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