Project Data

Mangesh Potdar

Data Visualization Specialist (OBIEE, Tableau)

Phone Number - +1-210-***-****

E-mail - *******.******@*****.***

LinkedIn - https://www.linkedin.com/in/mangeshpotdar Visa Status - H1-B (Valid till 2019)

EXPERIENCE SUMMARY

• Result Oriented IT professional with more than 15 years of progressive expertise in gathering reporting requirements, performing application design, development, testing and a comprehensive background in Oracle Business Intelligence (OBIEE) and related reporting components including Informatica PowerCenter and DAC

• Involved in working closely and efficiently with a variety of Business/Technical analysts and a variety of business users to meet their reporting objectives.

• Good Analytical exposure to create Reports using Answers, proficient in building analytical repository, presentation layer and business models.

• Extensive experience in providing end-to-end business intelligence solution by performing dimensional modeling design, configuring metadata, creating/scheduling Delivers / Ibots, creating reports / Dashboards, managing cache and building OBIEE Repository using analytics Admin tool.

• Experience in implementing security in OBIEE using Repository Variables, Initialization Blocks, and Session Variables.

• Experienced in working with DAC (Data warehouse Application Console) design and development including customization of execution plans, subject areas, tables and tables groups.

• Implemented data level security and object level security in OBIEE

• Experience in configuring interactive dashboards with drill-down capabilities.

• Worked on creating users and groups to configure object level security.

• Worked on custom java coding to enable ibots to create and transmit files to a mailbox periodically.

• Experience in creating new subject areas and target levels as per business needs in marketing analytics module.

• Created marketing campaigns, assigned programs, created load and list export jobs to schedule these marketing campaigns.

• Hands on experience working on data visualization tools like Tableau, PowerBI and Microstrategy

• Worked on a POC for using PowerBI and Microstrategy as an alternative data visualization tool for reports that included forecast calculations.

• Strong analytical and problem solving skills.

• Self-motivated and able to learn quickly.

Tableau 10.2

• Worked with Business users to understand the user requirements, layout, and look and feel of the reporting application to be developed.

• Generated interactive dashboards using Tableau.

• Created adhoc reports in Tableau by connecting to various data sources.

• Handled Tableau admin activities like granting access, managing extracts and Installations.

• Generated Dashboards with Quick filters, Parameters to handle views more efficiently.

• Published Workbooks by creating user filters so that only appropriate teams can view it.

• Analyzed the source data and handled it efficiently by modifying the data types.

• Used excel sheet, flat files, CSV files to generate Tableau adhoc reports.

• Generated context filters and used performance actions while handling huge volume of data.

• Generated tableau dashboards for sales with forecast and reference lines. CERTIFICATIONS/AWARDS

• Siebel 7.7 Certified Siebel Analytics Server Architect TECHNICAL SKILLS

• OBIEE 12c (12.2.1.0.0)

• OBIEE 10.1.3.4.2 and 11.1.1.9, Siebel Analytics Versions 7.7, 7.8.2,7.8.4

• Tableau 10.2, PowerBI

• Informatica 6.8.2, 7.1.4,9.1

• DAC

• Unix Shell Scripting, PL/SQL

Operating Systems and Databases

• Unix, Linux, Windows 2000,2003,2008 Server

• Oracle 9i,10g

• Db2 v9.5 and 9.7

• Microsoft SQL Server 2008 R2

• Sybase

EDUCATION

• Bachelor of Technology in Electrical Engineering from R.E.C. Kurukshetra, India.

(Graduated in 2001)

TECHNICAL AND PROFESSIONAL EXPERIENCE

Following ‘tree map’ shows my hands-on work experience in different technologies used so far. Key Technologies are as below

OBIEE/Siebel Analytics – 12 Years

Informatica and DAC – 11 years

PL/SQL and data warehousing – 7 & 8 years respectively

Unix 2 years

Data visualization tools like Tableau and PowerBI – 3 years Following ‘Horizontal Line bars’ shows my employment history starting from 2001. Major employers so far were

Tata Consultancy Services Ltd. (2001 to 2007)

Harland Clarke Corp (2008 to 2012)

Royal Bank of Scotland (2013 to 2016)

Magniris IT (current)

Following ‘packed bubble’ graph shows my employment history with regards to actual end client by month.

Contact this candidate