Senior Analyst/Programmer with 39+ Years Experience

Orlando M. Delgado. B.S. Computer Science, MBA

San Bernardino, CA 92407. 818-***-****

**********@*****.***

Summary:

Senior Analyst/Programmer with over 39 years of professional experience using COBOL, RPG, Assembler, DB2, CICS and SQL Servers, Aldon CMS, IBM tools, Microsoft tools.

Experienced in Mainframe, midrange, servers and networking in on-line and batch environments during all phases of the SDLC and Agile methodologies, Hardware infrastructure configuration, and management.

Education & Certifications:

BS Computer Science, Sep 1990 National University of San Marcos.

MBA, May 1997 National University of San Marcos.

GED High School Equivalent Certificate, Apr 2001 West Valley Occupational Center CA.

IBM Certified Specialist, AS/400 Programmer.

Professional Experience:

4D ADVTECH Inc.

Química Suiza SAC. (Programmer Analyst), Lima Peru (Remote) Jun 2021 to Date

Led “Sales Statistics System” project, interactive module created to improve the sales management.

Developed and implemented a “Pharmaceutical Control Information” system.

Using JCL, RPG all levels, COBOL/400, SQL/400, DB2, ROBOT, RDi, QM query, SEQUEL/ iSeries. Agile methodology using Jira and Confluence.

Openlogix, Corporation.

(Senior Programmer Analyst) Suzuki Motor America, Brea CA (Remote) Aug 2018 to May 2021

Provide development, enhancement and maintenance in different projects for Dealer’s SALES ORDERS System.

Using DB2, SQL400, and Stored Procedures, COBOL/400, CL, iSeries Navigator, WebSphere. Agile methodology using Jira, Confluence, iSeries.

Support in UAT environment and production environment.

Analysts International, Inc.

(Senior Programmer Analyst) Vallourec Star, Minneapolis MN (Remote) Jan 2018 to Jun 2018

System Migration for S/36 UNIX emulator to iSeries, moving sources from RPG II to RPG ILE, OCL to CLLE. As well as screen files and files definitions on DDS.

Using UNIX, DB2, MS SQL, SSIS, SSRS,RPG, CL, iSeries Navigator.

(Senior Programmer Analyst) Mayo Clinic, Rochester MN Jun 2014 to Oct 2017

Maintained and Supported Explanation of Bills system (EOB).

Multiple projects for the government using EDI X12 (835, 837, 820) formats.

Letters Project. Analyzed, designed, and developed DB Data extraction on CSV format to build “Subscriber’s Grace 31 and 90 day Period Warning”, “Provider Notification by Claim Activity” and “Subscriber’s Acknowledgement”.

Encoded and decoded XML format files on EDGE Server project, for Enrollment, Medical and Pharmacy Claims submissions.

On call support.

Correspondence System support (OPTIO).

Resolved issues with DB2 stored procedures and functions back end for Web applications.

Using Aldon CMS, RPG ILE, CL, AFP and DB2, ROBOT, RDi, QM query, SEQUEL Viewpoint, MS SQL, SSIS, SSRS. Agile methodology.

Country Villa Healthcare Services (Senior Programmer Analyst) July 2001 to Apr 2014

Los Angeles California

Created queries statements, query reports, stores procedures, and functions from iSeries with Query/400 and MS SQL servers with SSRS on SQL.

Developed interface between web/SQL “Vision” system and iSeries Billing System updating Census and Clinical information using EDI HL7 format.

Developed summarized and detailed payroll/HR information for Equifax from iSeries “Kronos Payroll” system and “Workforce” web system using MS SQL store procedures and functions.

Developed “Patient Adjustments” system loading data from Excel workbooks to iSeries, using ADO.NET connection on the SQL server. With this system the process was moved to the Billing Department.

Developed Executive Dashboard web system, which automated access and distribution of census, payroll and financial reports, thus eliminating printing costs. Nexus/Clover WebSmart PHP.

Migrated data from iSeries into SQL servers systems using BI SSIS.

Developed EDI HIPAA Medi-Cal/Medicare systems 837 (Claims) decoded 999 and 277 formats, 835 (Cash Receipts) on MS SQL servers and iSeries for Billing system. Both systems were optimized and Cash Receipts were handled by billers only.

Upgraded and optimized Universal Billing system from the old UB92 standard to UB04.

Resolved all production support issues by coordinating with clients and internal units.

Using RDi, CL, COBOL, RPG, DB2, RPG free format ILE, .NET VB VisualRPG, MS SQL. iSeries (AS/400), DUNDAS, Nexus /WebSmart PHP, SQL, HTML5, XML, PML, CSS3. Management Studio 2008 and Visual Studio 2010, iSeries Navigator.

Softtek Business Solutions (Senior Programmer Analyst), Irvine CA May 1999 to Dec 2001

Versata, Oakland CA: Converted Windows systems to Versata and WebSphere environment, customized with additional JAVA methods.

Federal government and Nekema Insurance Company, Fairfax VA: Analyzed issues related to browser differences, and implementation of fixes using Window NT, NetScape, IE, Jade 4.1, JAVA, MS-Access.

OAO Healthcare Solutions, Woodland Hills CA: Analyzed, designed, developed, maintained MC/400 Healthcare System, RPG/400 and RPG/ILE and Aldon/CMS to manage software versions.

Washington Mutual, Chatsworth CA: Analyzed, designed, developed and assured quality of the Checking and Saving Accounts Systems, running in Systematics/IMPACTS I SAVINGS using JCL, Endevor,COBOL CICS/Batch, DB2, VSAM and Assembler. IBM S/390.

Sprint, Kansas, City KS: Analyzed, designed, and developed for project FMS Module LR201-ION 3.25, using JCL, Endevor, Assembler, COBOL II and CICS. IBM S/390.

Credit Bank of Peru. (IT Consultant), Lima Peru Apr 1996 to May 1999

Analyzed, designed, developed and assured quality of the Checking and Saving Accounts Systems, running in Systematics/IMPACTS I SAVINGS using JCL, COBOL CICS, DB2, VSAM, Endevor and Assembler. IBM S/390.

Mortgage Central Bank of Peru. (Project Leader), Lima Peru Aug 1986 to Jan 1996

Led “Hyper Savings” and “Regular Savings” systems fusion project.

Led “Payroll Direct Deposit System” project, using cashier terminals, first bank offered in Peru.

Led “Certificate of Deposit System” (CD) project.

Using JCL, COBOL, RPG, Assembler, CICS, DB2, Cross SP, SAFE, VSAM. IBM S/390.

Contact this candidate