SUMMARY

• 13+ years of professional experience in successfully developing and implementing a wide range of data warehousing solutions in BFS, Insurance, Telecom and Health care.
• Experience in managing team at offshore. Also worked as Onsite Coordinator.
• Experience in design, requirement analysis, data analysis, preparation of Technical Design Documents and providing ETL solutions for business cases.
• Exposure in preparation of ETL transformation mapping sheet.
• Extensively worked on Ab Initio GDE Batch processing, plans with experience on UNIX and Database like Teradata, Oracle, Sql server, Netezza
• Developed generic graphs and reusable components.
• Worked on Autosys for job creation, scheduling and monitoring
• Exposure to quality standards and quality procedures followed in IT Projects
• Ability to learn new as well as advancements in technologies and apply them effectively
• Proficient in Agile and waterfall methodology of project lifecycles
• Good exposure to data warehousing concepts.
• Excellent communications skills, comfortable in fast paced challenging environments.
• Mentoring and Guide ETL Team during the day to day project activities.
• Having Well - rounded understanding of database and data warehousing technologies and good understanding of operation environments that the ETL tool runs on

TECHNICAL SKILLS

Programming Languages: Unix - Shell scripting, Basic python

Operating System: Unix / Windows

Tools: /Packages: Ab Initio (GDE), Autosys (Scheduler),Toad, Quality Center

Databases: Oracle, Netezza, Teradata

PROFESSIONAL EXPERIENCE

Confidential

Offshore ETL Tech Lead

Responsibilities:

• Analysis of Business Requirements and Understanding the business model and customer requirements.
• Coordination with on-site team to understand the requirement.
• Understanding systems with respect to different Lines of Business and preparation of various understanding documents.
• Coordinating with team members to effectively carry out all project activities such as analysis & design, coding, integration and testing.
• Analyzed the sources, targets, transformed the data, mapped the data and loading data into targets using Ab Initio.
• Extensively used Ab Initio GDE and plans to develop the processes for extracting, transforming, integrating and loading data from various sources into Data Warehouse.
• Involved in testing the project in various phases of development as well as implementation.
• Schedule and run the jobs using Autosys.
• Leading offshore team - task and work allocation, scorecard preparation, Design, Development, Release Management, Production support, Devops and supporting application in all environments.

Technologies: Ab Initio, Teradata, Sql Server, Unix, Quality Center

Confidential

Technical Lead

Responsibilities:

• Mentoring the Jr.ETL Team member.
• Preparation of Technical Design Document after requirement understanding based on the source to target mappings.
• Understand and enhance Complex transformation graphs based on the domain (e.g. Customer, Account etc.) to derive new fields and to solve various business requirements.
• Worked on ACE and BRE for the Core data acquisition.
• Involved in the documentation work related to the SIT / UAT deployment activities.

Technologies: Ab Initio (ETL), UNIX, Netezza, Quality Center

Confidential

ETL Team Lead/ Sr.Ab Initio Developer

Responsibilities:

• Mentoring the ETL Team.
• Preparation of Technical Design Document after requirement understanding based on the source to target mappings.
• Preparation of ETL Supplementary mapping sheet.
• Developing the graphs, plans and wrappers for the ETL part of the project using the ETL tool AbInitio.
• Developed Complex transformation graphs based on the domain (e.g. Customer, Account etc.) to derive new fields and to solve various business requirements.
• Developed reusable component for handling Audit and Error logging.
• Preparing Unit test cases and performing the Unit testing.
• Guide team members during the day to day project activities.
• Review the Ab initio graphs developed by the team members.
• Worked as primary contact for the System Integration Testing Team (SIT) and guide them with the business requirements.
• Analyzing the Defects and coordinating with the testing team.
• Involved in the documentation work related to the SIT / UAT deployment activities.

Technologies: Ab Initio (ETL), UNIX, Oracle, Quality Center

Confidential

Sr. Ab Initio Developer

Responsibilities:

• Preparation of Technical Design Document after requirement understanding based on the source to target mappings.
• Preparation of ETL Supplementary mapping sheet.
• Developing the graphs, plans and wrappers for the ETL part of the project using the ETL tool Ab Initio.
• Developed Complex transformation graphs based on the domain (e.g. Customer, Account, Market Hierarchy etc.) to derive new fields and to solve various business requirements.
• Developed reusable component for handling Audit and Error logging.
• Preparing Unit test cases and performing the Unit testing.
• Guide team members during the day to day project activities.
• Review the Ab initio graphs developed by the team members.
• Worked as primary contact for the System Integration Testing Team (SIT) and guide them with the business requirements.
• Analyzing the Defects and coordinating with the testing team.
• Involved in the documentation work related to the SIT / UAT deployment activities.

Technologies: Ab Initio (ETL), UNIX, Oracle, Quality Center

Confidential

Sr. Ab Initio Developer

Responsibilities:

• Worked on ICFF, normal lookups, XML processing, continuous graphs and reusable batch graphs.
• Developed number of Ab Initio data extracting graphs, transform graphs and loading graphs using various Ab Initio Components such as transform components, partition components, sort components, datasets component, validate components and compress components etc.
• Developed Complex Ab Initio XFRs to derive new fields and to solve various business requirements.
• Experienced using Ab Initio functions such as string functions, date functions, lookup functions, miscellaneous functions, inquiry and error functions and math functions etc.
• Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check in and checkout were used for this purpose.
• Used Ab Initio Parallelism techniques, phases and checkpoints.
• Prepared UTPs (Unit tests plans) for the Ab Initio Graphs those were developed.
• Worked on the project from the beginning and on advance ab initio components.
• Worked as an individual contributor to the project as a content owner.

Technologies: Ab Initio, UNIX, Jenkins, JIRA

Confidential

Sr. Ab Initio Developer

Responsibilities:

• Analysis of the specifications provided by the clients
• Design and Development of code.
• Coding using Ab Initio.
• Database management.
• Testing - unit testing.
• Responsible for overseeing the Quality procedures related to the project.
• Checking whether all the functionalities are met or not as per the requirement.
• Creating packages and implementation of the project.

Technologies: Ab Initio, Oracle 10g

Confidential

Team lead

Responsibilities:

• Analysis of the specifications provided by the clients
• Design and Development of code and 3rd line Support to the Application.
• Coding using Ab Initio
• Database management
• Testing - unit testing.
• Responsible for overseeing the Quality procedures related to the project.
• Checking whether all the functionalities are met or not
• Raising Change Request through Query center.
• Incident Management.
• Live job monitoring
• Proper coordination with my Team member.

Technologies: Ab Initio, Oracle, Quality Center

Confidential

Designer/ Sr. Developer / Onsite Coordinator

Responsibilities:

• Low Level Design for the PMF Integration Layer using Ab-Initio Framework & java framework.
• As a Adapter Designer, understand the high level requirement and then based on the requirement preparation of the low level Adapter design document for each User Story using Abinitio Framework.
• As part of Design roler, prepare the design document for user stories using Abinitio, JAVA & BPEL Framework
• Providing Solution to End To End Issues related to integration Layer.
• Coordination between High Level Design & Development Team
• Development of Ab-initio graphs (Batch graphs).
• Developing PL/SQL Stored Procedures which are invoked by the Ab-initio Graphs.
• Parsing/Generating XMLs via Ab-initio.
• Configuring the EME environment, Checking in & checking out codes to/from the EME Repository.
• Coordination with offshore development and testing team.
• Interaction with Client to validate the requirement scope.
• Preparation dashboard reporting for status update.

Technologies: Ab Initio, TOAD, Windchill, Oracle PIM, Starteam

Confidential

Developer

Responsibilities:

• Development of Ab-initio graphs (Batch & Contiguous graphs).
• Developing PL/SQL Stored Procedures which are invoked by the Ab-initio Graphs.
• Configuring the EME enviroment, Checking in & checking out codes to/from the EME Repository

Technologies: Ab Initio, TOAD, Starteam, Actuate