SUMMARY

• Seven years of IT Experience in Mainframe Technology.
• Currently working as a Mainframe Developer/Lead for Confidential through Confidential .
• Worked for more than two years as a Mainframe Programmer/ETL developer for Confidential
• Worked for four Years as Programmer Analyst at various client locations for Confidential Inc.
• Worked primarily in Banking, Health Care and Retail Domain.
• Extensive experience in executing and leading Development, Maintenance and Enhancement projects using Waterfall Model and Agile Development Process.
• Extensive experience in coding and testing of new programs and enhancement of the existing ones.
• Extensive experience with COBOL, DB2, JCL, SQL, Embedded SQL, Stored Procedures, IMS - DB, IMS-DC.
• Extensive experience with SQL Query optimization and performance tuning.
• Extensive experience with IBM’s ETL tool SAFR.
• Extensive experience with tools like Endeavor, Panvalet, Zeke, CA-7, HP Quality center, BMC Remedy, File Aid, Rational Quality Manager etc.
• Extensive experience with Relational Databases as DB2, physical data modeling and implementing the model in cost effective manner.

TECHNICAL SKILLS

Operating System: Z/OS, MVS, Windows

Languages: COBOL, JCL, SQL, Easytrieve, DB2 Stored Procedures, IMS DC

Databases: DB2, IMS DB, VSAM

Other Tools: Endeavor, Zeke, File-Aid,CA-7,SPUFI, Panvalet, NDM, FTP, QMF, Expeditor

Quality Assurance Tools: HP Quality Center, BMC Remedy, Rational Quality Manager (RQM)

PROFESSIONAL EXPERIENCE

Confidential

Mainframe Programmer /Lead

Responsibilities:

• Meeting with Business for developments/enhancements and encapsulating requirements into standard template.
• Analysis of existing COBOL /DB2-SQL programs for defect fixes.
• Preparation of Approach Documents, Requirements Document and Pseudo code Document.
• Code changes in exiting COBOL DB2-SQL programs and enhancements of existing programs for addition required functionalities.
• Preparation of Unit test Plan and Unit test cases .
• Unit Testing and Regression Testing of programs using Cobol, JCL, Expeditor, SPUFI.
• Conducting Walk thru Meeting with Business for Code and Test case review.
• Allocation of tasks to offshore team members and preparation of estimation Document.
• Passing the requirements to offshore team members and conducting regular calls to improvise the quality of work delivered.
• Reviewing Code changes and Unit Test cases delivered by offshore team members.
• Preparation of Packages and Incident Creations in BMC Remedy to move the Code fix in Production.
• Working on Defect Tracking using HP Quality Center.
• Providing Level 2 support for the existing system.

Confidential

Programmer

Responsibilities:

• Requirement gathering from the client by conducting regular meetings and preparation of requirement specification documents.
• Involved in estimation and quality maintenance module using WBS (Work Breakdown Structure)
• Allocation of tasks to sub ordinate members in the team.
• Converting new requirements to the design by coding new Cobol DB2 Programs
• Performing batch testing using JCL.
• Performing various function on files using File-Aid, FTP, NDM.
• Providing Level 2 support for the existing system.
• Involved in various phases of Testing Life Cycle such as test plan preparation, test case design, test execution and defect tracking
• Involved in various phases of Project Life Cycle such as Design, Development, Production, and Hand-over and Post-Project maintenance
• Managing the deliverables with constraints of timeline and quality
• Maintenance of testing deliverables via RQM (Rational Quality Manager)
• Defect fixing using bug tracking system like Rational Clear quest
• Conducting code Walkthroughs
• Preparation of Understanding Documents(UDs) for new team members
• Preparation of Questioners and Assignments for the evaluation of project understanding of new team members

Confidential

Team Lead

Responsibilities:

• Requirement gathering and preparation of RSD (Requirement Specification Document
• Conducting meetings with clients for requirement gathering and revision of lower level design.
• Involved in estimation of task based on number of resources and task priority
• Analysis of requirement and Coding of new COBOL DB2, IMS-DB programs.
• Performance tuning for COBOL DB2 programs and SQL queries.
• Enhancement of existing programs in a cost effective manner.
• Involved in performance tuning of the system.
• Involved in Quality Assurance Cycle for the project. Maintained the document repository in chronological order per task
• Estimation of task using WBS (Work Breakdown Structure)
• Involved in various phases of Testing Life Cycle
• Preparation of Technical Design Documents using specific templates
• Peer to peer review of deliverables from team members
• Mentoring the team and distribution of tasks among team members
• Member of the committee responsible for conducting weekly sessions and presentations on technical and domain side

Confidential

Module Lead

Responsibilities:

• Requirement gathering from clients and passing the abstract to offshore team members in form of Requirement Specification Document (RSD)
• Preparation of Lower Level Design and skeleton for new developments
• Coding and Unit/System testing of new Cobol, DB2 Programs
• Reviewing deliverables from offshore team members
• Conducting code Walkthroughs on per task basis
• Performance tuning of the DB2 queries on Claim Tables. Analysis of Indexing required for the columns fetched quite frequently.
• Analysis of plan Analyzer output such as cardinality, filter factor, Number of index able Columns and CPU time.
• Analyzing the need of cursors over singleton query, limiting the need of sorting via Order By and Group By. Implementing correct type of index, using proper predicates while Join etc. Modification of Programs based on the above outcome and moving them to production region
• Providing Level 2 support for the clients. All the system level issues were Solved at our side and some trivial fixes were sent to offshore
• Preparation of Domain Glossary which was later served as a basic level understanding document for the new team members
• Enhancement of existing programs and coding of adhoc Cobol DB2 Programs

Confidential

Team Member

Responsibilities:

• Requirement gathering and preparation of Requirement Specification Document (RSD)on task basis
• Estimation of tasks and subtasks based on resources and priority of work.
• Allocation of tasks to the team members
• Development and testing of new programs
• Modification and Enhancement of Programs
• Change of the existing JCL/procedures/includes/copybooks
• Unit testing and preparation of test plan, test scripts, test cases.
• System testing by embedding new/modified code to the system.
• Reviewing deliverables of peer/team member
• Conducting Mock Audits in the team

Confidential

Team Member

Responsibilities:

• Development of new programs based on Requirement Specification Document.
• Lower Level Design
• Coding new Cobol-DB2 Stored Procedures using the embedded SQL and working on the performance of the whole system. By applying normalization techniques and proper constraints tried to upgrade the performance of the chain of programs. The newly developed programs proved to be efficient in reducing the cost and the CPU time involved as compared to the previous system.
• Preparing test plan and test result covering Unit testing to Integration Testing
• Involved in Delivery Co-Ordination between Onsite & Offshore Teams
• Following the Project Development Life Cycle for each task

Confidential

Team Member

Responsibilities:

• Requirement gathering from Client