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.