SUMMARY:

• Quality - driven Enterprise Performance Management (EPM) professional with over 9 years of industry (SAP) experience that includes 8 years of experience in SAP BPC. A well-qualified diverse candidate specialized in understanding client’s needs, propose possible solutions and translate them into efficient systems.
• Have worked on several SAP BPC implementations / Upgrades / Ongoing support, that include 4 end-to-end EPM solutions.
• Have led teams at 3 projects (onsite and offshore). Part of which was to face client meetings understand their requirements and guide the team about what we are trying to achieve and propose solutions. Finalize the best solution and present it to the client for approval to take things in the right direction.

TECHNICAL SKILLS:

SAP: SAP BPC 10.1 (Admin + EPM Client for excel),BPC 10.0, BPC 7.5, NW, BPC 7.0, SAP R/3, SAP FI, SAP BW

Other: Project Management / Team Management, Business Analysis, Financial Analysis, Enterprise Architecture and Enterprise Data Warehousing, Custom Application Design and Development, Data Modeling, ASAP Methodology, MS Excel, Word, Power Point, Visio, Project, Outlook, IBM Lotus Notes, VMWARE Workstation 9, Hyperion Enterprise, VBA for Excel, IBM COGNOS Report Development, Salesforce.com Administration, Tableau, ESSBASE, LUMIRA, HPQC, RevTrack, BEx

Industry experience: Infrastructure, Construction, Energy, Logistics, Food Industry, Healthcare, Textile, Professional Services, Luxury, Beverages, Fashion, Orthopedic

PROFESSIONAL EXPERIENCE:

Confidential, Warsaw, IN

Sr. Consultant (SAP BPC)

Environment: BPC 10.1 on HANA

Responsibilities:

• Worked on requirements gathering
• Designed solution with team
• Created Info Objects and Info Providers as per requirements and BPC Design Document
• Created Staging Cube and transformation
• Loaded Data from Info Provider (DSO) to Staging cube for BPC
• Worked with ABAP programmer to help him understand the requirement and code i.e. converting multiple key figures to single key figure structure
• Worked with ABAP programmer for a requirement to eliminate all leading zeros before loading data from DSO to Staging cube to match master data in BPC
• Created process chain in BW to be triggered by Data Manager Package from within BPC which should load data from DSO to Staging Cube
• Created an Interface for testing & reconciling data between BEx report, ECC KE24 (COPA) & BPC Report
• Loaded Master and Transaction Data from BW to BPC
• Created Transformation and Conversion files for data loads and data extracts
• Created Reports, input schedules & script logic
• Configured Business Rules
• Configured Security End to End (worked with Internal Auditors to understand the Audit requirements)
• Configured Work Status
• Transported from DEV to QA
• Gathered Requirements for a custom data extract to be loaded into Hyperion
• Developed Transformation and Conversion file for Data Extract (flat file) to be loaded into Hyperion
• Training Documentation (+ “How To” documents)
• Technical Unit Testing (HPQC + Rev Track used)
• End User Training & UAT

Confidential, New York, NY

Subject Matter Expert (SME) - SAP BPC

Environment: BPC 10.0

Responsibilities:

• Managed a new implementation and upgrade
• Upgraded from 7.5 to 10.0
• Migrated some not so important and built from scratch all the important reports based on client’s decision
• Implemented new functionality for full Income Statement Planning, Budgeting, Forecasting plus Actual Simulation Derived by Depletions instead of Sales Volume
• Report and Input Schedule development, plus development of custom excel interfaces between Essbase, Cognos and BPC
• Managing Production and Development environments for BPC
• Working on several projects within the organization to improve processes, using systems more efficiently and automate where possible
• Managing Master data in SAP BPC
• Implementing new Planning and Consolidation functionality as per client’s requirement
• Validating Data loads from ECC to BPC (transactional)
• Created Trainings for regions finance teams to train them on tools and applications
• Part of Information systems master plan, working on the master data synchronization between Cognos and BPC.
• Working closely with FP&A team and other users in Operations, Regions Sales, Brand Managers and Accounting department, to better understand their needs and transform them into future solutions
• Worked on a home grown tool for Pricing. Master data modeling for this tool was in progress for 1 year( completed data modeling which was a challenge back in the date because of different master data in different systems) this effort and success was very well appreciated
• Created several interfaces in excel which retrieves data from BPC and Essbase and compare them for validation
• To report consolidated numbers to the Headquarter we use Essbase, I have created several templates and input schedules to load data from BPC to Essbase at a top level and vice versa
• I am responsible for timely delivery of projects, resource management and scoping need of new resources
• Part of what I do every day is to build users’ confidence in tools as an advocate of IT and Finance
• Built reports in Cognos and validated transactional data between Cognos and BPC

Confidential, New York, NY

Team Lead - SAP BPC / Financial Analysis

Environment: BPC 7.5 MS

Responsibilities:

• Maintenance of BPC System (Scheduled and Unscheduled)
• Creation of new reports and input schedules
• Maintaining Dimensions, Reports, Input Schedules etc.
• Working with business / Finance users to improve processes
• Working with Finance department to facilitate analysis part of which is developing new reports according to their analytical needs
• Facilitates in Financial close at period end (every month and quarter end)
• Generate monthly reports (Consolidated PnL, Consolidated Balance Sheet, Statement of Cash flow)
• Help Financial analysts for their analytical needs in slicing and dicing the data
• Upload Monthly statements (PnL, Balance Sheet, Cash Flow, Revenue, Expected Revenue) to Hyperion
• Configured Cash flow functionality
• Trained new hires on BPC
• Wrote How To documents for new users and new functionalities
• Created Macros using VBA to automate routine functionalities
• Created Task Profiles, Member Access Profiles and Teams to facilitate Security.
• Configured Security as per customer’s needs.

Confidential, Houston, TX

Sr. SAP BPC Consultant

Sr. Consultant SAP BPC / Report Development Lead

Environment: BPC NW 10.0, SAP BW 7.3, ECC 6.0

Responsibilities:

• Created Environment (Appset), Created Module (Application), mapped and identified required dimensions and properties, loaded Master data from BW using Data Manager Package
• Created Transformation and Conversion files for Master Data load from BW
• Created Hierarchies in BPC according to client’s requirements
• Worked on Business Process Flow to standardize Planning Process
• Set Audit to see reports
• Maintained Rate Module its dimensions and members
• Worked on Currency Translation to support Consolidated statements in Reporting Currencies (USD) Planned and Actual data was coming in BRL, EUR, CAD and CNY
• Created Input Schedules using new EPM 10.0 client for Excel to facilitate Planning data input, Forecasting data input, Budget data input and Currency Exchange Rates input
• Part of the solution was to create user defined dimension called “UNIT” to facilitate reporting and planning in SI units like KG, LBS, MT and BRL
• Created input schedule to facilitate planning in other units instead of money
• Created several Trend, Variance, Offset, Dynamic, Static reports
• Created Balance sheet reports based on Entity, Regions and Headquarter
• Created Income Statement based on Entity, Regions and Headquarter
• Created reports to show transfers using units of Mass and Volume
• Setup Security according to client’s requirements (based on secured entity and category dimension)
• Created Users, Teams, Task Profiles, Data Access Profiles,
• Maintained Category dimension to support Rolling Forecast
• Created local members using EPM 10.0 functionality
• Used Excel formulas to create report specific local members to show required calculations
• Created Test Scripts and Training Power Points, used train the trainer approach to train key users
• Worked on test scripts with the project manager from client site, created training material accordingly, trained key user in workshops and let them test the developed functionality
• Provided support / Resolved issues after Go-Live.

Confidential, Atlanta, GA

SAP BPC Consultant

Environment: BPC NW 7.5

Responsibilities:

• Modeled a guided workflow for high-level process orchestration with BPF
• Modeled Dimensions, Properties, Applications as per design
• Extracted Master Data and Actual Data using DMP from BI to BPC
• Configured the Currency Translation Logic, maintained Rate Application, Business Rules, Account Dimension
• Worked on BPC Excel EVDRE, EVGET reports, input templates and input schedules
• Developed input schedules for CapEx Planning, Revenue/COGS Planning
• Modeled security for restricting user access by activity, for reports specific to region
• Implemented Security using Applications, Task Profiles and Member Access Profiles
• Created custom Process chains, Data Manager Packages and performed data loads
• Created Test Scripts and did Unit Testing
• Created end user training material and conducted trainings

Confidential, San Jose, CA

SAP BPC Consultant

Environment: BPC NW 7.5

Responsibilities:

• Designed applications for HCM and Revenue Planning
• Designed and developed transformation and conversion files for loading Master and Transaction data into BPC
• Report generation using EVDRE and advance formatting
• Implemented Planning, Budgeting application including of application set creation and dimension builds.
• Created Business process flow, Work Status and enabled security setting for user groups / teams
• Worked on multiple data flows between ECC, BW and BPC, created and configured transformation files and data conversion files, created detailed End User Training Documents and Conducted Trainings for Super Users

Confidential, New York, NY

SAP BPC Consultant

Environment: BPC NW 7.0

Responsibilities:

• Gathered the requirements for blue print, built the Consolidation
• Prepared Process Definition Document, Report Definition Document for the finalized consolidation
• Prepared the documentation on the input template and data extraction of consolidation documentation
• Performed Consolidations (Hyperion to BPC conversion)
• Designed, developed and successfully implemented BPC 7.0 NW
• Performed Inter Company Eliminations and Matching, Consolidations
• Developed Reporting and Input templates to meet business requirements
• Created Application Set from APPSHELL. Developed Applications, Dimensions, Properties and Hierarchies
• Worked with Script Logic and Worksheet Formulas
• Created Conversion files
• Created and maintained Transformation file (Mapping + Conversion)
• Developed reports and Templates using EVDRE functionality
• Generated P&L reports for multiple business entities and corporate centers
• Worked on BPC Optimization Tool and set parameters for automatic light and full optimization
• Delivered SAP BPC End User Training

Confidential

SAP FI Consultant

Environment: SAP 4.7

Responsibilities:

• Involved in Full Life Cycle from Project Planning to G-live and Post Production Support
• Areas of focus during the project: Gl, AP and AR
• Involved in the GAP analysis (AS IS - TO BE), business process re-engineering, blueprint creation of the business processes and testing of Accounts Payable and Accounts Receivable
• Discussed with the client authorities and configured organizational structure
• Created the master data for General Ledger, Accounts Payable and Accounts Receivable
• Configured the Accounts Payable and Accounts Receivable
• Configured House Banks and automatic payment methods
• Configured the automatic payment program
• Integrated AP and AR with MM and SD
• Configured Bank Reconciliation accounts
• Participated in discussion with the client about their Dunning procedure and worked with a senior consultant who was implementing Dunning
• Worked with the team who configured the BAI2 Lockbox functionality to process Accounts Receivable payments automatically against customer invoices
• Provided End User Training
• Provided Go-Live and Post Production support