SUMMARY:

• Had an extensive experience using COBOL for more than 25 years, in developing, maintenance and support of different systems.
• Had more than 10 years of experience in developing and maintenance of programs using SAS, here in U.S. and 11 years of experience in Saudi Telephone Company, Riyadh, Saudi Arabia.
• Had been tasked by the Confidential, to convert the Students’ Aid System which were all written in COBOL to SAS and was able to increase the Refund from the State, from $300,000.00 to more than $500,000.00, annually.
• Was able to solve the perennial problem in Confidential wherein the State of Monaco was not appearing on their Service Manual, aside from resolving some of their existing Production issues.
• In Wal - Mart, since they were starting to phase-out SAS in some of their systems, some of their programs had been abending and they were looking for someone who knew SAS and I volunteered to resolve the problems.
• My latest assignment was with Confidential wherein I converted their system written in COBOL, Easytrieve and DB2 to SAS EG and SQL Server.

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, GEAC, Clarity, ReMEDY /7, qUERYMAN, wsdl, xml, HFDL, Confidential .

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

EXPERIENCE:

Mainframe COBOL / SAS Programmer

Confidential, Basking Ridge, New Jersey

Responsibilities:

• Responsible in the maintenance and support of the Enterprise Tax Service System, in the process of 23 Tax Registers outputted by different systems from different locations, by doing the following:
• Submit jobs monthly, and pass data from remote LPARs to a common location for processing, using COBOL, SAS, SQL SERVER, JCL and CLIST.
• Responsible in developing new COBOL, SAS programs and debugging, or modifying the existing ones.
• Uploading of outputted files from SQL SERVER into mainframe, for processing and transmitting the outputted files from mainframe process into PC, thru ‘MFT’ and ‘SFTP’.
• The reports which are in Excel are being updated to reflect the new outputted files, and sent to the users for their analysis whether there’s a need for them to resend the corrected file/s.
• Participated in a regular Mainframe Disaster Recovery Exercise and Validation Process.

Mainframe / SAS EG Programmer

Confidential, Tallahassee, Florida

Responsibilities:

• Analyzed the High Stakes System which was developed in EZTRIEVE, COBOL, DB2, VSAM, JCL and CLIST and prepared the HIPO (High-Level Input Process Output) Chart and IPO (Input Process Output) Analysis, to aid the work of the Business Analysts for the Reverse Engineering of the System from Mainframe to SQL Server.
• 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 Confidential 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 GEAC.
• 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.
• Worked on the GCF (General Collateral Finance) REPO MRS Project, which entailed the modifications of programs in the Match Book Reporting System, testing, debugging and promoting it into production.
• Performed special printing of reports for users in other systems and assisted others in the problem-determination during the pilot run.