Resume

Sign in

Senior BI Consultant

Location:
Dallas, Texas, United States
Posted:
December 26, 2018

Contact this candidate

Resume:

Professional Summary:

Over **+ years of experience in IT industry with Oracle BI Applications, OBIEE and Informatica. Extensive experience with ODI, Tableau, Microsoft Power BI and Hyperion Interactive Reporting Studio.

Experience in Business Intelligence and Transactional applications, Design and implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling

Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization, Data Modelling and Business Intelligence solutions

Expertise in implementing like implementing Out of Box prebuilt mappings, Designing ETL INFORMATICA & DAC, Creating Oracle provided Data Warehouse, OBIEE RPD development, OBIEE reports and Dashboards, Upgrading the versions and implementing security.

Implemented modules for BIAPPS are Financials, PROC, SCOM, Projects, Marketing HR Analytics and Manufacturing

Strong experience in Installation, Configuration and Administration of OBIEE.

Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow Flake Schemas

Very strong experience in developing OBIEE Repository (.rpd)

3 layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters,

Expertise in implementing Security Models for Dashboards, Row level, objects Level, Role Level, and Dashboard Level; Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling I-Bots

Hands on experience in Authentication and Authorization of OBIEE by using External Authentication, LDAP Authentication

Experience in creating Aggregate tables

Implemented MUD Environment and worked on three and two-way merging

Having good knowledge on Parent-Child, Ragged and Time dimension hierarchies in OBIEE 11g

Strong experience in developing and customizing Reports using OBIEE 10.X, 11.x and 12c versions

Expert in converting Functional specs to Technical Specs and implementing OBIEE with Best practices

Expertise in implementing Hyperion ESSBASE with OBIEE.

Extensive experience in extraction, transformation and loading of data directly from various data sources like flat files, Excel, SQL Server, Oracle.

Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.

Experienced with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations

Expertise in creating mappings, mapplets, task and workflows in INFORMATICA with proper standards of BIAPPS

Configuring BIApps, Informatica/DAC to integration of OBIEE with EBS

Extensively worked with BIAPPS OOB mappings in INFORMATICA and also worked on Customizations

Good experience in performance tuning of Reports generated using OBIEE as well as ETL

Expertise in designing data model and developing reports in Oracle Hyperion Interactive Reporting.

Extensive expertise in designing and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization

Experience in ODI Repository, designer, Topology, Operator, packages, scenarios and ODI Tools

Worked with knowledge modules like LKM, IKM and CKM.

Involved in monitoring the loads/replication lags and coordinating with system’s team for any performance issues with environment.

Involved in end-end testing (Unit testing, System testing and Business Users Acceptance testing); have customer face time to hand over reports to enable the users with the know-how on the reports

Conducted Trainings to Train the Trainer (to train business users on UI) on Architecture, Answers and Reports

Can handle team with proper spec understand and delivering it professionally with all standards

TECHNICAL SKILLSET

Business Intelligence Tools

Oracle Business Intelligence (OBIEE) 10g/11g/12c, BI Publisher, OBIA 7.9.6.x, Informatica 9.x, Tableau, Hyperion Interactive Reporting Studio, Microsoft Power BI, Taleo

Operating Systems

Windows Family, Linux

Languages

SQL, PL/SQL, C, Scala

RDBMS

Oracle 9i/10g/11g/12c, MS SQL Server 2000/2005

Migration Tools

Winscp, Putty

CERTIFICATIONS:

Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist.

EDUCATION:

Master’s Degree from Vinayaka Missions University, India in 2005.

Bachelor’s Degree from Kakatiya University, India in 2003.

PROFESSIONAL EXPERIENCE:

CBRE, Dallas, TX Jun 2018- Till Date

Senior BI Consultant

Participated in gathering and analyzing the Business Requirements in collaboration with the Sales, Marketing and Service Business Analysts and Users.

Worked under Agile Methodology, delivering reports in each sprint.

Integrating Taleo OBIEE reports into existing BI environment.

Working with Taleo Connect Client to extract data from Taleo.

Loading data from Success Factor’s LMS and developing reports in BI environment

Developed and customized the Oracle BIEE Metadata repository (.rpd ) model by creating connection pools, physical / Alias Tables, defined joins and implemented authorizations in the physical layer, aggregates, dimensions, hierarchies & time series functions in the BMM Layer, catalogs & folders in Presentation Layer using Oracle BI Administration tool.

Developed and customized executive level dashboards and reports in various views such as Pivot Table, Charts, View Selectors, Column Selectors, catering to provide insight into the Sales / Marketing / Financial data.

Created BI publisher reports and templates with output as (Excel, HTML, PDF format)

Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements. Generated various Analytics Reports like Formulary Report, Union Report and Direct Sales Report using global and local filters.

Generated Ad hoc Statements as per the business user requirements into Production.

Debug the OBIEE issues by checking logs

Implemented security by creating users & web groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associating catalog objects and Web modules with the created groups.

Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, Oracle materialized views and making changes to reports.

Code migration in different OBIEE environments like Dev, UAT and PROD.

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, Tuning Reports.

Experienced in configuring ETL metadata, including Informatica Source Analyzer, Designer, Mapplets, mappings, and workflows

Developed standard and reusable Informatica mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.

Environment: OBIEE 12c, Informatica9.x, Oracle 11g/12c, Linux

Lumentum, Milpitas, CA Apr 2015 - May 2017

BI Lead

Worked with Business Groups to identify, analyze, and document Business Requirements.

Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.

Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.

Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.

Migrated Analytics RPD and Webcat from one environment to another.

Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.

Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.

Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.

Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.

Customized Dashboard pages like Overview, AP Balance, Payments Due, Effectiveness, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.

Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.

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, Tuning Reports.

Created BI publisher reports and templates with output as (Excel, HTML, PDF format)

Customized prebuilt Informatica SDE Mapping and SIL Mappings based on Client Requirements.

Developed new mappings in Informatica for custom modules CAPEX, OPEX and BBB.

Extended source columns are populated to OBIEE by using Informatica customized mappings

Environment: BIApps 7964, OBIEE 11G, EBSR12.1.3, Informatica9.x, Oracle 11g/12c, Linux

Baptist Health South Florida, India Aug 2014 - Mar 2015

Senior BI Consultant

Implementing HR Analytics OOTB reports and customization.

Worked with Business Groups to identify, analyze, and document Business Requirements.

Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.

Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.

Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.

Migrated Analytics RPD and Webcat from one environment to another.

Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.

Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.

Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.

Customized prebuilt Informatica SDE Mapping and SIL Mappings based on Client Requirements.

Environment: BIApps 7964, OBIEE 11G, Peoplesoft 9.x, Informatica9.x, Oracle 11g, Linux

TiVo, Bangalore, India Aug 2013 -Jul 2014

Senior BI Consultant

Worked with IT Business Analyst teams to gather and analyze business reporting requirements from end users and translate them into reporting designs

Worked on OBI Answers, OBI Dashboards, OBI Delivers and configuring Interactive Dashboards with drill-down capabilities and using Dashboard and Page Level Prompts and Filters

Worked on hierarchies, level based measures and time series calculations in the repository (RPD)

Worked on Configuring repository on all the three layers (Physical Layer, Business Model and Mapping Layer and Presentation Layer)

Troubleshoot OBIEE and Data Warehouse application and system issues

Design and develop Data Warehouse schemas using ETL tools including Informatica

Assist in managing the OBIEE Admin Tool, Catalog Manager

Prepare detailed design documentation and program specifications from which systems are developed and coded

Support project personnel, management and end users in resolving complex program and business issues

Coordinated with multiple teams during implementation and transition phases

Develop and execute plans for deploying the applications into production environment

Facilitated knowledge transfer sessions for new team members

Environment: OBIEE 11g, Informatica 9.x, Windows server 2008, SQL Server 2008.

Electronic Arts, Hyderabad, India Apr 2013 - Jul 2013

Senior BI Developer

Extract the data from source system oracle EBS and load data by using Informatica, DAC and finally develop the reports by OBIEE.

Installation of OBI-APPS (OBIEE, Informatica, DAC)

Configuration of OBI-APPS in Informatica and DAC

Worked in Full and Incremental data loads and fixed the issues during data load

Developing Source Dependent Extract (SDE) and Source Independent Loading (SIL) mappings as per Technical Design. By customizing the Siebel vanilla mappings.

Involved in monitoring the Dailey & weekly incremental loads through DAC (Data Warehousing Application Console).

Installed OBIEE 11.1.1.5 and OBI Apps 7.9.6.3 in POC Server.

Configured and Deployed BI Apps RPD and Web catalog.

Worked on Security Implementation using LDAP Authentication and External Table Authorization.

Imported Apps pre-defined users and Application Roles through Admin console.

Involved in modelling RPD.

Preparing Low Level Design document for RPD, Reports and Dashboards

Worked on Interactive Dashboards and Pages.

Environment: OBIEE 11g, Informatica 9.x, BI Apps 7.9.6.3, DAC, Linux, Oracle 10g/11g.

SIDBI, Bangalore, India Feb 2012 - Mar 2013

Senior BI Developer

Installed OBIEE 11.1.1.5 tool in DEV, SIT and UAT servers.

Deploying RPD through Enterprise Manager and Managing Web Catalog Migration across DEV, SIT and UAT Environments through Catalog Manager.

Worked on Security using LDAP and External Table Authentication.

Preparing Low Level Design document for RPD, Reports and Dashboards

Worked on Interactive Dashboards and Pages.

Developing Reports and Dashboards for different SIDBI Departments.

Created Dynamic Session variables to handle Data filters.

Created session initialization blocks to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.

Developed SQL queries for data level validation of reports.

Creating and Executing Functional Test Cases for verifying the functionalities of the reports.

Creating and Scheduling Agents.

Environment: OBIEE 11g, Informatica 9.x, Windows 2008, Oracle 10g/11g.

Merck, Bangalore, India Aug 2010 - Jan 2012

BI Developer

Interacting with Client for requirement gathering, status and update meetings.

Daily monitoring all the Reports published in the Dashboards.

Understanding High Level Design (HLD) and Detail Level Design (Low Level Design)

Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns. Setup the visibility of dashboards to employees with respect to their responsibilities.

Implemented Prompts to provide dynamic filter condition to End users.

Providing object level security for different web groups based on responsibilities.

Environment: OBIEE 10.1.3.3 Oracle 10g

Inchcape, Djibouti Oct 2006 - Mar 2010

Software Developer

Worked with DDL, DML Commands.

Created Stored Procedures to perform insert, delete and update operations.

Worked with views, indexes and User Defined Functions.

Understanding the FRD, Source Data, Identifying Entities, Attributes and Measures.

Imported Dimensions and Facts into Physical Layer, Created the Logical Model in the BMM (Business Model and Mapping) Layer.

Created multiple drill down to support various business requirements and User Friendly Subject Areas in Presentation Layer.

Developed OBIEE Dashboards with Dashboard Prompts, Answers.

Set up Users, Groups, access privileges and query privileges. Designed role-base Dashboards for managers and Business heads to review figures across regions, products with the family to drill down to individual customer relationship manager or customer support agents.

Environment: OBIEE 10.1.3.3 Oracle 10g, Windows 2000 Server



Contact this candidate