OBIEE Informatica OBIA DAC PL/SQL

SHRAVAN MANSANI

Email: ***********@*****.*** Phone: 484-***-****

Professional Summary

• 9 Years of experience in IT with full life cycle implementation of Oracle Business Intelligence

Product suites (OBIEE) and Oracle Business Intelligence Applications( OBIA)

• Involved in all the phases of gathering requirement, Proof of concept, gap analysis, design,

development and implementation of software applications

• Extensive expertise in providing end-to-end business intelligence solution by configuring

metadata& building analytics metadata repository, star schemas, snow flake schemas, dimensional

modeling design, building business models, generating reports, and creating interactive BI

dashboards

• Extensive experience in building and customization of interactive dashboards with drill down

capabilities using global & local filters, contextual navigation, guided analytics, Business Rules

with User Identity & roles, profiles & personalization and creating and scheduling I-Bots

• Experience in up gradation from OBIEE 10g to 11g migrating RPD, Catalogs and applying

patches

• Proficient in development and production support and OBIEE application design, build, test,

experience, including requirements gathering, ownership of metadata and dashboards and reports

• Extensive experience in migration of OBIEE Presentation Services objects using OBIEE

Catalog Manager and repository files between different environments

• Experience in development of BI Publisher Reports using various templates using BI

Publisher Desktop Tool

• Experience in performance tuning, security, cache management, aggregation and usage

tracking

• Experience of working in MUDE, resolve conflicts and maintain consistency

• Exposure to OBIEE Administration activities as OBIEE Installation, LDAP Configuration,

Map Viewer Configuration, Essbase Connectivity and Cluster Configuration

• Experience in development of mappings using InformaticaMapping Designer using various

transformations like Expression, Router, Lookup, SQ, Update Strategy,etc.

• Experience in development of sessions and workflows and using Informatica Workflow

Manger

• Experience on execution, monitoring and troubleshooting of the ETL executions using

Informatica Workflow Monitor

• Experience in migration of informatica repository using Informatica admin console and also

individual folders, mappings, sessions, workflows using Informatica Repository Manager

• Experience on development, configuration and scheduling of tasks and execution plans using

DAC

• Expertise in debugging, optimizing the performance tuning of Oracle BIEE 10g/ 11g Repository

& Dashboards / Reports by implementing Aggregate tables, Fragmentation of data sources, Indexes

and Cache management.

• Experience in performing end to end testing including Data Validation, Unit Testing and UAT

• Implemented a PoC on GoldenGate for data replication for ODS

• Proven experience and ability to adapt quickly and work in teams, a can-do ability to take charge

when necessary and drive the work to completion

• Excellent interpersonal skills, outstanding problem solving and decision making skills

Certifications

• “Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist ”

Certification

Education

• Bachelor of Science: Computer Science

• Masters of Computer Application (MCA)

Technical Skills

Reporting Tools : OBIEE 10G/11G, OBIA 7.9.6.3, BI Publisher, BI Publisher

Desktop

RDBMS : Oracle 8i/9i/10g/11g, MS SQL server, MS Access

ETL Tools : Informatica 9.0.1,7.x, Oracle Data Integrator(ODI),GoldenGate

Operating Systems : Unix,Windows Server 2003 Enterprise Edition

Scheduling Tools : DAC, Cron Jobs

Applications : MS Office Suites (Excel, Word, PowerPoint, Access)

Querying : T-SQL,PL/SQL

Database : Oracle 11g/10/9.x, Teradata, MS SQL Server

Database Clients : TOAD, SQL Developer

Professional Experience

Project #1:

Client: PNC Bank, Pittsburgh, PA

Duration: Jul 2014 –till date

Role: OBIEE Developer

Environment: OBIEE 11.1.1.6.x

Responsibilities:

• Working closely with financial analysts to understand the report details to the end user community

• Requirement gathering and perform gap analysis and build the solution

• Customized and developed the OBI repository

• Implemented changes to the Star Schemas and in all the 3 layers of the RPD(Physical, Business

Model and Mapping Layer and Presentation Layer)

• Involved in the design activities for providing reporting solution

• Created the sample BIP reports for the end user look and feel experience

• Development of the reports using BI Publisher for LCR module

• Created custom reports to produce pixel perfect reports using BI Publisher desktop to generate RTF

templates for generating BIP reports.

• Analysis and implementation of the reporting requirements of the LCR project

• Functional Analysis of the data to be shown on the LCR reports

• Implemented R&D on the reports User Interface requirements

• Implemented complex sql queries to implement the BI Publisher reporting requirements

Project #2:

Client: General Electric, Albany, NY

Duration: Nov 2013 –Jun 2014

Role: OBIEE Developer

Environment: OBIEE 11.1.1.5.4, 11.1.1.7

Responsibilities:

• Conducted design sessions with data owners toward capturing business requirement for an analytics

environment.

• Working closely with end user community to enhance and improve the user experience architecture

look and feel

• Requirement gathering from the client and perform gap analysis and build the solution

• Proposed the enhancements required and effort estimates on the reporting requirements

• Proposed the required changes that are required in the data ware house for generating the required

reports

• Customized and developed the OBI dashboards and reports

• Implemented changes to the Star Schemas and in all the 3 layers of the RPD(Physical, Business

Model and Mapping Layer and Presentation Layer)

• Created and modified hierarchies in the Business Model and Mapping Layer

• Involved in the design activities and created the design specifications documents.

• Provided the knowledge transition to the project support team.

• Developed the reports using BI Publisher for the accounts reconciliation management (ARM) for GE

Finance.

• Developed OBIEE reports for risk mitigation for GE Capital.

• Fixed performance issues for improving report performance.

Project #2:

Client: Essilor, Nashville, TN

Duration: Jul 2012 – Oct 2013

Role: OBIADeveloper &OBIEE Administrator

Environment: OBIA 7.9.6.x, OBIEE11.1.1.6.4, OBIEE 11.1.1.6.2, 11.1.1.5

Responsibilities:

• Worked closely with Business Users, involved in discussing and gathering the analytic

requirements from different user groups.

• Worked on repository Physical Data Layer, Business Model and Mapping Layer and

Presentation Layer using OBI Administration Tool.

• Created complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over

columns.

• Created connection pools, physical tables, defined joins and implemented authorizations

in the physical layer of the repository.

• Implemented Human Resources (HR) Analytics and Financial Analytics.

• Designed and implemented custom business intelligence solutions(Dashboards/Reports)

and dashboard prompts using the BI Applications Analytics platform.

• Configured global filters, dashboards and page prompts in OBI Web.

• Modified presentation layer filters and attributes to match user requirements.

• Used the Security settings in Oracle BI Admin Tool to set up users, groups, access

privileges and query privileges.

• Created Dimension hierarchies to achieve the drill down functionality.

• Configured interactive dashboards by adding embedded content such as links/images,

HTML objects and folders.

• Managed security privileges for each subject area and dashboards.

• Created groups in the repository and added users to the groups and granted privileges

explicitly and through group inheritance.

• Worked on DAC for creation of Tasks, Task Groups, Subject Areas, Execution Plan, and

to configure, monitor and schedule ETL routines.

• Used Informatica for data extraction, mapping and conversion using Informatica Power

Center.

• Extensively worked in fine-tuning of Informatica mappings.

• Created mappings using different Transformations like Source Qualifier, Filter, Router,

Aggregator, Lookup, Expression, Sequence Generator and Update Strategy to store the data

in target table.

• Created sessions, tasks and workflows etc. in Workflow Manager.

• Worked with the Testing team to resolve, fixing and testing problems found during the

systems integration test, UAT phases.

• Handled full load and refresh load via staging tables in the ETL Layer.

• Optimal utilization of object-reusability features like reusable transformations, mapplets,

copying objects from other repositories, using variable/parameters for simplifying

mappings.

• Performed installation and configuration of 11.1.1.5, Informatica 8.6.1 and DAC

10.1.3.4.1.

• Responsible for Query Tuning to enhance the performance of reports and Dashboards.

• Managed upgrade and maintained the environments with latest patches

• Integration of OBIEE with EBS Source Systems

Project #3:

Client: Kellogg, Brown and Root, Houston, TX

Duration: Nov 2011– Jun 2012

Role: OBIA Developer & OBIEE Administrator

Environment: OBIA 7.9.6.x Procurement and Spend Analytics, OBIEE 11.1.1.6.x, OBIEE 11.1.1.5.4

Responsibilities:

• Worked in analysis of reporting requirements and coming up the custom data model and creation

of custom repository for meeting the reporting requirements.

• Worked on the Configuration files for configuring the modules and prepared the Data Lineage for

HR Projects and Supply Chain Management Analytics for meeting the requirements.

• Customized the data model and development and enhancement of ETL and DAC objects.

• Involved in DAC configuration for HR, Procurement and Spend, Supply Chain module.

• Report Customizations in OBIA application and creating Data Validation test cases from Source

to target.

• Involved in migration of code objects (ETL, DAC, RPD and Catalog) form development to the

higher environments.

• Performed the Admin related Activities like Configuring and Installing OBIA Out of Box

Applications and OBIEE 11g and Applying OBI 11g interim and bundle patches, and refreshing

the servers, shutting and starting up the servers

• 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.

• Managed upgrade and maintained the environments with latest patches

• Trouble shooting the issues related to repository models and report development.

Project 4:

Client: Emerson, Atlanta, GA

Duration: Jan 2011 - Oct 2011

Role: OBIEE Developer, Oracle Data Integrator (ODI)

Environment: OBIEE 11.1.1.3, OBIEE 10g

Responsibilities:

• Conducted design sessions with data owners toward capturing business requirement for

an analytics environment

• Working closely with end user community to enhance and improve the user experience

architecture look and feel

• Proposed and Configured a new Security model in order to maintain data-level security

for the users

• Proposed the enhancements required on the reporting requirements

• Proposed the required changes that are required in the EDW data model for generating

the required reports

• Involved in the DB design and required changes

• Developed the BI dashboards and reports

• Configured the security settings for the dashboards as well as data security

• Involved in the design activities and created the design specifications documents

• Documented test cases to test the reporting requirements functionality and carried out

thorough testing

• Deploy the code to the OBIEE Production environments

• Upgraded the environment from OBIEE 10g to OBIEE 11g

• Installed and configured Oracle Data Integrator (ODI) and developed Knowledge

Modules

• Installed and configured Oracle GoldenGate for data replication from the MSS to MSS-

R. Configured GoldenGate processes such as Manager, Extract, Replicat, Collector, etc.

Project # 5:

Client: HCA,Irving, TX

Role: Informatica Developer, Teradata Developer

Duration: Jun 2010 – Dec 2010

Environment: Informatica 7.x

Responsibilities:

• Analysis of the Source data for the required reports

• Proposed the required changes that are required in the EDW data model given by the

client

• Involved in the design activities and created the design specifications and the

corresponding documents

• Involved in the DB design and implementation of the Staging Area

• Created BTEQ Scripts to load the data from Staging area to EDW.

• Implemented BTEQ Scripts for comparison to validate the data before loading the EDW

• Developed and tested the Informatica Workflows to load the Staging Area

• Executed, monitored and troubleshoot the ETL for the full and the Incremental

• Co - ordinate with the admin teams to deploy to the production environments and also

executing the ETLs in the production

Project # 6:

Client: Eli-Lilly, Indiana, IN

Role: BO Data Services Developer

Duration: Feb 2010 - May 2010

Environment: Business Objects Data Services

Responsibilities:

• Analysis of the Source data

• Customized the out-of-box Rapid Marts given by the SAP

• Involved in the design activities and documented the required changes for the mappings

• Involved in the DB design and implementation of the Staging Area

• Developed and validated the loads of the EDW

• Executed, monitored and troubleshoot the ETL for the History and the Incremental loads

to test the customized rapid marts

Project # 7:

Client: Oracle, Redwood Shores, CA

Role: OBIEE Analyst

Duration: Sep 2009 – Jan 2010

Environment: OBIEE 10.1.3.4.1

Responsibilities:

• Analysis the required metrics and their functional usage

• Proposed and formulated the metrics as per the requirement

• Involved in the design activities and created the design specifications and documents

• Analyzed the functionality of the application from all the aspects of the data flows from

different sources into the data warehouse

• Proposed the data model and provided inputs to the data model in order to generate the

reports and the dashboards

Project # 8:

Client: GlaxoSmithKline Unlimited, UK

Role: Production Support Analyst

Duration: Jul 2008 – Aug2009

Environment: OBIEE 10.1.3.2.1

Responsibilities:

• Investigate the issues escalated by the Help desk and proposing them for fix and ensure

effective and timely resolution.

• Worked on Oracle Business Intelligence Administration activities

• Developed Informatica Mappings, sessions and Workflows on each subject area and data

marts based on best practices to implement the functionality with best quality

• Validated the Informatica mappings and Server logs and fix the issues.

• Involved in troubleshooting of the Informatica Mappings and OBIEE Repository

Configuration.

• Configured the end-to-end OBIEE environment on SSL

Project # 9 :

Client: Microsoft, Redmond, WA

Role: Siebel Analytics Tester

Duration: Sep 2005– Jun 2008

Environment: Siebel Analytics 7.x

Responsibilities:

• Involved in testing of the new subject area in Siebel Analytics Answers

• Actively involved in the testing area related to the release

• Involved in different Siebel Analytics processes migration (RPD, OBIEE webcat,

Informatica Repository and DAC)

• Involved in build engineer activities and in building environment for CRS application

• Validation of the CRS replication tool

Contact this candidate