PRABHAV BHATJIWALE
acd2gd@r.postjobfree.com
PROFESSIONAL SUMMARY
• A certified SAP-BI specialist with 5 years of Information Technology experience, 3+ 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 implementations right from Requirements gathering to deploying SAP
BEx Reports.
• Excellent technical knowledge of “Backend” SAP BW Development balanced with substantial “Frontend” BEx Query
Designer/Analyzer.
• Good Knowledge in SAP HANA data modeling using Attribute View, Analytic View and Calculation View
• 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
1. LO-Cockpit data source enhancement and Extraction, Generic delta data source extraction.
2. Understanding Delta management of info package and DTP in SAP BI 7.0
3. Involved in the Initialization of Data Sources and running Full/Delta as well as repeat delta, Load as and
when required
• Reporting
• Developing BEx reports using formulas, selections, structures, calculated key figure, restricted
key figure, variables and RRI
• 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
• 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
• 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 and Spend Analytics functional side experiences using SAP ASAP Methodology coupled
with GAP Analysis to incorporate the latest technology 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.
• Multidimensional Data modeling, created InfoObjects, InfoProviders, DSOs, Write optimized DSOs,
Standard DSOs, InfoCubes and Multiproviders.
• ETL, Experience extracting and enhancing Data Sources using LO-Cockpit and Generic extractors with
view/table structures.
• Created field level Routines in transformations, InfoPackages and DTPs.
• Created Process chains to automate data loading and maximize data loading efficiency.
• 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
• Customized LO-Cockpit (LBWE) to transport data into DSO InfoObject, Using Extractors
Frontend SAP BW/BI:
• Experience 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 a
overall SAP BW/BI solution for manufacturing industry
Workplace/Soft Skills:
• 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.
• Ability to work well with others and collaborate to get project and tasks done.
• Strong business and technical analytical skills.
Ability to consistently meet project deliverable deadlines.
PROFESSIONAL EXPERIENCE
April 13 – Present 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: Spansion Inc.
Environment: SAP BW 7.3 ECC 6.0 and BI Portal, BO Suite 4.0
Senior Software Engineer
• Extensively working in Data Extraction from Multiple SAP and Non SAP
(Legacy) Systems using Business Content,LO,LIS, Flat File, Generic
Extraction Methods for legacy data
• Supporting prioritized sales cycles, helping with strategy, competitive
positioning, demonstrations and presentations
• Gathered necessary business project requirements and involved in the SAP
R/3 technical and SME’s for SAP MM with functional analysts in the business
areas
• Writing ABAP code for enhancing data sources, customizing field routines,
custom variables used in BEx Query Designer for improving end user
experience
• Performing Performance tuning Techniques (Aggregates,
Cube Compression, Line Item Dimension, and Indexing) for Improving
Reporting performance
• Designed, developed and documented the extended star schema model
for the custom Infocubes to upload Bookings, Billings, Backlogs,
Resale and Revenue Forecasting information.
• Installing Business Content Objects for aligning with SAP defined best
practices
• Responsible for upload of Master Data and Transactional Data form SAPR/3
source system and also Flat File upload into BW via InfoCubes and ODS.
• Scheduling and Monitoring daily and weekly process chains, Data loads
(Full /Delta Up-Load) for optimizing automation of BW modelling tasks
Jun 11 – Jul 12 TIMELINK INTERNATIONAL CORPORATION Purchase, NY, USA
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
Analyst
• Led an average team of 6 on SAP BI 7.0 implementation, preparing
documentation for client use and user training on all modules
• Involved from project scoping to ‘go-live’/support; successfully implemented
2 large scale projects for Harley Davidson & Michigan University (each worth
USD100,000)
• Scoped, documented & validated business process to improve on legacy system;
converted documents into blueprints creating navigational attributes
• Structured solutions to increase business performance at Harley Davidson by
13%; improved productivity measuring and reporting through Crystal Reports
• Installed business content objects as per blue print for Central Michigan University
• Created complex BEx queries to assist improved resource allocation by integrating
planning variables and forecasting of revenues
• Executed realization phase activating business content data flow and
maintaining 90% uptime as per SLA
• Created DSOs, InfoCubes and Multi- provider for queries.
• Created Info packages, DTPS transformation mappings.
• Received personal recommendation from Harley Davidson for contributions in
solution development and determining deliverables and producing excellent results
• Received recommendation from Senior Software Developer at Time Link
International Corp, on various complex projects for resolving client issues and
meeting deadlines
Aug 10 - May 11 RVM INCORPORATED New York City, NY, USA
Litigation Support Services
Description: RVM is a woman-owned business that provides
end-to-end legal technology consulting including Information
Governance, Forensics, Managed Review.
Client : Citibank Inc.
Environment: SAP BW 7.0; SAP BO 4.0; SAP ECC 6.0
Litigation Support Technical Analyst
• Led 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 analyzing
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,
Calculated Key figures
• Actively involved in creation of Process Chains, Meta Chains for upload of
Transaction Data and Master Data.
• Involved in creating Aggregates, Partitioning, Indexes, Roll-up and Compression to
improve the Query performance
July 2010- Aug 2010 WSG SYSTEMS New York City, NY, USA
CORPORATION
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.
Quality Assurance Analyst (Intern)
• 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
May 2009 – May 2010 Pace University: New York City, NY, USA
Seidenberg School of
CSIS
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.
Computer Lab Consultant
• Resolved Computer Software/Hardware Issues for students and professors in
Computer Lab
• Managed a Computer Lab, providing user technical support for 40 computers,
printers and scanners
Sep 2009 – Nov 2009 Graff Diamonds Inc. New York City, NY, USA
Luxury Goods
Manufacture
Description: Founded
in 1960 by Laurence
Graff OBE Graff
Diamonds continues to
push boundaries of
ever-greater excellence
and innovation in luxury
jewellery industry.
IT Support Technician (Intern)
• Performed scheduled server maintenance to ensure compliance with vendor
security patch bulletins
• Worked extensively on Active Directories and resolved problems concerning e-
mail and password
• Troubleshot Desktop applications and operating system for employees ensuring
company productivity
July 2009- Aug 2009 Safe Horizon Inc. New York City, NY, USA
Public service
Description : Safe
Horizon is the largest
victims’ services agency
in the United States,
touching the lives
of more than 250,000
children, adults, and
families affected by
crime and abuse
throughout New York
City each year
IT Helpdesk Support Technician (Intern)
• Performed Manual Desktop/PC Maintenance and imaged computer to ensure
stability and productivity
• Installed computers, printers, scanners and several other computer peripherals
on site for company upgrade
Sep 2008 – May 2009 Pace University: New York City, NY, USA
Seidenberg School of
CSIS
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 Analyzing SAP Crystal Reports, New York City-USA, May
2011
•
LEADERSHIP Selected among 700 students to be featured in Pace University Parent
ACTIVITIES AND Newsletter/Graduate Student Spotlight magazine
ACHIEVEMENTS • Granted Graduate/Research Assistantship and half tuition fee waiver for 2
semesters at Pace University
• Secured 2nd Place in All India Geo Map quiz
• Awarded International Graduate Scholarship for 2 consecutive years at Pace
University
• Volunteered at, One To World Organization “Cleaning Prospect Park in Brooklyn,
New York”
• Active Member, New York City Business Networking Group, New York City Quality
Assurance Professionals Group