BI Consultant

VIHARI PAWAR

*** ******* **. • Bridgeport, CT ***04 • 972-***-**** • ******.*****@*****.*** • in.linkedin.com/in/viharipawar

SUMMARY

Reporting and data specialist with over 5 years of experience in leveraging data from various data sources, manipulating data, building models, developing dashboards and reports to generate insights. Worked closely with client to meet the needs and provided recommendations.

EDUCATION

University of Bridgeport, Bridgeport, CT Aug 2015 - Dec 2016

Masters of Science in Computer Science

Jawaharlal Nehru Technological University, India

Bachelor of Technology – Computer Science Engineering Sept 2007 - May 2012

CERTIFICATIONS

•Cisco Certified Network Associate – Routing & Switching

SKILLS

Specialties: Business Modeling, Web Analysis, Data Mining, Smart View Reporting, Hyperion Financial Reporting, Shared Services

Programming and Tools: SQL, Oracle 11g, SSIS, SSRS, SSMS, OBIEE, Tableau (Desktop & Server), Hyperion Essbase, Hyperion Planning, HFM, DRM, Oracle Middleware, OEM, ETL-ODI, TOAD, MS Office

EXPERIENCE

Infinity Pharmaceuticals

BI Consultant Dec 2013 - Present

•Served as Subject Matter Expert on OBIEE, Hyperion Essbase, Hyperion Planning and Oracle Database 11g

•Proven experience in administration, development, installation, configurations, upgrades and support for OBIEE, Tableau, Hyperion products and Data Warehouse

•Responsible for installation and upgradation of Hyperion products from 11.1.2.2 to 11.1.2.3 and patch upgrade from 11.1.2.3 to 11.1.2.4

•Gather information from various department to build metadata and inject data into multi-dimensional database in Hyperion Essbase and generate reports for stakeholders

•Migration of objects between environments using LCM in Hyperion planning application and monitoring Essbase Administrative Services Console and Essbase Studio Console

•Developed BSO & ASO applications, Rule files, Calculation scripts, MaxL scripts to build metadata and load data

•Implemented Ad hoc analysis to support strategy discussions, decisions and good experience in Essbase Excel Spreadsheet Add-in and Hyperion reports

•Developed many dashboards, reports and provide security and manage privileges on OBIEE Analytics; Involved in installation of OBIEE 11.1.1.6 and upgrade from 11.1.1.6 to 11.1.1.7

•Implemented code migration and repository deployment on Oracle BI from one environment to other and manage catalog on analytics; Extensively used BI Admin tool for customizing and modifying all the layers of repository

•Extensively used Catalog manager for Ad hoc analysis and report them for SOX Audits

•Performed performance tuning and troubleshooting on Oracle and SQL Server databases and optimize time for the generation of reports

•Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters)

•Creating solution driven dashboards by developing different chart types including heat maps, geo maps, scatter plots etc., using Tableau desktop

•Created interactive dashboards in Tableau Desktop and published them to Tableau server which allowed story telling with quick filters to retrieve on demand information with just click of a button

•Experience in trouble shooting and performance tuning of reports and resolving issues within tableau server and reports

•Hands on experience in developing reports using SSRS, HFR and web analysis using grid views

•Performed upgrades on Oracle 11g databases from 11.x to 11.x using patch set and upgraded Oracle Database from 11g to 12c

•Extensive experience in the creation of databases, table spaces, tables, indexes and other database objects and provide database administration on production, testing and development database servers

•Administer database user accounts by Creating, modifying and deactivating user accounts; assign and monitor user access rights

•Monitoring Tablespaces and Data files utilization. Managing Schema Objects, Undo Tablespaces, Redo Logs, Control files and Archive logs; Extensively used DATAPUMP and Export /Import utilities for logical backups

•Configure and implement the use of Oracle Recovery Manager (RMAN) for cold and hot backup to the databases; Performing physical, incremental backups and database cloning and duplication using RMAN

Electronic Corporation of India Ltd. (A Govt. of India Enterprise)

Internship Aug 2012 – Aug 2013

E.C.I.L. is a govt. based company which was setup as a department of Atomic Energy. The company played a significant role in training and growth of technical and managerial manpower in field of Computer and Information technology. It has extended its hand into various departments which has changed the scope in India.

•Worked as application developer and server maintenance for customer support division using SQL Server 2008R2

•Developed various reports based on internal company P/L statements for customer support division using SSRS

•Developed and executed plan scenarios in transforming unstructured data from various sources using SSIS like conditional split, Lookup, Merge, Join and Sort

•Involved in development and maintenance of ticketing system with web technologies such as HTML and CSS

•Involved in maintenance and repair of hardware equipment’s which come as defective products from power plants located in India

ACADEMIC PROJECTS Bridgeport, CT (2015 - 2016)

•Characteristics Victims of Identity Theft – Analyze large data sets and generate reports using data mining tools named WEKA and R where we can determine the factors and cause. We can also extract and generate reports with the specific inputs based on the region we define.

•Hospital Database Management System – Developed code in UNIX and generated reports using data files which are based on database rules. This Management System has various options where we can extract data with various factors such as number of patients, hospitals, inventory of hospitals, number of free beds etc.

•Olympic Database System – Developed database on Microsoft SQL Server 2008R2 and used C# as front end. Developed various pages to display data and manipulate data directly onto SQL Server. This project agenda was to display information regarding all the activities and events that take place over Olympic games.

•Shopping Cart – This project is based on ASP.Net Web API. The main aim of the project is to build http services using web API framework and display the details of products which are selected.

Contact this candidate