SUMMARY

• He is a seasoned SAP professional and an expert at managing and delivering SAP projects and support with a focus on SAP EPM/BPC.
• He is a functional expert with experience in all phases of the project life cycle, from initial assessment and road mapping to feasibility analysis and conceptual design through implementation and enhancement and on various project management methodologies.
• He has supported numerous of SAP BPC solutions in productive operation.

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

SAP BPC Reporting Consultant

Responsibilities:

• In charge of develop 64 consolidation reports using multiple EPM functionality such as local member formulas, butteryfly reports ( shared page, row or column axis for multiple reports on a single sheet), report views spanning multiple worksheets, and advanced Formatting Sheet functions.
• Experience with financial services reporting - legal and management
• Work with the Finance project team and end users to synthesize requirements, make suggestions for reporting performance and functionality improvement and in ultimately deliver scalable reports, enable successful user adoption and go-live.
• Apply report changes due to leadership change and new acquisition.
• Success fully performed Book publishing
• Document report specs, maintain master log, supported and developed training material

Confidential, Houston, TX

BPC Consultant

Responsibilities:

• Configuring BPC environments and models
• Configuring BPC Security for Task/Data Access Profiles, creating Teams and assigning Users
• Ensure master data, transaction data integrity
• Configuring and testing default BPC script logic
• Developing reporting and input schedules based on client specifications
• Create month-end closing Data manager package
• Build complex reports in Consolidations & Finance.
• Developed Security, Work Status and Interfaces to ECC.
• Supported and developed Training Material and various Test Plans
• Supervising BPC Development teams, including offshore resources

Confidential, Deerfield, IL

BPC Report Writer

Responsibilities:

• Configure Environments, Models, Dimensions, Business Rules and script logic
• Implemented Budget and Forecasting Process for Financial Planning
• Review Financial Reporting, Input Schedules and Self Service Query requirements.
• Developed various Script Logic and Member formula Calculations required for generating EPM Reports
• Developed various Input Forms and Reports using EPM Functions and VBA Macros.
• Work with business owners to understand requirements, design and maintain financial reports in BPC
• Perform unit testing of EPM reports and templates, support the creation and maintenance of data input templates using the EPM Add-in
• Responsible for immediate BPC production issues, work with a diverse and integrated team consisting of application developers, technical business users and business analysts
• Configured Work Status for locking the data for required periods
• Create unit testing scenarios and resolve/trouble shoot issues identified during testing.
• Develop reports: Consolidated Balance Sheet, Income Statement reports (monthly and quarterly), Cash flow report, Gross Profit report, Intercompany report, SG&A reports (by Department, by Product Line), COGS details report etc.

Confidential

BPC Consultant

Responsibilities:

• Conducted Workshops in EPM10 Features
• Successfully lead Pivotal implementation of Consolidations in EPM10
• Designed and built consolidation system business Rules, Advance Script Logic and Journals.
• Built consolidation model / Ownership and Rate Model
• Configured Intercompany and Currency Translations
• Configured Ownership model
• Developed many reports and input schedules
• Developed Security, Work Status and Interfaces to ECC.
• Success fully performed Book Functionality
• Supported and developed Training Material and various Test Plans

Confidential

SAP BPC Technology Consultant

Responsibilities:

• Handled Master data from BW to BPC dimensions, as well as CO-PA extractions into the Finance Model.
• Handled Transaction data from BW to BPC, which includes Exchange Rate Data.
• Handled transaction data from Flat File to BPC using data manager package, transformation and conversions files.
• Developed Script logic for Account-base Calculations.
• Developed of Reports and Input Forms: Exchange rate report, Balance Sheet Report, Income Statement Report and IC elimination verification Report, and Segment Reporting With sales.
• BPC Architect for Cash Flow/Balance Sheet planning Application, and Income Statement.
• Worked as a Solution Architect on a highly complex Consolidation project initiative.
• Worked as a mentor/coach on the recreation of financial and managerial reports
• Improved the performance of multiple folds by optimizing Input Schedules and logic calculations

Confidential, Austin, TX

BPC Solution Architect

Responsibilities:

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