We provide IT Staff Augmentation Services!

Sap Bpc Consultant Resume

IL

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 Confidential - Confidential, BPS, BI,BW and FI-CO projects.
  • Exposed to all phases of project from Planning, Blueprinting, Configuration, Development, Integration Testing, Cutover, and to Go Live.
  • 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
  • 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)
  • Two(2) years of experience implementing and configuring Confidential - Confidential .
  • Excellent experience configuring Confidential 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.
  • 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 Confidential 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.
  • 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:

BPC: BPC 7.0 (Netweaver), BPC 5.1/7.0/7.5 (Microsoft-Outlooksoft),BPC 10 NW

BI/BW: BI 7.0, BW 3.5, 3.1C, 3.0B, BPS, IP and Confidential

SAP R/3: ECC 6.0, ECC 5.0,ECC 5.0,4.7,4.6C, 4.5B, 4.0B

SAP Modules: FI-CO, SD, MM, HR

Reporting Tools: BEx Analyzer, Web Analyser, BPC For Excel,WEB, Word and PowerPoint

Database: Oracle 10g, SQL server, MS Access, DB2 and Teradata

O perating Systems: UNIX, Windows XP/2000/2003/NT 4.0/98/95.

Application Programs: MS Office, MS Power Point etc

Languages: C, C++, SQL, ABAP/4, MDX and PL/SQL.

PROFESSIONAL EXPERIENCE:

Confidential, IL

SAP BPC Consultant

Environment:, BPC 7.5NW

Responsibilities:

  • 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.

Confidential, NY

SAP BPC (Outlooksoft) Consultant

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

Responsibilities:

  • 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 .

Confidential, VA

SAP BPC(Outlooksoft) Consultant

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

Responsibilities:

  • 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.
  • 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
  • Implemented new features like drill through in reports.

Confidential, CA

SAP BPC (Outlooksoft) Consultant( )

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

Responsibilities:

  • 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.
  • 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.

Confidential, CA

SAP BPC Consultant

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

Responsibilities:

  • 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.
  • 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.
  • 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.

Confidential

SAP Confidential Consultant

Environment: SAP ECC 6.0, BI 7.0, ConfidentialL

Responsibilities:

  • 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 Confidential into Local and BW systems. Synchronized master data using synch programs between Confidential 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.

Confidential, MN

SAP-IP Consultant

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

Responsibilities:

  • 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.

Hire Now