Profile

Over ** years of IT experience in various phases of Software Development life cycle including Design, Development & Testing using Data Warehousing & Business Intelligence

Extensive experience in designing Data modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables, Physical and Logical data modeling.

Extensive experience in Designing, development and testing of Mappings & Workflows using Informatica power center Designer, Repository manager, Workflow Manager and Workflow Monitor

Design & Build efficient ETL mappings & workflows for processing fact and dimension tables using major transforms such as source qualifier, lookups, normalizer, joiner, aggregator, update strategy, router, filter

Created numerous mappings which do previous/next row processing, type 1& type 2 dimensions

Experience in Performance tuning of Informatica Mapping & workflow

Experience in DAC design and development including customizing execution plan, subject areas, tables groups and task definitions.

Customized OBIEE Repository (RPD) by creating Facts, Dimensions & hierarchy in physical, logical & Presentation layer in Multi User Development Environment (MUDE).

Developed various custom configuring interactive dashboards with drill-down capabilities using global and local filters

Worked on Production support, troubleshooting the issues and resolving bugs

Excellent analytical, problem-solving, communication skills.

Worked with Business Analysts to identify, analyze & document Business Requirements then translated them into technical design documents.

Ensuring the Projects are successfully delivered on time as per required standards

Technology Snapshot

Databases:

Oracle 11g/10G/9I

SQL server 2005/2000

IBM DB2

Tools:

BIAPPS 11.1.1.7.1, 7963 & 7964

Informatica Power Center 9/8/7

ODI 11.1.1.5.0

DAC

Informatica Data Quality (IDQ) 8.6

OBIEE 11g, RPD Modelling

Platforms:

Windows

Unix

Scripting:

PL/SQL

SQL

Shell

Education

B.Tech. degree in Electronics Engineering (2002- 2006) from Harcourt Butler Technical Institute Kanpur, India with 1st Division

Professional Experience

Vidorra, Pittsburgh PA Dec 17 – Present

FedEx Ground: This project involved the implementation of Actual & Budget module and with Budget variance reports.

Some of the activities / responsibilities include:

Interaction with business representatives for requirement analysis

Requirement analysis and design the ETL, RPD & Reports

Data & Dimensional modelling of Ground Actual & Budget Module.

Designed & Developed the ETL mappings & DAC Metadata.

Managed the team in all the development efforts which include ETL, RPD, Report, DAC and Database changes.

Development of Various Reports & Dashboards and demo to users

Actively involved in testing strategy and execution

Environment: BIAPPS 7964, Informatica 9, Oracle 11g, OBIEE 11, DAC, PeopleSoft

Vidorra, Memphis TN Jun 16 – Dec 17

FedEx Encore Analytics: This project involved the implementation of Lease module and integration with Financial Analytics for the client.

Some of the activities / responsibilities include:

Interaction with business representatives for requirement analysis

Requirement analysis and design the ETL, RPD & Reports

Data modelling of Lease, Contract, Clear & Request Module.

Designed & Developed the ETL mappings & DAC Metadata.

Managed the team in all the development efforts which include ETL, RPD, Report, DAC and Database changes.

Performance tuning of Informatica mappings and session

Actively involved in testing strategy and execution

Environment: BIAPPS 7964, Informatica 9, Oracle 11g, OBIEE 11, DAC, Tririga

KPI Partners Jul 11 - May 16

Carnival, Miami, Florida - Implementation & customization of Financial Analytics module & Fixed Assets module according to client requirement.

Some of the activities / responsibilities include:

Interaction with business representatives for requirement analysis, to define functional specifications

Designed & Developed the ETL for the Fixed Assets & Sub Ledger module for Real time.

ETL, RPD, Reports customization following the BI Apps standards

Designed and implemented RPD changes for Performance tuning of Informatica mappings and session

Actively involved in testing strategy and execution during SIT & UAT

Environment: BIAPPS 11.1.1.7.1, ODI 11, Oracle 11g, OBIEE 11

Red Hat, Bangalore - Enable seamless integration of Oracle EBS R11 and R12 data in Oracle BI Applications warehouse for Order management & Supply Chain, Project, Services, HR & Finance Modules.

Some of the activities / responsibilities include:

Managed the offshore team in all the development efforts.

Analysis of comparing keys for EBS R11 and R12 sources

Created design documents for ETL changes

Developed & tested Procedures to delete duplicate records

Developed & tested ETL mappings and DAC metadata.

Performance tuning of the Procedures

Fixed bugs during UAT

Environment: BIAPPS 7963, Informatica 9.0.1, Oracle 10g, R11 EBS, R12 EBS, DAC

Progressive: Implementation of HR Analytics module along with new implementation of Training & Survey Modules following the BI Apps standards to provide a consolidated BI solution.

Some of the activities / responsibilities include:

Lead the offshore team in all the development efforts.

Designed & Developed the Data Model, ETL and DAC metadata for the Training & Survey module.

Developed & tested custom mappings following the BI Apps standards.

Performance tuning of the Informatica mappings

Developed & tested reports for Training module

Fixed bugs for Training, Survey & HR Module during the UAT phase.

Environment: Informatica 8.6, Oracle 10g, People Soft 9.0, TOAD, OBIEE 10.1.3.4, DAC

Goldman Sachs Apr 10 – Jun 11

Passive Foreign Investment Company (PFIC) - Extract the potential PFIC candidates from the active product list and send the list to the vendor to research. Load the researched information from vendor into the system and make available data for user to override and approve the information.

Some of the activities / responsibilities include:

Requirement gathering for design phase from users

Design & build efficient Informatica mappings and workflows for processing fact and dimension tables with complex transformations.

Performance tuning of the Informatica mappings.

Unit Testing of Mappings and created Test plans.

Active member during UAT phase of project

Environment: Informatica 8.6, Oracle 10g, Oracle SQL Developer, DB2, Autosys, Unix, Filezilla.

Wipro Technologies Sep 08 – Apr 10

Johnson & Johnson: Consolidate the two data warehouses into one enterprise data warehouse to reduce duplication of information acquisition, consolidation, report generation and enable faster reconciliation.

Some of the activities / responsibilities include:

Requirement gathering for design phase from clients

Design, development and testing of Mappings & Workflows in Informatica, Procedures & Packages in Oracle

Created numerous mappings which do previous/next row processing, type 1& type 2 dimensions

Built efficient Informatica mappings for processing fact and dimension tables using major transforms such as source qualifier, lookups, normalizer, joiner, aggregator, update strategy, router, filter

Presentation of design document & code to Client

Lead the team

Performance tuning of the Informatica mappings.

Unit Testing of Mappings and created Test plans

Fixed the bugs raised by the QA team.

Environment: DWH, Informatica Power Center (8.6), Oracle, TOAD

Schneider Electric: Data migration from Legacy systems to SAP environment. Source data was analyzed, cleansed, standardized and parsed. Potential duplicates were identified; rules were applied according to functional specs and migrated to target systems.

Some of the activities / responsibilities include:

Legacy Systems Data Analysis, Cleansing, Standardization, Parsing and De-duplication using Informatica data Quality (IDQ)

Reporting the Data Quality

Environment: Informatica (8.6.1), Informatica Data Quality (IDQ), Oracle, DWH, TOAD

Tavant Technologies Jul 06 - Sep 08

Production support for Drive Financial Services, which would entail Requirement analysis, ETL development, job scheduling, job monitoring, Root cause analysis for data issue & fixing the data quality issues (SQL, PL/SQL) & Preparation of document for the production support

Environment: DWH, Informatica (7.1.1), SSIS, MSSQL, Control M, Batch File, TOAD

Contact this candidate