Summary:

• Sr BPC Consultant with extensive PLANNING and Consolidation Experience.
• 10 Years of experience as an SAP Consultant with good command on ASAP Methodology.
• Extensive Hands on Experience in Analysis Design and Development of BPC Solution in varied verticals.
• Involved in Pre Sales POC and Statement of Work Assessment.
• Extensive Hands on Experience to gather requirements data, mapped current and future state business processes to the packaged application s being implemented, and developed plans to address functional gaps between the packaged application and the redesigned processes Business .
• In-depth implementation experience to address multiple integration points between functions, related interface and data conversion issues, and expanded setup and configuration requirements Business .
• Domain knowledge on budgeting, planning, consolidation, and reporting processes
• 3 years of experience in BPC as functional and technical consultant in implementing SAP BPC Netweaver and Microsoft Outlooksoft Versions for Consolidations and Planning
• Eight 8 years implementing SEM-BCS, BPS, BI,BW and FI-CO projects.
• Exposed to all phases of project from Planning, Blueprinting, Configuration, Development, Integration Testing, Cutover, and Training to Go Live.
• SAP BPC NW and MS :
• Extensive experience in Blueprint, Design, Realization and Testing of BPC for both Planning and Consolidations using MS version and NW Version .
• Experience with Two full life cycle implementation of BPC for Legal and Managerial Consolidations. Consolidations include Intercompany Eliminations, Consolidation of Investments, Currency Translations, etc
• Experience with Two full life cycle implementation of BPC for Financial Planning that includes HCM, Capital Expenditure, Gross Profit, Income Statement, Balance Sheet and Cashflow.
• Migration: Experience working on Migrating BPC MS 5.1 version to BPC NW 7.5 version
• Extensive hands-on experience configuring BPC objects of Applications, Dimensions, Reports, Input Schedules, Script Logic, Data Manager Packages, SSIS packages ,VB Macros and BPFs, BADIs, Process Chains, Dimension Formula, Security Profiles, WorkStatus, Custom Menu, etc
• Functional Expertise with Currency Translation, Intercompany Eliminations, Consolidation of Investments with Purchase method and Equity Method, IC Matching, Balance Carry Forward, Allocations, Budgeting and Forecasting
• Technical Skills include creation of Application Set, Application, Dimensions, Properties, Members, Hierarchies, Security Task Profiles and Member Profiles , Work Status, Custom Menu, Script Logic, Reports-EVDRE, EVSND, EVGTS,EVHOT, and other EV functions, Custom Buttons using Macros, Journals, Comments, Datamanager packages using custom SSIS MS and Process Chains NW , VB macros, Transformation Files, Conversion Files, BPFs, Business Rules, SQL tables, TSQL Code, Transports NW , System Migration MS
• SEM BCS:
• Two 2 years of experience implementing and configuring SEM-BCS.
• Excellent experience configuring SEM BCS for Legal and Managerial Consolidations for Interunit Eliminations, Profit Eliminations, Consolidation of Investments with different methods, Reclassifications, Allocations, Restatements and Currency Translations.
• Configuration experience includes Databasis, Consolidation Area, Consolidation Groups, Consolidation Units, FS Items, Consolidation Functions with custom methods, Tasks and Method Layouts. Installed and customized Infoproviders, DSOs and Virtual Infocubes for reporting.
• Expertise in front-end Business Warehouse components for creating Consolidated income statement and Balance Sheet, Profit in Inventory, Investment in Subs, Cashflow report and various automated validation and reconciliation reports.
• SAP BPS/BI/IP:
• More than three 3 years overall experience implementing and configuring BW-BI-BPS-IP. Three 3 complete Life Cycle implementations of BPS. One 1 implementation of IP Integrated Planning
• Excellent experience configuring SEM BPS planning applications for Sales Profit Planning, Expense Planning, Income Statement Planning, Resource Planning and Balance Sheet Planning. Configuration experience includes Planning Objects like Planning areas, levels, functions, layouts etc in BPS, transformations, DTP, DSOs, Multiproviders in BI/BW.
• Expertise in front-end Business Warehouse components for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI, Ad-hoc Queries and Web application designer, Web Items and Web Reports. Also experience using Report Painter in R/3 creating several FI/CO reports.
• SAP FI-CO:
• Two 2 years of Functional expertise in implementing SAP FI-CO configuring General Ledger GL , Cost Center Accounting CCA , Internal Orders and Profitability Analysis COPA .

Technical Skills:

Industry: Pharmaceuticals

• Coordinated with Finance Team users and IT for the changes required for various Financial planning and budgeting activities.
• Captured and prepared functional and technical specification required for the new enhancements and requirements for financial process.
• Gathered requirements for Daily Sales Business Reporting Application.
• Created input schedules for input for HR Applications.
• Created Reports using EVDRE and VB Code functions.
• Identifying enhancements and Implementing.
• Defined the Application for the Sales Data.
• Defined the Data Manager packages for the Data load from Non-Sap Sources.
• Maintain Dimension members and Dimension hierarchies in BPC.
• Involved in day to day admin activities of BPC.
• Maintain uses in SAP BPC and Assign users to Teams and Member Access Profiles for Changing Financial Process roles.
• Troubleshoot and perform optimization activities for BPC.
• Implemented BADI for allocation script.
• Defined the Data Manager packages for the Data load from Non-Sap Sources.
• Wrote script logic for copying data from one application to another.
• Support the BPC Application on daily basis.
• Coordinate with business users for troubleshooting issues during month end process.

Consultant Environment: SAP ECC 6.0, BI 7.0, BPC 5.1 Outlook Soft ,BPC 7.5 Outlook Soft .

Industry: Medical Instruments

• Implemented variance Analysis Application.
• Wrote script logic for various variance calculations.
• Created input schedule for various input data for Budget and Forecast planning.
• Created EVDRE Reports for the Variance Reporting.
• Supported the Application .

Consultant Environment: SAP ECC 6.0, BI 7.0, BPC 5.1 Outlook Soft ,BPC 7.5 Outlook Soft .

Industry: Retail

• Completely responsible for the Full Implementation Project Blueprinting, Scoping, Realizations, Testing and Support of Financial Planning.
• Did Analysis to identify Data Sources to load Data from various Sources for Subsidiary Sales Volume and price per unit feed.
• Analyzed the Entity structure in scope and defined the hierarchy in the BPC Entity Dimension.
• Created 3 planning applications in BPC SALES Volume, SALES Revenue, and Product Price.
• Created Input Schedules for Sales, Discounts, Prices, Rates, COGS, Expenses, Fixes and Variable Costs, Variances, etc.
• Created script logic for various calculations including Allocation rules and Sales Margin ,Sales Revenue via custom data manager packages.
• Reports of Income Statement, Balance Sheet, P L Sales Revenue by Product Category, Sales Volume by

Territory ,

• Responsible for the development of various Test cases/scenarios for various stages of testing such as Unit Test, Functional Unit Test and detailed Integration Testing.
• Developed Cash Flow Report, Cash Flow 12 Month Spread, by Territory, Sales Budget Report, Marketing Detail Report.
• Defined Reports in Xcelsius for Sales Revenue,Sales Volume ,Product Category.
• Used Dimension formulas for all Percentage margin accounts, Growth metrics, Earnings Per share and Effective Tax rate accounts.
• Involved in Post Go live support and Month End Close Activities for Projections.

Migration to BPC 7.5 MS

• Involved in the Migration of BPC MS 5.1 version to BPC MS 7.5 version
• Implemented the process chains for SSIS in Microsoft version
• Tested all the Input Templates, Reports, Processed Dimensions and Applications.
• Worked closely with SAP support team in resolving issues.
• Post Migration User training
• Implemented new features like drill through in reports.

Consultant Environment: SAP ECC 6.0, BI 7.0, BPC 5.1 Outlook Soft ,BPC 7.0 Outlook Soft .

Planning and Forecast in BPC:

• Completely responsible for the Full Implementation Project Blueprinting, Scoping, Realizations, Testing and Support of Financial Planning.
• Did Analysis to identify Data Sources to load Data from various Sources for Sales Volume and ProdPrice.
• Analyzed the Entity structure in scope and defined the hierarchy in the BPC Entity Dimension.
• Created 3 planning applications in BPC SALES Volume, SALES Revenue, and Product Price.
• Created Input Schedules for Sales, Discounts, Prices, Rates, COGS, Expenses, Fixes and Variable Costs, Variances, etc.
• Created script logic for various calculations including Allocation rules and Sales Margin ,Sales Revenue via custom data manager packages.
• Reports of Income Statement, Balance Sheet, P L Sales Revenue by Product Category, Sales Volume by

Territory ,

• Responsible for the development of various Test cases/scenarios for various stages of testing such as Unit Test, Functional Unit Test and detailed Integration Testing.
• Developed Cash Flow Report, Cash Flow 12 Month Spread, by Territory, Sales Budget Report, Marketing Detail Report.
• Developed SSIS Packages for Loading Actuals from BW to BPC, to infuse Actuals into projections, to export data from BPC to BW, to run the accumulation logic.
• Developed Script Logic to Calculate Sales revenue Application doing a lookup in Price in PRODPRICE Application.
• Allocate the Corporate expenses and to calculate the Year To date data for Sales and Model data.
• Defined Reports in Xcelsius for Sales Revenue,Sales Volume ,Product Category.
• Used Dimension formulas for all Percentage margin accounts, Growth metrics, Earnings Per share and Effective Tax rate accounts.
• Involved in Post Go live support and Month End Close Activities for Projections.

Migration to BPC 7.0 NW

• Involved in the Migration of BPC MS 5.1 version to BPC NW 7.0 version
• Worked closely with SAP in using Migration utility
• Re-created objects like script logic and process chains in place of SSIS packages
• Tested all the Input Templates, Reports, Processed Dimensions and Applications.
• Worked closely with SAP support team in resolving issues.

Consultant Environment: SAP ECC 6.0, BI 7.0, FICO, BPC5.1 OutlookSoft , BPC 7.0 Netweaver

Legal and Managerial Consolidations in BPC:

• Rolled out a complete life cycle Financial Consolidation Project
• Designed the Integration of the Systems of ECC, BI and Legacy Systems Oracle Financials to combine the data for Analysis and Consolidation of data.
• Created 2 applications in BPC for Legal Consolidation and Managerial Consolidation.
• Configured BPC for consolidating data from companies of US, Canada and LATIN. Performed Foreign currency translations, Intercompany eliminations ICElim , Consolidation of Investments using Business Rules and also allowed journal entries in BPC for adjustments.
• Created Business Process Flows BPFs in BPC to monitor progress of users, send email notifications, assure consistency and uniformity.
• Supported 3 Month end-cycles.

Budgeting and Forecast in BPC:

• Completely responsible for the Full Implemention Project Blueprinting, Scoping, Realizations,Testing and Support of Financial Planning.
• Created 3 planning applications in BPC HCM Plan, GrossProfit Plan and CapEx Plan.
• Created Input Schedules for Sales, Discounts, Prices, Rates, COGS, Expenses, Fixes and Variable Costs, Variances, etc.
• Created script logic for various calculations including Allocation rules using tables in SQL Server clcAllocH and clcAlloc and executed via custom SSIS data manager packages.
• Reports of Income Statement, Balance Sheet, Headcount, Departmental Expenses, etc
• Responsible for the development of various Test cases/scenarios for various stages of testing such as Unit Test, Functional Unit Test and detailed Integration Testing.

Migration to BPC 7.0 NW

• Involved in the Migration of BPC MS 5.1 version to BPC NW 7.0 version
• Worked closely with SAP in using Migration utility
• Re-created objects like script logic and process chains in place of SSIS packages
• Tested all the Input Templates, Reports, Processed Dimensions and Applications.
• Worked closely with SAP support team in resolving issues.

Consultant Environment: SAP ECC 6.0, BI 7.0, BCS

Legal Consolidations in BCS:

• Implemented Legal Entity based consolidation to generate Consolidated Financial Statements and internal reports for management.
• Created consolidation area, assigned roles to consolidation fields. Created source data basis to get financial data from R/3 for R/3 based companies and flexible upload for non r.3 subsidiaries.
• Loading and Maintenance of all the master data for BCS into Local and BW systems. Synchronized master data using synch programs between BCS and BW.
• Created consolidation Functions include Balance Carry forward, Period Initialization, Data entry, Local and Group Validation, Currency Translation, Retained earnings calculation using Reclassification, Inter unit Elimination. Created necessary tasks, methods, method layouts and assigned them to monitor hierarchy.
• Created mechanism to link FS item to Parent company's Consolidation account. Generated Cons Balance sheets and income statement in two different views. Created canned reports for Cash flow statements, Profit in inventory and investment in sub.
• Created ABAP programs to format and validated the generated data. Created Custom t-codes to house the programs.

Consultant Environment: SAP BI 7.0,ECC 5.0, IP and FI, CO-PA modules

• Rolled out a full Profitability Analysis and Planning project in SAP IP. Responsible for overall delivery. Conducted Meetings on status, issues and progress.
• Completely responsible for IP development for custom developed Sales Profit Planning.
• Designed the Input-Ready Queries with WEB Interface for Planning Sales at different levels of aggregation for different Sales Managers, Product Managers and the Regional Directors.
• Set up the methods for Retracting Plan data from BW back to COPA for the online reports built on COPA in R/3.

Consultant Environment: SAP SEM 3.5, BW 3.1c, SAP R/3 4.7, and FI, CRM3.0, SD.

• Completely responsible for the initial phase of the Project Blueprinting,Scoping and Implementing BPS for CRM Marketing and Campaign Planning.
• Conducted workshops with business to get them acquainted with the bps tool.
• Activated Planning Services in BPS to integrate CRM Marketing profiles to BPS profiles.
• Created budget layouts for CRM sales and marketing for key figure planning in CRM marketing planner. Made setting to integrate CRM with BI for automatic Hierarchy Uploads and Master Data transfers.
• Create CRM planning profiles to use in BPS and assign to User Groups.

Consultant Environment: SAP SEM 3.5, BW 3.5, SAP R/3 4.7, and FI, CO-PA

Legal Consolidations in BCS

• Responsible for data modeling of all SEM-BCS info providers for pre-Consolidation staging, Consolidation and post-Consolidation reporting activities.
• Configuration of Consolidation functions which includes Balance Carry forward, Period Initializations, IU eliminations, Manual Documents, Validations etc.
• Designed process to migrate the Consolidation historical data.
• Leveraged the existing EC-CS consolidation processes to develop the SEM-BCS consolidation functions.
• Supported 3 Month end close process and 1 Quarter end close.

Budgeting and Forecast in BPS

• Analysis of current state of Budgeting and Forecasting Processes.
• Examined the corporate readiness to implement SEM BPS
• Analyzed and evaluated for opportunities to achieve best in class.
• Configured a prototype in Sales Profit Planning and Cost Planning using SEM BPS to replicate their current S OP and Cost Center planning in R/3.

Consultant Environment: SEM 3.2, BW 3.0b, SAP R/3 4.7, FI-CO, CCA, FI-GL, SD, and MM modules

• Created Individual Planning layouts for Sales, COGS and SG A to Rollup to income statement planning.
• Created different data sets by using version combinations. Gave the ability for the user to plan Sales and COGS components at material group/Region levels and SG A at Cost center/Functional area level
• Gave the mechanism for the user to directly load SG A plan data into BPS cubes using flat files.Created default views for different users to avoid locking. Deployed web based planning layouts.

Functional Consultant Environment: SAP R/3 4.6c, FI-CO modules

• Configured organizational data company code, chart of accounts, fiscal year variant, posting period variant, open and close posting periods. Created GL accounts, Field status variant and modifications.
• Month end foreign currency revaluation. Maintained the exchange rate table for multiple currencies.
• Implemented special purpose ledger to meet the business specific requirements for consolidations and to derive the reports using Report Writer/Report Painter

FI/CO Consultant Environment: SAP R/3 4.6b, FI-CO modules

• Creating and setting up the appropriate GL accounts for FI-MM and FI-SD integration through Automatic Account Assignment. Configured to keep track of inventory, GR/IR reconciliations and sales/use tax, cash discounts and retained earnings.
• Involved in period end close activities such as posting the recurring entries, lock the period, performing account reconciliation, interest calculation and account adjustments.
• Configured and tested distribution and assessment cycles for both profit center accounting and cost center accounting.Configured the necessary settings for costing-based profitability analysis CO-PA .