SUMMARY:

• Responsible, analytical and technically oriented systems professional with heavy expertise hands on using DB2 ORACLE SQL SAS in both UNIX and z/OS MVS MAINFRAME with COBOL/SYNCSORT environments. Over 10 years of PC SAS BASE experience and SAS Enterprise Miner Guide including SAS Data Studio. 8+ years of current experience within the Financial Services/Banking industry.
• Extensive experience in data architecture, migration management, data structures, and platforms Mobility applications/systems SME, data integrity, data security with Confidential .
• Particularly skilled in structured flowcharting and programming.
• Creative problem solver and trouble shooter, resourceful and consistent accustomed to a fast paced environment and multiple projects, able to work under pressure and meet deadlines.
• Diplomatic negotiator and dealing effectively with all level of management and staff.

TECHNICAL SKILLS:

Languages: COBOL, SAS.

Databases: SQL, ORACLE, DB2.

O/S: MVS IBM 370/3033/308 X/309X/AIX.

Tools: MAINFRAME / UNIX.

HARDWARE: IBM 370, 3033, 308X, 309X, AIX/6000, AS/400, PC MS/DOS/AST/WINDOWS.

PROFESSIONAL EXPERIENCE:

Confidential, Moline, IL

IT ANALYST

Responsibilities:

• Monitoring and fixing SAS Jobs and JCL with invalid data coming into the Programs. They have been running for sometimes.
• Resolved issues with Jobs and programs with false alert warnings because volumes no longer in Production files. Also modify SAS programs to change reports heading.
• Created and automate a process in SAS to capture UNIX data from all Data Center & send email to owners of FTP jobs running on the systems. Requested by the users. This implementation of the FTP jobs is in Production and scheduled to be run on the first quarter of January 2018.
• Monitor all Data center for UNSUCCESSFULLY JOBS RUNNING ON ALL CENTER and notify to Mainframe Storage team to clean up the Mainframe environment.
• Got familiar with environment related to Capacity Planning and Performance and shared information with member of the OFFSHORT team.

Data Engineer

Responsibilities:

• Production and Test Support for installation Systems. Working with IT department to evaluate, manipulate and determine valuation of the move off mainframe to AIX system from existing MAINFRAMES TERADATA/SQL/ORACLE/SAS/COBOL and SYNCSORT Environment.
• Create and maintain scripting conversion programs and SQL queries for Ad - hoc report requests, ongoing maintenance and issue debugging.
• Pre-Compile, Compile and Set environment for the programs for testing. Transfer Data to other environment.

PROJECT LEADER

Responsibilities:

• Production and Test Support for installation Systems.
• Working with IT department to evaluate, manipulate and determine valuation of the future UNIX/LINUX system from existing SOLARIS UNIX /SQL/ORACLE/SAS Environment.
• Install correct versions of 3rd party software online for SAS 9.3.

Consultant

Responsibilities:

• Production Support for all Claims Systems.
• Working with IT department to extract data, manipulate and determine valuation Claims for existing projects on TERADATA, PC SAS and MAINFRAME UNIX COBOL/SQL/DB2/SAS Environment.
• Assisting Mangers to Research, clean data and fix errors on all require Claims System for all Confidential Department.

Consultant

Responsibilities:

• Develop markets in Europe, Asia, the Middle East, Africa and Latin America. ALICO has regional headquarters in Tokyo, Paris, Athens, Dubai, and Santiago, Chile.
• Working with IT department to extract data, manipulate and determine valuation reconciliation for existing projects on PC SAS, AS/400 MAINFRAME UNIX Cobol/SQL/DB2/SAS Base, Enterprise Miner environment.
• Assisting vendors to create data dictionary for the purpose of creation Prophet Models insurance policy for all Actuary Department.
• Utilized Vendors Product/Securities Processing, Portfolio Market, Reference Data and Integrated Monetary Processing and Control System (IMPACS).

Sr. Programmer/Analyst

Responsibilities:

• Primary responsibilities with Citibank are develops and maintains productive working relationships with key internal clients, vendors and other IS resources.
• Support existing system processes and maintain data integrity of the systems. Also, provide production support and on-going maintenance and enhancement projects for existing systems. Using Mainframe processed and transfers data to the UNIX box.
• Extracted Data Warehouse from DB2 SQL ORACLE SAS COBOL MVS MF SYSTEM.
• Evaluated data and produce Ad Hoc Matrix reports to do audits for direct marketing and database marketing systems.

Confidential, New York, NY

Consultant

Responsibilities:

• Extracted Data Warehouse from DB2, SQL, ORACLE, SAS, COBOL MVS Mainframe.
• System to evaluate Data and produce Ad Hoc Matrix reports to do audits for various PRE SCREEN and ITA direct marketing and database marketing projects.

Consultant

Responsibilities:

• Creating Ad Hoc reporting required by Company using SAS Mainframe and SAS DB2 SUBSYSTEM.
• Also, developed production system on Mainframe and then Down load all Spreadsheet Report to the LAN to be use in Microsoft Excel format.
• Converted all Report to run on Prodigy Central (WEBSITE) for Viewing by vendors.

Consultant

Responsibilities:

• Assisting Coopers & Lybrand in Health Insurance Application to do Audit for Prudential insurance.
• Creating AD HOC report required by Coopers & Lybrand using COBOL/CICS/DB2/SAS MAINFRAME & PC. AF / SCL Processing.

Consultant

Responsibilities:

• Creating and maintaining Database, SAS and COBOL programs for PHOTOCARD PENETRATION, BALCON and Aims System Projects. DOWNLOAD and RESTORE FILES using FDR and IBM Utilities.
• Transmitting reports to users to keep track of all credit card accounts in X/L Software.
• Also, automate and create system for programmer’s users to evaluate Mainframe Data VS Data Warehouse (CAM).

Consultant

Responsibilities:

• Wrote and maintained SAS, EZTRIVE & COBOL Program for Pharmaceutical company. Process claims filled at the pharmacy or mail-order to send report required by clients / or insurance companies for which they manage the distribution of prescribed drugs.

Consultant

Responsibilities:

• Worked with all Canadian Telephone companies.
• Wrote SAS and COBOL programs for all these telephone Companies.
• Also teach MVS SYSTEMS.

Consultant

Responsibilities:

• Wrote Cobol/CICS/DB2/SAS programs.
• Processed claims submission & mortgages customer information.

Sr. Systems Engineer

Responsibilities:

• Worked as a technical specialist on non-technical team to design and automate.
• Disaster Recovery Program for company.
• Evaluated software packages and recommended package elected for Company.
• Installed and managed BEST/1 (MVS, CICS & NETWORK Modeling Packages at 5 Data Centers).
• Developed, simulated, evaluated and maintained multiple recovery scenarios using BEST/1.
• Modeling Packages to determine optimal recovery strategy.
• Documented all steps necessary to utilize BEST/1 Product and trained other staff member.
• Balanced workload for all production applications and Automated Disaster Recovery.

Consultant

Responsibilities:

• Created capacity planning to report resource usage in system to senior management
• Converted COBOL program to SAS. Installed PC and software packages

Capacity Planning Analyst

Responsibilities:

• Set up new release of SAS color graphics and SAS/FSP
• Installed new release of Epilog and created Epilog reports
• Installed new release of OMEGAMON; created new screens
• Managed project to merge two major brokerage systems
• Installed SMF Dumps. Collected SMF and RMF data from six different systems
• Selected data for creation of own database to develop and produce automatically generate usage report for Management review of resources (CPU utilization, I/O devices, batch production job on-line, Response Time, Testing and TSO) - accomplished using SAS and MERRILL/MXG.