SAP HANA Consultant
Resume:
Itishri Ray * **********.***@*****.***
Professional Summary:
Over 5 years of experience in SAP industry and have worked in various technical platforms as HANA Studio Modelling, SAP BW/4 HANA and SAP BO in End to end Implementation, Development and Support Projects with working knowledge in SD, MM, FI and CO-PA functional areas.
Experience Summary:
Expertise includes Worked on SAP HANA Enterprise project for Products, Life Sciences and Oil&Gas Clients. It includes requirement gathering, design, development, implementation, testing, delivery and post delivery supports.
Having experience in handling deliverable on SAP Enterprise portal applications / Open ODS Views in BW/4 Hana/ Calculation views / Imbedded BW (BW on HANA), aDSO’ s in BW4/HANA, SAP Native HANA / SAP BW on HANA, S4HANA.
Developed master data flows in Hana Design studio(eclipse) and consumed the external Hana views created for master data and combined with transactional data
Work Experience:
Working for Accenture solutions Pvt. Ltd., Bangalore as SAP BW HANA Consultant from Oct’ 2015 to Jan’ 2020.
Worked for IFS Pvt Ltd, Bangalore as SAP BI Consultant from Jun’ 2013 to May’ 2014.
Educational Qualification:
B.Tech from Biju Patnaik University of Technology.
Technical Skills:
Operating System : Windows NT, Windows 2000, Windows XP, Windows8, Windows 10.
Language : C, C++, SQL, ABAP Routines.
RDBMS : Oracle 9i, SAP HANA.
ERP : SAP ECC 6.0, S4 HANA 1808
Data Warehouse : SAP Enterprise HANA modelling,SAP HANA LIVE,SAP BW/4 HANA 2.0,SAP BW HANA.
Reporting tools : BEx Analyzer, Query Designer, AO,Webi reporting.
Project Experience:
Project #1 (Implantation)
Client : Xcel Energy.
Role : SAP HANA Consultant.
Duration : Oct 2018 to Jan 2020
Environment : Native HANA,SAP BW4 HANA
Responsibilities:
Worked on HANA Calculation Views.
Created Information models (Attribute Views, Analytical Views and Calculation Views) in HANA studio.
Good knowledge on Data provisioning methods such as SLT replication method.
Worked in building the views on Enterprise HANA Landscape.
Created HANA modeling scenarios, SQL Script Procedures.
Run SAP HANA Plan Viz to achieve better Performance Optimization.
Experience in creation of Calculated columns, Restricted Columns (KPI), input parameters, variables in HANA for OTC, PM, PTP, RTR, and EWM process streams.
Worked on SAP BW/4 HANA with end to end data flow.
Worked on Data source creation, Flat File data extraction and loading till data target in SAP BW/4 HANA.
Worked on End to end activation,extraction and Loading of LO extractor from S/4 HANA source system to BW/4 HANA.
Worked on SAP BW Workspace for creation of customized reports.
Created process chain using BW/4 HANA Cockpit.
Project #2 (Development)
Client : Bell Canada
Duration : April 2017 to Sept 2018
Role : SAP HANA Consultant
Environment : Native HANA,SAP BW 7.3, SAP BW 7.5,& ECC 6.0.
Responsibilities:
Developed & designed Attribute views, Analytic views and Calculation views using Graphical Mode.
Experience on creating Row Store and Column Store type of Tables.
Extensive experience on creating Schema using SQL and creating Packages.
Expertise in Export & Import of Info-packages, Validation, Activation, Mass copy, Auto-documentation, Schema Mapping, Redeploy.
Created SQL based Calculation Views using procedures.
Created HANA Calculation views, tested end to end data w.r.t different tables and views.
Data Provisioning from Flat File, Excel into SAP HANA.
Extensively worked on Delivery unit and developer mode to export the individual information model or packages from development to target systems such as Quality and Production.
Designed and developed HANA Modeling objects for all the dimensions and Key figures.
Created Technical Design Documents from HANA Functional Design document.
Project #3 (Development and Support)
Client : Astellas
Role : SAP BW Consultant
Duration : Oct 2015 to March 2017
Environment : SAP BW 7.3 ECC 6.0.
Responsibilities:
Worked in enhancements.
Delivered the report build, Unit Testing by analysis of functional Specification.
Completed the build and report changes based on Quality system defects.
Involved in creating the Info Objects, DSOs, Info Cubes, Multi-providers based on technical design document.
Designed and developed queries to generate reports in BEx Analyzer, Worked extensively on query designer.
Involved in replacing ADSO with existing info cubes and creating Composite providers.
Worked on critical report (workbook).
Created APD based on BEX report.
Worked extensively on BEx query Designer and Developed flexible queries using navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
Involved in modifying existing reports and creation of reports using Query Designer such that by using Free Characteristics, Restricted Key figures, calculated key figures, Variable and formula Variables.
Daily Support activities include monitoring of data extraction and restore of failed loads.
Month end Support Activities includes Flat files loading and scheduling the Process chains on frequent basis in a day Rendering 24/7 support as a part of month end support.
Monitoring Daily chains, Weekly chains and monthly chains.
Project #4 (Support)
Client : GlaxoSmithKline (GSK)
Role : SAP BI Consultant
Duration : Jun’ 2013 to May’ 2014
Environment : SAP BI 7.0 & ECC 6.0.
Responsibilities:
Daily Support activities include monitoring of data extraction and restore of failed loads.
Month end Support Activities includes Flat files loading and scheduling the Process chains on frequent basis in a day Rendering 24/7 support as a part of month end support.
Monitoring Daily chains, Weekly chains and monthly chains.
Involved in change of existing design to meet current requirements of the user.
Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
Involved in solving the Technical issues related to loading part.
Worked on Daily and Monthly Dash board Queries Broadcasting to the Portal.
Involved in Client meetings and upgrading them to rectify their mistakes which cause data extraction problems especially with the invalid characteristic.
Extensively worked with basis team for the database issues during data extraction.
Coordinating with Customers for Period End Closing Reports and supports the application.
Handling the tickets raised by the customer and resolving them with in SLAs.
Contact this candidate