Candidates About

 

Anila Mohan

Professional Summary

Ø  Around 11 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 (Balance Sheet) 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 models, Units & Revenue Forecasting, Gross Margin, P&L and Corporate Units 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 

Ø  Good understanding of monthly forecasting process and Yearly Budget Approval 

Ø  Experience in consolidating GL data with the data loaded to BPC systems.

Ø  Experience in Building Input schedules, Reports, Security Set up (Task Profile, Member Access Profiles, Users and Teams), Work Status Settings.

Ø  Hand-on experience on BPC 10.1 Embedded with exposure to Planning Concepts including Aggregation Levels, Planning Functions, Filters, Planning Sequences and Data Slices.

Ø  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 EPM functions to create worksheet logic for local calculations.

Ø  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 Business Support Role. Daily Job monitoring, Master data management, Data consolidation, Security, ad-hoc reporting, Performance monitoring and Problem Tickets Management.

Ø  Well versed with Microsoft excel. Has good knowledge on VBA coding

Ø  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 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 HANA & Analysis for Office

Ø  MS Office Suite (Excel)   

 

SAP Project Experience:

Company:	Infosys Limited	Client:	Apple Inc.
Role:	SAP BPC Functional
Date:	Sep 2015 – 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. It is the world's largest information technology company by revenue and the world's third-largest mobile phone manufacturer . The client enjoys a high level of brand loyalty and has been repeatedly ranked as the world's most valuable brand.

Areas Worked:

1.      End-User Support –

·         Interacts with business to understand the issues faced during Forecasting cycle,

·         Prepares system and provides support to CFP&A users during monthly forecasting

·         Consolidates GL Actuals during month end close.

·         Conduct end-user trainings and assign relevant security roles for them.

·         Provides feasible solutions and issue resolutions in terms of enhancements ,bug fixes and root cause analysis.

·         Review and understand the design and architecture of the As-Is Model.

·         Early engagement in new process implementation to propose solutions from a supportability standpoint.

·         Propose solutions to automate existing and new processes that ensures minimal manual intervention and better performance.

2.      Corp Units Enhancements -Additional enhancement requests in Corp Units forecasting and coordinate with other teams to propose systematic solutions. Implemented the complex forecating processes that includes Lineairty,SKU Alignment, Topside Adjustments via SAP BW 7.5 on native HANA

3.      PN6 HANA Upgrade implemented the HANA upgrade patch and involved detailed functional testing on the existing processes across models.

4.      LRF Security implemented additional BPC security for super secret products in Corporate Units Forecasting.

5.      Sales Adjustments for Units Revenue and Gross Margin enhanced the sales adjustment driver upload and dissagregation processes.

6.      Corporate Units implemented the BPC solution for supporting the corporate units forecasting.

7.      Headcount –Average Salary by Type enhanced the headcount planning to both active and inactive employment types.

Role/Responsibility:

Ø  Responsible for new implementations and upgrades, and supports projects for Corporate FP&A.

Ø  Interacts with business to understand and design the solution, implements various requirements on the Planning cycles, enhances technical and business processes and reporting

Ø  Build and translate business requirements to functional specifications and provide recommendations and best practices around solution design.

Ø  Analyze problems, suggest various options to address the problem specifying functionality, integrating systems and applying patches.

Ø  Responsible for the end to end implementation from Requirement Gatherings, Design Discussions to Project Warranty Support.

Ø  Experience with Web/Excel Reports, input forms and EPM format templates with Decision making capabilities and Highlights.

Ø  Assist with building customized scripts/rules, planning, testing, rollout, post-implementation and support.

Ø  Coordinate with off-shore team on a daily basis for the project deliverables.

Ø  Support UAT activities and interacts with Business to receive UAT signoff

Ø  Troubleshoot issues in BPC and coordinates with the BW/ABAP team for BPC requirements and supported the project warranty post go-live

 

1. Theatrical & Domestic Planning

Company:	Deloitte Consulting	Client:	Warner Bros
Role:	Sr. SAP BPC Consultant
Date:	Jan 2013 – Mar 2014	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

 

1. 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

 

1. 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.

 

1. 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

1. 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

 

1. 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

 

1. 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)

Ø  Wo