Data Informatica
Resume:
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