Profileimage by Sankalp Nayak SAP BW, SAP BW/4HANA, SAP BO, WebI, Tableau, Power BI from Bhubaneswar

Sankalp Nayak


Last update: 03.02.2021

SAP BW, SAP BW/4HANA, SAP BO, WebI, Tableau, Power BI

Graduation: B.Tech Information Technology
Hourly-/Daily rates: show
Languages: English (Full Professional)




I am a SAP Business Intelligence Consultant & Visualization developer with 10 years of experience.I have worked on SAP BW, SAP BW4HANA, Analysis for office, SAP Analytics Cloud, Power BI, Tableau & Excel in companies like TCS, CSC, SEMTECH & Skillmad Technologies. Apart from the above, I have freelancing expertise. I completed 50+ projects to date that includes implementation, support & maintenance projects.

1. Clear communication
2. Available 24/7
3. 24-48 hours turn around.

SAP BW/4HANA, SAP BW, SAP Analytics Cloud(SAC), SAP BO, Tableau, Power BI

Project history

12/2017 - 09/2018
Senior Analytics Consultant
Client: Net4site, Devesh Logistics, BM Construction & Engineers
Role: Freelancer - Senior Analytics Consultant
Timeline : Dec 2017 - Sept 2018

Worked on SAP support project for Netforsite
Managed a team of UI developers and back end developers for the development of android apps and web
Automated the process of customer onboarding on ZOHO CRM using UI Path

07/2015 - 12/2017
Senior SAP BI Consultant
Client: Semtech
Role: Senior SAP BI Consultant

Complete development of BW Objects in BW4HANA and reporting & dashboard solutions in SAP Analytics Cloud
Design and development of BW queries, development of SAC models and stories
Leveraged knowledge of data warehouse, ETL and software development methodologies to contribute to the overall
planning by recommending approaches, identifying resources and developing timelines
Worked on CKF, RKF & set up of filters (object wise filters and global filters)
Complete flow design from ECC to BW and the report development using SAP BO
Complete flow design from APO to BW and the report development using SAP BO
Leading a 5 member SAP BW team. Management of all the SAP BW projects that is assigned to the team
Migrated BW objects from BW to BW/4HANA

05/2013 - 07/2015
Programmer Analyst
Client: Anheuser-Busch InBev
Role: Programmer Analyst

Designed Technical Specifications Documents for ABIn Bev Reports
Created write optimized DSO, Standard DSO, Info cube, Multi Provider & multiple Bex Report for ABIn Bev. Also
created SPO (Semantic Partitioning Objects)
Created custom APO BW data sources and replicated those on the external BW side, experienced in the creation of
data source from tables/views and function module
Written start routine, field-level routine, end routine, expert routine, Info package level ABAP routine (for
automatically capturing selection values for the fields). Written customer exits for reporting variables and OLAP
Creation and maintenance of Info Spokes for sending the data from BW to the Data stage
Designed and developed process chains for master and transaction data loads with the help of Info packages
Worked on performance improvement tools such as aggregates, BI statistics, and compression
Designed complex queries that involved CKF's, RKF's, formulae, variables, and variables with customer exits
Monitoring of the process chain and prompt resolution of issues in the Process Chain in the post-go-live
activities/hyper care
Involved in unit testing, peer review, pre-go-live activities, and post-go-live activities

06/2012 - 05/2013
System Engineer
Client : Australian Gas and Lights (AGL) Project : Hydro
Type : Implementation
Role : System Engineer
Timeline : June 2012 - May 2013

Identification, enhancement and replication of logistics data sources according to project requirement
Created and replicated new custom data source
Identification of standard Info Objects, Info Cubes, DSO's
Created new Info Objects, Info Cubes, DSO's
Created Info Package and DTP for Data Loading into the Info Providers
Worked on Multiprovider and Infoset
Worked on the creation of BEx report and on the creation of WEBi report on top of the BEx report
Worked on the creation of transformation routines (start routine, field level routine, end routine)
Created, maintained and monitored Process chain

08/2011 - 06/2012
System Engineer
Client : Australian Gas and Lights (AGL) Project : MINT, NECEF, NEXTGEN, TATA Steel Singapore Project
Type : Support
Role : System Engineer
Timeline : Aug 2011 - June 2012

Maintenance of InfoObjects, DSO, InfoCubes as per the business requirement
Working on Process chain
Monitored Daily Chains, Weekly Chains, Monthly Chains
Analyze the errors in the data loads
Replication of Master data, Transaction data and into the SAP BW from ECC
Worked with the Process Chain monitoring in solving the data load errors
Involved in monitoring the info package groups and process chains
Monitoring of info packages and analyzing the reasons for frequent failures of info packages
Handling tickets based on priorities and maintaining the backlog with respect to the SLA
Developing new enhancements as per the user requirements
Reconciliation's to verify the data in SAP IS-u and SAP BW are the same or not after the data loads

08/2010 - 07/2011
Assistant System Engineer
Client : Australian Gas and Lights (AGL) Project : MINT, NECEF, NEXTGEN Project
Type : Implementation
Role : Assistant System Engineer
Timeline : Aug 2010 - July 2011

Creation of reports
Creation of new Info Objects, DSO, InfoCubes as per the business requirement
Creation and replication of new custom datasource
Worked with standard datasources
Replication of generic datasource in Business Data Warehouse
Creation of InfoPackages for Extraction and Loading of data from SAP IS-U
Creation of transformation between the source and destination InfoProvider
Creation of DTP for Loading of data from PSA to infoprovider, one InfoProvider to another
Creation and scheduling of Process Chain's
Design and analysis of Query using Query Designer and analyzer

Contact form

Contact details