PROFESSIONAL SUMMARY

• Having 10 + years of IT industry experience with 6+ years of experience in Development and Testing of ETL applications, Involving extraction, transformation and loading using Ab Initio and 5 years of experience in Development and Testing of Mainframe Applications.
• Having extensive experience in Banking and Finance Domain.
• Having extensive experience in System Analysis Design, Development, Testing, Supporting and Implementation in AbInitio Technology and Mainframe Application
• Experience in development of business applications for Data Warehouse Systems.
• Currently working in Richmond VA as Lead Ab Initio Developer for Confidential .
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Experience in project planning, strategic planning, systems analysis and troubleshooting, quality control, scheduling and planning and tracking of results.
• Experience with AbInitio Co - operating System in application tuning and debugging strategies.
• Experience in all components in teh GDE of AbInitio for creating, executing, testing and maintaining graphs inAbInitio.
• Worked on automate routine tasks using UNIX shell scripting and a good experience in SQL.
• Ability to work in a geographically distributed virtual team environment and to build relationships with internal and external organizations.
• Experience on System, System Integration, Regression, Functional and Migration testing of various ETL applications
• Experienced in performing Functional, UI, Integration Testing and Regression testing
• Well acquainted with SDLC and Agile Model (SCRUM Process)
• Proficiency on Automation tools - Quality Center 10, Test manager and Manual Tester
• Flexible, enthusiastic and project oriented team player with good communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS:

ETL: Ab Initio GDE(1.13,1.15and 3.03), Ab Initio Co>Op (2.13,2.15 and 3.15)

Languages: COBOL,JCL,XML,C,C++,shell scripting, Eztrive

O/S: UNIX,MVS,Z/OS

Databases: DB2,SQL, Oracle, Teradata and IMS DB

Tools: Control-M, Job Track, Change man, Endeavour, Xpeditor, Quality Center 10

Business Domains: Banking and Finance, Insurance

Modeling Tools: MS Visio

PROFESSIONAL EXPERIENCE

Lead Ab Initio Developer

Confidential, Richmond VA

Hardware/Software: Ab Initio (GDE (1.13, 1.15and 3.03) and Co>Op (2.13, 2.15 and 3.15)), UNIX, DB2, Teradata, shell scripting and Mainframes.

Responsibilities:

• Working as ETL Developer in understanding teh requirements of teh End Users/Business Analysts and developing applications for ETL Process using Ab Initio and Mainframe process using COBOL, JCL.
• Participated in business, detail design and technical specification documentation for client’s standards, procedures and naming conventions.
• Working closely with teh Clients and teh Business partner of teh clients.
• Understanding client requirements and providing functional insights
• Providing teh technical solutions for teh business requirements
• Planning for all teh phases of teh project and tracking teh status of teh project at each phase
• Issue resolution/ Risk Mitigation and status reporting of teh project activities
• Developed ETL code using Abinitio Tool to load data from cross platforms into ODS and BDW Tables where teh data will be extracted for reporting purpose.
• Coding, Code Review, Creating Test Strategy & Testing. Testing involves both Unit & Integration Testing.
• Supported Testing Team in providing data, loading teh Data in Test Environment, provided SQL’s for testing teh Test cases.
• Worked in Scrum & Agile Methodology Environment.

Technical Lead & Lead Ab Initio Developer

Confidential, Houston, TX / India( Chennai)

Hardware/Software: Ab Initio (GDE (1.13, 1.15and 3.03) and Co>Op (2.13, 2.15 and 3.15)), UNIX, DB2, shell scripting and Mainframes.

Responsibilities:

• Working as an Onsite Technical Lead in understanding teh requirements of teh End Users/Business Analysts and developing applications for ETL Process using Ab Initio and Mainframe process using COBOL, JCL.
• Responsible for leading teh project team in delivering solution to our clients on target date.
• Participated in business, detail design and technical specification documentation for clients standards, procedures and naming conventions, worked under teh AMEX and SYNTEL Standards.
• Requirement Gathering, working closely with teh Clients and teh Business partner of teh clients.
• Understanding client requirements and providing functional insights
• Providing teh technical solutions for teh business requirements
• Preparation of Estimation for projects
• Planning for all teh phases of teh project and tacking teh status of teh project at each phase
• Issue resolution/ Risk Mitigation and status reporting of teh project activities
• Leading teh technical team coordinating efforts towards analysis, design, preparation of functional specification documents and detail design documents.
• Developed ETL code using Abinitio Tool to load data from cross platforms into DB2 Tables where teh data will be extracted for reporting purpose.
• Coding, Code Review, Creating Test Strategy & Testing. Testing involves both Unit & Integration Testing.
• Supported Testing Team in providing data, loading teh Data in Test Environment, provided SQL’s for testing teh Test cases.
• Involved in preparing project documentation outlining teh whole process and project reports.
• Co-ordination with onsite and offshore Tech team to meet teh expectation of teh Clients
• Worked in Scrum & Agile Methodology Environment.

Technical Lead & Lead Mainframe Developer

Confidential, Phoenix AZ

Hardware/Software:COBOL, JCL, Eztrive, IMSDB, DB2, VSAM, IMSDC, FILE-Aid, Changeman, Xpeditor, CC/CR Menu, Work Bench, CAC and Quality Center 10

Responsibilities:

• Participated in business, detail design and technical specification documentation for clients standards, procedures and naming conventions, worked under teh AMEX and SYNTEL Standards.
• Requirement Gathering, working closely with teh Clients and teh Business partner of teh clients.
• Understanding client requirements and providing functional insights
• Providing teh technical solutions for teh business requirements
• Preparation of Estimation for projects
• Planning for all teh phases of teh project and tacking teh status of teh project at each phase
• Issue resolution/ Risk Mitigation and status reporting of teh project activities
• Leading teh technical team coordinating efforts towards analysis, design, preparation of functional specification documents and detail design documents.
• Coding, Code Review, Creating Test Strategy & Testing. Testing involves both Unit & Integration Testing.
• Supported Testing Team in providing data, loading teh Data in Test Environment, provided SQL’s for testing teh Test cases.
• Involved in preparing project documentation outlining teh whole process and project reports.
• Co-ordination with onsite and offshore Tech team to meet teh expectation of teh Clients
• Estimation and design of teh proposed work.
• Understanding client requirements and providing functional insights.
• Coding, code review, creating test strategy & testing.
• Testing involves both Unit &Integration testing.
• Responsible for coordinating with onsite.
• Involve in all teh phases of unit and integration testing
• Perform impact analysis on tool change requests.
• Prepare tool specification documentation.
• Preparing change specification documents.
• Analyses of teh tool output.

Software Engineer & Mainframe Developer

Confidential

Hardware/Software: COBOL, JCL DB2, VSAM, FILE-Aid and Xpeditor.

Responsibilities:

• Understanding client requirements and providing functional insights for incorporating client’s requirement in Mainframes.
• Coding of Application Program as per teh analyzed document to effect teh new logic and necessities.
• JCL Job creations for compiling and running teh programs.
• Testing of teh new functionality in case of implementing changes.
• Testing and documentation all new type of requests for future reference.
• Created Unit test plan, which covers all logical condition.
• Resolving teh defects and teh issues during testing phase.
• Recorded teh unit test results as per teh Standards.
• Analyze, Design, Develop & test activities in Cobol,CICS,DB2
• JCL job’s creation to compile and run COBOL db2 programs.
• Documenting and coordinating project activities for internal noledge base.
• Resolving project related issues during design and testing.
• Creation of High level and Detailed level flow diagrams for programs.
• Creating bind strategies and running bind jobs.