PROFESSIONAL SUMMARY

• 8+ years of IT experience wif 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 DSIM 3.0.
• Worked in various roles such as Consultant, Senior Consultant, Associate Process Area Lead, Team Lead, Solution Analyst, Solution Designer and Onsite Delivery Coordinator.
• Expertise in Solution Design, Implementation, Upgrade, Migrate and Production Support for various business solutions in teh areas of SAP BI/BW, HANA & BO (WEBI).
• Proven ability to manage and communicate wif multidisciplinary distributed teams (onsite/offshore) including designers, developers, architects, and executives wif 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.
• Application certified associate in SAP HANA.
• 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 wif 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 teh 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 wif BW-ABAP requirements (Routines, enhancements, generic data sources and Customer Exits).
• 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 wif DMO option, involved in teh pre-migration and post migration activities and issues after migration, involved in teh house keeping activities and Exposure on BW 7.5 upgrade.
• Experience in SAP HANA development, optimization and support for mixed approach wifin 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 wif Complex SQL stored procedures.
• Worked on teh SAP HANA production issues, HANA performance Optimization and experienced in analysing teh SAP HANA SQL procedures.
• Working Knowledge on CDS Views, Decision Tables, ABAP Managed Data Base Procedures.
• Data Provisioning: Experience in data provisioning wif SLT, SDI, BODS.
• Reporting: Integration of SAP HANA models wif SAP Business Objects 4.1 tools - WEBI
• Created teh Universe using Information Designer Tool on HANA Calculation Views and Generated teh WEBI Reports.
• Implemented different types of Routines to customize teh data flow in achieving teh desired output solutions in SAP BW.
• Expertise in teh Enhancements of LO, CRM Data sources.
• Expertise in Customer Exists to achieve teh desired Reporting Solutions.
• Experienced in sorting out teh Performance techniques in Routines to Optimize teh Data Extraction process.
• Proficient Debugging Knowledge across teh 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 wif 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

SAP HANA BW DSIM - Solution Designer and Developer

Responsibilities:

• Involved in Collaborating wif Client managers, Reporting team, Business users and other Stake holders to understand SAP HANA, teh existing landscape and identify key business use cases for teh Poof of Concept POC .
• Interacted wif 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 wif 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 teh HANA DB and provided teh performance of data loads in EDW.
• Coordinate wif Business users and completed teh Market Integration Tests and Market Acceptance Tests.
• Worked closely wif users and resolved teh user defects on teh solution wif in teh time line.
• Worked on Pre Transport and Post Transport Manual Actions during teh deployment of application.
• Extensively worked on Hyper care Support and resolved all teh issues.
• Trouble shooting experience wif end users, business analysts about teh day-to-day work process.
• Prepared teh documentation for teh Sustain Handover and successfully Handover teh solution to teh Sustain Team.
• Created Change Requests and coordinated wif BASIS Team to progress teh developments to Production.

Confidential

SAP DSIM-BW-HANA

Responsibilities:

• Led 6 members Team (Onsite / Offshore Model).
• Served as a Solution Designer and Onsite Coordinator.
• Discussed business solutions wif Confidential Business Analysts, resolve existing problems and improve teh 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 teh Technical design to Confidential 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 wif Offshore to get teh Status on teh 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 wif BASIS Team to progress teh developments to Production.
• Coordinated wif BODS SPOC’s and supported BODS Team for successful completion of Unit Testing and Integration Testing.
• Provided Hyper Care Support for teh newly implemented solutions.

Confidential

SAP DSIM-BW-HANA

Responsibilities:

• Participated in discussions wif client’s project team to take up teh client’s requirements, understanding teh requirements, and planning teh smooth delivery as expected.
• Designed and developed DSOs, Info cubes and Multi Providers for data loads and reporting requirements.
• Transportation of BI objects across teh landscape and trouble shoot teh transport conflicts.
• Created Data sources for BODS Team to load teh 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 teh Harmonization Process to Harmonize teh Internal data wif 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 teh user’s requirement and exposed teh BEX reports for WEBI and Analysis for Office reporting.

Confidential

Lead SAP BW HANA Consultant

Responsibilities:

• me 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.,
• Analysed teh requirement and convert teh Functional specifications to teh 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 teh 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 teh 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.

Confidential

SAP BW HANA Consultant - Developer

Responsibilities:

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

Confidential

Support Analyst

Roles and Responsibilities:

• Good Functional noledge of all teh Information areas of Lighting and Luminaires Landscapes.
• Worked extensively in teh Functional areas: Marketing and Sales.
• Good noledge on Sales and Orders, Billing Documents (COPA).
• Served as teh 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 teh 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 teh Solution Owners
• Analysis of Short Dumps like SQL error during upload and interaction wif teh 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 teh initialization and delta updating of all data.
• Involved in Support pack upgrade and release activities.
• Finding teh issues and resolve in teh month end activities.
• Resolving master data load issues and reconciliation wif R/3.
• Coordination wif various Service Vendors including Basis, S&A, Interface team and APO Functional Teams.
• Creating KPI dash boards for auditing teh 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

Associate BW Consultant

Responsibilities:

• Worked on extracting data from ECC using LO and Generic Extractions.
• Involved in installing Business Content Objects as per teh Business requirement, end to end design and construction of Info Objects, Data Sources, Info Cubes, DSOs and Multiprovider to suit teh 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 teh Query Performance.
• Created various Process Chains to automate teh 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 teh landscape and analysing teh transport failures.
• Developed Sales reports: open order, lost sales and complete orders report