SUMMARY

• Over Nine years of experience in Business Intelligence and Transactional applications, Design and Implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling.
• Expertized experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Power center.
• Extensively Worked on Informatica Power Center 9.1.0/8.x/7.x.
• Extensively Worked on Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of Box prebuilt mappings, Designing ETL, metadata management using DAC (Data warehouse Administration Console).
• Expertise in Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL.
• Expertise in Performance Tuning of Informatica Sessions, Oracle SQL queries.
• Extensively worked in developing and customizing Reports using OBIEE 10g and 11g reports.
• Extensively worked on several TDDs (Technical Design Documents) according to the requirement of the project.
• Domain Data warehousing experience in Retail and Telecom.
• Excellent analytical, problem solving, and communication skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS

PeopleSoft, Siebel, Oracle Applications: People Soft HCM 9.2, Oracle EBS R12, General Ledger, Accounts Payables, Order Management, Inventory

Application Tools: Informatica 9.1.0, Informatica 8.x/7.x, BI Apps 7.9.5, 7.9.6.X, DAC 11g, Informatica Power Analyzer, OBIEE 11.1.1.X,OBIEE 10.3.4.1

Databases & Tools: Oracle 11g/10g/9i/8i, TOAD, SQL*PLUS

Scripting Languages: Unix Shell scripting

Languages: SQL, PL/SQL, JAVA,C

Operating System: Unix, Linux, Windows 7/XP

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Sr. ETL Lead Developer

Responsibilities:

• Worked with Business Groups/Users to identify, analyze, and document Business Requirements.
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Involved high - level and low level design specifications for ETL coding.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Extracted the data from the flat files into staging area and populated onto Data warehouse.
• Developed custom mappings for Custom Dec using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, XML generator (for ReSA integration) and Aggregator and also designed and developed Sessions and Workflows through Informatica.
• Involved in Performance tuning at source, target, mappings, and sessions.
• Performed Testing like Unit Testing, integration testing and UAT (User Acceptance Testing) etc.

Environment: Informatica 9.1.0, UNIX, SQL Server, Oracle, Teradata, Erwin, IBM Mainframe, ESP.

Confidential, Plano, TX

Sr. ETL Lead Developer

Responsibilities:

• Worked with Business Groups/Users to identify, analyze, and document Business Requirements.
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Developed custom mappings for Human resource (PeopleSoft) Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator and also designed and developed Sessions and Workflows through informatica and Scheduled through DAC (Data warehouse administration console).
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE.
• Involved in Query Tuning to maximize the performance of ETL Jobs.
• Configured new tasks, parameter files and Execution Plan inDACfor incremental and fill load. Streamlined theExecution Planswith their respective tasks inDAC. Maintained the Full and Incremental loads through DAC on different environments like Development, QA and Production environment.
• Performed Unit and Regressive testing during development of reports and dashboard.
• Responsible for Unit Testing, integration testing and UAT (User Acceptance Testing) etc.

Environment: PeopleSoft HCM 9.2,Oracle Apps 12.1.3, BI Apps 7.9.6.3, OBIEE 11.1.1.6/ Informatica 9.1.0, DAC 11g, SQL Developer, Unix.

Confidential, Horsham, PA

Sr. Informatica Lead

Responsibilities:

• Worked with Business Groups/Users to identify, analyze, and document Business Requirements.
• Prepared Technical Design Documents.
• Involved in creating Informatica Mappings for File Sources. Experienced in using Normalizer, Joiner and Router Transformations in ETL.
• Involved in RPD Development for prompt based Reports.
• Created OBIEE Reports through Direct Database Request, Prompts and Dashboards.
• Implemented PDF calling functionality from OBIEE Reports.
• Published Case Study on the Gregorian based Fiscal Calendar Definition in Data warehouse using Informatica Tool.
• Experience in Testing like Unit Testing, integration testing and UAT (User Acceptance Testing) etc.

Environment: OBIEE 11.1.1.6, Informatica 9.1.0, Informatica Power Analyzer, SQL Developer, UNIX.

Confidential, Schaumburg, IL

Sr. Informatica Lead

Responsibilities:

• Worked with business users to gather business requirements and provided reports in Financial, manufacturing and Supply Chain modules.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system.
• Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Implemented Financial Analytics. Integrated data from enterprise systems and transformed data using Informatica (ETL).
• Involved in the impact analysis for Legacy applications as part of iFocus decommissioning due to SCPT.
• Performed ETL Lead Role in the ETL customizations design and coding for enhancing OBIA reports in the Supply Chain Process.
• Involved in the preparation of Technical Design Documents for the ETL Customizations.
• Have extensive knowledge in EBS Source System.
• Created and ran Sessions & Workflows using Informatica Workflow manager to load the data into the Data warehouse.
• Worked closely with the reporting team to understanding OBIEE Custom changes for the Out of Box Dashboards.
• Follow Quality processes for all the components delivered are tracked using Confidential EQUIP IT and conformance to SOX processes.
• Experience in Testing like Unit Testing, integration testing and UAT (User Acceptance Testing) etc.

Environment: Oracle Applications 11i (11.5.10) General Ledger, Account Payables, Accounts Receivable, Inventory, EBS, OBIEE 11.1.1.3.0, 10.1.3.4/10.1.3.2, XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, UNIX.

Confidential, Schaumburg, IL

Sr. Informatica Lead

Responsibilities:

• Involved in Systems Study/ Analysis and understand the business needs and implement the same into a functional database design.
• Designed, developed and improved complex ETL structures to extract transform and load data from multiple data sources into data warehouse and other databases based on business requirements.
• Developed complex mappings and SCD Type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router, Stored Procedure, XML and SQL transformations.
• Worked on the changes to Power Analyzer Reports based on the requirements.
• Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
• Worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter and Sequence Generator etc.
• Used ANALYZE, dbms stats, explain plan, to tune SQL queries.
• Identified and fixed bottlenecks and tuned the Informatica mappings for better performance.
• Developed and modified UNIX shell scripts to meet the requirements after the system modifications andwas also involved in monitoring and maintenance of the batch jobs.
• Developed, executed Test Plans and Test Cases to validate and check Referential integrity of data extracts before loading it to Data Warehouse.

Environment: Informatica Power Center 8.6.1, Informatica Power Analyzer, Brio Reports, Oracle 11g, UNIX, PL/SQL, Toad.

Confidential, Horsham, PA

Informatica Lead

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Design and development of new mappings, session and workflows using Informatica to extract data from R12 tables.
• Used Pipeline partitioning to enhance session performance.
• Used session partitions, Dynamic cache memory and Index caches for improving performance of Informatica server.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Designed and Developed Sessions and Workflows.
• Involved in preparation of Unit and System Test Cases.
• Involved in Creation and review of test Scenario and test Case based on requirement and design document.

Environment: Informatica 8.1, PLSQL, Oracle, UNIX Shell Scripting SQL Developer.

Confidential, Horsham, PA

Sr. Informatica and Cognos Developer

Responsibilities:

• Analyzing the Business Requirements and System Specifications to understand the application.
• Design and development of COGNOS reports for trend reports by customer and products.
• Migration from Cognos 7 Impromptu reports to Cognos 8 Version.
• Developed PL/SQL Packages and Procedures based on the requirement.
• Involved in development of reusable Mapplets, workflows using Informatica.
• Have successfully decommissioned the Informatica Repository Database, by moving to another DB instance which in turn benefited in Cost savings of Confidential .
• Ensure Review Request corresponds to the actual document/code that needs to be reviewed.
• Involved in preparation of Unit and System Test Cases.
• Involved in Creation and review of test Scenario and test Case based on requirement and design document.
• Tracking the Test Plan/Test Specification vs. Requirements using Scegen.
• Analysis of client supplied documents.
• Quality processes for all the components delivered are tracked using Confidential EQUIP IT and conformance to Sox process.
• To implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Extracted various sources like Oracle tables and imported Flat files using Informatica Power center. Extensively developed mappings on various business areas in the project by employing the available Transformations.
• Experience in Testing like Unit Testing, integration testing and UAT (User Acceptance Testing) etc.
• Created Dimension hierarchies to achieve the drill down functionality.
• Involved in Query and Performance tuning in order to increase the performance of the reports by creating Indexes and Aggregate Tables etc with the help of PL/SQL.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Designed and Developed Sessions and Workflows.
• Conducted training Sessions on Informatica power center.

Environment: Cognos 8, Cognos 7, Informatica 6.2, Informatica 7.1, PLSQL, Oracle, UNIX Shell Scripting SQL Developer.

Confidential, Schaumburg, IL

Informatica Developer

Responsibilities:

• Worked with business users to gather business requirements.
• Transformed Business Requirements to Technical High level Design Documents.
• Prepared Low level Design documents.
• Extracted the data from source systems (oracle flat file), load it into staging (oracle) area and populating data into Data warehouse by using Informatica.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Used Debugger to troubleshoot the mappings.
• Updated UNIX Shell scripts in automation of data movement to avoid manual intervention.
• Migrating workflows from Dev to Test to Prod through repository manager.
• Involved in Creation and review of test Scenario and test Case based on requirement and design document.
• Provided Post Implementation Support for a month after Go-Live.

Environment: Informatica 6.1, Oracle 9i, PL/SQL, SQL*PLUS, SQL*Loader, TOAD, UNIX.

Confidential, Schaumburg, IL

Informatica Developer

Responsibilities:

• Gathered information by interacting with clients and end users.
• Analyzed the Business Requirements and System Specifications to understand the application.
• Developed Informatica Mappings and Worklets based on the requirement.
• Migrating workflows from Dev to Test to Prod through repository manager.
• Involved in preparation of Project Related Test case documents.
• Extensively worked on PL/SQL in order to increase the performance.
• Extensively worked on Data Extraction from Databases and flat files by using Informatica.

Environment: Informatica 6.1, Oracle 9i, PL/SQL.