We provide IT Staff Augmentation Services!

Senior Programmer Analyst Resume

0/5 (Submit Your Rating)

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.

We'd love your feedback!