SUMMARY:

• 8 years of IT experience in Analysis, Design, Development, Testing, Implementation and Supporting of Data Warehouse (DW) Business Intelligence (BI) solutions using Operational Data Store(ODS),Data Mart (DM), ETL, OLAP on Unix platforms.
• Worked on data warehousing projects from inception to implementation and delivered high quality solutions in a timely manner meeting and exceeding the business requirements. This involved working with the top management and executives, business sponsors and IT department.
• Responsible for defining the information architecture and technology infrastructure along with the design of data models and the Business Intelligence delivery solutions.
• Responsible for managing the data analysis, data sources, data mapping along with defining the Meta data repository.
• Extensive hands - on ETL experience using Informatica Power Center and Performance tuning.
• Having good experience in setting up Informatica PowerCenter environment for new projects like Server in Linux environment.
• Managed the evaluation of ETL and OLAP tools and recommended the most suitable solutions depending on business needs.
• Responsible for creating Business Objects reports and universe, defining security parameters, scheduling and distributing reports.
• Skilled in implementing Data Warehousing and Business Intelligence solutions. Expertise in Ralph Kimball Data Warehouse methodology.
• Extensive hands-on experience on ETL Strategies, ETL Architecture and ETL Design Patterns.
• Defining coding and development standards and implemented design and code review procedures throughout the project lifecycle.
• Strong leader with experience training developers and advising technical groups on ETL best practices.
• Experience with different databases Teradata12/13, Oracle 9i/10g/11g.
• Experience on HDFS, Hadoop, Hive, Sqoop and Flume.
• Extensive experience with Load Utilities Multiload, BTEQ, Fast Load, Fast Export, TPT of Teradata.
• Extensive hands-on experience on SQL and PL/SQL.
• Creating projects conceptual, logical and Physical data models using Power Designer.
• Team player with excellent communication and problem solving skills.
• Team Player, Able to Work with a new and fresh perspective on work assignments, good in debugging, creative and able to learn new things.
• Highly motivated, energetic individual and a very good team player willing to work hard to meet intensive schedules and having excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5x/ 9.0.1/8.6/8.1.1/7.9, Informatica Cloud edition with Salesforce.

RDBMS: Oracle 11g/10g/9i, Teradata 14/13, MS SQL Server 2005/2000, DB2, MS Access

Big Data: HDFS, Hadoop, Hive, Sqoop, Flume

Load Utilities: Teradata - Mload, Fast Load, Fast Export, BTEQ, TPT

Scheduling Tools: Tidal, Tivoli Work Scheduler

Language: SQL, PL/SQL, Unix Shell Scripting

Dimensional Data Modeling: Dimensional Data Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Physical and Logical Data Modeling.

Operating Systems: UNIX, Linux, Windows 2007,2003/2000/XP/98

System Design & Development: Requirements Gathering and Analysis, Data Analysis, ETL Design, Reporting Environment Design, Development and Testing, UAT, Implementation

Tools: Toad, SQL Developer, SQL Plus, SQL Assistant, Synergy, Perforce

WORK EXPERIENCE:

Confidential

Responsibilities:

• Worked with business Analysts and Architects to get the functional specs and design documents in order to get a better understanding of the user requirement.
• Used Informatica Power Center for data extraction, transformation and loading data from heterogeneous sources including salesforce Cloud.
• Designed, developed and documented the methodologies for integrating data from different applications to EDW.
• Developed mappings, workflows to extract data from multiple sources like Oracle 11g and Flat files and loaded into target Oracle tables.
• Designed and supported all type of Slowly Changing Dimensions.
• Processed log data on HDFS using Hive, Flume and Sqoop.
• Developed complex Informatica mappings using different types of transformations like Connected and Unconnected, Lookup, Aggregator, Expression, Union and Update strategy, Router, Normalizer transformations for large volumes of Data and also involved in constraint based loading, target load order.
• Creation of Data marts. CDC data capturing and loading in DWH.
• Performance Tuning of Database Read/Write process, ETL Workflows and Business Objects Reports.
• Involved in code deployments while pushing from one environment to the other using Repository Manager.
• Responsible for performance tuning of Informatica code components and reports from the database and data model perspective.
• Responsible for Optimization of Informatica mappings, sessions, SQL queries.
• Used Shell Script to execute post-session and pre-session commands.
• Prepared low level technical documentations and unit test cases.

Environment: Informatica 9.5, Salesforce Cloud, Hadoop, Hive, HDFS, Sqoop, Flume, Oracle 11g, Unix, Synergy.

Confidential

Responsibilities:

• Worked closely with business stakeholders and technical team members to gather and analyze application requirements.
• Used Informatica Power Center for data extraction, transformation and loading data from heterogeneous sources.
• Developed mappings, workflows to extract data from multiple sources like Oracle 11g/10g, AS/400, DB2 and Flat files and loaded into target Teradata.
• Extensively used Erwin for data modeling and Dimensional Data Modeling.
• Designed and architected end-to-end ETL process in order to fast load and very fast retrieval of data.
• Implemented SCD Type I, II and III dimension loading strategy.
• Performance Improvement in Teradata by using Multiload, Fast Import/Export and proper PI defined on tables.
• Developed complex Informatica mappings using different types of transformations like Connected and Unconnected, LOOKUP, XML, Aggregator, Expression, Union and Update strategy transformations for Large volumes of Data and also involved in constraint based loading, target load order.
• Performance Tuning of Database Read/Write process, ETL Workflows and Business Objects Reports.
• Scheduled ETL workflows and Business Objects reports using TWS in Daily/Weekly/Monthly/Yearly batches.
• Migrated Project into QA, UAT,Prod and Back-up environments.
• Created Business Objects Reports and Universe.
• Responsible for performance tuning of Informatica code components and reports from the database and data model perspective.

Environment: Informatica 8.6, Teradata 13, Teradata Load Utility, TWS, Business Objects XIR2, Synergy

Confidential

Responsibilities:

• Used Informatica Power Center for data extraction, transformation and loading data from heterogeneous sources.
• Developed mappings, workflows to extract data from multiple sources like Oracle 11g/10g, AS/400, DB2 and Flat files and loaded into target Teradata.
• Extensively used Erwin for data modeling and Dimensional Data Modeling.
• Designed and architected end-to-end ETL process in order to fast load and very fast retrieval of data.
• Implemented SCD Type I, II and III dimension loading strategy.
• Performance Improvement in Teradata by using Multiload, Fast Import/Export and proper PI defined on tables.
• Developed complex Informatica mappings using different types of transformations like Connected and Unconnected, LOOKUP, XML, Aggregator, Expression, Union and Update strategy transformations for Large volumes of Data and also involved in constraint based loading, target load order.
• Performance Tuning of Database Read/Write process, ETL Workflows and Business Objects Reports.
• Scheduled ETL workflows and Business Objects reports using TWS in Daily/Weekly/Monthly/Yearly batches.
• Migrated Project into QA, UAT,Prod and Back-up environments.
• Created Business Objects Reports and Universe.
• Responsible for performance tuning of Informatica code components and reports from the database and data model perspective.

Environment: Informatica 7.5, Teradata 12, Teradata Load Utility, TWS, Business Objects XIR2, Synergy

Confidential

Responsibilities:

• Understanding of Old Legacy system and creation of new Workflows using Informatica as ETL tool.
• Creation of SCD2 mappings to have historic track of data.
• Creation of Low Level Design documents and Run book for operation support.
• Quality Engineering of Informatica based data warehouse.
• Performance Improvement in Teradata by using Multiload, Fast Import/Export and proper PI defined on tables.
• Migrated Project into QA, UAT,Prod and Back-up environments.
• Wrote Unit Test cases and executed test scripts successfully.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Environment: Informatica 7.5, Teradata12, Business Objects XIR2, Synergy

Confidential

Operational Analyst

Responsibilities:

• Involved in the ETL technical design discussions and prepared ETL high level technical design document.
• Involved in the analysis of source to target mapping provided by data analysts
• Involved in ETL low level design and prepared design document for each of the target table
• Supported during QA/UAT/PROD deployments and bug fixes.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Involved in code Reviews as per ETL/Informatica standards and best practices
• Worked with Reporting team to improve performance of reports.
• Unit Testing, Peer Review of ETL and Database code.
• Created integrated workflow per subject area keeping the dependency within the subject area
• Wrote Unit Test cases and executed test scripts successfully.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Environment: Informatica 7.5, Oracle 9i, Unix

Confidential

Data Warehouse/Business Intelligence Support

Responsibilities:

• Receiving Production Support tickets and maintaining their SLA.
• Giving business justification to business team or raising bugs for development team.
• Analyzing Business Object report and analyzing data in Source EDW systems.
• Looking in ETL mappings about business rules and solving the cases.

Environment: Informatica 7.5, Oracle 9i, Unix, Business Objects.