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 teh existing ones.
• Extensive experience wif COBOL, DB2, JCL, SQL, Embedded SQL, Stored Procedures, IMS - DB, IMS-DC.
• Extensive experience wif SQL Query optimization and performance tuning.
• Extensive experience wif IBM’s ETL tool SAFR.
• Extensive experience wif tools like Endeavor, Panvalet, Zeke, CA-7, HP Quality center, BMC Remedy, File Aid, Rational Quality Manager etc.
• Extensive experience wif Relational Databases as DB2, physical data modeling and implementing teh model in cost TEMPeffective 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

Responsibilities:

• Meeting wif 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 wif Business for Code and Test case review.
• Allocation of tasks to offshore team members and preparation of estimation Document.
• Passing teh requirements to offshore team members and conducting regular calls to improvise teh 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 teh Code fix in Production.
• Working on Defect Tracking using HP Quality Center.
• Providing Level 2 support for teh existing system.

Confidential

Programmer

Responsibilities:

• Requirement gathering from teh 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 teh team.
• Converting new requirements to teh 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 teh 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 teh deliverables wif 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 teh evaluation of project understanding of new team members

Confidential

Team Lead

Responsibilities:

• Requirement gathering and preparation of RSD (Requirement Specification Document
• Conducting meetings wif 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 TEMPeffective manner.
• Involved in performance tuning of teh system.
• Involved in Quality Assurance Cycle for teh project. Maintained teh 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 teh team and distribution of tasks among team members
• Member of teh committee responsible for conducting weekly sessions and presentations on technical and domain side

Confidential

Module Lead

Responsibilities:

• Requirement gathering from clients and passing teh 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 teh DB2 queries on Claim Tables. Analysis of Indexing required for teh columns fetched quite frequently.
• Analysis of plan Analyzer output such as cardinality, filter factor, Number of index able Columns and CPU time.
• Analyzing teh need of cursors over singleton query, limiting teh 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 teh above outcome and moving them to production region
• Providing Level 2 support for teh clients. All teh 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 teh 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 teh team members
• Development and testing of new programs
• Modification and Enhancement of Programs
• Change of teh existing JCL/procedures/includes/copybooks
• Unit testing and preparation of test plan, test scripts, test cases.
• System testing by embedding new/modified code to teh system.
• Reviewing deliverables of peer/team member
• Conducting Mock Audits in teh team

Confidential

Team Member

Responsibilities:

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

Confidential

Team Member

Responsibilities:

• Requirement gathering from Client