SP

Sidram Patil

available

Last update: 05.09.2022

Sr.SAP HANA MODELER /Sr.SAP ABAP, Sr.SAP ABAP Consultant, Sr.SAP ABAP Consultant

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Limited professional)

Attachments

SR_PATIL_June-2022.doc

Skills

ABAP, Graphical, SQL, HANA Studio, Design Studio, Filters, Hierarchy, SAP Landscape Transformation (SLT), SAP Data Services, SAP/ non-SAP source systems, HANA integration tools, BODS, y5h, SAP NATIVE HANA Administration, managing, SAP NATIVE HANA, Software Development, ERP, SAP, NATIVE HANA 1.0, SAP ECC 6.0, Operating System, Windows Vista/XP/NT/2007/98/95, SQL SCRIPTS, SAP ABAP/4, Database, SAP HANA, ORACLE, Teradata, SFDC, Haddop(Hive), Solution Manager, CHARM, Service Now, Tableau, Qlik View, SAP BO, SRTMU, Nanded, SAP ABAP, HANA, SAP Source system, Data Replication, input parameters, databases, OLTP, router, Business Objects, Oracle database, SDA, Smart, Access, bug fixing, UAT, reporting tools, analytics, SAP BW, Data modelling, User Management, SAP R/3

Project history

01/2019 - 06/2019
SAP HANA MODELER
Wipro Technology Ltd.

Client: McLaren Automotive
Environment: SAP NATIVE HANA 1.0, SAP HANA STUDIO, Business Object.
Duration: Jan'19 - May-2019

McLaren Automotive is a creator of luxury, high-performance sportscars and supercars.
The company, launched in 2010, is now the largest part of the McLaren Group.
Every vehicle is hand-assembled at the McLaren Production Centre (MPC) in Woking, Surrey, England.
The company has three defined product families: Sports Series, Super Series and Ultimate Series
which are retailed through over 80 retailers in 30 markets around the world.

Roles and Responsibilities

* Handling Incidents related to SAP HANA development systems within SLA.
* Managing Service request and Problem Tickets to find out the root cause of recurring incident and
providing the solution.
* Developed Information Model Mapping of ECN to MCN to enable traceability of relationship between
Manufacturing Change Number items back to the related Engineering Change Number record and
vice-a-versa /PLMI/GSS_I2B_CN
* The SOE report column 'Scheduled Flag' is currently only working for partial scenarios for a
sales order. System should first look in the SAP Sales Order no.1 then VELO no.2 no.3 no.4 if
required.

06/2017 - 12/2018
SAP HANA MODELER
Zensar Technology

Client: CISCO (Demand Generation)
Environment: SAP NATIVE HANA 1.0, SAP HANA STUDIO
Duration: June'17 - Dec-2018

Cisco (NASDAQ: CSCO)
Cisco helps seize the opportunities of tomorrow by proving that amazing things can happen when you
connect the unconnected. An integral part of our DNA is creating long-lasting customer partnerships,
working together to identify our customers' needs and provide solutions that fuel their success.
We have preserved this keen focus on solving business challenges since our founding in 1984. Len
Bosack and wife Sandy Lerner, both working for Stanford University, wanted to email each other from
their respective offices, but technological shortcomings did not allow such communication. A
technology had to be invented to deal with disparate local area protocols, and as a result of
solving their challenge, the multiprotocol router was born.

Roles and Responsibilities

* Designed data sets and data mart information models like
* Advance Services Bookings and Technical Services Bookings.
* Advance Services Renewals and Technical Services Renewals.
* Installed Base Bookings.
* LDOS (Last Day Of Support)
* TAC Cases (CISCO Technical Assistance Centre)
* Modified Information models like IB, LDOS, TAC, Product Bookings, AS Booking and Pipeline
Bookings as per the client requirement.
* Performed Monthly Refresh activity against SSOT.
* Data validation on different data sets against CRUE and CE.
* Data reporting on Information models like Calculation view.
* Understand the business Requirement on the context of Reporting Need.
* Convert the Business requirement into technical.
* Analysing the gap between the reporting need and current available field in SAP HANA.
* Discuss the custom calculation with the business user to achieve the reporting need.
* Hands on experience in Data Modelling, Security implementation.
* Hands Created Attribute, Analytical, Calculation (Graphical, Scripted) view depends on Scenario.
* Integrating the SAP HANA with SAP BO (Webi Reports) for Achieving the Drill down report i.e.
Detail Reports.
* Consume the SAP HANA View into Tableau and Qlik View Dashboards.
* Apply Row level security by Creating Analytical Privileges (Region Specific) on Different
Business User from Divorced region.
* Created the Input parameter for performance tuning.
* Dump the views output (The View which took long time to Execute) into Table for performance
optimization.
* Created the Summarize and Detail Tableau Dashboard Reports on Top of SAP HANA View.
* Test the Created reports with the SAP HANA View as well as on Base Tables.
* Support the Post Production as an when necessary
* Good Conceptual Knowledge Different Replication Technique i.e. SLT and BODS.
* Did the POC on Integration of SAP HANA with Design Studio for creating interactive reporting.
* Working in Tableau to Consume SAP HANA Views for real-time reporting.
* Worked in SAP HANA with Business Objects 4.1/4.0

06/2015 - 04/2017
Sr.SAP HANA DATABSE MODELER
ERP Consulting Ltd.

Client: Confidential (Implementation Project)
Environment: SAP NATIVE HANA 1.0, SAP HANA STUDIO
Duration: June'15 - Apr-2017
Client has legacy system which stores sales data into ECC system also in Oracle database. Need to
migrate this data into SAP HANA and on top of this data client needed reports which will ensure all
fine details are captured for each of the distributor and reseller. Through SLT all data from ECC
system is migrated to the SAP HANA and for Non SAP we used SDA (Smart Data Access) as not much data
was needed to from it. On top of this data, created information views which were processing data
distributor, reseller, and ROC& currency level and make it available for the reporting tool by
pushing it to the target schema.

Roles and Responsibilities

* Analyze the source system and make plan for migration and then through SLT all data from ECC
system is migrated to the SAP HANA and for Non SAP we used SDA (Smart Data Access) as not much
data was needed to from it. On top of this data, created information views (Attribute, Analytical
& Calculation) which was processing data for distributor, reseller, and ROC & currency level and
make it available for the reporting tool by pushing it to the target schema.
* Apart from development support for the bug fixing, UAT and Production support.
* SAP HANA business requirements for technical and functional rollout for SAP and non-SAP source
systems to include in the reporting tools.
* Worked closely with Business Analyst in understanding the analytics requirements and generated
reports as per the user requirements.
* Worked in the security aspects of SAP HANA like creating Analytic Privileges.
* Helped the administrator to Identify and solve data loading errors with respect to source data
dependencies.
* Involved in extensive Integrity testing and reconciliation of the HANA models with the source
data.
* Experience on aspects of SAP HANA like creating Analytic Privileges.

08/2014 - 01/2015
SAP HANA DATABASE MODELER

Client: Warner Bros. Entertainment Inc (Implementation)
Environment: SAP NATIVE HANA, SAP HANA STUDIO, SAP ECC 6.0, SAP BW, SAP BO 4.0
Duration: May-14 - Jan'15




WBEI is one of the world's largest producers of film and television entertainment. It is currently a
subsidiary of the Time Warner conglomerate, with headquarters in Burbank, California.

Client has legacy system which stores data into ECC system also in Oracle database. Need to migrate
this data into SAP HANA and on top of this data client needed reports which will ensure all fine
details are captured for each of the distributor and reseller. Through SLT all data from ECC system
is migrated to the SAP HANA and for Non SAP we used SDA (Smart Data Access) as not much data was
needed to from it. On top of this data, created information views which was processing data
distributor, reseller, and ROC & currency level and make it available for the reporting tool by
pushing it to the target schema.

Roles and Responsibilities
* Hands on migration of ECC & Non-SAP databases to the SAP HANA using SLT. Configuration, Schema
mapping while transporting objects between the development's environments.
* Loading data into table definitions, suspending data loads, resuming data loads. Creating
information objects.
* Involves Development, Testing, Documentation, Requirement analysis, End user documentation, Data
extraction, Data modelling.
* Experience in the OLTP extraction of data of ECC system, Enhancements and extraction from flat
files, non-SAP systems.
* Experience in Performance Tuning using Indexing, Partition, and Compression.
* Good Knowledge and Experienced in User Management and security in HANA.
* Used Input parameters and variables for data filtering.
* Migrated HANA content from development, testing environment to Production environment using
delivery units.
* Designed and developed ER model and DIMENSIONAL Model.
* Data provisioning using SAP Landscape Transformation (SLT) for replication and loading.
* Evaluate impact of different implementation options such as table joins, aggregation, Projections
or filters. Understanding of performance implications of the various reporting tools and
connection
* As per business requirements developed various Calculated Columns, Restricted Columns, and
Filters, Hierarchy, variables and input parameters.

08/2012 - 01/2015
Sr.SAP HANA MODELER /Sr.SAP ABAP
CAPGEMINI CONSULTING (I) LTD


08/2012 - 08/2014
SR. SAP ABAP Consultant
Capgemini Consulting India Ltd.

Client: Centrica Energy / Direct Energy Support (Application Support)
Environment: SAP R/3 ECC 6.0
Duration: Aug'12 - Apr-14

Centrica plc is a British multinational utility company headquartered in Windsor, United Kingdom.
Its principal activity is the supply of electricity and gas to businesses and consumers in the
United Kingdom and North America. Direct energy is another oil & gas company acquired by Centrica
plc in the year 2004. It is headquartered in Toronto, Canada.

07/2010 - 07/2012
Sr.SAP ABAP Consultant
OPTIMAL SOFTWARE SOLUTIONS (P) LTD


07/2010 - 07/2012
SR. SAP ABAP Consultant
Optimal Solutions Pvt.Ltd; Hindustan Zinc India Ltd (AMS)

Client: Hindustan Zinc India Ltd (AMS)
Environment: SAP R/3 ECC 6.0
Duration: Mar'11 - Jul'12
Hindustan Zinc is a Vedanta Group company in Zinc, Lead and Silver business - India's only and the
world largest integrated producer of Zinc-Lead and also one of the leading Silver producers in the
world. They are one of the lowest cost producers in the world and are well placed to serve the
growing demand of Asian countries.

08/2010 - 03/2011
SR. SAP ABAP Consultant
Square Pharmaceuticals Ltd

Client: Square Pharmaceuticals Ltd (Support Project)
Environment: SAP R/3 ECC 6.0
Duration: Aug'10 - Mar'11
From its inception in 1958, Square Pharma has today burgeoned into one of the top line conglomerates
in Bangladesh. It holds the strong leadership position in the pharma industry of Bangladesh since
1985 and is now on its way to becoming a high-performance global player.

12/2009 - 04/2010
Sr.SAP ABAP Consultant
NET BUSINESS SOLUTIONS


12/2009 - 04/2010
ABAP Consultant
Net Business Solutions; KPMG; Supreme Petrochem Ltd (SPL)

@ KPMG:
Client: Supreme Petrochem Ltd (SPL) (Implementation Project)
Environment: SAP R/3 ECC 6.0
Duration: Dec'09 - Apr'10
SPL owns and operates a state-of-the-art Polystyrene facility with an installed capacity of 2,72,000
TPA located at Nagothane in Raigad District, about 100 Kms south-east of Mumbai city. The facility
also includes a world class colouring and compounding facility with an installed capacity of 17000
TPA. The Plant is based on technology from the erstwhile Huntsman Chemical Corporation (now NOVA
Chemicals) USA with basic engineering by ABB Lummus Crest, USA.

08/2008 - 03/2009
SAP ABAP Consultant
DATAMATICS GLOBAL SERVICES


08/2008 - 03/2009
ABAP Consultant
Datamatics Global Services

@ Datamatics:
Client: Owens Corning (Implementation)
Environment: SAP R/3 ECC 6.0
Duration: Aug'08 - Mar'09
Since Owens Corning was founded in 1938, the company has continued to grow as a market-leading
innovator of glass fibre technology. A Fortune 500 company for more than 56 years, Owens Corning
people redefines what is possible each day to deliver high-quality products & services to customers
around the world. Owens Corning invented glass fibre and glass fibre insulation 50+ years ago
including the brand and its full line of PINK insulation products.

07/2007 - 08/2008
SERVICES-Associate System Engineer
TATA CONSULTANCY

WORK PURVIEW
* Roles & Responsible for Handling of Tasks Involving:
* Involved in information gather phase.
* Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development.
* Good knowledge of Configuring SLT from SAP Source system to HANA for Data Replication.
* Created transformations in SLT using ABAP routines for Finance module to identify debit credit
Indicators.
* Helped the administrator to Identify and solve data loading errors with respect to source data
dependencies.
* Used SLT for table partitioning for performance optimization. No-drop function in SLT to
replicate data without dropping the target HANA table to avoid dropping of dependent objects.

ATTRIBUTE VIEWS
* Used attribute views to rank the customer based on age to apply discounts.
* Create time attribute views to do time analysis & worked extensively on Hierarchies.
* Created Derived attribute views to avoid rework.

ANALYTICAL VIEWS
* Extensively used analytic views for Currency conversions & Dynamic currency conversion based on
login user.
* Used Input parameters and variables for data filtering.
* Used Calculation before aggregation for line item level calculations.

CALCULATION VIEWS
* Worked on Expression filters to filter the data based on a validation column.
* Used expressions within the input parameters for data manipulations.
* Worked on Ranking and partitioning in Calculation views for performance optimization.
* Used version management technique to recover the lost models.
* Expert in designing Dimensions, Cube and Star joined Cubes.

SQL SCRIPTS
* Created SQL procedures to dump the output of the Information models into Column tables for
performance optimization.
* Used SAP HANA Job scheduler efficiently to schedule jobs.

ANALYTICAL PRIVILLEGES
* Used stored procedure in analytic privileges to dynamically fetch the login user.
* Used analytic privileges for performance optimization.

DATA PROVISIONING
* Hands on migration of ECC & Non-SAP databases to the SAP HANA using SLT. SLT configuration,
Schema mapping while transporting objects between the development's environments.
* Experience in the OLTP extraction of data of ECC system, Enhancements and extraction from flat
files, non-SAP systems.

07/2007 - 08/2008
System Engineer
Tata Consultancy Services; ABN AMRO

@ Tata Consultancy Services:
Client: ABN AMRO (Implementation)
Environment: SAP R/3 ECC 6.0
Duration: Jul'07 - Aug'08
ABN AMRO is an international bank with European roots. It ranks 8th in Europe and 12th in the world
based on total assets with more than 4,000 branches in 53 countries.
Sensitivity: Internal & Restricted

Local Availability

Only available in these countries: India
Profileimage by Sidram Patil Sr.SAP HANA MODELER /Sr.SAP ABAP, Sr.SAP ABAP Consultant, Sr.SAP ABAP Consultant from FDBAEBCFD Sr.SAP HANA MODELER /Sr.SAP ABAP, Sr.SAP ABAP Consultant, Sr.SAP ABAP Consultant
Register