SUMMARY:

• Over 8 years of professional experience in Data warehousing domain involving in various phases of ETL Project software development including system analysis, design, development, testing, and implementation.
• Domain knowledge in Banking and Financial Services industries.
• Extensive experience in Ab inito (3.2.5),Co - Operating system, EME, CA7 job scheduler, Abinitio MHUB and Abinitio Control center.
• Good programming skills in SQL, PL/SQL and UNIX shell scripting.
• Experience in providing High Level Design and Low Level Design for ETL solutions.
• Expertise in data analysis, profiling data, development and implementation of ETL applications.
• Hands-on practical experience with various Ab Initio component groups such as Transform (Join, Rollup, Scan, Reformat), Partition, Sort, Validate, database and FTP etc.
• Well versed with various Ab Initio parallelism techniques and implemented Ab Initio graphs using Data parallelism with Multi File System (MFS) techniques and component parallelism.
• Hands on experience in end-to-end of Data warehousing ETL routines, which includes requirements gathering, developing Ab Initio graphs, code migrations, SIT/FIT/CAT testing support, performance testing process and install/warranty support.
• Designed and deployed well-tuned Ab Initio graphs (Generic and Custom) from UNIX environment.
• Experience in data integration from various sources like Oracle,DB2EEE, Mainframe and Flat files.
• Excellent programming skills with ability to automate routine tasks and experience in SQL.
• Strong knowledge of Data Warehousing and Dimensional modeling concepts.
• Extensive hands on experience on Unix programming and worked on database tools such as SQL Developer and TOAD.
• Has flair to adapt to new software applications/technologies and products, self-starter, has good communication and understanding skill of business workflow.
• Effective team player with excellent problem solving abilities, a willing and quick learner with strong technical skills.
• Worked as ETL technical lead by managing Offshore team and delivered ETL solutions in various releases and worked closely with Client and release management on progress, also worked with multiple XWS, testing, release teams to understand/support road blocks if any.
• Good Understanding of the Hadoop Distributed File System and Ecosystem and Involved in processing data from UNIX file system to HDFS and vice versa.
• Working experience in HDFS, SQOOP and HIVE. Have fair understanding of Hadoop echo system concepts.
• Skilled in managing & developing ETL solutions in both waterfall and Agile SDLC models.
• Co-ordinated & worked with the offshore teams, Expertise in mentoring the team, code reviews, building reusable utilities, defining coding standards and performance optimization techniques.

TECHNICAL SKILLS:

ETL Tool: Ab-Initio 3.2.5, CO>OP, EME, MHUB, AI Control center

Databases: Oracle 12, DB2EEE

Operating System: UNIX, Windows XP/2007,2010

GUI Tools: Oracle SQL Developer, Toad

Programming Languages: C, C++, Core JAVA Concepts, PL/SQL

Defect Tracking: ALM

Development Tools: UNIX Shell Scripts

Job Schedulers: Mainframe CA7, Tivoli

PROFESSIONAL EXPERIENCE:

Confidential

• Analyze business requirement, define development scope and develop technical specification documents.
• Analyze various ETL processes/applications to understand the ideal process to change in interest of less maintenance, stability, relevance to existing ETL application, cost optimization.
• Perform data profiling for better understanding of data, cleansing and build optimal transformations.
• Provide innovative ETL solution to business by exploring business needs.
• Develop generic ETL process as utilities for reusability using Ab Initio as the tool.
• Developed customized shell scripts to trigger Abinitio process in runtime. Involved in performance tuning of Ab Initio ETL graphs, processes and load routines.
• Taking ownership and accountability for the assigned deliverables thru all phases of the development lifecycle.
• Involved in developing generic graphs for extracting, transforming and loading the data from transaction DB to DIME(Unix). Transformation graphs includes most of transform group components.
• Understanding cross work stream application review/development sessions to assess impact analysis to current application.
• Coordinate and communicate tasks with Offshore developers and testers.
• Ensure that development/testing are performed as per requirements and communicate any gaps if identified.
• Be able to coordinate and work with multiple development teams, outside vendors and other support areas for making improvements in the nightly schedules or correcting bugs.
• Assists/oversees production implementation according to the defined release schedules and maintenance of the production, QA and Pre-prod environments.
• Owning the technology specific queries from application end users.
• Involved in discussions with the client’s project manager, PSO and other interfacing application teams to apprise the client about critical production issues and it’s analysis.
• Coordinating between the clients and the other project stakeholders for any requirements changes, clarifications and approvals.

Environment: Ab Initio GDE V3.2.5, DB2, Oracle 12 and Unix, Mainframe.

Confidential

• The responsibilities included understanding the requirements and analysis, design, Development, Unit testing, Support to SIT,CAT and implementing the solution.
• Extensively used Ab-Initio for construction of ETL graphs
• Developed several Unix automation utilities to construct psets and Dmls for framework graphs.
• Reviewed the developed code against client standards and delivered defect free code.
• Tested all the graphs involved and Prepared Unit Test Cases.
• Supported code migrations to next level environments and Warranty support on installs.

Environment: Ab Initio 3.2.1, Oracle, UNIX

Confidential

• Creation of Ab Initio graphs & Plans for data extraction from multiple transactional systems, transformation of data to clean & cleanse it and to add more info to it by joining it with other master data or dimension tables and loading this data to Oracle.
• Handling highly sensitive data by using encryption components or encryption flows in AI.
• Optimization of AI code to save the respective CPU resources.
• Supporting the peer developers in their development work and review their code.
• Performing unit testing by writing test plans to verify that all requirements have been met.
• Scheduling Mainframe CA7 Jobs to trigger the Ab initio plans by analyzing upstream & downstream dependencies.
• Supporting Integration and UAT Testing by coordinating with the testing team and fixing any code issues.
• Creating documents like TDD, Job scheduling sheet, post implementation activities and KT to PSO.
• Creating tags & raising work orders for code migrations to next level environments.
• Ensuring the post implementation activities has been done properly and defect analysis & fixing in prod if any by interacting with PSO / L1 teams.

Confidential

• Involved in gathering and analyzing requirements.
• Enhancement activities: Identify/implement enhancements to existing graphs/projects to meet the Business requirements.
• Creating graphs based on Business needs.
• Preparing the Impact Analysis form (IA) including all the details like impact modules, implementation process and estimations etc.
• Involved in preparing the documentations which supports post production.
• Created the Sandboxes in Development and as well as in Test Environment using the EME.
• Done Unit testing for newly developed Graphs or any other elements.

Technologies Used: Ab Initio, Unix .

Database: Oracle and Teradata.

Confidential

ETL-Developer

• Involved in gathering and analyzing requirement.
• Involved in preparing the Low Level Design Specifications.
• Developed the graphs using various components in Ab-Initio as per business requirements.
• Prepare and performed Unit test plan and Unit test cases.
• Resolving all issues raised by testing team which are related to the test TPs being handled by our team.
• Involved in SIT and support UAT.
• Involved in Raising work order for code deployment.

Technologies Used: Ab Initio, Unix .

Database: Oracle and Teradata.

Confidential

ETL-Developer

• Involved in gathering and analyzing requirement.
• Involved in preparing the Low Level Design Specifications.
• Involved in making graphs using various components in Ab-Initio.
• Developed unit test cases, prepared test data, performed unit testing & bug fixing.
• Implemented phasing to avoid dead locks and proper data loading.
• Review of the code to ensure client standards.

Technologies Used: Abinitio, Unix .

Database: Oracle.