We provide IT Staff Augmentation Services!

Sr. Sap Hana Consultant Resume

Bolingbrook, IL

SUMMARY

  • Over 12 years of experience in which 5 years on SAP HANA and 7 years on Business Intelligence solutions, innovative analytical reporting and visualizations to often unique business requirements utilizing the SAP HANA BW products such as HANA 2.0, BW 3.x, BI NW 7.0,7.3,7.4,7.5 and SAP BOBJ 4.X.
  • Worked in various Industries such as Electronics, Chemical, Food and Beverages and Retail.
  • Involved in Full life cycle implementation by using SAP HANA 2.0, SAP BW & BO.
  • Expertise in working SAP HANA modeller by using business artefacts for each business unit and analyse the KPIs.
  • Experience in Hana Cloud foundry, Hana Cloud Platform (HCP) and On - Premise environments.
  • Experience with Cloning the Repositories from GIT repository into Local workspace, Build DB Artifacts, Containers and Multi-Tenant architecture using HANA 2.0
  • Native HANA - Schemas, Packages, designing Views (Attribute View, Analytic View and Calculation View), Stacked Calculation Views, and Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modelling using SQL Script, Variables and Input Parameters, Calculated and Restricted Columns, Currency Conversion, Hierarchies and CESQL scripting, Export/Import of Models, Validating Information Models, Creating Schemas, Manage Schema Mapping, and Performance Tuning.
  • HANA SQL SCRIPTS & CDS Views - Strong experience on Creating SQL, Stored Procedures with SQL Script and Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like - Tracing, Using the SQL Script Debugger.
  • Proficient working on XS Engine, O Data Service and CDS Views.
  • Worked on NetWeaver 7.3/7.4 platform to deploy models.
  • By using SAP NetWeaver Application server, perform analysis and embedded analytics in real time.
  • Experience in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and Performance tuning.
  • Working experience in define and implement security and Dynamic Analytics Privileges.
  • Experience in extracting the data using Business Object Data services (BODS), SAP Landscape Transformation Replication Server (SLT) and Smart Data Integration (SDI).
  • Good understanding of LSA and LSA++.
  • Extensively worked on Data Warehousing workbench Info Objects, Info Cubes, Classical DSOs (Standard and Write Optimized), Advanced DSOs, Composite Providers, Transformations, DTPs, Open Hub destinations.
  • Strong Experience Hybrid Modelling - BW Data Models with Native HANA modelling artefacts and vice versa.
  • Worked on AMDP to Pushed logic to HANA DB to leveraging potential of HANA.
  • Expertise on modelling of Advanced DSOs, Composite Providers and Open ODS views using BW modelling Tools in HANA Studio.
  • Good Experience on Analytic Privileges as part of Security for HANA Information Models.
  • Expertise in OLTP extraction from SAP R/3 using LO Cockpit, CO-PA, FI AR, AP and Generic Extraction also data from flat files
  • Worked extensively on Logistics (PP, PM, MM, QM and SD) and generic data extractions.
  • Worked extensively on SCM, FI-CO and CRM.
  • Requirement gatherings, Design solutions and worked throughout different project phases.
  • Proficient working with cross-functional project teams on different phases of Software Development Life Cycle implementation - Requirement Gathering, Solution Design, Solution Build/Development, Testing, Preparation of Cutover Plan and Deployment.
  • SAP HANA Data Provisioning using SAP Landscape Transformation Replication Server (SLT) for real time (and Non real time) data replication from SAP ERP and non-SAP systems.
  • Expertise in Data Extraction, Transfer and Loading (ETL) using SAP Business Object Data services (BODS) and Direct Extractor Connection (DXC).
  • Extracted data using BODS from SAP into HANA with the ODP (Operational Data Provider) functionality.
  • HANA SECURITY & TRANSPORT- Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges. Hands-on experience on all three modes of transport - Delivery Unit mode, Development mode, as well as on the ‘SAP support mode’, Apt in Direct metadata import - mass import of metadata, selective import of metadata.
  • Created Universes on top of HANA Calculation views and developed the Webi reports and dashboards using IDT (Information design tool)/UDT.
  • Expertise on Reporting using BEx Query Designer, BEx Analyzer, Analysis for Office Microsoft Excel, WebI, Design Studio, Tableau and SAP Lumira.
  • In WebI developed Adhoc Reports with BEx Queries as source using BICS Connection.
  • Hands on experience on new SAP Business Objects 4.1 client tools like Information Design Tool, BI Launch Pad, Dashboard Design, Crystal Reports Enterprise etc.
  • Adept in analyse information system needs, evaluating end-user requirements, custom designing solutions, and troubleshooting any problems in the process.
  • Good exposure to Project Management activities and involved in all phases of Project Management & experience of helping Practice Heads/Sr Managers in building the Proposals and handling Requirement gathering workshops.
  • An enthusiastic, highly self-motivated, Excellent Technical, Interpersonal and solid communication skills with the ability to interact with end-users and Training end-users on the solutions.

TECHNICAL SKILLS

Data Base: DB2, HANA, Oracle, MS-SQL server

ETL: BODS,BW,SLT,SDI,SDA

DW Skills: SAP BW, SAP HANA

Reporting Tools: BO Webi, Dashboards IDT, Tableau, Lumira, Analysis for Office, Design Studio.

BeX Analyser: Power BI

Programming Language: ABAP, SQL, PL/SQL, T-SQL

PROFESSIONAL EXPERIENCE

Confidential, Bolingbrook, IL

Sr.SAP HANA Consultant

Responsibilities:

  • Involved in Requirement gathering to understand the current business scenarios for the e-commerce Fast Fulfilment centre SKUs Limited.
  • Worked on S/4 HANA(1809) to consume tables in embedded HANA
  • Analyse and architect HANA staging and developed models using Scalar and Table functions.
  • Analysed and Created KPI’s as per the outcome of brain storming from the business users.
  • Enhanced data models to accommodate additional data without impacting existing reporting setup.
  • Extracted the data using Business Object Data services (BODS), SAP Landscape Transformation Replication Server (SLT) and Smart Data Integration (SDI).
  • Involved on NetWeaver 7.3/7.4 platform to deploy BI models by integrating other services.
  • Worked on SAP NetWeaver Application server, perform analysis and embedded analytics in real time.
  • Used SAP cloud foundry to access data from google cloud platform.
  • Configured and Replicated the ECC Tables using SLT for retail time data and modelled the Calculation Views.
  • Created Technical specs by analysing functional specs.
  • Developed Info Providers using HANA Studio such as Advanced DSOs, Composite Providers, Open ODS Views.
  • Export/Import of Models, Validating Information Models, Creating Schemas, Manage Schema Mapping, Performance Tuning.
  • Developed SAP HANA Information Models using Calculated Views.
  • Designed the data flow architecture for Master & Transaction data.
  • Modelled Calculation views using Scalar functions to derive Week from and Week to from Current date input parameter.
  • Involved in SAP HANA Security Analytical Privileges.
  • Created Test cases for data models.
  • Conducted user trainings to help them understand the enhancements so that they can use self-service reporting views, Bex reports and AO.
  • Developed new Reports as per the Business Requirements.
  • Worked extensively on Data Model design in Supply chain.
  • Coordinated with teams from cross functional areas to manage dependencies and continue to complete project with in the agreed time lines.
  • Maintained detail document for all the changes and shared knowledge with support team for smooth transition.
  • Provided training to the end users on reports for their business decision making.

Confidential, Bolingbrook, IL

Sr.SAP HANA Consultant

Responsibilities:

  • Participate in Requirement gathering to understand current reporting scenarios where the pricing is relevant and e-com Fast Fulfilment centre Limited SKUs.
  • Analyse and architect HANA staging and developed models using Scalar and Table functions.
  • Enhanced native Hana data models to accommodate additional data without impacting existing reporting setup. Pushed logic to HANA DB using AMDP leveraging potential of HANA.
  • Configured and Replicated the ECC Tables using SLT for retail time data and modelled the Calculation Views.
  • Implemented HANA CDS views with annotations, associations and rich semantics like currency conversions, variables and Input parameters.
  • Extracted and transformed the data remotely using Smart Data Access (SDA) and Smart Data Integration (SDI).
  • Assigning the Reporting Views to corresponding role using SQL based privileges.
  • Created Technical specs by analysing functional specs.
  • Developed SAP HANA Information Models using SQL based Calculated Views.
  • Conducted user trainings to help them understand the enhancements so that they can use self-service reporting views, BO and Bex reports.
  • Modelled Calculation views using Scalar functions to derive Week from and Week to from Current date input parameter.
  • Involved in SAP HANA Security including Object Privileges, Analytical Privileges
  • Creating Test cases for data models.
  • Worked on SAP HALM (Hana Application Life Cycle Management, transported objects from one environment to another.
  • Designed Data flow architecture for Master & Transaction data.
  • Developed new Reports and Modified existing Reports as per the Business Requirement Testing.
  • Worked extensively on Data Model design in Supply chain.
  • Coordinated with teams from cross functional areas to manage dependencies and continue to complete project with in the agreed time lines.
  • Maintained detail document for all the changes and shared knowledge with support team for smooth transition.

Confidential, St. Louis, MO

SAP HANA Consultant

Responsibilities:

  • Interacted with Business stakeholders in order to understand their structured and ad-hoc reporting requirements, User stories for business Marketing and Sales domains.
  • Conducted interviews with clients to solidify the required business rules and fact-finding sessions with continued reviews throughout the project lifecycle.
  • Created Technical Specifications document based on Functional Specification, Report Design Documents.
  • Created HANA Procedures, functions, Tables, created the HANA Calculation views exposed it for reporting.
  • Creating Test cases for data models.
  • Worked on SAP NetWeaver Application server, perform analysis and embedded analytics in real time.
  • Worked on SAP HANA data model with LSA++ architecture
  • Developed Complex Calculation views using Graphical and SQL Scripts
  • 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.
  • Export/Import of Models, Validating Information Models, Creating Schemas, Manage Schema Mapping, Performance Tuning.
  • Developed Stored Procedures with dynamic calling of Calculation views as per the requirement.
  • Created Calculation Views by using various nodes like Aggregation, Join, Union and Projection.
  • Created advanced modelling using Hierarchies, derived views, restricted calculated column, variable, input parameter.
  • Modelled Calculation views using Stored Procedure to derive YTD, MTD and Rolling Sales Revenue values.
  • Developed Info Providers using HANA Studio such as Advanced DSOs, Composite Providers, Open ODS Views, Calculation views
  • Designed and developed virtual data models HANA Live eliminating the need to replicate data of ECC and analytical, attribute, calculation views on SAP HANA.
  • Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
  • Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.1 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
  • Used Data Services to expose data from HANA Calculation views.
  • Developed Production Order Actual vs Plan variance report, Capacity Utilization report, Material Actual vs Plan Reports.
  • Adopted parallel techniques/filter pushdown/parameters in developing models to achieve the performance.
  • Involved in User/Role Management and HANA security.
  • Implemented HANA CDS views with annotations, associations and rich semantics like currency conversions, variables and Input parameters.
  • Co-coordinated with different functional teams in SAP SD and SAP MM.
  • Involved in SAP HANA Security including Object Privileges, Analytical Privileges
  • Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN.
  • Consumption of HANA information Models in BW
  • Involved in Support pack upgradation Testing Activities.
  • Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool
  • Worked on SAP HALM (Hana Application Life Cycle Management, transported objects from one environment to another using this brand-new tool.

Confidential

SAP HANA Technical Consultant

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 and Developed HANA Modeling Artifacts - Attribute, Analytic and Calculation views using HANA Studio (Graphical and SQL Script).
  • Created SQL Stored Procedures to implement complex logics and integrate them with HANA Views and Composite Providers.
  • Extracted data from Calculation Views into SAP BW with the ODP (Operational Data Provider) Functionality.
  • Development of Hybrid Models by consuming BW Models into Native HANA.
  • Worked with variables, Input Parameters, Calculated and Restricted Columns, and Currency Conversion in Calculation Views.
  • Developed SAP HANA Information Models using Calculated Views.
  • Worked on Projection, Join and Union in HANA calculation views.
  • Developed Information models like Scripted Calculation Views in native HANA.
  • Worked on Filters, Restrictions, Calculated measures, restricted measures in HANA views.
  • Worked on Decision Tables, Triggers and Sequences in HANA Studio.
  • Worked on Performance Tuning using Explain Plan and Visualize Plan.
  • Worked on Analytic Privileges for HANA Information Models.
  • 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 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.
  • Development of Proof of Concepts (POCs) in Sandbox before starting the Actual development.
  • Coordinate with Business users and completed the Market Integration Tests and user Acceptance Tests.
  • Worked on Performance Tuning Techniques to Push down HANA Transformation logic into HANA Data Base.
  • Designed Data flow architecture for Master& Transaction data.
  • Extraction of Data from SAP ECC and development of ABAP programs with SAP BW.
  • Maintain and modify existing ETL applications and corresponding documentation.
  • Develop new ETL processes of simple to moderate to highly complex scope and contribute to design specifications, using organization standards, procedures, and techniques.
  • Assist in the development of test plans for assigned projects.
  • Development of New Reports or Modification of existing Reports as per the Business Requirement and Testing.
  • Worked on Smart Data Access (SDA) solution for virtualizing data from Oracle, MS SQL Server.
  • Multi Temperature Data Management - Hot, Warm (Dynamic Tiering), Cold and Frozen.
  • Developed Stored Procedures to move aged to data to WARM Dynamic Tiering tables and scheduled those using XS Jobs to run periodically.
  • Worked extensively with the major functionality of BO WebI Reports like Breaks, Sections, Group values, Sorts, List of Values (LOV), Calculations and Ranking.
  • Involving in House-keeping Activities and Performance Optimization.
  • Co-coordinating with different functional teams in SAP SD, SAP MM, SAP PP, SAP FI-CO etc.
  • Estimating the timelines for RFCs (Request for Change).

Hire Now