Senior Programmer Analyst Resume

Experience Summary

Twenty eight (28) years of professional experience, including fifteen (15) years of IT and thirteen (13) years of Accounting and Finance experience.
Has performed as a Sr. Programmer Analyst to develop, enhance, and maintain applications.
Provides application expertise in large Payroll, Work Order, and other Financial Systems.
Participated on major Development Projects following the EDS System Life Cycle and the Chrysler Quality Gate process, including Gathering and Analyzing Requirements, preparing Business and Technical Designs, Creating Advanced Computer Programs, Testing, Implementing and Documenting the changes.
Provides technical expertise in COBOL, PL/1, JCL, DB2, IMS, Dialog Manager, Easytrieve, PeopleSoft SQR’s, SPUFI, SQL, CA-7/11, CHAMP, Endevor, and Xpediter and has used UNIX, Oracle, PeopleSoft, PGP, FTP, EBMX, PVCS, VSAM, CNTL-M/R.
Demonstrates excellent written and verbal communication skills.

Work Experience

July 2003 – Aug 2008 Confidential,Rochester Hills, MI
Senior Programmer Analyst

Participated on major 3 year Payroll development project that converted multiple Chrysler payrolls from a COBOL 3270 Mainframe file based system to a PeopleSoft DB2 table based system as a key member of the Conversion, Parallel Testing, Master File Replacement and Payroll Transfer teams.
Analyzed, modeled and created DB2 Master File Replacement and W4 Tax profile tables.
Analyzed, designed, coded, tested, documented and implemented multiple jobs and programs using both Mainframe and PeopleSoft technologies including initial and ongoing table loads.
Created SQL queries to aid the customer in testing production changes.
Provided maintenance support by addressing Payroll, SUB and S&A abends and created required SOX documentation for all production changes promoted over the past 2 years.
Languages, Skills and Tools Used: PeopleSoft SQR’s, COBOL II, Enterprise COBOL, DB2, IMS Checkpoint and Easytrieve programs, JCL/PROCS and Parms, Xpediter, SPUFI, WinSCP, WS-FTP, WINSQL, IBM DB2 Command Center, UltraEdit, and CA-7/11.

Sep. 2002 – July 2003 Confidential,Troy, MI
Technical Consultant – Confidential,

Coded SQL table joins for Marketing campaigns using an Oracle8i DataMart and executed queries using Toad and UNIX. Encrypted and transmitted data to appropriate marketing vendors using PGP and WS-FTP.
Documented campaign procedures and requirements, and created analysis, business and technical design documents and user test plans.
Led 2 individuals on a 3 month project that produced new Cognos Impromptu Customer Exception Reports, Oracle SQL and Excel software. All deliverables were on time.

Jan. 1985 – Apr. 2002 Confidential,Warren, Troy & Southfield, MI
Jul. 2001 – Apr. 2002
Information Analyst/Programmer – Confidential,

Created and modified COBOL II programs, JCL and WAAPDSUT’s for medium and minor enhancement projects, created detailed business requirements, business design and technical design documents and conducted code walkthrough’s using QMS and CMM SSP processes.
Submitted and monitored weekly, monthly and quarterly jobs using CA-7/11.
Created process documentation, updated MS-Excel spreadsheets and MS-Word documents.

Feb. 2000 – Jun. 2001
Information Analyst/Test Specialist – Confidential,

Executed weekly functional and regression test plans for multiple environments and documented detailed defect results using Test Director and Clear Case.
Administered ID’s for the GM E2 Client/Server system that included updating Oracle8i tables, LDAP and DCE using UNIX scripts, Toad, Exceed and Policy Director.
Investigated and resolved trouble tickets initiated via the Vantive Help Desk, created and updated the Knowledge Base and performed on-call duties ensuring 24x7 system availability.

Sept. 1993 – Feb. 2000

Information Analyst/Programmer – Confidential,Analyzed requirements, designed, coded, tested and implemented changes on several major enhancement projects for the GM EWO System. The projects restructured the entire system and involved adding, changing and deleting DB2 tables, modifying IMS screens and IMS batch jobs, and eliminating, changing and consolidating JCL jobs. I also created numerous new PL/1 DB2 programs and JCL jobs to process on-line print requests and convert table data.
Provided production support as the Subject Matter Expert for the Engineering Work Order and Engineering Budget System’s on an IBM MVS OS 390 platform using PL/I, DB2, COBOL, IMS (batch and online), Dialog Manager, JCL, SPUFI, SQL, TSO, CA-Endevor and CA-7/11.
Performed troubleshooter and on-call duties for the GM GPDS System which had over 20,000 on-line users and hundreds of nightly batch jobs.
Participated on initiatives including the GPDS and EOPTS Y2K projects, the Cntl-M to CA-7 Conversion project and followed processes implemented to achieve SEI CMM Level 3 status.
Investigated and resolved customer trouble tickets initiated through the Vantive Help Desk.

Jan. 1985 – Sept. 1993
Business Analyst/Marketing Cost Analyst/Financial Analyst/Accountant

Created and improved internal measurement processes, created and maintained cost models, facilitated and presented monthly business results to the SSU President and his direct staff, and assisted the financial organization with special research projects.
Prepared, analyzed and consolidated monthly outlooks, annual budgets and monthly general ledger transactions, calculated and updated internal billing rates, audited 100% of the general ledger transactions for the Communications Services Division spanning a 4 year time frame, and audited and approved vendor invoices for payment.
Initiated the implementation of new JV and accrual processes and procedures.

May 1980 – May 1984 Confidential, Ellsworth AFB, SD
Disbursement Accounting Specialist

Reconciled daily transaction balance sheets, audited vouchers, and travel reimbursement claims, monitored and certified account fund availability, prepared government reports, interpreted regulations and updated manuals.
Received Airman of the Month and Comptroller Airman of the Quarter awards.

Education