Oracle BI, Tableau, Birst, Pandas, Python

Professional Summary

More than ** years of IT experience working in Business Intelligence and Data Warehousing domains

Experience working with major business intelligence tools like Tableau, Birst, Oracle BI (OBIEE), Power BI, Oracle Data Integrator and Informatica.

Experience integrating BI tools with multiple data sources systems like Oracle, SAP, Salesforce, Service Now

Created Incident Free dashboard in Tableau that helped Engineering executive team to monitor Incidents created every day which Uptime %

Created a CIO Dashboard that provided CIO of the company a summary view of key metrics across different data points like Budget & Forecast, Spending, Projects, Incident management and Systems availability

Experience handling Data needs of multiple business orgs of Sales Ops, Marketing, Finance, Accounting, Customer Support, IT & Engineering

Experience with Python/Pandas for data collection, data analysis and data visualizations

Experience working with executive teams to understand their needs and providing data visualizations in the form of Dashboards with KPI’s, trend analysis etc

Provided multiple hands on group training sessions to introduce new users to BI and encourage users to use BI platform for their day to day data needs

Worked as Admin for Oracle BI (OBIEE) 10g, 11g and 12c for day to day report/object migrations and setup of High Availability multi node cluster environment and performing patch upgrades

Education: Master of Science in Electrical Engineering, 2009

Certifications:

Data Visualization with Python (Link)

Professional Experience

Wipro

Lead Consultant January 2020 – Present

Responsibilities

Participate in gathering and analyzing the Business Reporting Requirements from Business Users and transforming to technical requirements.

Understand data needs and provide data visualizations in the form of Reports and Dashboards

Work with other technical teams in incorporating BI reports with ongoing companywide Projects

Building data model using ETL and presenting data attributes in way for the users to be self-sufficient in creating reports

Understand data needs and provide data visualizations in the form of Reports and Dashboards

Work with other technical teams in incorporating BI reports with ongoing companywide Projects

Developed and designed interactive Tableau Dashboard reports and helped Users to create Adhoc reports

Working with new reporting interface Birst to create data model in Admin and reports in Designer and Visualizer

Environment: Tableau, Birst, PL/SQL Developer, Oracle SQL, SQL * Loader, Python, Amazon AWS.

TiVo Inc May 2011 – Present

Lead BI Engineer

TiVo Inc. is a global leader in next-generation television services. With global headquarters in San Jose, CA and offices in New York, NY, Durham, NC, and Warsaw, Poland, TiVo's innovative cloud-based Software-as-a-Service solutions enable viewers to consume content across multiple screens in and out-of-the home. (Source: Tivo.com)

Achievements:

Created Incident Free dashboard that helped Engineering executive team to monitor Incidents created every day which Uptime %

Created a CIO Dashboard that provided CIO with summary view of key metrics across different data points like Budget & Forecast, Spending, Projects, Incident Management

Consolidated data in one place by creating multiple data pipelines from different small/big data sources like SAP, Oracle, Service Now, Salesforce, Jira by utilizing multiple data extraction techniques using Python, Rest API, file system, Microsoft Flow etc

Dashboards I created are displayed on TV’s in Engineering and IT team spaces

Improved number of concurrent users using BI tools by 100% and help users create their own reports by providing hands-on training sessions

Successfully implemented project of BI tool migration from Hyperion IR to Oracle BI in 2013 where 100+ reports are migrated

Responsibilities:

Participate in gathering and analyzing the Business Reporting Requirements from Business Users and transforming to technical requirements.

Work with data source teams to build data pipelines

Building data model using ETL and presenting data attributes in way for the users to be self-sufficient in creating reports

Understand data needs and provide data visualizations in the form of Reports and Dashboards

Work with other technical teams in incorporating BI reports with ongoing companywide Projects

Maintained Object Level and Data level Security for data and reports in line with SOX audit systems

Developed and designed interactive Tableau Dashboard reports and helped Users to create Adhoc reports

Working with new reporting interface Birst to create data model in Admin and reports in Designer and Visualizer

Performed successful OBIEE upgrade from 10g to 11g and then to 12c with SSL setup

Environment: Oracle 10g/11g, OBIEE 10.1.3.4.1/11.1.1.6.0/12c, Oracle Data Integrator, Hyperion IR, Tableau, Birst, PL/SQL Developer, Oracle SQL, SQL * Loader, Python, Amazon AWS.

Newedge Inc., Chicago, IL Sep 2010 – May 2011

OBIEE Developer

Description

Newedge offers global, multi-asset brokerage services on a range of listed and OTC derivatives and securities. My involvement in this project includes working on development of financial reports, RPD modifications and security implementation.

Responsibilities:

Collecting Financial Design documents and understanding the business requirements.

Performing necessary Rpd file modifications to the metadata and testing the same on local machine before moving to the server.

Building reports in financial template with subtotals at each Level using Pivot view in Answers understanding the financial data.

Created Dimensional hierarchy in RPD for Users to drill down at Report level.

Created Time Series Functions such as Month Ago, Year Ago and To Date measures for balances.

Creating Level Based Measures, Aggregated tables and adding multiple logical sources to the table understanding the granularity, performing calculations on the duplicated columns wherever needed in Business Model and Mapping layer.

Configured Repository, session, presentation and request variables based on the business requirement.

Configured Security (Data Level and Object Level) using Administration tool at the Group level.

Configured OBIEE-EBS integration, authenticating and authorizing a user with sso to OBIEE Answers/Dashboards from EBS environment.

Worked in migration of Rpd file and webcat in the linux environment.

Involved in raising an SR wherever necessary for application of necessary patches and opening of ports for OBIEE environment.

Performed Performance Tuning of Dashboards / Reports by aggregate navigation, Cache Management using Event Polling Tables and making necessary changes to reports.

Involved in running of concurrent programs in EBS for loading of grouping files and refreshing MV’s.

Working at database level running necessary scripts for views and materialized views used in reports.

Environment: Oracle 10g, OBIEE 10.1.3.4.1, EBS R12, PL/SQL Developer, Oracle SQL, SQL * Loader.

AccessMED, Kansas City, MO June 2010 – Sep 2010

OBIEE Developer

Description

AccessMED provides patient assistance programs and consulting services to the Pharmaceutical and biotechnology companies. In this project I was involved in production support for the Dashboards and reports and modifications at RPD level.

Responsibilities:

Participated in gathering and analyzing the Business Requirements in collaboration with the Business Analysts and Users.

Created metadata and Imported tables from database and created their Aliases and created foreign key joins between Aliases in the Physical Layer.

Involved in implementing Security with respect to Subject areas at RPD level.

Created Dimensional hierarchy in RPD for Users to drill down at Report level.

Created Time Series Functions such as Month Ago, Year Ago measures for comparison of Sales and To Date function.

Involved in working Out of the Box OBIEE (OBIA) prebuilt reports.

Involved in developing the Incremental ETL process (Mappings & Mapplets) using various Transformations Lookup, Source Qualifier, Expression, Update Strategy, Joiner transformations to build mappings and Workflows with Sessions / Tasks.

Extensively used DAC, to configure, monitor and schedule ETL routines.

Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & Tasks and scheduling using both Workflow Manager.

Involved in creating and adding data in to the tables in Data warehouse and developing stored procedures to populate necessary data in to the tables.

Environment: Oracle 10g, Informatica 8.6.1, OBIEE 10.1.3.3, Oracle BI Applications 7.9.5.1, DAC, PL/SQL Developer, Oracle SQL, SQL * Loader.

Bhrigus, Raritan, NJ January 2010 - May 2010

Programmer Analyst

Responsibilities

Involved in the Analysis, Design and Development of the Policies & Claims maintenance data warehouse.

Involved in analyzing user/business requirements and mapping them into technical specifications.

Involved in Design and Development of Stored Procedures, Packages, Cursors, Triggers and Functions using SQL and PL/SQL scripts and performed PL/SQL tuning.

Environment: Oracle9i, SQL, PL/SQL, SQL*Loader

Contact this candidate