SUMMARY:

I have 30 years of experience in development, analysis, implementation and testing of business applications in Credit card, Retail, Finance, Automobile, MEDI - CAL domains using COBOLII, COBOL370, PLI, CICS, JCL, DB2, VSAM, PROC/JCL, SYNCSORT, Confidential Tools, TSO /ISPF.

SKILL:

LANGUAGES: COBOL II/ 370/LE, PL/I, JCL, CICS, SQL, QMF, MQ, SPUFITOOLS: TSO/ISPF, CHANGEMAN, EXPEDETOR, EZTRIEVE, INTERTEST, PANVALET, ENDEAVOR, FILE-AID, ABEND-AID, PLATINUM, DCLGEN, MS OFFICE, VISIO, LOTUS NOTES, SAR, NDM, VIEW DIRECTCOMPAREX, CEDF, CA7 / CA11

RDBMS: DB2, VSAM, ISAM, DATACOM

OPERATING SYSTEM: OS/390, MVS/ESA, VSE/ESA, Z/OS.

EXPERIENCE:

Confidential, Newark, CA

Mainframe consultant

Responsibilities:

• Support and process policy application for State Fund insurance.
• Daily process and FTP jobs of endorsement and declaration for all policies.
• Create JCL/PROC, modify Cobol DB2 programs
• Resolve issues for QA, production.

Environment: COBOL II, DB2, JCL, TSO, ISPF, SQL, PANVALET,VSE/ESA, Z/OS

Confidential, Downey, CA

Sr. Mainframe Developer

Responsibilities:

• This project enhanced the Retirement, Personnel, Payroll application that will handle the dates.
• Modified online and batch programs, wrote test scripts, performed system test. Daily resolve issues relate to programs and JCL.
• Enhanced and supported Payroll and Retirement application for Confidential .

Environment: COBOL II, CICS, DB2, JCL, TSO, ISPF, SQL, QMF, VSE/ESA, Z/OS

Confidential, San Diego, CA

Sr. Mainframe Developer

• Demanded jobs in CA7 under z/OS 1.11 and tested all online transaction to ensure the results from z/OS 1.11 match with the results from z/OZ 1.09.
• Validated all finance application do not fail or crash due to new operating system.
• Fixed Cobol /CICS programs during conversion.

Environment: COBOL II, CICS, VSAM, NATURAL, ADABAS, JCL, TSO, ISPF, SQL, QMF, VSE/ESA, Z/OS

Confidential, Albany, NY

Sr. Mainframe Developer

Responsibilities:

• Created new process to create monthly Reinsurance Underwriting reports calculating underwriting profit / lost by policy and transferred to the Fund Held account on a monthly basic.
• Created a new process to create Retrospective A/P process which is 30 days after the quarter closes.
• This process will include Retrospective Distribution to PeopleSoft interface and Honda/Acura VSC Retro semi-annual distribution to be FTP’d to Gateway.

Environment: COBOL2, CICS, DB2, JCL, TSO, ISPF, LIBRARIAN, SPUFI, FILE MANAGER, OS/390

Confidential, Sacramento, CA

Sr. Mainframe Developer

Responsibilities:

• Modified Cobol DB2 CICS programs to add new fields and expanded the length of current input fields.
• Performed system test and created test scripts for Medi-Cal Claim project.

Confidential, Franklin Lakes, NJ

Sr. Mainframe Developer

Responsibilities:

• Wrote high and detail level specification for mainframe tasks to build a New Rx Group Cross Reference Table and to load data using Initial Load Extract from the Anchor Rx Group cross Reference Table.
• Migrated data from Medco drug database to Express Script database.
• Coded Cobol, MQ, SQL programs to retrieve the data (DB2) from RX group based on submitted group ID from POS.
• Modified batch Cobol program to call stored procedure to extract multiple addresses from DB2 tables.
• Coded new Cobol CICS DB2 programs to accept requested input from POS (Point of Service) to search for drugs ids and their related information from DB2 tables and VSAM files . Created PROC/JCL to execute batch programs to generate reports.
• Using CA7 to scheduled new batch jobs and viewed job scheduling to monitor /analyze production failed jobs prior fixing issues and defects in claim and benefit processing.
• Purchase Order Operation. (Walmart).
• Designed and coded requester Cobol program which passes purchase order numbers and invokes Web Service to the provider program to rewrite Vsam file.
• Designed and coded provider Cobol program which gets PO number from requester program via Web Service then update DB2 table.
• Worked on the project to monitor and alert the batch jobs which are running over maximum limit time set up in the schedule. This project involved in coding new Cobol program to read timestamp in DB2 table and send email to the proper group to alert the late jobs.
• Created batch jobs (Proc / JCL) to process all purchase numbers that not acknowledged in DB2 table.
• Created test scripts and tested all above new programs prior installing to production.

Environment: WEB SERVICE, COBOL370, CICS, DB2, MQ, VSAM, JCL, TSO, ISPF, CICS, EXPERDITOR, SPUFI, FILE MANAGER, CA7, OS/390

Confidential, Rancho Cordova, CA

Sr. Mainframe Developer

Responsibilities:

• Worked with team members to set up, tested and verified CICS regions.
• Migrated data from Nevada MMIS to HP test environment for system test.
• Modified and mass changed JCLS, PROCS, PARMS, Cobol-CICS-DB2 programs, Part of the team performed all phases of tests in CORE test environment. Used SPUFI to extract data from DB2 and FTP to server or sent to client to investigate or to verify claim issues from cycle. Researched report programs that access to DB2 and provided technical information for team members to develop.
• Modified Cobol program to call SQL stored procedure to select patient’s address formatted to XML and /or sent data (MQ) to other group/environment.
• Medical MMIS System Group.
• Responsibilities for maintain daily claims processing of MEDICAL. Monitored production cycle (CA7) and resolved issues. Researched and provided technical information to customer‘s business requirement.
• Modified /enhanced programs to accept MQ series or XML requests from problem statement to resolve issues relate to MEDICAL application.
• Coded CICS Cobol programs to accept screen input(GUI) and accessed to databases to retrieve procedure codes, claim amounts and passed them to screens.
• Peer reviewed and walked through projects for team.
• Created test cases and performed unit/system tests.
• Created documentation and implemented components to production via Endeavor.
• Created JCL/Proc to backup data of all GDG level to turn over the Medi-Cal project to new vendor.

Environment: COBOL370, CICS, ENDEAVOR, JCL, TSO, ISPF, DB/2, VSAM, INTERTEST, FILE MANAGER, CA7, IBM3090.

Confidential, Columbus, OH

Sr. Programmer Analyst

Responsibilities:

• Analyzed retirement plans, modeled Ledger database and use data dictionary to created new DB2 table to store the plans separately from DB2 tables.
• Enhanced programs to allocate the plans, extracted plans and generated report.
• Contact Address re-engineering project.
• Designed DB2 tables for OHIO Public Employees Retirement System so that addresses can be retrieved accurately.
• Modified online & batch Cobol 370 programs to access new tables.
• Write technical specification and test plan. Set up PROCS/JCL. Perform walk thru programs, unit and system test.

Environment: COBOL 370, CICS, SPUFI, QMF, XPEDITOR, NDM, JCL, TSO, ISPF, DB2, VSAM, IOF, ENDEVOR, Confidential 3090/MVS.

Confidential

Sr. Programmer Analyst

Responsibilities:

• Analyzed Child Support Benefit and enhanced application for new requirement.
• Modified online programs to accept input screens to process application using COBOLII and extracted data from DB2. Formatted, transferred files to statistic program.
• Fixed stream of batch jobs to prevent issues in current system.
• Created test cases and performed unit, system test.

Environment: COBOL II, CICS, SPUFI, QMF, ENDEVOR, NDM, VISIO, PROC/JCL, TSO, ISPF, DB/2, VSAM, SARS, XPEDITOR, Confidential 3090/MVS

Confidential, Foster City, CA

Sr. Software Developer

Responsibilities:

• Wrote technical documents based on business requirement.
• Coded programs to keep track of users who accessed Confidential transactions.
• Designed Confidential Transaction Research (VTRS) screens.
• Coded program to stored users’ ids, timestamp, screen-ids to TSQ, triggered transaction to load data from TDQ to DB2.
• Managed small team to develop batch DB2 programs, JCLS and scheduled jobs in CA-11
• Re-structured current system so that Confidential customers could view their transactions using
• COBOLII, CICS. Loaded detail data on partitioned DB2 tables, restored same data onto VSAM files.
• Coded programs to extract data from both DB2, VSAM, displayed on screens using CICS.
• Created JCLS to load, unload DB2 data. Selected specific data file using Eztrieve Plus.
• Set up JCLS to produce tapes to other departments.
• Wrote test plans and performed unit, system tests.

Environment: COBOL II, CICS, SPUFI, QMF, ENDEVOR, EZTREIVE PLUS, JCL, TSO, ISPF, DB/2, VSAM, SARS, VIEW-DIRECT, COMPAREX, Confidential 3090/MVS, Windows 2000