SUMMARY

• 10+ years of designing, developing and supporting Mainframe applications using COBOL, CICS, SQL, JCL, VSAM, DB2, Stored Procedures, IMS DB/DC, IDMS, MQ Series and CTG.
• Integrated with .Net and Java applications using DB2 Stored Procedures and CTG.
• Expertise with Expeditor and experience in conducting batch and online testing.
• Created/Modified job schedules using CA - 7 and Control-M.
• Excellent communication and presentations skills with Teams, Project Managers, Business Users/SME’s and Customers.
• Grasps new technical and functional skills with ease.
• Efficiently translates business requirements to technical details.
• Possesses excellent Analytical and Problem Solving skills and works independently to research and develop complex requirements.
• Self-motivated and determined to resolve issues with minimal help.
• Identifies/coordinates risks with external projects and prepares disaster recovery documents.

TECHNICAL SKILLS

Languages: SQL, Cobol, JCL, CICS, Cross System Product (CSP), Stored Procedures, CICS Transaction Gateway (CTG), Easytrieve, MQ Series

Databases: Confidential DB 2 9.0/8.0/7.0, IMS DB/DC, IDMS, MAPC, ADSA, DIALOG, Oracle 9i, Microsoft Access

Testing Tools: Abend-Aid, Expeditor, Intertest, Mercury Quality Center CA-7, Control-M, Zeke, Infoman

Software: Microsoft Word, Excel, PowerPoint, MS Visio, TSO/ISPF, Fileaid, Syncsort, DFSort, Platinum, QMF, SPUFI, BMC, NDM, FTP, INFOPAC, Stored Proc Builder, MKS, Equip, Service Center, SOLA, Microsoft Visual Studio

Hardware: Windows 95/98/2000/XP/NT, OS/390, z/OS

PROFESSIONAL EXPERIENCE

Confidential, RICHMOND, VA

SYSTEMS ANALYST

Responsibilities:

• Prepared the high level architecture of the system and introduced Stored procedures within the organization for faster retrieval of data.
• Interacted with business and the SMES to understand the current business and the business rules that they would like to view on the new screens
• Contributed to the workshops to prepare screen designs for CIBOODLE
• Analyzed the existing systems and the inputs/outputs generated by each prior to deciding the screens.
• Designed and implemented Foundation of Gateway dealing with retrieval of customer data and contact history.
• Prepared extensive business and technical requirements documents for business and technical review and signoff.
• Prepared estimates and work plans for team members to help design, build and test the application.
• Assisted with user testing, load testing, performance testing and defect resolutions.
• Prepared functional and technical design documents with specifications and test cases.
• Analyzed the architecture for each module using either MQ Series or Stored Procedures.
• Extensive interaction for testing the DIA screens with the SOA team.

Environment: - COBOL, CICS, JCL, VSAM, DB2, Endevor, FILEAID, Expeditor, Intertest, Filemaster, FTP, SQL, CIBOODLE - Java, Visio, Stored Procedure.

Confidential, SACRAMENTO, CA

Sr. Mainframe developer

Responsibilities:

• Interacted with business and the SMES to understand the current business and the business rules that will be incorporated into the SOA.
• Analyzed claims and reduced pay functionality to retain business rules in CICS programs.
• Involved in developing temporary storage queues, maps, XCTL’s and LINK’s to new programs, to convert the CICS programs and to avoid the limitations in the SOA middleware suite.
• Analyzed and conducted impact analysis of the changes with other projects which also used SOA for integration such as Unemployment Insurance project.
• Prepared functional and technical design documents with specifications and test cases.
• Prepared Test Plans and Test Cases using data from IDMS tables to assist System/Regression/Integration and User Acceptance testing.
• Extensive interaction for testing the DIA screens with the SOA team.

Environment: - COBOL, CICS, JCL, VSAM, DB2, Changeman, FILEAID, Expeditor, NDM, CA-7, IDMS/ADSO, IDDM, DMLO, ADSC, Microsoft Visual Studio, Service Oriented Architecture.

Confidential - St Louis, MO

Sr. Mainframe developer/Architect

Responsibilities:

• Performed Development, Maintenance, Enhancements and Support tasks for several systems such as Books and Records, Tax, Money Market, Mutual Funds and Trades.
• Participated in JAD sessions with business users/auditors to gather requirements.
• Coordinated with DBA’s to build logical design of DB2 tables for the application.
• Prepared ADHOC reports and files for branch users as part of maintenance tasks.
• Analyzed and conducted impact analysis of existing systems to accommodate new requirements.
• Designed systems and tasks as per User requirements and prepared LLD and HLD documents.
• Created/Modified/Reviewed complex batch and online programs.
• Prepared Test Plans and Test Cases using data from DB2 and IDMS tables to assist System/Regression/Integration and User Acceptance testing.
• Tracked defects using Mercury Quality Center and ensured defects were rectified and closed.
• Interacted with client-server teams to perform Integration/Performance testing involving Java screens and Mainframe using CTG.
• Prepared/modified job schedules for the new/existing jobs.
• Involved in Production support, resolving Abends and monitoring jobs for several systems.
• Changed/Added File controls to reduce errors from external datasets from vendors.

Environment: - COBOL, DB2 V9.0, SQL, CICS, JCL, VSAM, Platinum, FILEAID, Workbench, Expeditor, NDM, FTP, CA-7, CTG, IDMS/ADSO, IDDM, DMLO, ADSC, MKS, Mercury Quality Center, Service Center

Confidential - louisville, KY

Sr. Mainframe developer

Responsibilities:

• Prepared jobs, reports and job schedules for RX Automation process to provide reports in three different regions with different run cycles.
• Supported the ME system for Medicaid Eligibility.
• Involved in Performance Tuning of SQL queries using Strobe results.
• Prepared Stored Procedures for .Net applications providing Pharmacy information on MyHumana page.

Environment: - COBOL, DB2, JCL, VSAM, IMS DB/DC, Stored Proc, Stored Proc Builder, PANVALET, FILEAID, NDM, FTP, Easytrieve, Control-M, Infopac, Platinum, TSO/ISPF and Equip.

Confidential, Phoenix, AZ

Onsite Team Lead/Sr. Mainframe Developer

Responsibilities:

• Involved in Requirements gathering with users, screen layout design with front-end team (Java) and logical design of tables with the DBA’s.
• Conducted Impact Analysis of existing systems to design batch and online flow.
• Prepared technical and functional documents as well as Test Plans and Test Cases.
• Estimated the deliverables, designated tasks and mentored team.
• Created/Modified complex programs and screens integrating with Java applications.
• Assisted users with System/Regression/Integration/User acceptance testing.
• Excellent knowledge of Credit Card Processing (Accounts Payable).
• Involved in QA process for external projects and conducted internal audits.

Environment: - Changeman, COBOL, JCL, VSAM, TSO/ISPF, CICS, NDM, FTP Expeditor, DB2, IMS DB/DC, CA-7, Stored Procedures, Stored Proc Builder, File Aid, Infoman, Infopac, and BMC tools, VISIO.

Confidential

Mainframe Developer

Responsibilities:

• Created application for Bank of Spain with details of depreciation rates and lease terms for various Confidential products - hardware and software that were leased.
• This involved preparing reports, queries and programs using Confidential third party tool CSP (Cross System Product).

Environment: - COBOL, CSP (Cross System Product), SQL, DB2, CA-7, BMC

Confidential, RALEIGH, NC

Mainframe developer

Responsibilities:

• Implemented and supported Conversion tasks to convert from IDMS database to DB2/Oracle.
• Added business functionalities for home owner lenders and financial institutions through additional Screen Functions and batch program changes.
• Prepared User Interface screens for users to submit Dynamic JCL in order to generate reports.

Environment: - COBOL, CICS, SQL, DB2, IDMS/ADSO, ADSA, Oracle 9i, MAPC, Dialog, JCL, VSAM, SPUFI, BMC, Fileaid, Intertest, Expeditor, CA-7, Endevor, Easytrieve

Confidential, RALEIGH, NC

Mainframe developer

Responsibilities:

• Involved in production support and provided temporary and permanent fixes for the Employee Stock and Options (ESOP) application.
• Modified online and batch programs to accomplish user requirements for enhancement tasks.
• Involved in documentation of existing and new jobs for the application in HTML format.

Environment: - COBOL, CICS, SQL, DB2, JCL, VSAM, SPUFI, BMC, Fileaid, Intertest, Expeditor, CA-7, ENDEVOR and HTML.