Sheraz Mehmood

Experience

1. SAP Business Intelligence Consultant

   SAP

   Jan 2010 — Present · Atlanta, GA, US

   Successfully set up SAP EPM 10.0 NW for detailed Planning, Budgeting, and forecasting for leveraging the existing data warehousing infrastructure • Gathered all the business requirements and designed the data model for HCM Planning and Innovation planning model • Created DM Packages to load Master and Transactional Data into BPC Dimensions and Applications respectively. Worked extensively with Copy, Move and Optimization Packages • Created Reports and Input Templates using Excel Interface of EPM add-in • Created complex Input Templates and Reports using Excel interface of EPM add-in with combination of EPM add-in and excel based formulas and along with VBA coding • Created Input Schedule for Inter Company Volume Transfer which submits and refreshes data based on user entered comments • Created Reports using Excel interface of EPM add-into pull the transaction data from different models • Created multiple Input Templates using Excel interface of EPM add-in to submit the data to different models within environment • Provided training to business users to how to create reports and templates using Excel interface of EPM add-in • Created process chains to automate loading of data from BW to BPC system • Carefully analyze the data and developed Dimensions and its properties to suit the complete operations of the planning process at the Client site • Developed Financial Planning and Forecasting models, involving multiple sets of Input scheduling templates • Hands on experience in setting up of all the business rules including – Account Transformation, Carry-Forward, Validations, Currency Translations, and Allocations • Developed Script logic for complex calculations • Designed transformation and conversion files for synchronizing incoming data from SAP BI/ ECC systems into BPC • Created data load automation for transaction data from SAP BI system to SAP BPC • Tested the data validation with SAP BPC and SAP BI and created many test script for testing and training purpose

Education

• University of the Punjab

  Masters, MBA

  1997 — 2005