Highlights

• 12 Years of experience in SAP Analytics Cloud, SAP HANA, Native HANA, SAP BW, BW on HANA, BODS and BO implementation & Development projects.


• Around 2 years’ experience in SAC and 5 years SAP HANA implementation projects.


• Worked on Data Modelling, Data Provisioning, Reporting, Security aspects of SAP HANA 1.0


• Experience working on HANA Enterprise Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges, CDS views.


• Experience Native HANA in Data-Provisioning techniques suing SLT SAP Landscape Transformation, Smart data access (SDA) to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.


• Excellent knowledge on: HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.


• Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and Info Cubes.


• Experience in Importing BW models Info Cube, DSO in HANA as Analytical view.


• Good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users in SAP HANA.


• Experience in Configuring and Consuming SAP HANA models in BI clients such as Business Objects, Tableau, Fiori Tiles


• Ability to manage multiple tasks and work effectively in a fast-paced environment.


• Strong communication, interpersonal and organizational skills.


• Experience working in AGILE methodology and been part of a SCRUM team

Certification 

• SAP Certified Application Associate (Edition2014) - SAP HAN


• Open Sap Certifications –
  
  
  
  • Introduction to Software Development on SAP HANA 
  
  
  • SAP Business Warehouse powered by SAP HANA
  
  
  • Implementation of SAP S/4HANA
  
  
  
  

Skills

Primary Skills

SAP

ABAP

Native HANA

Secondary Skills

BW4HANA

SAP BW

Projects

Project 1. Direct Materials - IT Industry (12 months)

Roles & Respobilities :






• Worked on Requirements gathering, drafted Functional and technical documents for Direct Materials.


• Extensively worked with data provisioning using SDA/SLT.


• Extensively worked with HANA modelling- Created multiple schemas and tables, Packages, Graphical Calculation views, Table Functions, Stored Procedures, Flowgraphs.


• Responsible for migrating of HANA Development objects to across systems and validations.


• Extensively handled performance optimisation on HANA modelling objects.


• Analysing report issues and preforming the data validations in Unit Testing and User Acceptance Test.


• Drafted HANA development, Qlik sense Reports and hand over to business for continues support.






Tools Used :     






• SAP HANA 2.0,S/4 HANA, SAP ECC, SQL,Qlik Sense






 

Project 2. DFT (Digital Finance Transformation) - IT Industry (31 months)

Project Description: This project is envisioned to build Finance Reports using migrated data from S/4 HANA  and ECC systems, which is combined solution for global semiconductor and software design. Systems has been integrated for data modelling and report development using HANA and BO.





 





Roles & Respobilities :





As a Senior SAP Analytics Cloud\HANA Consultant, I was responsible for:





SAC:






• Extensively worked on connecting SAP HANA, HANA Marketing Cloud, ABAP CDS Views to SAC environment.


• Experience in SAC connections with different On Premise and Cloud data source with fluent knowledge on cloud connector & cloud agent.


• Proven experience in delivering solutions to challenging business requirements for project initiatives that involves SAP BI solutions such as SAC.


• Experience in building Live and Import data Models, Analytic & Planning models, Stories, Dimensions, and currency Conversion.


• Expertise in Migrating Models ad Stories to production environment.


• Strong knowledge on machine learning and worked on smart assist scenarios like Smart Discovery, Smart Insight etc


• Hands on Experience in creating planning, Forecasting, Allocations, VDT, Data actions and Automating actions through Planning Calendar.






SAP HANA






• Requirements gathering, drafted Functional and technical documents.


• Responsible for providing the solutions and feasibility of application simplifications.


• Extensively worked with data provisioning using SDA/SDI and BODS.


• Experience in using Web IDE for SAP HANA – crating data models.


• Extensively worked with HANA modelling- Created multiple schemas and tables, Packages, Graphical Calculation views.


• Responsible for migrating of HANA Development objects to across systems and validations.


• Extensively handled performance optimisation on HANA modelling objects.


• Built reports in Web intelligence Reports for Account Payables, Account Receivables and Reconciliation. 


• Analysing report issues and preforming the data validations in Unit Testing and User Acceptance Test.


• Drafted HANA development, BO Reports, and hand over to business for continues support.






 





Tools Used:     






• SAP HANA 2.0,SAC, Business Object, S/4 HANA, SAP ECC, SQL, Tableau     






 

Project 3. Opportunity Management - IT Industry (16 months)

Project Description:





Opportunity Management provides a variety of financial services including retail, business and institutional banking, funds management, superannuation, insurance, investment and broking services. It has enhanced integrated solution through SAP CRM, SAP HANA, Fiori.





 





Roles & Respobilities :





As a SAP HANA Consultant, I was responsible for:






• Responsible to Creating schemas, tables, packages, column views and synonyms.


• Creating Attribute views, Analytical view and Calculation views, stored procedures, and table functions.


• Worked on Variables and Input parameters, different types of Joins and Unions.


• Extensively worked on HANA Views Performance Optimization with Visualize Plan, Execution plan and performance trace.


• Migrating HANA Views using Application life cycle management (Delivery Unit) and ABAP on HANA


• Creating Reports on SAP Web IDE and SAP Fiori


• Tracking and Dashboard adding, modifying, and deleting existing Fiori Tiles


• Integration of HANA Views with Fiori Tiles.


• Experience with Agile product development methodologies (SCRUM)


• Worked on OData Services for integrating the Tile report filters and making dynamic filters.






 





Tools Used:      






• SAP HANA, SQL, SAP CRM, SAP Fiori






 

Project 4. Honeywell -HANA Implementation - IT Industry (19 months)

Project Description:





This project has provided the complex integrated HANA Implementation with Global Reporting for business units, known as Strategic Business Units – Honeywell Aerospace, Home and Building Technologies (HBT), Safety and Productivity Solutions (SPS), and Honeywell Performance Materials and Technologies.





 





Roles & Respobilities :





As a SAP HANA/BODS Consultant, I was responsible for:





HANA






• Responsible in all phases of the process from requirements gathering to handover process


• Handled project management activities including scheduling the testing and release phases


• Coordinating with Client for accommodating the changes in requirement


• Hands on experience in HANA modelling objects – Creating schemas and table definitions, creating Attribute views, Analytical view, Calculation views, stored procedures and table functions


• SAP HANA Data Provisioning and using SAP LT Replication Server (SLT) Executed Data Extraction Transfer Loading (ETL) using SAP BODS Data Services 4.0


• Worked on migrating HANA Views using Application life cycle management (Delivery Unit) and Export - Import mechanism


• Validation of Data in the Reports and Troubleshooting Performance Issues


• Reporting, Accessing Analytical and Calculation views from EXCEL.


• Transported HANA content from development, testing environment to Production environment using delivery units.






BODS:






• Extensively worked on BODS/BODI Designer Components-Jobs, Workflows, Data Flows, Formats, Data Store and Scripts


• Created multiple data store configurations in Data services local object library with different databases to create unified data store.


• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, Table Comparison, case, Validation, Merge, lookup etc. in Data flows


• Involved in writing scripts and used some built-in functions like To Date, lookup, key generation and Custom Functions like checking whether the load is an initial load or a bulk load.


• Worked on connect from different source systems like SQL, ORACLE, Ingress, SnC, SAP ECC, SAP HANA


• Worked on snapshot jobs creation – connecting HANA view and updating into HANA Table


• Extensively worked on code validations and code check in, check out from local repository to central repository on code migration


• Extensively used ETL to load data from flat file and from the relation database






 





Tools Used:     






• SAP HANA, SAP ECC, SAP BODS, SQL, Oracle, SAP BO, Tableau






 

Project 5. JCI-HANA Implementation - IT Industry (4 months)

Project Description: Executive dashboard will provide integrated in house developed system to generate reports (Score card) for submissions automotive parts such as batteries and electronics and HVAC equipment for buildings.





 





Roles & Respobilities :





As a SAP HANA Consultant, I was responsible for:






• Worked on Power Solutions Score Card -Executive Dashboard creation.


• Have been involved in requirement gathering and tech documents preparation


• Worked on BODS as creating the data flows, workflows, transformations like query, key generation, history preserving, table comparison and jobs to extract the data from Oracle source system to HANA Studio


• Worked on creation of Attribute View, Analytical Views and Calculation views 


• Have been crated Restricted Columns and Calculated Columns to define KPI's as per the requirement and created input parameters and variables.


• Involved in creation of Packages and Delivery Units to transport object across the landscape


• Extensively involved in Data Validation – BODS data Loads, HANA Views and Dashboard


• Worked on creation of Analysis for OLAP reports and exposed same reports on Design Studio


• Worked on Design Studio - Global Score Card report to Visualize data in Charts, Cross tabs and has been used multiple components, Custom CSS functions to make it dynamic data visualization.






 





Tools Used:     






• SAP HANA, Design Studio, BODS






 

Project 6. GPA-Support - IT Industry (20 months)

Project Description:





GPA Support - capable of storing procurement information and generating reports to pharmaceuticals, diagnostics, healthcare. It is handled well Pharmaceutical and the hospitals for managing the patient information With SAP BI/BW, ECC.





 





Roles & Responsibilities:






• Worked on Procurement to Pay data flow for Global Procurement Analysis


• Creation of Process Chains for the entire Daily / Weekly Loads as and when required. Developing / Enhancing the structure from time to time as per the client’s requirement & creating the transports of the same.


• Checking daily Production run as we are also providing Production Support.


• Cross Verifying the Daily data load as per the checklist for ensuring the proper data upload in BW.


• Checking the daily time schedule for the run & ensuring that the jobs are finished within the specified time frame.


• Resolve and fulfil SAP BI Incidents and service requests raised by users according to SLA.


• Support the day-to-day data load monitoring, fix data and performance issues.


• Interacting with the clients from time to time to discuss the open issues.


• Changes to the existing Reports & Creation of new Reports as per Client’s requirements.


• Also sorting out the problem if the problem is related to BW. Informing Clients about the Success / Failure of the loads as soon as the activity is finished.


• Update the status, work logs and solution in Remedy


• Create test plan and execute the test plan and provide evidence in HPQC.






 





Tools Used:     






• SAP BI/BW, ECC, SAP ABAP BEx






 

Project 7. I Finance - IT Industry (39 months)

Project Description:





I Finance application is Unilever’s Corporate Consolidation system where data is collected from all countries across the globe, consolidates, and reports centrally covering Management, Financial, and Incurred Cost Reporting.





 





Roles & Responsibilities:






• Extensively worked on complex report of Management Reporting and Financial Reporting


• Expertise with BW reporting with Business Explorer using BEx Analyzer, BEx Query Designer, and developed queries using Filters, Free Characteristics, CKF, RKF, Structures, Variables to enhance reporting features, Conditions, Exceptions, Workbooks


• Info cube Management with Aggregates Roll up, Compression, Reconstruction, Partitioning, Re-modelling.


• Worked on export data sources (data mart) to pull the data from the Prod system to Non-Prod systems


• Performed the Change Request activities like creating tech specs and getting sign off from Business analysts    


• Participated in year-end Rollover to gather requirements from business, do impact analysis and implement changes.


• Implement new change requests from business in monthly release. Gather functional requirements and provide Impact Analysis and Effort estimates to business to agree with the delivery date.


• Performed Unit Testing in development system to ensure there are no bugs in development.


• Coordinated with streams like BCS, Security, and Basis and Change management whenever necessary.


• Create proper Documentation for all the existing data flows and reports in the system according to the defined process and ensure all changes are captured and documented.


• Adherence to process, performed Internal Audit to make sure it is followed 100%.


• Provide training to new team members about business and system landscape. Also involved in providing technical training.






 





Tools Used:     






• SAP BI/BW, SAP ABAP, SAP BCS, ECC, BEx 

Awards

N/A