PROFESSIONAL SUMMARY:

• 10+ years of IT experience with strong background in SAP BW/HANA technologies such as HANA 1.0 (SP 12), BW 3.x, BI 7.0,BO 4.x, BW on HANA (7.3, 7.4, 7.5), SAP BW4HANA, SAP DSIM 3.0.
• Worked in various Industries such as Food and Beverages, Retail, Health care, Manufacturing.
• Expertise in Solution Design, Implementation, Upgrade, Migrate and Production Support for various business solutions in the areas of SAP BI/BW, HANA & BO (WEBI).
• Involved in requirement Gathering, Blue Printing
• Proven ability to manage and communicate with multidisciplinary distributed teams (onsite/offshore) including designers, developers, architects, and executives with exceptional analytical and organizational abilities.
• Exposure in SAP functional areas including SD, MM, CRM, FICO, CGP (Consumer Goods and Products) and technical areas SAP BODS.
• Expertise on SAP Demand Signal Management 3.0 on HANA.
• Team player through all phases of Software Development Life Cycle including Requirement analysis, design, development and testing, go - live, rollout and post implementation support of SAP BW/HANA Projects.
• Highly self-motivated, very eager to learn and work on new technologies, keen on handling challenging assignments and capable of working on multiple engagements simultaneously.
• Extensively worked on Integrated planning.
• Application certified associate in SAP HANA.

SKILL:

• Implemented 6 end-to-end full-life cycles using ASAP methodology across various modules in SAP BI/BW, BW on HANA and Native HANA projects.
• Worked with cross-functional project teams on different phases of implementation - Requirement Gathering, Solution Design, Solution Build/Development, Testing, Preparation of Cutover Plan and Deployment.
• Adept in analyzing information system needs, evaluating end-user requirements, custom designing solutions, and troubleshooting any problems in the process.
• Designed and developed SAP BW Data Modelling & Reporting includes creating of Info Objects, Data Store Objects, Info Cubes, Multi-Providers, Transformations, Routines, DTPs, Info Packages, Aggregates, Process chains, Index creation, Open Hubs, APD, customer exits and delta handling for standard/custom extractors.
• BW data load scheduling (daily, weekly and monthly), monitoring and troubleshooting data extraction/load problems.
• Hands on experience of ABAP to deal with BW-ABAP requirements (Routines, enhancements, generic data sources and Customer Exits).
• Created the Aggregation levels, planning sequences, Planning Filters, Data Slices and Planning Functions using RSPLAN. Extensively worked with the top down and bottom up planning function types
• Extensively worked on ABAP Managed Data Base Procedures, Advanced Data Store Objects, Composite Providers, Open ODS Views and Hana Analysis Process Designers.
• Reporting: Front-end Business warehouse components: Extensively worked on Bex
• Queries, Bex Analyzer, calculated Key figures, Restricted Key figures, Structures, Variables, Exceptions and Conditions, Work Books, RRI Jump Queries and Bex Information Broadcasting.
• Experience in implementing Warehouse and Reporting Solutions (Analytical, Operational & Strategic) for various functional areas like SD, MM, PP, FI and COPA.
• Exposure on BW 7.4 migrating experience with DMO option, involved in the pre-migration and post migration activities and issues after migration, involved in the house keeping activities and Exposure on BW 7.5 upgrade.
• Experience in SAP HANA development, optimization and support for mixed approach within Native Hana and SAP BW on Hana solutions.
• Worked on Schemas/Packages, Tables, Calculation Views and defining Joins, Attributes and Measures.
• Defining Calculated Columns to achieve specific business KPIs. Decision Trees to modify data and experience with Complex SQL stored procedures.
• Worked on the SAP HANA production issues, HANA performance Optimization and experienced in analysing the SAP HANA SQL procedures.
• Working Knowledge on CDS Views, Decision Tables, ABAP Managed Data Base Procedures.
• Data Provisioning: Experience in data provisioning with SLT, SDI, BODS.
• Reporting: Integration of SAP HANA models with SAP Business Objects 4.1 tools - WEBI
• Created the Universe using Information Designer Tool on HANA Calculation Views and Generated the WEBI Reports.
• Expertise on designing and Building the CDS Views in SAP HANA.
• Implemented different types of Routines to customize the data flow in achieving the desired output solutions in SAP BW.
• Expertise in the Enhancements of LO, CRM Data sources.
• Expertise in Customer Exists to achieve the desired Reporting Solutions.
• Experienced in sorting out the Performance techniques in Routines to Optimize the Data Extraction process.
• Proficient Debugging Knowledge across the BW Data flows and Customer Exists.
• Experience in creation of Function Modules.
• Expertise in configuration of Data Delivery Agreements, Data origin, Data Provider, Context, Data sets.
• Expertise in configuration of Files and Files set definition.
• Expertise in Harmonization of External data with Internal SAP data.
• Expertise in configuration of mapping instructions sets, sequences, functions.
• Expertise in configuration of Process Definitions.
• Expertise in on boarding of Point of Sales and Market research Data from Nielsen and IRI.

PROFESSIONAL EXPERIENCE:

Confidential, Glendale, CA

Sr. BW HANA Lead/Process Area Lead/Onsite Delivery Coordinator

Environment: SAP HANA, Business Objects - Web Intelligence, MS Power BI

Responsibilities:

• Interacted with Business stakeholders in order to understand their structured and ad-hoc reporting requirements, User stories, business Marketing and Sales domains.
• Interacted with Business stakeholders in order to understand their structured and ad-hoc reporting requirements, User stories, business Marketing and Sales domains.
• Created Technical Specifications document, Functional Specification Documents, Report Design Documents.
• Created HANA Procedures, functions, Tables, created the HANA Calculation views, Attribute views and Analytical views and exposed it for the reporting.
• Created Tables and Views using CDS Artifacts.
• Extracted and transformed the data remotely using Smart Data Access (SDA) and Smart Data Integration (SDI).
• Configured and Replicated the ECC Tables using SLT for retail time data and modelled the Calculation Views.
• Created Open ODS Views, Composite providers and BEX Queries.
• Created, Reports, Charts using the power BI Visualization.

Confidential

Environment: SAP BW 7.5, SAP DSIM 3.0, SAP HANA 1.0 (SP 12), Business Objects - Web Intelligence.

Responsibilities:

• Involved in Collaborating with Client managers, Reporting team, Business users and other Stake holders to understand SAP HANA, the existing landscape and identify key business use cases for the Proof of Concept POC .
• Interacted with Business stakeholders in order to understand their structured and ad-hoc reporting requirements, User stories, business Marketing and Sales domains.
• Created Technical Specifications document, Functional Specification Documents, Report Design Documents.
• Designed Open ODS view, Advanced DSO, Composite providers, analytical views, calculation views- graphical and SQL scripted stored procedures and consumed those models into Bex Query designer, Analysis office and BO WebI.
• Created SQL Stored Procedures to implement complex logics and integrate them with HANA Views and Composite Providers.
• Created Calculation Views to meet new reporting requirements in HANA Studio using different joins (inner join, outer join, referential join etc) and union to connect tables.
• Created HANA Expert Routine to Leverage the HANA DB and provided the performance of data loads in EDW.
• Coordinate with Business users and completed the Market Integration Tests and Market Acceptance Tests.
• Worked closely with users and resolved the user defects on the solution with in the time line.
• Worked on Pre Transport and Post Transport Manual Actions during the deployment of application.
• Extensively worked on Hyper care Support and resolved all the issues.
• Trouble shooting experience with end users, business analysts about the day-to-day work process.
• Prepared the documentation for the Sustain Handover and successfully Handover the solution to the Sustain Team.
• Created Change Requests and coordinated with BASIS Team to progress the developments to Production.

Confidential

Environment: SAP BW 7.4, SAP DSIM, SAP HANA.

Solution designer and Onsite coordinator

Responsibilities:

• Led 6 members Team (Onsite / Offshore Model).
• Served as a Solution Designer and Onsite Coordinator.
• Discussed business solutions with Nestle Business Analysts, resolve existing problems and improve the application stability.
• Requirements gathering and analysis, time estimates, preparing design documentation, design reviews, development, testing and deployment of application enhancements, project planning.
• Consulted customers or other departments on project status, proposals, or technical issues, such as software system design or maintenance
• Prepared and Presented the Technical design to Nestle Business Analytics Stream Lead.
• Prepared Functional Specifications to BODS Source team.
• Prepared Test Scripts for Market Acceptance Test and Market Integration Test.
• Conducted Daily Operations Review meetings with Offshore to get the Status on the Developments, Road Blocks and Next Actions.
• Created or Configured data flows in SAP HANA, SAP BW and SAP DSIM using various BW/HANA Objects.
• Created Infoobjects, Data sources, Open ODS Views, Advanced DSO’s, Composite Providers, BEX Queries, Transformations using Expert routine and SAP HANA Expert routine.
• To Leverage SAP HANA Data base, Modelled various Objects using Attribute view, Analytical View and Calculation View, Procedures etc.,
• Created WEBI Reports on BEX Queries.
• Created Change Requests and coordinate with BASIS Team to progress the developments to Production.
• Coordinated with BODS SPOC’s and supported BODS Team for successful completion of Unit Testing and Integration Testing.
• Provided Hyper Care Support for the newly implemented solutions.

Confidential

DSIM Developer

Environment: SAP BW 7.4, SAP DSIM, SAP HANA.

Responsibilities:

• Participated in discussions with client’s project team to take up the client’s requirements, understanding the requirements, and planning the smooth delivery as expected.
• Designed and developed DSOs, Info cubes and Multi Providers for data loads and reporting requirements.
• Transportation of BI objects across the landscape and trouble shoot the transport conflicts.
• Created Data sources for BODS Team to load the data in BW.
• Configured Retailer Data On boarding in DSIM.
• Configured Data Delivery Agreements, Data origin, Data Provider, Context, Data sets, File set Definition, Process Definition.
• Configured the Harmonization Process to Harmonize the Internal data with External data.
• Configured mapping instructions sets, sequences, functions.
• Created Calculation Views, Advanced DSO’s, Open ODS Views and Composite Providers.
• Created Native HANA Objects such as HANA Calculation views, Attribute views, Analytical Views, Procedures, Tables, synonyms etc.
• Created BEX Queries according to the user’s requirement and exposed the BEX reports for WEBI and Analysis for Office reporting.

Confidential

Environment: SAP BW 7.4 on HANA.

Responsibilities:

• I had served as an Associate Process area Lead for a team of 9 members.
• Implemented End to End Flows for Sales orders, Deliveries, Promotions, Billing e.t.c.,
• Analyzed the requirement and convert the Functional specifications to the Technical Specifications.
• Implemented and enhanced various fields to LO Extractors Such as 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 02 SCL, 2LIS 11 VAITM, 2LIS 11 VAHDR, 2LIS 11 VASTH, 2LIS 12 VCSCL, 2LIS 13 VDITM.
• Worked on Data Warehouse Workbench - Info Cubes, DSO Objects, Info Sources, Transformations, DTP Info packages, Data sources, Business Content & Data Marts, process chains to suit the Business requirements, ERP, LO Cockpit, Generic Extractions, Master and Transactional data Extraction, Activating Data sources, Setting of V3 update, deleting setup tables and filling up of setup table.
• Involved in transporting objects from Development to quality and other systems in Landscape.
• Designed queries in BEx Query Designer and Restricted key figures, Calculated key figures, Variables, Filter, Free Characteristics, RRI.
• Exclusively Involved in Performance Related issue - Improved data load and query performance.
• Expertise in day-to-day activities like Scheduling, Monitoring process chains for daily Master data and Transaction data, Changing and activating reports as per the requirement, Handling Tickets, Data load failures.
• Worked on Warehouse Architecting reporting requirements into technical design and development. Created Info providers & BEx queries to simulate/validate results achieved from Design Studio reports.
• Capable of handling various day-to-day Tickets of all priority/severity levels on both Incident Tickets and Change Request Tickets.
• Worked on BEx Query Designer, BEx Analyzer to develop various queries based on user requirements as well as utilization of business content related queries and workbooks.
• Designed and developed Cost Center, Capital Expense and GL Planning using RSPLAN - Integrated Planning
• Developed copy function for multiple versioning based on planning cycle, data slice used for locking the data.
• Extensive use of BW-IP features covering Variables, Data Slices, User Exits, Functional Modules, ABAP and FOX formulas.
• Planning application was accessed via Analysis Office tool

Confidential

Environment: SAP BW 7.3.

Responsibilities:

• Understand the Technical Specifications from the Nestle Solution designers.
• Analyse the FI and Cost Accounting data flows according to the technical design and provide an estimates of the developments to Nestle Project Management.
• Created or replicated the data sources from the MONO system in BW.
• Built the data flows in LSA Architecture i.e., Built the Pass through, corporate Memory, Propagation, Business Transformation and the reporting Layer.
• Built the info packages and the process chains to schedule the data loads in Business warehouse.
• Mapped the Newly created cubes into the Existing Multi Provider.

Confidential

Subject Matter Expert (SME)/ M&S Support Lead

Responsibilities:

• Good Functional knowledge of all the Information areas of Lighting and Luminaires Landscapes.
• Worked extensively in the Functional areas: Marketing and Sales.
• Good knowledge on Sales and Orders, Billing Documents (COPA).
• Served as the Data Monitoring team lead for a team of 8.
• Acted as a Functional Support Lead area Marketing and Sales.
• Handled load plan executed after Release activities, Perform Pre-Cutover, Post-Cutover activities during Releases, Handling System Outages and Housekeeping activities.
• Handle Change request, Corrective changes, Adaptive changes.
• Perform SIT and Unit testing for newly changes in the system.
• Performance Optimization and maintenance of BW via Housekeeping activities, PSA deletions, Data base Log deletions
• Identification of Design flaws in existing flow and worked towards improvements by proposing Changes to the Solution Owners
• Analysis of Short Dumps like SQL error during upload and interaction with the BASIS Support.
• Worked on different types of Data Store objects like Standard DSO and Write Optimized DSO.
• Performance Tuning via aggregates, DB statistic, DB indexes and Partitioning.
• Developed process chains to automate the initialization and delta updating of all data.
• Involved in Support pack upgrade and release activities.
• Finding the issues and resolve in the month end activities.
• Resolving master data load issues and reconciliation with R/3.
• Coordination with various Service Vendors including Basis, S&A, Interface team and APO Functional Teams.
• Creating KPI dash boards for auditing the tickets OLA’s.
• Helping to users to raise incident/SR/CR to respective team and provide access to raise calls (if user not having access).

Confidential

Responsibilities:

• Worked on extracting data from ECC using LO and Generic Extractions.
• Involved in installing Business Content Objects as per the Business requirement, end to end design and construction of Info Objects, Data Sources, Info Cubes, DSOs and Multiprovider to suit the Business requirements.
• Designed and modified Transformations, Info packages and DTP’s (Data Transfer Process).
• Extensively worked on BEX Reports providing insight of Business Intelligence as Decision making tool for Business Analyst using Formulas, Selections, Structures, Conditions, Exceptions, Filters, Free Characteristics, Restricted Key Figures and Calculated Key Figures.
• Hands on experience using Characteristic, Text and Formula Variables using different Processing types.
• Designed APD’s to improve the Query Performance.
• Created various Process Chains to automate the data loads from different source systems.
• Analysed Query performance to suggest optimizations as per theory and practical observations.
• Involved in transportation of BI objects across the landscape and analysing the transport failures.
• Developed Sales reports: open order, lost sales and complete orders report