Project Manager Sales

Bhagashra

Career Summary

. Have a total * years of IT experience as BPC Consultant and Business

Analyst.

. Three years' experience in BPC as Techno-Functional Consultant and two

years as Functional Consultant.

. Successfully completed three full life cycle implementations with SAP

Business Planning & Consolidations in BPC 7.5, BPC 7.0 and BPC 5.1

. Three years of proven experience in full implementations in SAP BPC

NetWeaver and Microsoft version.

. Hands on experience in BPC Planning & Reporting and creating

application in Profitability Planning (COPA), Capital Expenditure

Planning (CAPEX & OPEX), Sales Volume Application and Head Count

Application.

. Transformation, Mapping, Conversion and Validation of data from

different sources.

. Used Script language for scoping data from Data Manager, Input

Schedule and transfer data from one application to another.

. Analyzed data in MS SQL Server and used SQL language for ETL

processes.

. Extensively used EVDRE and related functions for designing reports &

input schedule.

. Designed & developed Business Process Flows (BPFs) to monitor progress

of users, send email notifications, and assure consistency and

uniformity.

. Excellent exposure in interacting with clients, understanding their

business requirement and providing them with desired solution.

. Proficient in documenting Project Blue Print i.e. from requirement

analysis to implementation and maintenance.

. Strong technical and analytical skills, problem solving, communication

and documentation skills.

Technical Experience

SAP Technology BPC 7.5, BPC 7.0 and BPC 5.1

Platform NetWeaver and Microsoft

BPC Technology Application sets, Dimensions, Hierarchies, Business

Process Flow(BPF), EVDRE Reports, Dynamic Templates,

Input Schedules, Work Status, Security, Audit, Currency

Translation, Data Manager Packages, Account

Transformation, Validation, Script Logic, BADI, MDX

Logic.

Environment MS SQL, MS Access, SAP BI, SAP FI, ECC, Scala, Unix

System V (SysV), Cartesis, ECC

Reporting BPC Excel

Methodology ASAP

Client: Cognizant Technology, NJ Nov,

2010 - Present

Project: Planning Budgeting and Consolidation

Role: BPC Consultant

SAP Implementation: BPC 7.5 MS

Environment: MS SQL, MS Accesses

Client Profile and Project Objective

Cognizant Technology is a leading provider of information technology

related services. These services include Business Consulting, Application

Services, IT Infrastructure and Business Process Outsourcing. With over 50

delivery centers worldwide and approximately 100,000 employees, Cognizant

today is ranked among the top performing and fastest growing companies in

the world.

The objective of the project is to help business user make annual business

plan and then design standard reporting format for user to analyze the

data. Also, BPC should act as central database and help Client in a faster,

easier & auto-reconciliation/consolidation of data. My responsibilities

are:-

As functional consultant:

. Designed Business Requirement Template for analysis helped client

manager & project manager in completing Project Blueprint.

. Extensive meeting with business user in identify the problems &

propose the solutions.

. Trained 50 end user on application usage, generating reports &

entries in input schedule.

As technical consultant:

. Dimension & Application : Designed 12 dimensions and created 4

applications i.e. Profitability Planning, Capital Expenditure Planning

(CAPEX & OPEX), Sales Volume Application and Head Count Application .

Handled all activities related to dimension & application design i.e

adding, deleting, modifying properties, members, hierarchies,

security, member assess profile etc.

. Maintaining the exchange rates in the rate application.

. Data Manager: Extensively used Data Manager to load transaction

data. Other activities included Transformation, Mapping, Conversion

and Validation of data from different sources.

. Analyzed data in MS SQL Server and used SQL language for ETL

processes.

. Developed custom SSIS package by using SQL coding as part of data

loading.

. Report & Input Schedule: Developed reports and Input templates using

EVDRE and other EV functions (EVPRO, EVDES, EVTIM, EVGTS, EVENE,

EVMBR, EVCVW, EVSEN, etc).

. Developed Cash-flow design and cash-flow reports.

. Configured Adhoc reports, Variance analysis & Driver analysis.

. Creation of input template for sales volume and head count expenses

data.

. DataSrc (Data Source): Uploaded data from SQL server and Flat Files.

. Script Logic : Used Script language for scoping data from Data

Manager, Input Schedule and transfer data from one application to

another.

. 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 set up. Creating task profiles, member access

profiles to allow users to perform task and access assigned data.

Client: NALCO, IL

April, 2009 - Oct, 2010

Project: Planning, Budgeting, Reporting and Consolidation

Role: BPC Consultant

SAP Implementation: BPC 7.0 NW

Environment: SAP BI, SAP FI, ECC, Scala, Unix System V (SysV), Cartesis

Client Profile and Project Objective

Nalco is the world's largest sustainability services company focused on

industrial water, energy and air applications. The company help its

customers to reduce energy, water and other natural resource consumption,

minimizing environmental releases while boosting the bottom line. The

company employees more than 11,000 technically trained experts and serve

nearly 70,000 customer located in over 150 countries.

The primary objective of the project was to meet the long term need for a

comprehensive, user-friendly, flexible, consolidation, reporting and

planning solution.

As functional consultant:

. Assisted Project Manager in designing Project Blueprint for Global

implementation.

. Interacted with Business User for understanding their requirement and

creating Functional specifications for Reporting Application.

. Trained end user on Reporting Application usage.

As technical consultant:

. Dimension & Application: Processes 19 dimensions for MgmtRptg

(Management Reporting), Legal, Ownership & Rate application. Created

Reporting Application. This application provided report on P&L

Statement and included information on Sales Volume, Cost of Goods Sold

(COGS), OPEX & other expenses.

. Data Manager: Created Process Chain to support master and transection

data loads from BW/BI to BPC. Used Transformation processes (Mapping,

Conversion and Validation) to move data into BPC.

. Report & Input Schedule: Organized data for approximately 50 reports

on Sales, COGS, OPEX, Admin. & other expenses and Corporate Power

Users.

. Developed reports using EVDRE, EVGTS, EVSND, EVCOM, EVDPS, etc.

. Develop reports for Planning Application such as Budget Analysis,

Forecast Analysis and Performance Reports etc.

. Created Input Schedules for Sales, Discounts, Prices, Rates, COGS,

Expenses, Fixed and Variable Costs, Variances, etc.

. Designed input templates, reports, data loading and integration

between BPC 7.0 NW and SAP BW systems related to master data,

hierarchies, transaction data including historical data. The data was

validated before loading.

. Created script logic for calculating revenue from Planning Application

to Reporting Application.

. 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 set up. Creating task profiles, member access

profiles to allow users to perform task and access assigned data.

Client: Li & Fung Group, NY

Jan, 2008 - March 2009

Project: Planning, Budgeting, and Forecasting

Role: BPC Consultant

SAP Implementation: BPC 7.0 NW

Environment: ECC, R3

Client Profile and Project Objective

Li & Fung Group is global trading company in Retiling, Sourcing and

Distribution. As a Supply Chain Manager across many producers and

countries, Li & Fung provides product design and development, raw material

and factory sourcing, production planning and management, quality assurance

and export documentation to shipping consolidation. With 80 offices across

40 countries, Li & Fung are leaders in Retiling, Sourcing and Distribution

. Interacted with Business user to understanding planning & budgeting

processes.

. Dimension & Application: Designed 10 dimension & created 4 application

i.e. Revenue Planning, Inventory Planning, Capital Expenditure and HR

Planning. Dimension and Application Management i.e. adding, deleting,

modifying properties, members, hierarchies, security, member assess

profile etc.

. Loaded historical data, opening balances, current year data to BPC

application from SAP ECC / R3.

. Maintaining the exchange rates in the rate application.

. Developed reports and input templates using EVDRE function.

. Developed Input Template for sales, inventory, marketing expenses &

rent model template.

. Extracted and integrated ECC periodical BW data load for transaction

data, master data, and exchange rate maintenance.

. Designed & developed Business Process Flows (BPFs) to monitor progress

of users, send email notifications, assure consistency and uniformity.

. Developed Script Logic to move data of Rent model expenses from CAPEX

application to Revenue application. Allocate the Corporate expenses

and to calculate the Year to date data for CAPEX and Rent Model

expenses.

. Used work status for tracking, locking and monitoring the job

completion.

. User Security such as team, task, member access profile creation,

maintenance. Also restricting user access by activity, for reports

only and specific to region.

. Prepared user guides and conducted training for the business users

. Provided Go-Live Support.

Client: Diaspark Inc, NJ

May, 2006 - Dec, 2007

Project: Planning, Budgeting, and Forecasting

Role: Project coordinator

SAP Implementation: BPC 5.1 MS

. Assisted PM to design project plan, budget, decision making principals

etc.

. Coordinated with various users for SAP BPC implementation.

. Staffing and active management of the SAP BPC project team.

. Build up a great relationship with the stakeholders.

. Regularly updating Project Manager on BPC implementation progresses.

. Creation of specification (functional, technical, commercial etc.)

. Analysis & design business process analysis in regards of SAP BPC.

. Act as Business Analyst /Consultant for the SAP BPC implementation.

. Training the users on BPC.

Client: marketRx, Inc, NJ

April, 2004 -April, 2006

Role: Business Analyst

marketRx (now cognizant technology solutions) is a product based company

and provides global solutions in sales and marketing tracking, analysis and

planning as well as fast-turnaround market research and interactive

marketing services.

. Plan study of work problems and procedures, such as organizational

change, communications, information flow, integrated production

methods, inventory control, or cost analysis.

. Analyze data gathered and develop solutions or alternative methods of

proceeding.

. Document findings of study and prepare recommendations for

implementation of new systems, procedures, or organizational changes.

. Assisted company managers in making informed and sound business

decisions to sustain or improve the competitive positioning of the

organization.

. Analyzed the company financial/business data to receive facts and

statistics and provide true picture of performance and industry

standing.

. Analyzed the organization's strengths and weaknesses in order to

enhance the future performance.

. Formulated the process of reports to improve the business intelligence

of the organization.

. Collected historical and current business data to establish

operational trends in the company.

. Utilized statistical tools to forecast the outcome of implementing

certain business strategies based on historical data.

. Helping the management in preparing new business plans and policies.

. Monitoring business strategies and undertaking different studies to

improve them

. Give presentations and handle reports to the senior management of the

company.

. Worked directly with customers, analysts and vendors to develop,

articulate, and document a project approach.

. Analyzed and consolidated data across the business and made effective

planning decisions.

. Accountable for coordinating business and technology resources to

overcome challenges and resolving issues.

. Facilitated meetings to achieve specific outcomes.

. Worked with the training department effortlessly and developed

training materials.

Professional Education

1- Master's in Business Administration

April, 2002 - March, 2004

2- Certification in Business Analysis from International Institute of

Business Analysis (IIBA) - July, 2008

Contact this candidate