SUMMARY

• 7+ years of Data Warehousing experience working on INFORMATICA 9.1/8.x which includes implementing ETL/BI solutions in System Analysis, Design, Development and Testing.
• Solid Knowledge in Data Warehouse Concepts, Methodologies and SDLC.
• Conceptually good at logical and physical Data Modeling, Star Schema, Snowflake, Fact & Dimensions tables, slowly changing dimensions (SCDs)
• Proficiency in SQL, PL/SQL programming like creating Triggers, Procedures, Stored Procedures, Cursors.
• Experience with multiple source and target systems such as Oracle, MS SQL Server, Teradata, DB2, VSAM, MQ Series, COBOL, XML and Flat files.
• Experience in Designing, developing and testing ETL processes for the support of reporting/analytics purposes.
• Worked on conversion projects and converted PL SQL code to Informatica.
• Have solid development experience in creating complex ETL mappings to move data from source to target schema.
• Involved in developing and deploying ETL job workflow with reliable error/exception handling and rollback framework.
• Involved in writing scalable and high volume ETL strategies using Informtica for large volume data warehouses.
• Involved in Optimizing and Performance tuning logic on targets, sources, ETL Mappings, and Sessions to increase the efficiency.
• Have Experience in performance tuning of Informatica Mappings to ensure maximum Efficiency
• Designed and developed Unix Shell scripts for Data Import/Export, Data Conversions and Data Cleansing, Remove Workflow and Session Logs and backing upInformaticarepository.
• Extensive experience working with Oracle DBLinks and creating materialized views.
• Involved in performing Unit, Functional, Regression, Integration and User Acceptance Testing (UAT).
• Multi - platform experience on Unix/Linux and Windows Server family.
• Excellent communication skills and experience working with business users and leads/managers.
• Strong analytical & problem solving skills and a quick learner of new technologies and concepts.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x/8.x., ODI 11g.

BI Tools: Cognos 8.x/9.x/10.x, OBIEE 11.1.1.x/10.1.3.x., BI Publisher 11g/10g

Scheduling Tools: Control-M, Autosys.

Databases: Oracle 11g/10g/9i, SQL Server, DB2, Teradata

Database tools: SQL*Plus, SQL * Loader, SQL Navigator, Toad

OS: Windows 7/XP, Windows Server 2008/20033, IBM AIX 6.1, RHEL 5

Programming: C, C++, SQL /PLSQL, Shell scripting

Web Technologies: Java Script, CSS, XML, HTML

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Informatica Consultant

Responsibilities:

• Actively participated in requirement gatherings and analyzed Business Requirements in collaboration with the Business SMEs, Business Analysts, Users, Data Model Architects, DBAs and ETL leads to develop a data model.
• Worked in Coordination with Oracle Database Administrators for the Warehouse database design, data model, storage, security and performance requirements.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements.
• Integrated Data warehouse Design for enormous sources feeding the Warehouse like Billing, finance, call details, customer, usage, Product integration, Point of sales.
• Worked on Admin tasks like taking backups, creating users, Deploying code, assigning roles and restoring the Informaticarepositories from backup.
• Automated load run onInformaticasessions, PL/SQL scripts and implemented pre and post-session scripts, Written SQL Scripts and PL/SQL Scripts to extract data from Data base.
• Extensively worked on Informatica to extract data from flat files, Oracle, DB2 to load the data into the target database.
• Extensively used Informatica Power center and created mappings using transformations to flag the record using update strategy for populating the desired slowly changing dimension tables.
• Used Informatica Source Analyzer, Mapping Designer, Transformation Developer and Warehouse Designer for Extraction, Transformation and Loading.
• Querying and analyzing multiple databases and handling the errors as per the client specifications.
• Interacted with DBAs to create staging and target tables.
• Participated in team meetings to analyze the requirements and build the mapping design document.
• Converted PL SQL code to Informatica, Converted stored procedures to Informatica ETL code.
• Designed and developed Unix Shell scripts for Data Import/Export, Data Conversions and Data Cleansing, Remove Workflow and Session Logs and backing upInformaticarepository.
• Wrote stored procedures to check source data with Warehouse data and if not present, wrote the records to spool table and used spool table as Lookup in Transformation.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Extensively usedInformaticafunctions like IIF, DECODE, ISNULL, ADD TO DATE, TO DATE, etc., in transformations.
• Handling larger database queries and applying transformations to make the business solution applicable to project.
• Implemented best practices suggested by Informatica to simplify deployment Process.
• Used various kinds of the transformations to implement simple and complex business logic. Transformations used are: Lookup, Router, Expressions, Source Qualifier, Aggregator, Filter, Union, Sequence Generator, Update Strategy etc.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Used Mapping parameters, variables and session parameters to dynamically enter values between sessions.
• Responsible for performance tuning for several ETL mappings, Mapplets, workflow session executions.
• Trouble shooting and problem solving applications with Informatica Debugger. Used debugger to test the data flow and fix the mappings.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.
• Designed and developed Oracle PL/SQL Procedures for dropping and re-creating indexes, exchange partitioning.
• Implemented exchange partitioning for increasing data load frequency.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Involved in Unit and System Testing of ETL Code (Mappings and Workflows).
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Identified the errors by analyzing the session logs.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica PowerCenter 9.5, IBM Cognos 8, OBIEE 11g, Oracle EBS 12/11i, PeopleSoft 9.1, Oracle 11g/10g, Microsoft Windows Server 2008, TOAD.

Confidential, Phoenix

Informatica Consultant

Responsibilities:

• Actively participated in requirement gatherings and analyzed Business Requirements in collaboration with the Business SMEs, Business Analysts, Users, Data Model Architects, DBAs and ETL leads to develop a data model.
• Worked in Coordination with Oracle Database Administrators for the Warehouse database design, data model, storage, security and performance requirements.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements.
• Integrated Data warehouse Design for enormous sources feeding the Warehouse like Billing, finance, call details, customer, usage, Product integration, Point of sales.
• Worked on Admin tasks like taking backups, creating users, Deploying code, assigning roles and restoring the Informaticarepositories from backup.
• Automated load run onInformaticasessions, PL/SQL scripts and implemented pre and post-session scripts, Written SQL Scripts and PL/SQL Scripts to extract data from Data base.
• Extensively worked on Informatica to extract data from flat files, Oracle, DB2 to load the data into the target database.
• Extensively used Informatica Power center and created mappings using transformations to flag the record using update strategy for populating the desired slowly changing dimension tables.
• Used Informatica Source Analyzer, Mapping Designer, Transformation Developer and Warehouse Designer for Extraction, Transformation and Loading.
• Querying and analyzing multiple databases and handling the errors as per the client specifications.
• Interacted with DBAs to create staging and target tables.
• Participated in team meetings to analyze the requirements and build the mapping design document.
• Converted PL SQL code to Informatica, Converted stored procedures to Informatica ETL code.
• Designed and developed Unix Shell scripts for Data Import/Export, Data Conversions and Data Cleansing, Remove Workflow and Session Logs and backing upInformaticarepository.
• Wrote stored procedures to check source data with Warehouse data and if not present, wrote the records to spool table and used spool table as Lookup in Transformation.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Extensively usedInformaticafunctions like IIF, DECODE, ISNULL, ADD TO DATE, TO DATE, etc., in transformations.
• Handling larger database queries and applying transformations to make the business solution applicable to project.
• Implemented best practices suggested by Informatica to simplify deployment Process.
• Used various kinds of the transformations to implement simple and complex business logic. Transformations used are: Lookup, Router, Expressions, Source Qualifier, Aggregator, Filter, Union, Sequence Generator, Update Strategy etc.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Used Mapping parameters, variables and session parameters to dynamically enter values between sessions.
• Responsible for performance tuning for several ETL mappings, Mapplets, workflow session executions.
• Trouble shooting and problem solving applications with Informatica Debugger. Used debugger to test the data flow and fix the mappings.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.
• Designed and developed Oracle PL/SQL Procedures for dropping and re-creating indexes, exchange partitioning.
• Implemented exchange partitioning for increasing data load frequency.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Involved in Unit and System Testing of ETL Code (Mappings and Workflows).
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Identified the errors by analyzing the session logs.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica PowerCenter 9.1, IBM Cognos 8, Oracle EBS 12/11i, PeopleSoft 9.1, Oracle 11g/10g, Microsoft Windows Server 2008, TOAD.

Confidential

Programmer Analyst

Responsibilities:

• Actively Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details. Worked with project teams to plan integration and implementation strategies.
• Actively Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details. Worked with project teams to plan integration and implementation strategies.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Improved development time by leveraging metadata, and reduced IT coordination costs by providing a common working business model across the enterprise architecture.
• Extensively used Source Qualifier, Aggregator, Filter, Expression, Lookup, Update Strategy, Router and Joiner transformation.
• Worked extensively on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer, and Transformation Developer.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse. Converted PL SQL code to Informatica.
• Used Stored Procedure Transformation to invoke Oracle PL/SQL Procedures.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Involved in creating and maintaining various database objects like SQL Joins, synonyms and aggregate conditions and worked on various databases and their connectivity from various parts of the Source Systems.
• Extracted data from sources such as Oracle, DB2 and loaded to DB2 and Teradata.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance
• Wrote stored procedures to check source data with Warehouse data and if not present, wrote the records to spool table and used spool table as Lookup in Transformation.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Implemented performance tuning logic on Targets, Sources, Mappings, Sessions to provide maximum efficiency and performance.
• Used Autosys for automating Batches and Session.
• Involved in writing shell scripts on Unix for Informatica ETL tool to run the Sessions.
• Designed and developed the architecture for all data warehousing components (e.g. source system data ETL strategy, data staging, movement and aggregation, information and analytics delivery.)
• Designed and implemented Extract, Transform and Load (ETL) processes, programs and scripts.
• Used OBIEE 11g extensively for Reporting purposes.
• Mapped Logical resources to Physical resources in different contexts
• Performed unit testing at various levels of ETL flows
• Written many SQL statements for validating the reports and used the same in Test documents.

Environment: Informatica PowerCenter 9.1/8.x, OBIEE 11.1.1.6/10.1. x, Oracle EBS 12/11i, Siebel CRM 8.x, BI Publisher 11g/10g, Oracle 11g/10g, Teradata, RHEL 5, Shell Scripting, TOAD.