We provide IT Staff Augmentation Services!

Sap Bpc Metrics Consultant Resume

SUMMARY:

  • Certified and experienced SAP BPC Developer (with SAPFI Functional development experience) on multiple platforms, including S/4 HANA, NetWeaver and Microsoft SQL; BPC on HANA platform and Embedded BPC for Pilot developments; SAP BPC Planning Embedded; SAP BPC Optimized for SAP S/4 HANA
  • Seasoned Functional SAP BPC Data Analyst with 10+ years of progressive OutlookSoft/SAP BPC MS and SAP BPC Netweaver with multiple full cycles with post go - live supports and Proof of Concepts (POCs) or Prototypes and 5 upgrades experiences in SAP BPC Implementation with Post-Go Live Support; SAP BPC Notes (OSS) Management and Hot Fixes
  • Functional understanding of BW, HANA and it’s integration with BPC
  • Data Cleansing, Matching and Analysis, Business Operations Analysis, Cost, Financial Budgeting, Planning, Accounting, Forecasting and Corporate/Customer Reporting, Metadata Management
  • An individual contributor and committed team player with proven ability to meet and exceed goals and deadlines and have built a collaborative team relationship with all employees at various levels.
  • Demonstrated ability in customizing and analyzing complex financial application projects and able to learn and apply new concepts quickly.
  • Excellent analytical, problem solving and writing skills with ability to adjust easily to innovative concepts and tasks including Gap-Fit Analysis; Impact Analysis
  • SAP BPC 10.1 on HANA Proof of Concept (POC) & Implementation
  • SAP BPC 11.0 (Ongoing)

SAP SKILLS SUMMARY:

Application: SAP BPC Embedded Model; SAP BPC optimized for S/4 HANA Finance 1610; SAP BPC 7.5, SAP EPM 10.0, SAP EPM 10.1,SAP ECC; SAP FI configuration - GL. AR, AP, Asset Accounting, PCA, CCA;SAP BPC 7.5,10.0 and 10.1 versions on SAP NW Platform (with BW Integration) and Microsoft Platform; SAP BPC 7.0/7.5 Migration and Upgrade from Oracle Hyperion Essbase (HFM) to EPM 10.0 and 10.1 versions

Skills: Implemented the BPC/EPM RDS solutions across multiple versions including S/4 HANA 1103 and 1610; Report and Input Schedule Development and Modeling; Book Publications; Script Logic; ETL; BPC Hot Fixes; BPC Reports Publications; IFRS, SEC, GAAP, STAT and XBRL Reporting; Financial and Accounting Modeling; Financial Planning; SOX Controls; SOX Compliance; Data Migration; Profitability Analysis; Data Extraction, Transformation and Conversion; Master Data Management (MDM); Data Cleansing and Validation; Data Manipulation and Analysis, Shared Services, SAP Application User Acceptance and Support; Data Mining, Data Quality- Process Improvement; ABAP Custom Tests and Validations; Valuation Maintenance VBA Macros; MS Office Suite (Excel, Access, PowerPoint, Visio, Word, and Outlook)

BPC Models: Planning Financial Statements (Finance), Management Reporting, Operations Expense Planning (OpEx), Capital Expenditure Planning (CapEx), Driver-Based Planning, Revenue and Income Planning, Manpower Planning, SGA, HR Headcount Planning and Reporting, Consolidation Reporting, Sales Planning, Employee Planning and Cost Center Planning; Consolidations

PROFESSIONAL EXPERIENCE:

Confidential

SAP BPC Metrics Consultant

Responsibilities:

  • SAP BPC 10.1 on BW Reports and Metrics Developments in Finance Model
  • Developed multiple Manual Input Schedules and Reports for the FP&A team across multiple company divisions

Confidential

Sr SAP BPC 10.1 Developer

Responsibilities:

  • Upgraded, Developed and Configured SAP BPC 10.1 on Microsoft Platform from Hyperion Essbase to SAP BPC 10.1
  • Gathered and accessed existing Essbase reports and group reports to maximize Total Cost of EPM Ownership (TCO)
  • Design and developed script logics for Consolidation model and Data loading
  • Conducted SAP BPC s for Confidential internal EPM developers, provided materials using actual company’s business scenarios
  • Designed and built highly complex reports in BPC
  • Tested and Validated reports with the FPA and Consolidation team within Confidential Corp
  • Production Support

Confidential

Sr SAP EPM Consultant

Responsibilities:

  • SAP BPC 10.1 NW Embedded Planning for multiple models
  • Gathered reporting requirements from client
  • Loaded Master and Transactional data from SAP & Non-SAP Sources to BPC cube
  • Design and developed script logics for various data recalculations and needs
  • Tested and Validated reports with the FPA and Consolidation team within Confidential Corp
  • Supported client during production and post go-live

Confidential, Dayton, OH

Sr SAP BPC Consultant

Responsibilities:

  • Created project plan and resource schedule
  • Liaison with Data Integration (SAP BW) team in ETL-related activities
  • Designed and built highly complex reports in BPC using SAP best practices to optimize performance
  • Developed business rules and associated script logic
  • Developed re-class and other required input forms to meet business needs
  • Mentored other SAP BPC resources on the Implementation team during non-productive time
  • Organize & provide admin to BPC Administrators (Train the trainer)
  • Assisted with the UAT process

Confidential, Oakbrook, IL

SAP BPC Consultant

Responsibilities:

  • Provided and updated documents for end users for the new system
  • Upgraded and converted business reports and input schedules from SAP BPC version 7.5 to 10.0
  • Developed and configured Reports and Input Forms for business processes evaluations as stated in requirements

Confidential, Providence, RI

SAP BPC Consultant

Responsibilities:

  • Recommended solutions aligned to Confidential ’s Information Systems’ technology strategy and standards
  • Configured and customized the BPC system to attain the desired functionality for the Proof of Concept Analysis.
  • Analyzed, designed, developed, implemented, and supported dynamic SAP BPC NW and SAP ECC Reporting sample solutions for multiple Business Units using SAP BPC reports distribution functionalities(Reports and Input templates and master reports)
  • Customized complex BPC reports to align with clients’ ps for both Planning and Business subsidiary consolidation solutions

Confidential, New Haven, CT

SAP BPC Consultant

Responsibilities:

  • SAP BPC Post Go-Live Support for SAP BPC 7.5 to SAP BPC 10.0, 10.1 NetWeaver Platform
  • Upgraded and updated the SAP BPC Security sub-modules to reflect prior SOX standards setup in old 7.5 version for all users
  • Migrated SAP BPC data from the BI cubes from the older SAP BW 7.3 NW platform to SAP BW 7.4 NW platform
  • Tested and validated cleansed data for initial Consolidation data in the new EPM 10.0 BPC report cubes
  • Participated and facilitated requirements gathering sessions
  • Worked with business partners to develop test scripts for unit and integration testing
  • Performed unit and integration testing on Development and Quality Assurance prior final import to Production
  • Assumed active role in managing the monthly Financial Planning update cycle

Confidential

SAP EPM Consultant

Responsibilities:

  • Implemented multiple SAP BPC 10.0 Standard-, Financial-typeModels: Expenses, General
  • Ledger, Management Reporting, Analytics, Rates for the client on the SAP NW platform
  • Imported transactional data, Master data, and Hierarchies from BW to BPC cubes using specific, modified and applicable Data Manager packages
  • Assisted with Application functionality after Go-Live, understood issues and assist users with resolution
  • Worked with the Finance department team, FP&A Grouping recommending SAP BPC best practices with respect to business needs
  • Developed complex Financial Reports and Input Schedules for multiple SAP BPC Applications from multiple data sources. Financial Reports varies from Trended, Comparison to Consolidation types. Input Schedules or Forms are developed for Manual Adjustments for Financial Data coming from different Data sources
  • Proactively worked with business end users in designing and modifying Reports and Input Schedules to meet specified requirements in the area of Financial Reporting, Planning and Budgeting
  • Contributed and participated in internal knowledge base documents geared towards other consultants and clients on the latest version of SAP BPC, EPM 10.0
  • Trained, wrote and prepared desktop directions on how run an VBA Macro-Embedded Financial Live Reports
  • Configured Book Publication templates for financial statements reports for upper management team, General Accounting and FP&A groups, etc.

Confidential, Cleveland, OH

SAP FI/BPC Consultant

Responsibilities:

  • Created Company Code, Business Areas, Chart of Accounts, GL A/c masters, Number ranges, and Screen lay out for document entry for sample and parked documents. Created Vendor masters, Customer masters, Tolerance groups
  • Prepared Revenue Accounts and Assignment of GL Accounts
  • Involved with designing the tax solution for 3 European countries and 2 North American countries in the SAP FI module
  • Defined the Tax procedure and its integration with the Accounting system.
  • Worked in a team responsible for the SAP Post Go-Live and stabilization phase
  • Worked with the BPC Manager reporting through the Finance department and the implementation team to rollout Business Planning; Contributed to architecture discussions
  • Perform technical activity for BPC (reports, workflow, etc.); Assisted BW resources in identifying and development necessary for BPC integration to BW
  • Proactively worked with business users to define functional requirements in areas of finance/financial planning, accounting, budgeting and forecasting. Performed system application analysis tasks to review, identify, develop, and recommend designs, modifications and new functionalities
  • Developed financial planning & forecasting models; Collected and aggregated forecast data and developed customized forecast reports for both senior level financial and operational management
  • Created 7.5 EVDRE reports, Input Schedules; worked closely with business users to design and extend functionality within BPC.
  • Worked with to design, implement, and support of budgeting and planning application set. Assisted in the creation of a Consolidated Financial reporting application set

Confidential, Chicago, IL

Sr. Financial Data Consultant

Responsibilities:

  • Prepared and Analyzed the SG&A budgeting, forecasting and analysis process for Life Products business units
  • Conducted monthly variance analysis and reporting for assigned the Financial Securities business units
  • Reviewed the SOX portal internal control documentation and control test results updated by the Shared Services Organization
  • Developed the Visio Flow Charts for the Combo Edits and Background Data Quality Fixes processes for other members of the Data Management Consultant (DMC) team and new hires - New hires and less experienced analysts were efficiently coached and lead while a positive, open team environment were fostered with help of detailed and resourceful Visio flow

Confidential, Chicago/Downers Grove, IL

Sr. Financial/Cost Accountant

Responsibilities:

  • Responsible for bi-monthly Purchasing Price Variances, PPV analysis with Actual Unit Cost and Standard Unit Cost calculations
  • Automated month-end COGS journal entries reducing closing cycle by more than a half day.
  • Improved and reduced the turnaround time for monthly financial reports by optimizing available applications and processes using SAP-based Essbase
  • Calculated and Allocated Material, Labor, and Burden Costs; Look up and assign Product Codes to jobs reported on VISTA with no Product Codes; Misrepresentation of Standard Costs were eliminated

Confidential, Northbrook, IL

Sr. Financial/Valuation Analyst

Responsibilities:

  • Prepared the monthly and periodic GAAP, Stat, and Tax periodic closes for Payout annuities: GICs, MTNs, FA, GISA, IFA and other Payout Annuities. Result was an error-free interfaced bookings of Benefits Reserves for In force policies
  • Developed the Financial Models needed for the Actuarial Data and Modeling Strategy (ADAMS) project
  • Recreated the DAC (Deferred Acquisition Cost) process before the unlock; New design revealed the financial impact of expenses on revenue before booking deadline
  • Reviewed data for accuracy, recommendations, and adjustments/corrections.
  • Results were a 30% shortening of the monthly reporting cycle and a $12,000 annual reduction of temporary staffing expenses.
  • Prepared monthly, quarterly, and annual financial information including product, customer profitability and capital usage

Hire Now