Software and Language:

• ORACLE/SQL
• IDEAL/SQL
• SYBASE/SQL
• DB2/SQL
• SQL
• C++
• Excel
• Windows NT
• COBOL II
• OS/JCL
• Assembler
• EDP
• Word
• Expeditor
• Lotus Notes
• Focus
• QMF
• MS-DOS
• DYL-280
• Max 2000
• Syncsort
• XML
• EDI
• Access

Hardware and Environment:

• IBM 3090
• IBM PS/2
• JES2
• CICS/VS
• IBM/UNIX
• SUN/UNIX
• IBM 3084-Q
• IBM 3080
• VTAM Roscoe
• OS/MVS
• IBM/PC/XT/AT
• MVS/ESA/XA
• TSO/ISPF
• MVS/DOS
• Datacom

Employment:
Confidential.
December 2010 to March 2011
System Analyst Consultant

• Responsibilities included: Team Lead ~ Programs development & enhancements for DB2, CICS & COBOL II online & batch, data analyst, data validation and data mapping.
• Enhanced CICS screens design, performed programs testing & unit testing. Q/A Documented trends, prepared Word or Excel for data comparisons, test plans, and test results.
• Modified Jobs stream for proc developments, job development and programs enhancements. Performed programs walk-thru, programs design, User interface and identified additional development processing. Platforms: COBOL II, VSAM, DB2, JCL, File Aid, EDI, EDP and Changeman.

Employment:
Confidential.
December 2007 to March 2010
System Analyst

• Responsible for user interface, analysis, designing, coding and testing for JCL, DB2 & COBOL II. Implement the mainframe process for Production. Develop the Jobs, PROC’s, PARMs & FTP to Production & Development.
• DB2 programs Extracts, Inserts, Deletes and Updates. COBOL II developments & enhancements, JCL Jobs & PROC’s development plus UNIX scripts procedure & developments.
• Programs DB2 extracts preformed by moving source tables columns to corresponding extract tables columns to data mapping. Using joins of table columns to populate the extract when required.
• Created JCL Jobs stream with PROC’s developments, JCL override, symbolic parameter and file processing.. Performed programs walk-thru, programs design, user interface and identified additional development processing.
• Data modeling, data analyst and data validation. Plus Users acceptances review with sign-off.
• Q/A Network Element developments, stage planning and implementations, post testing, client testing, system provisioning and client interfacing/training

Platforms: COBOL II, DB2, JCL, SPUFI, CICS, EDI, EDP, .Net, File Aid, VSAM, Excel, Access & Changeman. 

Employment:
Confidential.
December 2005 to 2007
System Analyst Consultant

• Responsibilities included: Team Lead ~ Programs development & enhancements for DB2, CICS & COBOL II online & batch, data analyst, data validation and data mapping.
• Enhanced CICS screens design, performed programs testing & unit testing. Q/A Documented trends, prepared Word or Excel for data comparisons, test plans, and test results.
• Converting the mainframe VSAM files processing into DB2 Tables format for the database Extract & Load. Assisted with Parent & child relationship with DB2 Tables, one to one or one to many or many to many.
• Created Jobs stream for proc developments, job development and programs documentation. Performed programs walk-thru, programs design, user interface and identified additional development processing.

Platforms: COBOL II, VSAM, DB2, JCL, File Aid, EDI, EDP, CICS & Excel.

Confidential.
May 2004 to May 2005
System Analyst Consultant

• Responsibilities: Centralize job stream, naming standards, data screening/validation, programs walk through for prior to implementation. Platforms: COBOL II, DB2, JCL, LOTUS NOTES & Excel.
• Team Lead perform unit testing, cross team unit test, user documentations, developer documentation and assisting with queries management. Headed the jobs cycle setup procedures system testing and job scheduling.
• Responsibilities consisted of systems and programs designs, logical conceptions, data storage and data recovery. Performs: data validation, data mapping, data integrity and system implementations. Developed check lists for implementing enhancements and new developments.

Confidential
System Analyst 
September 2000 to January 2003

• UDS Responsibilities: Centralize data flow to UNIX directories, monitoring the directories, validating the directories capacity, and preparing data files from the directories for nightly processing on the Mainframe.
• Programs developments, System inspections & enhancements, jobs developments, data modeling & unit testing, cycle processing, stage planning and implementations/documentation/training.
• DB2 programs Extracts, Inserts, Deletes and Updates. COBOL II developments & enhancements, JCL Jobs & PROC’s development plus UNIX scripts procedure & developments.
• Programs DB2 extracts preformed by moving source tables columns to corresponding extract tables columns to data mapping. Using joins of table columns to populate the extract when required.
• Development Languages: COBOL II, DB2, JCL, FTP, Fie Aid, Abend-Aid, Endevor, REXX, TSO & UNIX Shell. Platform: IBM Mainframe & SUN/IBM UNIX. Database: DB2 Universal Database
• Activation Manager: Responsibilities: Installations of upgrade releases, package testing, unit testing, customizations, configurations, Package inspections & enhancements.
• Q/A Network Element developments, stage planning and implementations, post testing, client testing, system provisioning and client interfacing/training
• Enhancements phase by engaged users with disabilities as consultants to review the new release being deployed, provided application or product support.
• Package Installation: GSM, TDMA, PCS, OTAC, SMS, VAD, Data DPS &GPRS markets. Environment: SUN/IBM UNIX. Development Platforms: COBRA, Oracle, Websphere, ITS, GUI, XML, C++, HTML, EDI, Weblogic, EDI, EDP, and Solaris.

Confidential.
January 1999 to August 2000
System Analyst Consultant 
Client: Peoples Energy

• Responsible for user interface, analysis, design and coding with Prism for Oracle, Sybase, DB2 & COBOL II. Implement the mainframe process for DataMart ~ Develop the Jobs, proc’s, parms & FTP to UNIX. Establish the mainframe centralizes process; this includes moving DataMart MVS into Endevor & documentations.
• Programs DB2 extracts commenced by moving source tables columns to corresponding extract tables columns to data mapping. Using joins of table columns to populate the extract when required and getting the current date and updating extract date.
• Oracle & DB2 programs Extracts, Inserts, Deletes, Updates and Joins. Data Storage weekly data capture and Data Integrity testing including performed programs walk-through.
• Prepare designs and coding scripts for programs, data loads with SQL loader, coping and moving data using UNIX commands, I also used UNIX FTP command to different UNIX boxes & scripts with RI and Scripting development.
• Designed and developed of Revenue Statistics process both mainframe & UNIX implements the fusion to FTP. Daily Data Store ~ process of capturing daily data form batch & online transaction and loading the data into warehouse. Scheduling the job using Autosys. Data mapping assisted with data model development and data validation.
• Perform unit testing, cross team unit test, user documentations, developer documentation and assisting with SQL queries both user & management. Data validation, data mapping, DDL setup, data loads, Prism development and implementing of revenue statistics as well as assisting in the DataMart installation.
• Q/A testing, created and executed test plans, ensured data integrity and system up-time. Analyzed the system run time, availability and escalated any issues.
• Developed training manuals and materials for customized software versions to assist users and management.
• Development Platforms: SUN/IBM UNIX, Oracle, Sybase, Mainframe, Xpeditor, COBOLII, DB2, JCL, FTP, Max2000, File Aid, SQL & TSO

Education: 
Bachelor of Science Degree Computer Information Systems