SUMMARY

• 12 years of IT experience with extensive Data Warehousing implementations across Gaming, Banking, Retail, Education, Hospitality, Media and Pharma Industries.
• Extensive Business Intelligence experience using OBIEE 12C/11.1.1.x, 10.1.3.x, OBIA 7.9.6.x/OBIA 11.1.1.7.x, and Siebel Analytics 7.8, Tableau 10.x,9.x/8.x.
• Experienced in full life cycle implementations of BI projects from requirement gathering, Fit Gap Analysis, Configuration, Mapping, Development and testing.
• Core Experience in End to End Implementation of BI Projects including Installation and Configuration of OBIA/OBIEE 11G/10G, Design and Development of OBIEE Repository, Analysis, Dashboards. Setting up Security, Agents/ibots.
• Extensively worked on end to end implementation of BI APPS in various domains such as Finance, Projects, HR and SCM applications.
• Expertise in developing all 3 layers of the Analytics Repository (Physical Layer, Business Model & Presentation Layer).
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Experience in developing Complex reports in Table, Pivot views, using Column Selector, View selector, narrative views and others. Created visually appealing reports using Bubble, Scatter, Waterfall Graphs.
• Extensive experience on BI publisher which includes installing, configuring and integrating with OBIEE server Experience in creating Analysis, Data Model, RTF template, Excel Templates, Smart View Report Templates for BI Publisher reports
• Experience in configuration of Multiuser Development Environment (MUDE) and Working in MUD environment.
• Experience Configuring and setting up of Map View in OBIEE 11G.
• Extensive experience in Performance tuning using Aggregate navigation, mini Dimensions, using required Hints, and tuning the SQL.
• Worked in integration of Essbase with OBIEE 11g to enable reporting on top of OLAP cubes and accomplish slicing and dicing of data.
• Experience with Design and Development of Tableau Visualizations using Tableau Desktop features like Measures, Dimensions, Folders, Hierarchies, Filters, Parameters, Sets, Groups, Calculated fields, Data Blending.
• Worked with Synchronous and Asynchronous Cubes in Hyperion.
• Extensive experience in Unit Testing, Performance Testing, Integration and User Acceptance testing.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
• Experience using Erwin for Data Modelling.
• Hands on experience and familiar knowledge on Configuration of BIACM for OBIA 11G.
• Over 4 years of ETL experience using Oracle Data Integrator (ODI), Informatica Power Center / Power Mart tool and Alteryx
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience leading offshore and onsite team for multiple projects.
• Excellent Documentation Skills Analyzing MD 50’s and Preparing MD 70’s

TECHNICAL SKILLS

BI Tools: OBIEE 12.2.1.x, 11.1.1.x, 10.1.3.x, OBIA 7.9.6.3, 11.1.1.x, Oracle BI Publisher 11g/ 10.1.3.4.1/10.1.3.4 ,Siebel Analytics 7.5/7.7/7.8,OAC Tableau 10.X,9.X/8.X Endeca 3.1, SSRS, SSAS Smart View, Hyperion.

ETL: ODI 11.1.1.7,Informatica Power Center 8.1.1/8.0/7.1. x,SSIS,Data Stage, Alteryx

Dimensional Data Modeling: Star Schema Modeling, Snow flake Modeling, Physical and Logical Data Modeling, Erwin 7.1, Microsoft Visio

Oracle EBS (R12/11i) /PeopleSoft (9.1/8.9/8.0: General Ledger; Accounts Payables; Profitability (P&L, BS); Accounts Receivables; Purchasing; Order Management; Inventory; Fixed Assets,HR; Projects; Procurement.

Languages: C, C++, SQL,PL/SQL,HTML

Databases: Oracle 12c,11g,10g/9i/8i/8.0/7.x, Oracle Exadata X4-2, MS SQL Server 2005/ 2000, Teradata,MS Access, Netezza 7.0.

Operating System: Win /95/98, Win 2000,Win NT, Win XP, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr OBIEE/Tableau Consultant

Responsibilities:

• Working on current PPMT BI Infrastructure and design needed to develop complex reports.
• Review Business requirements with users and do Fit Gap analysis.
• Responsible for Dimensional Modelling creating Star and Snowflake Schemas.
• Review and work on Extract, Transform and Loading (ETL) using SSIS and Stored Procedures.
• Design and Develop Repository Metadata using RPD (Physical, BMM and presentation layer).
• Build Analysis, Reports and Dashboards as per industry standards.
• Migrated on premise OBIEE 12C to Oracle Analytics Cloud using lift and shift methodology.
• Created dataflows in OAC for data cleansing using filter, join operations.
• Created visualizations in Data Visualizer.
• Worked extensively on RTF Templates for BI Publisher Reports.
• Created Data Models and XML Output for BI Publisher Reports.
• Working on Data Level Security and Object Level Security using Oracle Enterprise Manager and Weblogic Console
• Design and Build visualizations using Tableau, Oracle Data Visualizer (DV) by creating Data sets.
• Configuring Tableau Server using Tableau Service Manager (TSM)
• Setting up users in Tableau environment and assigning privileges to users.
• Creating complex visualizations in Tableau Desktop.
• Developed Tableau Workbooks from Multiple data sources using Data Blending.
• Built workbooks using calculated fields, parameters, Trend Lines, Reference Lines, Quick Filters.
• Refreshing Tableau Extracts.
• Responsible for migrating RPD, WebCatalog across multiple environments.
• Performance tuning of complex SQL queries, Metadata to improve overall BI Performance.
• Working on Production Tickets assigned in TFS

Environment: OBIEE 12.2.1.4, OAC, BI Publisher, Tableau 2019.2, SQL Server 2016, Alteryx 2019.4, WinSCP, PuTTY

Confidential

Sr OBIEE/Tableau Consultant

Responsibilities:

• Working on Integration Project of Hyperion Essbase and OBIEE.
• Directly worked with End users for Requirement Gathering and Analyzed the BRD documents.
• As OBIEE Consultant, I worked on building the RPD and related Reports for Finance Team.
• Imported the Essbase Cubes to build the RPD for measures and different Dimensional Hierarchies.
• Troubleshooting and fixed issues relating to Hierarchies
• Custom built the Complex Reports for Financial Operations involving Drill Down and Drill through Reports.
• Built Navigation links to Drill Through from Essbase Reports to Operation Reports (Oracle) in OBIEE.
• Created reports in Smart View and did the Data Validations
• Also built the Gourl to navigate from OBIEE Essbase reports to Finance Data Mart
• Built Complex reports involving Action Links through different presentation Hierarchies .
• Created Various Session and Presentation Variables based on the requirements.
• Involved in migration of reports, RPD between Dev, QA and Prod environments
• Provided Training to New Users
• Led an offshore team of 4 by having daily Scrum meetings to track the progress.

Environment: OBIEE 12.2.1.0, OAC, Tableau, Essbase 11.1.2.4, SmartView, Netezza, Aginity Workbench, Peoplesoft Financials, WinSCP, PuTTY

Confidential

Sr. OBIEE/Tableau Consultant

Responsibilities:

• Working on Integration Project of Hyperion Essbase and OBIEE.
• Directly worked with End users for Requirement Gathering and Analyzed the BRD documents.
• As OBIEE Consultant, I worked on building the RPD and related Reports for Finance Operations Team.
• Imported the Essbase Cubes to build the RPD for measures and different Dimensional Hierarchies.
• Troubleshooting and fixed issues relating to Hierarchies
• Custom built the Complex Reports for Financial Operations involving Drill Down and Drill through Reports.
• Built Navigation links to Drill Through from Essbase Reports to Operation Reports (Oracle) in OBIEE.
• Created Various Session and Presentation Variables based on the requirements.
• Involved in migration of reports, RPD between Dev, QA and Prod environments
• Provided Training to New Users
• Led an offshore team of 4 by having daily Scrum meetings to track the progress.

Environment: OBIEE 12.2.1.0, Essbase 11.1.2.4, SmartView, Tableau 9.2, Netezza, Aginity Workbench, Peoplesoft Financials, WinSCP, PuTTY

Confidential, Chicago, IL

Sr. OBIA/OBIEE Consultant

Responsibilities:

• Confidential serves customers from advanced-technology manufacturing and operational facilities in North America, South America, Europe and Asia, with additional facilities located throughout the U.S. and around the world.
• As OBIEE Consultant, I worked on configuring BI Apps, out of the box reports and developing RPD and built custom reports for Financials (AP, AR, Fixed Assets, GL, Profitability, Budget), HR, Project Analytics, Procurement and Spend and SCM modules. Worked on day to day migrations of RPD and web catalog.
• Involved in Requirement gathering with users. Done detail Analysis and verified the compatibility and technical feasibility with OBIEE.
• Performed FIT/GAP analysis on the out of the box reports.
• Custom built the Financial Reports (Balance Sheet Trend, P&L Reports, Revenue and Gross Margin) Reports.
• Modelled and Developed OBIEE Real Time reports by connecting to Oracle EBS source Data.
• Involved in Data Modelling Sessions with ODI team to identify Dimensional Attributes, Fact Groups. Worked extensively on RPD to build new subject areas involving Procurement Requirements.
• Created Star Schemas, Dimensional Hierarchies, Aggregations, Variables, and Initialization Blocks in RPD.
• Created projects for setting up MUD Environment. Worked in MUD environment by checking out and Checking in required Projects.
• Created Aggregate tables and implemented Aggregate navigation to increase the performance of Summary Reports.
• Configured the Usage Tracking and built the Reports to analyze the performance of reports and track the reports being used by different users
• Designed and Developed Object Level and Data Level Security for Business Users to define users, groups, set roles and responsibilities by integrating OBIEE users with Organization’s OID.
• Involved in functional configuration of BI Apps to load data into Data Warehouse tables.
• Involved in managing data load parameters and reporting parameters in BIACM for Financials, Supply Chain management, Project Analytics and HR Analytics.
• Managed Domain load plans in BIACM to load EBS data into Data warehouse tables.
• Migrated Objects (Analysis, Prompts, Dashboards through Catalog Manager) and RPD (by creating XML Patches) from DEV to QA to PROD.

Environment: OBIA 11.1.1.8.1 , OBIEE 11.1.1.7.1 ,OBIEE 12c BI Publisher, BIACM,FSM Tableau 9.2,Oracle 11g, Oracle EBS 12i, ODI 11G, TOAD,SQL Developer, WinSCP, PuTTY, ServiceNow

Confidential

Sr. OBIEE Consultant

Responsibilities:

• The Shared data Repository (SDR) initiative is a DATG-wide data warehouse/BI program. The objective of this program is to consolidate data from all of the DATG businesses (Cable, Broadcast, Distribution, Sales) and subject areas in order to gain efficiencies from faster, more accurate access to BU-wide information.
• Gathered Business Requirements from Sales Advertiser team.
• Configured the DEV System for OBIEE and BI Publisher set up.
• Analyzed the Business Requirement Documents (BRD’s) and created the technical Specifications for the required Subject areas and corresponding Dashboards.
• Worked with multiple data sources like HULU, Adsales, Freewheel, Neilson and others
• Created the SDR Model in RPD with multiple Subject Areas like AD Sales Digital Revenue, Digital and Linear Program Viewing, Digital Billing, ABC Advertise revenue Analysis and more.
• Created the star schemas, dimensional hierarchies, Aggregations, Fragmentation in Business Model layer in OBIEE Admin tool based on the requirements for these Subject Areas.
• Created the initialization blocks for repository and session variables to be used in the report calculations
• Developed various Analysis, Reports using Table views, Pivot Views, Pie Charts, View Selectors, Column Selectors, Narrative views and some latest graphs like Waterfall, and Bubble Charts to display data effectively.
• Created complex calculations to get the TOPN reports.
• Imported Essbase Cubes to OBIEE and worked on hierarchies and to flat out measures.
• Developed Financial Reports and Dashboards based on these cubes.
• Configured the BI Publisher and Smart View to do some of the Reports which required cell level calculations.
• Used Different BI Publisher Templates like RTF, Excel to replicate the layouts based on sample reports provided by the users.
• Created the reports with both data level security and Object level Security depending on the different user requests.
• Administered security groups using WebLogic Administration Console
• Involved in migration of reports, RPD between Dev, QA and Prod environments.
• Provided Support for any issues in production for OBIEE reports
• Involved in preparing the step by step instructing documents for the user training on the AD HOC analysis and creating some basic RTF and Excel templates for BI Publisher.
• Involved in creating the step by step documentation on installation the OBIEE and BI Publisher for the Admin team to replicate the set up in PROD Environment.

Environment: OBIEE 11.1.1.7,BIP 11.1.1.7, Smart View, Oracle 11g, Teradata v13, Aginity SSIS, Workbench, Peoplesoft 9, Tableau 8.1,Hyperion Essbase 11.1.2.1,Visual Source Safe 10, Windows 7, Endeca 3.1