We provide IT Staff Augmentation Services!

Bi Lead (obiee & Tableau) Resume

Horsham, PA

SUMMARY:

  • Over 11 years of extensive IT experience involving a blend of client - server technologies with focus on CRM and Data Warehousing solutions using Siebel Analytics, Oracle BI (OBIEE 11g, OBIEE 10g), Hyperion Essbase 11x, BI Publisher, Oracle 10 g, 11g, 11i and Informatica 8.6 . Have extensive track record of success in applying BI/BPM solutions to improve business performance, and extensive experience with the HYPERION suite of products specializing in Oracle BIA and OBIEE 10 g, 11i.
  • Very strong experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, and Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges) and scheduling reports.
  • Extensive Dimensional Modelling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables (OBIEE).
  • Involved in designing & implementing complex ETL/BI systems.
  • Expertise in End to End system design, System Feasibility study, system redesign/engineering and implementation with significant experience in Data Modelling/Data Quality Analysis.
  • Strong domain knowledge in Retail Industry - Involved in Marketing, Sales and Customer Analytics
  • Developed and Implemented Market Basket Analysis and RFM Analysis for Retail Clients.
  • Worked on ETL and BI tools like Informatica, MS DTS, Oracle Business Intelligence Enterprise Edition Plus (Siebel Analytics), OBIEE, Oracle OLAP, Microsoft BI Development Studio (SSRS, SSAS & SSIS) and Databases like Oracle 11i & MS SQL Server 2008, 2015.
  • Got strong analytical & problem solving skills using Structured Query Language and MDX.
  • Gathered Business requirements by interacting with the business users.
  • Performed gap analysis and feasibility study for the given requirement.
  • Strong knowledge in RDBMS.
  • Extensive experience in testing the Data Warehouse and Business Intelligence applications.
  • Got good pre-sales consulting skills.
  • Worked on various RFI’s, RFP’s and POC’s.
  • Self-motivated; able to work independently and in teams; can handle multiple projects while paying attention to details.
  • Ability and desire to mentor/coach others in a team environment.
  • Extensive experience in utilizing Business intelligence tools for the design and deployment of Data Marts supporting Enterprise Data Warehouses
  • Experienced with Hyperion-Essbase 11x, OLAP, MSBI, Oracle 11g, 11i
  • Expert in customization of Siebel Analytics and Oracle BI, OBIEE 10g, 11g.
  • Extensive expertise in OBIEE Analytics Web, OBIEE Administration tools.
  • Involved in the data analysis for source and target systems, designing and developing denormalized multi-dimensional Star Schema and Snowflake Schema data models.
  • Proficient in Installing and Configuring OBIEE.
  • Extensive expertise in Data Warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation
  • Experienced in installation, Configuration and Administration of Informatica power/Center/Power mart on client/server environment.
  • Expertise in deriving Analytical, Logical, Physical, Dimensional and Statistical Data Models in OBIEE
  • Proficient in SQL, Procedures/Functions.
  • Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

RDBMS: Oracle10g, 11g, SQL Server 2005, 2008, 2012 MySQL, MS Office 2013, MS Visio.

ETL Tools: Informatica 8.6, 9.0. SSIS.

OLAP: Hyperion 9.3.3, SSAS, Oracle 11g, 11i

Operating Systems: Windows NT, 95/98, 2000, XP, VISTA, 7 and 8.

Data Modeling: Reporting (CRM)

Hyperion: Erwin 3.5.2, 4.0, Toad 9.0.1, 10.1.1

Siebel Analytics: 7.1, Oracle BI, OBIEE 10g, OBIEE 11g, MSBI, Tableau.

HYPERION ESSBASE: (9.3.1, 10x); load rules, dimension build rules, calc scripts, report scripts, task lists, smart lists, menus, Dynamic calc scripts, shared services, ODI, star analytics/integration service (EIS).

PROFESSIONAL EXPERIENCE:

Confidential

BI Lead (OBIEE & Tableau), Horsham, PA

Responsibilities:

  • Analytical expertise in OBIEE and Data warehouse.
  • Evaluation of profitability/risk
  • Identified the granularity level of the data required to be available for analysis
  • Worked on business requirements and designed design documents.
  • Is closely involved with the business community to get the requirements
  • Knowledge of business processes. Ability to have a business-oriented vision
  • Worked closely in creating materialized views in physical layer (OBIEE)
  • Coordinated in designing star schema and dimensional model.
  • Worked on configuring the OBIEE RPD in the physical, Business and Presentation Layer.
  • Extensively worked in business model layer to map the business requirement.
  • Worked on setting up aggregate level and level based measures.
  • Worked on setting up dimensional hierarchy.
  • Improvement of business and engineering processes
  • Strategic planning; Case development, Testing and UAT.
  • Designed reports based on the business requirements in the Siebel answers.
  • Designed intelligence OBIEE Dashboards based on the business requirement.
  • Experienced in working with pivot table format and graphs in OBIEE reporting.
  • Implemented security in Siebel Analytics using LDAP authentication.
  • Involved in unit, integration testing and User Training of the generated reports using Siebel Analytics.
  • Worked extensively on Siebel analytics usage tracking, to track the data usage, which helped in identifying the threshold.

Environment: OBIEE 11g, Informatica 8.6, 9.0, Oracle 11i, SQL Navigator 4.5, Erwin 4.0, Toad 12.1.

Confidential

OBIEE Developer, Lead, Columbus, IN

Responsibilities:

  • Analytical expertise in OBIEE and Data warehouse.
  • Evaluation of profitability/risk
  • Identified the granularity level of the data required to be available for analysis
  • Worked on business requirements and designed design documents.
  • Is closely involved with the business community to get the requirements
  • Knowledge of business processes. Ability to have a business-oriented vision
  • Worked closely in creating materialized views.
  • Coordinated in designing star schema and dimensional model in OBIEE.
  • Worked on configuring the Siebel Analytics RPD in the physical, Business and Presentation Layer.
  • Extensively worked in business model layer to map the business requirement.
  • Worked on setting up aggregate level and level based measures.
  • Worked on setting up dimensional hierarchy.
  • Improvement of business and engineering processes
  • Strategic planning; Case development, Testing and UAT.
  • Designed OBIEE reports based on the business requirements in the OBIEE answers.
  • Designed intelligence Dashboards based on the business requirement.
  • Experienced in working with pivot table format and graphs.
  • Implemented security in Siebel Analytics using LDAP authentication.
  • Involved in unit, integration testing and User Training of the generated reports using Siebel Analytics.
  • Worked extensively on OBIEE usage tracking, to track the data usage, which helped in identifying the threshold.

Environment: Oracle BI, OBIEE 10g, OBIEE 11g, MSBI, Oracle 11g, 11i.

Confidential

OBIEE Lead, Development Lead, Olathe, KS

Responsibilities:

  • Working extensively in migrating the traditional MRE reporting to user friendly BI Siebel Analytics.
  • Identified the granularity level of the data required to be available for analysis for OBIEE
  • Worked on business requirements and designed design documents.
  • Is closely involved with the business community to get the requirements
  • Involved in identifying fact and dimensions for Business needs.
  • Worked closely in creating materialized views.
  • Coordinated in designing star schema and dimensional model in OBIEE.
  • Worked on configuring the Siebel Analytics RPD in the physical, Business and Presentation Layer.
  • Extensively worked in business model layer to map the business requirement.
  • Worked on setting up aggregate level and level based measures.
  • Worked on setting up dimensional hierarchy.
  • Designed OBIEE reports based on the business requirements in the Siebel answers.
  • Designed OBIEE intelligence Dashboards based on the business requirement.
  • Experienced in working with pivot table format and graphs.
  • Implemented security in Siebel Analytics using LDAP authentication in OBIEE
  • Worked on security users and groups for various level of security.
  • Involved in unit, integration testing and User Training of the generated reports using Siebel Analytics.
  • Worked extensively on OBIEE usage tracking, to track the data usage, which helped in identifying the threshold.

Environment: OBIEE 10g, 11g, Informatica 8.6, Oracle 11g, 11i SQL Server 2008, Erwin 4.0

Confidential

OBIEE Developer/BA, Project Lead, Overland Park, KS.

Responsibilities:

  • Worked on business requirements and designed design documents OBIEE reports.
  • Worked closely in creating materialized views in OBIEE repository.
  • Coordinated in designing dimensional model, Dense dimension, Sparse dimension
  • Worked on complex calculation, writing calculation script.
  • Experienced in creating, dimension, dimensional hierarchy
  • Experienced in loading data, sending data and performing calculation.
  • Proper understanding of block storage data and Aggregate storage data (ASO and BSO).
  • Worked on user’s security and groups for various level of security for OBIEE.
  • Accomplished senior level IT professional in the EPM / BI technologies successfully.

Environment: Hyperion 9.3, Essbase Server 7.6.5, OBIEE 10g 11 g, Informatica 8.6, Oracle 10g, 11i.

Confidential

Siebel Analytics Developer/BA, OBIEE Developer, Overland Park, KS

Responsibilities:

  • Working extensively in migrating the traditional MRE reporting to user friendly BI Siebel Analytics.
  • Identified the granularity level of the data required to be available for analysis
  • Worked on business requirements and designed design documents.
  • Is closely involved with the business community to get the requirements
  • Worked closely in creating materialized views.
  • Coordinated in designing star schema and dimensional model.
  • Worked on configuring the Siebel Analytics RPD in the physical, Business and Presentation Layer.
  • Extensively worked in business model layer to map the business requirement.
  • Worked on setting up aggregate level and level based measures.
  • Worked on setting up dimensional hierarchy.
  • Worked on schedulers and cache reports.

Environment: Siebel Analytics 7.7.1, Informatica 6.2, Oracle 9i, SQL Navigator 4.5, Erwin 4.0

Confidential

OBIEE Lead/BA, Hyperion Essbase Developer, Atlanta, GA

Responsibilities:

  • Involved in designing the reporting needs of Business and practice Data Warehouse concepts.
  • Working extensively in migrating the traditional MRE reporting to user friendly BI Siebel Analytics.
  • Identified the granularity level of the data required to be available for analysis for OBIEE.
  • Worked on business requirements and designed design documents.
  • Is closely involved with the business community to get the requirements
  • Involved in identifying fact and dimensions for Business Industry.
  • Worked closely in creating materialized views in OBIEE.
  • Coordinated in designing star schema and dimensional model.
  • Worked on configuring the OBIEE RPD in the physical, Business and Presentation Layer.
  • Extensively worked in business model layer to map the business requirement in OBIEE.

Environment: OBIEE 10g, 11g, Informatica 8.6, Oracle 11g, SQL Navigator 4.5, Erwin 4.0

Hire Now