Data Sap
Resume:
Dave Prateek SAP BW/BI Consultant
812-***-**** ********@*****.***,
Professional Summary
. Five (5+) years of expertise in SAP with over 4 years in SAP BW (2+ years in BI
7.0).
. Two (2) complete life-cycle implementation in SAP BW in all phases like Gap
Analysis, Blue-printing, design specification, development, performance tuning,
testing, documentation, maintenance, training, Security authorizations and
trouble-shooting.
. Excellent working Knowledge in BI 7.0 (Netweaver 2004s).
. BW Upgrade experience of Migrating Frontend solution such as Queries, Workbooks &
Web reports, Unit of Measure migration with BI 7.0, successful implementation and
Delivery.
. Excellent work ethics, Go-getter, Self-starter, Team player, Adaptable, Innovative
with strong System Analysis, Design and Development skills, Good presentation and
technical writing skills.
. Modeling - Excellent working knowledge of datawarehouse concepts. Extensive
experience in BW Architecture, Extended Star-Schema, Multi Dimensional Modeling, Data
Flow Strategy, Defining Dimensions, InfoCube, Multi-Provider, InfoSets, DataSource,
InfoSource, InfoObjects, PSA, DSO etc.,
. Extractions - Extracted data from LO Logistics Cockpit, CO-PA and Generic
DataSources from Views Function Modules, DB Connect and Flat Files.
. Customizations - Experience in activating standard Business Content, extending and
enhancing InfoCubes according to the requirements, Datasource Enhancements, User Exit
Variables, Virtual KeyFigures, Start Routines and Formula Builder.
. Reporting - Expertise in front-end Business Warehouse components for Queries,
workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables,
Exceptions, Conditions, R/RI, Visual Composer, Ad-hoc Queries, BEx Analyzer, Web
application designer(WAD), Web Items.
. Performance Tuning - Evaluated statistical performance and optimization using Bi
Statistics and BI Administration Cockpit. Improved data load and query performance by
doing Compression, creating Aggregates, Indexes, Data packet size.
. Production Support - Extensive experience in support, Data loads, Validation and
trouble shooting of transaction data and Master data, Change management, Transport
Management, Roles & Security, System Checks, Performance tuning and Process chains.
. Training - Extensively involved in End User training as well as Developer Training.
Created Technical Documentation, Training Manuals etc.
DATE: Mar 2009- Current
CLIENT: SONY BMG Music Entertainment
Lyndhurst, NJ
POSITION: SAP BI Technical Consultant(BW Upgrade Project)
Technical Env. SAP BI7, SAP BW3.5, ECC 5 Modules: SD, MM, FI,
ABAP,CRM
RESPONSIBILITIES: BW Migration Project
. Worked on BW Upgrade project performed Functional and Technical upgrade
of BW 3.5 to BI 7 EHP1.
. Performed BW Technical upgrade which includes Validate ABAP Dictionary,
Check Infoobjects inconsistency & System Codepage Settings, Check F
Partitions, create Primary & Secondary indexes and lot more.
. Fix Security issues with interval *, work on ASU system, setup Portal &
Java instance, turn off RFC Connections, activate & replicate Source
systems, Datasources, Migrate Authorizations. Convert Chart settings, Web
objects, activate Hierarchy versions, adjust Customer developments &
customizing settings, Run SGEN, activate all views, regenerating RSDRO*
objects etc.,
. Fix all Upgrade related issues, apply SAP Notes, Testing.
ANALYSIS : Extensive testing of Frontend tools such as BW Queries,
Workbooks, Workbooks with VB Coding, Unit of Measure, RRI, Workbooks with
Single or multiple embedded queries, drop down box, embedded graphs etc.,
STRATEGIES: Discussed Strategies of rolling out Netweaver 2004s
Tools to update all users desktop, new Authorizations and Security for all
Front end tools for End user, super users, power users, Timeline for
upgrading all front end tools such as queries, workbooks etc.
USER TRAINING : Provided Training for Super Users and Power users about
How to Upgrade Queries and Workbooks, new BI 7.0 Tools such as 2004s Query
Designer, BeX Analyzer, Web Reports, How To create Queries and Workbooks.
. Provided after-sessions to resolve doubts and Questions from Users with
new 2004s front end tools and provided solution whenever possible.
Documentation: Created lots of documentation e.g. How To's & Quick
Reference Cards
. Maintaining Info-spokes for Digital Data for different systems,
maintained process chains and resolved errors and Dumps, enhanced it by
adding Process type that will Rollup Aggregates, send Emails upon
Success/Failure.
. Created a Infospoke to reverse specific set of Data into BW utilizing
files, reloaded the data with custom percentage distribution, wrote ABAP
routines, involved in Data reconciliation process, Utilized Standard
reports to compare C-Code access to users on SAP & BI system.
. Maintained SD Cubes- Sales Billing US, UK, Ireland, Canada and FI Cubes-
P&L, GL Detail & Balance & Expenditure Analysis (enhanced performance of
Custom Digital Data such as GRS, SAMIS and EROS).
. Maintained data loading using Standard extractors for FI,SD and custom
extractors like GL Plan Data, Reversal entries, RAAS master data, Material
data etc.,
BW Support: Maintenance of Process chains, Monitoring Nightly and
weekly loads, fixing errors, Dumps etc.,
Development for Loading & dumping historical Digital Sales data for GRS &
EROS systems from external Source systems into BW.
Responsible for configuring DTP's, data sources, DSO's and Info package
utilizing Flat file loads.
Creating Balance-sheet Queries for Trend, Monthly, Yearly & Quarterly
comparison.
DATE: Mar 2008- Feb 2009
CLIENT: Kimberly Clark, Inc. Appleton, WI
POSITION: SAP BI Architect
Technical Env. SAP BI7, SAP R/3 4.7, BW 3.5 Modules: SD, FI, ABAP,
CRM
RESPONSIBILITIES:
Phase I - Order to Cash Project
. Key role as a Functional analyst for Transportation module as a part of
Order to Cash System, which involves preparation of FRICES, strategies of
BI Objects developments, integration of Transportation Multiprovider with
other modules (full life cycle implementation.)
. Designed the data model to integrate data from two different source
systems - SAP and I2. I2 data is loaded via flat files into BI system and
is integrated with R/3 data that is loaded through standard and customized
SAP Extractors.
. Responsible for Creating, Modifying and Activating business content
extractors, Info Objects, Info Cubes, Multi Providers and DSOs (data
stores) according to the reporting requirements.
. Customized LO Cockpit extract structures and data sources (extending
extractors) in SD and MM, Developed custom Infocubes, DSOs and
Multiproviders for SD & MM.
. Created Data Transfer Process (DTP) to schedule the update in BI 7.0,
extensively worked on DTP functionalities like enhanced filtering, DTP
monitoring, DTP debugging, temporary data storage and Error DTP stack.
. Performed Unit Testing, Integration Testing and Regression Testing,
Extensively worked on performance tuning aspects with Aggregates,
Partitioning, Compression and BI Statistics.
. Worked on Information Broadcasting to send reports to end users by
e-mail.
. Developed TMS Reports such as Shipment and Volume Reporting, Vendor
Mileage Summary, Prerate and Actual Freight Comparison, Non Operational
Freight Analysis, Freight Payment Reporting and Customer Mileage Summary.
TMS Reports were developed for 2 main modules within, Inbound
Transportation for Raw Materials from Vendors and Outbound Transportation
for Finished products to Customers and other KC Facilities.
Phase II BI User Migration/ Upgrade Project :
. Analysis for potential migration of all BW 3.5 Queries & Workbooks to BI
2004s.
. Discussed Strategies of rolling out Netweaver 2004s Tools across
multiple landscapes.
. Strategies for different level of security, User Access, different
landscapes, Testing phase etc., for Migration Project.
. Deliverables and documentation for BI Reporting Workshops for End Users.
Etc.,
DATE: Sep 2007- Feb 2008
CLIENT: Michael Foods, Inc. Minnetonka, MN
POSITION: SAP BI Backend Consultant
Technical Env. SAP BI7, ECC 6.0 Modules: SD, MM, FI,
SCM, ABAP,HR,BPC, CRM
RESPONSIBILITIES:
. Designed, developed and modified Info Objects, Info Cubes, ODS Objects,
Info Sources, Transfer rules, Update rules to suit the business
requirements, populated it with Master data and Transactional data from SAP
R/3 via Data Staging area (PSA) using Info-Packages.
. Analyzed and Enhanced LIS and LO Cockpit extract structures and data
sources in SD, IM and MM to facilitate the data extraction,extended the
extract structures by adding new fields and populating them with the
user/function exits, Responsible for handling data loads for Historic data
and implemented process chains for handling weekly deltas.
. Carried out data conversions for Customer Master and Material Master in
LSMW workbench. Created reusable conversion rules and routines, modified
several existing SAP script layout sets like plant order, notifications and
service orders. Created and maintained CO-PA datasources. Created report
for Profitability Analysis (CO-PA) based on the fiscal year. Used Delta
Update process for loading the data to BW from R/3 in specific intervals.
. Responsible for handling data loads related to Purchasing Groups
(0PUR_C04), Purchasing Data (0PUR_C01), Purchase Order Items (0PUR_O01),
Purchase Orders (0PUR_O02) using LO extraction cockpit.
. Installed the Bi Administration Cockpit and Bi statistics and
successfully tested around 40 Bi content queries for Bi Statistics, created
Custom Queries for Bi statistics for Business purposes as per requirements.
Successfully Installed, Scheduled and Monitor the 6 Process chains for Bi
statistics, researched several OSS notes so as to make sure that the data
is updating perfectly in the Statistics Cubes and Multiproviders.
DATE: Sep 2006 - Aug 2007
CLIENT: Colder Products Company Palatine,
IL
POSITION: SAP BI Techno-Functional Consultant
Technical Env. SAP BI7, SAP R/3 4.6C Modules: SD, FI, ABAP4, CRM
RESPONSIBILITIES:
. Responsible for generating Function specifications & Technical
Specifications
. Designed and developed Basic Infocubes, DataStores (DSOs) and
Multiproviders
. Customized LO Cockpit extract structures and data sources in SD, FI to
facilitate the data extraction to BW and to reporting using classification
of various data elements.
. Created Data Transfer Process (DTP) to schedule the update in BI 7.0.
. Implemented BEx reporting and BW Web reporting, End User Training for
Power users and Super Users.
. Developed flexible queries using filters, Free Characteristics,
Navigational attributes in BEx analyzer to facilitate data analysis in a
drill down version to enable the easy access of information at various
levels. Generated reports with replacement path, adjusted exceptions for
detailed reporting and designed Exceptions, Variables, Structures,
Restricted Key figures, calculated key figures on BEx Queries for
Logistics, SD, Procurement and Finance(AR, AP, GL).
. Monitored Delta, Repeat Delta extractions and process chains,
responsible for conducting and monitoring test results from unit &
regression testing and fixing defects.
DATE: Jan 2006 - Aug 2006
CLIENT: Century Aluminium
POSITION: SAP BW Technical Consultant
Technical Env. SAP BW 3.5, SAP R/3 4.6 Modules: MM, FI, ABAP,
BPS,BPC, CRM
RESPONSIBILITIES:
. Implemented extraction, transformation and loading of data to Business
Warehouse from SAP R/3 after analyzing Technical Specifications
Documents.
. Installed, modified & activated Business content & custom MM InfoCubes,
ODSs, DataSources, InfoSources.
. Data extraction from flat files and SAP R/3. Used interface DB connect
to get data from external sources.
. Handled performance tuning of queries using aggregates, table
partitioning, indexing of InfoCubes.
. Used RRI jump queries for drilling down to other queries and R/3
transactions.
. Created Web reports using Web Application Designer WAD,, Publish the
reports on portal, utilized Information broadcasting.
DATE: Nov 2004 - Dec 2005
CLIENT: Graham Packaging Company
POSITION: SAP BW Consultant
Technical Env. SAP BW 3.5, SAP R/3 4.6C Modules: SD, MM, ABAP,
BPC, CRM
RESPONSIBILITIES:
. Responsible for identifying business requirements and implementing ASAP
methodology, Creating functional specification & Technical specifications.
. Sole BW Implementation for SD Module.
. Responsible for identifying SD, InfoCubes and ODS Objects in Business
Content based on business requirements.
. Extracted data from SAP R/3 using LO Cockpit, Generic and Business
Content Extractors.
. Created and maintained CO-PA data-sources.
. Used Delta Update process for loading the data to BW from R/3 in
specific intervals.
. Used BEx to create reports with exceptions, conditional formatting,
restricted key figures and calculated key figures. Worked on currency
conversion as per the user requirements.
. Excellent knowledge of WAD, Visual Composer, Report Designer, Portal
Integration.
. Responsible for writing new ABAP/4 routines and also tuning existing
start routines and update rules.
. Performance Tuning of Data Loads, Queries, Aggregates building for Query
optimization
Contact this candidate