Experience Summary:

• 7+ years of experience with strong Data Warehousing experience using Informatica PowerCenter 8.x/7.x/6.x (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer) and BI solutions such as OBIEE/Siebel Analytics.
• Expertise in Configuring Financials, Procurement & Spend Analytics.
• Strong Experience in customizing category 1 and category 2 using BIApps and DataWarehouse Administration Console (DAC).
• Experienced in Installation, Configuration, and Administration of Informatica Power Center Client/Server and OBIEE/Siebel Analytics.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Experienced in OLTP/OLAP system study, analysis and ER modeling.
• Extensive knowledge in Oracle applications (E-Business Suite).
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De-normalization Concepts.
• Extensive exposure in using Oracle Business Intelligence EE (OBIEE) 10.x (Administration, Presentation Services).
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector using Oracle BI Presentation Services.
• Extensively worked with Oracle PL/SQL Stored Procedures, Triggers, Functions, Packages and also involved in Query Optimization.
• Experience in supporting the production system and handling day-to-day issues.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hard working and high level of motivation. A quick learner with an aptitude for taking responsibilities.

Technical Skills:
Operating System: Windows XP/2000/98, UNIX, Linux
Programming Languages: SQL, tSQL, and PL/SQL.
Scripting languages: Shell Scripting, Perl
Web technologies: HTML, XHTML, TCP/IP
Database: EBS(E-Business Suite),Oracle 10g/9i/8i/7i, SQLServer 2000/2005
Data Warehousing: InformaticaPowerCenter 8x/7x/6x,Designer, Workflow Manager,workflowMonitor,DAC(Datawarehouse Administration Console 7.9.6).
Business Intelligence: BIApps 7.9.6,(OBIEE)10.1.3.3.3
Database Applications: SQL*PLUS, SQL*Loader, TOAD, PL/SQL
Methodologies: ERWIN 4.x/3.x, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables, Normalization, De-normalization

Education:

• Bachelors in Electronics and Communication Engineering

Professional Experience:

Confidential,Boston,MA Feb ’10 –Till Date
Sr.ETL Developer
Project involved migrating the database from SQL Server to Oracle and implementing Oracle Procurement and spend Analytics using BI Apps 7.9.6.1.

Responsibilities

• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux,Windows Environment.
• Configured Financial Analytics, Procurement and Spend Analytics.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Extensively used Informatica Client tools – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager
• Successfully migrated database from SQL Server to Oracle by replacing the DTS packages with Informatica 8.6.1 mappings.
• Customized out of box ETL mappings and developed new mappings to load the data from non EBS source in to OBAW.
• Responsible for configuring the informatica Source and lookup files.
• Responsible for customizing the out of box reports and creating new reports and dashboards.
• Created Dimension hierarchies to achieve the drill down functionality.
• Customized Dashboard pages like Spend by Business Area, Open Invoice Details and All AP Transactions in Spend Analyzer Dashboard.
• Used Hints, Indexes and other tuning techniques to increase the performance of the slowly running reports.
• Created Dashboard prompts and advance filter criteria.
• Created new requests and opened Answers for adhoc reporting to the End users.
• Implemented ETL process to load data into target Oracle tables.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query performance
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Used Informatica Designer to create reusable transformations to be used in Informatica mappings and mapplets.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Monitored Workflows and Sessions using Workflow Monitor.
• Validated the mapping and integrity of data populated in the database using SQL queries.
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
• Designed, implemented and tested security privileges on Dashboards and reports.
• Migrated web catalog by using Catalog Manager from one instance to another.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Scheduled Informatica Workflows by creating JIL commands using Autosys.

Environment: Informatica 8.6.0, BIApps 7.9.6(Financials Analytics, Procurement & Spend Analytics), OBIEE 10.1.3.4.1, DataWarehouse Administration Console (DAC)7.9.6.1, Oracle 11i,10g, SQL*PLUS, SQL*Loader, TOAD, Unix, Autosys.

Confidential,IL Mar ’09 –Jan’10
Sr. ETL Developer
CNA is one of the leading health insurance providers focused in building a modern, innovative system of health services. The scope of the CORE project is to maintain the data warehouse with the data relating to customers, plans, claims and quotes. Designing the BI Apps Data warehouse and educating the ETL and reporting team were the key responsibilities.

Responsibilities

• Worked extensively with BA in gathering requirements.
• Used Informatica power center for extraction, transformation and loading data from heterogeneous source systems.
• Configured GL Account Segment Files for Financial Analytics using BI Apps.
• Configured Global currencies for creating enterprise wide reports and involved in configuring DAC source system parameters.
• Designed and developed Oracle PL/SQL and Unix shell Scripts, data import/export, data conversions and data cleansing.
• Tuning of SQL queries in SQL overrides for better performance.
• Responsible for mapping migration, importing and exporting maps from different servers.
• Imported data from various databases and converted it into 2nd normal form.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Reconciliation of data from scratch i.e., from source to target. Maintaining the flow and writing SQL queries and finding the mismatches in the data manually. Like UNIT testing.
• Involved in developing Physical Model, Business Model and presentation layer and established relationships with OBIEE.
• Used Metadata Design Principles to design Repository based on business requirements and followed Best Practices
• Exposure in creating Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters
• Created and generated reports, comparisons using EXCEL for user level purpose.
• Written UNIX and PERL Scripts for event automation.

Environment: Informatica Power Center 8.1(Source Analyzer, Mapping Designer, Mapplet, Transformations), BIApps 7.9.6,OBIEE 10.1.3.3.3, Kimball Methodology, ORACLE 10g, UNIX, Erwin 7.0, Windows XP, PL/SQL, TOAD for Oracle 9.1.2.

Confidential,Bloomington, IL Apr ’08 – Feb’09
Sr. ETL Developer
Project involved creating the Data Mart for the Customer Quotes using the Siebel CRM as a Source System. The QUOTE Data Mart was used for analyzing the effectiveness of the quotes provided by Sales people in Field Operation and helped management make decision in terms of designing different programs/strategies around the statistics collected using the Data Mart.

Responsibilities:

• Involved in preparing ETL requirement documents and designing and documenting the ETL process.
• Worked with the SMEs (Subject Matter Experts) to understand the business.
• Provided the ETL specification, coding guidelines and standards for the development team.
• Extracted data from the source, loaded in the SRL (Single Record layer) level and loaded the same into the Data Mart after scrubbing the data.
• Created mappings for Type2/Slowly Changing Dimensions for updating and inserting of records and in turn maintaining history.
• Managed Informatica Repository. Created Users, Folders, and Assigning access permissions to repository users.
• Involved in requirements gathering, designing functional and technical specifications for reporting needs.
• Extensively worked with OBIEE to build Physical Model, Business Model and presentation layer and established relationships.
• Defining various logical subject areas and organization of presentation layer metadata.
• Involved in trouble shooting, Performance tuning, maintaining of the daily and weekly ETLs .
• Developed Shell Scripts for taking the regular backup of repository and also for monitoring the daily loads in Informatica.
• Evaluated and upgraded Informatica Powercenter 7.1.4 to 8.1 in development environment.

Environment: Informatica Power Center 8.1/7.1.4,OBIEE, Oracle 10g, MS SQL Server 2005, Web log, UNIX, XML, Erwin 7.0, Windows XP, PL/SQL, Unix.

Confidential,Minneapolis, MN Jan ‘07 – Mar ‘08
ETL Developer
RDW(Retail sales Data Warehouse) serviced financial and marketing groups which needed this data warehouse to better understand the customer purchases so this system will allow us to analyze what products are selling in which stores on what days and under what promotion condition. It was also used for calculating gross profit, gross margin, product-revenue ratios, promotions, trend analysis and information from various dimensions.

Responsibilities:

• Involved in Source System Analysis to understand the incoming data into Data Warehouse and their Sources.
• Extracted the data from various Sources like SQL Server, Oracle & Flat Files into the staging area for the Data Warehouse. Performed the de-duping of the data in the Staging area.
• Involved in designing and development of logical and physical Erwin data models (Star Schemas) as a part of the design team.
• Reviewed the models with Business Analyst and Business Users.
• Developed ETLs using Informatica Powercenter 6.2. Used various transformations such as Expression, Filter transformation, Lookup transformation, Joiner transformation, Aggregator transformation, and Update strategy transformation.
• Used Informatica Workflow Manager to create and run the sessions for loading the data using the mappings created.
• Involved in performance tuning of transformations, mappings and sessions to optimize session performance
• Experience in Migrating a SQL server database to oracle database.
• Involved in maintenance and enhancements for the existing ETLs and related processes. Provided Production support on 24x7 basis on rotary basis.
• Involved in testing the upgrade of Informatica from version 6.2 to 7.1.1.
• Assisted in creating Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas for reporting .
• Developed Unix Shell Scripts to Automate the daily runs of ETLs and used Crontab to schedule the scripts.

Environment: Informatica Power Center 6.2/7.1.1, OBIEE, Oracle 10g, SQL Server 2000,Erwin, Unix

Confidential,Chicago, IL Nov’05 - Dec‘06
Informatica Developer
The SmartView Data Warehouse project involved collecting and analyzing the debit, credit and other related customer transactions. This would provide a single view of a customer to the business user and they can use the information from DW accordingly to make new decisions, marketing efforts, promotions etc.

Responsibilities:

• Developed mappings using Informatica Power Center Designer to load data from various source systems to target database.
• Designed, developed and unit tested the ETL (Informatica, PL SQL, SQL*Loader) to maintain the data marts .
• Developed PL/SQL procedures for processing business logic in the database.
• Performed the Tuning of some existing ETL. The process time was reduced from approx 8 hrs to approx 6 hrs. This was 25% gain in performance.
• Worked with Business Objects Developers to troubleshoot the production level issues.
• Involved in the testing of Stored Procedures and Functions, Unit and integration Testing of Informatica Sessions and fixing invalid Mappings.
• Used Type2 SCD mapping to insert new dimensions and update dimensions in the target and maintain the history.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Workflows.
• Used SQL*Loader to load the data into the table.
• Extensively used Siebel Analytics Software in creating a Physical Layer, BMM Layer and Presentation Layer in a Repository.
• Loaded metadata and table definitions into the Siebel repository by setting up Connection Pooling.
• Understanding and defining key metrics, dimensions, hierarchies and attributes.
• Involved in Unit/Integration Testing & user training of the generated reports in Siebel.

Environment: Informatica Power Center 7.1.2, Oracle 10g, TOAD for Oracle 8.5 , Siebel Analytics, UNIX.

Confidential,India Jun’03 - Oct’05
Database Programmer/Analyst
Project 1 - CMC is one of the leading System Integrators in India with multi-faceted expertise in Information Technology. As a member of the E-Commerce team, was involved in the design and development of the online parts warehouse system featuring an extensive inventory of new, overhauled and serviceable components. Also involved in ETL part of the DW.

Responsibilities:

• Involved in gathering the requirements from the business users.
• Developed PL/SQL stored procedures , functions and packages as a part of the application development.
• Developed SQL scripts to verify the data quality in terms of the data integrity, constraints integrity and business logic.
• Used performance tuning techniques to improve performance for the slow running SQL. Used Explain plans and Hints to modify the SQL and increase the performance.
• Developed the ETL packages to load the data from E-commerce system to DW.
• Used Informatica PowerCenter 6.1 to Perform ETL in Data Warehouse. Created Various Mappings and Sessions to perform ETL of data from E-commerce OLTP system to Data Warehouse.
• Migrated PL/SQL code for ETL to Informatica PowerCenter ETL mappings and Sessions.

Environment: Oracle 8i, PL / SQL, Windows 2000, SQL* Loader, Informatica Powercenter 5.1, Unix

Project 2 – Worked on Product Management System (PMS), Employee Database and Library Management System (LMS). PMS kept track of the product inventory, quantity in stock, order details etc.

Responsibilities:

• Designed and ER diagram by using Normalization principles and created database tables and relationships
• Involved in the creation of physical database objects such as tables, views, database triggers, sequences, synonyms, Partitioning the tables, and indexes.
• Created PL/SQL stored procedure and functions according to Business requirements.
• Created the SQL scripts to audit the data in the RDBMS.
• Loaded the data initially into the new systems using SQL*Loader for Oracle.

Environment: Oracle 7x, C, Windows, MySQL4.1, Linux