SUMMARY
·
7+ years of BI experience in OBIEE 11.1.1.5.x/10.1.3.x, Oracle 10g/11g & Tableau which includes experience in
Business Requirement Gatherings, Analysis, Design, Data Modeling, Development,
Testing and Implementation of Data warehouse/Business Intelligence.
·
3.5+ years of Agile experience working in Scrum
model.
·
Rich functional knowledge in the Sales domain including Bookings, Quoting, Commissions,
Opportunities, etc.
·
Expertise with
developing dynamic and interactive Dashboards with drill-down & drill-through
capabilities, and Web Catalog using Oracle Business Intelligence Tool.
·
Configured Physical Layer - Import
tables, Create Tables, add / change physical joins / keys, Logical Layer -
Create Logical tables / dimensions, columns, Create Logical Joins/keys, Set
levels to support Drill-down, Aggregation / Sum over Columns, Presentation
Layer - Create Folders / sub-folders
·
Administering
security for Tableau
· Production support and helping business user in resolving report, Tableau desktop & OBIEE level issues.
·
Experience in
Setting up Dynamic, System and Non-System Variables.
·
Development of
Business Reports, Business Alerts with help of Oracle Answers, Oracle Delivers
and Oracle iBots, Oracle BI
Publisher to create reports from multiple data sources.
·
Experience in weekly production release
activities & post release sanity check tasks.
·
Experience in Setting creating Time Dimensions
including As-Was, As-Is & As-Of flavors and Time Series Measures like AGO and To-Date functions and also
created Level Based Measures.
·
Experience in Creating Complex Aggregation
Tables and Dimensional Hierarchies.
·
Experience in Configuring Usage Tracking to keep track of Query Performance, Query Log and
Report Usage.
·
Experience with General Ledger
reporting including Balance Sheet, Cash Flow, Budget, etc.
·
Expertise in Building Metadata Repositories (.rpd), building Physical layer,
Business Model and Mapping layer, Presentation layer using Oracle BI
Administration tool.
·
Experience in Configuring & working with
Multi User Environment (MUDE) on
Shared environment to multiple development teams to work.
·
Experience with OBIEE components like OBI
Server/Client, OBI Answers, Oracle BI Presentation Services, Scheduler, Config
files, other tools and utilities.
·
Experience in Installation, Configuration, and
Administration of OBIEE 10.1.3.x/11.1.1.x
·
Proficient SQL coding with Index, Views, Partitions using TOAD/SQL Server.
·
Experience in developing Informatica Mappings
/ Mapplets and Tasks using various Transformations for ETL from Multiple
Sources to Data Warehouse.
·
Active
participation in Presentation of Project concept, status, plans and progress.
TECHNICAL
SKILLS
·
Business Intelligence -
OBIEE 11.1.1.5.x, OBIEE 10.1.3.x, Tableau 9.x, BI Validator, BI Connector
·
RDBMS - Oracle
10g/11g, MS-SQL SERVER
CERTIFICATIONS
Certified Scrum
Master (CSM)
PROFESSIONAL
EXPERIENCE
NetApp
Inc., Sunnyvale CA Oct
2012 –Till Date
Sr.BI Analyst
Responsibilities:
·
Analyze business
reporting requirements & assist in modeling & architecture activities
for pricing related DW development
·
Dashboard Prompts
functionality for reports by passing the parameters on to the dashboards using
the Presentation Variable.
·
Developed and
debugged many Dashboards using different Analytics Views (Pivot Table, Pie/Bar
Chart, and View/Column Selector, Narrative View), Dynamic / Interactive
Dashboards with drill-down capabilities using global and local Filters.
·
Assisting in
modeling & architecture activities for Quote DW development.
·
Modifying &
Updating database credentials in the rpd connection pools, maintain users,
project permissions
·
Building Metadata
Repositories (.rpd), building Physical layer, Business Model and Mapping layer,
Presentation layer using Oracle BI Administration tool.
·
Developed
multicurrency functionality for the user’s ability to acquire data in user’s
preferred currency format.
·
Development of
Business Reports, Business Alerts with help of Oracle Answers, Oracle iBots to
create reports from multiple data sources.
·
Configuring &
testing new 11.1.1.7 for the OBIEE application & its verification as per
corporate standards.
·
Help business users
to build analytics/reports on Tableau
·
Design &
maintain incident ticket tracking dashboard in Tableau
·
Develop
enterprise level forecast, goals & bookings related dashboards in Tableau
·
Train Tableau
audience to navigate through published dashboards in Tableau server
·
Utilized session
variables, repository variables and initialization blocks in the repository
building and modification procedures.
·
Coordinating with
multiple cross functional teams to work with RPD MUD client tool.
·
Create
custom/derived measures in Administration tool for the requirements using
expression builder and calculation wizard and also created hierarchies and
level-based measures for drilldown detail within Analytics Reports.
·
Creating &
administrating the security settings in the administration tool as well as in
the underlying database.
·
Dashboards pre
& post implementation pixel to pixel comparisons using BI Validator &
manual eyeballing.
·
Analyze data
discrepancies & provide solutions to support reporting requirements.
Successfully deployed POC models for OBIEE reporting & conduct UAT sessions
with business stakeholders.
·
Data validations
using complex SQL queries & custom answers reports.
·
Build test cases
and test the Reports (BI Answers)/Dashboards by comparing the SQL Output on the
Data-warehouse
·
Create drill down
charts and drill down tables to gather more information on Financial Analytics
and Supply Chain using navigation
·
Decommission
reports, dashboards & attributes based on usage
·
Build custom
reports using AGO and To-Date functions.
·
Integrate OBIEE
reports with SharePoint, SFDC, MS outlook using drill through functionality.
·
Manage, modify
& maintain user’s data level & object level security.
·
Reconcile sales
participant commission data using OBIEE Answers/Dashboards.
Environment: OBIEE
11.1.1.6.5, 11.1.1.7.140225, BI Publisher 11g, Oracle 11g, Toad for DB2,
Tableau 8.2/9.0 windows server 2008 R2 Enterprise.
Probuild,
Denver, CO Feb 2011 – Sep 2012
OBIEE Developer
Responsibilities:
· Configured the OBIEE Analytics Web, Generated Reports and Dashboards using OBIEE Answers with many useful chart views like map view, Histograms etc.
· Ensured seamless communication and deliverables between onsite and offshore teams.
· Created mockups for the requirements and discussed with clients for improvement of reports.
· Created materialized views by joining few tables to make the life easy in the reporting perspective.
· Designed and developed the OBIEE/ Metadata Repository (.rpd) using Analytics Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
· Enhance performance by creating Aggregate tables and managing Cache using OBIEE Administration tool.
· Developed answers, interactive dashboards and involved in interactive sessions with clients to make them feasible, with the reports.
· Developed high-level ad-hoc reports for grain level analysis.
· Implemented various security levels and created various variables in both repository and in presentation levels
· Involved in deployments of repository and code migrations into different instances.
· Used Analytics Scheduler to configure Delivers and iBots to notify the corporate managers and region managers immediately about the messages. Generated iBot alerts for reports to be delivered by email.
· Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
·
Developed
custom logical columns and calculated measures using expression builder
·
Worked closely with Users, Developers and
Administrators to resolve ongoing Production Problems by reviewing design
changes made to production systems.
Environment: OBIEE 11g/10.1.3.4, Oracle BI Applications 7.9.6 (Financial
analytics),BI publisher, Informatica 8.6, DAC, Oracle 11g, Oracle EBS, SQL Developer, SQL*Plus, Windows-XP
RedCats
USA, Inc. NY, NY May 2010
– Jan 2011
OBIEE Developer
Responsibilities:
·
Designed and developed the OBIEE Metadata
Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions
and Facts) with integrity constraints into Physical Layer using connection
pool, developing multiple Dimensions (Drill-Down, Hierarchies) & Logical
& Facts / Measures objects in Business Model Layer, and creating the
Presentation catalogs in Presentation Layer.
Environment: OBIEE 10.1.3.2.1, Oracle10g, DB2, SQL Developer, Informatica 8.5.1, SQL*Plus, DAC, UNIX,
Windows-XP.
CNA
Insurance, Chicago, IL Nov 2009 – April 2010
OBIEE Developer
Responsibilities:
·
Work
extensively with Physical Layer, Business Layer and Presentation Layer to
customize the existing business models and also developed new models.
·
Developed
Reports, dashboards, metadata, security, calculation, caching, and intelligent
request generation services.
·
Involved in
designing the PL/SQL procedures for
getting the data from all systems to Data Warehousing system. The data was
standardized to store various Business Units information in tables.
·
Created
initialization blocks and variables for usage in reports.
·
Created
presentation catalogs for exposing both stored and calculated measures and
dimensions to users for adhoc reporting.
·
Checked
Global consistency of repository and resolved consistency issues.
·
Worked on security by creating groups and
implemented group level security. Set Query limits for user groups.
·
Used Multi user development environment for
check out and check in of Repository.
·
Performed
migration as well as back up of OBIEE repository and web catalog for different
environments.
·
Developed
dashboards and pages using dashboard prompts, page prompts and linking
capabilities.
·
Hiding
shared folders to prevent users from accessing dashboard reports, prompts and
filters. Created separate shared folders and permissions for users to share
adhoc reports with other users.
Environment: OBIEE 10.1.3.2, Informatica 7.1.3, Oracle EBS, Oracle 10g, SQL
Developer, SQL*Plus, LINUX, Windows-XP.
Shree
Jajoo instruments Manufacturing Corp, Mumbai, India Dec 2008 – Oct 2009
OBIEE Developer/SQL Developer
Responsibilities:
·
Designed Prototype of the project repository and developed
reports/dashboards to make it easier for business users to visualize how
reports will look like in Siebel Analytics.
·
Built
reports using Answers including drilldown objects, union based reports, formatting
and functions within the reports,
dashboards, filters, and prompts.
·
Implemented
Time Comparison and calculation measures in the business model using Time series wizard and modeled slowly
changing dimension data.
·
Performed
Repository Testing and validation before exposing Business Models in the
Presentation layer.
·
Created
proactive agents (iBots) and interactive dashboards to alert the sales rep
about the sales of the particular item.
·
Maintained
effectiveness in creating the dashboards by appropriately including drilldowns.
Setup the visibility of dashboards to employees with responsibilities.
·
Developed
Role-Based Dashboards for Managers and Business Heads to review the reports
according to the role.
·
Built
reports using Answers including drilldown objects, union based reports,
formatting and functions within the reports, dashboards, filters, and prompts.
·
Performed
Repository Testing and Validation before exposing Business Models in the
Presentation layer.
Environment: Siebel Analytics
7.7, Windows 2000, Informatica 6.2, Oracle 9.2.0.5