SUMMARY:

• Working with Confidential as a SAP HANA Consultant having close to 10 years of IT experience.
• Experience in analytical modelling using latest version of SAP HANA involving implementation of Business KPIs involving complex scenarios.
• Worked on HANA developments with exposure to various virtual data models (VDM), calculated columns, analytic privilege (static, dynamic) and data replication scenarios in SAP HANA.
• Involved in implementation of BW on HANA 7.5 SP5 in objects like Open ODS, Composite Provider, ADSO, Open hub and various other objects involving integration of SAP HANA models with BW objects.
• Proficiency in SAP HANA SQL scripting with experience in creation of schema, tables, triggers, sequences and various simple to complex procedures.
• Exposure to SAP HANA administration and security including maintenance of users, roles.
• Exposure to SAP HANA lifecycle manager configuration setup and use.
• Exposure to native HANA XS applications including various CDS objects, exposing and consuming data with ODATA services.
• Experience in data provisioning with Smart Data Access, SAP SLT and in SAP BODS with implementation of complex transformations.
• Experience in providing training in SAP HANA technical trainings as per SAP guidelines.
• Business Process Knowledge in various SAP ECC Object - modules.
• Worked in multiple Business Intelligence projects and have been involved in every step of SDLC starting from design to Cut-over and Go- Live, and including live production warranty support and delivery of user training.
• Experience in working as an onsite/offshore Technical lead focussed on creation of Solution Architecture with business Facing Roles.
• Experience in interacting with various Cross Functional team across various Geographies and always own up the solution right from development to support.
• Strong domain knowledge in retail, life-sciences and healthcare industry.

CAREER HISTORY:

Confidential

Environment: SAP HANA SP12, SAP BW 7.5 SP5

Responsibilities:

• Involved in the project as a SAP BW/HANA lead responsible for delivery of the solution.
• Involved in developing the architecture, strategy and design for BW HANA interface for the Enterprise Management reporting
• Involved in the development of SAP HANA virtual data models (Calculation Views) and consuming them through Open ODS View or Composite Provider with upward flow into ADSO and Open Hub.
• Involved in implementation of the latest in HANA technologies from CDS objects, HANA live models, process chain and AMDP ranging from native HANA to BW/HANA objects.
• Involved in the design and development of HANA SQL procedures to support the daily batch scenarios
• Responsible for implementation of SLT solution including complex transformations.
• Responsible for development of best practices guidelines and implementation of code review template to be followed across objects.
• Development of innovative solutions to give the best performance out of the HANA objects.

Confidential

Environment: SAP HANA Cloud SP11, Fiori

Responsibilities:

• Involved in the project as a SAP HANA Lead consultant.
• Involved in developing the architecture, strategy and design for HANA implementation
• Creation of various SAP HANA objects like Schema, tables, procedures, triggers and data maintenance using the CDS functionality.
• Development of SAP HANA Virtual data models (Calculation Views) and exposing them as a service using ODATA.
• Extensively worked on maintenance of user Roles and also various types of Analytic Privilege including complex dynamic Analytic Privilege.
• Involved in development of dashboard services.
• Responsible for implementing best practices for performance improvement.

Confidential

Environment: SAP HANA SP9, Oracle RDBMS, Business Objects (Webi), BODS

Responsibilities:

• Involved in the project right from blue-printing and solution development phase.
• Developed strategy and design for HANA implementation with BODS as the data provisioning mechanism.
• Interacted with business users to understand requirement and provide effective solution.
• Involved in understanding the business logic from the legacy SQL interface and applying the business rules in HANA virtual data models.
• Development of HANA procedures to enable data massaging and data transformations
• Creation of SAP HANA information models.
• Implementing 70 plus KPI through HANA models ranging from simple and complex to very complex scenarios.
• Implementing best practices for performance improvement.
• Involved in UAT, cutover to handling of warranty support.

Confidential

Environment: SAP BODS, SAP HANA SP 5, SAP ECC, Oracle RDBMS, Business Objects (Webi)

Responsibilities:

• Technical Lead for performing data migration and business intelligence activities that include data analysis, reporting, conversion, harmonization and business-process analysis and developing the business KPIs through SAP HANA.
• Data has been mainly extracted through direct table read through ABAP Dataflow and has been loaded mainly through BAPI and IDOC in BODS.
• Activities include requirement analysis, design, and solution estimation while driving communication with client SMEs and Business-Process Experts in specific process threads and communicate with different stakeholders, end users and functional managers to understand data migration requirements and activities.
• Involved in Data Validation, Data Governance, Data cleansing, Data quality, Data mapping and Data loading
• Performed Data Quality setup, Duplicate Check and other required validation
• Involved in planning and played a major role in cutover activities across Brazil and Mexico
• Advised the client & project team on the merits and demerits of different solution approaches in sight and recommend the best solution from technical feasibility point of view
• Applied business-process knowledge associated with multiple SAP functional modules

Confidential

Environment: SAP BODS, SAP HANA, Oracle RDBMS, Business Objects (Webi)

Responsibilities:

• As SAP BODS onsite Technical Lead involved in requirement analysis, design, solution estimation and development.
• SAP BODS was used as an ETL tool for extraction and loading of data into SAP HANA from the current Oracle and File data sources.
• Also used SAP BODS for data cleansing and implementation of numerous business rules for formation of a strong physical layer for building up of robust HANA models.
• Involved in design and development of Initial loads from the existing Oracle Source system as well for daily delta load from the Oracle source and File sources to HANA system.
• Also involved in providing fixes to the issues in the existing development
• Have been actively involved in designing of the primary solution along with SAP and have attended numerous workshops at SAP Confidential, CA office to understand the best practices.
• Worked alongside SAP to implement the solution and understand the best practices for the SAP BODS and HANA implementation.
• Involved in UAT, cutover to handling of warranty support

Confidential

Environment: SAP BODS, Oracle RDBMS

Responsibilities:

• As SAP BODS Consultant have been involved working in enhancements and provide resolution to the issues as a part of the support activities in SAP BODS
• SAP BODS had been used in extraction of the legacy Database and the flat files and has been involved in posting of IDOCS in the SAP ECC system.
• Involved in providing solutions to incidents as per the SLA.

Confidential

Environment :SAP ECC, Confidential, Oracle RDBMS

Responsibilities:

• As a Confidential Consultant have been involved working in enhancements and provide resolution to the issues as a part of the support activities in Confidential
• Confidential was a middleware platform primarily used to integrate various SAP and non-SAP interface through IDOC or BAPI.
• Involved in providing solutions to incidents as per the SLA and providing changes to the existing interfaces as per as the client requirements