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 of Education, 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 FEDEX 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 Florida Department of Education wherein I converted their system written in COBOL, Easytrieve and DB2 to SAS EG and SQL Server.

TECHNICAL 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, NEON.

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

PROFESSIONAL EXPERIENCE:

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

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.

Programmer Analyst

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.

Programmer Analyst

Confidential, Washington D.C

Responsibilities:

• Responsible for maintenance by modifying the programs as required and handled the problems as prompted by the error messages generated by the system on a daily basis.
• Performed system analysis, recommended and implemented the necessary solutions.