trong experience in providing end-to-end business intelligence solution (OBIEE/OBIA) by data warehou

EXPERIENCE SUMMARY

1. PROJECT PROFILE 1

DurationJan’2015 to Apr 2015
LocationPune, India(Client Location)
Tools and TechnologiesOBIA 11.1.1.8.1, OBIEE 11.1.1.7.13,ODI 11g, Oracle EBS R12.3, SQL
CLIENT DESCRIPTION & SCOPE
Client is a leading manufacturing company in India. The project involved creating dashboards and reports for EBS sourced data for different functions – Procurement & Spend, Inventory and Sales and Order Management.

Roles and Responsibilities:

• Closely worked with business Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository
• Configuration OBA 11.1.1.8.1 configuration
• OBIA SSO Integration with EBS R12.
• Administered Permissions and Privileges for dashboard visibility and modifications to Users based on their groups or responsibilities and Object level security and data level security for the various users who would be using SSO integration.
• Experienced in Installation and configuration OBIEE on various servers and System Administration using Windows /Linux, Sun Solaris.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up in reports to improve performance.
• OBIA Code migration for one environment to other environment
• Performed stakeholder analysis team and weekly status reports to leadership teams

 

1. PROJECT PROFILE 2

DurationAug’2014 to Jan’ 2015
LocationMumbai, India
Tools and TechnologiesOBIEE 11.1.1.7.13
CLIENT DESCRIPTION & SCOPE
Client is a leading largest private Bank in India. The project involved to provide the production support for OBIEE 11g server, dashboards, reports and security.

Roles and Responsibilities:

• Manage OBIEE team, Production Server.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up in reports to improve performance.
• Administered Permissions and Privileges for dashboard visibility and modifications to Users based on their groups or responsibilities.
• Responsible for implementing Object level security for the various users who would be using the BI system.
• Extensively involved in setting up Data level security for the BI Reports and also handled the security and privileges from the Database to the Oracle repository.
• Setting up the Administered Privileges and Security for various users using the LDAP security.
• Experienced in Installation and configuration OBIEE on various servers and System Administration using Windows.
• Performed stakeholder analysis team and weekly status reports to leadership teams

1. PROJECT PROFILE 3

DurationAug’2013 to Aug’2014
LocationMumbai, India
Tools and TechnologiesOBIA 7.9.6.3, OBIEE 11.1.1.7.13, Informatica 9.0, DAC 10g, Oracle EBS R12.1, PL/SQL,
CLIENT DESCRIPTION
Client is a leading BPO company in US and India. The project involved creating dashboards and reports for EBS sourced data for different functions – HR, Accounting, Spend and Projects.
Roles and Responsibilities:

• Manage OBIEE team, Production Server and project like financial scorecard, Manager Dashboard and CFO Dashboard for WNS.
• Providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers creating reports / Dashboards, cache monitor, security implementation and building OBIEE/Siebel Analytics Repository.
• Interacted with business team and vendors to gather Business Requirements as well as to define business and functional specifications.
• Involved design and development of repository (RPD) (creating/Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
• Expressions mapped logical columns in BMM layer to physical columns in the physical layer. Developed Reports/ Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Column Selector, Tabular with global and local Filters).
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up in reports to improve performance.
• Administered Permissions and Privileges for dashboard visibility and modifications to Users based on their groups or responsibilities.
• Responsible for implementing Object level security for the various users who would be using the BI system.
• Extensively involved in setting up Data level security for the BI Reports and also handled the security and privileges from the Database to the Oracle repository.
• Setting up the Administered Privileges and Security for various users using the LDAP security.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository.
• Experienced in Installation and configuration OBIEE on various servers and System Administration using Windows.
• Performed stakeholder analysis team and weekly status reports to leadership teams

 

1. PROJECT PROFILE 4

DurationAPR’2012 to Aug’2013
LocationGujarat, India
Tools and TechnologiesOBIA 7.9.6.3, OBIEE 11.1.1.7.13 , Informatica 9.0, DAC 10g, Oracle EBS R12, PL/SQL
CLIENT DESCRIPTION
Client is a leading manufacturing industrial gear in India and Global. The scope of the project was to create interactive dashboards and reports using OBIEE / OBIA 7.9.6.3 for EBS R12 sourced data for different modules –Financial( AP, AR, GL), Order managemnt , Procurement , Project, Inventory


Roles and Responsibilities:

• Configuration and installation and up gradation OBIA/OBIEE to the client Elecon Eng. Ltd.
• Up gradation OBIEE 11.1.1.6.7,OBIA 7.9.6.4 with informatica PowerCenter 9x ,DAC 11g
• OBIEE 10.1.3.4.1 (Designing the repository, Designing of Reports, charts, Dashboards, Dimensional hierarchies to view the most granular level of information, Creation of Users and user groups assigning various privileges to them to view different Dashboards, Unit testing of the reports developed, Preparing User Manuals explaining how to use the reports dashboards, Fixing bugs of the module applications as and when necessary)
• Perform unit testing at various levels of the ETL
• Developed Informatics Mapping for the different stages of ETL.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Debug the sessions by utilizing the logs of the sessions.
• Developed technical solutions to business problems in the OBIEE repository.
• Developed new subject areas in the repository per business requirements.
• Performed environment migrations between the Development, Quality Assurance, and Production environments
• production support, document and training

 

1. PROJECT PROFILE 5

DurationOCT’2011 to Apr’2012
LocationGujarat, India
Tools and TechnologiesOBIA 7.9.6.3, OBIEE 11.1.1.7.13 , Informatica 8.6, DAC 10g Oracle EBS R12, PL/SQL
CLIENT DESCRIPTION
Client is a leading manufacturer of GEARED MOTORS & GEAR REDUCERS in the country. The scope of the project was to create interactive dashboards and reports using OBIEE / OBIA 7.9.6.3 for EBS R12 sourced data for different modules –Financial( AP, AR, GL), Order managemnt , Procurement , Inventory
Roles and Responsibilities:

• Involved in the design and set up of Dev, Test and Prod environments.
• Worked with the Financial Services staff and Business Analysts for requirements gathering, business analysis, testing, metrics and project coordination.
• Used Informatica to extract data from OLTP source to OLAP destination.
• Customized and developed Repository, Configured Metadata Objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Monitored ETL mappings as per report requirements Developed Custom Reports/Ad-hoc queries using OBI Answers and assigned them to application specific Dashboards
• Created Custom Star Schema as per the business requirements Configured and Created repository using OBIEE Admin tool.
• Created hierarchy based Dashboards for different Business units and end-users.
• Used BI Publisher to customize Answers requests to output in pdf and html formats
• Involved in Unit, System and Integration Testing and Performed Data Validation for all the reports that are generated from BI Analytics.
• Oracle EBS 11.5.x OM, Finance(AP,AR), Purchase) functional knowledge.

 

1. PROJECT PROFILE 6

DurationJul’2010 to Sep’2011
LocationGujarat, India
Tools and TechnologiesOBIA 7.9, OBIEE 10 , Informatica 8.6, DAC 10g Oracle EBS R12, PL/SQL
CLIENT DESCRIPTION
Client is a leading manufacturing in Mining and Construction Machines in India. The scope of the project was to create interactive dashboards and reports using OBIEE / OBIA 7.9.6.3 for EBS R12 sourced data for different modules –Financial( AP, AR, GL), Order managemnt , Procurement , Project, Inventory

Roles and Responsibilities:

• Worked with the Business Analysts for requirements gathering, testing, metrics.
• Inspected and recommended workflows for the ETL processes which are used to extract historical and latest Transaction, and FDIC information from ODS tables.
• Designed Custom Star Schema for Related Loans and merged with the existing subject area.
• Involved in enhancing Business Models for improved request performance
• Used MUD to create the RPD.
• Analyzed and added enhancements to Metadata in all 3 layers (Physical, Business and Presentation).
• Developed Reports using Answers to build application specific Dashboards for AP and GL modules.
• Scheduled ibots to deliver daily emails according to user requirements.
• Involved in Setting up Security, Users & Groups.
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all the reports that are generated from BI Analytics.
• Trained end-users to build Ad-hoc reports using OBIEE.