Shubham Porwal
SAP BI/HANA Consultant
: shubhamporwal90@gmail.com
: 9873525972
Professional Summary:
3 years of IT experience in Software Development as SAPBI/BW/HANA consultant
Involved 1 End to End Implementation and 1 production support
Good knowledge in HANA
Hands on experience in SAP HANA Modelling (Developed Attribute views, Analytic views,
Graphical Calculation views, and SQL Script.)
Worked on multiple SAPHANA activities that includes loading data to SAPHANA from different
source systems using SLT for Real-Time and SAP BODS
Worked with industries in domains like Health Care Pharmaceutical & manufacture
Worked on Back end Business Warehouse components like Generic Extractor, info object,
info source, Info cube, Info set, DSO and Info Package.
Strong Experience in Reporting With SAP BW info provider such as info objects Cubes Queries
Maintaining AGGREGATES as well as standard info cube .Implementing ROLLUP measure for
Aggregates.
Experience in designing business view manager business objects universes complex crystal
and BO reports both full and thin Client Reports.
Worked on reports using BExAnalyzer , BEx designer
Data extraction from SAP Source System using LOCOCKPIT and Generic Extractor.
Involved in creating Generic Extractors using Table/view and Functional module
Installation of standard delivered business content in the form of info cube info source info
cube and query.
Creation of PROCESS CHAINS for data uploads.
Data extraction using Business Content data sources, flat file and R/3 extraction.
Creating Open Hub Destination (info spoke) to transfer data from info providers, (Info cube,
DSO) to flat files.
Experience in working with standard and custom info cube, info objects, info source, DSO,
transformations DTPs, Multiproviders, transportation of business content etc.
Enhanced queries by adding new objects as per the business requirement.
Experience In ETL Data Extraction, Data Transferring Data Loading Such as SAP BI
good communication and interpersonal skills technically sound Result Oriented with strong
problem solving skills capable of working as a team member
Educational Qualification:
Diploma in SAP BI HANA from ERP Scholars from March 15 to May 15.
BSc. from TDPG, Kanpur University Auraiya in 2010 with 54% marks.
12th from CH.V.S.B.V.I.C Auraiya U.P Board in 2007 with 63% mark.
10th from CH.V.S.B.V.I.C Auraiya U.P. Board in 2005 with 58% marks.
Technical Skill:
Applications (Apps) : SAP Business Intelligence (BI), Data Warehouse ETL.
Data Warehouse (DHW) : SAP BW 3.5, SAP BI 7.0, and SAP BIW 7.3.
Reporting Tool : SAP BExAnalyzer, BEx Designer
ERP Packages : SAP ECC 6.0 SAP R/3 Version 4.7
Operating System : Microsoft Windows 2007/2000/XP/2010/2013.
Professional Experience:
Working as SAP BI HANA Consultant in Elegant Technosoft from June 2015 to till now
Project # 2
Client : LULU HyperMarket
Duration : March 2017 to till now
Designation : SAP HANA Consultant
Team Size : 9
Client Description
Lulu Hypermarket (stylized as LuLu Hypermarket) is a hypermarket chain and retail venture started
by Lulu Group International in 2000. It is one of the largest retail chains in Asia and is the biggest in
Middle Eastwith 128 outlets in the Gulf Cooperation Council (GCC) countries. They also have 13 mallsa
ll over the GCC and India with a mall planned to come up in Malaysia which after opening willl be
the largest mall in Malaysia. Research firm Deloitte, recently placed it amongst the world’s 50 fastest
growing retailer
Project Responsibilities:
Worked extensively on query designer.
Hands on experience in SAP HANA Modelling (Developed Attribute views, Analytic views,
Graphical Calculation views, and SQL Script.)
Worked on multiple SAPHANA activities that includes loading data to SAPHANA from different
source systems using SLT for Real-Time and SAP BODS
Involved in data loading processes, creating info packages, DTPs. Developing and Monitoring
the Process chains. Involved in solving the tickets regarding extractions, Performance Issues
and also load failures.
Involved in solving the tickets regarding extractions, performance Issues and also load
failures.
Involved in Creation of Reports using Query Designer, BEx Analyzer such that the execution
time is evenly distributed throughout the report by using Conditions, Exceptions, Filtering,
Structures, Free Characteristics, customer exit variables, Calculated key Figures, Restricted
Key Figures and Variables
Worked with business user on Regression testing the monthly/quarterly reports and convey
the errors/issues to developer and get them fixed on deadlines
Schedules DTP for loading Transaction Data from PSA to Info provider using process chains.
Creation of Process Chain for data uploads
Loaded data from PSA to Data Target Using Transformations and DTPs
Have experience in creating functional and technical documents by analyzing the business
needs and the reporting requirements
Involved in data loading processes, creating info packages, DTPs. Developing and Monitoring
the Process chains
Worked on reports using BExAnalyzer , BEx designer
Project # 1(Implementation)
Client : One Pharma (APAC)
Duration : June 2015 to Feb 2017
Designation : SAP BW\BI Consultant
Description:
One Pharma is the APAC reporting applications migration to the One Pharma BW this is an important
step towards the consolidation platform more importantly this project is an enabler APAC is now
aligned with the latest business intelligence technology used by global reporting this brings us more
unity and collaboration which is beneficial for regional and ultimately for Roche.
Project Responsibilities:
Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes,
DSOs, Data Sources, DTPs, Transformations and multiproviders.
Set up periodic Data loads from legacy system (flat files).
Installing and creating BI objects like info objects, DSOs, Info cubes.
Creating and managing dataflow using DTP, transformations and info packages.
Designed and developed queries to generate reports inBEx Analyzer.
Monitored Daily Loads, Weekly Loads, and Month End Loads Using process chains.
Worked extensively on LO Cockpit Loaded the data from R/3 to BW and Initialization with
Delta update and Full update methods
Maintaining process chains to automate and schedule the background jobs
Created reports on sales of product by region for specific year quarter month week.
Creating aggregate to improve the query response.
Previous Experience
Worked as Data Analyst in Annik Technology Services Pvt. Ltd. from Feb 2013 to Feb 2015
Role & Responsibilities:
Provide report for external and internal use.
Analyze data to derive insights and for hypothesis, identify possible solutions, and determine
the scope of the project.
Devise and evaluate methods for collecting data, such as surveys, questionnaires, and opinion
polls
Convert complex data and findings into understandable tables, graphs, and written reports
Prepare reports and present results to clients and management
Identifying Business segment and provide the solution by analysing the data
Maintaining high productivity and customer satisfaction.
Performing data analysis and search execution.
Meet deadline of the provided data with quality.
Work on advanced excels.
Provide input and analysis of data for Product.
Perform secondary research.
Personal Details
Date of Birth : 01-july-1991
Father Name : Lt. Anoop Kumar Porwal
Married Status : Single
Languages Known : English, Hindi
(Shubham Porwal)
