We provide IT Staff Augmentation Services!

Microsoft Office Excel Expert Resume

SUMMARY

  • Certified and experienced SAP BPC and SAP FI Functional Developer on multiple platforms, including 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 9 years 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
  • 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

TECHNICAL SKILLS

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 & CO configuration - GL. AR, AP, Asset Accounting, PCA, CCA, IO, COPA; 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; Data Management; 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

Microsoft Office Excel Expert

Responsibilities:

  • Financial Management Association (Member since 1999)
  • Global Association of Risk Professionals (GARP)(Member since 2002)
  • Project Management International (PMI) (Member since 2010)
  • Association of SAP Users’ Group (ASUG) (Member since 2012)

Confidential

SAP BPC Metrics Consultant

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 trainings for Associated Bank Corp internal EPM developers, provided training 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 Associated Bank 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 Associated Bank 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 training to BPC Administrators (Train the trainer)
  • Assisted with the UAT process

Confidential

SAP BPC Consultant

Responsibilities:

  • Provided and updated training 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

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’ preferences for both Planning and Business subsidiary consolidation solutions

Confidential

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

Hire Now