PROFESSIONAL SUMMARY:

• Having 11 + years of IT industry experience with 8+ 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 Charlotte NC as Ab Initio Lead for Synechron for Wells Fargo Client.
• 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 the GDE of AbInitio for creating, executing, testing and maintaining graphs in
• 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), BRE, Express>IT.

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

O/S: UNIX, MVS, Z/OS

Databases: DB2, SQL, Oracle and IMS DB

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

Business Domains: Banking and Finance, Insurance

Modeling Tools: MS Visio

PROFESSIONAL EXPERIENCE:

Ab Initio Lead

Confidential, Charlotte NC

Hardware/Software: Ab Initio (GDE (3.12) and Co>Op (3.15)), Linux, Teradata, SQL Server2014, BRE, XML, shell scripting, Conduct>IT, AutoSys, Op Console.

Responsibilities:

• Working as Ab Initio Lead in understanding the requirements from the business team and the technology team and developing applications for ETL Process using Ab Initio and SQL Server 2014.
• Participated in business, detail design and technical specification documentation for client’s standards, procedures and naming conventions.
• Working closely with the Business partner of the clients.
• Understanding client requirements and providing functional insights
• Providing the technical solutions for the business requirements
• Preparation of Estimation for project.
• Planning for all the phases of the project and tracking the status of the project at each phase
• Issue resolution/ Risk Mitigation and status reporting of the project activities
• Used Express>IT to create the Business rule transformations for Ab Initio.
• Converting the existing reports in SSRS to Abinitio and Linux based code. Micro Strategy will be used to generate reports on top of that.
• Leading the technical team coordinating efforts towards analysis, design, preparation of functional specification documents and detail design documents.
• Involved in preparing project documentation outlining the whole process and project reports.
• Co-ordination with onsite and offshore Tech team to meet the expectation of the Client.
• Coding, Code Review, Creating Test Strategy & Testing. Testing involves both Unit & Integration Testing.
• Supported Testing Team in providing data, loading the Data in Test Environment, provided SQL’s for testing the Test cases.
• Worked Agile Methodology Environment.

Lead Ab Initio Consultant

Confidential, Columbus OH

Hardware/Software: Ab Initio (GDE (3.12) and Co>Op (3.15)), Linux, Teradata, Oracle, BRE, XML, shell scripting, Conduct>IT, Control-M, Op Console and Mainframes.

Responsibilities:

• Working as ETL Consultant in understanding the requirements of the 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.
• Developed ETL process using generic graph to extract various tables from differing sources i.e SQL Server and Oracle and Teradata.
• Working closely with the Business partner of the clients.
• Understanding client requirements and providing functional insights
• Providing the technical solutions for the business requirements
• Planning for all the phases of the project and tracking the status of the project at each phase
• Issue resolution/ Risk Mitigation and status reporting of the project activities
• Developed ETL code using Abinitio Tool to create custom XML reports and statements for the clients.
• Converting the existing reports in MVS to Abinitio and Linux based code.
• Coding, Code Review, Creating Test Strategy & Testing. Testing involves both Unit & Integration Testing.
• Supported Testing Team in providing data, loading the Data in Test Environment, provided SQL’s for testing the Test cases.
• Worked in both SDLC and Agile Methodology Environment.

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)), Conduct> IT,UNIX, DB2, Teradata, shell scripting and Mainframes.

Responsibilities:

• Working as ETL Developer in understanding the requirements of the 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 the Clients and the Business partner of the clients.
• Understanding client requirements and providing functional insights
• Providing the technical solutions for the business requirements
• Planning for all the phases of the project and tracking the status of the project at each phase
• Issue resolution/ Risk Mitigation and status reporting of the project activities
• Developed ETL code using Abinitio Tool to load data from cross platforms into ODS and BDW Tables where the 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 the Data in Test Environment, provided SQL’s for testing the Test cases.
• Worked in Scrum & Agile Methodology Environment.

Technical Lead & Lead Ab Initio Developer

Confidential, Houston, TX

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 the requirements of the End Users/Business Analysts and developing applications for ETL Process using Ab Initio and Mainframe process using COBOL, JCL.
• Responsible for leading the 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 the AMEX and SYNTEL Standards.
• Requirement Gathering, working closely with the Clients and the Business partner of the clients.
• Understanding client requirements and providing functional insights
• Providing the technical solutions for the business requirements
• Preparation of Estimation for projects
• Planning for all the phases of the project and tacking the status of the project at each phase
• Issue resolution/ Risk Mitigation and status reporting of the project activities
• Leading the 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 the 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 the Data in Test Environment, provided SQL’s for testing the Test cases.
• Involved in preparing project documentation outlining the whole process and project reports.
• Co-ordination with onsite and offshore Tech team to meet the expectation of the Clients
• Worked in Scrum & Agile Methodology Environment.

Technical Lead & Lead Mainframe Developer

Confidential

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 the AMEX and SYNTEL Standards.
• Requirement Gathering, working closely with the Clients and the Business partner of the clients.
• Understanding client requirements and providing functional insights
• Providing the technical solutions for the business requirements
• Preparation of Estimation for projects
• Planning for all the phases of the project and tacking the status of the project at each phase
• Issue resolution/ Risk Mitigation and status reporting of the project activities
• Leading the 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 the Data in Test Environment, provided SQL’s for testing the Test cases.
• Involved in preparing project documentation outlining the whole process and project reports.
• Co-ordination with onsite and offshore Tech team to meet the expectation of the Client.

Senior Software Engineer & Mainframe Developer

Confidential

Hardware/Software: COBOL, JCL DB2, VSAM, FILE-Aid, Endeavor, Xpeditor, Bench Mark and MQ Series

Responsibilities:

• Estimation and design of the 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 the phases of unit and integration testing
• Perform impact analysis on tool change requests.
• Prepare tool specification documentation.
• Preparing change specification documents.
• Analyses of the 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 the analyzed document to affect the new logic and necessities.
• JCL Job creations for compiling and running the programs.
• Testing of the new functionality in case of implementing changes.
• Testing and documentation all new type of requests for future .
• Created Unit test plan, which covers all logical condition.
• Resolving the defects and the issues during testing phase.
• Recorded the unit test results as per the Standards.

Software Engineer & Mainframe Developer

Confidential

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

Responsibilities:

• 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 knowledge 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.