Andrew "Drew" Wynne

Current

Programmer Analyst at City of Bakersfield

Past

RPG Programmer PENSCO Trust at .
Senior Programmer Analyst at West Marine Products
Contract Computer Programmer at John Evans

Contract Computer Programmer at EA Software
Programming Manager at Pacific Coast Producers
Contract Computer Programmer at John Evans
Contract Computer Programmer at Partners Consulting
Software Engineer at System Software Associates
Programming Manager at The Great Information Factory (Sole Proprietorship)
Programmer Analyst at Rug Doctor
Programmer Analyst at Freymiller, Inc.
Programmer at Kaweah Delta District Hospital
US Marine 2542 at United States Marine Corps

see less...

10 more...

Education

Columbia School of Broadcasting
Amherst College
Whitefish Bay High School

Orono High School

see less...

1 more...

Recommended

5 people have recommended Andrew "Drew"

Connections

500+ connections

Industry

Information Technology and Services

Websites

Andrew "Drew" Wynne’s Summary

My goals:
• Long-term challenging analytical work in information technology.
• Help the City of Bakersfield meet IT goals.
• Increase my knowledge of Sungard HTE Naviline.
• Learning new technology to apply to increase efficiency, quality, and throughput.
• (Please DO NOT CONTACT ME ABOUT EMPLOYMENT OPPORTUNITIES as I am happy where I am long term. However, at times, I may have friends who are looking for opportunities. Thank you for your consideration.)

Experience in a nutshell:
• Over twenty years of experience as an RPG Applications Developer as a senior program analyst, contract programmer, staff consultant, programming manager, and software engineer.
• Eighteen years of experience on the IBM iSERIES (AS/400) platform and DB2 relational database
• Industries including agriculture, consulting, finance, fruit and nut processing, government, hospitals, manufacturing, retail, and transportation.
Goals:
Accepting LinkedIn invitations emailed to wynneinc (at) hotmail (dot) com.

Using the Google search http://www.google.com/coop/cse?cx=012022021532202637257%3An0e8vkkccdq created by Jason Bailes to find more LinkedIn groups.

www.LinkedIn.com luminaries are: Ron Bates, Bruce Berger, Alon Blankstein, Marjan Bolmeijer, Alan Baumbach, Steven Burda, Joe Compton. Ray van Den Bel, John L. Evans, Andrew ‘Flip' Filipowski, Richard Fong, Marc Freedman, Idan Gafni, Joe Gillespie, Chris Gould, Wei Guan, Steve Hoffman, Bill Howell, Bruce Kane, Jan Karel Klejin, Malcolm Lawrence, Adam Levy, Bill Lonon, Dennis Livings, Peter R. Luiks, Finn Majlergaard, Eric Mariacher, Christian Mayaud, Dan McLaughlin, John McLaughlin, Dave Mendoza, Pier Paola Mucelli, Jan Mulder, Octavio Pitaluga Neto, Ed Nusbaum, Barack Obama, Nils Oudejans, Russ Peterson, Thomas Power, Jay Rao, David Reed, Stan Relihan, Nelson Rosamilha, Shally Steckerl, Hugh Stewart, Scott Sullivan, Andy Waroma, Kenneth Warner Weinberg, Joe Weinsteiger, and Moshe Weiss.

Andrew "Drew" Wynne’s Specialties:

iSERIES (AS/400)
RPG Free
SQLRPGLE
RPG III
CLP
DSPF, PF, LF

Andrew "Drew" Wynne’s Experience

Programmer Analyst

City of Bakersfield

(Government Administration industry)

August 2008 — Present (1 year 4 months)

Support HTE Naviline.
RPG Programmer PENSCO Trust

.

(Privately Held; Financial Services industry)

2001 — August 2008 (7 years )

•Interviewed clients in A/R, A/P, asset management, client services, compliance, deposits, finance, internal control, marketing, new accounts, private placements, purchasing, real estate, and management to gather requirements.
•Implemented requirements and specifications by developing RPG free, SQLRPGLE, RPGLE, CL, DSPF, PRTF, PF, and LF source and objects on the iSERIES AS/400. Developed exports from iSERIES database to CSV and TXT extension files via IFS for Excel and to publish to the internet.
•Enhanced and maintained the DB2 database.
•Tested, deployed, and maintained software.
•Conducted company wide training on client lookup software.
•Entered, modified, and deleted user profiles.
•Authored and implemented business continuity plan and successfully conducted business continuity exercises.
•Submitted budgets for iSERIES hardware upgrades and oversaw vendor who performed upgrades.
•May 2006 and April 2005 IBM Technical Conferences.
•HTML, CSS, and Javascript classes.
Senior Programmer Analyst

West Marine Products

(Information Technology and Services industry)

1999 — 2000 (1 year )

• Interviewed clients in A/P, merchandising, replenishment, and other departments to gather requirements.
• Utilized Word and Excel to author requirements and specifications.
• Implemented requirements and specifications by developing and maintaining RPG IV, RPG 400, CL, DSPF, PRTF, PF, and LF source and objects on the iSERIES (AS/400) for custom software, E3, and JDA.
• Enhanced and maintained the DB2 database as needed by adding tables, removing tables, changing tables, adding indexes, and removing indexes. Increased field sizes where necessary.
• Tested software.
• Deployed and implement software.
• Maintained software as directed.
• Ran Y2K conversion over 1999 Labor Day Weekend without a hitch.
Contract Computer Programmer

John Evans

(Information Technology and Services industry)

1998 — 1999 (1 year )

• Analyzed, gathered requirements, developed, customized, maintained, tested, documented, and implemented changes to custom software and JD Edwards in RPG IV, RPG 400, and CL on an AS/400 in a retail manufacturing environment.
Contract Computer Programmer

EA Software

(Information Technology and Services industry)

1997 — 1998 (1 year )

• Upgraded MARCAM PRISM for Y2K for huge rural California fruit and nut producer on AS/400.
• Analyzed, programmed, and tested changes to Mortgage A/R system in RPG on AS/400. Perform analysis to use JAVA tool-box front-end to AS/400 PCCONNECT database for Mortgage A/R system. Change RPG/CLP middle-layers to accommodate JAVA. Help debug JAVA code.
• Designed, programmed, tested, documented, and implemented enhancements to prime brokerage system in RPG on AS/400.
Programming Manager

Pacific Coast Producers

(Privately Held; 1001-5000 employees; Food Production industry)

1996 — 1997 (1 year )

• Authored and implemented programming standards.
• Worked with and reviewed code of programmers as team lead.
• Gathered requirements, analyzed, designed, tested, and implemented changes to EDI, marketing, order entry, and other areas of fruit canning on three AS/400s using RPG400, RPG IV, and CL.
Contract Computer Programmer

John Evans

(Information Technology and Services industry)

1996 — 1996 (less than a year)

• Programmed, tested, and implemented changes to order entry system in a JDE RPG AS/400 setting.
Contract Computer Programmer

Partners Consulting

(Privately Held; 51-200 employees; Information Technology and Services industry)

1995 — 1996 (1 year )

• Created functional requirements, functional designs, data dictionaries, technical designs, file layouts, test cases, and programs to uncouple Disney Buena Vista Home Video transportation shipment pipeline systems, freight management systems, and RIM (retail inventory management) systems from ASI software and interface them to MARCAM PRISM customer service software on an AS/400 using RPG IV, CL, UIM and also working with BPCS and ASI.
Software Engineer

System Software Associates

(Public Company; 1001-5000 employees; SSAX; Computer Software industry)

1995 — 1995 (less than a year)

• Designed, programmed, tested, and implemented BPCS supply chain server programs to supply maintained on-line information using AS/SET and RPG400 on an AS/400.
Programming Manager
The Great Information Factory (Sole Proprietorship)

(Sole Proprietorship; 1-10 employees; Transportation/Trucking/Railroad industry)

1992 — 1995 (3 years )

Programming Manager initially coming in moonlighting during evenings as a contractor
• Redesigned and rewrote from RPG 36 and OCL 36 with internal files to native AS/400 CLP RPG 400 external database with pop-up windows and cursor sensitive help maintenance programs, menus, dispatch, accounting, payroll, personnel, and other systems.
• Upgraded software at client sites.
Programmer Analyst

Rug Doctor

(Privately Held; 201-500 employees; Consumer Goods industry)

1992 — 1993 (1 year )

Instituted UIM cursor sensitive help with hypertext and search capability, programmed cash and memo posting system and new store setup utilizing subfiles using mostly BPCS files with a few custom interfacing to installed BPCS modules on AS/400 using RPG 400 and CL.
Modified many BPCS programs
Programmer Analyst

Freymiller, Inc.

(Privately Held; 51-200 employees; Transportation/Trucking/Railroad industry)

1990 — 1992 (2 years )

• Interfaced Trendar fuel system on Motorola PC to AS/400 McCormick software, AS/400 SYNON software, and AS/400 Innovative software.
• Designed, authored, developed, and tested accounting modules in SYNON.
• Automated month-end.
• Maintained Halberstadt.
Programmer

Kaweah Delta District Hospital

(Government Agency; 501-1000 employees; Hospital & Health Care industry)

1989 — 1990 (1 year )

Modified RPG III and CL on an IBM System 38 for custom software on Baxter for medical and payroll applications
US Marine 2542

United States Marine Corps

(Government Agency; 10,001 or more employees; USMC; Military industry)

1983 — 1989 (6 years )

I served as a Marine in California, Hawaii, Japan, Philippines, South Korea, Virginia, and Washington D.C. with a top secret clearance.
My highlight was being awarded the Navy Commendation Medal for meritorious service from January 1986 to September 1987.

Andrew "Drew" Wynne’s Education

Columbia School of Broadcasting

Radio Broadcasting 1980 — 1981

Activities and Societies:

Federal Communications Commission Restricted Radiotelephone Operator Permit granted 3-6-81 FCC Form 753
Amherst College

B.A. , Economics and Political Science , 1974 — 1979

Activities and Societies:

Delta Upsilon, Glee Club, Rugby
Whitefish Bay High School

High School Diploma , College Preparatory , 1972 — 1974

Activities and Societies:

Wrote for the Tower Times Newspaper, Thespian, debate team, Latin Club, Deutscher Verein, before school math club including set theory and linear algebra
Orono High School

College Preparatory 1970 — 1972

Activities and Societies:

Choir, Cross Country, Debate Team, Musicals, National Honor Society, Track

Additional Information

Andrew "Drew" Wynne’s Websites:

Andrew "Drew" Wynne’s Interests:

Fun for me includes the blues, being a Buklod member, Chicago Bulls, Chicago Cubs, eating French vanilla ice cream, Iglesia ni Cristo, jazz, my children, my wife, networking, Oakland Raiders, Philippines, NFL drafts, R&B, running at my own pace, singing hymns, walking, web surfing, worshipping, and more. I enjoy being an About.com:Football moderator. I admire sacrifice such as http://sports.espn.go.com/espn/page2/story?page=schoenfield/080616