Resume

Sign in

Data Life Insurance

Location:
Chandler, AZ
Posted:
May 16, 2020

Contact this candidate

Resume:

Naveen Chawan

972-***-****

adc9jk@r.postjobfree.com

Summary:

●Over 13+ Years of strong experience in design, analysis, development and implementation of various applications using Oracle Business Intelligence, ETL Tool under Windows/Unix environment.

●Expertise in implementation, upgrade and re-implementation of Oracle E-Business Suite ERP, Siebel CRM & Business Intelligence Applications for various industries (Manufacturing, HealthCare, Oil and Gas, Consumer Goods, Retail).

●Expertise in OAS, OAC, OBIEE 12c/11g/10g, OBIA and Security and Integration between BI application with Siebel and Oracle EBS Applications.

●Expertise in reporting tools like MS Power BI and Tableau.

●Having strong experience in installation, administration of various components (OBIEE/ODI/Informatica/DAC/Mobile App) on various platforms (AIX/Windows).

●Having onsite experience in Abu Dhabi, UAE.

●Having experience in implementation of various OBIA and is subject matter expert (SME) in Financial Analytics, HR Analytics, Projects Analytics and Order management & Supply Chain Analytics.

●Expertise in planning, designing and leading teams for implementing OBIEE solutions for leading clients using various implementation methodologies (Waterfall & Agile), deriving Functional Design based on Requirements, Development and maintenance of Data warehouse/Business Intelligence, performing solid GAP analysis for OBIA implementations to best use Out of the Box content.

●Worked extensively on modeling Hierarchies/Level Based Measures, Design & Development of ETL Mappings in Informatica/ODI, OBIEE & OBIA 7.9.6.1/11.1.7.1 architecting OBI solution for High Availability, configuring Clusters/SSO/integration with Siebel 8.1.1 & OBIEE 10g/11g/12c, designing and building all the layers of OBIEE Metadata Repository and design and development of reports and dashboards.

●Experience in multiple ETL tools such as Informatica/ODI which gives him enhanced skills in optimizing the data loads & a problem solver with a passion for simplifying and streamlining business processes using technology transparent to the business, has the ability to build strong relationships with clients and staff using negotiating talent, persuasion and demonstrated commitment.

●Strictly adheres to follow Oracle best practices throughout the implementation life cycle in all the areas and he has exceptional training skills in Oracle Business Intelligence tools to technical audience as well as business users (Oracle University & Oracle Partner Network instructor in ODI/Informatica/DAC, OBIEE & OBI Mobile Application).

Technical Skills:

●Oracle EBS Applications (11.5.1.0/R12)

●OBIA ERP: Financials/HR/Procurement & Spend/Order Management & Supply Chain/Projects Analytics, Sales & Marketing Analytics

●Oracle BI Enterprise Edition 10g (OBIEE) 10.1.3.3/10.1.3.4/10.1.3.4.1

●Oracle BI Enterprise Edition 11g (OBIEE) 11.1.1.5/11.1.1.6/11.1.1.7.1/9.x

●Oracle BI Enterprise Edition 12C (OBIEE) 12.2.1.0/12.2.1.2.0/12.2.1.3.0

●Oracle Analytics Server

●Oracle Analytics Cloud

●Oracle BI Mobile Application 11g

●Oracle BI Applications (OBIA) 7.9.6.3/7.9.6.4/11.1.1.7.1

●Siebel Analytics 7.7.1/7.8.4/7.8.5/8.1.1/8.2.2

●Siebel Analytics / OBI Administration Tool, XML BI Publisher Desktop

●Informatica 8.6.1/9.1

●Oracle Data Integrator (ODI) 10.3.5.0/11.1.1.7.1/11.1.1.9

●DAC/OBI Apps DAC (Data warehouse Administration Console) 10.1.3.4.1,11g

●SQL & PL/SQL

●Tableau 2019.1

●MS Power BI 2.7.x

●HTML, XML, SQL, JavaScript, Java

●MS Office: Excel/Word/PowerPoint/Projects/Visio

●Oracle Weblogic

●Oracle: 9i/10g/11g/12c

●MS SQL Server 2000

●Windows / UNIX

Professional Experience:

General Motors, Chandler, AZ USA

Sr OBIEE Analysts / Consultant Sep 2019 – Present

General Motors Company, commonly referred to as General Motors, is an American multinational corporation headquartered in Detroit that designs, manufactures, markets, and distributes vehicles and vehicle parts, and sells financial services, with global headquarters in Detroit's Renaissance Center.

GM would like to consolidate all their operational systems into the SIEBEL system and would like to build Enterprise Data Warehouse for all the historical & current data and serve OBI as a single source of reporting platform across the organization.

Responsibilities:

●Work with business managers across the organization to define, plan and develop further BI / reporting capabilities.

●Work with Business users to determine critical reporting needs in the Sales and Marketing Analytics, HR Analytics

●Building Custom OBIEE Dashboards/Reports and BI Publisher reports for the Users

●upgraded and Migrated OBIEE from 11G TO 12C and 12c to OAC i.e.; on premise to Oracle cloud server

●Apply required patches and securities privilege to make BI system workable

●Performed security configuration to entire organization using LDAP authentication

●Working on other reporting tool to compare data against different source system using MS Power BI and Tableau

●Collaborate with business owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution

●Develop front-end, metadata and ETL specification to support business requirements for reporting across the organization

●Troubleshoot Production issues, identifying root causes and planning remediation.

Environment: SIEBEL 8.1.1/8.2.2, OAC/OBIEE 12.2.1.3.0/4.0, OBIA 11.1.1.10, ODI 11.1.1.9, Oracle Database 12.1.0.2.0, MS BI 2.7.x, Tableau 2019.x

Projects under IT Convergence (Employer), Dallas, TX USA

Clients: ISS: DOTComm, Ithaca College, Masterbrand Inc, Riverbed, Intrado (WEST), Fundtech, Amys Kitchen

Sr BI Consultant March 2015 – Sep 2019

IT Convergence provides infrastructure services to various customers using enterprise applications such as Oracle E-Business Suite, Oracle Business Intelligence Applications and many Middleware applications. We provision environments based on client needs and provide support in maintenance of the servers.

Responsibilities:

●Design, implement major upgrades and expansions and Manage integrated security for BI applications

●Work with business managers across the organization to define, plan and develop further BI / reporting capabilities.

●Upgrade and migrate OBIEE 11g to OBIEE 12C.

●Installation and upgradation OBIEE from 11G TO 12C

●Migrated OBIEE 12c on premise to Oracle cloud

●Worked on apply patched for weblogic bug fixes

●Work with Business users to determine critical reporting needs in the Financial Analytics, HR analytics, SCOM Areas

●Building Custom BIP reports, Mobile Application Dashboards/Reports for the Users

●Train power users in the use of these tools and development of basic queries / reports / dashboards.

●Worked on other reporting tools like MS Power BI and Tableau.

●Collaborate with business owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution

●Develop front-end, metadata and ETL specification to support business requirements for reporting across the organization

●Responsible for the application maintenance of both Production and Non-Production environments

●Troubleshoot Production issues, identifying root causes and planning remediation.

Environment: Oracle EBS 12.1.3, OBIEE OAC/12C/11.1.1.7.x/9.x, OBI Mobile App, OBIA 11.1.1.7.x, Tableau 2019.x, MS BI 2.7.x, ODI 11.1.1.7.1, Informatica 9.x, DAC 11g, Oracle Database 11g/12C

Oxbow Carbon LLC, West Palm Beach, FL USA March 2014 – Feb 2015

Lead BI Administrator/ Consultant

Oxbow Carbon LLC is one of the world's largest recyclers of refinery and natural gas byproducts. Oxbow upgrades, handles, transports and sells petroleum coke and Sulphur into markets where they can be used to produce aluminum, steel, electric power, fertilizer, cement and other critical products for the world economy.

Oxbow Carbon is a global organization with many various technology footprints. Over a period of time, Oxbow’s business grew with many mergers and acquisitions. With each acquisition there is a new application/system. Oxbow would like to consolidate all of their operational systems into Oracle EBS and would like to build Enterprise Data Warehouse for all the historical data and serve OBI as a single source of reporting platform across the organization.

Responsibility:

●Design, Implement and Manage integrated security for BI applications

●Support BI solution – Planning and implementation of enhancements.

●Work with business managers across the organization to define, plan and develop further BI / reporting capabilities.

●Design, manage and implement major upgrades and expansions.

●Work with Business users to determine critical reporting needs in the Financial Analytics, Supply Chain and order Management Areas and Procurement and Spend Analytics.

●Serve immediate needs via Federated data Sources

●Build Corporate Financial Reporting (Blue Book) which should be accessible via Mobile App (iPad)

●Build Pipe-lines to extract data from Microsoft Great Plains + KIT System

●Build Pipe-lines to extract data from Essbase Cubes

●Integrate OBIEE Reporting into SharePoint Portal

●Building Mobile Application Dashboards/Reports for CFO team

●Train power users in the use of these tools and development of basic queries / reports / dashboards.

●Collaborate with business owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution

●Develop front-end, metadata and ETL specification to support business requirements for reporting across the organization

●Responsible for the application maintenance of both Production and Non-Production environments

●Troubleshoot Production issues, identifying root causes and planning remediation.

●Develop reporting standards and best practices to ensure data standardization and consistency

●Perform data cleansing and data auditing as necessary to ensure data quality

●Define and develop physical and logical data models to support departmental and functional reporting needs

●Create, maintain, and manage documentation for all data warehouse and reporting development efforts Help to create and implement a long-term storage and business continuity strategy including backup & recovery and data storage and archiving

Environment: Oracle EBS 12.1.3, OBIEE 11.1.1.9.x/7.x, OBI Mobile App, OBIA 11.1.1.7.1 Oracle OnDemand Linux

Servers, ODI 11.1.1.7.1, Oracle Database 11g

Statistics Center Abu Dhabi, UAE April 2013 – March 2014

Sr. OBIEE/ETL Consultant

Client is the government-based company which aims to develop and organize statistical work in the Emirate of Abu Dhabi and the production, analysis and dissemination of all the official statistics of Abu Dhabi Emirate. Client is also responsible for the integration and harmonization of statistics produced by other local departments and entities, in regard to the standardization of statistical concepts and definitions. Being the main official body concerned with the collection of statistical data in the Emirate of Abu Dhabi, SCAD assumes the functions of preparing the statistical business plans that serve the emirate’s development programmers, conducting statistical surveys all over the emirate, without prejudice to the interest of national statistical work. SCAD is also responsible for the collection, classification, storage, analysis and dissemination of official statistics and the release of the results of social, demographic, economic, environmental and cultural surveys. Client has Oracle EBS for managing their data process and Oracle Business Intelligence for reporting on the Survey programs. Current BI solution requires extensive efforts from the business users to derive certain reports.

Responsibility:

●Understanding the requirements of the client, business scenario(s) and the application and preparing the design documents.

●Assist Users for planning and scoping the BI activities/projects

●Integrated OBIEE 11g with .Net Application & Google Maps.

●Installed & Configured OBI Mobile App Designer.

●Upgraded OBIEE 11.1.1.5.0 to OBIEE 11.1.1.7.1. Implemented and Configured OBIEE with Data warehouse setup.

●Designed and developed OBIEE Repository (.rpd), Dashboards, Answers, prompts, Filters and BI Publisher reports.

●Work with Business users to determine critical reporting needs in Financial Analytics.

●Configured OBIA – Procurement and Spend Analytics.

●Involved in preparing the report for the General Meeting.

●Involved in regular Users interaction/Calls to identify the issues, change requests, enhancements and provided best of technical solutions.

Environment: Oracle EBS 11.5.1.0, OBIEE 10.1.3.4.1/11.1.1.5/11.1.1.7.0, OBI Apps 7.9.6.1, XML BI Publisher, Linux Servers, Windows Server 2008 R2, Oracle Data Integrator (ODI), Informatica 8.6.1/9.0.1, DAC10.1.3.4.1, Oracle 11g (SQL, PLSQL)

Abu Dhabi National Energy Company PJSC (TAQA), UAE June 2012 – March 2013

Sr. OBIEE/ETL Consultant

Client is the global leader in Oil & Gas, Water & Energy Sector Company and has implemented Oracle EBS for managing the Sales Representatives goals and tracking opportunities. Client also uses Marketing Segmentation for some of the regions worldwide. There are three separate instances deployed by the client along with the Oracle Business Intelligence applications with the same code base across different regions. The project goal is to consolidate all the instances into a single instance thus reducing the infrastructure costs along with usage of a single unified application across the regions.

Responsibility:

●Experience with Oracle Business Intelligence Enterprise Edition 11.1.1.6

●Upgraded OBIEE 10G to OBIEE 11G, Implemented and Configured OBIEE with Data warehouse setup- which contains (Informatica and DAC).

●Configured complete monitoring setup to monitor the performance of Applications and Database.

●Installing, Configuring, troubleshooting, upgrading and monitoring OBIEE & BI Apps.

●Integrated OBIEE 11g security model with Oracle R12 EBS.

●Worked on OBIA – Financial, Supply chain and Order Management Analytics.

●Designed and developed OBIEE Repository (.rpd), Dashboards, Answers, prompts, Filters and BI Publisher reports from EBS suite.

●Involved in preparing the report for Annual General Meeting (AGM)

●Involved in regular Client interaction/Calls to identify the issues, change requests, enhancements and provided best of technical solutions.

●Involved in developing ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.

●Worked on OBIA – Financial, Human Resource Analytics and Supply chain and Order Management.

●Developed reports based on AR, AP, GL, HR, OM, INV modules.

Environment: OBIEE 10.1.3.4/11.1.1.6.0, OBI Apps 7.9.6, Informatica 8.6.1/9.0.1, Oracle 11g (SQL, PLSQL), and Oracle Data warehouse Administration Console (DAC) 10.1.3.4.1, BI Publisher, Windows Servers

Gerling Life Insurance, Bangalore INDIA Nov 2011 – April 2012

OBIEE & Informatica Developer

Client is one of the largest insurance companies. Client offers a solution to provide every phase of one’s life. It offers Individual insurance and group insurance. And each has subcategories as Life insurance, med claims, disability insurance and annuity. This data exists in three types of source system. The main purpose of this project is to capture the customer’s data and reporting for bonds. ETL processes are scheduled to meet daily, weekly and monthly service level expectations. Data loads are primarily incremental updates with a full table refreshes treated as exceptions. Project involves design and ETL development of the Data Mart star schema

Responsibility:

●Designed and developed OBIEE Repository (.rpd), Dashboards, Answers, prompts, Filters and BI Publisher reports from EBS suite.

●Involved in preparing the report for Annual General Meeting (AGM)

●Involved in regular Client interaction/Calls to identify the issues, change requests, enhancements and provided best of technical solutions.

●Work with Business users to determine critical reporting needs in the Financial Analytics, HR analytics Areas

●Involved in developing ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.

Environment: Windows, OBIEE 10g, Oracle 10g.

Target, Bangalore INDIA March 2010 – Sep 2011

OBIEE Developer

Client is the largest retailer by sales revenue in the United States. Client operates its retailing business exclusively in the USA. It is a rival and competitor of Kmart and Wal-Mart. Target Co. includes clothing house wares food etc. The project trans3 dealt with the transportation department of Target Co. The company implemented OBIEE for the Delivery Analytics of the various goods. The Products are delivered to the stores from various Distribution Centers (DC). Dimensions like product truck Invoice DC Time etc. were considered. Various customized reports/dashboards were developed for the different user groups across the organization. Client has decided to use OBIEE 11g for enhancing their analytical capabilities.

Responsibility:

●Knowing the business of Client, understanding competitive analytical requirements

●Analyzing and understanding the functional requirements.

●Designing Technical documents by mapping the functional requirements.

●Development of ETL for Full and Incremental Loading.

●Work with Business users in the HR analytics Areas.

●Configuring DAC in order to accommodate the customization in Informatica.

Environment: OBIEE 10g (10.1.3.4.1), Windows 2008 Servers, Oracle 10g (SQL, PLSQL)

VCA/Antech, Chennai INDIA Oct 2009 – March 2010

OBIEE Developer

Client is the leading provider of pet health care services in the country with a nationwide clinical laboratory system and over 435 free-standing animal hospitals. Client has a business need to provide daily performance reports of all tests completed within its labs across the country to its lab managers. Using Oracle’s OBIEE dashboards provided a flexible, parameter-driven dashboard to present the information in an organized, insightful manner so that the lab managers can Drill-down within intuitive chart views of data and derive intelligence-at-a-glance which improved productivity by eliminating the need for any number crunching.

Responsibility:

●Understanding Business Processes and gathering analytics requirements with Business

●Building POC and validating the reporting requirements with Business

●Design of OBIEE Metadata Repository based on the POC results and requirements

●Building OBIEE Metadata Repository based on the design

●Building Hierarchies and Level based measures

●Construction of Reports using Oracle Analysis (Previously Answers) with different views (Pivot, Chart) and extensively implemented Slider based navigation of data.

●Building Dashboards with multiple pages and using Dashboard Prompts

●Performance Tuning of OBIEE Reports

Environment: OBIEE 10g (10.1.3.4.1), Windows 2008 Servers, Oracle 10g (SQL, PLSQL)

Chrysler, Chennai INDIA Feb 2008 – July 2009

Technical Support Engineer

Technical support for CSC and Covansys associates and coordinating with support helpdesk for Technical related issues. Providing support from IWC service desk to Chrysler production environment by monitoring the tickets (all Severity Levels from Level 0 to Level 6) by acknowledging and routing them to the respective support groups immediately within the defined SLA period.

Responsibility:

●Managed to provide excellent support to customers in a quick turnaround time. Ensured meeting various SLA like ownership SLA, Resolution SLA etc.

●Addressing end user questions / mails.

●Troubleshooting and resolving the tickets raised by CSC/Covansys associates in ticketing tool.

●All kinds of software Installation and Configuring.

●Providing first level support to the end users through remote administration using Dameware.

●Solving Server, network, and application problems.

●Creating Distribution list and Security Groups.

●Administered user accounts, adding/removing users and groups in Windows 2003.

●Monitoring the tickets (all Severity Levels from Level 0 to Level 6) by acknowledging and routing them to the respective support groups immediately within the defined SLA period.

●Designing Technical documents (RPD).

●Design and Develop new reports and Dashboards. Total of 32 custom reports and 4 dashboards with 15 dashboard pages in all are built.

Environment: OBIEE 10g (10.1.3.4.1), Oracle 10g, Web Trouble Ticket Tracking System, Dashboard Anywhere.

Merrill Lynch, Chennai INDIA Jan 2007 – Feb 2008

Oracle Developer

Client is one of the world's largest financial institutions, serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services.

Responsibility:

●Analyzing and understanding the functional requirements.

●Siebel Analytics 7.8.4, Oracle 10g, Windows Servers.

●Siebel Configuration using Siebel Tools

●Creation/Enhancements of the Actuate reports.

●Testing of functionality after Configuration.

●Test Data Creation and Unit Test Case Document Preparation

Environment: Siebel Analytics 7.8.4, Oracle 10g, Windows Servers.

Educational Details:

●Bachelor of Technology - Computer Sciences & Engineering from Jawaharlal Nehru Technological University, Hyderabad, India.



Contact this candidate