PROFESSIONAL SUMMARY:

• Over 9 years of professional experience including SAP BPC, BW, and financial services for various types of industries.
• Experienced in all aspects of teh SAP implementation lifecycle and a solid grasp of teh ASAP methodology.
• Highly skilled in designing Functional, Technical specifications and process implementation roadmaps for business requirements.
• Strong skill set in SAP EPM 10.0NW, BPC 7.5 NW - MS, 7.0NW wif SAP BI 7.3 & BI 7.0.
• Experience in BPC includes 2 End to End Implementation projects in EPM 10.0 NW, 3 End to End Implementation projects in 7.5NW,1 End to End implementation in SAP BPC 5.1 MS to SAP BPC 7.5NW migration, 1 Enhancement/Production Support in 7.5NW
• Excellent Understanding on BW-BPC Integration process and a solid understanding and experience of BPC functionalities - both Planning and Consolidations (business rules, script logic, journals, input schedules, reports, BW integration for master & transactional data etc.).
• Expertise in SAP BPC includes - Application sets, Applications, Dimensions, BPC security set up, Script Logic, Loading and Validating data, DM Packages, BPC for Excel, Work Status, BPC process flows, Journals and Performance Tuning Best Practices.
• Hands on experience in setting up of all teh business rules including - Account Transformation, Carry-Forward, IC Eliminations, Validations, Currency Translations, Allocations and IC Matching/Booking.
• Hands-on experience in creating EVDRE reports and input schedules and teh best practices related for efficient performance.
• Expert in Automation of all BPC Data Loads via BW ETL or Package Links.
• Experienced in BW Upgrade and Performance Tuning in BI/BW.
• Involved in multiple Full life cycle Implementations dat includes business process prototyping, configuration, testing and validation, go live, production support and training.
• Worked on building Universes on BEx Queries and Reports generation using Crystal Reports.
• Worked on BW Report Design, Query Design, KPI Reporting, Testing and Performance Tuning.
• Well versed in gathering business requirements, identifying and resolving difficult issues.
• Experienced in teh ASAP methodology, procedures of SAP R/3 implementation and have an excellent understanding of teh best Business Practices.
• Excellent troubleshooting, analytical, problem resolution and organizational skills.
• Excellent team player wif good communication and interpersonal skills.
• Development of Driver-Based Performance Management tool dat offers accurate picture of expected future business performance by incorporating assumptions about business activities which are modeled to drive financial data such as revenue projections, headcount, spending and capital requirements
• Development of End-to-End Legal Consolidation project involving, Inter Company elimination matching,, Inter Company elimination booking, Inter Company elimination, validations and complex foreign exchange translations
• Experience in designing and implementation of revenue and expenses forecasting models and reporting. Designed Application set, Application, Dimensions, built reports and input schedules.
• Two and half years of professional experience in accounting and finance wif expertise in auditing, internal controls, accounting policies (GAAP), and financial analysis & reporting
• Extensive experience in developing risk-based audit plans, managing audit engagements to desired objectives and deadlines, and reporting findings and recommendations to relevant parties

TECHNICAL SKILLS:

• SAP Business Objects Planning& Consolidation (BPC) MS 5.1,7.0&7.5, NW 7.0, 7.5
• SAP Business Intelligence (BI)
• Business Solution Architecture
• Web Services
• Data Architecture
• Business Analytics & Reporting
• Performance Testing (Volume, Stress and Load)
• Microsoft SQL Server, SSIS and DTS Packages
• Windows 2003/2000/ XP, Solaris 8.0, LINUX 7.3, 8.0.
• HTML, DHTML, XML, JavaScript, XI, Net Weaver
• MS-Office, Remedy, HPQC

PROFESSIONAL EXPERIENCE:

Confidential, Holly Spring, NC

Forecast Implementation/Support

Responsibilities:

• Successfully set up SAP EPM 10.0 NW for detailed Planning, Budgeting, and forecasting for leveraging teh existing data warehousing infrastructure
• Gatheird all teh business requirements and designed teh data model for Budget and Forecast
• Created DM Packages to load Master and Transactional Data into BPC Dimensions and Applications respectively. Worked extensively wif 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 wif combination of EPM add-in and excel based formulas and along wif 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 teh transaction data from different models
• Created multiple Input Templates using Excel interface of EPM add-in to submit teh data to different models wifin 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 teh data and developed Dimensions and its properties to suit teh complete operations of teh planning process at teh Client site
• Developed Financial Planning and Forecasting models, involving multiple sets of Input scheduling templates
• Hands on experience in setting up of all teh 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 teh data validation wif SAP BPC and SAP BI and created many test script for testing and training purpose
• Created Technical Documents (TD) and Functional Documents (FD)
• Set up security network for Financial Planning through developing member and task assignment profiles and assigning them to members and teams.
• Configured data manager extraction from ECC and BI system for teh actual, plan data
• Maintained and extracted Master Data from SAP BI system using data manager packages
• Performed teh integration testing and prepared teh test scripts
• Executed teh optimization tool for lite and full optimization
• Prepared teh documentation on teh input template and data extraction of planning requirements
• Detailed Training Guide is prepared and hands-on training provided to teh Super Users and Star Users

Confidential, Hershey, PA

Innovation & Supply Chain Planning

Responsibilities:

• Successfully set up SAP EPM 10.0 NW for detailed Planning, Budgeting, and forecasting for leveraging teh existing data warehousing infrastructure
• Gatheird all teh business requirements and designed teh 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 wif 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 wif combination of EPM add-in and excel based formulas and along wif 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 teh transaction data from different models
• Created multiple Input Templates using Excel interface of EPM add-in to submit teh data to different models wifin 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 teh data and developed Dimensions and its properties to suit teh complete operations of teh planning process at teh Client site
• Developed Financial Planning and Forecasting models, involving multiple sets of Input scheduling templates
• Hands on experience in setting up of all teh 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 teh data validation wif SAP BPC and SAP BI and created many test script for testing and training purpose
• Created Technical Documents (TD) and Functional Documents (FD)
• Set up security network for Financial Planning through developing member and task assignment profiles and assigning them to members and teams.
• Configured data manager extraction from ECC and BI system for teh actual, plan data
• Maintained and extracted Master Data from SAP BI system using data manager packages
• Performed teh integration testing and prepared teh test scripts
• Executed teh optimization tool for lite and full optimization
• Prepared teh documentation on teh input template and data extraction of planning requirements
• Detailed Training Guide is prepared and hands-on training provided to teh Super Users and Star Users

Confidential, Plymouth, MI

Planning, Budgeting, Forecasting and Reporting

Responsibilities:

• Created DM Packages to load Master and Transactional Data into BPC Dimensions and Applications respectively. Worked extensively wif Copy, Move and Optimization Packages
• Used Advance scripting to call Script logic Files, to customize selection screens, Passing parameters etc,
• Created complex Transformation files and Conversion files to meet Business data needs. Transformation files included Start and End Routine BADIs
• Created process chains to automate loading of data from BW to BPC system
• Data in BPC is transformed using custom ABAP Programs, Start Routines, End Routines and Expert Routines
• Created Custom Menu to provide one stop access for all Input Schedules and Reports to Business users
• Created Reports and Input Templates using Excel Interface of EPM add-in
• Created custom measure for complex Avg Working Capital and Avg Trade Working Capital
• Created Account Transformation for Calc Account
• Created and supported EVDRE/EPM built on Sales App, IFP App and Material App. Created custom Macros for Submitting and Refreshing data, Auto Column Width and Hide/Display Column
• Created complex Input Templates and Reports using Excel interface of EPM add-in wif combination of EPM add-in and excel based formulas and along wif 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 teh transaction data from different models
• Created multiple Input Templates using Excel interface of EPM add-in to submit teh data to different models wifin environment
• Provided training to business users to how to create reports and templates using Excel interface of EPM add-in
• Hands on experience in setting up of all teh business rules including - Account Transformation, Carry-Forward, Validations, Currency Translations, and Allocations
• Responsible for preparing teh “How-To” Documents for various activities teh end-user performs in BPC and conducting training sessions to halp them understand and explain teh functionality of teh new environment and teh BPC Terminology such as Name space, Application sets, Applications, Dimensions, Dimension members, Properties, Hierarchies, Functionality of Data manager, Optimization process and BPC Front end such as BPC for Excel and BPC Web.
• Developed a BPC/BW interface dat exports BPC Budgeting and Forecast data into a BW Sales Planning Info cube, using an Export Query, Application Process Designer (APD), and Direct-Update Data Store.
• Created a Custom DSO in BW to hold Actual/Plan/Forecast Data for Management Reporting purposes.
• Responsible for teh daily automated/flat file data loads from BW to BPC and data retraction from BPC to BW.
• End to End configuration of BW and BPC security. Extensively worked on Analysis Authorizations, Setting up Roles, Authorization Objects (at Info-Provider, Field and Reports levels), Member Access Profiles and Task Profiles.

Confidential, Roswell, GA

Planning, Budgeting, Forecasting and Reporting

Responsibilities:

• Successfully set up SAP EPM 10.0 NW for detailed Planning, Budgeting, and forecasting for leveraging teh existing data warehousing infrastructure
• Created DM Packages to load Master and Transactional Data into BPC Dimensions and Applications respectively. Worked extensively wif Copy, Move and Optimization Packages
• Used Advance scripting to call Script logic Files, to customize selection screens, Passing parameters etc,
• Created Reports and Input Templates using Excel Interface of EPM add-in
• Created custom measure for complex Avg Working Capital and Avg Trade Working Capital
• Created Account Transformation for Calc Account
• Created complex Input Templates and Reports using Excel interface of EPM add-in wif combination of EPM add-in and excel based formulas and along wif 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 teh transaction data from different models
• Created multiple Input Templates using Excel interface of EPM add-in to submit teh data to different models wifin 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 teh data and developed Dimensions and its properties to suit teh complete operations of teh planning process at teh Client site
• Developed Financial Planning and Forecasting models, involving multiple sets of Input scheduling templates
• Hands on experience in setting up of all teh 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
• Maintained teh Cost Centers manually in BPC as Cost Centers are time dependent in BI system
• Tested teh data validation wif SAP BPC and SAP BI and created many test script for testing and training purpose
• Created Technical Documents (TD) and Functional Documents (FD)
• Set up security network for Financial Planning through developing member and task assignment profiles and assigning them to members and teams.
• Developed many reports including Trend, Variance, Drill down and Rank templates
• Configured data manager extraction from ECC and BI system for teh actual, plan data
• Maintained and extracted Master Data from SAP BI system using data manager packages
• Provided go live support for SAP BPC 7.5 MS for GSA planning and forecasting
• Prepared multiple complex static and expansion reports using EVDRE, EVPRO, EVGET, EVHOT, and other functionalities as part of go live support for BPC 7.5 MS
• Created multiple reports to perform drilldown to see teh summary level data at dependent and base level members
• Performed teh integration testing and prepared teh test scripts
• Executed teh optimization tool for lite and full optimization
• Prepared teh documentation on teh input template and data extraction of planning requirements
• Detailed Training Guide is prepared and hands-on training provided to teh Super Users and Star Users

Confidential, Portland, OR

Driver Based Planning and Reporting

Responsibilities:

• Responsible for preparing teh “How-To” Documents for various activities teh end-user performs in BPCand conducting training sessions to halp them understand and explain teh functionality of teh new environment (BPC 7.5NW) and teh BPC Terminology such as Name space, Application sets, Applications, Dimensions, Dimension members, Properties, Hierarchies, Functionality of Data manager, Optimization process and BPC Front end such as BPC for Excel and BPC Web.
• Developed Custom Script Logics to automate loading of Plan Data from teh Planning (Financial) Application to Consolidation Application and to calculate various KPI’s.
• Developed a BPC/BW interface dat exports BPC Budgeting and Forecast data into a BW Sales Planning Info cube, using an Export Query, Application Process Designer (APD), and Direct-Update DataStore.
• Created a Custom DSO in BW to hold Actual/Plan/Forecast Data for Management Reporting purposes.
• Resolved inconsistency issues wif BADI UJ CUSTOM LOGIC when accessing a BPC application wif a large data set (SAP BPC 7.5NW SP6)
• Developed a BPC/ECC interface dat exports BPC Budgeting data into ECC via an Application Server wif Query Extract using RSCRM BAPI.
• Extensively used UJD TEST PACKAGE to automate and trigger teh BPC Master, Hierarchy and Transaction Data Loads from BW back-end.
• Maintained teh business rules for Currency translation, Intercompany Eliminations, Validations, Account Transformations (for Cash Flow) and troubleshot issues and errors.
• Created EVDRE reports and input schedules including teh use of teh option and formatting range and implemented a wide variety of EV functions such as EvDES, EvSUM, EvSUB, EvCOM, EvHOT, EvPRO, EvMBR, etc.
• Extensively worked on P&L, Cash Flow and Trial Balance Reports and Input Schedules.
• Configured Journals and troubleshot issues wif templates and entries while Copying, Reopening Journals and while copying Application Set (SP5).
• Configured Drill-Through to both ECC and BEx Queries.
• Configured BPC-BW-ECC interface to load budget data into ECC on a quarterly basis.
• Developed a custom measure - TTM (Trailing 12) in both Periodic and YTD Applications using UJA MAINTAIN MEASURE FORMULA for reporting purposes as per Business Requirements to view teh data on a Trailing 12 month basis.
• Extensively worked wif Logic and Business Rules to do on teh fly as well Application level calculations which include Days Sales Outstanding, Working Capital etc.
• Extensively worked wif end-users to fix teh performance issues wif existing EVDRE’s and create new reports based on teh best practices.
• Hands on experience and extensively worked on Security to limit teh access to teh users based on secured dimensions, tasks they perform depending on their roles. Primarily responsible for managing security and teh Go-To person for any security related issues.

Confidential, San Jose, CA

Driver Based Planning and Reporting

Responsibilities:

• Successfully set up SAP BPC 7.5 NW for detailed Planning, Budgeting, and forecasting for leveraging teh existing data warehousing infrastructure
• Prepared process Definition Document (PDD), Report definition Document (RDD) for teh planning, budgeting and forecast processes
• Prepared project blue print, road map & standards for implementing BPC platform.
• Actively involved in gathering teh requirements, technical & functional specifications for teh business process for Financial Planning
• Developed Applications for Financial Planning, Revenue Planning, and HR Planning
• Carefully analyze teh data and developed Dimensions and its properties to suit teh complete operations of teh planning process at teh Client site
• Developed Financial Planning and Forecasting models, involving multiple sets of Input scheduling templates, including Inventory adjustment, Warranty Costs, Cash Flow, Employee Grades template, Employee Salary Caps template and Employee hiring Input schedules
• Developed Script logic for complex calculations
• Created default logic for calculating revenue from sales unit prices in BPC
• Designed transformation and conversion files for synchronizing incoming data from SAP BI/ ECC systems into BPC.
• Set up security network for Financial Planning through developing member and task assignment profiles and assigning them to members and teams.
• Developed many reports including Trend, Variance, Drill down and Rank templates
• Tested teh data validation wif SAP BPC and SAP BI and created many test script for testing and training purpose
• Created Technical Documents (TD) and Functional Documents (FD)
• Configured data manager extraction from ECC and BI system for teh actual, plan data
• Performed teh integration testing and prepared teh test scripts
• Executed teh optimization tool for lite and full optimization
• Prepared teh documentation on teh input template and data extraction of consolidation and planning requirements

Confidential, Cheshire, CT

SAP BP

Responsibilities:

• Prepared strategy, scoped, collected business requirements, analyzed teh process to be modeled
• Created Business Requirements Document (BRD) and Business Design Document (BDD) for Financial Planning, Budgeting and Forecasting
• Designed question tracker for gathering data from various business owners and analyzed teh responses to build business process model for financial planning.
• Created Finance application and Rate application in BPC for Financial Planning, Budgeting and Forecasting
• Designed Dimensions to capture teh Financial Planning & Processes of teh Client, incorporating teh performance
• Created teh new hierarchies, additional properties for teh purpose of complex reporting and forecasting
• Created conversion and transformation files to upload Master Data and transactional data from SAP BI
• Responsible for preparing teh “How-To” Documents for various activities teh end-user performs in BPC and conducting training sessions to halp them understand and explain teh functionality of teh new environment (BPC 7.5NW) and teh BPC Terminology such as Name space, Application sets, Applications, Dimensions, Dimension members, Properties, Hierarchies, Functionality of Data manager, Optimization process and BPC Front end such as BPC for Excel and BPC Web
• Maintained teh business rules for Currency translation, Intercompany Eliminations, Validations, Account Transformations (for Cash Flow) and troubleshot issues and errors.
• Extensively used UJD TEST PACKAGE to automate and trigger teh BPC Master, Hierarchy and Transaction Data Loads from BW back-end.
• Created teh drill through using BPC Admin, to Business Explorer Analyzer
• Executed teh optimization tool for lite and full optimization
• Developed Custom Script Logics to automate loading of Plan Data from teh Planning (Financial) Application to Consolidation Application and to calculate various KPI’s.
• Developed several Input Schedules and Reports using EVDRE functionality to forecast and Budget Income Statement and Balance Sheet, Cash flow
• Created Dimension Logic and advanced script logic while calculating planning numbers
• Created standard input schedules for posting forecast data at entity level for all business users and power users for Expense, Revenue, Revenue Headcount and Quantity
• Designed templates for complex reports using EVDRE functionality
• Created several Trend, Variance, and comparison report templates
• Performed Foreign currency translations
• Extensively worked on security set up creating various task profiles and member access profiles to allow several users to perform various tasks and access certain data sets
• Customized teh work states to track and lock actual and plan data after teh month-end closure
• Developed data loading strategies for master data, transactional data and delta uploads using DTP’s
• Extensively worked on Query Designer, BEX Analyzer 7.0 and Web application designer (WAD)to create Queries for all actual reports
• Designed test scenarios while Unit testing; Functional & Integrated testing is done and sign off obtained from teh Business Owners
• Prepared teh documentation on teh input template and data extraction of planning requirements
• Detailed Training Guide is prepared and hands-on training provided to teh Super Users and Star Users

Confidential, Atlanta, GA

SAP BPC Consultant

Responsibilities:

• Responsible for interacting wif functional consultants & users to write teh technical specifications based on Functional specifications, BPC & BW Development(Modeling, ETL, Reports Generation & Broadcasting) Unit test documentation, Test Cases and test scripts for Integration testing and UAT, KT and giving end user training.
• Extensively used Revenue and P&L Applications used for Revenue and Expense planning.
• Developed a Custom Logic BADI to automate teh loading of Data from CONSOL Application to FINAN Application.
• Prepared Process Definition Document’s (PDD), Report Definition Document’s (RDD) for teh planning, budgeting, and forecasting.
• Configured data manager packages by extracting data from BI system and legacy systems like ACE400 for teh actual data and historical data.
• Extensively used BW ETL process and Data Package links for Master and Transaction Data Loads to teh BPC Application.
• Extensively used conversion and transformation files for teh data management process.
• Created Actual Plan comparison reports, Revenue by Customer, Expense by Account and By Site Variance Analysis reports using templates and EVDRE function. Created Flash reports, Trend analysis and consolidated reporting in Group currency - USD and CAD.
• Maintained teh business rules for Currency translation.
• Worked on setting up Security and Audit settings.
• Implemented Business Process Flows for Period End closing activities.
• Developed custom Info Objects, Master Data Objects, DSOs, Info Cubes, Multi Providers and Info sets.
• Created and activated Transformations (both DSO and Info Cube level) and wrote start routines and transformation routines.
• Developed Customer Exits to enhance teh standard GL, AP and AR Data Sources which include 0FI GL 14, 0FI GL 20, 0FI AR 4 and 0FI AP 10.
• Enhanced teh existing Info Providers by creating Custom data sources to merge teh data from Versa cold into Americold to maintain uniformity in Data Warehousing Solutions.
• Worked extensively on BEx Query Designer, Web Application Designer and used BEx Analyzer in building Queries, Charts and saving in Workbooks (Excel work Sheets) and created Custom Queries including teh Ageing Reports using Conditions, Exceptions, RRI, Variables and Structures.
• Reports generated in AP and AR included ageing reports - Overdue Analysis and Overdue Items by customizing teh standard SAP solutions 0FIAP M30 Q002 and 0FIAR M30 Q002.
• Designed, developed and broadcast queries and workbooks.
• Used multiple queries in workbooks (BEx Analyzer, Query Designer, Variables, and Restricted & Calculated Key Figures).
• Created Process Chains for Master Data & Transaction Data to run teh daily data loads.
• Responsible for transporting ECC & BW objects from Dev to Q, validating teh objects and transporting them to Production Environment.
• Interacted wif Power users by providing demo and user training on how to use teh various BI reports and BEx tools.
• Worked on go-live cut over plan activities and successfully handled & solved teh Post Go Live issues.

Confidential, New York, NY

Experienced Associate

Responsibilities:

• Reviewed client’s financial statements and footnotes to ensure conformance wif applicable literature
• Managed audit-test and reviews, communicated wif client, and teh issuance of financial statements
• Conducted SAS70 (Type II) reviews for a large client engaged in Transfer Agency business
• Performed testing of controls to certify compliance wif SOX section 404
• Generated clear and concise preliminary and summary documents for engagements, wif documentation including analysis of technical issues, business overviews, significant accounting and auditing issues, and conclusions reached upon performance of procedures
• Evaluated clients’ internal control systems, identified weaknesses and developed recommendations
• Supported managers in teh planning, testing, and sampling methods involved in conducting audits
• Managed projects by setting up goals and deadlines for teh team while providing weekly updates to teh client
• Investigated and evaluated operations and management controls; confirm material facts relating to material account balances; assess potential risk associated wif account balances, industries, and specific clients.
• Supervised two associates in performing teh substantive tests-of-detailsLead engagement meetings both internal and wif clients
• Maintained and established TEMPeffective work relationship wif team and clients for efficient performance
• Mentored new associates about audit performance of teh clients and industry
• Analyzed teh trial balances of teh supporting audit schedules for Mutual Fund Investment audit team, by cross examining teh entire set of financial statements including footnotes
• Tested internal controls of teh client and communicated controls to teh other team members
• Prepared reports after gathering, analyzing, and evaluating facts