SUMMARY

• IBM Mainframe Programmer/Analyst wif 6+ years of experience in banking and financial domain.
• Highly organized and detail - oriented individual wif strong programming, analytical, and leadership skills and executed multiple Mainframe projects involving new development, maintenance, enhancement and production support.

TECHNICAL SKILLS

Programming Languages: COBOL, SQL, DB2 Stored Procedure, PL/SQL, JCL, CLIST,REXX

Operating System: z/OS, z/VM, Windows 7, Natural

Databases: DB2 for z/OS, IMS, Oracle, IDMS

OLTP: CICS

Middle Ware: IBM Web Sphere MQ

Access methods: VSAM

Tools: IBM DB2 BMC Utilities, IBM RACF, XPEDITOR, ENDEVOR, CHANGEMAN, FILE-AID, Control M, Panvalet, SPUTIL, IBM Data Studio, IBM SP builder, SPOOL, CA tools, JHS, IBM Service Now, IBM Manage Now, Job Track, QMF, HP Service client, MKS integrity client,Net view FTP, SPUFI, ISPF and TSO, NDM, File-Aid, Abend-aid, Workbench, DFSORT, SYNCSORT.

Methodologies: Waterfall, Agile

PROFESSIONAL EXPERIENCE

Confidential, TN

IBM Mainframe Programmer

Responsibilities:

• Worked on various production issues as day in - day out.
• Modified Cobol CICS modules to fix teh on-line issues.
• Extensively working on issue fixes due to distribution weekend.
• Designed /tested COBOL -DB2 programs, jobs, procs, control cards for various requirements.
• Working on various tools like CA Dispatch, TOAD, Platinum, Endevour, Team Server, SPUFI and related tools.
• Modified/tested various online CICS modules which plays critical role during account open and edit process
• Worked in TFS to fix teh defects raised in UAT phase and to update teh requirement.
• JCL changes and fix for jobs.
• Designed requirements for a migration project from Mainframe to Azure.
• Analyzed teh system for estimation of project timelines.
• Implemented teh mainframe changes through endevour.
• Participated in all phase till thru implementation of changes in Azure from mainframe.
• Followed Agile methodology for migration project and participated in all phase as a key responsible for teh requirements designed.
• Worked wif Azure’s DEV, QA, BA and business users and groomed all teh requirements designed.
• Modified teh COBOL DB2 CICS programs required for statements generated to writers and publishers.
• Helped in key requirement changes and designed for Credit and Debit process.
• Have hands on working wif payment process.
• Analyzed and suggested teh key changes for optimization of SQLs used in Feature and Film data.
• Worked wif QA’s and DEV to fix teh bugs in Azure world.
• Instant fixes through job or SQL’s for distribution weekend.

Confidential, St. Louis, MO

IBM Mainframe Programmer

Responsibilities:

• Proactively worked on teh requirement modifications and made changes to teh COBOL/CICS/DB2 programs, CTG’s and unit tested teh changes and moved them to clone for UAT and subsequently participated to drive components modified to production install.
• Worked on new retirement account creation Owner 401 K, ERISA and NON-ERISA.
• Data base design in DEVL for Event manage system project
• Review of LDMs and PDMs
• Prepared SQLs to Load and unload tables
• Documentation of teh changes and presentation
• Modified and created new CTGs
• Worked on HP service client wif change request to install teh changes.
• Worked on report generation to provide list to DBA on Tables/table space/triggers/stored procedures/indexes daily updated/modified daily basis.
• Designed Cobol DB2 program to obfuscated account number to test from production.
• Developed/tested/implemented teh completed obfuscated from production to test
• Used Abend Aid for abend analysis production and test jobs
• Used MKS integrity client for teh changes required to implement in production
• NDM or Ftp’d teh files as required between teh environments.
• Transferred, Obfuscated and Loaded 14+ million customers data into DB2 and IDMS tables.
• Worked on various issues wif performance post implementation of obfuscated data due Time out errors.
• Modified/Updated database thru SQLs from SPUFI.
• Used Workbench for promoting teh changes to production, to search baseline libraries for impact analysis of jones libraries, to compile teh changes.
• Participated in change reviews as a pre-installation request and to discuss about teh impact on users.
• Designed/Modified and tested teh XML string from web services to Cobol CICS modules.
• created/changed teh Copybooks/Sort cards/data cards as per teh requirement.
• Used various utilities as required like SYNCSORT, IDCAMS, IKJEFT01, DFSORT and related.
• Have modified/view/compared teh file by using File-Aid
• Proactively updated teh status of teh project weekly on teh task assigned.
• Stretched to achieve teh scheduled timeline of teh project.
• Quickly built teh rapport wif teh senior leaders at jones to understand teh legacy system and to design teh programs to obfuscated teh data as required.
• Intertest/Xpeditor, Utilized Xpeditor to debug teh online components.
• Modified/created Proc for Jobs.
• Tirelessly opened new retirement accounts and reported defects observed to team and tested them thoroughly once fixed, this halped my team to save time and deliver teh efficient code for users for testing.
• DCLGEN to generate GDG’s.Data Obfuscation
• To replicate teh obfuscated production data in development by applying business rules.
• Designed Jobs, COBOL programs, Procs, Control cards to obfuscated 300+ DB2 tables sensitive data.
• Ran jobs working late hours to deliverer teh task on time and to achieve teh scheduled timelines
• Coordinated wif various teams to obfuscated data as per teh requirements
• Instant analysis and bug fixes post install teh changes
• Overall we obfuscated 4200+ DB2 tables and 100+ IDMS records.
• Performance testing in DEVL post installation and required changes on tables so as to avoid timeout errors for users
• Documented teh flow of jobs to run step by step to achieve data obfuscation for future development.
• Designed/tested critical sort card by applying various business rules and to join teh obfuscated files.
• Presented teh flow of obfuscation to leaders

Confidential, Phoenix,AZ

Mainframe Developer

Responsibilities:

• Developed complex COBOL, IMS programs,DB2 SQL Stored procedures and Jobs.
• Handled Database changes and Performance tuning.
• Database design considerations.
• Participated in Reviews of designed and tested programs.
• Complex build/problem management and resolving technical issues.
• Providing Feasibility Study and understand High Level Design to prepare Detailed Design.
• Developing and enhancing complex COBOL programs to meet teh Design and Requirements.
• Resolving complex abends and data issues in production environment.
• Daily meetings and addressing teh issue.
• Designed complex stored procedure in order to validate teh business functionalities.
• Worked in shifts and also stretched thru shifts as needed.

Confidential

Mainframe Developer

Responsibilities:

• Developed new mainframe programs using COBOL.
• Requirement gathering and finalizing teh delivery of teh requirements.
• Business calls and quires clarification on requirements.
• Analysis Design and Build for teh new requirements.
• Impact analysis due to new program changes in teh database.
• Unit test case preparation and execution.
• Worked wif 3 juniors and assign teh task, reviewing and providing teh feed back to RM.
• We are 20+, MOM preparation for weekly status call on rotation basis.
• Coordinating wif Front End team and TcoE teams whenever required.
• Participated in Implementation/Reviews.
• Database design considerations and SQL Performance.
• Participated in Implementation.

Confidential

Mainframe Developer

Responsibilities:

• Developed key modules of teh Mainframe application to upgrade warranty using COBOL and DB2/IMS.
• Analysis Design and Build of requirements.
• Impact analysis due to new program changes in teh database.
• Unit test case preparation and execution.
• MOM preparation for weekly status call on rotation basis.
• Discussion wif on shore team members.
• Coordinating wif Front End team and TcoE teams whenever required.
• Participated in Implementation.
• Formulated estimates, development plan and implementation checklists.
• Coordinated wif downstream applications during testing phase for completing thorough end-to-end testing.
• Provided support during teh acceptance testing in solving any technical glitches. Should see through teh completion of teh acceptance testing.
• Provided post-delivery support after deployment.
• Generated various Test cases and performed Unit / System / Performance / Integration Testing.
• Developed architecture, business logic and database structure of teh project.
• Developed new mainframe programs using microfocus, COBOL, CICS, DB2, IMS and CLIST, REXX.
• Impact analysis of teh existing components to teh DB object changes.
• Developed test plan. Resolved various UAT issues by enhancing COBOL CICS/CLIST mainframe programs as required for proper functioning of MATIC application.
• Coordinated wif teh upstream/downstream applications for processing teh billing files during end-to-end testing.
• Participated in deployment of teh software mainframe programs to UAT and production regions.
• Task execution, review and status tracking and reporting to higher management.
• Addressing teh issues wifout breaching SLA's.