Sign in

Programmer, Consultant, AS400, ILE RPG

Mundelein, Illinois, United States
August 24, 2018

Contact this candidate


Stefan Haubrich

Home: 847-***-****

Cell: 847-***-****


A business oriented professional with years of hands on experience, on the AS/400 and Iseries (RPG, RPGIII, RPG IV, ILE, and FREE). CA-PRMS. Strong Analytical skills, Project management skills, excellent communication and motivational skills. Technical skills in communications, personal computers, design, application development, system migration, testing. Project management skills from conception through testing and implementation. Data Base Administration, QA compliance. Analyzes, defines, and documents requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks and controls, and outputs.

Analyze user requirements, procedures, and problems to automate or improve existing systems and review computer system capabilities, workflow, and scheduling limitations.

Write and maintains technical specifications that include File layouts, screen layouts, report layouts and program logic formulation. Assists with preparation of workflow charts and diagrams to specify in detail operations to be performed by the computer programs.

Writes documentation or reviews existing documentation that describes installation and operating procedures.

Provides technical assistance by responding to inquiries from business users regarding errors, problems, or questions.

User Acceptance Test planning and execution.

Perform timely Research for reported issues and / or requests for information.

Prepare Detailed Functional Test scripts.

End-user process support for 21 CFR Part 11 compliance.

Collaborate with Developers to ensure requirements and design are completely understood and testing efforts align with project deliverables and processes.

Perform Technical Peer Reviews.

Strong analysis and communication skills as well as business process re-engineering.

Ability to work closely with users to resolve issues, define requirements, identify and drive business process improvements.

PRMS ERP configuration to match business requirements.


Hardware: IBM Iseries/AS/400/530/B50/B45/B10, S/38/700, System 3/15D, IBM 3995 Optical Jukebox,

IBM and Bell + Howell Scanners, 5208 Protocol Converter.

Software: CA-PRMS, RPGII, RPGIII, RPGIV-ILE, CLP, CLLE, SQL, AS400 Query, RDI, DDL. Isphere, TAATOOL, DBU, HAWKEYE, DFU, SDA, APPC, OS/2, OS/400, DBU, APLUS, C++, ALDON, ROBOT, PowerBuilder, Excel, Word, Turnover, WordPerfect, Project, PowerPoint, Lotus Notes, Access, SQL, FTP, Documentum, Turnover, MDCMS, AGILE.


Information Technology 10/2017 to 3/2018

Application Maintenance and support custom in house ERP system based on iSeries (AS400).

Application customization of Vendor, Customer, AR, AP applications.

Team member in Cybersource upgrade.

Modified extensive custom applications.

Modified Discount programs for special sales.

Information Technology 10/2014 to 06/2017

Application Maintenance and support PRMS ERP application based on iSeries (AS400).

PRMS application customization of the IN, OB, PO, SF, AP modules.

Modified extensive custom applications.

Information Technology 4/2012 – 4/2014

Supported remaining in house written Legacy applications and develop data migration programs to push data to central location for long term data retention.

Convert data to user requirements.

Manufacturing IT 11/2011 to 03/2012

Worked with a team to develop, coordinate, and manage the data cleansing and data migration and delivery for the implementation of Legacy AS400 PRMS data to ERPLX for the following: Vendor Master, Open Purchase Orders, and Open Sales Orders.

Help with the maintenance and day to day requests for the AS400 PRMS system so employees could focus on ERPLX implementation and training.

Manufacturing/Pharmaceutical 1/2003 to 5/2009

Extensive and complete control of AS400 and Data Center.

Developed, coordinated, and managed the business and technical migration planning and delivery for the implementation of Legacy AS400 data to the SAP team for the following: Inventory, Customer Master, Vendor Master, Open Purchase Orders, Open Sales Orders, Accounts Receivable, Accounts Payable, General Ledger, Product Master, and Contract Master.

Help with the maintenance and day to day requests for the AS400 PRMS system so the employees could concentrate on SAP project.

Responsible for running the Medicaid reporting on the AS400 after SAP go live. Quarterly reporting the average manufacturing price and average selling price.

Design, test and implementation of a daily sales, data transferring system which provided data to an external sales automation vendor.

Responsible for day to day complete, Legacy system operations, software, maintenance support.

Responsible for, Documentum administrator responsibilities. Add, Change, Delete of Forms, Users, and Documents.

ADP HR Perspective Upload for employee compliance.

Disaster Recovery.

Manufacturing/Pharmaceutical 6/2000 to 3/2002

All phases of 21 CFR Part 11 Compliance training, documentation auditing.

Author, execute and review testing documentation: IQ, OQ, IOQ, PQ.

Review and update project documentation: Requirements and Design.

Research and create test case preconditions: test data, test users, system configurations.

Develop and maintain Requirement Trace Matrices (RTMs).

Author Reason for Change (RFC) documentation.

Verify change packages for completeness, adherence to change procedures, and validation standards

Manufacturing 5/1999 to 3/2000

IBM AS400 Document management

AS400 Disk Capacity Management

AS400 System Cleanup

Technical Projects Analyst

Manufacturing/Pharmaceutical 2/1998 to 5/1999

Responsible for all phase of Y2K upgrades to all PRMS software package modules.

Consulting Company 1997 to 1998

1+ years Developed, coordinated, and managed the business and technical migration planning and delivery for the implementation of an out sourcing solution utilizing IBM NWS Service Elements including Pre-Delivery Preparation, Help Desk, LAN & Server Administration, Asset Control, Software Support, Procurement Services, IMAC(Installs, Moves, Adds, Changes), Warranty Coordination, Hardware Maintenance, Training, Network Integration, Disaster Recovery.

Responsible for project plan comprised of data collection, technical infrastructure and process documentation on each assigned business unit.

Second Level Support Tower Lead for Operation Delight, a selective group of people chosen to improve Life Cycle Management At a large Real Estate Management Company.

International Pharmaceutical 1995 to 1997

2+ years as hands-on Project Leader in an IBM AS/400 and CA-PRMS V8.4 environment which included custom coding, implementation and support.

Major Projects:

Returned Goods Authorization and Daily Sales Applications Using PowerBuilder interfaced with AS/400 as the database.

Author of project documentation for validated and non-validated systems: requirements, specifications, plans, change control; test protocols for unit, system, and user acceptance testing; training materials; and traceability matrices.

Converted all Microfiche to Optical Imaging

Integrated CA/PRMS Purchase Order, Invoices, Contracts, packing Slips into Imaging.

Regulatory Affairs Imaging system using AS/400 and Novell 3.1x LAN

International Pharmaceutical Manufacturer 1993 to 1995

2+ years as hands-on Programmer Analyst and Sr. Programmer Analyst responsible for custom coding, implementing and supporting the following CA-PRMS RPGIII applications:

oCA-PRMS V8.4 Year 2000 Upgrades

oCA-PRMS V8.0 to V8.3 Upgrade

oAccounts Receivable

oAccounts Payable

oPurchasing and Receiving

oOrder Entry and Billing

oShop Floor Control


- AS/400 Application Programming - Pascal


- RPGII Programming/Advanced - Introduction to Novell 3.1x

- RPGIII Structured Programming - R:Base

- AS/400 Performance Tuning - Introduction to Networking

- AS/400 Fundamentals - Networking Technologies

- AS/400 Networking - Project Management/Advanced

- AS/400 Subfile/Advanced - Cost control, AP,AR,GLWO…

- PowerBuilder/Mastering Data Windows - Building Teams/Teamwork

- Business Management - PMI Project Management Institute

- Notre Dame High School Graduated

Contact this candidate