SUMMARY

• Confidential is a Senior Programmer/Analyst with over 25 years of experience in designing, programming, testing, and implementing mainframe applications.
• His areas of expertise include both application analysis and design and application support and enhancement using COBOL, DB2, SQL, CICS, SAS Enterprise Guide, SAS Mainframe, EASYTRIEV, DATA STAGE, TERADATA, VSAM, and IMS DB/DC in an IBM MVS (OS/390, Z/OS) environment running TSO/ISPF.
• Confidential has strong experience in several databases, including DB2, IMS, ORACLE, TERADATA and Microsoft Access.
• He works closely with technical staff to ensure that the applications are developed, tested, and implemented according to the industry’s best practices, and he is capable of working with business and application end users to gather the information and determine business requirements, resolve issues, and verify results.

SKILLS:

Platforms: IBM ES 9000/3090/3030/370/360 , PRIME 850/750/650, FACOM 230/45S, ICL - 2904, DATAGEN

Operating Systems: MVS/XA, MVS/ESA, Z/OS, Windows XP/00/98/97/95, PRIMOS, OS/VS, MS-DOS

LANGUAGES: COBOL, VS/COBOL II, COBOL 370/390, DB2, SQL, CICS, IMS DB/DC, EASYTRIEVE, QMF, SAS EG, Base SAS, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS Connect, SAS/PH-CLINICAL, SAS Warehousing and Data Mining, SAS For Healthcare, SAS for Clinical Research, PL/1, Oracle, FORTRAN, RPG, REXCOM / REQUEST, Basic, MVS/JCL, CLIST, CPL, PM/SS, Java, .NET (C#, ASP.NET, VB.NET, ORACLE.NET), HTML, Data Stage, Teradata ,

DATABASES: IMS, DB2, REXCOM, Microsoft Access

Software & Utilities: MVS/TSO, JCL, ISPF, MVS Utilities, Abendaid/CICS, Abendaid/Batch, Exceed, File-Aid, Librarian, Spufi, Platinum Tools, QMF, Panvalet, Intertest, Smartest, Expediter, Visio, Infoman, Endevor, Flow, BMP, BTS, Idcams, SyncSort, Siter, CA-7, SAR, ChangeMan, NDM, Princeton Softech Relational Tools, ZEKE, OLV, WINSQL, Strobe, Exceed, SCLM, Infopac, Stored Procedure, WSDL, Data Stage, FTP, FTPS, SFTP, Confidential, Clarity, ReMEDY /7, qUERYMAN, wsdl, xml, HFDL, NEON.

Desktop SOFTWARE: Windows XP/2000/98/97, MS Word, Excel, PowerPoint, Access, Microsoft Project

EXPERIENCE:

Mainframe / SAS EG Programmer

Confidential, Tallahassee, Florida

Responsibilities:

• Converted all the programs using SAS EG replacing DB2 Tables with SQL Server Tables.
• Created different test data to handle different test scenarios.
• Verified that the converted programs were functioning as it should, as validated with the files from the existing system in Production.

Mainframe Programmer Analyst

Confidential, Pennington, New Jersey

Responsibilities:

• Revised existing batch programs using COBOL, DB2, SQL, JCL, BMC Utilities and Endevor.
• Revised existing Stored Procedures and developed new ones, using COBOL, DB2, SQL, XML and testing it with NEON software.

Mainframe Programmer Analyst

Confidential, Baton Rouge, Arkansas

Responsibilities:

• Responsible in generating data to be inputted in the Data Validation for Sun System and being sent to Federal and resolving issues that it would reconcile with the Federal Reports being generated in mainframe, using Cobol, DB2, SQL, CICS, Eztrieve, SAS, HFDL, VSAM, & JCL.
• Developed new and revised programs, jobs, cntls, jclprocs, copy-books using Cobol, DB2, SQL, CICS, Eztrieve and, HFDL for Monetary Determination and Notices being sent to claimants due to sequestration.
• Running Users Acceptance Tests for both the Portal Wage and for Tax, inputting the data coming from .NET that would be processed using Cobol, CICS, and HFDL.
• Conducted an analysis and research the for the impacted programs and jobs in converting the copying of the reports to be kept into FILENET, from manual to be automatic.

Mainframe Programmer Analyst

Confidential, Bentonville, Arkansas

Responsibilities:

• Analyzed the requirements of the users and translated it into program/s and/or jobs, that would satisfy their requirements.
• Created Program Specifications, Sub-System Flow, Test and Validation Plans, Change Controls, and the necessary documentations.
• Performed maintenance and testing of the programs and/or Data Stage jobs.
• Coordinated with the users and QA for Users’ Acceptance Test until it’s being approved.
• Led the off-shore consultant by preparing the necessary programs specifications and verifying that all her programs and jobs were working in accordance with the specs and conforming with the company coding standards.
• Provided support for Payroll System which is mainly under Confidential .
• Regularly scheduled, as Primary On-Call Support, for any Production Job Abend relating to People Systems Area.

Programmer Analyst

Confidential, Columbus, Ohio

Responsibilities:

• Analyzed the system and identified the impacted Programs, Maps and Copy-books and the necessary changes to be made.
• Prepared the proposed Screen Layouts, copy-books and new programs to satisfy the users’ requirements.
• Wrote a new program that would extract the Medical Records information and outputted it into a Flat File, in a Text format.

Programmer Analyst

Confidential, Colorado Springs, Colorado

Responsibilities:

• Made enhancements to satisfy the user requirements and corrected some of the affected programs for the resolution of the Production problems.
• Analyzed the systems and prepared the necessary documentations such as Sub-System Flow, Job Flow Chart, HIPO Chart (High-Level Input Process Output), IPO Chart (Input Process Output), File Layouts, Sample Outputs, Job Schedules with Dependencies.

SR. Programmer Analyst

Confidential, North Wilkesboro, North Carolina

Responsibilities:

• Involved in the Trans-Load Project, by modifying programs for different sub-systems.
• Prepared Sub-System Specifications, Programs Specifications and developed new programs for Manugistics and Transportation Reporting Projects.
• Modified and developed new programs for EDI, Replenishment, Autobill and Inventory systems.
• Unwrapped the data that’s being received thru ODS before it would be processed, from UNIX to MVS, and wrapped the data that’s being sent out.
• Prepared Test Plans and test the programs, jobs according to different test scenarios.
• Entered the Job Run Schedule in ZEKE, and prepared the necessary documentations.
• Walked through the programs and/or jobs until they were promoted to Production.

SR. Programmer Analyst

Confidential, Brooklyn, New York

Responsibilities:

• Converted the programs in Excess Cost Sub-System from COBOL to SAS.
• Responsible for extracting data, merging files and writing SAS Programs, creation of Macros for regular and ad-hoc reports or creation of Files to be loaded to Excel, or vice-versa, or to the Internet.
• Performed review and detailed analysis of the existing system, by documenting the old Excess Cost Sub-System (Inputs, Outputs, Input Process Output Analysis, Reports, Validation/Selection Criteria, Processing Requirements, Program Functions and Preparation of System Flow Chart).
• Re-systemized the system in accordance with the new users’ requirements every year due to new policies, new coding scheme and for the New Continuum.
• Modified and converted CICS, COBOL-1 Programs in other System (DSE) to COBOL-370.
• Provided maintenance and special run of the State-Aid Excess Cost Sub-System.
• Performed program unit tests of both the old and corrected programs as well as the Systems Parallel Run and compared its results.
• Created new version of the system, by utilizing DB2 for the computation of FTEs, and made a comparative analysis for its effects.
• Prepared the necessary documentations such as Sub-System Flow, Program Specifications, Test Plans and other requirements by QA in the promotion of programs to Production.
• Provided support for the Medicaid Remittance System, written in SAS.
• Made the necessary recommendations or suggestions as it deemed necessary for the solution of the problems.

SR. Programmer Analyst

Confidential, Manhattan, New York

Responsibilities:

• Developed a utility comprising of programs written in COBOL II, PM/SS (Program Machine / Standard Solution) and CLIST, providing a facility to the user, to determine the linkages of the programs based on a given Tran-Id. It gives information such as the number of levels and the count, and name of programs being invoked in every level.
• Converted COBOL I programs to COBOL II in accordance with the standard methodology.
• Modified the programs reflecting the Assembler-generated Data Table changing the COBOL-generated Data Table, together with adoption of new Copy Code.

SR. Programmer Analyst

Confidential, Rye Brook, New York

Responsibilities:

• Used XPEDITER/XCHANGE to modify the system date in testing jobs for future dates.
• Used QA/Hiperstation to create scripts of test data entry only screens.
• Ran billing jobs utilizing both the production version of programs versus the Y2K-compliant versions and compared its outputs.
• Prepared the necessary documentations using MS Word, Excel and PowerPoint.
• Changed all the “Accept” commands in every program with the “Function” feature of Current-date.
• Included the standard display of program information in every program.
• Modified the affected programs, procedures and drivers due to increase of the record length of some files.
• Modified the programs and JCLs, incorporating the Security System, which were written in COBOL/370 and CICS.

SR. Programmer Analyst

Confidential, Manhattan, New York

Responsibilities:

• Analyzed the outputs of DII package on which changes needed to be reflected, whether the changes it had made were correct and in some cases it would need to be recoded.
• Running both the original programs and its respective revised version, with the production data as inputs and compared its results or outputs.
• Devised/created input test data for every program modified and utilized it in running both the original programs and the revised ones, compared its outputs and analyzed its impacts or exceptions.
• Responsible for the documentation and promotion of the Programs, PROCS and CNTLS, by entering the necessary information in INFOMAN.
• Performed special printing of reports for users in other systems and assisted others in the problem-determination during the pilot run.

Programmer Analyst

Confidential, Piscataway, New Jersey

Responsibilities:

• Created new segments in the database of the Order Processing System, modified the maps, programs, reports and copy codes for the addition of new fields in the database and the outputting of new files.
• Converted the JCLs and PROCs, changing all the blocksize to zero.
• Documented some of the programs which were modified in conjunction with the Year 2000 Project.
• Wrote an ORACLE program to update the new ORACLE Distributor Customer Table.