SUMMARY:

• Over 16 Years of Experience in Enterprise Performance Management space with SAP BPC/BI/SEM/BPS/BCS across Industries like Federal Government, Mining, Oil & Gas, Utilities, Plantation, Services, Automobile, Retail and Government departments
• Worked extensively with boards, top management and operational business to articulate, define and derive the strategic focus of business and its integration to systems and derive competitive advantage for value generation and ROI within the complex framework of people, processes and system and its integration to Organizational transformation and strategy.
• Business Analysis
• Data Migration
• Solution Design
• Business Process Modelling
• System Architecture
• SAP Consulting
• Stakeholder Management
• Project Realisation
• Change Control Management
• Project Risk & Scope

PROFESSIONAL EXPERIENCE:

Confidential

SAP BPC/SAC/BW Consultant

Responsibilities:

• Working for Confidential, supporting multiple clients in BPC/BW embedded
• Leading the support and enhancements in BPC embedded Planning and consolidation
• Certified in SAP Analytics cloud Planning
• SAC configuration, licensing, setup import and live data connection to BW, S/4 HANA, Embedded BPC and created analytical and planning models.
• Data wrangling in Modeler, blending models, creation of self - service stories, linked analysis.
• Created Analytical application and story dashboards.
• Exporting and deploying SAC stories, files, dependencies across system landscape along with scheduling and publishing stories.
• Experience in planning use cases, what-if analysis, value driver trees, predictive forecasting, smart predict, and smart discovery
• Worked on SAC Planning POC’s for multiple planning scenarios
• Extensively worked on HANA views fetching data from S4 HANA
• Extensively worked on BW4HANA for creating and enhancing info providers/ADSO’s, queries
• Supporting integration of BPC/BW to S4 HANA and data uploads from other data sources
• Supporting the Group reporting solution for Monthly Consolidation
• Supporting the planning scenarios for CAPEX, Revenue and cost planning
• Extensively worked on Analysis for Office reports and designing underlying queries.
• Managing the process chains for Master data and transaction data loads from ECC to BPC/BW
• Conducting requirement gathering workshops for Planning & Consolidation with business users
• Created business process flows for Planning and consolidation on BPC
• Designing the business rules for consolidation using currency translation, eliminations & account transformations
• Regression testing for BPC/BW for any enhancements, support packages etc.

Confidential

SAP BPC/BW Consultant

Responsibilities:

• Support of BPC/BW existing Consolidation and Planning models
• Creating the business blueprint new BPC merger solution
• Merging the TFNSW transport and Confidential entities and reporting in BPC
• Conducting requirement gathering workshops for Planning & Consolidation with business users
• Integration of BPC/BW to ECC and data uploads from other data sources
• Designing technical architecture for BPC/BW
• Created planning scenarios for CAPEX & Revenue planning
• Created business process flows for Planning and consolidation on BPC
• Designing the security matrix and configuring the data access profiles for business users
• Designing the business rules for consolidation using currency translation, eliminations & account transformations
• Managing the Master data and transaction data loads from ECC to BPC/BW
• Creating BPC reports and Input layouts for Planning & Consolidation models
• Regression testing for BPC/BW for any new support packages
• Changes in work status configuration for BPC Models

Confidential

SAP BW Analyst

Responsibilities:

• Supporting BPC 11.0 Embedded using BW/4HANA
• Served as liaison between business users and application service providers
• Conducted business process Gap Analysis between To-Be design and SAP standard Business Processes, and made recommendations for Process Improvement
• Translated business requirements into SAP functional requirements and created Functional Design Specifications
• Solved application and configuration issues and collaborated to ensure end-to-end business process integration
• Support the data migration activities for existing and new projects
• Creating the projects, local repository, data transformations, job server & data stores using data services workbench
• Performing the data cleansing, data profiling and data harmonization activities
• Changes in Job server, BW models, reports & input layouts
• Conducting requirement gathering workshops with business users for enhancements

Confidential

SAP BPC/BW4HANA Consultant

Responsibilities:

• Implementing BPC 11.0 Embedded using BW/4HANA for CAPEX, Revenue & Consolidation
• Served as liaison between business users and application service providers
• Conducted business process Gap Analysis between To-Be design and SAP standard Business Processes, and made recommendations for Process Improvement
• Translated business requirements into SAP functional requirements and created Functional Design Specifications
• Solved application and configuration issues and collaborated to ensure end-to-end business process integration
• Creating the business blueprint for BPC solution
• Conducting requirement gathering workshops for Planning & Consolidation with business users
• Integration of BPC to S4 HANA and data uploads from other data sources
• Designing technical architecture for BPC 11.0/BW4HANA solution
• Created planning scenarios for CAPEX & Revenue planning
• Created BPC models on 11.0 embedded version, embedded with info providers
• Created business process flows for Planning and consolidation on BPC 11.0
• Designing the security matrix and configuring the data access profiles for business users
• Designing the business rules for consolidation using currency translation, eliminations & account transformations
• Creating the Task sequence for running the consolidation using Consolidation Monitor
• Created the control sets for BPC models
• Work status configuration for BPC Models
• Creating ADSO’s, composite providers, open ODS views & aggregation levels using HANA studio
• Created multiple models for different planning areas
• Created ADSO’s for Rate, Ownership & Consolidation
• Created multiple aggregation levels and reports
• Designed Input enabled queries for data input on aggregation levels
• Designed planning functions for inter model data transfers, copy and planning calculations
• Created reports using Query designer & Analysis for Office (AFO) reporting
• Extensively used Analysis for Office for creating reports

Confidential

SAP BPC Consultant

Responsibilities:

• Supporting BPC/BW solution for Planning and Consolidation.
• Changes in BPC models, reports & input layouts
• Conducting requirement gathering workshops for Planning & Consolidation with business users for enhancements
• Managing the Master data and transaction data loads from ECC to BPC/BW
• Regression testing for BPC/BW for any new support packages
• Designing the security matrix and configuring the data access profiles for business users
• Changing the business rules and script logic
• Managing the BPC/BW security
• Changes in work status configuration for BPC Models

Confidential

SAP BPC Embedded 10.1 Consutlant

Responsibilities:

• Using IBPF on BPC Embedded
• Used standard SBP (SAP Budgeting and Planning for public sector)
• Created budget forms on SBP using SAP IP framework
• Capex & Opex Planning using BPC Embedded
• Personnel Expenditure Planning (PEP) and Pay period PEP & shared services models on S4 HANA
• Analysis for Office (AFO) reporting
• Creation and enhancement of HANA CDS and analytical views
• Real time integration of master and transaction data from S/4 HANA to BPC
• HANA modelling for creating custom views for "Actual" Data from S/4 HANA
• Extensive usage of Eclipse as modelling tool for HANA
• BW modelling using Eclipse for HANA
• Retraction of Plan data using HANA views from BPC embedded to S/4 Hana
• Developing custom BPC dimensions/info objects for provisional master data
• Integration of provisional master data objects with S/4 tables using HANA views
• Creation of Multi providers, cubes, aggregation levels and planning related objects
• Creation planning functions for depreciation for capex.
• Creating Master data & transaction data load process chains.
• Cash flow model for generation of Actual Vs Plan Cash flow
• Integration of BPC cubes/Models to Combined model for Group reporting
• Creation of future projects for planning in BPC using internal orders
• Setting up of work status for data locking and Submit/Approval process
• Usage of FOX formulas for writing planning functions
• Creation of business process flows for all planning areas
• Using Custom BADI's for Work status & retraction of plan data
• Creation of Aggregation levels, Planning functions, filters and planning sequences in BPC Embedded
• Extensive use of Analysis office for reports
• Creation of BPC input layouts and statutory reports in AOF

Confidential

SAP BPC Consultant

Responsibilities:

• Managing the security for BPC & BW
• Establish appropriate security model in BPC for processes
• Creating new reports and input layouts to support planning
• Managing the data extraction jobs
• Changing the script logic and business rules the super users on administration activities & maintenance of BPC.
• Establishing the corrective steps to be undertaken to remediate failed Process Chains
• Managing the transports for BPC & BW objects for new enhancement

Confidential

SAP BPC Consultant

Responsibilities:

• Business blueprint preparation for consolidation solution using BPC.
• Requirement gathering workshops with business users.
• Data cleansing, conversion, mapping & transformation
• Workshops with users on AS-IS & TO-BE financial process flows
• Created Consolidation environment using BPC 10.0 NW
• Lead functional design workshops with team
• Detailed process diagrams for Consolidation and Rolling forecast
• Worked on development of environment, models and Dimensions
• Data Modeling & ETL Design for all financial data from ECC
• Creation of Ownership hierarchy & Exchange rates input layout within BPC 10.0.
• Created business rules for all consolidation functions.
• Balance Carry forward business rules
• Validations of reported financial data at upload level.
• Currency translation in group currency using different exchange rates.
• Consolidation of investment configured with respective method assignment depending on the % share.
• Setup of Business process flows for running the monthly process
• Designing the data/process flow from FI/CO & BI/BPC
• Planning Input Layouts & Reports using EPM Add in
• Creating of financial reports in BPC
• Preparing the security matrix with roles & authorizations for finance users
• Managing/Conducting UAT with Finance users
• Preparation of materials for users.
• Imparting user & to super users
• System support for post go live issues

Confidential

SAP BPC Consultant

Responsibilities:

• Preparing the blueprint & design of technical architecture for forecasting & planning
• Solution design for Rolling Forecasts
• Automation of Master data from SAP BW to BPC.
• Transaction data automation for Actual, Budgets & Commitments
• Setup of Business process flows for running the Planning process
• Creating financial reports
• Establish appropriate security model in BPC for processes
• Conducting UAT with Finance users & resolving issues there off.
• Prepare documentation & impart to users the super users on administration activities & maintenance of BPC.

Confidential

SAP BPC Consultant

Responsibilities:

• Requirement gathering for the planning process.
• Solution design for Capital Forecasting & planning process using BPC 10 NW
• Preparing the blueprint & design of technical architecture for forecasting & planning
• Creation of Input Templates for Rolling Capital Forecasting
• Creation of Budget Variance reports for Capital Accounts
• Financial reports in BPC for Capital Analysis
• Automation of Master data from SAP BW to BPC.
• Transaction data automation for Actual, Budgets & Commitments
• Setup of Business process flows for running the Planning process
• Creating financial reports
• Establish appropriate security model in BPC for processes
• Conducting UAT with Finance users & resolving issues there off.
• Prepare documentation & impart to users the super users on administration activities & maintenance of BPC.

Confidential

SAP SSM Consultant

Responsibilities:

• Technical Architecture design for SSM data flow
• Creation of Measures, KPI’s, Objectives & Perspectives
• Creation of Scorecards for programs & divisions.
• Creation of Entry & Approval process for Actual & Target data.
• Data upload process using PAS model
• Creation of model using Cube builder
• Using FIM to upload the financial KPI data from BPC to SSM
• Creating SSM roles, users using SSM NWA
• Using SSM transporter tool for data deletion & transport of database
• Conducting the UAT for SSM with users and resolving defects thereof.
• Imparting user on usage of scorecards the super users on administration activities for SSM
• Solution design & effort estimation for BPC engagements
• Building In-house capability in EPM space
• Involved in presales for BPC solution to clients
• Prepared Proof of concepts using BPC 10 on HANA for demos to clients in house consultants for building BPC capability

Confidential

SAP BPC Consultant

Responsibilities:

• Designing the BPC solution for Confidential .
• Business blueprint preparation for consolidation solution using BPC.
• Requirement gathering workshops with business users.
• Created Consolidation environment using BPC 10.0 Microsoft.
• Worked on development of environment, models and Dimensions
• Data upload using flat files from source systems like Pac soft, AS400 & SQL.
• Creation of Ownership hierarchy & Exchange rates input layout within BPC 10.0.
• Created business rules for all consolidation functions.
• Using store procedures within logic files to run the consolidation rules.
• Balance Carry forward business rules
• Validations of reported financial data at upload level.
• Currency translation in group currency using different exchange rates.
• Consolidation of investment configured with respective method assignment depending on the % share.
• Creation of Business process flows for running consolidation using BPC.
• Used Data Services 3.1 to perform ETL procedures from SQL database.
• Used WebI 3.1 for creating Universe on BPC data
• Crystal reports designer for reports like P&L, Balance Sheet & Cash Flow.
• Dashboards using Xcelsius with Drill through for company level
• Conducting the User Acceptance testing with users and taking sign off.
• Preparation of materials for users.
• Imparting user & to super users
• System support for post go live issues

Confidential

SAP BPC Consultant

Responsibilities:

• Solution & Designing the BPC solution for Yancoal Limited
• Preparation of Business blueprint for BPC.
• Holding workshops with users for requirement gathering.
• Created Legal Consolidation Solution using BPC 7.5 NW
• Worked on development of Application Sets, Applications and Dimensions
• Automatic uploads of Master data from BI cubes to BPC NW cubes
• Automatic upload of trial balance using custom process chains of BPC NW.
• Writing business rules & script logic for all consolidation functions.
• Balance Carry forward business rules
• Validations of reported financial data at upload level.
• Currency translation in group currency using different exchange rates.
• Consolidation of investment configured with respective method assignment depending on the % share.
• The reporting activity uses the Microsoft interfaces like Excel, Power Point and word.
• Go live support for any system issues or enhancements
• Assisting multiple projects in difficult project phases
• Solution design & effort estimation for BPC engagements
• Building In-house capability in EPM space
• Involved in presales for BPC solution to clients
• Prepared Proof of concepts using BPC 10 on HANA for demos to clients in house consultants for building BPC capability

Confidential

SAP IP Lead

Responsibilities:

• Designing the budgeting and planning solution for Confidential using SAP Integrated Planning
• Preparation of Business blueprint for Budgeting solution in IP.
• Leading a team of BW consultants for automating extraction of Transaction & Master data from ECC.
• Creating Aggregation levels in integrated planning layer.
• Creation of Input layouts for budget Inputs to be used by Ministry of Defense
• Actual Expenditure numbers uploaded from ECC and Plan numbers entered in IP
• Top down budget allocations from Ministry of Defense to Ship levels using planning functions in IP.
• Multiple Planning layouts created for entering plan numbers for users from ship to directorate.
• Status and tracking system configured for approval & rejection during each planning cycle.
• Extensive usage of FOX formulas, inbuilt Business Functions for calculations.
• Several Planning functions developed for copying, distributing, allocating and calculating Year end estimates.
• Reporting on Plan Vs. Actual models depicting the variance in targets.
• Conducting the User Acceptance Testing with the users from different levels of organizational hierarchy.
• Preparation of & User manuals.
• Imparting user to multiple levels of budget management structure.
• Supporting the system after go live

Confidential

EPM Competency Lead

Responsibilities:

• Competency Lead for SAP BPC
• Assisting the pre-sales team for building the practice
• Assisting the delivery team for solutions in EPM space
• Center of Excellence consultant for SAP BPC/EPM products
• Created Legal Consolidation Solution using BPC 7.5 NW
• Worked on development of Application Sets, Applications and Dimensions
• Automatic uploads of Master data from BI cubes to BPC NW cubes
• Automatic upload of trial balance using custom process chains of BPC NW.
• Balance Carry forward business rules
• Validations of reported financial data at upload level.
• Currency translation in group currency using different exchange rates..
• Consolidation of investment configured with respective method assignment depending on the % share.
• The reporting activity uses the Microsoft interfaces like Excel, Power Point and word.
• Extensive usage of EVDRE functions to create input schedules and financial reports.

Confidential

Solution Architect

Responsibilities:

• Worked on development of Application Sets, Applications and Dimensions including maintenance of dimension members and dimension properties.
• Used BPC Data Manager for loading data into BPC.
• Configuring applications for business function.
• Dimensions created and loaded with real time master data.
• Upload of company level trial balance using import packages.
• Validations of reported financial data at upload level and using MDX.
• Currency translation in group currency using different exchange rates.
• System will identify what is to be eliminated and post the elimination automatically.
• Investment structure with direct shares loaded in the system
• Consolidation of investment configured with respective method assignment depending on the % share.
• The reporting activity uses the Microsoft interfaces like Excel, Power Point and word.
• Extensive usage of EVDRE functions to create input schedules and financial reports.
• Business Process Flows also used to consolidate which leads to both control and consistency and to ensure that the activity of consolidation is happening throughout the enterprise with timelines.
• Prepared Documentation to highlight BPC features in comparison to SAP BCS/IP/BPS providing technical details & solution effectiveness.
• Go live support for any upcoming issues or enhancements required

Confidential

Senior Consultant - SAP BPC

Responsibilities:

• Creating application sets representing the Legal Consolidation activity for the group.
• Configuring applications for business function.
• Dimensions created and loaded with real time master data.
• Upload of company level trial balance using import packages.
• Validations of reported financial data at upload level and using MDX.
• Currency translation in group currency using different exchange rates.
• System will identify what is to be eliminated and post the elimination automatically.
• Investment structure with direct shares loaded in the system
• Consolidation of investment configured with respective method assignment depending on the % share.
• The reporting activity uses the Microsoft interfaces like Excel, Power Point and word.
• Extensive usage of EVDRE functions to create input schedules and financial reports.
• Business Process Flows also used to consolidate which leads to both control and consistency and to ensure that the activity of consolidation is happening throughout the enterprise with timelines.
• Prepared Documentation to highlight BPC features in comparison to SAP BCS/IP/BPS providing technical details & solution effectiveness.
• Go live support

Confidential

Senior Consultant - SAP BCS/IP

Responsibilities:

• Completed Business Blueprint document with documentation of all the gathered requirements from various requirements gathering and confirmation workshops.
• Data flow design & data modeling to provide trail balance from all SAP & NON SAP companies to BCS data base using BI 7.0.
• Data flow design & data modeling to get trial balance & notes reporting requirement from ECC 6.0.
• Designed the Consolidation Data basis involving multiple cubes and ODS for Investment, Inventory and Supplier documents.
• Created the flow of Reported Financial Data BI to SAP BCS data basis for consolidation.
• Tasks created in BCS for Validating and cleansing of reported financial data to be fed to consolidation system.
• Complex Currency Translation scenarios captured as a part of solution.
• Configuration of tasks and methods to capture and post Inter-Unit eliminations adjustments
• Journal upload through flat files and Manual adjustment at company or group level made available.
• Reclassification tasks configured
• Complex Investment structure of the group configured using the following Investment Consolidation Methods.
• Consol Monitor configured to run the tasks based on task hierarchy capturing all consol steps in structured way.
• Design and configured planning framework to get trial balance & data for supporting notes from NON SAP companies (Subsidiary) on monthly basis.
• Involved in configuration using BI Integrated planning - Aggregation Levels, Filters, Planning functions, Sequences, Excel based to accept data for NON R3 companies.
• Completed unit testing & UAT successfully.
• Prepare material and delivered for effective use of the SAP BCS system.
• Prepare for go-live.
• Prepare Documentation to provide technical details & design secrets.

Confidential

Consultant - SAP BPC

Responsibilities:

• Implemented the Legal Consolidation solution for the group.
• Configuring Legal Consolidation App set on BPC.
• Created the dimensions/properties required for consolidation.
• Upload of company level trial balance using import packages.
• Validations of reported financial data at upload level and using MDX.
• Configured Currency translation to different exchange rates.
• Configured Elimination task and business rules for the same.
• Consolidation of investment configured with respective method assignment depending on the % share.
• Created the consolidation reports using Microsoft interfaces like Excel, Power Point and word.
• EVDRE functions to create input schedules and financial reports.
• Configured Business process flows to run consolidation cycle.

Confidential

Consultant - SAP Integrated Planning

Responsibilities:

• Supporting the existing planning consultants on technical issues
• Query changes for any errors logged by users in planning cycle
• Enhancements in planning application, Queries and further testing of system.
• Application of Notes and suggesting on Patch application for any error resolutions
• Implementing the recommendations from SAP Go-Live Verification check

Confidential

Consultant - SAP BCS

Responsibilities:

• Requirements gathering from various workshops with users
• Business Blueprint document built covering all technical and functional aspects gathered from workshops
• Designing the Data basis for BCS system.
• Designed reporting solution on Multiprovider comprising of Virtual Infoprovider and Totals record cube as generated from BCS module
• Created Info cubes, Data store objects, virtual info provider, info objects and key figures
• Data flow design & data modeling to get trial balance & notes reporting requirement from R3 system
• Designed Consolidation Data basis involving multiple cubes and ODS for Investment, Inventory and Supplier documents.
• Generated the consolidation areas within the data basis
• Data collection tasks using flexible upload for collecting reported financial data.
• Validation checks to check correctness of reported financial data
• Manual Adjustment tasks at company and group level provided.
• Balance carry forward and period initialization tasks configured
• Journal upload using flat files
• Reconciliation of Inter Unit transactions and automatic posting for Inter-Unit eliminations adjustments
• Reclassification methods as part of consol process
• Complex Currency Translation scenarios captured as a part of solution
• Investment and Equity data with % shares loads created for flexible upload.
• Journal upload through flat files and Manual adjustment at company or group level made available.
• Master data maintained using BCS workbench
• Sub assignments defined and breakdown categories and checks used.
• Consolidation of Investment configured using following methods
• Consol Monitor configured to run the tasks based on task hierarchy capturing all consol steps in structured way.
• Involved in configuration using BI Integrated planning - Aggregation Levels, Filters, Planning functions, Sequences, Excel based to accept data for NON R3 companies.
• Involved in design, development and configuration of BEx Reporting Objects - Queries, Restricted Key figures(RKF), Calculated Key Figures (CKF), Key Figure
• Distribution, allocation and other logical functions used.
• Input layout and Validation reports presented as Workbooks built with Input enabled Queries.

Confidential

Consultant - SAP BCS/BI

Responsibilities:

• Checking the configuration for all BCS tasks after the system upgrade.
• BCS Master data checks for any inconsistencies arising
• Data validation or correctness after upgrade
• Running all tasks in test mode for thorough testing to know the impact of upgrade on BCS
• Preparing test scripts and reporting any errors thereof
• Checking in BI workbench the Cubes, ODS and other data base structures used in BCS
• Checking any impact on transformation rules, info objects, info packages and other BI structures
• Detailed documentation on testing done and any notes suggested for application

Confidential

Consultant - SAP BCS/BI

Responsibilities:

• QA and fine tuning the consolidation tasks created by the consolidation team.
• Validations on the reported financial data created
• Journal upload methods changed and fine tuned
• IU Elimination and Currency translation tasks enhanced
• Consolidation of Investment checked and rectifications done where necessary
• Completed unit testing & UAT successfully.
• Prepare material and delivered for effective use of the SAP BCS system.
• Prepare for go-live.
• Prepare Documentation to provide technical details & design secrets.

Confidential

Consultant - SAP BCS/BI

Responsibilities:

• Gathering all business requirements, formulated in BCS templates from various requirement gathering and confirmation workshops.
• Completed Business Blueprint document with documentation and notes on all financial processes to be implemented in BCS.
• Modeling of BCS Data basis to cater complex reporting requirements.
• Generating the consolidation area for consolidation build
• Data collection methods for loading trial balance designed using Input Layouts using integrated planning functionality.
• Data Validation tasks on reported financial data.
• Configuration of Manual adjustments tasks at company level and group level
• Standardize the reported data of consolidation units to comply with the corporate policies or valuation rules
• Reconciliation of inter company activity and automatically post any differences with audit trail
• Reclassification tasks created
• Currency translation methods and tasks to translate to group currency
• Additional Financial data load using flexible upload for Investment data and % ownership
• Flat company hierarchy created and consolidation method assignments to perform COI
• Consolidation master data loaded and maintained in BCS workbench
• Sub assignments defined and break down categories configured
• Consolidation of Investments configured and performed using Purchase and Equity Methods
• Design of consol monitor by creating task hierarchy as per the consolidation steps
• Completed unit testing & UAT successfully.
• Prepare material and delivered for effective use of the SAP BCS system.
• Prepare for go-live.
• Prepare Documentation to provide technical details & design secrets.

Confidential

Consultant - SAP BW/BCS

Responsibilities:

• Gathering all reporting requirements, formulated report list and data access templates detailing out all reporting requirements in terms of data granularity & front ends
• Define data flow and BW related data design strategy
• Multi providers to cater complex reporting requirements from wide scope of business
• Designing the cubes and ODS required for BCS data basis.
• Data flow design & data modeling to provide trail balance from all SAP & NON SAP companies to BCS data base.
• Data flow design & data modeling to get trial balance & notes reporting requirement from ECC.
• Involved in design, development and configuration of BEx Reporting Objects - Queries, Restricted Key figures(RKF), Calculated Key Figures (CKF), Key Figure
• Structures, Variables, Cell definitions, BEx Workbook and Web reports using BEx Web application designer (WAD)
• Design and configured authorization at query level reporting for subsidiaries & Group Users.
• Completed unit testing & integration testing successfully
• Preparation of User manual, and skill transfer to client team.
• Prepare for go-live.
• Prepare Documentation to provide technical details & design secrets.

Confidential

Decision Support System - Team Member

Responsibilities:

• Implemented SEM BPS for Annual Operating Planning for all SBU's on existing SAP BW platform (3.0B).
• Design and configured planning framework for Annual and Monthly planning cycles
• Created Transactional Info cubes for SBU's to be planned. Gathering all reporting requirements, formulated report list and data access templates detailing out all reporting requirements in terms of data granularity & front ends
• Configured Planning Areas, Planning levels and packages pertaining to following Business components- Market, Revenue, OPEX, CAPEX and KPI's.
• Multi Planning areas for Shared Services cost and Clearing House (Transfer Pricing) Models serving as interlink to all other Business areas
• Created Planning folders and Web Interfaces for multiple planning layouts.
• Extensive usage of FOX formulas, inbuilt Business Functions for calculations.
• Global sequences configured to structure the function running in one click.
• Several Planning functions developed for copying, distributing, allocating and calculating Year end estimates, Year to Date and other planning relevant measures
• Involved in design, development and configuration of BEx Reporting Objects - Queries, Restricted Key figures(RKF), Calculated Key Figures (CKF), Key Figure
• Created Business reports like Consolidated P & L, KPI, Profit & Loss, Cash Flow, Depreciation, ROCE etc.
• Structures, Variables, Cell definitions and Web reports using BEx Web application designer (WAD)
• Reporting on Plan Vs Actual models depicting the variance in targets.
• Created Shared Services Cost and Clearing House (Transfer Pricing) Models serving as interlink to all other Business areas
• Status and Tracking System and Authorization for tracking and control of planning cycles.

Confidential

Associate Consultant - BW

Responsibilities:

• Involved in pre sales activity, creating business proposals for SAP BW implementation, support and enhancement jobs.
• Analyzed business reporting requirements of potential customers and providing the solution thereof.
• Worked on various proof of concepts to be used for pre sales activities.
• Developed, modified Info Cubes & ODS and built Queries depicting the BW functionalities.
• Used BEx Analyzer for creating reports with exceptions, variables, restricted key figures and calculated key figures.
• Prepared and delivered presentations and s to potential clients and colleagues

Confidential

Assistant Cost Controller

Responsibilities:

• Analyzing data and preparing daily and periodic reports for management decision-making.
• Involved in pre sales activity, creating business proposals for SAP BW implementation, support and enhancement jobs.
• Reports prepared: Function P&L statement, Price variance report, Stock on hand report, Consumption report, Summarized receipt journal, Inventory Variance reports, Sales Mix reports, Sensitivity analysis, Food Costing, House charges report, Get-in summary, etc.
• Calculating costing for all functions and profits thereof.
• Conducting month end and spot inventories for the warehouse and charging shortages if any.
• Doing audit checks on warehouse inventories to ensure proper recording of every transaction.
• Authorizing ---All purchase requisitions for central beverage and food stores
• All demand requisitions from restaurants to main stores
• All spoilage reports from restaurants after cross verification
• Invoicing all the payments to the vendors and co-coordinating with them for any price changes.
• Approving any price changes from vendors asking reasons in writing.
• Ensuring controls to maintain the optimum inventory levels in the warehouse.
• Preparing demand schedules (forecasting) for upcoming weeks/months.
• Identifying and selecting the potential vendors on the basis of tenders.
• Ensuring delivery, pricing and discounts are in accordance with contract with the concerned vendor.
• Co-coordinating on daily basis with vendors for timely after delivery and repair services.
• Conducting periodic vendor audit to maintain service standards and improve performance.
• Doing Quality and Service Standard Checks.

Confidential

Executive

Responsibilities:

• Handling all after customer services for Microsoft, providing customers the customized solutions for the products as per their industry requirements.
• Handling all billing and technical operations related queries.
• Monitoring CCE responses to customer queries, doing QA (Quality Assurance), giving feedback and updates to agents.Solving billing issues for paid up accounts.
• Settling billing issues and complying with quality standards
• Managing a team of 8 members and acting as a liaison between the Management and the Team.
• Supervising a team of 8 people and assisting them in solving issues.
• Provide guidance to the team based on management decisions. Interact periodically with the Process Manager to discuss the team performance.
• Settling billing issues and complying with quality standards
• Solving billing and semi-technical issues related to installations, speed and outlook express.
• Ensuring Compliance with quality standards