SUMMARY

• Experienced techno functional consultant wif 15+ years of experience in various project life cycle.
• Currently working wif Confidential . as BW/BPC consultant since 2011 as SAP BW/BPC consultant.
• Multiple full lifecycle SAP BI implementations, development, optimization, enhancement, upgrade and extensive production support experience.
• Strong knowledge of best business practices and BI project methodology.
• Experience in gathering and converting business requirements into functional and technical specifications.
• Experience in SAP BW Data Modeling, Extraction and Reporting.
• Extracted data from SAP R/3 (FI, CO, COPA, SD, and MM) and non - SAP Legacy systems (Oracle, AC Neilson).
• Experience in developing BPC models, input templates and queries for forecasting and planning
• Extensively worked on input templates using VBA macros based on complexity; logic scripts for data movement across models, transformation and conversion files for data loads, currency translations, allocations and eliminations
• Extensive data loading and monitoring experience in a production environment.
• Experience in training functional consultants in BW Data Modeling & BEx Reporting
• Experience in End-User training and Documentation.
• Excellent client facing, Interpersonal and communication skills.

PROFESSIONAL EXPERIENCE

Confidential

SAP BI/BPC Consultant

Technical Environment: SAP-BI - 7.3, SAP ECC 6.0

Responsibilities:

• Transitioning Sysco’s Planning and Forecasting process from simple input forms in SAP BPC 7.5 and excel reports to driver based Planning and Forecasting Models in SAP BPC EPM 10.
• Designing Plan and Forecast (Budget and Estimate) driver based models for operating companies to Plan/Forecast for Sales, COGS, Payroll, Headcount, Capital and Variable Expenses.
• Creating Capital Expenditure Model to simultaneously book planned acquisition of Fixed Assets and roll forward Depreciation for both planned as well as existing assets.
• Generating and distributing reports displaying all P&L line items showing comparison between Plan/Forecast and Actuals from last year.
• Guiding Operating companies to utilize teh drivers/past trends to reach teh operating pre-tax targets set by corporate.
• Streamlining Forecast Cycle open/close processes (including running packages for Consolidations, Eliminations, and Foreign Exchange Translation and opening/closing teh Work status in BPC).
• Creating user communication and training documents along wif SOPs to ensure smooth implementation of new models.
• Support Sysco Business Managers by resolving their process related queries during planning and forecasting cycles

Confidential

SAP BI Consultant

Technical Environment: SAP-BI - 7.3, SAP ECC 6.0

Responsibilities:

• Requirement Analysis wif key users and SAP functional consultant
• Gap Analysis
• Functional Specification Preparation
• Activation BI Content in ECC 6.0 and BW 7.3
• Data extraction configuration
• Creation of BI integration layer objects
• Configuration of BI reporting structures
• Configuration of data flow - Transformation and Data transfer process configuration
• Configuration of data access environment
• Transport and Data loading
• Preparation of configuration documentation
• Unit testing and integration testing. Support during UAT.
• Performance tuning
• Communicate wif project manager as to teh progress of open items
• User training
• Quality assurance using HP Quality Center for creating test scripts and logging test results and defect tracking in teh system configuration

Confidential

SAP BI Consultant

Technical Environment: SAP-BI - 7.0, SAP ECC 6.0

Responsibilities:

• Requirement Analysis wif key users and SAP functional consultant
• Gap Analysis
• Tracking open items through a FS action register
• Functional Specification Preparation
• Activation BI Content in ECC 6.0 and BW 7.3
• Configuration of InfoObject, InfoCubes, MultiProviders, DataSources
• Create queries and web reports
• Setting up information broadcasting services
• Transport and Data loading
• Unit Testing
• Performance tuning
• Support during Integration testing and UAT
• Communicate wif project manager as to teh progress of open items
• SAP BW Production Support
• Interact wif SAP Business users
• Change management
• User training

Confidential

SAP BI Consultant

Responsibilities:

• Conducted teh workshops for gathering reporting requirements.
• Understanding user requirements and analyze teh requirements.
• Translate teh requirements into technical design and BW modeling.
• Activate/Configured Info cubes, ODS objects from teh business content.
• Extract Master data and transactional data from R/3 (logistics).
• Setting up process chains
• Helping in UAT

Confidential

SAP BI Consultant

Responsibilities:

• Conduct workshop for requirement gathering
• Designed and created all BW components to load teh historical data via R/3 and flat files.
• Worked extensively on Custom Info Cubes for Sales, Billing, Inventory, Purchasing and Delivery.
• Creating and mapping source and target structures, loading transactional data and master data, setting up delta load using SAP Standard extractor and Generic extractor Program.
• Developing teh queries to suit teh client’s requirement, Using Variables, Filters, free characteristics, restricted key figures and calculated key figures.
• Used LO Cockpits for Initial and Delta load data from SAP source system.
• Did flat file extraction of master data and transaction data of AC Neilson into BW.
• DB Connect for loading BOSNET data into SAP BW system
• Extensively used Transfer rules, Update rules (ABAP Routines) to translate teh business processes into end reporting objects.
• Developed Update rules and start routines going into ODS’ and cubes for calculations and lookups.
• Created Info Spokes, to extract data out of BW to flat files, those are used by NON SAP systems.