Post Job Free

Resume

Sign in

Rpg Iseries

Location:
Brea, CA
Posted:
June 14, 2021

Contact this candidate

Resume:

Chris Arias

adm4w8@r.postjobfree.com

Academic Background

Bachelor of Science in Business degree

California State University, Los Angeles

Business Administration - Major

Business Information Systems - Emphasis

Technical Summary

RPGIV, RPGILE, RPG FREE RPGILE, CL, Embedded SQL, Sub Procedures, Data Base Triggers, Premenos EDI400, Turnover, Aldon, Quest-View, Hawkeye, HTML, VB.NET, ASP.NET, SQL, AS400 Spool Flex.

Certifications

ASP.NET and Microsoft Visual Studio -- Microsoft Certificate

AS/400 RPG IV Developer -- IBM Certified Specialist

HTML CSS JavaScript SQL XML -- Cal State Poly Certificate

CIS Professional Certificate in SQL – Mt. San Antonio College

Java Courses – Mt. San Antonio College

Employment History

Arrowhead Products: Los Alamitos, CA 7/8/2019 - 1/21/2020

AS400/iSeries RPGLE/Programmer Contractor

Enhance BPCS System using iSeries RPGLE, SQL

Performed BPCS maintenance on existing ERP reports, screens and files.

Converted AS400 reports to Excel Spreadsheets using Spool Flex.

Created Trigger programs to capture updates to the Sales Order Register.

Maintained Time, Attendance and Labor collection applications.

Trained end users to use new and modified programs.

Worked with Robot Scheduler to coordinate night batch programs.

Promoted changes and new code into production.

ISGN: Software solutions for Mortgage life Cycle, Brea, CA 3/1/2016 – 1/24/17

AS400/iSeries RPGLE/SQL Programmer Permanent Remote

Enhance Private Mortgage Insurance System using iSeries SQL

Created Audit reports and downloads files.

Maintenance programming for the PMI Termination Dates system.

Enhanced PMI Eligibility dates.

Created PMI Termination Vendor File request system.

Enhanced PMI Plan assignment programs

Enhanced IRS – 1099 M Reports

Work with Change management team to promote programs with Turnover

United Health Care, Santa Ana CA 6/22/2015-3/1/2016

AS400/iSeries RPGLE/SQL Programmer Permanent

Enhance Health Care System using iSeries SQL

Maintained and enhance a Low Cost Alternate Proxy Drug system.

Created Maximum Out Of Pocket system.

Ventura Foods, Brea CA 3/5/2014 - 4/1/2015

AS400/iSeries QA/Programmer Contractor

Maintenance programming and testing on the Iseries

Test JDE conversion; Sales Order Entry, TMS (Manhattan Transportation Management System), Bill of Lading and Invoicing.

Update legacy programs using RPGLE and SQL.

Work on Production Support Tickets for the Legacy system.

Work with QA and prepared low-level design documentation with program objects, files, flow charts and test scripts.

Universal Studios, Universal City CA 8/5/2013 – 1/20/2014

AS400/iSeries Programmer Contractor

Maintain Fix Asset using Infinium iSeries RPGLE.

Maintenance of the Infinium Fix Asset system involving Asset Maintenance, Period End processing, and Application Setup.

Gathered business requirements from the users for enhancing or creating new programs.

Prepared low-level design documentation with program objects, files, and flow charts.

Develop test case and, scripts for testing integration, UAT, QA and performing implementations.

Assist in verifying post-implementation with users.

Daily production application and on-call support.

Work with Offshore team in India with coordinating new requirements and programs.

Bank of America, Simi Valley CA 8/15/2011 – 4/15/2013

AS400/iSeries Programmer Contractor

Enhance Mortgage Banking System using iSeries SQL.

Maintenance programming for the Freddie Mac Default reporting system-using SQL free.

Analysis and design as well as requirements gathering

Prepared low-level design documentation; coding and hard testing integration, UAT, QA and performing implementations

Work with Change management team to promote programs with Turnover

Assist in post-implementation support

On-call support

Avery Dennison/Hewlett Packard, Brea CA 1/10/2011 – 6/1/2011

AS400 Programmer Contractor

Enhance Warehouse system using RPGLE, RPG Free, CLP, and SQL.

Maintenance programming for the Purchase Order and Warehouse systems.

Modified purchase order screens

Maintained New Vendor pricing system

Modified EDI reports and mapping fields for KMART and STAPLES.

Perot/Dell Systems, Anaheim, CA 11/2008 – 01/07/2011

AS400 Senior Programmer Permanent

Enhance financial system using RPGLE, RPG Free, SQLRPGLE, CLP, Sub Procedures, and Data Base Triggers.

Maintenance programming for the ACE Tenet Patient Financial system

Updated Account Search, Payment and adjustments and billing screens Fixes to Appeal address letters and tables

Maintain Collection Summary, Patient Information and Guarantor information programs

Worked on Account Transaction posting programs

AAA Insurance, Irvine, CA 11/2005 – 7/2008

AS400 Senior Programmer Permanent

Enhance custom Insurance System using RPGLE, SQLRPGLE, RPG Free, CLP, Sub Procedures, Microsoft Net Data.

Developed and maintained web pages displaying Policy information using Net. Data, AS400 RPGLE and CLP.

Developed a Credit Order system using RPGLE, SQLRPGLE and FTP. These programs would send policy information and receive policy credit scores from a credential verification servicing company. User can also modify and track data from the servicing company.

Developed Motor Vehicle Comprehensive loss reports via FTP using Image files. These reports would be e-mailed to the Underwriting Department.

Developed Receiving Rejection Reports from ChoicePoint (a servicing company) on the AS400 IFS. These reports would be e-mailed to the Underwriting Department.

Added new States selling Insurance to the AS400 Insurance system.

Maintained the Policy Administration maintenance programs.

Maintained the Claims System management maintenance programs.

Countrywide Funding, Simi Valley, CA 8/2000 – 8/2005

AS400 Senior Programmer Permanent

Enhance custom Tax System using RPGLE, CLP, RPGLE Sub Procedures, RPG Free, Embedded SQL, VB.NET, ASP.NET, Microsoft SQL 2000 and Premenos EDI.

Created and maintained new AS400 Escrow Due Date Exception Processing systems.

Created and maintained new AS400 Tax Due Date Exception Processing systems.

Project lead for projects that involved Exception processing.

Added new Insurance Carriers to Invoice and Payment EDI PREMENOS systems.

Maintained Tax Setup Exception Process Intranet system using VB.Net and ASP.NET.

Maintained existing AS400 Tax Payment processing systems.

Setup and Mapped 811 Inbound invoices from Insurance Carriers

Catholic Health Care West, Pasadena, CA 4/1999 – 4/2000

AS400 Senior Programmer Contractor

Enhance INFINIUM HR Software using RPG, RPGLE, CLP

Created and Enhance inquiries custom programs and reports.

Converted uploading and downloading to Watts and Wyatt Benefits.

Countrywide Finding, Pasadena, CA 10/1998 – 3/1999

AS400 Senior Programmer Contractor

Upgrade AS400 INFINIUM Software using RPGIII, RPGIV, CLP

Assisted in A.P. Module to P.L. Module conversion.

Converted uploading and downloading custom programs and files.

Created and enhanced inquires custom programs and reports.

STROUDS, City of Industry, California 8/1992 – 10/1998

AS400 Lead Programmer Analyst Permanent

Enhance JDA Retail Merchandising System including Distribution Center Operations, Purchase Orders, Transfers, Merchandise Receiving, UPC, Polling, E.D.I. on IBM OS400 using RPGIII, RPGIV, RPGILE, CL, Hawkeye, DBU, Premenos EDI400.

Functioning as the programmer in charge of handling the receiving and shipping of merchandise for the Warehouse and Cross-docks. This also involves creating Purchase Order receiving numbers, P.O. tracking, printing tickets, detail entering received Skus and Truck Manifest maintenance.

Maintained and developed EDI for sending Purchase Orders and receiving Warehouse Advanced Shipped Notices which allows for Cross-docks to scan in merchandise directly from vendors.

Automated the previously manual system. Coordinated with users in designing, developing and implementing programs to collect daily polling transfers between stores. This includes transfer inquiries, aging reports and posting to inventory.

Automate a tracking system of merchandise from vendor to Warehouse or between stores. This system post to the stores inventory when the goods are shipped.

Developed a Promotional System and a Liquidation System for new prices.

Maintained and enhanced Permanent Price Management and U.P.C. systems.



Contact this candidate