TT

Tapan TRIPATHY

available

Last update: 06.09.2022

SAP BW HANA Analytics Consultant

Company: Arrys limited
Graduation: M.Tech
Hourly-/Daily rates: show
Languages: English (Full Professional)

Attachments

CV - Tapan Tripathy 072020.pdf

Skills

SAP BW/4HANA, Analytics Cloud (SAC), HANA, BW in S/4 HANA, SAP BW/4 HANA, SAP, SAP BW, Build HANA, Data flow Model, Partitioning, and, grouping, ODP Datasources, CDS, SLT, S/4, HANA System, SAP Analytics, Cloud, BW, ODP Framework, Business Object(BO), Design Studio 1.6, WebI Report, Dashboard Design and Analysis Office, BICS, Activation, Business Content objects, Data Modeling, Layered Scalable Architecture, LSA++, LO Cockpit, Generic extractors, flat file loads, Query design, Exception, Conditions, variable exit, currency translation, HANA Studio, ABAP, SAP BI, Analytics, Axon, Data modelling, data model, Datasource, Redshift, FI, SAP HANA, database, scalability, ODATA, Data Migration, UAT, Stored Procedures, SAP HANA modelling artefacts, Core Data Services Views, SQL Code, SQL Script, Decision Tree, User Management, BO Design Studio, BEx, Java Script, large data, HANA Enterprise Cloud(HEC), system monitoring, data visualisation, ERP, APO, BO Web Intelligence, SAP HR, Coding, R/3, CRM, OLAP, DB

Project history

04/2019 - 10/2019
Consultant
Royal Bank of Canada; SAP Analytics


04/2019 - 10/2019
SAP Analytics
Royal Bank of Canada

Royal Bank of Canada
For RBC Investor & Treasury Services, the FIDES project will bring all of this and more in the form of a single
ledger and integrated financial management system across Europe and APAC operations. This new application
will rationalize, standardize, automate, and centralize data, feeds, processes, and reporting, to reduce
operational risk, provide future business scalability, and deliver technical and operating efficiency and
consistency across reporting levels/platforms

April 2019 to Oct 2019

Role: SAP Analytics

Implementation of Hana Analytics in FIDES project
* Designed and developed HANA Information views and data modelling using CDS Views
* Exposing the CDS views to ODATA to be consumed by FIORI application
* Consuming the CDS views and HANA calculation views in WEBI and FIORI tiles
* Developed CDS Table control to handle complex requirements
* Implemented CDS Access Control to define instance based authorization check
* Designed complex reports using WebI to meet business requirements
* Developed simple FIORI tiles to consume CDS consumption views

05/2018 - 04/2019
Consultant
Brakes Group; SAP BI/BO/HANA


05/2018 - 04/2019
SAP BI/BO/HANA Consultant
Brakes Group

Brakes Group
The Brakes Group is a leading supplier to the foodservice sector in the UK, Ireland, France and Sweden.

May 2018 to April 2019 and Dec 2016 - Aug 2017

Role: SAP BI/BO/HANA Consultant

Implementation of BW on HANA :
This program is re-implementing the current SD Orders and Delivery BW solution in new landscape through
phased approach to improve the system performance. Implementation of Trial balance and Cost Centre
account Reporting. This involved the following activities
* Activation and enhancement of SAP HANA-optimised BI Contents to meet the business requirement
* Data Migration of the historical orders and delivery data from 3.5 system
* Data model to follow the requirements for the layered scalable architecture LSA++, which is optimized
for BW running on SAP HANA
* Implementation of SAP HANA-optimized Business Content for Cost centre accounting and FI/GL
* Stake holder management Plan, effort estimation, UAT and cut-over activities

08/2017 - 04/2018
Consultant
Swiss Re; SAP BI/BO/HANA


08/2017 - 02/2018
SAP BI/BO/HANA Consultant
Swiss Re; ATLAS RDI and Cost Transparency Reporting

Swiss Re (Zurich)
Swiss Re is world's second-largest reinsurance company based in Zurich, Switzerland has offices in over 25
countries.

Aug 2017 to Feb 2018 and Nov 2015 - Nov 2016

Role: SAP BI/BO/HANA Consultant

ATLAS RDI and Cost Transparency Reporting :
As a Tech Lead my primary responsibility includes collaboration with functional experts, Business Analysts and
offshore partners to jointly deliver solutions for all financial Reports and Dashboards.

* Hybrid modelling in Mixed scenario modelling BW & HANA views & CDS views and CDS Table
Functions, Stored Procedures
* Creating SAP HANA modelling artefacts using Attribute view, Analytical View and Calculation view in
HANA Studio
* Creating Core Data Services Views using SQL Code in S/4 HANA environment
* Designed Virtual Data Mart layer like Composite provider, Virtual Infocube, ADSO Object, Open ODS
based on SAP HANA Model
* Good Knowledge of SQL Script, CE Functions, Decision Tree, Currency Conversion
* Knowledge of SAP HANA security including User Management, Role and Analytic Privilege
* SAP BW configuration design & build within Layered & Scalable environment
* Designed Dashboards using BO Design Studio using BEx and Java Script
* Design of data warehousing solutions with in-the-large data volumes
* Support HANA Enterprise Cloud(HEC) migration

05/2015 - 10/2015
Consultant
Bluefin Solutions


05/2015 - 10/2015
SAP BW/BO Consultant
Bluefin Solutions

Clients: British American Tobacco( Tao Project)

Early Warning Dashboard:
The aim of this project is to provide a single view of the stability of the BAT BI system, through an Early Warning
Dashboard (SAP BO Dashboards) displaying prioritised system monitoring metrics pulled from a wide range of
sources such as Solution manager, Early Watch Report and BI Technical Content.

The project is an end to end deliverable, comprising of a number of technical stages, such as setting up
extractors in various source systems, building flows and data models, setting up a reporting layer, automating
data loads, creating reports, and finally, designing and delivering the dashboard to align usability, performance,
predictive analysis techniques and data visualisation best practise.

06/2014 - 05/2015
SAP BW Consultant (Team Lead)
Wipro Technologies

Clients: GlaxoSmithKline(GSK) - Global ERP Program

TSM Task Force :
The Role involved the support and stabilization of Trade Promotion Management BI Reports. Managing the
offshore team to develop the data model and reports.
* Parent child Report for promo packs and Customer Profitability and Rebate Tracker Report
* Promotion Planning with BPS
* Trade Fund Management
* Integration of SAP SD for Discount/Rebate and Free Good Scenario
* Integration with APO

02/2013 - 05/2015
Consultant
Wipro Technologies


02/2013 - 05/2014
SAP BW Team Lead
Wipro Technologies

Client/Project: National Grid Metering I&C Transformation

Tasks: Successfully lead a team of eleven. The team's work relied heavily on IS-U/CCS and PM/CS data model
knowledge, Contract Accounts Receivable and Payable (FI-CA) and Business Object Reporting using Web
Intelligence. Standard IS-U and bespoke extractor created using ABAP to meet the requirement. The development
involved :
* Unbilled Revenue using IS-U mass simulation and Sales Statistics Enhancements




* Extraction and enhancement of FI-CA Open and Clear Items and Development of SAP BW models, in the
Billing area, from the IS-U system for meter rental process
* Complete & Integrated IS-U Master Data Solution and understanding of asset hierarchy
* Developed BO Web Intelligence report and BO Dashboard using BICS connection. Good exposure to
Information Design Tool(IDT), Central Management Console(CMC) Life Cycle Management(LCM),
Promotion Management, Business Intelligence Consumer Services (BICS)

06/2007 - 01/2013
SAP BI/BW
Axon Solutions


06/2007 - 01/2013
SAP BW Consultant
HCL - Axon Solutions Limited

Clients: Xerox, TFL, GSK, British Petroleum( BP), Birmingham City Council


XEROX : A2B( Average to Benchmark )
Worked as a BI HR module lead in A2B project on SAP NW 2004s BI 7.0 platform.
Was accountable for the following activities.

* Conduct workshops and understand the business requirements of the company and conduct Gap
Analysis along with functional consultant to install SAP HR Business Content( Infoproviders/Queries) and
enhancing them using user exits
* Worked on head count( On and Off roll) report development in the area of personnel administration
* Developed Movers and Levers comparison based on year, Employee Roles/Position/Gender, average
length of staffing, job history and Organizational Reassignment reports.
* Built Custom User Exit Variables using the SAP ABAP Coding



Transport for London : Managed Services
As a part of a TFL on-going programme, HCL AXON provides the full suite of support services as a part of long
term SAP managed Service Call Off Agreement. TFL's SAP landscape comprises of ERP(R/3), Business Intelligence,
Customer relationship Management (CRM) and Supplier Relationship Management (SRM) across 8 separate
environments.
* As a lead consultant, responsible for change management from BI side and bridge the gap between
business requirement and solution development and to ensure the technical completeness of every
change
* Involved in various BI development in FI, HR, PM, Real Estate, CRM and SRM modules
* Proficient in coordinating and managing the activities between on-shore and off-shore teams
* Monitoring data load from various source systems like R/3, CRM and SRM etc.


British Petroleum(BP) : Upgrade and FBW
SAP BW Technical Upgrade of Integrated Supply and Trade(IST) system from version 3.5 to 7.01
The approach involves technical upgrade of the system landscape and developing "bespoke patches" to address
issues effecting the existing functionality.
* Worked on Application specific Upgrade(ASU) toolbox to execute preparation and follow-up steps for
an easy upgrade
* Installed BI Statistics to monitor the query runtime statistics and data upload statistics. The information
drawn such as OLAP Time, front end time, data manager time, records selected on DB etc is utilised in
comparison of performance before and after upgrade
* Tested query and interface functionality to make sure no functionality is lost

12/2000 - 04/2007
Consultant
Wipro Technologies


08/2000 - 11/2000
Consultant
L&T InfoTech; SAP ABAP


10/1999 - 07/2000
Consultant
Ygyan Consulting; SAP ABAP


Local Availability

Only available in these countries: Germany

Other

I am a certified SAP BW/4 HANA , SAP Analytics Cloud and HANA Consultant having 20 years of experience out of which 15.5 years in SAP SAP Analytics and 4.5 years in ABAP OO.
My primary skillsets are as below :
  • Certified SAP BW/4 HANA with strong programming knowledge in ABAP OO and AMDP Transformation using SQL.
  • SAP CDS View
  • Real time Replication using SAP Landscape Transformation (SLT)
  • Certified In SAP Analytics Cloud
I have extensive work experience in Switzerland and Germany.  
Should you need further information, please feel free to contact me anytime.
Regards,
Tapan
00 44 7507142028
Profileimage by Tapan TRIPATHY SAP BW HANA Analytics Consultant from Purley SAP BW HANA Analytics Consultant
Register