Summary:

• Around 10+ years’ experience in SAP BPC, SAP BW/BI implementation, SAP HANA, SAP ABAP, SAP Business Objects (BO), which includes 9 full Life Cycle Implementations and Production support Experience in following domains Retail,Travel,healthcare,Oil & Gas, Chemical, Telecom and Manufacturing.
• Extensively worked in the areas of Sales and Distribution (SD), Finance (FI) and controlling (CO), SRM, CRM, HR, PP, Materials Management (MM), Inventory Management (IM) and Warehouse Management (WM) and have in-depth business process knowledge .
• 6 years into SAP BPC Experience and 3 Years’ Experience on SAP HANA with 3 full life cycle Implementations.
• Certified in SAP BPC 7.0 & 10.0 / SAP BW / SAP HANA / SAP ABAP

Projects:

Client: Confidential, Houston, TX

Role: Senior SAP BPC / EPM Consultant

Responsibilities:

• BPC lead for Design, Build & Deliver
• Perform gap analysis of the existing client’s processes and finance processes available in the EPM framework.
• Custom BADI for Business Process Flows template to suit the business requirements.
• Provide Process Expert support and resolve project related issues. Implement the corrective and preventive actions in the project.
• Will be leveraging SAP BW with BPC alongside HANA and also installing SAP HANA studio and HANA Live
• Track and Report on EPM 10 deliverables status.
• BPC –HANA integration to cater RDS.
• SAP Business Objects Profitability & Cost Management Architecture & Design
• Understanding and analyzing the requirements and involved in the preparation of Design
• Define Data Import Structure and reporting structure
• Understand Objectives and Key Metrics of Multi-layer Allocation
• Define Measure and Variables on Dimension, Periodicity and Date Range.
• Understanding on main transactional costing from ECC COPA and BOM
• Define Web Reporting for Airline industry
• Knowledge on technical Store procedure and understanding on PAS structure
• Understanding on BICA transports
• Integration with BPC report distribution and SSM tool
• Shared 4 RFPS on Grate BI tool (internal tool) on BPC, BI & HANA
• Introduced AAEPS -Accelerated Asset Enterprise Performance Solutions for EPM suite of Products, owning & building multiple assets across industry and shared among prospective to be clients.
• Introduced & Published ideas “ i-think” where resources have the freedom to share their imagination on EPM and also share new ideas and publish in the monthly EPM magazine for COE
• Provide Process Expert support and resolve project related issues. Implement the corrective and preventive actions in the projects

Environment: SAP BPC 10.0, SAP BPC 7.5, SAP EPM 10 NW, HANA, PCM 10

Client, Confidential, San Antanio, TX

Role : Senior SAP BPC EPM / BW Consultant

• Worked on creating Data Models – Creating InfoObjects, Datasource, Infopackage, DTP, Transformations, DSO, Infocubes, Multi providers etc. and optimized the relevant objects for HANA in accordance with LSA++ architecture.
• BPC lead for Design, Build & Deliver
• Perform gap analysis of the existing client’s processes and finance processes available in the EPM framework.
• Custom BADI for Business Process Flows template to suit the business requirements.
• Provide Process Expert support and resolve project related issues. Implement the corrective and preventive actions in the project.
• Track and Report on EPM 10 deliverables status.
• BPC –HANA integration to cater RDS.
• SAP Business Objects Profitability & Cost Management Architecture & Design
• Understanding and analyzing the requirements and involved in the preparation of Design
• Define Data Import Structure and reporting structure
• Understand Objectives and Key Metrics of Multi-layer Allocation
• Define Measure and Variables on Dimension, Periodicity and Date Range.
• Understanding on main transactional costing from ECC COPA and BOM
• Define Web Reporting for Airline industry
• Knowledge on technical Store procedure and understanding on PAS structure
• Understanding on BICA transports
• Integration with BPC report distribution and SSM tool
• Shared 4 RFPS on Grate BI tool (internal tool) on BPC, BI & HANA
• Introduced AAEPS -Accelerated Asset Enterprise Performance Solutions for EPM suite of Products ,owning & building multiple assets across industry and shared among prospective to be clients.
• Introduced & Published ideas “ i-think” where resources have the freedom to share their imagination on EPM and also share new ideas and publish in the monthly EPM magazine for COE
• Provide Process Expert support and resolve project related issues. Implement the corrective and preventive actions in the projects

SAP BW:

• Worked on creating Data Models – Creating InfoObjects, Datasource, Infopackage, DTP, Transformations, DSO, Infocubes, Multi providers etc. and optimized the relevant objects for HANA in accordance with LSA++ architecture.
• Worked in ABAP routines – Start routine, End routine, field routine and Expert Routines in transformations – written codes for master data look-up, filtering data based on complex conditions, used function module for various conversions, etc.
• Created Transient Providers, Composite providers to import native HANA models to BW and also exported cubes to HANA Studio to leverage HANA optimized BO reporting tools.
• Created Open Hub Destination to load the BW data to 3rd party system.
• Created, published and scheduled reports as per requirement on BO OLAP analysis, Explorer and Webi.
• Implemented cells, workbooks and OLAP variables (like Customer exits, formula variables etc.) in BEx.
• Created and scheduled Master data and Transactional Data chains to automate data load process.
• Extensively worked on Business Objects (BO) integration with BW for reporting requirements.
• Extensive experience on developing Web Intelligence Reports and Crystal Reports.
• Experience in Business Objects universe designing (OLAP Universes), Business Objects Web Intelligence (Webi), Business View Manager, InfoView, and Business Objects Enterprise (BOE).

Environment: SAP SSM 10 & BPC 7.0 / 10, SAP EPM 10 NW ,ECC & HANA

Client, Confidential,San Ramon, CA

Role, SAP BPC Consultant

• Understanding business processes and mapping the same with SAP BPC 7.0 MS.
• Understand & Configured client requirement for Applications and Dimensions and Customized
• Understand & Configured client requirement for Applications and Dimensions and Customized validations, Custom Process types
• Configured Business Process Flows -BPF
• Prepared Simple & Complex EVDRe reports using Dynamic templates
• Prepared Complex Input forms
• Preparing Master data uploads for different Dimensions through flat files with the Transformation files.
• Knowledge in using Business Rules & Script Logic for COI and Inter Company transactions,
• Configured Secured Dimensions and Security Concepts
• Knowledge on debugging the Validations in the backend and understand of SQL Server Management Studio database table files.
• Provide technical & process support to team.
• Create re usable assets as per IndoStat guidelines.
• Provide Process Expert support and resolve project related issues. Implement the corrective and preventive actions in the project.
• Track and Report on deliverables status.
• Coaching and Mentoring team members.
• Understanding and analyzing the requirements and involved in the preparation of FDD & TDD.
• Understanding four core applications OutookSoft, Cartesis, Pilot and ALG for EPM 10 integration.
• Worked in the areas of SAP BPC Planning for Sales, Revenue, HCM, P&L and Capex.
• Implemented objects created in Project for above mentioned planning areas.
• Reviewing deliverables to ensure Quality of the deliverables.
• Extensively worked on flat file upload and Integrated BI Upload using 'How to papers... into SAP BPC'. And worked on BPC Reporting. These How to papers were converted into Reusable assets using IndoStat standards.
• To map the existing Finance processes of existing client with the leading processes available in the EPM.
• Perform a gap analysis of the existing client’s processes using the finance processes available in the EPM framework.
• Using the EPM, perform a fit-gap analysis of “As-Is” client processes and identify improvement areas.

SAP BW:

• Utilized new BI 7.3, Dataflows, transformations and DTPs for all new developments.
• Developed numerous custom datasources using database views and custom function modules.
• Implemented new BI 7.3 security authorization objects.
• Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.
• Involved in activating Business Content for Standard Info Objects, DSO, InfoCubes related to FI, CO-PA, SD.
• Experience in upgrading to BI 7.0/7.3 and in depth knowledge of migrating data sources from BW 3.5 to BI 7.0/7.3 .
• Involved in creating many complex OLAP variables, DTP routines.
• Generated CO-PA redesign which involves addition of more fields with complete different flow and was involved in complete end to end testing for all the developments assigned.
• Performed LO-Cockpit extraction for Sales Order, Sales Delivery, and Billings by extracting Standard DataSources from the Business Content using LO-Cockpit extraction methods for Transactional data and enhanced them to meet the reporting requirements.

Environment: SAP BPC 7.5 NW ,SAP EPM 10 NW ,ECC BI & HANA

Client: Confidential , CINCINATI, OH

Role: SAP BPC Consultant

• Understanding business processes and mapping the same with SAP BPC 7.0 M.S.
• Understand & Configured client requirement for Applications and Dimensions and Customized
• Understand & Configured client requirement for Applications and Dimensions and Customized validations, Custom Process types
• Configured Business Process Flows -BPF
• Prepared Simple & Complex EVDRe reports using Dynamic templates
• Prepared Complex Input forms
• Preparing Master data uploads for different Dimensions through flat files with the Transformation files.
• Knowledge in using Business Rules & Script Logic for COI and Inter Company transactions,
• Configured Secured Dimensions and Security Concepts
• Knowledge on debugging the Validations in the backend and understand of SQL Server Management Studio database table files.

Environment: SAP BPC 7.0 Microsoft

Client, Medco Health Inc,Franklin Lakes, NJ Duration, February 2009 - October 2010

Role : SAP BPC Consultant

• Knowledge on the Business scenario and Business process of the client in terms of implementing BPC 7.0.
• Knowledge on the client requirement for Applications and Dimensions and Customized Validations, Custom Process types.
• Worked on Input Schedule and Reports
• Good knowledge in using the Script Logic
• Good knowledge on Secured Dimensions and Security Concepts
• Have good knowledge in BPC Statistics. Posses knowledge and utilized the different EVDRe functionality

Environment, SAP BPC 7.0 MS & NW

Client : Confidential, New York, NY

Role : SAP BW Consultant

• Involved in the project from User requirements gathering, Business Blueprint, Realization and Testing Phases.
• Participated in teams and projects to understand business needs, design and recommend solutions, and provide support on the evolving BI environment.
• Interfaced the business users to develop an understanding of the business processes and user requirements at a depth sufficient to recommend and implement an appropriate BI solution to meet business needs and address the enterprise BI vision within the company.
• Involved in BW 3.5 to BI 7 upgrade processes and was responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO.
• Extensively involved in the scheduling and monitoring using process chains in Administrative Workbench.
• Provided complete solution in BW in the following metrics analytics Sales and Distribution, Account Receivable, Account Payable, and Profit Center Accounting.
• Managed, and monitored several data loadings, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Ensured BW data quality, reconciliation and validation with R/3 and external Source Systems, governance, and master/transactional data alignment/realignment.
• Created queries with variables, filters, exceptions, conditions and developed different reports in SD, AR, AP and PCA functional areas using BEx analyzer.
• Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries.
• Extensively used BEx analyzer, created queries with variables, filters and performed detailed reporting, published several web reports and worked on InfoSet queries using BEx analyzer.

Environment: BW 3.5/7.0, R3 4.6C, BEx, FI, SD, MM, PP.

Client : Confidential , Minneapolis, MN

Role : SAP BW consultant

• Actively involved in the requirement analysis, data modeling and technical implementation.
• Responsible for Design the FDD's and TDD are based on business requirements.
• Taking care of production support activities like loading the data, monitoring and improve the System Performance.
• Worked on Data modeling Considerations.
• Updating the Marketing attributes from BW to CRM Using APD Interface.
• Worked on Customer 360 view to increase the effectiveness of employees who are interacting with Customers.
• Designed and developed the multiple Infocubes and Multiprovider to analyze the Opportunities, Activities, Quotes, and Contracts.
• Developed the Sales order, Delivery, Backlogs, and Billing info cubes based on the client reporting requirements.
• Worked on reports (Billings, Bookings and Backlogs) using Bex.
• Worked on Campaigns (Saves and MSF).
• Worked on reports (Order process, Saves, Student services, Coaching, Retentions, and Inside sales) using BEx published the reports into the roles.
• Created the process Chains and automated the load process based on the business needs.
• Worked with SAP on CRM Extractor Delta Issues and suggested the Basis Team to Apply the OSS Notes in the system.
• Resolved many issues that came in Production support
• Environment: SAP BW 3.0B, Oracle, CRM 3.1, R/3 4.0, Java Script, and Non SAP systems.
• Worked extensively in the finance modules like FI-AR (Accounts Receivable), FI-AP (Accounts Payable) and FI-GL (General Ledger).
• Installed Business content for FI-GL, FI-AR and FI-AP business content cubes according to the business requirement.
• Extracted Data from Purchasing and Inventory Management.
• Extracted data from MM module and uploaded the data into the procurement cubes.
• Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.

Environment : SAP BW 3.1C, SAP R/3 4.6C, SD, MM, IM, FI.

Client : Confidential , San Ramon, CA

Role : SAP BW consultant

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing to go live and production support.
• Developed BI solutions such as data models, information objects and info cubes for projects to fulfill business needs and requirements.
• Involved in complete life cycle implementation of SAP BI in SD, MM and FI modules.
• Worked on ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Created data sources using generic and application specific extraction (LIS) for SD and MM modules and loaded the business content.
• Analyzed business reporting requirements that could be satisfied and activated/modified corresponding Business content InfoCube Sales
• Extracted Data from Purchasing and Inventory Management.
• Extracted data from MM module and uploaded the data into the procurement cubes.
• Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.
• Support Activities Performed.
• Monitoring Data load activities and recovered failures in Dev, Quality system as a part of unit testing.
• Preparing the process documents for each and every enhancement.
• Involving in solving high-prioritized tickets regarding extractions, performance issues and data load failures.
• Working on process chains to automate the Deleting indexes in Infocubes, Process of info packages, creating indexes, ODS activation, further updating, PSA request deletion and Attribute change run so on.
• Using open hub to export data from BI to External systems (flat file, table, 3rd party tool).
• Involving in Unit testing, Integration testing, Regression testing and User acceptance tests.
• Enhancing the existing reports as per the new requirement.
• Monitoring the daily loads to various data Confidential s in the system.
• Monitoring the process chains on the basis of daily, weekly & monthly.
• Manual loading and rolling up the data into data Confidential s.
• Maintaining the logs for each manual load.
• Creating aggregates to improve the query response.
• Performance tuning of queries using aggregates, indexing of Infocubes.

Environment: SAP BW 3.1C, SAP R/3 4.6C, SD, MM, HR, FI, CO

Client : Confidential, Glendale, CA

Role : SAP ABAP consultant

• Understanding the requirements and getting clarifications for the change requests and Enhancements,
• Documentation process for production related issues.
• Preparing TSD, QG4, QG5, Approval related documents.
• Preparing Test Plan Specifications and conduct Unit Testing.
• Coordinating the reviews and Code Walk Through with Internal Quality Assurance, External Quality Assurance and Final Inspection.
• Shipping the deliverables to the clients directly.
• Developed a report to check current moving average standard price and purchasing frequency of purchased material and to revise the ordering frequency of materials.
• Developed a report to display the stock status of the materials including the stock on order.
• Developed a Shipping performance report.
• Developed a report for displaying sales order details using ALV.
• Developed a Vendor expenses summary Report.
• Developed Print program to Print BAR Code for Production Order.
• Developed an interactive ALV Report, which displays customer's numbers ALV grid, and customer orders and items displayed in interactive lists.

Environment: SAP R/3 4.6C, SD, MM, IM, FI.