SUMMARY:

• Experience in Several full lifecycle implementationsin SAP BPC Embedded, BPC unified,Financial planning, Global reporting,SAP BPC 10.1 HANA Unified, SAP BPC 10.0 NW HANA, SAP BPC 7.5 NW and SAP BPC 7.0 NW. Extensively worked on Sales Planning, Head count Planning, P&L Planning, Balance Sheet Planning, Allowance and Marketing Planning and General and Administrative Planning.
• Extensively worked on End to End Configuration BPC System from loading Actual or historic data from SAP and legacy systems through flat file or Data sources using BW DTP loads. Created DSO to stage the Data before loading into BPC. And pulling them in to BPC Models using Data Manger Packages and reporting the data using BPC reports and Xcelsius.
• Experience in applying SAP Best Business practices thereby increasing the efficiencies of the existing systems.
• Demonstrated the ability to effectively transfer knowledge to end user and team members and create a lucid and concise documentation. Holds a Bachelor of Science in Computer Science.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago IL

SAP Architect

Responsibilities:

• Conducted business meeting to gather requirement and define functional and technical specification.
• Defined Planning process to lock and unlock data as part of the planning and forecasting process.
• Created Analysis for office - based input templates for Working Capitalplanning, Overhead planning and reporting.
• Created Planning functions using fox formula, Function type and copy functions.
• Created HANA views to convert 8XXX Accounts to 6XX accounts for labor cost posting at WBS level to map them to the OH report.
• Designed and Developed Planning template to lock data after the forecast, AOP and Budget numbers are finalized and approved.
• Extensively used HANA STUDIO for Modeling and SQL Scripting.
• Collected and transported developed objects and validated to ensure the consistency of the deployed solution.
• Conducted UAT with FP&A and sales user group.

Confidential, Burbank, CA

BPC HANA Senior Consultant

Responsibilities:

• Discussed the migration options and created migration Plan Document.
• Improved Query Performance by recommending the HANA standards and enabling parallel processing
• Enabled Parallel Framework and improved transactional loads.
• Suggested OSS notes to avoid dumps while loading data in to the BW staging area.
• Reviewed ad recommended the BPC objects like reports, DM packages, Scripts and BADI are following HANA standards.
• Wrote SQLScript on HANA and called from BADI to enable faster calculation.
• Tested Process chains that triggers DM packages ad provided recommendations.
• Created the cutover plan and coordinated the project team to execute them.

Confidential, Sunnyvale,CA

BPC HANA Senior Consultant

Responsibilities:

• Involved in blueprinting, Development and go live of P&L based Planning and Forecast solution on a BPC HANA Platform.
• Involved in configuring BPC on a HANA platform and developed P&L Planning solution on a BPC enabled HANA.
• Configured BPC Unified on a HANA Platform.
• Data Modeled URM, GM and P&L model.
• Created Dimension and properties used in the Models.
• Enabled Statistics to analyzed performance of the Solution and interacted with SAP to understand the recommended solution.
• Designed Data flow model for the Master data, Actual Transaction and Budget data.
• Developed Environment, Model, Dimension and other Meta data.
• Created Transformation Files, Conversion files for the Master and Transaction data load.
• In Creating Input Templates and reports to budget and forecast Cost by Drivers across Geographical location.
• Created Script and BADI to Push data from one model to another and Allocation.
• Applied OSS notes for Technical name consistency.

Confidential, Phoenix, AZ

BI IP Consultant

Responsibilities:

• Created Functions and Layouts for Opex Planning
• Created Layouts and functions for Revenue Planning
• Created Layouts and functions for Segment based planning
• Created FOX Formula to copy actual and overlay in the Budget Version.
• Created Currency Translation function.
• Created ABAP based function types functions for complex cost calculations.
• Created Input enabled queries and Excel based layouts.
• Extensively worked on Bex Analyzer.
• Created ABAP based User Exits and Characteristic relation.
• Configured Characteristic Relation to derive the data based on the functional relation
• Created Data slice to lock the data after finalizing the budget and open the data for initializing the budget.
• Supported the Existing BPS system for FP&A Planning

Confidential, Atlanta, GA

BPC Consultant

Responsibilities:

• Involved in blueprinting, Development and go live of Analysis of Change solution by Driver based model.
• The delivered solution enables the client to analyze the net sales, Volume, promotions, discounts and FX impact by Geography and product. The generated revenue and incurred expenses based on the driver based model are posted to P&L reporting.
• Designed Data Model for the True North Analysis of Change Functionality.
• Designed Data flow model for the Master data, Actual Transaction and Budget data.
• Developed Environment, Model, Dimension and other Meta data.
• Created Transformation Files, Conversion files for the Master and Transaction data load.
• Configured SPRO settings for BPC to enable parallel processing of transaction load using Data manger package.
• Configured parallel processing enabled data manager Package.
• Extensively Worked on Formatting, member Selector and Member Recognizer.
• Analyzed the reporting functionality available in BPC and provided the value chart to the client for making a decision.

Confidential, St Louis, MO

BI IP Consultant

Responsibilities:

• The Delivered Labor based model will enable the client to plan and forecast labor cost incurred at their various mines. The calculated costs are captured as expenses in their P&L reporting. This solution has enabled business to identify their expenses based on their current head count and predict the potential cost due to the increase in the head count based on their roles and position.
• Involved in development of Labor Cost model for the Australia mines.
• Worked on Data Model for Designing and Configuring Flat and Hierarchical Dimensions for Entity and Account dimension.
• Created FOX Formula for Calculation of wages, Hourly cost, Bonus, Befits, Payroll Tax, Escalation and Driver Costs.
• Created VBA code to look up the master data for input help.
• Worked extensively on Currency translation using SAP provided Currency conversion function.
• Involved in the development of Excel based input layouts and Input enables query.
• Heavily worked on performance tuning of the calculations.
• Involved in Unit and integration testing of the developed objects.
• Participated in everyday meetings for the technical review and to provide status of the project.
• Interacted with the end users for the Technical Review and User .

Confidential, Santa Ana, GA

BPC Consultant

Responsibilities:

• Conducted meeting with FP&A users and gathered business requirement.
• Created Blueprint and got Created by the business.
• Created Functional and technical Document.
• Managed onshore and offshore team in delivering the solution.
• Involved in development of and testing of cash and short term Debt planning Input schedules and Script logic.
• Created Script logic with MDX syntax for cash tax and revolver calculation.
• Created Input schedules and reports.
• Extensively worked on Data manager in loading data from BW, Flat file to BPC.
• Created BPC based process chain, Data manager package to load data in and out of BPC.
• Maintained BPC security by loading Users, Teams, Member access profiles and task profiles.
• Involved in Unit and integration testing of the developed objects.
• Facilitated business during the UAT process.