Senior Programmer Analyst Resume
Oakbrook, IllinoiS
OBJECTIVE:
- Provide business solutions through structured system design and development.
TECHNICAL SKILLS:
Technology and Tools: Oracle EBS (Payables/GL) for 6 years. Oracle SQL/PL SQL for 3 years. VB6/VB.Net for 3 years. C++ for 3 years. MQ Series for 5 years. CICS (V7)for 5 years. DB2 (V7) for 10 years. IMS (V9) for 15 years. PL/I for 20 years. COBOL z/OS (V3)for 20 years. Project Management for 10 years. Resume last modified: 7/ AM
PROFESSIONAL EXPERIENCE:
Confidential, Oakbrook, Illinois
Senior Programmer Analyst
Responsibilities:- Performed a Quality Assurance role for the OBIEE implementation and became the only dedicated resource to do ETL data validation testing; duties included developing SQL test scripts, detailed test plans, and documenting test results for audit purposes.
- Provided migration support to move Accounts Payable and General Ledger to the Oracle EBS.
- Participated in Oracle EBS programs and received Oracle s in Payables, iExpense, and General Ledger modules.
- Developed and led an Oracle SQL/PL SQL in - house classes to prepare for the legacy to Oracle transition.
- Cost saving measures (>$300K annually): retired the legacy Accounts Payable System, re-engineered the Accounts Payable Oracle to legacy interface for efficiency, and took a lead role in a project to retire two obsolete General Ledger financial reporting systems.
Confidential, Warrenville, Illinois
Senior Systems Analyst/Consultant
Responsibilities:
- Developed complex DB2 stored procedures to select data to be loaded daily into Hyperion/Essbase for the more comprehensive statistical reporting via Hyperion.
- Provided very detailed technical specifications to offshore team for them to develop the real-time web-based reporting of the same.
- This project was very successful and received recognition from the sales management team and the CIO.
Confidential, Rochester, New York
Senior Systems Business Analyst
Responsibilities:
- Base-lined the VB6 system using already-developed core components and implementing new components to provide label stock verification functionality.
- Modified the MS Windows GUI interface according to client specifications.
- Included the creation of multiple MS SQL Server databases and supporting Visual Basic applications, developing the SAP Order Update Application in VB.Net.
- Published an ActiveX COM component used by a Labeling Application Interface to fully automate product labeling in two work centers.
- Developed many new modules to support GLS automation.
- Met objective by eliminating mislabeled and unidentified products, therefore, increasing productivity and improving customer satisfaction.
- Participated heavily in the design and analysis stages of the project; developed technical specifications and test plans; provided all the technical aspects from software engineering and testing to implementation.
- Developed new IMS/PL1 online and batch programs to transmit real-time updates of paper and film wide roll quality data from the legacy paper coating/ film sensitizing Record Block System into SAP R3 finishing.
- Developed new IMS and DB2 supporting applications to update new tables online:
- Involved adding/updating numerous IMS and DB2 database tables, segments, transactions, and programs.
- Resulted in cost reductions by retiring legacy finishing system, Common Converting, and of many functions within the Record Block system.
- Contributed to increased productivity due to standardization of data and systems globally.
Confidential, Rochester, New York
Senior Systems Analyst/Consultant
Responsibilities:
- Developed new IMS/PL1 online and batch programs to receipt in and call out Kodak Manufacturing supplies from an outside warehousing firm.
- Developed and implemented an online message processing process for requesting supplies and a batch message processing process for weekly receipt reporting.
- This work effort contributed to the elimination of many Kodak positions, significantly reducing labor costs.
Confidential, Rochester, New York
Senior Software Engineer/Consultant
Responsibilities:
- Provided the initial scope analysis to identify all necessary system changes.
- Expanded date keys and search arguments for 13 inter-related IMS DB/DC databases used by core systems, the Material Logistics System and the Inter-Plant Ordering System.
- Analyzed, tested and installed two major production releases, without incident, as part of this effort.
- This effort was very successful and received high rewards from both the EDS and Xerox management teams.Provided technical leadership to remediate the Supplier /Forecast systems:
- Tested year-end calendar changes and re-analyzed Stores Balance, Work in Process Control, Material Replenishment, and Final Line Accounting Systems to determine the exact date of impact.
- Accepted the sole responsibility to remediate the Work in Process Control System.
- Provided all the technical work surrounding compliance testing of the changed core systems using HourGlass2000.
- Ultimately, it proved to be a milestone of success in Year 2000 and Confidential .
Confidential
Senior Systems Analyst/Consultant
Responsibilities:
- Completed over 70 backlogged requests for work in the system.
- Provided technical leadership on a project to send CESD real-time updates of Product Master Data using MQ Series.
- Downloaded Reuters new foreign exchange rates from the Internet and added them into Kodak's International Pricing System.
- Provided daily support for IMS DB/DC Worker's Compensation System and Customer Master Data System.
- Contributed to departmental recognition for running at 100% efficiency.
Confidential
Senior Software Engineer/Consultant
Responsibilities:
- Part of a team to develop new systems to support the deregulation of the telephone industry.
- Modified the existing production systems to accommodate wholesale, as well as retail billing.
- Contributed to the creation of a new wholesale bill format and to the reporting of wholesale revenue in Open Market Plan Phase I.
- Participated in recognition day to celebrate the successful completion of this effort.
- Wrote, tested, and installed a PSC mandated project to determine and notify customers of eligibility for Lifeline discounts.
- Provided maintenance support to COBOLII/CICS on-line Care and Mini Order Systems.
- Implemented projects to report aging of accounts and to housekeep new VSAM files.
Confidential, Rochester, New York
Senior Systems Analyst/Consultant
Responsibilities:
- Worked on various IDMS DB/DC projects using COBOL in an IBM MVS/ESA environment.
- Provided specifications and changes to allow for the sale of student loan portfolios and for multiple disbursements of PLUS loans.
- Automated USAF pre-claim reporting according to USAF specifications.
Confidential, Rochester, New York
Senior Analyst/Consultant
Responsibilities:
- Successfully implemented a VSAM PL/1/CICS project for updating the BIS/CPP price matrix real-time.
- Responsible for keeping all systems running while leading the conversion testing and turnover of 250 production jobs to IBM JCL and OPCA scheduler.
- Created new jobs that automated reporting of promotional rebates.
- Responsible analyst for all technical support of a VSAM COBOL/CICS Travel Master System.
- Led a highly visible project to allow for direct deposits to ES&L for travel reimbursements.
- Installed major releases to the Covia Travel Master package seamlessly; developed new system interface for AMEX Payment Reporting.
