PROFESSIONAL SUMMARY:

• Over 10.6 years of IT experience in the field of ETL Development & Designing, Datawarehouse Development, Data Modeling, Business/Data analysis, Business Intelligence and development of application software in Web - Based environment, distributed n-tier and Client/Server environments.
• 10+ years of ETL and data integration experience in designing and developing ETL mappings and scripts using Informatica PowerCenter 9.1/8.x/7.x and ODI 11.1.1.7x
• 10+ years of experience in design and development of ETL process from databases such as Oracle, Teradata, DB2, XML and Flat files sources.
• 10+ years of Strong proficiency in writing SQL (including ORACLE, SQL Server, Teradata).
• 5+ years of good exposure on optimizing the SQL and performance tuning.
• 5+ years of Team Lead Experience with expertise in leading team for development projects, handling small to large team, effort estimation, impact analysis for change request, task allocation to Team Members, and resolving technical issues of the Team Members
• 1+ years of experience in BIAPPS technical projects.
• 10+ years of extensive experience on Data Warehousing concepts like Star Schema, Snow Flake, Dimension and Fact tables and Slowly Changing Dimensions.
• Experience in working with different business systems like oracle EBS ( OLFM, OM, AR and GL) and SFDC
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation,, implementation and post-implementation review.
• Experience in implementing projects in Agile/Scrum.
• Extensive experience with ETL tool Informatica in Designing the Workflows, Worklets, Tasks and Mappings, scheduling and monitoring the Workflows and sessions using Informatica PowerCenter 9.1/8.x/7.x
• Experience in optimizing and performance tuning of Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and Tasks.
• Experience in Tableau, OBIEE Reporting and Business Objects Tools.
• Strong knowledge of Teradata BTEQ, Fast Load, Fast Export and MLOAD scripts
• Developed test strategies and plans for Unit, Integration, System and User Acceptance Testing.
• Developed ETL migration documents and operation manuals for migrating in various environments
• Extensive Knowledge of RDBMS concepts, SQL and PL/SQL
• Good Knowledge of DollarU tool for scheduling the jobs.
• Good Knowledge of PVCS - Polytron Version Control System, used for version control management.
• Good knowledge of Kintana tool, used for Configuration management.
• Familiar with building end to end solution, onshore-offshore model and multi site development projects, System Integration, migration, maintenance and Support projects
• Experience on working with Client, Customer and User interfacing projects
• Team player and self-starter with good communication and inter-personal skills.
• Organized professional with immensely strong leadership capabilities.

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 9.x/8.x (Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets), ODI 11x (Designer, Topology, Operator)Data cleansing, OLAP, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader, DTS Package.:

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Slowly Changing Dimensions, Master Data Management.

Front-end tools: TOAD 7.x, SQL Server Management studio

Databases: Oracle 10i/9i, SQL Server 2005, MS Access 7.0/97/2000, Teradata.

BI & Reporting Tools: OBIEE, Tableau and Business Object

GUI: MS Excel, MS Word, Visio.

Programming: SQL, PL/SQL, SQL*Plus 3.3/8.0, UNIX Shell Scripting.

Environment: Windows 7/XP, Windows server 2008/2003, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Data- BI Consultant

Responsibilities:

• Worked with business users to identify, understand and design data Models and the business model.
• Interacted with business analysts, data architects, application developers to develop a data model.
• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• Worked on setting up of BICM
• Worked on BIAPPS customizations.
• Built Load plans from BICM
• Prepared mapping documents and technical specifications.
• Analyzed warehouse statistics to accommodate organic growth besides facilitating new Inventory details in the warehouse.
• Extensively used Oracle Data Integrator (ODI) to load data from different source systems likes, Oracle, Flat files, etc., into the Staging table and load the data into the Target database.
• Developed ODI interfaces and Packages to load data to various Dimensions and Facts
• Developed Scenarios and Load Plan to schedule data loading and monitor jobs
• Generated Tableau Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Used excel sheet, flat files, CSV files to generate Tableau Ad-hoc reports.
• Developed reports and dashboards.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Implemented Pivot mechanism for List Line dimension part of Advanced Pricing module (Custom table).
• Set up the Topology including Physical architecture, logical architecture and contexts.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
• Analyzed data issues reported by production team and provided solutions.
• Used markers and memos to distinguish interfaces and projects for ease to other developers
• Performed unit and system testing for ETL Packages
• Created load plans to run the scenarios in a hierarchy of sequential and parallel steps
• Migrating objects from one environment to other environment.
• Resolving day to day production issues
• Validated OBIEE reports and Dashboards.

Confidential

Sr Engineer IT

Responsibilities:

• Worked with business users to identify, understand and design data Models and the business model.
• Interacted with business analysts, data architects, application developers to develop a data model.
• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• Prepared mapping documents and technical specifications.
• Analyzed warehouse statistics to accommodate organic growth besides facilitating new Inventory details in the warehouse.
• Extensively used ETL to load data from different source systems like Teradata Objects, Oracle, Flat files, etc., into the Staging table and load the data into the Target database.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Collaborated with data modelers, ETL developers in the creating the Data Functional Design documents.
• Created the Staging mappings for delta detection using the different Transformations (Expression, Lookup, Joiner, Filter, Router, Stored Procedure etc.)
• Created the DollarU jobs to automate the process and to scheduling the Informatica jobs and shell scripts.
• PVCS - Polytron Version Control System, is used extensively for Configuration management purposes to store the versions of SQL scripts, Informatica code, DollarU jobs etc.
• Quality Center - is used for tracking the defects, maintaining and running the test cases.
• Extensively used Kintana tool for creating the packages and migrating the code.
• TOAD - is used extensively for connecting to Oracle databases and running the SQL scripts and PL/SQL jobs.
• Created several Mappings to validate the Data Quality Framework (DQF).
• Was involved in the performance tuning of the queries using the stats and tune the queries for the optimal time frame.
• Conducted Data profiling prior to extraction and during building mappings to assess data quality.
• Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.
• Played a key role in the entire project by handling the most key applications in the project.
• Involved in fixing invalid mappings as well as remove logical errors using the Informatica Debugger.
• Involved in Preparing Unit test cases and testing ETL process.
• Involved in Coordinating with onsite and offshore team members.

Environment: Informatica 9.x, PowerCenter Workflow Manager, Monitor, Mapping Designer, Repository Manager, Teradata, Oracle 10g, Business Object 4.1/3.1, UNIX, Shell scripting, Windows XP, SQL, PL/SQL, DollarU, PVCS, Quality Center, Kintana, TOAD, MS Office.

Confidential

ETL Developer

Responsibilities:

• Worked with business users to identify, understand and design data Models and the business model.
• Interacted with business analysts, data architects, application developers to develop a data model.
• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• Analyzed warehouse statistics to accommodate organic growth besides facilitating new Inventory details in the warehouse.
• Extensively used PLSQL to load data from different source systems, into the Staging table and load the data into the Target database.
• Created technical Design and Unit testing Documents
• Created Cubes using Oracle Analytical Workspace Manager
• Developed OBIEE Dashboards and Reports
• Quality Center - is used for tracking the defects, maintaining and running the test cases.
• TOAD - is used extensively for connecting to Oracle databases and running the SQL scripts and PL/SQL jobs.
• Involved in Coordinating with onsite and offshore team members.

Environment: Oracle 9i/ 10g, OBIEE 10g, Analytical Workspace Manager, Windows XP7, SQL, PL/SQL, Quality Center, TOAD, MS Office.

Confidential

ETL Developer

Responsibilities:

• Worked with business users to identify, understand and design data Models and the business model.
• Created technical design and Unit testing documents.
• Developed ETL mapping to load data to ODS using OWB
• Quality Center - is used for tracking the defects, maintaining and running the test cases.
• TOAD - is used extensively for connecting to Oracle databases and running the SQL scripts and PL/SQL jobs.
• Was involved in the performance tuning of the queries using the stats and tune the queries for the optimal time frame..

Environment: Oracle Warehouse Builder, Oracle 8/9i10g, Windows XP, SQL, PL/SQL, TOAD, MS Office.