We provide IT Staff Augmentation Services!

Senior Obiee Consultant Resume

Saint Louis, MO

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.

Hire Now