SUMMARY

• SAP Consultant over 8+ years Professional experience with Business Users Interaction, Requirement Gatherings, Configurations, Development, Testing and End User Training with SAP ERP, SAP BW/BI/BO, SAP HANA, Accounting, Technical and Production Support.
• SAP Finance and Controlling with two full life - cycle Implementations of SAP FI/CO Module in SAP Project as per ASAP methodology
• Currently working as SAP BI/ HANA/BPC Architect & Practice Lead.
• Recommended best practices and ensured Business Partners are aware of various solution options for financial systems automation.
• Experience developing short & long term roadmaps closely working with business partners and understanding their future requirements.
• Experience running technical governance meetings for developing implementation plans and manage project delivery.
• Worked on several implementations and has solid hands-on experience working in SAP BPC/ BW and HANA.
• Implemented new Security Model
• Implementation experience in General Ledger (GL), Account Receivable (AR), Account Payable (AP), Asset Accounting (AA), Special purpose Ledger, Controlling Areas, Cost Center Accounting (CCA), and Profit Center Accounting (PCA).
• Experience covers all stages of SAP BI/BPC,FI/CO activities from Fit Gap analysis, Develop
• Creation of business blueprints, Configuration, Realization, Unit Testing, Integration Testing, Learning training, Go Live support, Control Start, Support production.
• Experienced in Enhancements, Testing & Production Support/ user issues, super-users and End user training and documentation.
• Provided end user support for all issues pertaining to Finance and Controlling modules & Worked closely with Business Leaders to consult and influence direction of business process.
• User Training on the processes and assistance in developing End User Document.

PROFESSIONAL EXPERIENCE

Confidential, Denver CO

EPM/BPC and HANA Architect

Responsibilities:

• Responsible for BPC 7.5 implementation and Subsequent migration to EPM10 and EPM10 on HANA
• Gathered and Review Business Requirements.
• Review Financial Reporting, Input Schedules and Self Service Query requirements.
• Create functional specification documents.
• Co-ordinate Design & Build Workshops.
• Develop and oversee the system build and design.
• Create Dimensions and Models for Budget & Forecast.
• In memory planning in BW on HANA--Planning Application Kit (PAK)
• Create and Maintain BPC Master Data, create Reports and Templates.
• Manage Project & ensure deliverables are met as per plan.
• Set up project review meetings with Business and IT teams.
• Recommend SAP Financial and BI solutions as per the client future requirements.
• Ensure SAP Best practices are followed.
• Implemented Cost center Planning/ Capital and Treasury Planning
• Implemented Tax Planning and integration to Corp TAX
• Implemented Headcount planning based on HCM Module
• Real Time ECC integration
• Successfully met all project objectives of Strategic planning
• Successfully migrated existing model into EPM10: Models and Business
• Implemented 23 new infoproviders, 9 multi-providers, and 4 virtual cubes to support SD, MM, PP, FI, AR, and AP reporting requirements.
• SAP HANA optimized planning (PAK)
• Utilized new BI 7.3 transformations and DTPs for all new developments.
• Developed numerous custom datasources using database views and custom function modules.
• Utilized the Analysis Process Designer (APD) to populate summary cubes using complex queries on other cubes.
• Developed 34 process chains to automate the initialization and delta updating of
• Created over 50 BEX /BO queries and assigned them to roles by department.

Confidential, Bartlesville, OK

SAP BPC Consultant

Responsibilities:

• Understand Business Pain Points with the existing BPC System.
• Propose Alternate Design Solutions.
• Debug/ Rewrite Script Logic for Budgeting Process.
• Debug Budgeting/HR templates
• Setup new Process Chains and Data Manager Packages.
• Support Current Consolidations System.
• Document the Consolidations process and BPC workflows.
• Participate in Month End close maintenance activities.
• Verify Business Rules and Script Logic for Inter Company Eliminations and Consolidations.
• Planning Model.
• Create Input templates for Capex Planning model to input various projects
• Develop Scripts to calculate Gross Margins, Cost of Goods Sold.
• Develop Data manager packages to archive forecast and run developed Scripts
• Technical documentations and Process flows for all processes involved.
• Recommend SAP Financial and BI solutions as per the client future requirements.
• Manage Project & ensure deliverables are met as per plan.
• Set up project review meetings with Business and IT teams.
• Blueprint support

Confidential

SAP BPC Consultant

Responsibilities:

• SAP BPC Netweaver 10.0 Version
• Configure Transformation files and data loading packages
• Configure EPM reports on Planning
• Developed script logic files using ABAP, BADI, MDX and SQL.
• Configure currency translations - Rate of exchange upload, Rate Types and dimensions
• Gather and Review Business Requirements.
• Review Financial Reporting, Input Schedules and Self Service Query requirements.
• Create functional specification documents.
• Co-ordinate Design & Build Workshops.
• Create Dimensions and Models for Budget & Forecast.
• Create and Maintain BPC Master Data.
• Create Reports and Templates.
• Manage Project & ensure deliverables are met as per plan.
• Set up project review meetings with Business and IT teams.
• Recommend SAP Financial and BI solutions as per the client future requirements.
• Implemented Tax Planning and integration to Corp TAX
• Implemented Headcount planning based on HCM Module
• Successfully met all project objectives of Strategic planning
• Successfully migrated existing model into EPM10: Models and Business

Confidential, Providence, RI

SAP BPC Consultant

Responsibilities:

• Configure Environments, Models, Dimensions, Business Rules and script logic
• Review Financial Reporting, Input Schedules and Self Service Query requirements.
• Create functional specification documents.
• Configure currency translations - Rate of exchange upload, Rate Types and dimensions
• Interco Elimination journal entries in consolidation system and investment in subsidiaries
• Consolidations:
• Intercompany eliminations: AR AP, bond transfers, reinsurance elimination
• Planning:
• Design and develop input schedules, reports and custom interfaces, budget actual and forecast models
• Create EPM Reports in BPC-Excel
• Built consolidation model / Ownership and Rate Model
• Configured Intercompany and Currency Translations
• Configured COI ( Consolidation of investments)
• Configured Ownership model
• Developed logic for Cash flow and Treasury Planning
• Developed many reports and input schedules
• Design Proof of Concept documents
• Functional Design of legacy systems to BPC interfaces
• Testing of Planning reports, input schedules and data loads from BW cube

Confidential, San Francisco, CA

SAP BPC/BW Consultant

Responsibilities:

• Developed Data Model for BPC Account Based model from BI KPI's.
• Created Application Set from APPSHELL. Developed Applications, Dimensions, Properties and Hierarchies
• Configured Application Set and Application parameters for Journals and work status settings.
• Involved in data extraction and conversion between BPC and BW systems.
• Worked on Setting up Security features with Task profiles and Member Access Profiles.
• Integrated SAP BPC Data Manager Packages with SAP BI process chains.
• Developed script logic files using ABAP, BADI, MDX and SQL.
• Perform Planning using internal data base routines (PAK)
• Created EVDRE Input Schedules, Reports and Journals, Script Logic and Business rules.
• Worksheet formulas, and Dimension Formulas for G/L Accounts, P & L, AR, AP, Income Statements which involved Budgeting and Forecasting.
• Worked on month end closing consolidation Reports.
• Performed reporting and data collection using Distributor & Collector functionality.
• Extract data from SAP and non - SAP systems into BPC/BI/BW with ETL tools
• BI mapping Master Data to Source Data, create Transformations

Confidential, Phoenix, AZ

SAP BW Consultant

Responsibilities:

• Requirement gathering, design and analysis - Worked with end users to identify and advise on existing info structures updated by business events in R/3. Identify potential uses and conduct functionality gap-analysis. Identify potential solutions, implement enhancements to existing functionality.
• Responsible for business data modeling, data mapping, and gap analysis.
• Designed and developed custom DTPs, Transformations, and Cubes, DSO, Aggregates, queries and workbooks.
• Created Hierarchies on 0ACCOUNT, 0GL ACCOUNT and 0PROFIT CTR for financial reports.
• Created and automated monthly P & L reconciliation of budget, actuals and variances
• Created P & L Reports, Balance Sheet, Cash Flow Statement, FRP and Vision Reports.
• Distributed P & L Workbooks to field managers across the global using Broadcasting.
• Created Broadcasting Process Chain and created job to send emails automatically using SCOT. Distributed monthly financial reports using broadcasting.
• Created Generic Extractor using function module.
• Created WebI report directly on Bex queries without any universe layer in BOBJ 4.0.
• Prepare and deliver training materials station managers, technical project, business process owners and other end-users.
• Designed Security profiles for functional users, developers, and budget users. Created Authorization based on profit center hierarchy nodes.

Confidential, Secaucus, NJ

SAP BW Developer

Responsibilities:

• Involved in creating InfoObjects, Infosources, Infocubes, Multi Providers, Infoset and all other infrastructure changes.
• Created BI Dashboard for Procurement Top Sheet module for higher management to keep track of all the materials status in the warehouse.
• Using Web application Designer, designed many web reports, templates, Graphs, Uploading logo, Icons, Style sheets, creating tabs etc.
• Actively involved in creating default web template
• Using BEx Query Designer, created many queries using pre queries, filters, variables, calculated Keyfigures/Restricted Keyfigures, Exceptions, and Conditions etc.
• Created Master Data and transactional Infosources for uploading attributes and texts.
• As part of upgrade team, involved in migrating many BW 3.X queries to BI7.X
• Worked closely with SAP to resolve upgrade issues.
• Created multiple Generic Data Extractors to create Data Sources for transaction and master data.