Programmer Analyst Resume
PA
Enterprising, hard-working and technically skilled iSeries RPG programmer known for accuracy, attention to detail and timeliness in developing and supporting various systems on the AS400. 15 years of experience in pharmaceutical industry and working toward certification in Oracle. Expert in the technical, conceptual and content development for AS400 with RPGIV, RPGIII, RPGFREE and SQL. Proven ability to create and document within standards and practices set forth by industry and federal guidelines.
Key Skills
- iSeries AS400 programming skills developer
- SQL embedded interactive
- RPGIV RPG Free RPGIII RPGILE
- Stored Procedures Subfile sorting
- Microsoft Office products
- Hawkeye DBU FTP SYNON CL
- ETL ACCESS EXCEL EDI
- iSeries DB2 conversions Databases
- System Design Best Practices Kronos
- Legacy application programming
Professional Experience
Confidential, Pa Budgeting and Forecasting Support 08/10 to Present Supporting a Web based Forecasting and Budgeting System built over an Oracle Database for a Fortune 100 Pharmaceutical client company using the Toad 9.5 utility for the Maintenance of PL/SQL Procedures and Tables
Confidential. sKILLMAN, NJ Programmer Analyst 10/96 to 06/10 Key Results: Developed and maintained a sales accounting system on the iSeries AS400; addressed escalated issues from employees and managers regarding sales and accounting systems; expertise in developing working software applications from complex business requirements; managed the accurate and timely processing of pharmaceutical sales data sent electronically from a nationwide network of pharmacies and hospitals; created interface programs and ad hoc reports for Kronos; recommended and implemented ETL Utilities to facilitate the sales force compensation including creation of DDS for iSeries files; worked with IBM India to reformat data for input to SAP/BW Accounting Process files; implemented the use of RPGIV and taught co-workers key programming skills using updated techniques
Confidential Skillman, NJ Programmer Analyst 01/94 to 10/96 Key Results: Originally hired as a contract programmer through CG Computer Services then hired by BMS in 1994; supported a Cost Accounting System using both SYNON and RPG; modified BPCS programs for the Bristol-Myers-Squibb manufacturing system; implemented an inter-network information transfer system using CL and RPGIV that extracted data from multiple As400; TCP/IP and VAX computer transfers; incorporated use of SDA, RLU, and subfile display/selection techniques when writing CLP and RPGIV programs