PRABHAV BHATJIWALE

** *** **** **** ********* No.1, Westwood, NJ - 07675 USA

acpn13@r.postjobfree.com Cell-908-***-**** LinkedIn :

www.linkedin.com/in/prabhavbhatjiwale/

PROFESSIONAL SUMMARY

A certified SAP-BI professional having, 6 years of Information

Technology experience and around 4 years of experience in SAP data

modelling, extraction, reporting, business analysis and performance

tuning while managing wall-to-wall projects

Led team on implementation, user training and support; interacting

with client to gainfully resolve arising issues. Proactively involved

in 3 full lifecycles of BI/BW and Finance implementations right from

Requirements gathering to deploying SAP Web Intelligence Reports and

Xcelsius Dashboards

Excellent technical knowledge of "Backend" SAP BW Development balanced

with substantial "Frontend" BEx Query Designer/Business Objects 4.0

Xcelsius Dashboards and Web-Intelligence Reports

A team player with proven ability to influence and foster

collaborative relationships to push projects across the finish line.

Consistently maintain highest standards of personal and professional

performance with integrity

TECHNICAL SKILLS

SAP BW/BI Skills

Data Modeling

Creation of InfoCubes, DSO, Multi-providers, Info Set, Info sources,

Info Packages, DTP, Info object Catalogs, Info Objects, Navigational

attributes, Transfer rules, Update rules, Transformation, Data Marts,

writing ABAP code for custom variables in BEx Query Designer

Extraction

LO-Cockpit data source enhancement and Extraction, Generic delta data

source extraction.

Understanding Delta management of info package and DTP in SAP BI 7.0

Involved in the Initialization of Data Sources and running Full/Delta

as well as repeat delta, Load as and when required

Integrated Planning

Design of planning area, planning level, Aggregation level, filters,

planning function of type function exit, FOX formula, repost, copy,

delete, variables of different types

SAP PMO Skills

Work collaboratively with the steering committee, project leadership

and the PMO to ensure that project is well on

track, risk are mitigated in a timely manner and high quality

deliverables are produced to deliver a top quality SAP system

Advise steering committee to re-prioritize functionality and manage

project scope to meet milestones and budget constraints

Analyze all change request and provide alternatives to avoid or

address change requests in a cost effective manner

Computer Software: Certified SAP Crystal Reports 2008, MS Office Suite

2000-20013, MS SQL Server 2005/2008, Microsoft Visual Studio

2003/2005, Symantec Backup Executive Client, Norton Ghost,

MS-Access-2010, MS-Project 2010, Ipreo, J-Meter, JIRA, Firebug,

IMacros, QlikView

Database Software Skills: Oracle9i, Oracle10g, MySQL, MS-SQL Server

2005/2008, MS-Access, Relational Database Management Systems

Computer Platforms Familiar with: Windows Server 2003/2008 R2, Active

Directories, Microsoft Exchange Server, Citrix Server, LDAP

SAP BW/BI Deliverables:

Backend SAP BW/BI:

Leveraged ASAP methodology as roadmap to successful SAP BW/BI

implementation.

Strong Purchasing, Spend Analytics, Inventory Management functional

side experiences using SAP ASAP Methodology coupled with GAP Analysis

to develop business solutions that increase customer efficiency,

productivity and profitability.

Worked closely with the user community to create Technical and

Functional Specification documents which have addressed and enhanced

Clients business strategies.

Loaded, enhanced and activated Standard BI Content to maximize Client

ROI.

ETL, Experience extracting and enhancing Data Sources using LO-Cockpit

and Generic extractors with view/table structures.

Ensuring SOX compliance in Transport management STMS; Collections,

Groupings and Transport sequence.

Performance tuning with Compression, Aggregation, Partitioning, Load

Master Data first

BW operations: Data load management, ETL, experience in scheduling

Process Chains and Loading (Full Init / Delta Up-Load), Monitoring,

Data Mart, BW Transports

Frontend Reporting SAP BW/BI:

Experience in designing BW Queries and Modeling Data for Business

Objects reporting.

Worked with SAP BO team to create a Spend Analytics Supplier Score

card as Client KPI, along with Maverick Spend and Contract Compliance

Dashboard using SAP Dashboards 4.0 as part of designing an overall SAP

BW/BI solution for manufacturing industry

Developing BEx reports using formulas, selections, structures,

calculated key figure, restricted key figure, variables and RRI

SAP HANA/ Lumira Skills :

Good Knowledge in SAP HANA data modeling using Attribute View,

Analytic View and Calculation View

Hands on experience in HANA modelling, SQLScript. Created multiple

schemas and table definitions

Experienced in loading data from tables in HANA Database to BW data

marts

Designed SAP Lumira Visualizations using GeoMaps, Data Mashups and

HTML5 for mobile devices

Workplace/Soft Skills:

Passion for innovative, leading-edge technologies and their customer

adoption

Ability to work in a fast-paced, dynamic business environment.

Ability to provide timely response, updates and technical resolution

to ensure client Satisfaction is maintained at all times

Ability to work independently as well as in a team environment

PROFESSIONAL EXPERIENCE

Apr 13 - Present WESTWOOD,

Systems Analyst NJ,USA

ACTIVECUBES (A Blue Star Infotech

Group Company)

Business Analytics Solutions

Description : Founded in 2008, Activecubes is a

global firm providing Analytics Services with

associated Technology Solutions

Client: Cognizant Technology Solutions Inc. /

Pearson Education

Environment: SAP BW 3.5, 7.0, ECC 6.0 and BI Portal,

BO Suite 4.0,OBIEE 11g

Aug 14 - Present

ACCOMPLISHMENTS :

Accessing and integrating SAP FI / Purchasing Data

from different SAP Systems across locations, into 1

single SAP BI 7.0 system resulting in 6% lower than

planned actual cost variance

Designing insightful reports to collaborate order

acknowledgements using OBIEE and SAP BO 4.0

resulting in reduction of procurement costs by 43%

Scheduling and Monitoring daily, weekly and monthly

process chains, Data loads (Full /Delta Up-Load) for

optimizing automation of BW modeling tasks resulting

in 48% lower PO error rate for procurement of paper

and photos

Designing Contract compliance reports to save a

minimum of $50,000 annually in lawsuits for Pearson

Inc. thus providing business insights at all levels

of the organization

Client: Spansion Inc.

Environment: SAP BW 7.0 ECC 6.0 and BI Portal, BO

Suite 4.0

Apr 13 - Jul 14

ACCOMPLISHMENTS:

TCO was significantly reduced by 11% for each year

by extracting data from Multiple SAP and Non SAP

(Legacy) Systems and delivering actionable reports

Reduced Maverick Spend by 35% by deploying SAP

Procure to Pay solution

Increased Net Pay Terms by 60+ days to enable better

cash flow

Increased productivity by 30 percent using SAP

Accounts Payable Automation and reduced cost per

invoice by up to 60 percent

Designed, developed and documented the extended star

schema model for the custom InfoCubes to upload

Bookings, Billings, Backlogs and Revenue Forecasting

information

June 11 - July 12 Purchase,

Analyst NY, USA

TIMELINK INTERNATIONAL CORPORATION

Time and Attendance Solutions

Description: With over 25 years of experience,

TimeLink is a recognized leader in

providing enterprise workforce management (EWM) and

data collection solutions to organizations across a

broad range of industries.

Client : Harley Davidson and Central Michigan

University

Environment: SAP BW 7.0; SAP BO 4.0; SAP ECC 6.0,

SAP HANA 1.0.17

ACCOMPLISHMENTS :

Led an average team of 6 on SAP BI 7.0

implementation, prepared documentation for client use

and trained users on all modules

Involved from project scoping to 'go-live'/support;

successfully implemented 2 large scale projects for

Harley Davidson & Michigan University (combined worth

USD100,000)

Structured SAP HANA solutions, modeling scenarios,

created schemas and content models, views, attributes

and measures, hierarchies and increased business

performance at Harley Davidson by 13%

Created SAP Lumira version 1.23 Dashboards using Data

Mashups, GeoMaps and HTML5 interface to maximize

business knowledge with real-time insights and

granular-level details

Envisioned and guided on-site fulltime SAP PMO to

build project plans, business transformation proposal

and seek approval of project budget

Executed realization phase and activated business

content data flow to maintain 90% uptime as per SLA

Aug 10 - May 11 Litigation Support Technical New York

Analyst City,

RVM INCORPORATED NY, USA

Litigation Support Services

Description: RVM is a woman-owned

business that provides end-to-end

legal technology consulting

including Information Governance,

Forensics, and Managed Review.

Client: Citibank Inc.

Environment: SAP BW 7.0; SAP BO

4.0; SAP ECC 6.0

ACCOMPLISHMENTS:

Worked in a team of 7 on SAP BI implementation for

Citibank; supported after 'go-live' project and

managed corrective actions on 94% of the cases

within the TAT

Designed queries, MultiProviders, InfoSets, took

corrective action by analysing reasons for failures

and enhanced models according to changing needs of

end users

Handled a crisis independently on the project

yielding USD 190,000 profit for the company and

increased the project scope giving additional

billing of USD 60,000

Involved in front-end BI Components of BEx Queries,

Formulae, Variables Involved in creating Aggregates,

Partitioning, Indexes, Roll-up and Compression to

improve the Query performance

July 2010- Aug Quality Assurance Analyst (Intern) New York City,

2010 WSG SYSTEMS CORPORATION NY, USA

ERP Software

Description: WSG has been in

business since 1984 and our entire

business is focused on the

development of timesheet and expense

management software.

Analyzed and documented areas for software

improvement to strengthen quality

Audited software standards for specified

functionality

Inspected test requirements, planning/running tests

to boost quality and productivity of company software

Sep 2008 - May Pace University: Seidenberg School of CSIS k City, NY, USA

2009 Education

Description: Since 1906, Pace University has produced

thinking professionals by providing high-quality

education for the professions with a firm base in

liberal learning amid the advantages of the New York

Metropolitan Area.

Graduate Research Assistant

Performed data collection,

organization and observation on

"Reality Mining"

Researched Fortune 500 companies to

aid Professor in writing book on

"Service Oriented Architecture"

EDUCATION

2010 PACE UNIVERSITY New York City,

NY, USA

Masters in Science (Information Systems) 3.44 (CGPA)

Granted research assistantship and half tuition fee

waiver for 2 semesters as also

International Graduate Scholarship for 2 consecutive

years

2007 K.D.K. COLLEGE OF ENGINEERING Nagpur,

Maharashtra,

INDIA

Bachelors in Electronics Engineering

CERTIFICATIONS SAP BI Net weaver 7.0 with 94%, (SAP participant ID:

001-***-****), Bangalore - INDIA, December 2012

Certified in Designing and Analysing SAP Crystal

Reports, New York City-USA, May 2011

Contact this candidate