- */* -

David R Gonzalez

Professional experience

Profile I am a Mainframe Technology Lead with over 25 years experience in Health care, Automotive, State and Federal Government, and Financial applications. I have performed analysis, design, construction, testing and implementation on many projects following the Systems Life Cycle Methodology. I have written and revised thousands of programs using COBOL, PL1 and TELON. I have performed 24/7 production support with my team members for Health Care, Automotive and Financial systems. My key strengths include effective organizational skills, ability to assimilate new business processes, high productivity and quality of work, extremely detail oriented and promoting positive relationships with clients and peers. I bring 15 years’ experience with EDS and almost 4 years with IBM. I have been part of several large on shore off shore teams for projects. I have done many VSAM to DB2 conversion projects and I have 15 years application programming experience with DB2.

CAREER HISTORY

09/2021. - 09-2023

Mainframe Tech Lead at Teksystems, Remote Denver, colorado Client was Target Stores Corporation. I wrote many Cobol db2 programs and Did Production support with a mainframe team from Minnesota. This was an Agile environment. 06/2018 – 08/2020

Mainframe Tech Lead at Toyota Corporation Headquarters, Plano, Texas Currently assisting in analysis and testing of Toyota Financial Corporate Systems. Working the onshore offshore Infosys model with both teams. 05/2017 – 12/2017 Infosys, Citibank Client, Ofallon, Missouri Mainframe Tech Lead on Citibank Retail Bank applications. I jumped in immediately and started doing simple, medium and complex batch program changes to many different programs assigned to me. I volunteered to take on more work than I was originally assigned. I was part of a small Citibank Retail Banking team to do this project. I performed unit testing on all the program changes I was responsible for. This was cobol and vsam technology for all program changes. I did jcl and proc updates. I converted docugen code to hp extream code.

02/2017 – 04/2017 Infosys, CareFirst Client, Owings Mills, Maryland Mainframe Tech lead on modernization and decommissioning of mainframe applications project. I was the mainframe Tech Lead interfacing with both the Client and the Infosys Modernization team to provide details about decommissioning 108 CareFirst mainframe applications. I used all the necessary mainframe tools to provide reports on application programs, jobs and files to be decommissioned. I was part of a small Core team tasked to do this project for CareFirst. My part was finished efficiently in two months. 11/2015 – 01/2017 Infosys, Citigroup Client, Omaha Nebraska Production support role coordinating onshore and off shore resources. Working from home I modified any JCL changes needed for offshore team and implemented the JCL in OPC for Automation of jobs. I implemented several applications in OPC. I coordinated with the Citigroup offshore test teams to implement this automated job

- 2/6 -

methodology.

01/2014 – 01/2015 California Medicaid Project, Sacramento,CA Developer and Production Support team member

For this IBM assignment I was a Cobol Vsam developer coding and testing a new subsystem in the California Medicaid system to pay Child Health Disability Program providers the mandated bump in claim payment based on recent Federal mandated legislature. I am cloning several programs from a similar project and making the appropriate changes to allow them to fit within the new subsystem. 03/2013 – 01/2014 IBM Internal Financials Worldwide AMS Project in MDC, East Lansing, MI

A.I.W. Developer and Production Support team member For this IBM internal assignment I was a PL1/DB2 developer and a Production Support team member responsible for making sure all the hundreds of jobs which compose this Financial system run without any interruptions. If there are job a bends, we have to analyze the job in error and correct it as soon as possible to meet the time requirements for Financials to be created for the IBM executives and management team. In my six month development role, I was responsible for re-writing the largest AIW existing Reclass PL1 DB2 program to handle the Non Ledger reclassification of data.

.

02/2012 - 02/2013 IBM Internal Smarter AMS Project in MDC, East Lansing, MI Smarter AMS Centre of Excellence team member

For one year, a small band of MDC IBMERs rolled out the Ticket Analytics and Root Cause Analysis tools from the IBM labs to the 150 plus AMS accounts in the USA and also for AMS accounts internationally. Our job was to collect the Account's tickets and run the tickets via our tools we have from the IBM Labs and produced a presentation to the AMS Account DPE in hopes of saving the AMS Account time and money. Also, we were in a development mode to take the Ticket Analytics tool from a advanced Excel Spreadsheet with VBA Macros technology to the Web Platform with DB2 database technology and Cognos reporting. As of January 2013, all new Sales Endeavours will have the new web platform tools included in the sales initiative and other AMS existing accounts plus International AMS accounts will have the option to procure these same tools for a minimal cost.

04/2008 - 10/2009 Infocrossing / WIPRO, Phoenix, AZ, Programmer Analyst

Q/Care — a powerful, automated claims processing system designed to be an integral part of the day-to-day business process. Q/Care includes comprehensive management of everything from coordination of benefits, to entry of pre-existing conditions to Medicaid/Medicare information. As one of the market’s first rules based solutions, Q/Care can be easily customized to specific requirements. Its inherent flexibility provides value to a wide variety of healthcare payers, including managed care organizations, Medicare Advantage Plans, HMOs, Medicaid Managed Care Plans, PPO’s and indemnity plans.

Q/Care contains real-time adjudication or online data entry with batch adjudication, or direct HIPAA claim processing. You can access claim, member, pre-authorization, EOB, and remit information from easy-to-follow, user-friendly screens. It also enables support for dental, pharmacy and vision services. Q/Care is available under two types of contracts: Customized ASP model or a perpetual license agreement. Q/Care offers an integrated HIPAA and multi-partner electronic data interchange (EDI) solution that

- 3/6 -

supports HIPAA-mandated transactions, security and privacy (including a PHI tracking tool).

As a Programmer Analyst:

• As part of this project, actively involved in the enrolment-redesign process that takes care of sending the Medicare enrolment transactions to CMS (Centre of Medicaid and Medicare systems) and accept return transactions into the Q/Care system.

• Performed on call support for the Q/Care and Q/Advantage system.

• Analysis of the Functional design Specifications provided by the client, prepare detailed design documents and have necessary meetings with the team and co- ordinate work with respect to the release.

• Impact analysis of the programs and copybooks. This task consists of presenting the meetings to identify effecting downstream subsystems and identifies checkpoints as a part of testing.

• Preparing checklist & development tracker in order to maintain consistency and quality among all team member's work

• Preparation of test data, test cases, test reports, regression testing and participating in test review meetings with QA team.

• Performed Unit testing and integration testing for the modules coded and support QA testing.

• Involved in code reviews and also conducted code walk through with the other developers within the team.

• Responsible for resolving IR’s which will be raised by QA team while testing new functionalities that were added to the system.

• Documented the test results and preparing move up check list to and co- coordinating with SCM team to move elements to next levels. 08/2002 - 04/2008 Real Estate Market, Denver, CO

Real Estate Investor

Facilitated real estate transactions between buyers and sellers to bring residential and commercial transactions to successful closings. Real Estate market spiralled and went into the tank.

01/2002 - 08/2002 Connecticut Department of Children and Families, Hartford, CT Programmer Analyst

• Responsible for developing and supporting Batch programs

• Programs were written in COBOL, using CICS Command Level and VSAM file handling

• Responsible for enhancement of Batch programs for new business expansion.

• Created and modified test and production JCLs/ Procs / Parms and provided on- going support

• Debugging was done using XPEDITER

• Utilities- IEBGENER, IEBCOPY and IEFBR14 were used in JCL’s

• Cobol/DB2 new programs and extensive modifications to programs. Developed New and modified existing COBOL, CICS and DB2 programs

- 4/6 -

02/2000 - 06/2000 MasterCard, St. Louis, MO

Programmer Analyst

Converted large Cobol/Supra subsystem to Cobol/DB2 with about six team members. Based on DB2 being new to this company, I brought a lot of DB2 experience to the Team and it was very useful to the team.

• Responsible for modifying existing COBOL, DB2, CICS programs

• Involved in modifying existing online maintenance programs for new screen creation.

• Communicating with the application users for the user testing and implementation.

• Responsible for preparing implementation plan and communicate all groups.

• Provided UAT support and Post production support.

• Involved in fixing production issues on time to avoid Business impact.

• Responsible for issuing tracking, updated notes and notify developers on issues. 01/1999 - 01/2000 Ralphs Grocery, Compton, CA

Programmer Analyst

.

• Responsible for full life cycle methodology from requirements to production implementation of assigned programs.

• Worked closely with users on requirements and expected test results. Achieved major Y2K enhancements.

• Wrote many new Cobol/DB2 programs for store authorization system and performed enhancements to many existing Cobol/DB2 programs 03/1998 - 12/1998 Mass Mutual, Springfield, MA

Programmer Analyst

• Interpret needs; establish guidelines and priorities; identify required resources; plan and coordinate with staff at all levels.

• Champion change; create a shared vision of future beneficial and streamlined data systems. Direct multiple, concurrent assignments to consistently meet deadlines, objectives and quality standards.

• Monitor progress; evaluate outcomes. Perform unit and system testing; assign future subsystem test dates; oversee integration of modified subsystems into production; review and approve massive documentation.

• Structure and modify COBOL and CICS programs to expand capability of applicable dates.

• Orchestrated computer-related activities for large, complex Year 2000 project. 01/1997 - 01/1998 Kaiser, Denver, CO

Programmer Analyst

• Combined project management cognizance with hands-on technical expertise and proactive, practiced business sense.

• Exercised possibility thinking, planning and coordination skills critical to organizational efficiency and business growth.

• Performed and advised on administration and oversight of a variety of projects for

- 5/6 -

contracting clientele corporations.

• Kept informed on policies, priorities, industry trends and special requirements.

• Analyzed needs, developed insights and solutions; wrote several new Cobol programs; enhanced data warehouse Cobol / DB2 subsystem program 01/1995 - 01/1996 U.S. West, Denver, CO

Programmer Analyst

• Developed and implemented methods, systems and procedures to meet client needs and assure customized, cost-efficient technical direction for computer systems.

• Fostered cooperation, communication and consensus. Streamlined processes; infused innovation including state-of-the-art technological systems.

• Served on implementation team using JCL and PROCS. Evaluated test data; drew conclusions; submitted results; recommended action.

• Coded and tested Cobol II / CICS programs for life insurance company in TSO/ISPF, JCL, VSAM, Interest, Pan Valet environment.

• Defined issues; analyzed relevant information; designed and tested Cobol, CICS and DB2 programs.

01/1979 - 01/1995 EDS, Denver, CO

Programmer Analyst

• Demonstrated strong organizing and leadership skills in areas of creativity, technical expertise, quality assurance and Project management.

• Analyzed systems and applied new technologies to corporate needs.

• Designed, developed and delivered state-of-the-art billing systems, database management systems, general ledger systems and claims systems for wide range of environments.

• Provided training and support to new programmers.

• At major automotive client, propelled large on-line CICS and batch Cobol II applications for major PL/l, DB2 development project using Panasonic's TELON code generator.

• At numerous telephone corporation sites, defined requirements for BOC extract project, completed complex design and development and provided post- implementation user support.

• For large oil and gas client, coordinated 10 junior programmers in analysis, testing and coding 30 Cobol programs for oil and gas production implementation.

• At major health care company, wrote batch Cobol and CICS programs to convert massive history and provider files for Medicaid and Medicare system.

• For large client, developed Cobol programs for large general ledger system using Burroughs B6700 and sequential ISAM, random and DMS-II file structures.

• For major telephone carrier, oversaw all unit and model office billing system testing and support.

• For major non profit organization, devised large-scale Cobol and CICS applications.

• For federal government agency, led project instituting DMS II database management system.

• For State Health Care company, set up large membership and claim system.

• For major HMO client, provided COBOL programs for claims and VSAM data.

- 6/6 -

Key Skills Industry Expertise - Health Care, Automotive, State and Federal Government and Financial

Hardware - IBM Mainframe

Languages - COBOL, PL1, Telon code generation, SQL Databases - DB2

Software - Lotus notes, Lotus Symphony, Microsoft Office products Tools - TSO, ISPF, ENDEVOR, VSAM, IBM Utilities, SORT, File-aid, QMF, SPUFI, FTP,XPEDITOR,OPC, CHANGEMAN

Contact this candidate