SUMMARY

• Over 14 years of technology consulting experience with twelve years of hands - on SAP implementation experience in SAP BI & Data Insights.
• My technical area of expertise in SAP for SAC, BW/BI, BPC, IP & Adaptive insights. I have extensive experience in projects and performed in many different roles within Media industry & retail.
• Highly successful as an SAP Planning Team lead, BW consultant by relying on my people soft skills, deep cross-functional knowledge, strong analytical skills.
• Certified in SAC, SAP BPC 10.1, 11.0 & SAP S/4 HANA Financial accounting.
• Involved and built full life-cycle implementation projects (ASAP Methodologies) with the experience on Implementation, Designing, Development, Performance Tuning, migration, Go-Live, Post Go-Live and Production support activities. Also Includes BI Lead experience.
• Responsible for efficiently delivering the project and supervising the implementation team.
• Management experience in Onshore & offshore team members.
• Proven ability to lead stakeholder engagement meetings, facilitate working group discussion and problem solving, resolve challenging situations and focus group energy on the highest priority objectives
• Working with executive management teams to formulate or re-specify project objectives and key project design decisions.
• Expert in optimizing views, ETL, Data modeling/warehousing, Data analysis/visualization in SAP Analytics Could. Specializing in Business Intelligence and planning developed through years of technology contracting and consulting roles in large media organizations.
• Involved in complex financial Requirement gathering, analysis, identifying the Gaps in the requirements given by various business units across the corporate level.
• Expertise in SAP BI Planning solutions BPS/IP & BPC applications.
• Experience in SEM-BPS and Integrated planning Environment architecture with planning area, levels package, planning filters and complex Fox functions with planning sequences.
• Extensively worked on SAP Analysis office 2.2(BOBJ) and build the complex reports and planning templates using Integrated planning solution.
• Built the complex BPC EPM planning templates of Cost center and overhead planning solutions.
• Expertise level in creation of BPC Models and Data Manager packages.
• Developed the solution on SAP Analytics cloud to replace the BPC.
• Expertise in script logics, Transformation and conversion files in classis SAP BPC 10.1
• Extensively worked on SAP HANA data modeling using attribute view, Analytical view and Calculation views.
• Extensive experience on BW HANA ADSO’s, Composite providers, Open ODS views.
• Expertise and built the complex planning folders and planning sequences in SAP BPS solutions.
• Involved in creation of Object-oriented ABAP classes with IP Planning functions.
• Involved in the GAP Analysis for all reports which are applicable to OTC, P2P, FI & Projects System areas.
• Technical Expertise includes BW Business content activation for SD, MM, HR LSO, IM, PS FI /C0 & CPM application areas.
• Expertise in LO-COCKPIT Extraction and creation of Generic Data sources (Table, View & Function Module) as per the reporting requirements.
• Experience in enhancing the standard Data sources as per the requirement.
• Expertise in Data Archiving in BW/BI by ADK process.
• Experience on PBS CBW COCK-PIT and Analyzer to create the indices and providing access to archived data for users.
• Experienced in scheduling reports in Information broadcasting.
• Experience in Crystal reports design and support activities.
• Expertise in developing ABAP objects like ABAP reports, function modules, Includes, Customer exits and developed business logic for Transfer and Update routines, Transformations and enhance the Data source User Exits.
• Hands on Experience on Adaptive application using Cube, Model Sheets and report as part of Workforce planning and Expense projects.

TECHNICAL SKILLS

Analysis and Design: MS-Excel; MS-Visio; MS-Access for prototyping

OS: UNIX on HP servers; Windows NT; MVS on IBM servers

DBMS: Oracle; HANA 2.0

SAP: SD, MM, S/4 HANA, FI/CO, PLM, CRM, SAP R/3, ABAP /4, ALE-IDoc, EDI, SAC, SAP BW SAP BW 7.4, SAP HANA Studio 2.0, SAP NW BW 7.0 & EHPs, 7.3, SAP HANA SPS 9.0 & SLT, SAP BPC 10, S/4 HANA Group Reporting, SAP Business Objects, SAP Query Designer

PROFESSIONAL EXPERIENCE

Confidential, Burbank, CA

SAP BPC Lead

Responsibilities:

• Involved in initial setup, prototype, configuration, and perform testing accordingly to support the design sessions and to fulfill the customer’s business requirements
• Involved in Design and document the required configurations for the SAP Analytics Cloud solution Business Blueprint phase.
• Recommended the best practices for configuring SAP Analytics Cloud considering the overall architecture to achieve integration, high performance and stability
• Involved in Documenting the SAP Analytics Cloud technical and system related key decisions.
• Involved in Setup and configure security requirements.
• Worked on a visualization expert to implement the best visualization stories for customer’s business KPI’s.
• Extensive experience in data modeling and preparing datasets, merging, appending, custom hierarchies, custom calculations, groupings, formatting values, data wrangling, dimensions, and Measures
• Design and built SAC planning, forecasting and budget models and related reports & dashboards to support the business key KPIs.
• Involved in SAC P2P project to display P2P data.
• Expertise in creation of Dashboard story in SAC using Canvas, Responsive pages and Digital boardroom.
• Built the planning layouts using Advance Table features like table, side calculations, Number Formatting and Cell Visualizations.
• Created different stories based on the models using Input controls, cross calculations, calculated measures, Complex Calculations & Advanced filters.
• Involved in SAC project for Consumer Products Business Unit to replace the BPC EPM add-in planning into Web based SAC.
• Integrated Data actions for plan cycle data copy functions from stories.
• Expertise in data actions of Copy and Cross Model copy functions.
• Created public and private versions for plan data for Business unit and corporate level users.
• Developed script formulas to perform budget and forecast functions.
• Scheduled the import data function.
• Handle the Currency conversion logics for plan data set.
• Built the BPC Employee and Operational planning templates in BPC 10.1.
• Expertise in script logics, Transformation, and conversion files in classis SAP BPC 10.
• Built the complex BPC Data Manager packages using script logics for Actuals and plan data.
• Created Custom Copy and clear Data Manager Packages for plan cycles.
• Created Journal Entry load data Manager packages for BPS JE’s.
• Scheduled the AO reports with SAP BOBJ.
• Built the complex FP&A planning templates and reports in SAP BPC & BPS/IP platforms.
• Involved in Enhancements of BPC & BPS related objects and YEF plan cycle and Monthly plan cycles.
• Developed custom VBA macros for user planning templates to perform BPC EPM Calculations for Labor and Cost center allocations costs.
• Provide architectural design and technical expertise for implementation of complex technical strategies.
• SAP HANA data modeling using attribute view, Analytical view, and Calculation views.
• Build and enhance ABAP objects like ABAP reports, Function modules and Classes, Expert Routines, Custom Routines, User Exits, BADI.
• Built the Planning aDSO’s (ADSO) for overhead data sets on SAP BW on HANA.
• Design & Built the Composite providers for SAP Actuals from different Ledger’s data.
• Built the complete design and configuration of end-end SAP BW-Integrated planning solutions.
• Developed the IP solution for Allocations using SAP Analysis office 2.4 with planning functions, planning sequences and Aggregation levels.
• Create Basic and Multi Planning Areas, Planning Levels, Planning Functions, Global Planning Sequences, Planning Profiles in BPC Planning.
• Perform analysis and design, write technical specifications, configuration, and programming in the SAP/BI environment, including testing and implementation.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical issues.
• Create web templates using Web Application Designer, assigning queries to template and publish reports in Portal Roles.
• Build Workflow locking mechanism using ABAP exit classes.
• Implement costing mechanism to run across all business units.
• SAP HANA 1.0 & 2.0 data modeling using attribute view, Analytical view and Calculation views.
• Built analysis office planning template for allocations, overhead & employee data set.
• Build the complex custom function types to fetch the data from third party systems.
• Involved in SAP BPC retraction methods to push the data BPC landscape to BI landscape.
• Build custom VBA macros for user planning templates to perform BPC EPM Calculations for Labor and Cost center allocations costs.
• Build and maintain the rolling forecast vs. plan for WW TV Distribution Financials in SAP BPC.
• Build BPC Planning templates and models to save and data slice the corporate data of Confidential .
• Design BPS Copy functions move data across all the planning versions during costing and Ultimate’s planning.
• Build and enhance BI objects such as Info Objects, Info Cubes, Info Sources/Data Sources, Master Data, Transformations, Update Rules, ODS, Extractors, Info sets, Aggregates, Process Chains.
• Developed the IP solution for project Systems SAP(PS) as Capital Budget System.
• Created Custom Input Planning templates for Capital and expense project planners.
• Created Formula and ABAP based Planning functions and planning sequences.
• Created copy planning sequences for projects across the versions.
• Created Aggregation levels, Multiproviders & real time cubes for comments & plan data.
• Built master (Project & WBS elements) and transaction data flow for Project Systems from SAP ECC.
• Involved in Hyper care and Support activities of CBS applications.
• Developed recon reports in SAP BW across the SAP ECC reports.
• Maintain the master data for person responsible project planners.
• Implemented data slice and locking mechanism based on planner groups
• Interacted with Business users actively during the planning cycles.
• Involved in the security design for CBS planners across the WB.
• Handle the complex issues during BW upgrades related to CBS application.
• Handle the currency conversion based on planner groups.
• Implemented plan control table to handle the exchange rates to perform currency conversion.

Confidential, Burbank, CA

SAP BPC 11.0 Embedded Planning Consultant

Responsibilities:

• SAP HANA data modeling using attribute view, Analytical view, and Calculation views in S/4 HANA BPC.
• Built analysis office (BOBJ) planning template for allocations & overhead & data set.
• Built the Planning aDSO’s for Digital and overhead data set.
• Build the complex custom function types to fetch the data from third party systems.
• Created data allocation methods to move data across various planning versions
• Build Complex IP functions for planning models for Digital & Theatrical applications data set.
• Configure the standard Concenter accounting planning templates and objects.
• Involved in realization and Hyper care phases of Project.
• Designed the forecast copy functions across the year and periods.
• Design the security roles for TV & Theatrical application.
• Design the security auth objects for planners.
• Custom AO reports and planning templates Digital and Theatrical applications.
• Design the test cases and scenarios during UAT phases.
• Build all custom BW BPC objects for planning solutions.
• Created complex planning objects like Planning sequences, filters, copy & clear functions.
• Created custom copy functions for Digital and TV models.
• Created Custom models for planners.

Confidential, Fort Worth, Texas

SAP BW Consultant

Responsibilities:

• Involved in requirement workshop of LSO reports and understanding of Legacy System architecture. Finalized the scope of LSO project.
• Involved in requirement analysis of all reports from understanding of workshop and got the required information from report owners.
• Major role in the SEM-BPS implementation. Involved in gathering the functional requirements and converted them to technical specs.
• Created the necessary BW configuration for the BPS implementation. Created planning areas, levels, packages, layouts and functions necessary for forecasting.
• Created Individual Planning layouts for Sales, Cogs and SG&A to Rollup to income statement planning. Created planning sequences to facilitate the process.
• Created FOX formulas to do rollup based upon version and account combinations. Used Characteristic Relationships to derive Breakdown details based upon account combinations
• Involved in GAP Analysis is done for all the reports which are in the requirement.
• Identified required Data sources, Info objects & Info providers specific to LSO application.
• Info provider and Multi providers are designed and Developed as per the report requirements.
• Involved in the creation of technical specs for the Data sources and Info providers.
• Involved in Business content activation for LSO.
• Two levels of Staging DSO’S are created for all Transaction Data Streams.
• Involved in enhancements for LSO standard data source and Employee Master Data.
• Write Optimized & Standard Data DSO’S are considered as part of development.
• Created Custom BW objects for required qualification, Completed Qualifications & required courses for an Employee.
• Created custom Bex queries writing with the functionalities of filters, calculated, restricted key figures, variables & currency translation.
• Involved in Universe creation on SAP BI Bex queries.
• BO Reports are created in Web Intelligence as per the user requirement.
• Experience in BO Web functionalities like filters, Variables, formulas, Data purge & merging the query.
• Support & Maintenance Activities
• Designed all process chains specific to LSO.
• Monitor the data loads through process chains as per the scheduled time.
• Necessary action taken for data load failures and updated the incidents in Remedy tool with resolution.

Confidential, Santa Ana, CA

SAP BI Analyst

Responsibilities:

• Involved in analysis of report FSR’s and identified the Data source and Data targets for the reports.
• Identified the Enhancements for the Standard data sources and data targets for SD, MM & FI/CO-PA functional areas.
• GAP Analysis is done for all the reports which are in the requirement.
• Info provider and Multiproviders are designed and Developed as per the report requirements.
• Involved in the creation of technical specs for the Data sources and Info providers.
• Involved in Business content activation for SD, MM, IM, HR, PM, FI (AP, AR, GL) functional areas.
• Involved in Creating Transactional info cubes for SEM-BPS.
• Designed BPS Planning Environment architecture with area, level, package and Fox functions.
• Involved in creating BPS scenarios for Sales Planning, forecast and Budgeting Staging custom DSO’S are created for all the standard data sources.
• Involved in enhancements for standard data sources for Sales, Delivery & Billing applications.
• Involved in maintaining the ALE Delta for Generic Master Data sources.
• Involved in the creation of Custom Info cubes, DSO’S, and Info sets & Multiproviders for OTC, AFS business Content activation, P2P, FI, AP, AR, GL, PS, IM&AM.
• Involved in Migration of Transaction and Master Data sources.
• Written complex routines (look up) in order to populate Sales Manager, Inside salesrep & outside salesrep in Sales document DSO from Partner function DSO
• Characteristic routines are written in order to convert lower case to upper case letters.
• Involved in Developing Open hub destinations for all Info providers.
• Created custom Bex queries writing with the functionalities of filters, calculated, restricted key figures, variables & currency translation.
• Involved in Universe creation on SAP BI Bex queries.
• BO Reports are created in Web Intelligence as per the user requirement.
• Experience in BO Webi functionalities like filters, Variables, formulas, Data purge & merging the queries.
• Taken care of all issues during final preparation and Go-live phases.
• Support & Maintenance Activities in Ingram
• Monitor the data loads through process chains as per the scheduled time for Singapore and New Zealand regions.
• Necessary action taken for data load failures and updated the incidents in Remedy tool with resolution.
• Monitor the extraction queues in SAP R/3.
• Managing, reviewing, answering and resolving Remedy tickets.
• Involved in the development for new requirements for Customer Back orders & Sales Margin Reports.
• Involved in Analysis of Data related incidents raised by users.
• Reconciliation activity done for Finance reports on monthly basis.
• Involved in Data load activities of Full & Delta loads.
• Involved in filling of Setup tables as part of Unit testing, integration testing & User acceptance testing in Dev, Quality & Test Systems.
• Having lead experience during implementation and Production Support phases.