SUMMARY

• OBIEE Consultant with overall 8+ years of experience in the areas of Business Intelligence and Data warehousing tools like OBIEE 12c, 11g, 10g, BI Publisher, Microsoft Power BI, ODI 12c & Oracle Analytics Cloud (OAC).
• Expertise in Business Intelligence, Data Management, Data Modeling, Data Mining and Data Visualization.
• Expertise in maintaining Business Intelligence entire system, Experience in providing end - to-end Business Intelligence solution by dimensional modeling design, developing, and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, Security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and Scheduling Agents.
• Extensive technical experience and strong programming knowledge in Oracle 10g, 11g and 12c.
• Translating Business requirement to functional design document and preparing technical design which talks about technical details on ETL side including Data model changes and RPD design followed by reports design.
• Extensive experience in building template format using RTF, Excel and XSLT. Hands on dealing with complex RTF templates with multiple formats and complex coding. Good hands-on creating Bursting reports across enterprise level business users.
• Through understanding and working knowledge on Power BI Desktop version and pinning to dashboards with various views.
• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions. Worked on all kind of reports such as Yearly, Quarterly, Monthly and Daily.
• Created Workspace and Content packs for business users to view the developed reports and
• Scheduled Automatic refresh in Power BI Service.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all types of transformations that are available in Power BI query editor.
• Posting power BI reports to Microsoft SharePoint Sites for easy use of internal teams. Integration Microsoft Flow to post files into SharePoint using One Drive for business tool.
• Hands on experience in troubleshooting informatica out of the box Informatica workflows, Mapplets & mappings to the source systems tables, and enhancing the customization in ETL mappings.
• Hands on experience in handing ODI exporting and importing scenarios, Load Plans, Work Repositories and Master Repositories from one environment to other.
• Hands on experience in Installation, Configuration, Up-Gradation, Customization, Migration and Administration of Oracle BI Apps, OBIEE, Informatica Power Center and DAC.
• Managing the BI Publisher administration task with all the installation, configuration, and migration activities.
• Extensive experience in implementing various Authentication and Authorization mechanisms in OBIEE using External Database, LDAP, Native OBIEE Security.
• Expertise in handling all phases of Quality Assurance Life Cycle (QALC), Agile Model and Software Development Life Cycle (SDLC) of the BI Projects.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• Expert in implementing and handling the complex environments which include clustering of servers, back up and Failover Strategies with connected and disconnected analytics.
• Experience in performance tuning at the Database level by creating Aggregate tables, Bitmap, B-Tree Indexes, RPD level by creating Database hints in Physical Layer and Tuning Reports.
• Expertise in developing new reports, testing, and customizing existing reports using SQL procedures, Reports in XML/BI Publisher and OBIEE by interacting with the business analysts and end users.
• Strong experience in hierarchies, complex and foreign joins, initialization block, session and non-session variables, calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
• Expertise in gathering business requirements from end users and develop technical solutions.
• Proven ability to quickly learn and apply new technologies. Excellent analytical, problem-solving skills and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS

BI Tools: OAC 105.2, OBIEE 12.2.1.x, OBIEE 11.1.1.x/10.1.3.x, Microsoft Power BI, BI Publisher 12c/11g

ELT Tools: ODI 12c

ETL Tools: Informatica 8.6

Databases: Oracle 12c, 11g, 10g

Ticketing Tools: Jira, ServiceNow, HP Quality Center

Operating systems: Windows and Linux

PROFESSIONAL EXPERIENCE

Confidential

OBIEE Developer

Responsibilities:

• Working closely with Enterprise Data warehousing Team for providing updated date to Data Lake (holds all different projects data) and support with power BI reports.
• Worked on Migrating small set of analytics to Power BI, Convert all safety reports from OBIEE to Power BI.
• Participated in POC using third part plugins (BI Connect Driver tool) to connect OBIEE RPD from Power BI so that we can reuse all the existing models without rebuilding from scratch.
• Good Hands-on Creating reports and models in Power BI using multiple sources available.
• Redesigning the new changes in Business with the existing warehouse system and modifying ETL related changes, repository & Answers end.
• Good Hands on developing new ETL mapping using various transformations and loading data to new warehousing tables or with into existing tables new enhanced columns.
• Involved in Detailed Impact analysis on the existing reports & new changes into the reports and Repository.
• Experience in Offshore & Onsite model & coordinating with the end client with daily calls.
• Involved in providing technical solutions to the scenarios as part of the support enhancement and redeveloped the reports as per new requirement.
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates).
• Created saved filters using dynamic repository variables so business users can use these filters for ad-hoc reporting.

Environment: Microsoft Power BI, Oracle Business Intelligence Enterprise Edition 12c, BI Publisher.

Confidential

OBIEE Developer

Responsibilities:

• Worked on Conversion of Hyperion reports to OBIEE Dashboard and BI Publisher reports.
• Design, development, and deployment of new/ Enhancements on OBI Reports including RPD changes.
• Involved in Detailed Impact analysis on the existing reports & new changes into the reports and Repository.
• Involved in providing technical solutions to the scenarios as part of the support enhancement and redeveloped the reports as per new requirement.
• Develop reporting standards and best practices to ensure data standardization and consistency.
• Perform platform administration for Development, test, QA and Production environments.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.

Environment: Oracle Business Intelligence Enterprise Edition 12c, BI Publisher, Hyperion.

Confidential

OBIEE Developer

Responsibilities:

• Upgraded reports, dashboards, and BI Publisher reports from OBIEE 11.1.1.7 to 12.2.1.4.
• Retrofit reports in multiple phases to make reports available up to date.
• Involved in Detailed Impact analysis on the existing reports & new changes into the reports and Repository.
• Experienced in migrating security from 11g to 12c and created SQL DB authentication.
• Experienced in creating custom messages and custom skins as per requirement.
• Involved in providing technical solutions to the scenarios as part of the support enhancement and redeveloped the reports as per new requirement.
• Develop reporting standards and best practices to ensure data standardization and consistency.
• Perform platform administration for Development, test, QA and Production environments.
• Installed Interim and Bundle patches in OBIEE 12.2.1.4.
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates).
• Sharing access to multiple groups of users, to avoid traffic to application for same set of reports again.
• Created new reports in Usage tracking to monitor the usage of different reports and dashboards.
• Created saved filters using dynamic repository variables so business users can use these filters for ad-hoc reporting.

Environment: Oracle Business Intelligence Enterprise Edition 12c, BI Publisher.

Confidential

Obiee Developer

Responsibilities:

• Involved in Detailed Impact analysis on the existing reports & new changes into the reports.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• Created report templates using BI Publisher and scheduler report using Bursting concept to distribute reports to multiple sets of users in real-time.
• Publishing/Sharing OBIEE Reports to multiple groups of users, to avoid traffic to application for same set of reports again.
• Created new reports in Usage tracking to monitor the usage of different reports and dashboards.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Expertise in developing new reports, testing, and customizing existing reports using SQL procedures, Reports in XML/BI Publisher and OBIEE by interacting with the business analysts and end users.

Environment: Oracle Sales Cloud, Oracle Business Intelligence Enterprise Edition 11.1.1.9, BI Publisher.

Confidential

Consultant

Responsibilities:

• Expertise inOBIEE Metadata Repository. rpdusingOBIEEAdmin Tool by importing the required objects Dimensions, Facts Aggregates into Physical Layer usingConnection Pool, developing multiple dimensions drill-down HierarchiesLogical Facts Measure objects inBusiness Model Layer, and creating Presentation Catalog in the Presentation Layer.
• Hands-on Experience in configuringInteractive Dashboardswith drill-down capabilities usingFilters and Dashboard Prompts, OBIEE Security Setup groups, access privileges, Metadata objects and Web Catalog objects Dashboard, pages, folders, and reports.
• Experience in setting upSecurityand architecture with OBIEE 11g by usingweb logic admin console and enterprise manager
• Configured and scheduledIntelligence Agents iBotsto send real-time alerts to the end users using Delivers and created reports usingBI Publisher.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces, and packages inODI.
• Involved in Detailed Impact analysis on the existing reports & new changes into the reports and Repository.
• Hands on experience in data warehousing technologies including ETL, Oracle BI Server architecture, and metadata management.
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates).
• Created new reports in Usage tracking to monitor the usage of different reports and dashboards.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Created saved filters using dynamic repository variables so business users can use these filters for ad-hoc reporting.
• Worked on POC’s to migrate OBIEE to Oracle Analytics Cloud.

Environment: Oracle Business Intelligence Enterprise Edition 12.2.1.2, BI Publisher, Oracle Analytics Cloud

Confidential

BI Developer

Responsibilities:

• Troubleshooting production support issues, identify the root cause and migrate fixes.
• Working on Change requests to implement changes.
• Perform on-call duties for the production support issues and outages occurring across different environments.
• Extensive Development of the repository according to the BRD (Business Requirements Document) and building the metrics in accordance with the FSD (Functional Specification Document).

Environment: BI Publisher 11g.

Confidential

BI Developer

Responsibilities:

• Interacted with business users to gather business report requirements.
• Hands on experience inRPD and Web catalog Migrations.
• Created Application Roles using Oracle Enterprise Manager assigned different permissions on dashboards and reports.
• Created Shell scripts to start and stop the OBIEE instances in Linux environments.
• Designed and BuiltOracle BIEERepository at 3 layers i.e., Physical Layer connecting Data sources import schemas, Business Model / data mapping create Logical tables data source mapping and Presentation Layer level create presentation catalogs, create presentation folders, test and validate the model.
• Extensively used Presentation Hierarchy/Hierarchical Column to drill deeper into the data, to view more detailed information.
• Used/Suggested Views, Indexes, and Aggregated Tables to improve performance of reports/dashboards
• Modifying existing ETL jobs inOracle Data Integrator.
• Created Proactive Agents / iBots using Delivers delivered using Scheduler services.
• Create, maintain, and manage documentation for all data warehouse and reporting development efforts.
• Provide on-call support and worked with onsite and offshore teams.

Environment: Oracle Business Intelligence Enterprise Edition 11.1.1.9, BI Publisher, ODI

Confidential

BI Developer

Responsibilities:

• Attended defect review meetings and weekly status meetings.
• Implemented, Configured and TestedData securityandDashboard securityin OBIEE 11g.
• Configured theBI Deliversscheduler to schedule reports.
• Enhanced the performance ofReports/Dashboardsby implementing the Aggregate tables.
• Configured clusters on WebLogic using the WebLogic Console.
• Knowledge on creatingInformaticaworkflows.
• Experience in creating dimension tabletype1andtype 2mappings.
• CreatedAnalytical ViewsCompound Layout, chart, pivot etc. andGlobal/Local Promptsto design the Dashboards.
• CreatedAggregationsandLogical Based Measuresin Business Model and Mapping Layer.
• DevelopedPresentation Catalogsin the Presentation Layer.
• Developed and customized some of the existingDimensionsDrill down Hierarchies Logical Objects in Business Model and Mapping Layer.
• Organized testing schedules and test scripts. Managed execution and sign-off tests and also played an active role in product rollouts.

Environment: Oracle Business Intelligence Enterprise Edition 11.1.1.6, Informatica 8.6.