SUMMARY:
- Five years of experience in analysing and implementing the business intelligence solutions .
- Having experience in capturing the business requirements, poc, resource estimation and execution strategy planning for smooth production delivery.
- Expertise in providing end - to-end business intelligence solutions by configuring metadata & building Analytics Repository, dimensional modeling design, building business data marts, generating reports, and creating Interactive Business Intelligence Dashboards using Oracle Business Intelligence .
- Excellent understanding of Dimensional modeling techniques such as Star and Snow flake Schema methodologies.
- Experience in using Master-Detail Event navigation, Mapview,Oracle eLocator.
- Worked in different Industrial Verticals and well experienced in Finance and HR Functional Areas.
- Deployment of rpd/webcat, creating application roles, groups, setting the configuration parameters using Enterprise Manager/Weblogic console.
- Experience in developing reports and configuring various delivery options in BI Publisher and Capacity, Scaling and Performance planning in OBIEE.
- Extensively designed Interactive Dashboards, incorporating user friendly capabilities such as dashboard prompts, navigation, drill-down and Web Catalog Objects using OBIEE.
- Experience in creating OBIEE Scorecards for various KPIs, enabling write back feature Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Analysis by implementing Aggregate navigation, cache management and materialized views.
- Excellent problem solving skills with strong technical background and having the ability to meet deadlines and quickly master new technologies and skills.
TECHNICAL SKILLS:
FMW Technologies: Orace Business intelligence Enterprise Edition, Oracle BI Cloud Service, Oracle BI Publisher, Weblogic
ETL: PL/SQL
Tools: Toad, SQL Developer
Databases: Oracle 10g/11g, MS SQL Server
Programming Languages: SQL, PL/SQL, c
Operating System: Linux, Windows
PROFESSIONAL EXPERIENCE:
Confidential, New Jersey
Sr. OBIEE Analyst
Responsibilities:
- Coordinating with product management for gathering the requirements and writing functional specification documents.
- Analyzing the requirements, performing feasibility and gap analysis for existing FTI Catalyst Repository and dashboards.
- Logical and Physical data modeling was done for FTI Catalyst data warehouse in STAR Schema.
- Using Informatica Power center created mapping and mapplets to transform the data according to the business rules.
- Used various transformations like Source Qualifier, Joiner,Lookup,Filter, Expressions and Update strategy.
- Created and configured workflows and sessions to transport the data to target warehouse Oracle tables using informatics workflow manager.
- Developed stored procedures and used them in Stored procedure transformations for data processing and have used data migration tools.
- Designed FTI Catalyst repository data model and dashboards for Productivity, Core Measures subject area.
- Implemented various Time Series calculations and dimensional Ragged/Skipped hierarchy, Master detail’s events.
- Added performance tuning parameters across Weblogic, BI Server, BI Presentation server.
- Configured monthly alerts for FTI Catalyst summary dashboard page for executives and department managers.
- Involved in upgrade FTI Catalyst dashboard and repository and security migration from 10.1.3.4.2 to 11.1.1.7.0 . Resolved various 11g upgrade issues.
Environment: OBIEE 10.13.4.2,OBIEE 11.1.1.1.7.0, Oracle DB 11g, Informatica 8.1,PL/SQL,SQL, Web logic Server,, Enterprise Manager, Windows 7
Confidential
Sr. OBIEE Consultant
Responsibilities:
- Interacted with business teams to gather Business Requirements as well as to define business and functional specifications for new and BAU enhancements.
- Involved design and development of repository (RPD) (creating/Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
- Expressions mapped logical columns in BMM layer to physical columns in the physical layer. Developed Reports/ Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Column Selector, Tabular with global and local Filters).
- Used Filters and provided Customized prompts appropriately to avoid excessive data showing up in reports to improve performance.
- Administered Permissions and Privileges for dashboard visibility and modifications to Users based on their groups or responsibilities.
- Responsible for implementing Object level security for the various users who would be using the BI system.
- Extensively involved in setting up Data level security for the BI Reports and also handled the security and privileges from the Database to the Oracle repository.
- Setting up the Administered Privileges and Security for various users using the LDAP security.
- Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes
- Involved in migration of OBIEE 10g to OBIEE 11g by doing minimal RPD changes where ever it is required to accomplish 10g results.
- Communicating with Oracle product team on the product limitations after 11g upgrade in terms of data download issues(like excel 2003, 2007)
- Security User maintenance by migrating existing 10g user list to LDAP Authentication service support in 11g.
- Managed SIT, UAT tests for the 10g and 11g using HP ALM Application.
Environment: OBIEE 10.13.4.2,OBIEE 11.1.1.1.7.1, OBIA 7.9.6.2, Oracle DB 10g,PL/SQL,SQL, Web logic Server, Enterprise Manager, Unix, Shell script