SUMMARY

• Over 15 plus years of progressive working experience with Analysis, Design, Development and Implementation of OBIEE 12c/11g /10g, OBIA 11.1.1.9.x/7.9.x, Oracle BI Publisher, Power BI, ThoughtSpot, Tableau and Hyperion Interactive Reporting (Hyperion System 9 BI)/Oracle EPM 11.1.1/ Hyperion Performance Suite (8.5/8.3)/Brio Enterprise Suite.
• Experience in leading and managing multiple Business Intelligence projects.
• Expert installing Oracle Fusion Middleware products on Linux, Windows, and UNIX platforms.
• Have good experience with Visualization tools Power BI, Tableau, Oracle Visual Analyzer and ThoughtSpot.
• Expertise in designing and developing Repository (RPD), BI Analysis, Dashboards, Alerts, Delivers, iBots and BI Publisher reports.
• Expertise in implementing and Configuring SSL and SSO.
• Worked extensively with Star and Snowflake data models in Data Warehousing
• Experience in implementing Security at object level and data level using Repository Variables, Initialization Blocks, and Session Variables.
• Experience in setting up Multiuser environment (MUDE), Merging and Importing Objects from different repositories.
• Worked on converting Hyperion Reports to OBIEE and BI Publisher.
• Experienced in Installation, configuration, upgrade, migration and administration of OBIEE 12c/11g/10g, Oracle BI Apps (OBIA) 11.1.1.9.x/7.9.x, Oracle EPM 11.1.1,Data Warehouse Administration Console (DAC), Oracle Data Integrator (ODI 11g) and Informatica Power Center.
• Functional knowledge of Oracle EBS R12/R11 in Finance, HCM, Supply Chain, Procurement & Spend, Project, and Manufacturing.
• Working Knowledge of Oracle Data Integrator and Informatica Power Center to perform the ETL/ELT
• Worked with business groups and stakeholders in gathering user requirements and designed Functional and Technical specification documents.
• Has exposure to complete life cycle of software development.
• Quick learner with strong communication and people skills who can work in a team or independently.

TECHNICAL SKILLS

Operating Systems: Windows Server, Oracle UNIX, Red Hat LINUX

Business Intelligence: OBIEE12c/11g/10g, Oracle BI Apps, Oracle BI Publisher, Oracle EPM 11.1, Exalytics, Microsoft Power BI, ThoughtSpot, Tableau, SQR Reports, Hyperion Essbase

Source Systems: Oracle EBS R12/R11, People soft

Languages: C, C++, Java 2.0, JSP, SQL, PL/SQL, T - SQL, Unix Scripting, Python, HTML, XML, Java Script, VB Script, ASP, Shell

Databases: Oracle R12, IBM DB-2, MS-Access, SQL Server 2012, Teradata, Snowflake for AWS, Azure Data Warehouse, Oracle Exadata, Golden Gate.

Database Clients: Navigator 5.x/Oracle SQL Developer/Toad, Teradata Sql Assistant

Data Modeling: Erwin, Visio, Toad Data Modeling

ETL-Tools: Informatica, Oracle Data Integrator (ODI), PL\SQL packages

Cloud: Azure Cloud, AWS Cloud

Testing Tools: HP Quality center, JIRA, Test rail

Monitoring Tools: Solar Winds and Datadog

PROFESSIONAL EXPERIENCE

Confidential

Senior BI Lead Consultant

Responsibilities:

• Installed, Configured and Upgraded from OBIEE 10g to OBIEE 11.1.1.7 and BI Publisher on Prem ExalyticsOBIEE 11.1.1.7 On Prem Exalytics to OBIEE 12.2.1.0 On Prem ExalyticsOBIEE 12.2.1.0 On Prem Exalytics to OBIEE 12.2.1.4 Oracle Cloud Infrastructure
• Installed and configured OBIA 11.1.1.10.2 , Oracle EPM and ODI 11.1.1.9.0 application.
• Implemented and Configured OBIEE for Snowflake Cloud Datawarehouse.
• Implemented SSL and Integrated SAML Web Single Sign On (SSO) for OBIEE 12c, Power BI, Tableau and ThoughtSpot using OKTA Identity Provider.
• Installed and Configured Power BI Gateways, Security and Enabled External Sharing for External Vendors.
• Applied security patches/fixes to All BI Applications.
• Provided Excel Analysis (ODC) solutions through Power BI Data Models.
• Migrated Hyperion Interactive Reporting to OBIEE 11g which includes BI Publisher reports.
• Have Done POC’s for Oracle Autonomous data warehouse and Azure data warehouse.
• Configured All BI Applications in Datadog and SolarWinds tool for monitoring.
• Developed/Configured repository file RPD used for creating content within OBIEE.
• Implemented OBIEE usage tracking to analyze and tune the query performance.
• Developed and integrated security design for OBIEE.
• Defined the Power BI workspaces by business process, categorized power bi dashboards/reports and shared with the targeted users.
• Implemented Multiuser Development (MUD) environment for different developers.
• Work in the business intelligence team focusing on Design, Development, Testing and Implementation of Reporting Solutions. Responsible for leading and coordinating solution delivery with internal customer base and source application leads. Ensure overall high data quality and efficiency associated with reporting and ETL solutions.
• Implemented RevStream (ASC 606) and Incremental Inventory Reserve projects to deliver BI solutions.
• Involved in CORE migration project, part of project implementation migrated over 500 Hyperion IR and other legacy systems Reports to OBIEE 11g in Exalytics/Exadata/Golden gate environment.
• Involved in Requirements gathering from business area Leads/SMEs and prepared the Functional (MD50) and Technical (MD70) document for Reports and Repository development.
• Developed EBS transactional reports in BI Publisher based on user needs.
• Worked closely with Users and Developers to resolve ongoing Production issues by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
• Responsible to train business users to access OBIEE Dashboard reports and provided ad hoc report training for power users.
• Trained end users on the use of OBIEE/BI Publisher (XML Publisher) in a classroom environment, as well as one-on-one settings.
• Performed unit and integration testing. Created various test scenarios to test the application.
• Conducted code reviews and planned the knowledge transfer to client.
• Extensively worked on Merging and Migration of RPD and Catalog to higher environments like Dev to Test, Test to Production on a weekly basis.
• Worked closely with ETL Developers during data load/mappings to Data warehouse from various relational databases.
• Implemented the Data-level (row-level) and Object-level security as per the business user requirements.
• Performed Unit testing to validate report and fixed the issues opened by QA and BA team.
• Created RTF, PDF Reports using BI Publisher.
• Created Multiuser Development (MUD) environment for different developers.
• Implemented usage tracking
• Point of contact for all team related issues.

Environment: OBIEE 12c /11g /10g, BI Publisher, Power BI, Thought Spot, JIRA, Oracle Cloud Infrastructure, OBIA 11.1.1.10.2 , ODI 11.1.1.9.0 , Oracle EBS R12/R11, Informatica 9.6, PL/SQL, Exa-Data, Exalytics, Oracle 11g/12c, Jira, Oracle Linux, Toad, Service Now, Windows Server 2008R2, Snowflake Cloud Datawarehouse, Datadog and SolarWinds.

Confidential

Business Intelligence Architect

Responsibilities:

• Involved in multiple projects like HRS (Human Resource System), CSW (Campus Solution Warehouse), INFOACCESS, WISDM (Budget & Financial Warehouse) and SFS (Shared Financial Services).
• Implemented the OBIA 7.9.6.4 HR and Financial Analytics out-of-the box reports with extended customizations across the organizational environment and the configuration of out-of-the-box reports (Prebuilt Dashboards), development of Custom Dashboards & Organization Specific Operational reporting.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications in the development.
• Analyzing Functional documents, identifying the GAP's, designed Reporting Technical Specification documents.
• Implemented a Multi-User Development Environment (MUDE) utilizing projects.
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Development and maintenance of HR dashboards Absence management, Employee Job Probation, Salary Equity Study, Jobs on leave, Payroll Approver, OT Report, Classified carryover vacation and comp time, Headcount, Hires, Terminations, Off cycles, Merits, Global Compensation & Turnover reports.
• Development and maintenance of Financials Dashboards GL (Overview, Balance Sheet, Cash Flow, Budget vs. Actual, Asset Usage, Liquidity, Financial Structure, GL Balance, Trial Balance.), AP (Overview, AP Balance, Payments Due, Effectiveness, Payment Performance, Supplier Report Invoice Details, All AP Transactions) and AR (Overview, AR Balance, Payments Due, Effectiveness, Payment Performance, Customer Report Invoice Details, All AR Transactions).
• Created new logical columns, dimensional hierarchy, level based measures, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Developed Time Series Objects using Ago, Period Rolling and ToDate functions for time series comparisons.
• Designed Security at object level and data level using Repository Variables, Initialization Blocks, and Session Variables.
• Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
• Designed and developed various Interactive dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector, gauge, Master detail Linking etc. and various report prompts, Dash board prompts. Filters, Graphs, charts etc.
• Utilized Delivers for sending real-time, personalized alerts via intelligence agents to intelligence dashboards for subscribed users.
• 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.
• Coordinated the RPD and Web Catalog objects migration from DEV, QA to Production environment.
• Created various templates, reports, and prompts in BI Publisher.
• Worked towards the Performance Tuning of Dashboards and Reports with Database Administrators.
• Implemented caching and aggregate table techniques to improve the performance.
• Analyze and fix the production problems reported by the users.
• Involved in migration of all existing dashboard and reports developed in Hyperion System 9.3 to OBIEE 11.1.1.7.1 .
• Trained End Users to Build Ad Hoc Reports using OBIEE
• Provided guidance and support to end users during the implementation and in production.

Environment: OBIEE 11.1.1.7.1 , BI Publisher, OBIA 7.9.6.4, Oracle PeopleSoft 9.0, Hyperion System 9(Interactive Reporting), PASS (Pioneer Administrative Software System), DAC 10.1.3.4.1 , Weblogic10.3.5, Informatica 9.1.0, Oracle11g, ODI11g., SQL Developer 4.0, Share Point, SQL Server 2005, Windows 7, Unix, Putty, EIS JavaScript, Foot Print