SUMMARY:

• RPG Programmer/Analyst on the IBM i5, iSeries, AS/400
• 20+ years experience supporting the AS/400 with RPG development, testing, maintenance, software installations, upgrades, user support, operations, systems management and administration.
• Excellent analytical and problem solving skills.
• Excellent interpersonal and communication skills.
• Enjoy working with users of all levels to address challenges and solve issues.
• Very much interested in learning new ERP packages, methodologies, programming languages, tools, and operating systems.

TECHNICAL SKILLS:

Languages/Tools: RPG/400, RPG III, RPG IV, RPGLE, RPG FREE, CL, SQL, DDS, SEU, PDM, SDA, Query, SEQUEL, EZVIEW, HPQC, APLUS

Application: Infor Infinium, Infor (Pansophic) PRMS, IDS, IBS Bookmaster

Platform: IBM i5, iSeries, AS/400

Domain: Manufacturing/Distribution, Healthcare, and Hospitality.

PROFESSIONAL EXPERIENCE:

Confidential

iSeries RPG Programmer/Analyst

Responsibilities:

• RPG and CL Programming to support conversion of pricing data from iSeries ERP package Pansophic PRMS to SAP.
• New development to support conversion efforts and maintenance to existing legacy programs/systems.
• Conversion programming for Pricing/Allowances/Discounts from iSeries to SAP.
• Worked on interface to pump data from foreign country ERP system into SQL server and iSeries databases. This was to allow for Sales Analysis, Forecasting, and Trending information to be utilized until the foreign plants are ready to be converted to SAP.
• Worked in Agile type environment through multiple iterations/mock conversions leading to go - live.
• Researched and resolved defects as relates to data conversion efforts.
• Acquired new skills including: SEQUEL, EZVIEW, APLUS, and HPQC.

Confidential, Charlotte, NC

iSeries (AS/400) RPG Programmer/Analyst

Responsibilities:

• RPG and CL Programming to support Infinium ERP package - mainly PE/PY/PL.
• Fixed program bugs causing out-of-balance conditions caused by customized Infinium PL (Payables Ledger) batch processing programs.
• Did a source compare on all custom programs for Infinium PL, and added all vendor supplied release changes/fixes/enhancements that were found to be missing.
• Unit tested all programs that I changed and worked with the users to ensure they understood the exact steps required to test the specific changes that I made.
• Created a project for Fleet Maintenance Cost reporting to replace a current process where users had to manually change and run many queries. This project included a prompt screen and was built using CL/RPGLE/SQLRPGLE programs.
• Worked on project for sending benefit enrollment data to vendor. This included setting up Infinium HR (PE) for HIPAA 834 document transmission to vendors. Created IFS folders with authorization list security and CL program to send extracted enrollment data to the IFS and created new date/time stamp named archive folders for each run.
• Worked on ad-hoc research, analysis, debugging, and reporting as production issues arose.
• Fixed NACHA /ACH direct deposit programs to send “unbalanced” file as required by bank.
• Completed analysis of hard-coding issues in PL and HR/Payroll development environment.

Confidential, Emeryville, CA

iSeries (AS/400) DBA/Programmer/Analyst/Operator/Administrator

Responsibilities:

• RPG Programmer/Analyst/Administrator/Operator supporting publishing Confidential .
• Programs written to extract data for users to help with sales analysis, trending, forecasting and budgeting.
• Worked on updating item master and related programs and files to move our product from one external printer/warehouse to another.
• Created RPG and CL programs to extract all IBS Bookmaster ERP system data for import into new cloud-based (non-AS/400) system.
• I am the sole AS/400 technical resource at this Confidential .
• Monitor and help administer non-iSeries systems such as Microsoft Servers for Cognos, SQL servers, Microsoft Exchange, and Active Directory.
• Perform desktop support and assist users with day-to-day I.T. issues.
• Install ERP patches, tax table updates and IBM iSeries PTFs, and debug and fix program and data issues.

Confidential, Englewood, CO

iSeries Programmer/Analyst

Responsibilities:

• Wrote RPG and CL programs to specifications in the implementation of a cash card system.
• Prepared test data and ran quality assurance testing on my own and other developers code.

Confidential, Durham, NC

IBM AS/400 Operator

Responsibilities:

• Worked as an iSeries System Operator supporting IBM customer systems throughout the world.
• Monitored iSeries systems for errors and successful job completion.
• Monitored backups and end of day processing, checked on health of mirroring, moved tape drive between LPARs for backups, checked joblogs for any issues and created tickets and worked with system engineers on any production problems.
• Some of the systems that I monitored included CRP, Godiva Chocolates, Pearson Publishing, Macy’s, Banco, Altria, and many others.

Confidential, St. Petersburg, FL

Senior Systems Analyst (IBM iSeries / AS/400 RPG Programmer)

Responsibilities:

• Responsible for all RPG Programming and analysis for all corporate financial applications and interfaces.
• Supported Infinium H/R, Payroll, Employee Self Service, Fixed Assets, General Ledger, and Application Manager
• Responsible for all interfaces.
• Planned and implemented all Infinium software release installations.
• Supported First Advantage Applicant Tracking interface for recruiting, on-boarding, and hiring interface to AS/400 DB2 data.
• Created files and programs to automate upload of external salary and review database data into Infinium as PE transactions which prevented the need to key over 7,000 transactions each year.

Environment: INFINIUM H/R, Payroll, AM, GL, FA, SS

Confidential, New York, NY

Senior Applications Developer (RPG Programmer/Analyst)

Responsibilities:

• Provided analysis, RPG IV / RPGLE programming, production support, enhancements, process modifications and automation.
• Supported Infinium H/R and Payroll.
• Developed and maintained RPG and CL programs.

Environment: INFINIUM H/R, Payroll

Confidential, Pompano Beach, FL

Senior Programmer/Analyst/Administrator/Director of I.T. (IBM AS/400)

Responsibilities:

• Provided enhancements and maintenance of RPG IV and CL programs to support IDS Product Distribution ERP package for a Produce distribution Confidential .
• Created custom programs, files, reports, and queries for data analysis, reporting, and historical analysis.
• Created upload and download processes using shared files to be maintained by many employees, and then integrated the data into existing programs for better reporting.
• Created programs, files, queries to automate real-time validation for monthly physical inventory process.
• Maintained i5 (iSeries, AS/400), LAN, WAN, Email, Fax server, and Online Ordering system and related interfaces.
• Responsible for phone system, and connections some of which were using VOIP.
• Assisted in setup of I.T. infrastructure to support new office and operations in Puerto Rico to include T1, VOIP phone system with paging, PCs, and printers.
• Managed Biometric and Digital Video Security Systems to include maintaining employee access control upon hire and the automatic restriction of access upon termination.
• Responsible for all i5 backups, restores, operations and administration to include acquiring PTF acquisition, load and apply.

Environment: IDS Order Entry and Billing, Inventory, Financials, Online Ordering

Confidential, Hollywood, FL

IBM AS/400 Systems Manager -- RPG Programmer/Administrator

Responsibilities:

• RPG IV and CL programming - Planned, installed tested, customized, and maintained Infinium applications: HR, Payroll, AP, GL and FA.
• Built several interfaces to handle data to/from Infinium and bank applications which included Recon, Positive Pay, and Check Printing with graphical executive signatures.
• Responsible for all AS/400 issues related to Application, hardware, software, connectivity, QUERY/400 report creation, uploads, downloads, database design and creation, interfaces, user support, application administration, and AS/400 operations.
• Migrated from one IBM AS/400 to a new larger IBM AS/ 9406 for a new Confidential, country club, and spa. This was a $1.7 million budgeted conversion.
• Administered servers and software exchanging data with the AS/400. Products included Websphere, Kronos, Showcase, Timeline (SQL), and SkillSet (Domino).
• Automated processing functions via queries, uploads/downloads, CL programming, and OS/400 Job Scheduler.
• Designed and implemented laser check printing for Accounts Payable and Payroll. Used ACOM Solutions EZ/Print 400 software and Xerox printers. Automated and administered check-merge process with security controls for printing and external signature graphic.
• Created and maintained AS/400 subsystems, job queues, user profiles, job descriptions, device configurations, communications, as well as application and object security.
• Automated backups to disk and tape with CL and Job Scheduler for Disaster & Recovery.
• Maintained all AS/400-related hardware, software and security.
• Provided 24/7 support for all AS/400 users.

Environment: INFINIUM H/R, Payroll, AM, AP, GL, FA

Confidential, West, San Francisco, CA

Senior Applications Programmer/Analyst (RPG Programmer)

Responsibilities:

• RPG programming support for Infinium H/R and Payroll modules for 10 hospitals.
• Programming included work on new development, maintenance, release installs, debugging, and interfaces.
• Helped consolidate seven servers onto two AS/400 boxes.
• Responsible for implementing all Infinium release installations.
• Customized and maintained batch FTP interface from Infinium Payroll data to NT-based G/L system (ESI/Titan).
• Developed a process for export and import of open enrollment benefit data from third party vendor using ODBC, FTP, TCP/IP, Excel, Microsoft Query, RPG, and CL
• Developed custom forms and checks using Optio Software in order to reduce pre-printed forms cost.
• System Administrator for AS/400, OS/400, Infinium HR and Payroll, Client Access, and all security related to the AS/400 payroll box. Created subsystems, workstation entries, job queues, job descriptions, menus, device configurations, installed printers, updated Client Access, and configured user’s PCs for ODBC data transfers between Excel and the AS/400.

Environment: INFINIUM H/R, Payroll, AM, AP, GL, FA

Confidential, Gallaway, Tennessee

RPG Programmer/Analyst/Operator

Responsibilities:

• Developed and maintained Computer Associates PRMS Manufacturing and Distribution software using RPG III, RPG 400 and CL.
• Developed and maintained programs for the following modules: Order Entry/Billing, Invoicing, Forecasting, Contract Pricing, Sales Reports, Volume/Price/Cost analysis, Shop Floor, Product Structure, Premenos EDI, Purchasing, Inventory, A/P, G/L, HR and Payroll.
• Customized Order Entry & Billing programs for specialized pricing and discounts.
• Created RPG/400 programs to replace AS/400 queries.
• Designed a monthly Sales Variance Reporting System which helped to identify trends based on the affect of current pricing, sales volume, and cost versus the proposed forecast levels and margins.
• Created an Interactive Rebate Processing System which gave the user the ability to selectively combine Contracts, Bids, Proposals, and Sales data to approve or deny a rebate claim. The system substantially reduced manual processing time involved with Credit and Chargeback processing.
• Responsible for all operational functions to include daily, nightly, weekly, monthly, quarterly, and year-end processing, OS/400 updates, PTFs, release installs, backup and recovery, offsite storage, Client Access updates, printers, terminals, PCs, cabling, connectivity, and user support.
• Created subsystems and maintained in-house custom job scheduling as needed to separate and maintain job flow.
• Maintained OS/400 security, tape rotation, and disaster recovery plan.

Environment: CA-PRMS (now Infor) Order Entry & Billing, Inventory, Contract Pricing, Bids/Proposals, Sales/Volume/Pricing/Margin analysis.