Summary

• • • Which includes 5 years of SAP BPC NW EPM experience with 2 full - life cycle implementations and experience in Planning, Forecasting, Budgeting and Financial Consolidation
    • 3 years of SAP BI/BW experience with one full life cycle efforts to design, analysis, Blue printing, technical specification, implementation, Go-Live and deployment of BW solutions and support processes
• Strong experience in SAP BPC 10 NW and BPC 7.5 NW. Worked on SAP EPM 10.0 NW Planning Budgeting Forecasting and Consolidation
• Created Reports and Input Schedule using EPM 10 Excel Add-in, Analysis for Office and worked on SAP BPC 7.5 NW Planning/Budgeting/Forecasting implementation from Blueprint to implementation and going live
• Trained on BPC 10.1 Embedded Version and made experience on Analysis for Office
• Designed and developed EPM solutions for Financial, Headcount, CAPEX planning
• Advanced VBA expertise in reporting for custom formats and dynamic updates
• Created Customer specific Environment and Required Models as well as other Reference Models
• Defined and configured Appsets, Application, Dimensions, Dimension Members and their properties
• BPC Security Configuration, Creation of member access profile, Task profile creation, Team creation and Full integration
• Created ETL flow for extraction of Actual data from ECC, Flat Files to BW (Creation of BW Objects, Transformations and DTP) and worked extensively on FI and Generic extractions
• Loaded the data from R/3 to BW and used initialization with delta update methods
• Worked on ECC data sources and non- ECC data sources to load data to BW/BPC
• BADI Enhancement spotted BADI UJ COUTOM LOGIC, script logics for calculations
• Experience in installing and customizing the IFRS/GAPP kit
• Experience in created Hierarchies in BW and loaded into BPC
• Experience in Transport Mechanism from Development to Quality to Production
• Created BADI to Retract data BPC to SAP ERP cost center
• Experience in Business Process Flow to provide consistent and standardized application tools
• Experience with Script Logic, Process Chain and Data Manager Package
• Experience with Inter-Company Eliminations, Currency Translation and Balance Carry Forward
• Configure the currency translation logic, maintain rate application, business rules, Account Dimension, Rounding functions for the report
• Experience with configuring Input Schedules on Rolling forecasts and budgets
• Writing functional requirements and associated test cases. Designed and implemented applications for Planning, Reporting, and Budgeting including application set creation and dimension build
• Provide gap analysis and document the BPC solution options, recommendations and implications.
• Experience with configuring Transformation files and data loading packages
• Ability to document functional and technical specifications
• Expert level knowledge of the back end and front end functionality in BPC and BW
• Expertise in SAP Enterprise Performance Management (EPM)

PROFESSIONAL EXPERIENCE

Senior BPC Consultant

Confidential, Texas

Responsibilities:

• Designed and produced BINI (BI Integration) power point presentation for corporate presentation detailing benefits of BPC10 versus the present BPC7.5 installation after making an in depth study of the BPC installation
• Key resource in explaining the benefits of using BPC - Consolidation module to be while maintaining Planning Module (Budget, Forecast, and Planning)
• Presented Timeline & Budget to "Steering Committee" and "Business" kicking off the project
• Identified key players and designed "milestones" for project roadmap
• Produced a Business Blueprint complete with project timeline and estimated cost
• Got Business Owner to sign-off on BPML - (Business Blueprint Master List)
• Produced a "Step by Step Installation" guide for BI/BW/BPC team to follow
• Monitored and hand held AMS-basis team during installation on new landscape including the critical post-installation steps of a NEW BPC10 installation
• Stabilized the existing BPC7.5 environment, resolved all issues, and optimized all applications before exporting Master & Transactional Data to flat files for loading into the new BPC10 environment and models
• Validated and checked new BPC10 environment delivered by Basis team. Validated (.\CPBM and.\POABC) directories for consistency and namespaces
• Validated SSO configuration - CMC, CMS, Netweaver security profiles, task & roles for all users
• Configured Data Manager for new system (DM-Packages, updated links & configuration)
• Created environment and 5 new Models in accordance with BPML
• Configured Base Security in BPC - complete with TASK & ROLE Mapping document
• Created 15 new Dimensions to be used throughout the 5 new Models in DEV, QAS, PROD
• Adjusted Script Logic and converted SSIS packages to PC (Process Chains)
• Created transformation and conversion files for Master Data upload into new system
• Validated and exported Master data from old BPC7.5Ms system to Flat Files
• Uploaded & populated Master data (Imported from Flat Files)
• Validated and exported Transactional Data from old BPC75Ms system to flat files
• Wrote transformation and conversion files for all 5 models and imported 2 years of historical + one year of current data into BPC10 new Models (175m records)
• Configured 'Work Status' for BPC10 environment
• Validated Security, 160 Users, DataAccess Profiles, Tasks Roles from BPC-Sys Admin
• Exported 200+ reports and input schedules to new system and converted old EVDRE reports to new EPM report format
• Extensively worked on WebDynpro ABAP involving BPC and created on Custom Logic BADI, SQE, Write Back, Start Routine BADIs and triggered Datamanager packages in BADIs
• Created Web-Dynpros for complex reporting and Input scenarios and used UJ Validation BADIs for input validation in inputforms
• Resolved issues and modified reports to work under the new EPM reporting tool
• Conducted UAT, implemented cutover, Delta loads leading to cut over and Go Live
• Re-created 7 new BPF's (Business Process Flows) in accordance with Business needs
• Trained Business Super Users & IT on new system

Senior SAP BPC Consultant

Confidential, Dallas, Texas

Responsibilities:

• BPC support: Provided support to business user for three appset. These users were based in different locations. The user problem were related to application installation, security access, excel add-ins, appserver connectivity, data validation with source system, data loading problem
• BPC P&F lead of Onsite team to implement the EMP 10 tool in the existing BW system
• Input Template: Designed input template for Revenue, Expense, Budget, Short Range Planning (2 years), Long Range Planning (5 years), Head Count Planning, Position Planning
• Scheduling the Housekeeping activities like deletion of DM logs, audit logs, data files from UJFS
• Data Manager: Modified Data Manager Package to load data from staging table to BPC models
• Script Logic: Designed script logic for forecast adjustment and moving data from one application to another
• Allocation Logic: Designed allocation engine and script logic for corporate expenses
• Improved performance by moving script logic functionality to BADIs
• Reports: Designed approx. 30 reports related to revenue by region, Profit Center, Company, region etc. These reports included both i.e. static report and dynamic reports
• Upgrading existing BW 7.3 to BW 7.4 and then migrating existing DB6 database to HANA database, fixing the ABAP code syntax errors caused by HANA migration
• Work Status: Used work status for tracking, locking and monitoring the job completion
• Worked on security set up. Creating task profiles, member access profiles to allow users to perform task and access assigned data
• Supported Consolidation team member with various Consolidation related activities i.e. creation of application, parameters setting and Business Rules
• Used Script Logic and BADIs to move data from one EPM Model to another
• Business Rules activities included Account Transformation, Inter Company Booking & Elimination, Carry-forward, US eliminations, Validation
• Client Interaction: Actively interacted with BPC application owner from the client side. The objective was to understand the new client need and provide them with solution and also evaluate the support status on weekly basis
• Used SQL query statements to troubleshoot error related BPC and database. Similarly used MDX query statements for OLAP database
• Used BPC Server Manager to move the appset from one environment to another
• Monitoring system & application performance using Management Console. Other activities included optimization of the application
• Developing Input Schedules and reporting templates utilizing the new EPM 10 functionality
• Design and implementation of BADI's used for write back, calculate headcount fringe benefits, etc.
• Design and implementation of reports - web based and also in Datamanager
• Created transformation files and conversion files for loading. Also used the start/End routines in the transformation. Used java script commands in the conversion files
• Implementation of OSS notes and works with SAP proactively on fixing the bugs in EPM 10
• Coordinating with Basis team on installing the EPM 10 in all the test systems and through with the implementation steps
• Troubleshooting BPC transports and mastered the issues frequently occurs in EPM 10
• Involved in the upgrade of BW on HANA and implementing the solutions for commercial and chain account planning in BPC on HANA environment
• Responsible for Data modeling in SAP HANA - Attribute views, Analytical views, Calculations views, Decision tables for new business requirements
• Responsible for Data provisioning in SAP HANA - SLT, BODS

SAP BPC Consultant

Confidential

Responsibilities:

• Data Manager: Used transformation processes (Mapping, Conversion and Validation) to move data into BPC. Used BADI (UJD ROUTINE) to move Cost Center master data. Also modified data manager packages (Dynamic Script) to meet the client requirement
• Report: Organized data for approximately 20 reports on Revenue, Sales, COGS, OPEX, HR & other expenses for Corporate Power Users
• Other reports include Discounts, Prices, Rates, COGS, Expenses, Fixed and Variable Costs, Variances, etc.
• Wrote script logic for calculating and moving data from Consolidation to Dept App application. Used DESTINATION APP and LOOKUP for cross application logic
• Created Business Process Flows (BPFs) to monitor progress of users, send email notifications, and assure consistency and uniformity
• Work Status: Used work status for tracking, locking and monitoring the job completion
• Worked on security setup. Creating task profiles, member access profiles to allow users to perform task and access assigned data
• Used disaggregation to plan at a higher level and spread the results to base members
• Supported Consolidation team member with various Consolidation related activities i.e. creation of application, parameters setting and Business Rules
• Business Rules activities included Account Transformation, Inter Company Booking & Elimination, Carry-forward, US eliminations, Validation
• Designed new Data Manager Package to run Allocation and FX Translation logic - activities include modifying and creating new prompt, radio button for selection
• Responsible for Optimization of Application on regular basis
• Extremely knowledgeable and an expert with BPC debugging tools like SLG1, script logic debugger, SE30-Run time analysis, ST03, ST22 trace, ST21 system trace, ST05 & ST01 RFC traces, UJFS traces, etc.
• Used extensively all the UJ* programs needed from verifying the master data, security, transport entries, UJFS files, etc.
• Production cutover task
• BADI's - Start Routine, End routine - BADI's for planning functions - BADI's for write back to DB
• Owner for the Design and implementation of BW Integration with BPC

Senior SAP BW/BI/BPC Consultant

Confidential - San Francisco, CA

Responsibilities:

• Worked on the SAP BW-SAP BPC Integration-Master Data Loads and Transaction Loads for Cash Flow Forecasting, Integrated Planning and Consolidation of Budget.
• Worked on developing BPC reports for Consolidation of actuals & Cash Flow Forecasting and BPC Input schedules for consolidation of Budget
• Expertise in creation of Transformation and Conversion logic for data flow.
• Worked on BADI Implementation on Work Status to lock, approve and submit
• Created Process chains and implemented them in Data Manager Packages so that they can be triggered from the BPC environment and the complete flow of data happens as required.
• Worked on creating the Report specifications and Design documents
• Daily trouble shooting of Incidents, Implementing changes and requests.
• Involved in submitting the Ticket Status (open/close) report. Maintain Work History for all the Tickets until it is closed down.
• Develop custom data model using InfoObjects, InfoCubes, Standard and Write- Optimized DSO, InfoSets and Multiproviders.
• Used Delta Init, Full and Delta mechanisms for uploading data in BW
• Automated loading of data using Process chains which has Meta chains
• Played key role in Extraction of BW data to BPC as wells as retraction of BPC data to BW. Also automation of these activities
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains
• Worked on activating the Standard Business Content object like Info Cubes, ODS Objects, Info Objects etc.
• Writing ABAP codes for Function Module based extractors, Start/End routines and BAdIs.
• Performed Unit testing and Performance testing for all new developments.
• Constant interaction with the onsite team on all the requirements, Issues, changes and status updates.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Involved in creating UAT/BAT test scripts and Sessions with the analysts and given training

Senior SAP BW Consultant

Confidential

Responsibilities:

• Participated in the full life cycle efforts to design, analysis, Blue printing, technical specification, implementation, Go-Live and deployment of BW solutions and support processes
• Exposure to both BW 3.5 and BI 7.0 data flows
• Creation of process chains and scheduling according to the client requirement
• Monitoring the data loads and fixing in case of failure without affecting the business
• Successfully implemented solutions to frequently occurring problems like preventing LOCKING due to multiple loading to the same target through process chains, avoiding data inconsistency
• Automated the month end activities that involves the master data load from different non-SAP source systems
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement
• Loading of transaction data to the business content Info Cube from Info Sources like 2LIS 11 VASCL, 2LIS 11VAHDR for sales, 2LIS 13 VDHDR, 2LIS 13 VDITM for billing, 2LIS 12 VCHDR for order
• Designed, built, tested, documented and maintained data extractors, transformations, DTPs, process chains, DSO Objects, Info cubes, and Multi-Cubes; coding in start routines and end routines
• Creation of different BEx queries and workbooks based on the user requirement
• Transporting the BEx queries and other BI objects from development to production
• Developed reports on the MM cubes to check the price variance for materials from different vendors
• Effectively Analyzed and Debugged the BI-ABAP programs used for the different transactions
• Arranged the L1 meeting with the business users for the periodic update of the issues
• Acted as the SME for the new joiners for both BW 3.5 and BI 7.0
• Raising OSS message with SAP AGS and coordinating within different teams to resolved the issues
• Carry out requirement gathering, GAP Analysis and solution design with clients
• Implemented the planning functions and package for transactional InfoCubes
• Edited the transactional InfoCubes data whenever there was inconsistency in the data
• Responsible for giving the access for Status and Tracking Systems (STS)
• Primary contact for the issues related to the locking or unlocking of the data for particular region and cycle
• Creation of each cycles with required planning types for both top down and bottom up approach based on the business requirement
• Creation and maintenance of the Crystal reports based on BEx queries
• Proposed the implementation of crystal reports for the complex reports to analyze the forecast and budget figures for the normal business users
• Backend Performance Improvement: By using SE30 to analyze the ABAP code - used ST05 to analyze the Select statements, created indexes on ECC tables based on the extraction criteria, set the optimum size parameter for the package size, etc.
• Worked in the Analysis Authorization and have the company code and cost center as the authorization enabled variables and maintain the Z table
• Conducted user training on the front end tools like BEx, Query Designer, and Integrated Planning. Conducted trainings to BI teams on Integrated Planning, BPS-SEM, Analysis Authorization, etc. Regular KT's sessions to the offshore team and work with them constantly
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively
• Installed and Enhanced BW statistical technical business content to analyze overall system performance, InfoCubes, Aggregates Status, Queries Run Time, Query usage, Query OLAP time, Query Database Time and Load Time
• Managed and Kept consistency of master and transaction data in InfoCubes through BW RSRV performance tools
• Used the APD (Analysis Process Designer) feature in BI to perform several look ups to tie the transaction data to specific master data attributes
• Enhanced DataSource, InfoSource, Update rules, Communication Structure and Transfer rules through Delta Management, RFC, Customer Exit, User Exit, Update rules and Start routines workbooks

SAP BW/BI Consultant

Confidential

Responsibilities:

• Worked extensively with Administrative Work Bench (AWB) for creating InfoObjects, InfoCubes, DSO, MultiProviders, InfoSources, Transformation and Data Transfer Process (DTP)
• Created Functional specifications based on the business requirements in SD module.
• Involved in setting up procedure to extract R/3 data for SD using LO, Generic Extraction and customizing to the requirement using Business Content.
• Used the Business Content Data Extractors such as 2LIS 11 VAHDR (Header), 2LIS 11 VAITM (Item) and 2LIS 11 VASCL for Sales Orders for extracting data to BI system.
• Worked on extracting data from Inventory (Material Management) sources like 2LIS 03 BF and 2LIS 03 UM.
• Enhanced Sales Infocube with a custom field and a standard database field to meet the user requirements.
• Worked on activating the standard business content infocubes 0SD C01 (Customer) and 0SD-C03 (Sales overview).
• Actively involved in creating Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads with full update and delta mechanisms.
• Installed BW Statistics to monitor the daily loads and query performance on cubes and enhanced the performance by building aggregates on required objects.
• Implemented Performance tuning techniques like Compression, Partitions for improving the query response time and proposed archiving strategy for future based on the Time characteristics.
• Involved with performance tuning of queries by maintaining Aggregates, compression, partition of info cubes.
• Working with CKF and RKF for BEx reporting.
• Working with CMOD code for master and transaction data.
• Created a Dashboard with the Net Sales value report by Calendar years and drilled down further by Quarter, Sales Organization, Sales Offices and Sales Reps using BEx tools (Analyzer, Query Designer and Web Application Designer).
• Delivered Documentation for all new objects and enhancements.
• Conducted workshop training for the end users on BEx tools and various reports execution.
• Enhanced Business Content, Data Sources with delivered/custom InfoObjects & Key figures. Activated Business Content as required.
• Involved in BW upgrade into BI and migrated the BW 3.x datasources to BI 7.0 datasources.