Sales Project
Resume:
Professional Summary
Overall **+ years of experience in SAP EPM Application Development/Management and Functional with core focus on SAP Business Objects Planning and Consolidation (BPC).
SAP BPC functional and technical experience implementing multiple full life cycle projects in Planning/Budgeting, Forecasting and Consolidation for various clients from Mobile Phones and Consumer Electronics, Media and Telecommunications, Consumer Goods, Retail &Pharmaceuticals industries.
Experienced with the implementation of Legal Consolidation Processes such as Currency Translations, Intercompany Eliminations, Account transformations and Balance Carry Forward.
Experienced in modeling and end to end implementation of Capex, Head Count, Dept Spend modules, Units & Revenue Forecasting, Gross Margin and P&L forecasting processes.
Involved in configuring and creating task profile and member access profile, create teams and assign profiles to the teams, create users and assign users to teams
Experience in Configuring BPF with SAP BPC for Monthly Forecast projection cycle and Yearly Budget Approval
Experience in Building Input schedules, Reports, Security Set up (Task Profile, Member Access Profiles, Users and Teams), Work Status Settings.
Worked on complex Reports & input schedules having EPM, EVDRE functions, multiple segments and multiple EVDREs. Performance tuning of various Complex reports with VBA Functionalities. Extensively used EV functions to create worksheet logic for local calculations. Maintained comments in Input Schedules and report using EVCOM functions.
Monitored and Conducted User Acceptance and Integration (SIT) Testing, Training, Documentation, Development, Production support & Customer care. Planned and Supervise Core team & End User Strategies for Cut over, Data migration, transition, authorization & workflow
Experience with Production Support Role. Handling incident Tickets, Daily Job monitoring and Problem Tickets Management.
Experience working with Dimension Member Formulas, MDX, Script Logic, BADI’S, Business Rule, Excel Logic, administrative functions, security.
Experience in Configuring and Designing InfoCubes, Data Sources, Multi-providers, infosets, InfoSources, InfoObjects, and ODS/DSO Objects
Well versed in running business blueprint sessions & workshops to understand the business needs and creation of functional design documents, user training and defining support process.
Adept at identifying process improvement areas during the requirements & analysis phase of the engagement and effectively communicating recommendations to the client.
Expertise at managing & working on projects involving on-shore & off-shore models
Well versed with complete software development Life cycle (SDLC) and its integration With QA methodology and experience in Testing Tools like HPQC and extensive Experience in MS – Office Tools for documentation
Key SAP Skills
SAP BPC – version 5.1, 7.0(MS). 7.0 NW, 7.5 NW, 10.0 NW, BPC 10.1 Standard & 10.1 Embedded
SAP BI-version BW 3.5,BI 7.0,BI 7.4
SAP Bex Analyzer
SAP BO –Xcelsius, Web Intelligence
SAP HANA & Analysis for Office
SQL Data Base – version 2000, 2005, SQL Server components.
MS Office Suite (Excel)
SAP ABAP/4
SAP Enterprise Portal (EP) - Portal Administration & WebDynpro for Java
SAP Project Experience:
1.PN6 HANA Upgrade
Company:
Infosys Limited
Client:
Apple
Role:
SAP BPC Functional
Date:
May 2017 – Present
Environment:
SAP BPC 10.1 NW
Client Description:
Client is an American multinational technology company that designs, develops, and sells consumer electronics, computer software, and online services.This project implements the HANA upgrade and involves detailed functional testing on the existing processes.
Role/Responsibility:
Played the role of BPC Functional Lead who is involved in the end to end implementation of the project from Design discussions to Project Warranty Support.
Worked on creating the Functional and Technical specifications, Playback and Design Documents.
Managed and Delivered quality work by involving off-shore team.
Supported UAT activities and interacted with Business to receive UAT signoff
Worked on BPC Objects –BPC Security,Reports,Input forms,script logics,master and transaction data loads.
Troubleshooting issues in BPC and coordinating with the BW/ABAP team for BPC requirements and Supported the project warranty post go-live
2.LRF Security
Company:
Infosys Limited
Client:
Apple
Role:
SAP BPC Functional
Date:
Dec 2016 – May 2016
Environment:
SAP BPC 10.1 NW
Client Description
Client is an American multinational technology company that designs, develops, and sells consumer electronics, computer software, and online services.This project implements additional BPC security for super secret products.
Role/Responsibility:
Played the role of BPC Functional Lead who is involved in the end to end implementation of the project from Design discussions to Project Warranty Support
Interacting with end users and business leads/Managers to understand and design solution, implementing requirements on the Planning cycles, continuously enhancing technical and business processes and reporting
Developed the Functional and Technical specifications, Playback and Design Documents.
Managed and Delivered quality work by involving off-shore team.
Supported UAT activities and interacted with Business to receive UAT signoff
Worked on BPC Objects –BPC Security,Reports,Input forms,script logics,master and transaction data loads.
Troubleshooting issues in BPC and coordinating with the BW/ABAP team for BPC requirements and Supported the project warranty post go-live
3.Sales Adjustments for Units Revenue and Gross Margin
Company:
Infosys Limited
Client:
Apple
Role:
SAP BPC Functional
Date:
Aug 2016 – Feb 2016
Environment:
SAP BPC 10.1 NW
Client Description
Client is an American multinational technology company that designs, develops, and sells consumer electronics, computer software, and online services.The project enhances the fixed sales adjustment driver upload and dissagreagtion processes.
Role/Responsibility:
Played the role of BPC Functional Lead who is involved in the end to end implementation of the project from Design discussions to Project Warranty Support.
SAP BPC Planning, Budgeting, and Forecasting Implementation – Data Load, Manual Planning via Input Form, Manual Forecast via Input Form, Automated Planning & Forecast via Logic, Budget Allocation, Business Process Flow, Work Status, and Management Reporting
Worked on creating the Functional and Technical specifications, Playback and Design Documents.
Managed and Delivered quality work by involving off-shore team.
Worked on BPC Objects –like BPC Security,Reports,Input forms,script logics,master and transaction data loads.
Created Process Chains to Automate & Schedule Daily & Monthly Loads to our BPC Models & Dimensions. The Master data Loads were automated on the monthly basis with just a file required to be complete the whole process.
Worked on BW Master Data and Transactional Data ETL Process with Different Source Systems such as FLAT FILE, ECC, DB Connect, HANA ODP and BW to bring down the data into BPC.
Experience with Web/Excel Reports, input forms and EPM format templates with Decision making capabilities and Highlights.
Troubleshooting issues in BPC and coordinating with the BW/ABAP team for BPC requirements and Supported the project warranty post go-live
4.Corporate Units
Company:
Infosys Limited
Client:
Apple
Role:
SAP BPC Functional
Date:
May 2016 – Aug 2016
Environment:
SAP BPC 10.1 NW
Client Description
Client is an American multinational technology company that designs, develops, and sells consumer electronics, computer software, and online services. This project implements the processes for supporting the corporate units forecasting.
Role/Responsibility:
BPC Project Lead involved in the end to end implementation of the project from Design discussions to Project Warranty Support.
Worked on creating the Functional and Technical specifications, Playback and Design Documents.
Managed and Delivered quality work by involving off-shore team.
Supported UAT activities and intercated with Business to receive UAT signoff
Worked on BPC Objects –like BPC Security,Reports,Input forms,script logics,master and transaction data loads.
Troubleshooting issues in BPC and coordinating with the BW/ABAP team for BPC requirements and Supported the project warranty post go-live
Enhanced the Performance issues with few long Running EPM Reports. Optimized the Macros, BADIs and MDX commands. Usage of more Local Members and Excel formatting instead of EPM Formatting has fixed the issue for a large extent in our scenario.
5.Headcount –Average Salary by Type
Company:
Infosys Limited
Client:
Apple
Role:
SAP BPC Functional
Date:
Oct 2015– May 2016
Environment:
SAP BPC 10.1 NW
Client Description
Client is an American multinational technology company that designs, develops, and sells consumer electronics, computer software, and online services. The project has enhanced the headcount planning to both active and inactive employment types.
Role/Responsibility:
Played the role of BPC Functional Lead who is involved in the end to end implementation of the project from Design discussions to Project Warranty Support.
Worked on creating the Functional and Technical specifications, Playback and Design Documents.
Managed and Delivered quality work by involving off-shore team.
Supported UAT activities and intercated with Business to receive UAT signoff
Worked on BPC Objects –like BPC Security,Reports,Input forms,script logics,master and transaction data loads.
Troubleshooting issues in BPC and coordinating with the BW/ABAP team for BPC requirements and Supported the project warranty post go-live
6.Theatrical & Domestic Planning
Company:
Deloitte Consulting
Client:
Warner Bros
Role:
Sr. SAP BPC Consultant
Date:
Jan 2013 – Present
Environment:
SAP BPC 10.0 NW
Client Description:
Client is the largest, fully integrated, broad-based entertainment company and a global leader in the creation, production, distribution, licensing and marketing of all forms of entertainment and their related businesses..
Role/Responsibility:
Development Phase
BPC Implementation
Design & Develop automation of data loads (Master and Transaction data) from BW to BPC via. BPC Data Manager Packages, BW transformations and DTP’s.
Design & Develop customized & interactive Input layouts and Reports using EPM10
Design & Development of Logics for various Planning Automations
Developing VBA macros in the template to achieve the requirements and automate the process
Built stand-alone userforms using VBAs for planning selections.
Lead the BPC teams and coordinated the work within BPC & BI team.
Testing phase
Unit Testing on individual functions, reports and input schedules
System Integration Testing of all Reports and Input Templates.
Integration Testing on entire process
Support phase
Leading the development team for Hyper care support of BPC post go-live.
Troubleshooting issues in BPC and coordinating with the BW/ABAP team for BPC requirements.
Support for the applications rolled to Live along with Development
Upgrade Phase
Perform regression testing on system functions and entire Process of all developed Applications
Report Product bugs to SAP and fixing it
7.Consolidation of Actuals & Budget (Implementation)
Company:
Deloitte Consulting
Client:
Sony Pictures International
Role:
SAP BPC Consultant
Date:
Jan 2012 – Feb 2013
Environment:
SAP BPC 7.5 NW
Client Description:
The Client is the television and film production/distribution unit of Japanese multinational technology. It is a member of the Motion Picture Association of America (MPAA).This project includes SAP BPC implementation of all Close, Consolidation and Reporting (CCR), Integrated Planning (IP), Amortization & Ultimate and Cash Flow Forecasting (CFF).
Role/Responsibility:
Worked on creating the report specifications and design documents
Worked on BPC reports for Consolidation of actuals & Cash Flow Forecasting and input schedules for consolidation of Budget
Worked on P&L Statements and Balance Sheets.
Worked on the SAP BI-BPC Integration-Master Data Loads and Transaction Loads for Cash Flow Forecasting and Integrated Planning
Worked on BADI Implementation on the BPFs and work status.
Implemented Custom Macros using VBA for CSV Flat File Generation upload templates in Amortization and Ultimate work stream.
Worked on Script logic (Calculations& Copying data) and Business Rules (Currency Conversions) for IP and CFF.
Worked on customizing data manager packages and process chains.
Interacted with the onsite team on reporting requirements, Issues, changes and status updates.
Worked on Consolidation concepts like journals and journal validation
8.SCJ Project Everest
Company:
Deloitte Consulting
Client:
S C Johnson
Role:
SAP BPC Consultant
Date:
Nov 2011 – Feb 2012
Environment:
SAP BPC 7.5 NW
Description:
The Client is a privately held, global manufacturer of household cleaning supplies and other consumer chemicals. It has operations in 72 countries and its brands are sold in over 110.This project includes SAP BPC implementation of all Close, Consolidation and Reporting (CCR) and Financial Planning & Analysis (FP&A) processes.
Role/ Responsibilities:
Worked on BPC consolidation reports (Balance Sheet,Income Statement etc.) and planning input schedules
Worked on Business Rule Calculations like Intercompany Elimination.
Worked on Script logic (Allocation) and data manager packages (data loading and copying).
Managed the team & coordinated the activities and assigned daily tasks on BPC reporting.
Interacted with the onsite team on reporting requirements, Issues, changes and status updates.
Worked on creating the report documentations and other design documents
Mentor the fresher’s in the team.
9.Sales Planning Accelerator (Implementation)
Company:
Cognizant Technology Solutions
Client:
SAP Labs
Role:
SAP BPC Consultant
Date:
Dec 2010 – May 2011
Environment:
SAP BPC 7.5 NW
Description
Project requirement: Sales Planning Accelerator is developed as a starter kit for the customers. It is a pre-configured content built on top of an existing SAP solution. BPC NW 7.5 is the solution underlying the initial version of the starter kit for Sales Planning. The content consists of data models, input schedules, reports, dashboards, business logic, work flow processes, integration logic between BPC and CRM, documentation and sales kit. It basically implements both Top down planning and bottom up planning approaches.
Role/Responsibility:
Worked on BPC Administration and excel tool like creating reports, templates, input schedules, managing security and script logic
Managed Data loading, data manger packages and process chains.
Written Visual Basic codes inside the templates to include many additional functionalities in the templates like expand, collapse, distribute Equal ratio, distribute Existing, replace row, replace column etc also worked with User Forms in Visual Basic
Added members on the fly (adding master data from the excel) with the help of ABAP function modules and web services
Worked on Building block, short term promotion and long term promotion templates
Maintained the Gap value in Gap Analysis Report from the Top down planning (target values) and the baseline volumes (uplift, base volume)
Generating Sales forecast data, analyzing with actual data and the GAP
10.Sales and Operation Planning (Application Development)
Company:
Cognizant Technology Solutions
Client:
SAP Labs
Role:
SAP BPC Consultant
Date:
Jun 2010 – Dec 2010
Environment:
SAP BPC 10.0 NW
Description
Project requirement: Sales and Operation Planning Accelerator (SOPM) is developed as an additional functionality to the Sales Planning Accelerator.SOP is to plan for the production and capacity for products (finished goods), its plant distribution and the raw material procurement for the products (finished goods. The production demand is retrieved from the SPA and further it’s added to Sales and Operation Planning Accelerator. It also provides a product wise Profit/Loss analysis.
Role/Responsibility:
Planning done for production of finished goods at No Plant, Gross Production and net production are calculated. User enterable adjustment is allowed to maintain the Gap.
Capacity planning for products that take in to account the required hours and available hrs.
Plant distribution is done using the allocation logic and it’s distributed from No Plant to All Plants.
Procurement planning done with the planning of raw materials required for the production of each product and a BOM explosion is done at the ABAP end, i.e. means the net production will send the amount of each quantity of raw material required.
Created various BPC planning templates like Production Plan, Capacity Plan, Plant Distribution, Procurement plan and Product wise P/L report.
Included extensive VB codes in the above templates to gain much additional functionality like Expand, Collapse the column or rows based on the parent level members, recalculate the formulas.
Added members on the fly (adding master data from the excel) with the help of ABAP function modules and web services
Performed script logic for run allocation logic and various key figure calculations using LOOKUP, FOR/NEXT, SELECT, and WHEN/ENDWHEN keywords.
Worked with the web services to call an ABAP function module through SAP connector and has implemented it through excel using Visual basic (VBA).
Also worked with SOAP UI Client3.0 to run batch jobs and the same again is implemented through Microsoft excel using Visual basic (class modules and procedures).
11.NIBR Global Planning Tool (Application Development)
Company:
Cognizant Technology Solutions
Client:
Novartis Swiss
Role:
SAP BPC Consultant
Date:
Mar 2010 – Jun 2010
Environment:
SAP BPC 7.5 NW
Description:
Project requirement: NIBR Global Planning Tool to plan NIBR Expense costs for various Cost Center of different country. Planning Objects are Running Cost and Project Cost. Periodical planning was done for Preliminary Budget and Final Budget versions.
Role/Responsibility:
Planning done at
All Sites (all NIBR Sites including Basel, Cambridge and Hoshom)
All levels of aggregation for Cost Center, Cost Element, etc.
Different Exchange rates-Rates maintained for different Planning Versions,viz, Preliminary Budget and Final Budget
Used Evdre function to build the Input Schedule and Reports. BPC functionalities like EVPRO, EVGET, EVSEND, EVCOM, EVEXP, and EVEXP are used. Worked on VB to develop the drop downs for Site and Cost Centers. Created Button for sending values and run Copy package.
Preliminary Budget was uploaded through flat file. This was copied to Final Budget and then adjustments were made either manually or using distribute.
Used Spread, Trend as different distribution methods to distribute planned figures to base level including at individual Cost Center, Cost Element level.
User to post comments for various planning Object.
Inserting of members at runtime.
Variance between planning version data
Performed an Script logic for Top Down Allocation and Currency Translation
12.492 BPC Clarity
Company:
Cognizant Technology Solutions
Client:
Autodesk MTC
Role:
SAP BPC Consultant
Date:
Jun 2009 – Feb 2010
Environment:
SAP BPC 7.0 MS
Description:
Autodesk is a Fortune 1000 company headquartered in San Rafael, California. Since 1982, Autodesk has ushered in state-of-the-art 2D and 3D technologies that let customers visualize, simulate, and analyze the real-world performance of their ideas early in the design process
The project involves understanding current planning and consolidation process and carrying out the fit gap analysis. The team also designed the proposed SAP BPC system and in the later stage carried out the quality assurance activities for the BPC implementation.
Role/Responsibility:
Identified scenarios and test scripts for testing Reports, Input schedules, Security profiles, Application sets and interfaces
Worked in HP Quality center for execution of scenarios and test scripts, Raised defects in Test Director
Experienced with the testing of reports, input schedules, security profiles (teams, users, task profiles &member access profiles), application sets and interfaces
Extensively worked on the data flow structure (Interfaces) from ECC->BI->BPC in BI Systems
Experienced to perform Data validation in SAP Business Objects.
Regression Testing and System testing of the following Planning Scenarios:
COGS Planning
Head count planning
Revenue planning
SEC reports
13.Retail Comp Store Planning Accelerator (Application Development)
Company:
Cognizant Technology Solutions
Client:
SAP AG
Role:
SAP BPC Consultant
Date:
Jan 2009 – May 2009
Environment:
SAP BPC 5.1 MS
Description:
The project involves conceptualizing and developing Retail Comp Store Planning Accelerator jointly with SAP. A Retail Comp Store planning model has been developed for SAP targeting retail industry using SAP BPC Application. It involves building the Retail specific applications, scripts, logic and templates to replicate typical Retail Industry planning process and to address the pain points experienced by retailers.
Role/Responsibility:
Worked with BPC Admin, Creating Application Sets, Applications and Dimensions
Adding Users, Team, Task Profiles and Member Access Profiles
Worked with BPC Excel; creating EVDRE reports and input schedules
Created Business Process Flows (BPFs)
Worked with BPC Functions and report templates
Data loading and Scripts for top down Allocations
Developing ABAP classes necessary for implementing the methods
Created function modules
Worked on module pool programming
Implementing the logics necessary for Effort Analysis and Estimation
Education
Bachelor of Technology from College of Engineering,(Kerala University), India.
Master of Business Administration, Symbiosis Institute of Management Studies, India
Contact this candidate