We provide IT Staff Augmentation Services!

Obiee Consultant Resume

Irving, TexaS

SUMMARY:

  • Over 6+ years of diversified experience in the field of Information Technology with an emphasis on Data warehousing which includes extensive experience in OBIEE formerly SiebelAnalytics and Datawarehousing tools.
  • Experience in installing and configuring OBIEE.
  • Extensive experience in implementing OBIEE for Sales, HumanResources and Order Management, CSW, Finance and Supply Chain analytics.
  • Experience in interacting with Business users to analyze the business process and gathering requirements.
  • Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects (Dimensions, Facts & Aggregates) into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
  • Experience in setting up the usage tracking, Creating Variables/Initialization Blocks.
  • Implemented Data level and Object level security.
  • Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, OBIEE Security Setup (groups, access privileges), Metadata objects and Web Catalog objects (Dashboard, Pages, Folders, Reports).
  • Developed many Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Pivot table, Chart, Column Selector, View Selector, Narrative, Ticker, static Text, Tabular with local and global filters) using OBIEE Answers.
  • Configured and scheduled Intelligence agents (ibots) to send the real-time Alerts to the end users using Delivers and Created reports using BI Publisher.
  • Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema Dimensional Data Modeling used in relational, dimensional modeling, Erwin data modeling and Slowly Changing Dimensions.
  • Good experience in ETL process using Informatica PowerCenter for various transactions and loading data from various legacy data sources.
  • Expertise in debugging and optimizing Siebel Analytics Dashboards / Reports.
  • Good experience in Oracle and hands on on UNIX Shell scripting and extensively used TOAD.
  • Good understanding of Software Development Life Cycle (SDLC).
  • Hands on experience in BI Apps, DAC.
  • Excellent communication skills, Good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, sincere, eager to learn, ability to grasp quickly.

Technical Skills:
BI Tools: Siebel Analytics 7.x, OBIEE 10.1.3.x (Oracle BI Administration,
Oracle BI Presentation, Oracle BI Dashboards, Oracle BI Delivers,
Oracle BI Publisher, Catalog Manager), BO, Brio/Hyperion.
Data Warehousing: Informatica Power Center/Power Mart8.1.x/7.1.x/6.2.x.
Data Modelling: Erwin 3.x/4.x
Databases: Oracle 8i/9i/10g/11g, SQL Server 2005/2000, MS Access, DB2,
Languages: SQL, PL/SQL, C, C++, HTML, XML, Java Script and VB.
OperatingSystem: Windows XP/ NT/95/98/2000, MS DOS, LINUX.
SQLTools: SQL Developer, TOAD.

Work Experience:

Confidential, Irving,Texas
OBIEE Consultant Oct 2009 - Till Now
Confidential, is a leading provider of global IT, security, and communication solutions, with one of the world's most connected IP networks. It combines broad range of strategic solutions, services, and expertise to help some of the world's largest organizations- including 96% of the Fortune 1000 - and governments - meet the challenges of their increasingly extended enterprises.

Responsibilities:

  • Every day attend Follow up calls about the OBIEE Buisness Processes with End Users and Team Members.
  • Created Repositories by building physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin tool
  • To Create Connection pools import physical tables and define joins in physical layer
  • Developed and Customized Some of the existing Dimensions (Drill Down Heirarchies) & Logical Objects in Business Model and Mapping Layer and Presentation Catalogs in the Presentation Layer.
  • Created Aggregations and Logical Based Measures in Business Model and Mapping Layer. Created Analytical Views (Compound Layout,chart,pivot etc.,) and Global/Local Prompts to design the Dashboards.
  • Created Security Settings in Oracle Administration Tool to setup Groups and Provide Access Privileges and Query Priviliges and also managed security for Groups in BI Answers.
  • Developed Dashboards for each of metrics by embedding reports and providing intuitive drill-downs and links to exploit the full benefit of Analytics in providing summary and detail reports.
  • Used OBIEE Delivers to automate iBot queries, obtain weekly reports and to send alerts to related managers and secured team members.
  • Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
  • Used DAC (Data warehouse Application Console) for both incremental and full loads.
  • Monitored and Scheduled ETL along with reducing application configuration and development time by using DAC.
  • Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
  • Involved in developing the Incremental ETL process (Mappings & Mapplets) using various Transformation and Workflows with Sessions/Tasks, executed workflows through shell scripts using pmcmd.
  • Created & saved several BI Publisher reports by selecting an Answers request as Data Source.
  • Built multiple execution plans in DAC for weekly and daily loads.
  • Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema).
  • Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
  • Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Informatica Power Center 8.6, Data Warehouse Administration Console (DAC), Oracle BI Publisher, Oracle Delivers,Windows XP, UNIX/LINUX Oracle 11g/10g, SQL,ODI, PL/SQL, and TOAD 6.3/7.0.

Confidential, St. Louis Mar 2008 - Sept 2009
Role: OBIEE consultant

Confidential, is the largest provider of local, long distance telephone services in the United States, and also sells digital subscriber line Internet access and digital television.
Project: Implementing HR analytics as part of setting up the warehouse environment for BI.

Responsibilities:

  • Worked closely with the business users to identify various KPI\'s and designed solutions to enhance business decision-making.
  • Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
  • Worked on Oracle BI EE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
  • To create Connection pools, import physical tables and define joins in the Physical Layer.
  • Developed and customized some of the existing Dimensions (Drill-Down Hierarchies) & Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
  • Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
  • Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in BI Answers.
  • Designed dashboards and reports for role based users like Executive Management, Rep Level.
  • Developed Dashboards for Compensation, Retention, Performance and Workforce.
  • Developed Reports like Turnover Demographics, Trend Analysis, Top performers, Employee lists, overtime expenses, Headcount Trend and many more.
  • Developed Dashboards for each of metrics by embedding reports and providing intuitive drill-downs and links to exploit the full benefit of Analytics in providing summary and detail reports.
  • Used OBIEE Delivers to automate iBot queries, obtain weekly reports and to send alerts to related managers and secured team members.
  • Used DAC (Data warehouse Application Console) for both incremental and full loads.
  • Monitored and Scheduled ETL along with reducing application configuration and development time by using DAC.
  • Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
  • Created & saved several BI Publisher reports by selecting an Answers request as Data Source.
  • Built multiple execution plans in DAC for weekly and daily loads.
  • Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema.
  • Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
  • Designed and documented the custom ETL process to gather data from different data sources to populate the OLAP database (Star Schema).
  • Extensively involved in performance tuning.
  • Closely worked with ETL team and DBAs for query tuning.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.2, Informatica Power Center 7.1.4, Data Warehouse Administration Console (DAC), Oracle BI Publisher, Oracle Delivers, Windows XP & SQL.

Confidential, Wamu San Francisco, CA Feb 2007 - Feb 2008
Role: OBI Developer

The Wamu marketing data warehouse processes 25 million credit card accounts, 46 million customers, 21 million Retail customers, and 3 Million mortgages. The campaign data mart aims to provide a Central Repository and a Decision support system. There are approximately 400 users of the data. It supports analytics; weekly campaign offers (Credit Cards, Retail Bank and Home Loans). There are 463 data extraction workflows and most of them are updated on daily, weekly, and monthly basis. The department is using the onshore/offshore model (24/7).
Project: The goal/objective of this project is to analyze and measure the effectiveness of various marketing campaigns initiated by the marketing group.

Responsibilities:

  • Customized OBIEE Applications Financial management module based on the business requirements.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
  • Configured and Created repository using OBIEE 10.1.3 Admin tool.
  • Created numerous executive level reports. 'Dashboards' were generated to provide insight into the marketing/financial data.
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
  • Analyzed and validated the Oracle BI repository by performing consistency check as per the oracle best practices.
  • Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements
  • Designed and customized RPD's, Oracle Answers (webcat), Dashboards and Cache.
  • Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
  • Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables.
  • Generated various Analytics Reports like Formulary Report and Direct Sales Report using global and local filters.
  • Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
  • Involved in managing appropriate Security privileges on subject areas and dashboards according to business requirements.
  • Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
  • Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
  • Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Informatica Power Center 8.1,Oracle Delivers, BI Publisher, Windows XP, UNIX/LINUX, Shell Scripting, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0, EPM 8.9 on Oracle 10g.

Confidential, Boca Raton,FL Oct 2005 - Jan 2007
Role: Siebel Analytics Consultant

Confidential, based in Confidential, FL, manages the nation's largest database of workers compensation insurance information. The purpose of this project is to create and maintain a central data warehouse and to create reports for the financial group for further business analysis. Siebel analytics was implemented for the generation of the reports.

Responsibilities

  • Worked closely with Business Analyst in understanding the Analytics requirements and created the business model for generating reports as per the user requirements.
  • Worked closely with the data modeler in designing the logical data model/physical data model (star schema).
  • Configured and created repository using Siebel Analytics Administration Tool.
  • Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation.
  • Layer in a Siebel Analytics Repository using Siebel Analytics Administration Tool.
  • Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
  • Involved extensively in Siebel Answers, Siebel Delivers, and Siebel Intelligent Dashboards with Siebel.
  • Analytics Integrated implementation (Siebel Business Analytics Applications).
  • Involved in Data Modeling and Data Mapping review, including sources, staging areas, and target database.
  • Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
  • Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
  • Suggested and implemented Siebel recommended Performance tuning practices to improve Siebel Analytics server performance by implementing Query Caching, using aggregate tables, tuning & reorganizing database indexes and configuring NQSConfig.INI files performance parameters.
  • Involved in developing different kinds of reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboard.
  • Created Security settings in Siebel Analytics Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in Siebel Answers.
  • Used filters and provided customized prompts (filtering options) appropriately to avoid excessive data visibility in reports.
  • Involved in unit testing, integration testing of the reports generated using Siebel Analytics.

Environment: Oracle 9.2.0.6, Informatica Power Center7.1.4, Erwin, SQL, PL/SQL, TOAD 7.3, Siebel Analytics 7.8.2, HP UNIX's, and Microsoft tools Excel, Word.

Education:

  • Bachelor of Information Technology

Hire Now