SUMMARY:

• 12 years of experience in Data Warehousing concepts, ETL and OLAP with a major focus on Solution Design, Project Management, Development & Implementation, Performance Tuning, Testing, Application Support & Maintenance and Team Leadership.
• Team member of multiple end - to-end solutions for BI intelligence projects with ETL as well as OLAP technology.
• Experience in most major BI tools such as OBIEE 10g/11g/12c, BICS 12c, OAC 12c, Informatica 9.x,10.x Datawarehouse Administration console 10g/11g, Oracle Data Integrator 10/11g/12c
• Hands on experience in installing and configuring Oracle BI Apps 7.9.6.x/ 11.1.1.10. x with HR, AP, AR, GL, Projects, Time and Expense (OTL), Procurement and Spend Analytics etc.
• Extensive work with Oracle 8i,9i,10g,11g,12c PeopleSoft 8.9, Siebel 7.8, SQL server 2005, 2008 using Oracle PL/SQL and complex SQL queries.
• Excellent understanding of business requirements and to change into BI presentation
• Can handle high-pressure situations with aplomb, known to be a problem solver and analytic thinker among peers and clients.
• Excellent written and oral communication skills

PRIMARY TECHNOLOGIES:

ETL : Informatica Power Center 7.x,8.x,9.x, Power Center Administration Console, Oracle Data Integrator 10g/11g/12c, Datawarehouse Administration Console 10g/11g, SQL Server Integration Services

BI Platforms : OBIEE 10g/11g/12c, BICS 12c, OAC 12c Oracle Discoverer, Oracle BI Apps 7.9.6.x/ 11.1.1.10. x (HR, AP, AR, GL, Project, Time Expense, Procurement and Spend analytics etc.)

Other Technologies: Oracle EBS 11xxx and Oracle EBS 12xx

PROFESSIONAL EXPERIENCE:

Confidential, Saint Louis, MO

Senior OBIEE Consultant

Responsibilities:

• Interacting with business user and participating in gathering requirements
• Analyzing the requirements and converting into the technical documents, Identified the stars (Dimensions/Facts) that needs to be populated
• System test, UAT and deploy
• Debugging issue during load process and fixed ODI interface
• Identified irrelevant task running during ETL process and disable them to reduce time
• Coordinated with their off-shore team and providing assistance in their need
• Built metadata in the analytics repository with Analytics Administration Tool in physical, business and presentation layers
• Prepared Custom Dashboards and Reports.
• Created users, groups using Web Admin Tool & assigned different dashboards permissions.
• Created, modified and formatted requests, along with charts and filters, in OBIEE. Built new reports and Customized OOTB reports as per business needs
• Assisted User in Designing Report Layouts and Report Structure for better utilization and Understanding of data.
• Worked on Branding of the existing OOTB product for enhanced user adoption
• Created data visualization analysis from different source systems
• Used Reverse-engineering knowledge modules to import brand new source table and other DWH tables
• Customized OOTB Dimension and Fact interfaces to add custom column as per business needs
• Ran ODI scenario standalone during regular ETL run and sometime during addition on new column in some dimension and fact table
• Identified irrelevant tasks running during ETL process and disabled them to reduce processing time
• Fixed OOTB Bug for Day Dimension that truncate W DAY D in each load process, W PRODUCT D TL for generating duplicate records
• Developed and documented Data Mappings/Transformations as per the business requirement
• Performed integrated Testing for various scenario , Tested the data and data integrity among various Sources and Targets
• Prepared audit script to validate report from defined source system

Environment: OBIEE 12c, ODI 11g, OBIA 11.1.1.10. 2, Oracle EBS R12

Confidential, Saint Louis, MO

Senior ETL/OBIEE Consultant

Responsibilities:

• Interacting with business user and participating in gathering requirements
• Analyzing the requirements and converting into the technical documents, Identified the stars (Dimensions/Facts) that needs to be populated
• Project Management - Status reporting
• System test, UAT and deploy
• Coordinated with the on-site and off-shore team and working on service requests as team.
• Created Informatica mappings, Sessions and executed them to Load the data from the source system using Informatica Server Manager
• Implementing Slowly Changing Dimensions - Type I & II in different mappings as per the requirement
• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement
• Performed integrated Testing for various Mappings, Tested the data and data integrity among various Sources and Targets
• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environments
• Created Bitmap Index, Materialized View
• Configuring Data Warehouse Administration Console (DAC) to create new execution plan and running the Complete Informatica Workflows
• Involved in performance tuning of various mappings and sessions to increase the performance
• Conversion of existing ETL code from sql scripts, spool, xml files to Informatica ETL code
• Built metadata in the analytics repository with Analytics Administration Tool in physical, business and presentation layers
• Configuring Repository, Session variables to generate dynamic reports.
• Prepared Custom Dashboards and Reports.
• Created users, groups using Web Admin Tool & assigned different dashboards permissions.
• Created, modified and formatted requests, along with charts and filters, in OBIEE. Built new reports and Customized OOTB reports as per business needs
• Assisted User in Designing Report Layouts and Report Structure for better utilization and Understanding of data.
• Worked on Branding of the existing OOTB product for enhanced user adoption
• Upgraded OBI 11g to BICS 12c
• Upgraded BICS 12 to OAC12c
• Configured RDC for BICS Lift and shift methodology
• Migration of existing OBI Reports, prompts and Dashboard to new BICS
• Created data visualization analysis from different source systems
• Installing/troubleshooting of Different OBI Application Components (OBIEE, DAC, and Informatica)
• Defining and implementing Backup strategy for Informatica Repository, DAC repository, OBIEE RPD, and Web Catalog
• Worked for the migration of Repository & Web Catalogs from Development to Test & Production server.
• Guiding / customer’s IT Team during course of the project so that they feel confident about supporting this product post deployment

Environment: OBIEE 11g, BICS 12c, OAC 12c, BI Apps 7.9.6.4, Oracle 11g, Oracle EBS 1213

Confidential, Grafton, WI

Senior ETL/OBIEE Consultant

Responsibilities:

• Interacting with Customers and participating in gathering requirements
• Analyzing the requirements and converting into the technical documents, Identified the stars (Dimensions/Facts) that needs to be populated
• Project Management - Status reporting
• System test, UAT and deploy
• Created Informatica mappings, Sessions and executed them to Load the data from the source system using Informatica Server Manager
• Implementing Slowly Changing Dimensions - Type I & II in different mappings as per the requirement
• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement
• Performed integrated Testing for various Mappings, Tested the data and data integrity among various Sources and Targets
• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environments
• Created Bitmap Index, Materialized View
• Configuring Data Warehouse Administration Console (DAC) to create new execution plan and running the Complete Informatica Workflows
• Involved in R12 Implementation Project and Integration of 11.0.3 and IFS system to R12
• Involved in performance tuning of various mappings and sessions to increase the performance
• Built metadata in the analytics repository with Analytics Administration Tool in physical, business and presentation layers
• Configuring Repository, Session variables to generate dynamic reports.
• Prepared Custom Dashboards and Reports.
• Created users, groups using Web Admin Tool & assigned different dashboards permissions.
• Created, modified and formatted requests, along with charts and filters, in OBIEE. Built new reports and Customized OOTB reports as per business needs
• Assisted User in Designing Report Layouts and Report Structure for better utilization and Understanding of data.
• Worked on Branding of the existing OOTB product for enhanced user adoption
• Installing/troubleshooting of Different OBI Application Components (OBIEE, DAC, and Informatica)
• Defining and implementing Backup strategy for Informatica Repository, DAC repository, OBIEE RPD, and Web Catalog
• Worked for the migration of Repository & Web Catalogs from Development to Test & Production server.
• Guiding / customer’s IT Team during course of the project so that they feel confident about supporting this product post deployment

Environment: OBIEE 11.1.1.6, BI Apps 7.9.6.4, Oracle 11g, Oracle EBS 1213

Confidential, Mansfield, MA

Senior ETL/OBIEE Consultant

Responsibilities:

• Interacting with Customers and participating in gathering requirements
• Analyzing the requirements and converting into the technical documents, Identified the stars (Dimensions/Facts) that needs to be populated
• Performance optimization of the ELT process
• Unit testing and Code migration to QA and Prod repository
• Used Reverse-engineering knowledge modules to read the table and other object metadata from source databases
• Journalizing knowledge modules to record the new and changed data within either a single table or view or a consistent set of tables or views
• Used loading knowledge modules to extract the data from source databases for loading into a staging area and Check knowledge modules to detect errors in source data
• Use IKM Incremental Update Knowledge Module for Both Insert n Update operations
• Using Integration knowledge modules to efficiently transform data from staging area to the target tables, generating the optimized native SQL for the given database
• Created Interfaces, packages and procedures
• Implementing CDC in different mappings as per the requirement
• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement
• Performed integrated Testing for various Mappings, Tested the data and data integrity among various Sources and Targets
• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environments
• Created Clustered and Non Clustered Indexes
• Built metadata in the analytics repository with Analytics Administration Tool in physical, business and presentation layers
• Configuring Repository, Session variables to generate dynamic reports.
• Prepared Custom Dashboards and Reports.
• Created users, groups using Web Admin Tool & assigned different dashboards permissions.
• Created, modified and formatted requests, along with charts and filters, in OBIEE. Built new reports and Customized OOTB reports as per business needs
• Assisted User in Designing Report Layouts and Report Structure for better utilization and Understanding of data.
• Worked on Branding of the existing OOTB product for enhanced user adoption
• Installing/troubleshooting of Different OBI Application Components (OBIEE, ODI)
• Defining and implementing Backup strategy for ODI Repository, OBIEE RPD, and Web Catalog
• Worked for the migration of Repository & Web Catalogs from Development to Test & Production server.

Environment: OBIEE 11.1.1.6, ODI 11g, SQL Server 2008

Confidential, Woodland, Texas

ETL/OBIEE Consultant

Responsibilities:

• Interacting with Customers and participating in gathering requirements
• Analyzing the requirements and converting into the technical documents, Identified the stars (Dimensions/Facts) that needs to be populated
• Created Informatica mappings, Sessions and executed them to Load the data from the source system using Informatica Server Manager
• Implementing Slowly Changing Dimensions - Type I & II in different mappings as per the requirement
• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement
• Performed integrated Testing for various Mappings, Tested the data and data integrity among various Sources and Targets
• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environments
• Created Bitmap Index, Materialized View
• Configuring Data Warehouse Administration Console (DAC) to create new execution plan and running the Complete Informatica Workflows
• Involved in performance tuning of various mappings and sessions to increase the performance
• Built metadata in the analytics repository with Analytics Administration Tool in physical, business and presentation layers
• Configuring Repository, Session variables to generate dynamic reports.
• Prepared Custom Dashboards and Reports.
• Created users, groups using Web Admin Tool & assigned different dashboards permissions.
• Created, modified and formatted requests, along with charts and filters, in OBIEE. Built new reports and Customized OOTB reports as per business needs
• Assisted User in Designing Report Layouts and Report Structure for better utilization and Understanding of data.
• Worked on Branding of the existing OOTB product for enhanced user adoption
• Installing/troubleshooting of Different OBI Application Components (OBIEE, DAC, and Informatica)
• Defining and implementing Backup strategy for Informatica Repository, DAC repository, OBIEE RPD, and Web Catalog
• Worked for the migration of Repository & Web Catalogs from Development to Test & Production server.
• Guiding / customer’s IT Team during course of the project so that they feel confident about supporting this product post deployment

Environment: OBIEE 11.1.1.6, BI Apps 7.9.6.3, Oracle 11g, Oracle EBS 1212

Confidential, Cleveland, OH

ETL/OBIEE Consultant

Responsibilities:

• Interacting with Customers and participating in gathering requirements
• Analyzing the requirements and converting into the technical documents, Identified the stars (Dimensions/Facts) that needs to be populated
• Unit testing and deployment
• Created Informatica mappings, Sessions and executed them to Load the data from the source system using Informatica Server Manager
• Implementing Slowly Changing Dimensions - Type I & II in different mappings as per the requirement
• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement
• Performed integrated Testing for various Mappings, Tested the data and data integrity among various Sources and Targets
• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environments
• Created Bitmap Index, Materialized View
• Configuring Data Warehouse Administration Console (DAC) to create new execution plan and running the Complete Informatica Workflows
• Built metadata in the analytics repository with Analytics Administration Tool in physical, business and presentation layers
• Configuring Repository, Session variables to generate dynamic reports.
• Prepared Custom Dashboards and Reports.
• Created users, groups using Web Admin Tool & assigned different dashboards permissions.
• Created, modified and formatted requests, along with charts and filters, in OBIEE. Built new reports and Customized OOTB reports as per business needs
• Assisted User in Designing Report Layouts and Report Structure for better utilization and Understanding of data.
• Worked on Branding of the existing OOTB product for enhanced user adoption
• Involved in increasing the performance of Report
• Installing/troubleshooting of Different OBI Application Components (OBIEE, DAC, and Informatica)
• Defining and implementing Backup strategy for Informatica Repository, DAC repository, OBIEE RPD, and Web Catalog
• Worked for the migration of Repository & Web Catalogs from Development to Test & Production server.
• Guiding / customer’s IT Team during course of the project so that they feel confident about supporting this product post deployment

Environment: OBIEE 10.1.3.4.1 , BI Apps 7.9.6, Oracle 10g, Oracle EBS 12.1.1

Confidential, Kansas City, Missouri

ETL/OBIEE Consultant

Responsibilities:

• Interacting with Customers and participating in gathering requirements
• Analyzing the requirements and converting into the technical documents, Identified the stars (Dimensions/Facts) that needs to be populated
• Implementation and Go-Live
• Created Informatica mappings, Sessions and executed them to Load the data from the source system using Informatica Server Manager
• Implementing Slowly Changing Dimensions - Type I & II in different mappings as per the requirement
• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement
• Performed integrated Testing for various Mappings, Tested the data and data integrity among various Sources and Targets
• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environments
• Created Clustered and Non Clustered Indexes
• Involved in performance tuning of various mappings and sessions to increase the performance
• Configuring Data Warehouse Administration Console (DAC) to create new execution plan and running the Complete Informatica Workflows
• Built metadata in the analytics repository with Analytics Administration Tool in physical, business and presentation layers
• Configuring Repository, Session variables to generate dynamic reports.
• Prepared Custom Dashboards and Reports.
• Created users, groups using Web Admin Tool & assigned different dashboards permissions.
• Created, modified and formatted requests, along with charts and filters, in OBIEE. Built new reports and Customized OOTB reports as per business needs
• Assisted User in Designing Report Layouts and Report Structure for better utilization and Understanding of data.
• Worked on Branding of the existing OOTB product for enhanced user adoption
• Installing/troubleshooting of Different OBI Application Components (OBIEE, DAC, and Informatica)
• Defining and implementing Backup strategy for Informatica Repository, DAC repository, OBIEE RPD, and Web Catalog
• Worked for the migration of Repository & Web Catalogs from Development to Test & Production server.
• Guiding / customer’s IT Team during course of the project so that they feel confident about supporting this product post deployment

Environment: OBIEE 10.1.3.4.1 , BI Apps 7.9.6, Oracle 10g, SQL server 2005, Oracle EBS 11.5.10

Confidential

ETL Consultant

Responsibilities:

• Interacting with Customers and participating in gathering requirements
• Analyzing the requirements and converting into the technical documents, Identified the stars (Dimensions/Facts) that needs to be populated
• Performance optimization of the ELT process
• Unit testing and Code migration to QA and Prod repository
• Used Reverse-engineering knowledge modules to read the table and other object metadata from source databases
• Journalizing knowledge modules to record the new and changed data within either a single table or view or a consistent set of tables or views
• Used loading knowledge modules to extract the data from source databases for loading into a staging area and Check knowledge modules to detect errors in source data
• Use IKM Incremental Update Knowledge Module for Both Insert n Update operations
• Using Integration knowledge modules to efficiently transform data from staging area to the target tables, generating the optimized native SQL for the given database
• Created Interfaces, packages and procedures
• Implementing CDC in different mappings as per the requirement
• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement
• Performed integrated Testing for various Mappings, Tested the data and data integrity among various Sources and Targets
• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environments
• Created Clustered and Non Clustered Indexes
• Built metadata in the analytics repository with Analytics Administration Tool in physical, business and presentation layers
• Configuring Repository, Session variables to generate dynamic reports.
• Prepared Custom Dashboards and Reports.
• Created users, groups using Web Admin Tool & assigned different dashboards permissions.
• Created, modified and formatted requests, along with charts and filters, in OBIEE. Built new reports and Customized OOTB reports as per business needs
• Assisted User in Designing Report Layouts and Report Structure for better utilization and Understanding of data.
• Worked on Branding of the existing OOTB product for enhanced user adoption
• Installing/troubleshooting of Different OBI Application Components (OBIEE, ODI)
• Defining and implementing Backup strategy for ODI Repository, OBIEE RPD, and Web Catalog
• Worked for the migration of Repository & Web Catalogs from Development to Test & Production server.