We provide IT Staff Augmentation Services!

Sap Hana Consultant Resume

San Jose, CA

SUMMARY:

  • Strong experience designing and developing SAP HANA Information Models using SAP HANA SP07, SP08, SP09, SP10, SP11, SP12 and SAP HANA 2.0.
  • Experience in gathering requirements from the business users and functional analysts to provide the design options for reporting requirements.
  • Strong proficiency in SQL, and experience in writing Stored Procedures in HANA using SQL Script.
  • Strong Experience in identifying the bottle necks in the HANA model performance and optimizing the models.
  • Used HANA Live views and created copies of the live views and modified and used them as per the requirement.
  • Knowledge of HANA XS and experience in developing user Interface with SAP UI5 by exposing the HANA models using OData services.
  • Worked on configuring, creating transformations and troubleshooting SAP LT Replication Server (SLT) to import metadata and data from ECC Tables into SAP HANA.
  • Worked on multiple SCM modules including procurement, Quality management and Plant Maintenance for analysis and to facilitate reporting in SAP UI5 and Tableau.
  • Experience on Building on Hana Models on ECC Tables, and validating the report data with ECC table data.
  • Experience in BW Powered by HANA, HANA - Optimized Cubes and Advanced DSOs (ADSO) and Composite providers.
  • Experience in Importing BW cubes into HANA studio/modeler and HANA views into BW.
  • Fair understanding of SAP HANA architecture & SAP HANA concepts such as In-Memory Computing, Row Store, Column Store, Data Compression and Data Provisioning.

PROFESSIONAL EXPERIENCE:

Confidential,San Jose,CA

SAP HANA Senior Consultant

Technologies: SAP HANA, Tableau, NodeJS, AngularJS

Responsibilities:
  • Understanding the business requirements and converting them into functional specification document, and then translating functional specifications into Technical design document.
  • Translating the business KPIs into SAP HANA & Define the Reporting Layouts in Tableau.
  • Designed and Developed SAP HANA Calculation views, SQL Scripts, Procedures licensing, collector and acquisition data.
  • Optimizing the HANA models for better performance
  • Creating and applying the Analytics Privileges for user restrictions in SAP HANA
  • Validating the data in the SAP HANA Information Models with the source Teradata table data
  • Validation of Data in the SAP HANA Vs Tableau Reports
  • Conducting UAT sessions with the business for validating the report data
  • Resolving the production issues in timely manner

Confidential,Sacramento,CA

Senior SAP HANA Consultant

Technologies: SAP HANA, Tableau, SAP BODS

Responsibilities:
  • Designed and Created SAP HANA Calculation views, SQL Scripts, Procedures for Hospital and for the regions data
  • Optimized the HANA models for better performance
  • Validated the data in the SAP HANA Information Models with the source SQL Server table data

Confidential, Los Angeles,CA

SAP HANA Senior Consultant

Technologies: SLT, SAP HANA, Tableau

Responsibilities:
  • Worked on configuring, creating transformations and troubleshooting SAP LT Replication Server (SLT) to import metadata and data from ECC Tables into SAP HANA.
  • Designed and Created SAP HANA Attributes views, Analytic views and Calculation views for Procurement data including Purchase orders, Purchase order items, Contracts, purchase requisitions and so on..
  • Used HANA Live views and created copies of the live views and modified and used them as per the requirement.
  • Optimized the HANA models for better performance
  • Validated the data in the SAP HANA Information Models with the source ECC table data
  • Designed, developed and optimized Tableau workbooks for senior business leaders, to effectively tell the story based on the underlying data.
  • Developed Tableau visualizations to support ad-hoc analyses.
  • Published Workbooks and Dashboards to the Tableau server.
  • Validation of Data in the SAP HANA Vs Tableau Reports
  • Involved in Unit testing, Integration testing and system testing of the reports in Development, QA and UAT environments
  • Involved in the performance tuning of the Workbooks by analyzing the SQL generated by tableau by monitoring the Log Files

Confidential, St Louis, MO

SAP HANA Consultant

Technologies: SAP HANA, SAP UI5.

Responsibilities:
  • Understanding the Business requirements and convert them into Blueprint
  • Translating Functional Specifications into Technical Specifications
  • Translate the Business KPIs into HANA & Define the Reporting Layouts
  • Defining the Design Documents for the HANA Models
  • Designing and Creating of HANA Attributes views, Analytic views and Calculation views
  • Designing and Creating of XSJS jobs, and OData Services
  • Optimizing the HANA models for better performance
  • Implementing Currency Conversions in the information models.
  • Creation of Constant and or calculated columns in HANA Models
  • Creating and applying the Analytics Privileges
  • Creating and exposing the OData Services in Hana for UI5 binding
  • Validating Information Models in HANA with the source table data
  • Comparing Object Versions for Hana models
  • Checking Model references while transporting
  • Validation of Report Layout and Data in the Reports
  • Validation of Data in the Reports vs. Source ECC
  • Conducting UAT sessions with the business for validating the report data
  • Resolving the production issues in timely manner

Confidential

SAP HANA Developer

Technologies: SAP BODS, SAP HANA, IDT, WEBI

Responsibilities:
  • Created tables in HANA by importing the table definitions from the source systems using BODS.
  • Extracted the data from Oracle, transformed and loaded into the target HANA Tables.
  • Worked on Source to Target Mapping design Doc.
  • Created various BODS Jobs, work flows, data flows and scripts in Designer to pull data from Oracle and load into the target HANA Tables.
  • Validated the jobs, Tested data flows and scripts against sample data and real data in both source (Oracle) and target (HANA).
  • Created packages in HANA to group the Objects together logically in a structured way.
  • Created Attribute views, Analytical Views and Calculated views as per the reporting requirements.
  • Developed Script based calculation views, stored procedures whenever required.
  • Worked on complex filters using filter expressions, dynamic input parameters using procedures, parameters.
  • Worked on optimization of the HANA models.
  • Used Information design tool to create data foundations, Business Layer and publish connections and layers to the SAP BO repository.
  • Involved in documenting the changes to the universe and reports functionality
  • Creating WEBI reports as per the requirement.

Hire Now