SUMMARY

• Over 8.2 years of experience with development in complex and high volume Ab - initio ETL applications including requirement gathering, design, implementation, unit testing, debugging, documentation under Unix Environment. Good experience in leadership. Excellent Data warehousing technical skill set with robust knowledge of DWH architecture.
• Hands on experience on generic graph implementation, advanced Ab-initio components, psets, plans and Ab-initio product tools like Ab-initio GDE, Cooperating system, EME Technical Repository, PDL meta programming, XML data processing, Strong experience in both waterfall as well as agile methodology.
• Experience in requirement gathering, impact analysis, data cleansing, data transformations, data relationships, source systems analysis.
• Adequate knowledge and experience of Data Mart, Data Modeling, Dimensional Modeling, OLTP, OLAP, star schema, snowflake schema, data warehousing concepts, fact and dimensions tables, logical and physical data modeling, ETL processes, SCD, data analysis, surrogate keys and normalization/de-normalization.
• Strong working experience in RDBMS development using Oracle and SQL and large scale database management including building and tuning complex SQL queries.
• Good exposure to UNIX shell scripting, commands, problem solving and analytical capabilities.
• Good experience in various kinds of testing like Unit testing, Regression testing, and System integration testing including preparation of test plan, creation of test cases, test case documents, test data creation.
• Involved in Business requirement meetings with Business Users and prepared Technical Design Document for ETL development Process.
• Provide a proactive approach to supporting the production environment including presenting ideas to automate manual tasks and reduce the team workload
• Developed Mappings using Type 1, Type 2, and Type 3 SCD logic to load data into Dimension tables.
• Experience in Scheduling the Ab-initio graphs through scheduling tool like Tivoli and wrapper script.
• Sound understanding of Informatica ETL tool.
• Extensive knowledge and experience of Banking and Financial, insurance Domain applications.
• Experience in providing 24*7 Production Support and real time issue resolution for ETL applications.
• Excellent communication, interpersonal skills and strong ability to work as part of a team and as well as handle independent roles with positive attitude towards responsibilities and challenges.

TECHNICAL SKILLS

Platforms: Windows 98/XP/7, UNIX

DW Technology: Ab Initio 2.14, 2.15 and 3.0,3,1

Key skills: Ab-initio, Unix scripting, Data warehouse, Database

Databases: Oracle, SQL

Additional Skills: Agile Technology, Informatica ETL tool

PROFESSIONAL EXPERIENCE

Confidential

Onsite coordinator /Ab-initio Developer / Module lead

Environment: Ab-initio, Unix

Responsibilities:

• Implemented end to end Ab-initio applications for one of the Individual extract application, process to auto generate and send statistics consolidated report for all extract using Abinitio graphs, psets, plans, Unix Shell scripting.
• Requirement gathering by interacting with client/business, creating impact analysis and design documents, proposing solutions, defect fixing and estimating the hours. Working proactively and independently to articulate issues/challenges to address project delivery risks.
• Worked in onsite-offshore model and lead onsite team of 5 people.
• Interact with release management, configuration management and quality assurance, database modeling support, other upstream and downstream development teams and operation support team.
• Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
• Providing unit testing, module testing, and regression testing and system integration testing of the scripts, graphs, psets, plans and queries.
• Code reviews to ensure code developed meets the requirements.
• Provide KT sessions, preparing documentation, mentoring junior resources.
• Performed lead level activities and independently handled various modules
• Developed generic graphs and created conduct>it plan which takes care of the entire BDW 2.0 execution from source to target jobs.
• Involved in requirement analysis and prepared the technical design document.
• Supported the SIT, OAT and LIVE activities
• Analyzing and fixing the SIT and UAT defects

Confidential

Ab-initio Developer / Module lead

Environment: Ab-initio, Unix

Responsibilities:

• Requirement gathering by interacting with client/business, creating impact analysis and design documents, proposing solutions, defect fixing and estimating the hours. Working proactively and independently to articulate issues/challenges to address project delivery risks.
• Involved in requirement gathering meetings, data planning, client meetings to understand the new requirements, existing applications problems.
• Prepared impact analysis and design documents, proposing solutions, defect fixing and estimating the hours.
• Working proactively and independently to articulate issues/challenges to address project delivery risks.
• Worked in onsite-offshore model and coordinating team of 6 members from onshore.
• Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
• Providing unit testing, module testing, and regression testing and system integration testing of the scripts, graphs, psets, plans and queries
• Performed module lead level activities and independently handled various modules
• Preparation of unit test plan and review checklist document
• Supported the SIT, OAT and LIVE activities
• Analyzing and fixing the SIT and UAT defects

Confidential

Ab-initio Developer / Module lead

Environment: Ab-initio, Unix

Responsibilities:

• Responsible for handling different project modules independently.
• Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
• Prepared impact analysis and design documents, proposing solutions, defect fixing and estimating the hours.
• Working proactively and independently to articulate issues/challenges to address project delivery risks.
• Providing unit testing, module testing, and regression testing and system integration testing of the scripts, graphs, psets, plans and queries
• Worked on Agile technology
• Worked on MDM data warehousing tool
• Responsible for Requirement Analysis and Development of graphs and validation of processed data through ETL.
• Supported SIT, OAT and LIVE activities.
• Responsible for handling end-to-end process starting from Development till Live
• Interaction with other teams across companies for project related work / issues

Confidential

Ab-initio Developer

Environment: Ab-initio, Unix

Responsibilities:

• Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
• Providing unit testing, module testing, and regression testing and system integration testing of the scripts, graphs, psets, plans and queries
• Involved in requirement gathering meetings, data planning, client meetings to understand the new requirements, existing applications problems.
• Prepared impact analysis and design documents, proposing solutions, defect fixing and estimating the hours.
• Working proactively and independently to articulate issues/challenges to address project delivery risks.
• Performed testing and prepared UTPs (unit test plan).
• Performed Peer to Peer testing, system testing for whole framework.
• Written the Unix wrapper scripts for applications.
• Handled the project modules independently.

Confidential

Ab-initio Developer

Environment: Ab-initio, Unix

Responsibilities:

• Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
• Providing unit testing, module testing, and regression testing and system integration testing of the scripts, graphs, psets, plans and queries
• Issue resolution and reporting.
• Prepared the UTPs.
• Written the Unix wrapper scripts for applications.
• Performed testing and prepared UTPs (unit test plan).
• Performed Peer to Peer testing of whole framework.