We provide IT Staff Augmentation Services!

Sr.bi Consultant Resume

Seattle, WA

SUMMARY:

  • Over 8 years of IT Experience, which includes 8+ years of experience in Oracle Business Intelligence Enterprise Edition (OBIEE 11.x, 10.x, OBIA 7.9.x, Micro strategy 9.X)
  • Expertise in developing business intelligence solutions by using Data Warehousing and OLAP techniques.
  • Expertise in developing/customizing OBIEE Repository (. rpd), at all three layers (Physical Layer, Business Model & Mapping Layer and Presentation Layer) using Oracle Business Intelligence Administration Tool.
  • Experienced in implementing security at various levels (Object level/Data Level).
  • Experienced in creating Level Based Measures, Time series measures, Repository and Session Variables.
  • Experienced in Creating/Customizing Reports with different views (Table/ PivotTable/ Gauge/ Column Selector/ View Selector) using Oracle Business Intelligence Answers
  • Extensive experience in Creating/Configuring Interactive Dashboards with drill - down capabilities.
  • Experienced in using Oracle BI delivers including Configuring and Scheduling Agents/iBots to deliver alerts, reports to various Business Users.
  • Experienced in Using BI Publisher for Creating Reports, Templates.
  • Experienced in performance tuning of Oracle BI Repository & Dashboards / Reports, by implementing Aggregate tables, Indexes and managing Cache and proper content filters.
  • Experienced in data modeling using dimensional data modeling, star schema/snow flake schema, fact and dimension tables, physical and logical data modeling in OBIEE.
  • Expertise in Design and development, maintenance, testing and documentation.
  • Experienced in project management and knowledge of all the phases in a Software Development Life Cycle (SDLC) i.e. Analysis, Design, Building and Testing.
  • Extensively worked on Microstrategy Desktop to create both Schema and Public objects. Includes, Metrics, filters, Prompts, Custom Groups, Facts, Attributes, Hierarchies, Free form SQL Reports, Logical Views, Reports, Documents etc.,
  • Experienced in installing and configuring OBIEE and integrating with various applications Micro strategy, Web focus, Oracle JDE etc.,
  • Data warehousing /ETL experience using Informatica Power Center and Oracle Data Integrator (ODI) to Support the Data warehouse implementations.
  • Used Informatica client tools like Source analyzer, Mapping designer, Mapplet designer, Transformation designer, Repository manager to perform the ETL tasks.
  • Monitored the jobs using DAC and fixed various that occurred during the loads.
  • Business Analysis experience with excellent communication and interpersonal skills, broad understanding of business operations and requirements.

TECHNICAL SKILLS:

Analytics: OBIEE 12C,11.1.1.x, OBIA 7.9.6.X, MSTR 9.x, Webfocus, TABLEAU, BIRST

ETL Tools: Informatica (Power center 8.x/9.x),DAC,ODI 11.1.1.X

Tools: /Utilities: SQL Loader, Data Studio, SQL developer, TOAD, PL/SQL Developer

Operating systems: Windows 98/2000/XP/Vista.

RDBMS: DB2, Oracle 11g/10g/9i/8i, SQL Server 2000/2005

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Sr.BI Consultant

Responsibilities:

  • Gathered Omnicare requirements and worked with end users to understand business functionality and reporting expectations.
  • Reverse engineered Micro Strategy (BI Tool) model, Web focus reporting structure and built roadway to implement in OBIEE.
  • Decoded. fex files and converted the code to SQL to be used in building the OBIEE reports.
  • Decoded Parm Files and built different report and dashboard prompts to filter the data based on the requirements.
  • Extensively worked on rpd and its components to support entire BI Model.
  • In order to support the business statistics and to understand the customer relations, created various dashboards for Payables, Receivables based on the Ledger information.
  • Implemented Data level and Object level securities to manage user access to Reports, Dashboards.
  • Created Interactive Dashboards to represent the User requirements in a meaningful format using Tableau Desktop.
  • Developed various workbooks in Tableau by importing data from various Sources and transformed based on business logic to support the report criteria.
  • Built highly intuitive reports, analyses and dashboards in Tableau in support of Day to day operations.
  • Migrated Rpd and Catalog Objects across different environments.
  • As the Customer is migrating from Microstrategy to OBIEE, created additional new dashboards which would be helpful for further business analysis.

Environment: OBIEE 11.1.1.7, Microstrategy 9.x, Webfocus, Tableau 9.x, Oracle 11g, Oracle SQL Developer.

Confidential, Philadelphia, PA

Lead OBI Consultant/BI Analyst

Responsibilities:

  • Worked with Business to understand the new requirements.
  • Analyzed the existing RPD model as part of fit gap analysis, to accommodate the new business requirements.
  • Documented the analysis and implementation methodology.
  • Developed the metadata repository (rpd) that involved developing the Physical, Business Model Mapping and the Presentation layer.
  • Created dimensional hierarchies for data at different granular levels as per the business requirements.
  • Improved the performance by including the aggregates in the model and setting the priority group accordingly.
  • Worked on Configuring OBIEE Security parameters at object level, data level to control access to customer data.
  • Created new reports and modified existing reports with different views and Action links at various levels for drill across capability.
  • Created Sales Dashboards for Business users in belonging to various regions.
  • Configured & published Agents to deliver analytics content based on schedule to obtain daily & weekly transactions to all the departments in the organization through emails to alert them about business changes.
  • Involved in design, development and test documentation.
  • Involved in unit testing and integration testing for all components in OBIEE.
  • Interacted with end users and developers to validate the data model, reports and dashboards.
  • Improved performance monitoring by eliminating bottlenecks at different levels.
  • Created different views using Tableau Desktop and Combined visualizations into Interactive Tableau Dashboards publishing them to a web portal.
  • Developer Story telling dashboards using Tableau desktop and published them to BI server that allowed users to understand the current data.
  • Created Tableau workbooks for weekly reporting by establishing connections to various data sources.
  • Expertise in building the custom charts and visualizations and complex calculations-using Tableau.
  • Involved in Unit testing, Integration testing and User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
  • Provided training to the end user’s on OBIEE Answers, Dashboard and Admin tool using OBIEE best Practices.

Environment: OBIEE 11.1.1.7.X, OBIA7.9.6.3, Tableau 9.0, DB2, Data Studio, Windows.

Confidential, Sunnyvale,CA

BI Lead Consultant

Responsibilities:

  • Involved in upgrading various projects from 10G to 11g and responsible for fixing various defects occurred during the upgradation of 10G catalogs.
  • Raised various service requests and worked closely with oracle in finding fixes and patches for the discrepancies of upgraded reports.
  • Analyzed the gathered business requirements and translated the functional specifications into technical specifications.
  • Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.
  • Developed Oracle BI Metadata Model (Repository) based on different requirements, with the necessary logic that involved building the Physical, Business Model Mapping and the Presentation layer.
  • Developed various Measures/Metrics and defined dimensional hierarchies (Time, Locations, and Services etc.)
  • Created different presentation catalogs/folders in the presentation layer for different groups depending on the business requirements.
  • Implemented BI Publisher Data Models, Data Sets and Templates/Sub Templates, which are used to analyze the business functionality.
  • Using BI Publisher bursting feature delivered reports to various destination based on the user roles and responsibilities
  • Created Dashboard Prompts which are used as global filters at a Dashboard level.
  • Created and scheduled Agents to deliver Analytics content for subscribed users and to seed the cache.
  • Designed ETL solutions for the data integration and enterprise data warehouse.
  • Involved in performing the data load using ODI navigators to create monitor and execute the developments.
  • Worked closely with project development managers to ensure overall project time lines.
  • Developed and implemented a design/develop/test methodology for ETL group

Environment: OBIEE 11.1.1.5, OBIEE 10G, Oracle 10g, SQL Developer, Windows 2003.

Confidential, GA

Sr OBIEE Developer/Analyst

Responsibilities:

  • Involved in meetings with Business analysts to update the functional requirement design documents in a systematic manner and to discuss the technical feasibility.
  • Involved in Installing OBIEE 11G on various local systems following the OBIEE recommended Standards.
  • Involved in repository (.rpd) building, based on different requirements, with the necessary logic that involved customizing the Physical, Business Model Mapping and the Presentation layer.
  • Worked closely with System Analyst in order to simplify the various weighted average calculations for different measures (time series, level based etc.) created in BMM to be further used for reporting purposes.
  • Worked on configuring OBIEE Security parameters and assigned Dashboard privileges for controlled access to sensitive customer data.
  • Created Folders/Sub-folders for different user groups and departments in Presentation Layer and managed catalog folders using catalog manager in Analytics as well.
  • Extensively worked on developing and modifying existing Holdings and Transaction reports with various views like pivot table, graph etc.
  • Created Complex Dashboards for business users based on different business units like Investors, Brokerage etc. and created various presentation variables, global and local prompts and implemented guided navigation.
  • Involved in design, development and test documentation.
  • Interacted with end users and developers to validate the data model, reports and dashboards.
  • Worked closely with Data warehousing team at various stages of development (Informatica (ETL), OBIEE) for maintaining the equilibrium.
  • Used catalog manager to migrate Web catalog across the diff environments.

Environment: OBIEE 11.1.1.3, OBIA 11g, Oracle 10g, PL/SQL Developer, Sql server 2008, HP Quality Center 10x, Windows XP.

Confidential

OBIEE Developer

Responsibilities:

  • Participated in User Meetings to understand the requirements.
  • Worked closely with the data modeler in creating logical data model (Star Schema).
  • Built the OBIEE repository/metadata (rpd) (Physical Layer, Business Model and Mapping Layer and Presentation Layer) and created the subject area where reporting and analysis are centered around.
  • Calculated measures like Gross margin, claims in a region, total no of claims etc., in the Business Model and Mapping Layer.
  • Created Users, Groups (Region Manager, receivable manager, stream manager and claims analyst etc.,) and assigned Particular privileges.
  • Implemented Security at object/data Level using session variables.
  • Configured/Scheduled ibots using BI Delivers to deliver alerts to managers/executives about updates like (Critical Claims etc,).
  • Migrated BI publisher reports to multiple environments.
  • Developed User documents for internal analysis using BI Publisher.
  • Built various PDF, RTF and Excel templates and modified existing XML, XSLT, SQL code to support the model using Publisher.
  • Scheduled bursting of the reports to e-mail or file location based on the business necessity using BI Publisher.
  • Developed user guides for the end users had some screenshots of high level reports and providing instructions in accessing them.

Environment: OBIEE 10.1.3.4, Oracle, PL/SQL, Windows Server 2003.

Hire Now