Vaibhav Vulpey

ad37sk@r.postjobfree.com

848-***-****

SUMMARY:

Twelve Plus years of experience in gathering Business Requirements, Analysis, Design & Data Modeling, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.

Experience in Installing and Configuring Oracle Data Integrator (ODI) Software tool in a three-tier environment and performing periodic upgrades, performing source to target mappings, storage capacity planning and developing ETL.

Extensive DW experience using Oracle Data Integrator (ODI), Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.

Experience in architecting data-related solutions, developing data warehouses, developing ELT/ETL jobs, Performance tuning and identifying bottlenecks in the process flow.

Hands on experience with the new version ODI 12C.

Extensive experience in OBIEE Administration Tool, OBI Answers, OBI Intelligent Dashboards, OBI Publisher, Delivers and iBots with OBIEE Applications.

Installed and Configured OBIEE, DAC and Informatica on Unix/Linux and Windows Environment.

Expertise in developing Oracle BI Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer).

Experience in Complete life cycle of Business Intelligence with Star and Snowflake Schema Methodologies.

Experience in OBIEE features (i.e., Cache, Usage tracking, Dimensional hierarchy, Aggregate navigation, Variables/Initialization Blocks configuration etc.), converting Snow-Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, and Physical & Logical Data Modeling.

Good experience in configuring DAC tasks and generating reports by using Answers and configuring and scheduling of iBots.

Informatica – Expertise in Developing Mappings, Maplets, Workflows and Sessions using Informatica Power center.

Detailed knowledge in Data Warehouse Administration Console (DAC) and Informatica Servers.

Creating variables, sequences, user functions, interfaces, and packages in ODI.

Good Knowledge in Oracle SQL & PL/SQL Packages, Procedures, Functions and Triggers.

Technical Skills:

Business Intelligence: Oracle Business Intelligence OBIEE 12c/11g/10g, OBIA 7.9.6.x, 11.1.1.8.1, BI Publisher, (Web, Answers, Dashboards), Hyperion Essbase

ETL Tools: ODI 11g/12c, Informatica 10x/9x/8x/7x

Databases: Oracle 8i/9i/10g/11g, DB2Teradata

Tools: TOAD, Oracle SQL Developer

Operating System: Windows 2000/2003/XP, UNIX, Linux

Scripting Languages: SQL, PLSQL, UNIX shell scripts and K shell

WORK EXPERIENCE:

Office of StateComptroller, NY Apr 2021- Till Date

Sr. ODI/OBIEE Developer

Responsibilities :

Design, Build, Test, Deploy ETL Automation processes/routines in ODI using Mappings, Procedures, Variables, Scenarios, Load plans for data Integrations to suit the varied data sets/patterns.

Design, develop complex database objects such as Stored Procedures, Functions, Packages, Indexes, Triggers using SQL and PL/SQL to move the changed data (CDC, Full load, Delta loads) across multiple env's/platforms using ODI KM's, Adapters, Load plans.

Create, Modify, perform periodic review of ODI Source and Target systems physical, logical schema's, data server connection strings, jdbc url's, db properties, agent property settings, Purge log's in ODI Topology Manager, Operator to fine tune, for optimal/best performance of MW ODI Data Integrations.

Analyze complex business processes, develop requirements (brd's), provide technical solutions (design, develop and deploy ODI data automation processes) to meet the reporting/data requirements of the business.

Document the Deployment Plans, Code Review/Deployment Checklists, AT/SIT/UAT Test Results, Business Signoff, Change Management approvals (CR's) to accommodate ODI Code Deployments in completing Business user requests.

Correct customizations of Data Warehouse, RPD, and in Dashboards

Design and implement security object level security using custom roles and privileges.

Create drillable/guided navigation reports based on business requirements.

Create iBots/Intelligence Agents for job-critical levels and auditable differences delivered to dashboards.

Design, test and modify OBIEE security using roles, privileges in Enterprise Manager (EM), Administration Console to Access security.

Environment: ODI 12c, OBIEE 12c and Oracle Applications R12

Gilead Sciences, CA May 2020- Apr 2021

Sr. ODI /OBIEE Developer

Responsibilities :

Worked during the whole life cycle of the project from requirements gathering to deployment.

Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.

Developed Interfaces for multiple sources such as Relational database, SQL server, Flat files for Extraction, Transforming and Loading data.

Assisted Data Architect in designing by doing source data analysis, rectifying the requirement documents, creating source to target mappings.

Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.

Implemented Change Data Capture feature of ODI to refresh the data in Enterprise Data Warehouse.

Used yellow interfaces/Reusable mappings in ODI 12c for developing most complex interfaces.

Increased performance of loads by applying proper hints, indexes, and analyzing master tables and explain plans.

Analyzed session log files in operator navigator to resolve errors in mapping and managed session configuration.

Implemented mappings in ODI 12c using Aggregate, Expression, Filter, Dataset, Join, Lookup and Split components and Implemented ODI 12c mapping to load multiple target tables.

Created Load plans to run the scenarios in a hierarchy of sequential and parallel steps and created test cases for end-to-end testing of ETL packages.

Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.

Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.

Provided guidance and support to end users during the implementation and in production.

Environment: Oracle Applications 12.2, OBIEE 12C and ODI 12C

McGrath Rental Corp, CA Aug 2019- May 2020

Business Intelligence Engineer

Responsibilities :

Lead a BI Configuration team, ensuring design, development and testing work is completed on time.

Captured and documented management information/Business Intelligence requirements from clients, via workshops, ensuring suitable balance of business needs and delivery feasibility.

Created numerous executive level reports. Generated dashboards to provide insight into the Order Management data.

Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.

Gathering requirements from users to develop interfaces, packages, Load Plans.

Extensively used ODI to load data from Oracle, XML files and flat files.

Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents.

Hands on experience of working with ODI Knowledge Modules like LKM, IKM and JKM, CKM. Extended the base ODI Knowledge Modules to create customized versions that are re-used across other data integration projects.

Optimization & maintenance of the Data Warehouse implemented strategies for the fact tables and indexing.

Raised SR with oracle and worked closely with oracle on the bug fixes.

Implemented and created custom Reports in Usage tracking reports User Acceleration.

Implemented the delivery of Agents using OBI delivers to alert the associated teams.

Environment: Oracle Applications R12, OBIEE 11g and ODI 11g

Charter Manufacturing, WI Jul 2016- Jun 2019

OBIEE /ODI Consultant

Responsibilities :

Worked during the whole life cycle of the project from requirements gathering to deployment.

Implemented Supply Chain, Manufacturing and Procurement and Spend Analytics for OBIA 11.1.1.8.1.

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

Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse.

Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.

Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.

Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.

Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.

Analyzed the Business requirement for Oracle Data Integrator, mapped the architecture, and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.

Customized the OBIEE Repository (physical, BMM, and presentation layers).

Developed and maintained Data modeling standards, policies and procedures.

Enforce data quality measures and data elements naming standards at the time of validating logical data model components.

Experience in Conceptual, Logical and Physical Modeling

Extensive experience in designing dimensional models such as Star Schemas.

Worked on Procurement and Spend- Purchase orders subsets and merged these subsets into a Master repository without conflicting work of other developers.

Continuous review of Business-critical Database to proactively identify space issues, performance tuning issues.

Environment: Oracle Applications 12.2, OBIEE 11.1.1.9, ODI 11g/12c, OBI apps 11.1.1.8.1

Advance Auto Parts, VA Jul 2015 – Jun 2016

OBIEE Consultant

Responsibilities:

Installed and configured OBIEE 12c on Linux environment.

Created reporting solutions for Item supersession and Store acquisitions projects using OBIEE 12c.

Performance tuning the existing reports and reviewing poor performing OBIEE reports.

Involved in Cache Management, Performance tuning, data and creating object level security.

Created schedules to seed and purge cache for cache management.

Defect Fixing and Migration activities for OBIEE 11g and BIP reports.

Development/Unit testing of BI Publisher reports. Includes developing Data models from SQLs.

Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.

Developed templates and reports in Oracle BI publisher in rtf format.

Conducted UAT sessions with end users.

Involved in unit testing, integration testing of reports generated by OBIEE.

Environment: OBIEE 12c, BI Publisher, Data stage 8.0.1, Teradata 14.0

California Water Service Company, CA Jan 2015 – Jun 2015

Sr. OBIEE Lead

Responsibilities:

Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.

Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.

Provided dashboard access to the users through WebLogic and setting up the security levels.

Involved in Integrating Oracle BI Presentation Services with BI Publisher.

Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.

Involved in Analytics gap analysis related to SRMW Data Model and ETL, creation of detailed design documentation, accurately mapping requirements.

Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.

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.

Environment: Oracle RMS, OBIEE 11.1.1.7.1, OBIEE 10g, OBI Apps 7.9.6.4, Informatica 8.01/9.5.1, DAC 10g/11g

NBTY, Inc.-Bohemia, NY Sep 2013 - Jan 2015

Sr. OBIEE Consultant

Responsibilities:

Configured and Implemented Supply chain and Project Analytics.

Set up of Multiuser Development in OBIEE.

Worked on Subset repositories for functional areas of Finance and order Management in MUDE Environment.

Responsible for Maintaining and Migrating MUDE RPD and performing Three-way merge.

Implemented custom functionality in BI Publisher to prevent blank pages getting printed in reports.

Configured Column and Dashboard Filters in OBIEE Requirement validation of the reports and drilldowns.

Extensively worked on RPD, developed various Subject Areas for Contracts, Service Request & Install base modules, and utilizing them for different criteria including charts, prompts, and pivot tables using OBIEE Answers and OBI Dashboards.

Customized repositories using metadata objects (Tables, Columns) and Web Catalog Objects (Folders, Reports).

Environment: Oracle Applications R12, Supply Chain Management, OBIEE 11.1.1.7.1, BI Publisher 11g

GE Energy-Waukesha, WI April 2013-Aug 2013

Sr. OBIEE Developer

Responsibilities:

Extensively worked on OBIEE and BI administration and developed business reports and dashboards based on business requirements.

Configured Column and Dashboard Filters in OBIEE Requirement validation of the reports and drilldowns.

Created logical tables, assigned levels, and custom aggregation rules.

Performed End-to-End development (mappings, data sources, business rules/logic, rpd, subject areas, reports/dashboards, and administration)

Customized repositories using metadata objects (Tables, Columns) and Web Catalog Objects (Folders, Reports).

Set up permissions to the users and implemented object level security.

Design & build reports and dashboards and assist in development of complex ad hoc queries and analyses.

Provide consulting services in a technical capacity to management and other technical staff.

Provide on-site user support to clients, including data analysis, discovering and fixing data issues, and assisting with OBIEE dashboard/reporting questions.

Environment: Oracle Applications R12, OBIEE 11.1.1.7, OBI Apps 7.9.6.3

EDUCATION: Master of Science in Electronics and Computer Technology, 2012, Indiana State University.

Contact this candidate