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.
• 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 (ADSO’s), 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.
• Extensively worked on ODP (Operational Data Provisioning) and ODQ Monitoring.
• 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.
• Experience in Extracting and Loading the data from MS.SQL and Oracle using SDI.
• Expertise on designing and Building the CDS Views in SAP HANA.
• Experience in SAP Information Steward to Cleanse the data.
• 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

SAP BW HANA Consultant

Environment: SAP HANA, Business Objects - Web Intelligence.

Responsibilities:

• 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, Unit Test, QA Testing and Migrate the objects to Production.
• Created Handover document and performed the knowledge transfer to Application support Team.
• Enhanced the Business content and Generic extractors in SAP ECC.
• Modelled the data flow in BW on HANA.
• Extracted the data using SAP BODS and onboarded the data in ADSO’S.
• Created Open hub Destinations and sent the data to external systems.
• Created HANA Procedures, functions, Tables, created the HANA Calculation views, Attribute views and Analytical views and exposed it for the reporting
• Created Open ODS Views, Composite providers and BEX Queries.

Confidential, Glendale, CA

Sr. BW HANA Developer/Onsite 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.
• 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.
• Extracted the data using ODP Extractors and onboarded the data in ADSO’S.
• Extracted and Loaded the from HADOOP, MS SQL to SAP HANA.
• 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.
• Extracted the data from external sources using BODS and cleanse the data in SAP Information Steward.

Confidential

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

Solution designer and Onsite coordinator

Responsibilities:

• 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.