SUMMARY

• Result driven IT professional having 14+ years of experience, involved in Application Development, Maintenance, Support and code and data migration of IBM Mainframe Technologies.
• Experience in each phases of Software Development Life Cycle (SDLC). Experience in Agile Methodology, Waterfall based development.
• Well Experienced in teh domains of Financial Services, Health Care, Telecom, Credit Card, Life Insurance and Auto Insurance.
• Experience working as an onsite coordinator attending teh project review meetings with Clients gathering requirements, preparing High Level Design(HLD), Low Level Design (LLD), transitioning teh requirements and design to offshore for teh Build activity.
• Strong Hands on experience requirement gathering, analysis, design, development of COBOL programs, DB2 native stored procedures, JCLs and DB2 Queries, implementation, testing and integration. Good work experience as Mainframe Data Analyst (data reconciliation, Integrity check, profiling and Mapping).
• Perform impact analysis, Trouble shooting and provide solutions to user's change requests.
• Strong experience in Performance Tuning (As part of MIPS reduction) of Complex programs/procedures, run explains on SQL queries and increase teh performance of database with TEMPeffective Index updates, RUNSTATS, rebinds and database Constraints.
• Good knowledge and best practices of testing environments and Quality processes.
• 1 Year experience in Informatica Power Center (ETL) to Extract, Transform data from various sources Flat files, Text files, Excel and CSV files, Oracle and Load into IBM DB2, flat files and Working knowledge in UNIX.
• Expertise in analysis, design, coding and testing in Multi - tiered and Layered applications.
• Worked on developing and testing, DB2 version migration and testing.
• Experience in DB2 utilities UNLOAD, LOAD, IMAGE COPY, REORG, RUNSTATS, and REBIND.
• Solid experience with writing complex Stored Procedures, SPUFI, QMF, SQL Queries and Cursors.
• Well versed in using HP Application Life Cycle Management Tools (ALM), HP Quality Center, Service Now, Service Manager, TCM, Serena and JIRA.
• Ability to multi-task work across different applications. Diverse work experience with different functionalities of teh application, with Development and Production Support projects.
• Excellent working knowledge in COBOL, JCL, DB2, IMS DB, VSAM, CICS, REXX, CLIST, SAS, Easytrieve and CICS Web Services in z/OS. Good knowledge on Assembler and PL/I.
• Expert in using MS Visio and Other MS office products Office, Power Point, Access.
• Developed many stored procedures to extract teh data from table and send through APIs, calculate Performance summary, Asset allocation, Asset allocation overtime, Standard Deviation, Alpha, Beta and R-Squared reports for Account, Composite and PM Composites.
• Work experience in various Version Control Tools like ChangeMan, Endeavor, Panvalet, GIT, and Jenkins.
• Easily adaptable to New Technologies, well demonstrated to understand complex mainframe applications and able to achieve challenging deadlines

TECHNICAL SKILLS

• COBOL
• JCL
• SQL
• MQ Series
• REXX
• CLIST
• EASYTRIEVE
• HTML
• XML
• DB2
• IMS DB
• VSAM
• Oracle
• Teradata
• Changeman
• Endevor
• Platinum
• Panvalet
• File-aid/Manager
• Abend-aid
• Strobe
• QMF
• SPUFI
• SAR
• SDSF
• TOM
• JHS
• CoolGen
• AQT
• Git and Jenkins
• TWS
• CA7
• CONTROL-M
• TMON
• JOBTRAC
• Expeditor
• INTERTEST
• Vision-plus
• AUTOSYS
• DFSORT/SYNCSORT and other IBM Utilities ICEMAN
• ICETOOL
• DB2 Native Stored Procedures
• Performance tuning in z/OS DB2 environment
• System Analyst
• Interface design and Implementation
• Agile and Walter fall methodologies
• Requirement Analysis and design phases
• Onsite Offshore model and work co-ordination
• Informatica
• HP Quality Center (ALM)
• JIRA
• Service now service manager
• Serena
• Incident
• Change and Problem management

PROFESSIONAL EXPERIENCE

Mainframe Lead Developer

Confidential, NY

Responsibilities:

• Real Time Accounts (RTA) application is a hub for financial data such as internally and externally held positions, balances and activities.
• Work demands high level technical and analysis skills in COBOL, DB2, JCL, VSAM, IMS DB and various mainframe tools etc., detailed knowledge of mainframe environment and user interactions.
• Analysis, root cause explanation and fix of daily production and QA issues.
• Develop design specification documents such as SRS, BRD, HLD and LLD for projects
• Developed DB2 data archival jobs to take daily, weekly, monthly image copy of tablespaces and reorg with discard data older than 3 months, 2 years and 7 years into tape files.
• Coded Reformat, validate, load processes jobs and programs for Yodlee AAR project.
• Developed API Stored procedures to retrieve data and send teh result set back to front end.
• Developed REXX/CLIST scripts to generate reconciliation reports and send an email.
• Developed One-time update easytrieve programs to populate data in newly added columns.
• Code reviews, Data quality checks and performance turning of batch process and API programs.
• Adhere to SDLC and Agile standards, and conduct design and code reviews.
• Analyze decommission tasks, DALN jobs in TWS, Scratch components from ChangeMan libraries.
• Developed CICS programs to read messages from MQ to validate data and insert into appropriate tables
• Preparation of teh Test Plan and review of Test Cases (Unit, Integrated & System).
• Drive various team meetings, scrum calls, weekly status meeting, Writing SDS
• Played a role as Business System analysis

Mainframe Lead Developer

Confidential

Responsibilities:

• Strategic Performance Reporting (SPR) application provides performance reporting for different kinds of Accounts (SMA, UMA, CGA, TRAK, Vetesk) and Composites (PM, BOM, FS, UMA, FAM)
• Work demands high level technical and analysis skills in COBOL, DB2, JCL, VSAM, IMS DB and various mainframe tools etc., detailed knowledge of mainframe environment and user interactions.
• Analysis, root cause explanation and fix of daily production and QA issues.
• Develop design specification documents such as SRS, BRD, HLD and LLD for projects
• Project coordination and Quality Assurance.
• Timely communication clients and response to User queries
• Knowledge transition and process improvement.
• Impact analysis and documentation, Review of Design and Code and Unit test plan.
• Coordinate Defect Prevention Meeting and maintain Defect log.
• Involved in teh design of teh database for respective modules and developed Stored Procedures & Cursors using DB2.
• Involved in application support and bug fixes.
• Support System Testing and User Acceptance Testing
• Create Ad hoc Job for data update and reports
• Assist with defining and documenting user requirements
• Assist with development of user manuals, procedure and documents
• Provide leadership, work guidance and to less experienced personnel
• Interact with customers and team members to clarify requirements

Programmer Analyst (Onsite)

Deer Company

Responsibilities:

• Provide detailed designs based on user requirements and Provide accurate estimates for development tasks.
• Understanding teh business requirements and converting them into Technical Design documents.
• Preparing program, process diagrams and flow charts for existing & new programs, Jobs.
• Developed applications COBOL, JCL, DB2, IMS DB and SAS technologies.
• Extract teh Market Information data from different sources and load into DB2 tables in Batch applications.
• Written SAS program to prepare data reports and send customers on daily basis.
• Fixed existing bugs in teh program to calculate teh correct Machine rental information before load into DB2.
• Creating User defined reports in SAS by selecting data from DB2, Flat files and Text files.
• Deployed teh changed or new program into production using Panvalet version control tool.
• Construct solutions in a timely fashion using COBOL, SAS and other tools - Research and resolve issues.

Mainframe Project Lead (Onsite)

Confidential

Responsibilities:

• Teh application provides different types of reports such as Account Executive Summary, Performance summary, Corporate Trust Fund, Top 10 holdings, Asset Allocation, Asset Allocation overtime, Portfolio Characteristics, Risk return analysis, holdings by discipline, Asset under Manager, CSV and Manager Performance
• Work demands high level technical and analysis skills in COBOL, DB2, JCL, VSAM, IMS DB and various mainframe tools etc., detailed knowledge of mainframe environment and user interactions.
• Analysis, root cause explanation and fix of daily production and QA issues.
• Develop design specification documents such as SRS, BRD, HLD and LLD for projects
• Project coordination and Quality Assurance.
• Timely communication clients and response to User queries
• Knowledge transition and process improvement.
• Impact analysis and documentation, Review of Design and Code and Unit test plan.
• Coordinate Defect Prevention Meeting and maintain Defect log.
• Involved in teh design of teh database for respective modules and developed Stored Procedures & Cursors using DB2.
• Involved in application support and bug fixes.
• Support System Testing and User Acceptance Testing
• Create Ad hoc Job for data update and reports
• Assist with defining and documenting user requirements
• Assist with development of user manuals, procedure and documents
• Provide leadership, work guidance and to less experienced personnel
• Interact with customers and team members to clarify requirements

Mainframe Project Lead (Onsite)

Confidential

Responsibilities:

• Promoting teh Table changes using DSS (Distributed Sub System) from Development to QA and production regions. Proactive Maintenance project mainly concentrates in Performance Optimization and to ensure MIPS reduction
• Responsible for all teh phases of SDLC Life Cycle from requirement phase to design, code, test, debug and documentation.
• Work demands high level technical and analysis skills in Informatica, Cobol, Oracle, VSAM, DB2, CICS, MS Office, MS Excel Macros, File aid, DB2 Explain, DF Sort, Data Analysis, Data profiling, Data cleansing/Integrity and various mainframe tools etc., detailed knowledge of mainframe environment and user interactions.
• Analysis, root cause explanation and fix of daily production issues.
• Analysis and Understanding teh requirements & functional specifications.
• Preparation of Technical Specifications based on teh existing functionality and requirements.
• Problem Diagnosis and working with other engineering groups.
• Prepared test cases, test data and performed Unit, System and UAT testing.
• Perform Peer review and log any issues and track till it is closed.
• Status Reporting and Responsible for teh final delivery. Organize Quality assurance meeting.
• Perform HLD, Code and Test case review.
• Utilized DB2 utilities to load and unload teh tables & also did some performance tuning utilizing teh analysis generated by teh DB2 EXPLAIN function
• Development and Maintenance are done on IBM Mainframe Platform
• Preparation of teh Test Plan and review of Test Cases (Unit, Integrated & System).
• Involved in various status meetings, scrum calls, Quality meetings, Risk meetings.
• Data validation, Business rule validation, Data Classification and mapping.
• VSAM to DB2 conversion

Sr. Mainframe Developer (Onsite and Offshore)

Confidential

Responsibilities:

• Work demands high level technical and analysis skills in COBOL, JCL, VSAM, DB2, IMS DB, CICS, Water fall, UNIX, TSO, Windows/DOS batch script, MS Office, MS Visio, CA tools, MS, DB2 Cursor, Copybook generation, DB2 Explain, DF Sort and various mainframe tools etc., detailed knowledge of mainframe environment and user interactions.
• Analysis, root cause explanation and fix of daily production issues.
• Teh Production Compensation and Broker Licensing application calculates Compensation for Producers or Brokers and maintains Broker licensing information
• Perform technical design and hands-on coding for development and enhancement efforts.
• Interacting with Business Analysts, getting teh requirements and prepare technical documents.
• Creating new online programs, batch programs, JCL, testing by programmers and users.
• Doing Code reviews, validating and verifying Test results delivered by other team members.
• Maintaining teh existing system included making user requested changes/enhancements.
• Developing CICS screens and COBOL programs to invoke by transactions.
• Created monthly Compensation reports for producers to put on servers for customer access.
• Accessing data from VSAM, DB2 and IMS DB databases.
• Monitoring teh SQL statement performance in Omegamon and tuning teh SQL queries.
• Developing teh COBOL programs to read data from IMS DB and DB2 databases to process and generate reports.
• Providing 24X7 On-call Production support and fixing teh production abends.

Senior Programmer Analyst (Offshore)

Confidential

Responsibilities:

• Requirement analysis and Design. Maintenance & Enhancement of legacy components.
• Analyze teh requirement and create Technical Specification
• Development in COBOL, JCL, DB2, VSAM, CICS, DB2 Stored procedures.
• Testing of COBOL programs, JCLs, Db2 SQLs and Implementation.
• Project runs on IBM Mainframe platform. Code review and Defect fixing.

Senior Software Developer (Offshore)

Confidential

Responsibilities:

• Interpreted teh requirements of business into design solutions.
• Reported daily status to Technical Delivery Managers and Management.
• Doing code changes, testing and implementation to production.
• Support, enhancement or maintenance existing applications.
• Coordinated with teh operations areas and lines of business to spot out and specify complex business requirements and processes
• Make recommendations, researches and find out alternative solutions
• Development in Cobol, JCL, DB2, VSAM, CICS, REXX, CLIST, DB2 Stored Procedures
• Project runs on IBM Mainframe platform. Code review and Defect fixing.

Programmer Analyst (Offshore)

Confidential

Responsibilities:

• Consults with internal business groups to provide appropriate application software development services or technical support.
• Analyzes, defines and documents requirements for data, workflow, logical processes, interfaces with other systems, internal and external checks, controls, and outputs.
• Analyzing teh Customer requests and preparing HLD or LLD design documents.
• Doing Code changes, Unit, System, integration testing and Code Peer reviews.
• Implemented teh Code changes in production and scheduling of jobs.
• Peer reviews of teh Code changes and Test results. Developed CICS Maps using SDFII Tool.
• Maintaining teh existing system included making user requested changes/enhancements and being on call to take care of any issues dat arise.
• Cobol, JCL, VSAM, DB2, CICS, MS Office, MS, DB2 Cursor, DF Sort, CA-7, z/OS, REXX, TSO, Microsoft Visio.