SUMMARY

• Having 10+ years of experience in Design, ETL development, testing and Implementation with major focus on data warehouse & BI solutions for clients namely Confidential, Confidential Group, Confidential, Confidential capital across varied domains like Commercial Financial & Banking, Telecom.
• Has proven experience in ETL tool Ab initio 3.1.6, Data Model Tool like ER - Studio and EDWs like Teradata 14.0 and Oracle 11.
• Other experiences include Unix Shell script, Oracle PL/SQL and Teradata utilities like Fast export, Fastload, Multiload and TPUMP.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling forOLTPand dimension modeling forOLAP.
• Has experience in all the phases of SDLC involving Requirement Analysis, Design, Development, testing and implementation in EDW & BI area.
• Has varied client experiences like coordination with cross teams and vendors, understanding and analyzing business requirements from business users.
• Developed complex Ab Initio graphs using various Ab initio parallelism techniques, Multi file systems, dynamic lookups. Extensively worked on Abinitio Tool using various components likerollup,join reformat and techniques like parallel processing.
• Working with EBCIDIC,XML,flat unix files processing.
• Developed several complex UNIX shell scripts to process the file level validation and schedule Abinitio Graphs.
• Developed Complex database objects likeStored Procedures and Functions using SQL and PL/SQL.
• Developedmaterialized viewsfor data replication in distributed environments.
• Loaded Data into Oracle Tables usingSQL Loader. Partitioned large Tables usingrange partition technique.
• CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
• Worked extensively onRef Cursor and External Tables.
• Expertise inDynamic SQLandException handling.
• Involved in promotions and deployment of Ab Initio graphs in Dev., QA, SIT and production environments.
• Demonstrated ability to complete multiple assignments simultaneously and maintain high standards of client organizations, ensure quality customer deliverables while leading and driving advanced / complex projects to successful completion.

TECHNICAL SKILLS

Primary Skill category: DW - Ab initio, Unix shell scripting, Oracle and Teradata and ER-Studio

Sub skills: Oracle PL/SQL programming, Teradata sql and utilities

Primary Domain: Banking, Commercial Financial and Telecom

Trained Skills: Ab initio ETL, Pl/sql

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Ab Initio Lead / Developer

Responsibilities:

• Analysis of business requirement specifications from clients and co-coordinating with business Users.
• Identifying current process flow.
• Analyze the source data, do data profiling, understand the nature of data in source system.
• Created FSD (functional Specification Document), Data Architecture Document, created/modified low level design document (mapping document).
• Explain the business requirements; collaborate with developers and DA team for the overall design and low level design for integrating data from heterogeneous sources, created harmonization document and TDD (technical design document).
• Testing the graph once development is completed and preparing Unit test case documents, code review documents.
• Consolidating the code developed by all team members and making the deliverables as per schedule
• Addressing code related issues raised during all the phases of the project
• Performed potential transformations at the staging area, such as cleansing the data (dealing with unwanted elements, parsing into standard formats) combining data from multiple sources and de-duping the data.

Environment: Ab initio ETL, Oracle, UNIX shell scripting.

Confidential, Danbury, CT

Ab Initio Developer

Responsibilities:

• Analysis of business requirement specifications from clients and co-coordinating with business Users.
• Identifying current process flow.
• Analyze the source data, do data profiling, understand the nature of data in source system.
• Created FSD (functional Specification Document), Data Architecture Document, created/modified low level design document (mapping document).
• Explain the business requirements; collaborate with developers and DA team for the overall design and low level design for integrating data from heterogeneous sources, created harmonization document and TDD (technical design document).
• Worked on the Development cycle and creating process flow diagrams and implementation plan documents for ETL & Teradata.
• Testing the graph once development is completed and preparing Unit test case documents, code review documents.
• Consolidating the code developed by all team members and making the deliverables as per schedule
• Addressing code related issues raised during all the phases of the project
• Involved in promotion of patch files from DEV to SIT,UAT, Production environment by using Abinitio AIR commands
• Performed potential transformations at the staging area, such as cleansing the data (dealing with unwanted elements, parsing into standard formats) combining data from multiple sources and de-duping the data.
• Used different EME Air Commands in Project promotion like air tag create, air save, air load, air project export etc.

Confidential

Ab Initio Developer

Responsibilities:

• Analysis of business requirement specifications from clients and co-coordinating with business Users.
• Identifying current process flow.
• Identifying to be process flow with modification for reduce SLA time.
• Analysis on downstream system and reports.
• Used Teradata utilities fast load, multiload, tpump to load data
• Worked on various components like continues subscriber, publisher, Abinitio queues, Partition, Transform, and Database, Excel components and Dataset Components.
• Project development from scratch and participated in design and development.
• Performed data cleansing and data validation by using various Abinitio Functions.
• Involved in unit testing of graph and code reviews.
• Designed Abinitio plans to schedule the object flows and error handling.
• Preparing technical design documents (TDD) once development is finished.
• Testing the graph once development is completed and preparing Unit test case documents, code review documents.

Environment: Ab initio GDE 3.1.6, Teradata 12.00.02.40 , Oracle Pl/Sql, Unix AIX 5.2 and OP console scheduling.

Confidential

Ab Initio Developer

Responsibilities:

• Analysis of business requirement specifications from clients and co-coordinating with business Users.
• Identifying current process flow.
• Identifying to be process flow with modification for reduce SLA time.
• Analysis on downstream system and reports.
• Used Teradata utilities fast load, multiload, tpump to load data
• Worked on various components like continues subscriber, publisher, Abinitio queues, Partition, Transform, and Database, XML components, Excel components and Dataset Components.
• Project development from scratch and participated in design and development.
• Performed data cleansing and data validation by using various Abinitio Functions.
• Involved in unit testing of graph and code reviews.
• Designed Abinitio plans to schedule the object flows and error handling.
• Preparing technical design documents (TDD) once development is finished.
• Testing the graph once development is completed and preparing Unit test case documents, code review documents.
• Involved in promotion of patch files from DEV to SIT, UAT.

Environment: Ab initio GDE 3.1.6, Teradata 12.00.02.40 , Oracle Pl/sql, Unix AIX 5.2 and OP console scheduling.

Confidential

Ab Initio Developer

Responsibilities:

• Analysis of business requirement specifications from clients and co-coordinating with business analysts.
• Used Teradata utilities fast load, multiload, tpump to load data
• Writing Fast export scripts to export data, Involved on tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Worked on various components like Partition, Transform, and Database, XLM components, Excel components and Dataset Components.
• Project development from scratch and participated in design and development.
• Developed transformation logic and business rules for ETL purpose.
• Performed data cleansing and data validation by using various Abinitio Functions.
• Involved in unit testing of graph and code reviews.
• Written several Unix Control Scripts specific to application in order to pass the Environment variables.
• Used different EME Air Commands in Project promotion like air tag list, air tag create, air Object save, air Object load, air project export etc.
• Run UNIX scripts to execute the AbInitio graphs and load the tables
• Preparing technical design documents (TDD) once development is finished.
• Testing the graph once development is completed and preparing Unit test case documents, code review documents.
• Involved in promotion of patch files from DEV to SIT, UAT.

Environment: Ab initio GDE 3.0.4, Teradata 12.00.02.40 , Unix AIX 5.2 and Autosys.

Confidential

Ab Initio Developer

Responsibilities:

• Prepared Functional requirement document (FRD) and Technical Specification Document (TSD), having details about pricing process.
• Developed different both continuous and non-continuous services using Informatica.
• Project development and participated in design and development.
• Used Teradata utilities fast load and multiload to load data
• Developed transformation logic and business rules for ETL purpose.
• Performed data cleansing and data validation by using various Informatica Functions.
• Involved in unit testing of mapping and code reviews.
• Involved in project promotion from development to SIT and SIT to UAT.
• Worked on UNIX shell scripting control scripts to handle and schedule project from backend.

Confidential

Responsibilities:

• Testing the graph once development is completed and preparing Unit test case documents, code review documents.
• Involved in end to end testing and promoting patch files from DEV to SIT, UAT, Production environment.
• Processing bunch of XML files on daily basis which we receive in source path by using xsd and loading in to corresponding tables.
• Involved as Designer and Developer for Commercial Business Group data Ware House (CBGDWH).
• Requirement gathering and analysis, prototyping, Interface Design Document and High level design document creation.
• Development of source Data profiling and analysis - review of data content and metadata will facilitate data mapping, and validate assumptions that were made in the business requirements.
• Consolidating the code developed by all team members and making the deliverables as per schedule