SUMMARY

• Over 7 years of Business Planning and Consolidations (SAP BPC)and Business Warehouse (SAP BW) experience.
• Have experience in both planning and consolidationas a Confidential - Functional Consultant.
• SAP BPCPlanning, Budgeting, and Forecasting Implementation - Data Load, Manual Planning via Input Form, Manual Forecast via Input Form, Automated Planning via Logic, Automated Forecast via Logic, Budget Allocation, Business Process Flow, Work Status, and Management Reporting.
• SAP BPC Consolidation Implementation (Data Collection, Data Preparation, Pre-Consolidation, Consolidation, and Post Consolidation) - Data Load, Currency Conversion, Group Currency Conversions, Journals, Carry Forward and Account Classifications, Ownership Calculations, Intercompany Matching, Intercompany Booking, Intercompany Eliminations, Minority Interest and Equity Adjustments, Statuary Reporting, and Consolidation Centrals.
• SAP BPCApplication Architecture - Managing Environment, Model, and Dimensions, Optimize Model, Logics, Business Rules, Journals, Work Status, BPF’s, Documents, Library, Web Reports, EPM Add-In Excel, Data Manager, Transformation and Conversion files, Data Package, Input Forms/Reports, and EPM functions.
• SAP BPCSecurity - Secured Dimensions, Users, Team, Task Profile, Member Access Profile.
• ConfiguringEnvironments, Dimensions and Models in BPC 10.0andbasicknowledge on creating InfoCubes in BPC 10.1 (Classic).
• Performed data loads into BPC 10.0 from flat files and also fromBW InfoCubes into BPC Models.
• Worked on building custom InfoObjects, InfoCubes, DSO and loading data into DSO from SAP ECC system.
• Participated in resolving Performance issues, as part of Production support.
• Strong analytical ability, excellent interpersonal communication skills, proven track record and ability to work independently and in teams. Result-oriented with excellent problem-solving and leadership skills.

TECHNICAL SKILLS

SAP BPCNW: BPC NW 7.5, 10.0, 10.1 (Classic)

EPM 10.0: Script Logic, Worksheet Functions, Data Manager, BW Process Chains, Work Status, BPF and Security

Data Warehouse: BW7.3

Programming: C, Visual Basic ActiveX (VBA)

PROFESSIONAL EXPERIENCE

Confidential, PA

SAP BPC Consultant

Responsibilities:

• Project involved design and development ofSAP BPC10 NW version for the FI Planning. Gathering user requirements, implementation of Input Schedules/Reports for Finance Planning backend of SAP BW.
• Design and configure BPC (BPC 10Net Weaverversion) structures.
• Environment Shells, Models, Dimensions, Attributes, Hierarchies, and Security Profiles.
• Designed and configured MS Excel based templates that would be used to enter different types of data (future forecast, price projections, and assumptions).
• Designed and developed transformation and conversion files for deriving master and transactional data from BI to BPC.
• Experienced with developing integration between BPC and BW objects.
• Developed Logics using macros.
• Provided solutions on master data automation and Master data on fly.
• Developed complex input schedules on EPM 10.
• Developed reports to reconcileActuals on EPM 10.
• Implementation of Legal Consolidation and relevant reporting requirements based on USGAAP Financial Standards.
• Created required input template to maintain supplementary information for all entities.
• Provided required csv file format for non- sap entities to upload data.
• Created Legal Consolidation Application with relevant ownership & rate applications.
• Created static and dynamic templates to report on the pre consolidated &consolidateddata.
• Defined required data source & flow members based on client requirement.
• Configured Currency translation Business rules to enable conversion based on the Accounting standards.
• Created Audit reports to validate currency translation results for Audit purpose.
• Calculated quarterly movements based on the YTD values using script logicfor reporting.
• Provided SAP BPC as a single source for publishing the annual financial statements based on USGAAP Financial Standards.

Confidential, PA

SAP BPC Planning Consultant

Responsibilities:

• Project involved design and development ofSAP BPC10 NW version for the SCM Planning. Gathering user requirements, implementation of Input Schedules/Reports for SCM Planning (Sales, Marketing, and Product Management) with backend of SAP BW.
• Designed and configured BPC (BPC 10 NetWeaver version) structures.
• Prepared Design Document for Business Planning (Sales and Marketing).
• Environment Shells, Models, Dimensions, Attributes, Hierarchies, and Security Profiles.
• Designed and configured MS Excel based templates that would be used to enter different types of data (future forecast, price projections, and assumptions).
• Designed and developed transformation and conversion files for deriving master and transactional data from BI to BPC Experienced with developing integration between BPC and BW objects.
• Experience with Unit of Measure and Unit of Currency conversions.
• Performed data loads into BPC 10.0 from flat files and also fromBW InfoCubes into BPC Models.

Confidential, DE

SAP BPC Consultant

Responsibilities:

• Worked onBPC7.5 feasibility study. Created a Pilot using 7.5 and later upgrade toBPC10.0 NW for Emblem Sales Model to track past and current sales and project future Sales Plans.
• Created Business and Functional Requirements document Blue Print by discussions with stake holders in IT and Business.
• Created new Environment and Sales Model, related Dimensions, Properties for Sales team.
• DevelopedEvDRE& EPM Excel Reports to create Sales Plan and Report Sales Data on periodical basis on the web.
• BPCUpgrade from 7.5 toBPC10.0.
• Help in Upgrade Strategy
• Evdre Migration to EPM.
• Created Budget Allocation Scripts for Sales Plans & Budgets.
• Created Input Schedules to Input Sales Data
• Created Journals to adjust data.
• Created Transport from Dev regions to QA and Production.

Confidential, IL

SAP BW Consultant

Responsibilities:

• Extracted data using both standard and generic extraction procedures.
• Scheduled and monitored data loading processes.
• Worked at length on setting up historical data inSAP R/3and extracted and loaded data intoBW targets.
• Createddata sources,InfoSources,InfoCubesand update andtransfer rulesso as to load data into respective InfoCubes and data storage objects.
• Evaluated performance of the system and incorporated performance enhancing solutions by forming aggregates and carrying out InfoCube compression.
• Created process chains for master and transaction data as per business requirements.
• Designed queries inBEx query designerand embedded these reports into worksheets.