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

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

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

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, Visual Studio, TFS, TOAD, CA Dispatch,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 the 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.
• Developed complex COBOL, DB2 SQL Stored procedures and Jobs.
• Worked in TFS to fix the defects raised in UAT phase and to update the requirement.
• JCL changes and fix for jobs.
• Designed requirements for a migration project from Mainframe to Azure.
• Analyzed the system for estimation of project timelines.
• Implemented the mainframe changes through endevour.
• Modified JOBS PROCS and CONTROL CARDS as part of file length changes.
• Used Endevour to implement the changes to production.
• Helped to migrate the queries and stored procedures from DB2 to SQL server.
• Handled CTG’s for CICS modules changes for new fields.
• Impact analysis for the DB2 column changes.
• Understanding and suggested the changes in data models for data base design LDM and PDM.
• Used Abend Aid for abend analysis production and test jobs.
• Used various utilities as required like SYNCSORT, IDCAMS, IKJEFT01, DFSORT and related.
• Have modified/view/compared the file by using File-Aid
• 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 the requirements designed.
• Worked wif Azure’s DEV, QA, BA and business users and groomed all the requirements designed.
• Modified the COBOL DB2 CICS programs required for statements generated to writers and publishers.
• Proactively updated the status of the project weekly on the task assigned.
• Helped in key requirement changes and designed for Credit and Debit process.
• Have hands on working wif payment process.
• Created/changed the Copybooks/Sort cards/data cards as per the requirement.
• Analyzed and suggested the key changes for optimization of SQLs used in Feature and Film data.
• Worked wif QA’s and DEV to fix the bugs in Azure world.
• Instant fixes through job or SQL’s for distribution weekend.

Confidential, St. Louis, MO

Sr. Mainframe developer

Responsibilities:

• Proactively worked on the requirement modifications and made changes to the COBOL/CICS/DB2 programs, CTG’s and unit tested the 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 the changes and presentation
• Modified and created new CTGs
• Worked on HP service client wif change request to install the 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 the completed obfuscated from production to test
• Used MKS integrity client for the changes required to implement in production
• NDM or Ftp’d the files as required between the 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 the changes to production, to search baseline libraries for impact analysis of jones libraries, to compile the changes.
• Participated in change reviews as a pre-installation request and to discuss about the impact on users.
• Designed/Modified and tested the XML string from web services to Cobol CICS modules.
• Stretched to achieve the scheduled timeline of the project.
• Quickly built the rapport wif the senior leaders at jones to understand the legacy system and to design the programs to obfuscated the data as required.
• Intertest/Xpeditor, Utilized Xpeditor to debug the online components.
• Modified/created Proc for Jobs.
• Tirelessly opened new retirement accounts and reported defects observed to team and tested them thoroughly once fixed, dis helped my team to save time and deliver the efficient code for users for testing.
• DCLGEN to generate GDG’s.
• To replicate the 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 the task on time and to achieve the scheduled timelines
• Coordinated wif various teams to obfuscated data as per the requirements
• Instant analysis and bug fixes post install the 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 the 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 the obfuscated files.
• Presented the 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 the Design and Requirements.
• Resolving complex abends and data issues in production environment.
• Daily meetings and addressing the issue.
• Designed complex stored procedure to validate the business functionalities.
• Worked in shifts and stretched thru shifts as needed.

Confidential

Mainframe Developer

Responsibilities:

• Developed new mainframe programs using COBOL.
• Requirement gathering and finalizing the delivery of the requirements.
• Business calls and quires clarification on requirements.
• Analysis Design and Build for the new requirements.
• Impact analysis due to new program changes in the database.
• Unit test case preparation and execution.
• Worked wif 3 juniors and assign the task, reviewing and providing the feedback 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 the Mainframe application to upgrade warranty using COBOL and DB2/IMS.
• Analysis Design and Build of requirements.
• Impact analysis due to new program changes in the 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 the acceptance testing in solving any technical glitches. Should see through the completion of the 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 the project.
• Developed new mainframe programs using microfocus, COBOL, CICS, DB2, IMS and Easytrieve+.
• Impact analysis of the existing components to the 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 the upstream/downstream applications for processing the billing files during end-to-end testing.
• Participated in deployment of the software mainframe programs to UAT and production regions.
• Task execution, review and status tracking and reporting to higher management.
• Addressing the issues wifout breaching SLA's.