Start Your Career in SAP HANA
Start Your Career in SAP HANA
Acknowledgment
Preface
Introduction
Step 1: Why you want to start career in SAP HANA
Step 2: Who is eligible to choose SAP HANA Career?
Step 3: Decide what you want to do in SAP HANA
Step 4: Build Knowledge on HANA
Step 5: Learn Project experiences
Step 6: Create unique skills to sell yourself
Step 7: Update Resume on HANA knowledge
Step 8: Gain Experience & become expert
Conclusion
Acknowledgment
I personally wish to thank you for taking your time to read this book and
learn about starting and embracing your career in SAP HANA. I know that
your time is valuable so I wrote this book as easy, in readable and
straightforward manner. I am sure after reading this book you will get great
confidence and interest that will take your HANA career path into next
level.
I would also like to thank my family and friends for all the support they
given to me, especially at times when I needed them most. Also I would
like to say big thanks to my mentor and friend Simon Vukojevic (CEO of
Vupico) who took special attention on reviewing this book and giving a
wonderful look to each line; He has done a wonderful job and it has
contributed greatly.
Magalingam Chandrakumar
SAP HANA Leads
Preface
What to expect in this SAP HANA Career Guide.
Motivation
If this book can inspire and help at least 100 people to consider SAP HANA
career transition then the purpose of the book is successful for what it was
made to do.
Introduction
This books is an investment for you. So let’s make sure you get return on
investment by understanding and following the 8 successful Baby steps of
SAP HANA Career path.
Again, this book is not going to explain in detail about what SAP HANA is
and its technical background. Instead we are going to discuss about
Why you want to start career in SAP HANA
Who is eligible to choose SAP HANA Career
what you want to do in SAP HANA
how to Build Knowledge on HANA
how to Learn Project experiences
how to create unique skills
how to Update Resume on HANA knowledge
How to Gain Experience & become expert
Before we get into career plan, let’s have high level understanding of What
SAP HANA platform is. Here is the chart from SAP presenting evolution of
SAP HANA
We all know there are different SAP HANA Platform Products available in
the market
SAP HANA(In memory DB & Platform)
SAP BW on HANA(for Data warehousing)
SAP BW4/HANA(new generation Data warehousing)
SAP Business suite on HANA (for ERP, CRM, and SRM etc.)
SAP Simple finance powered by HANA(ERP Simple Finance on
HANA)
SAP S4 HANA(ERP applications sitting on HANA Platform)
SAP HANA Cloud Platform (2017/3, newly SAP Cloud Platform-
Public Cloud)
SAP HANA Enterprise Cloud Platform(SAP Managed Cloud
platform- Private Cloud)
All above are different products for SAP even though the name HANA is
commonly used because all these products or applications are based on SAP
HANA Database. Above Last two products are Cloud platform products. In
this book we are going to focus more on SAP HANA platform and not on
Products.
(The latest version of HANA Platform is HANA 2.0 SPS01 released
2017/05)
Let’s have quick glance about what is HANA later let’s explore why the
need for HANA and why is that companies are interested from HANA.
What is SAP HANA
As you may already know, SAP HANA is game changing in-memory
database, it is also Next Generation Platform for digital transformation that
can leverage Data and Database management technology, Advances
Analytical capabilities, and intuitive application tools to develop new
innovative applications to meet your business strategic objectives.
SAP HANA platform has below 4 Main Services and released for on-
Premise, Cloud and Hybrid (Support both)
Application Services
Processing Services
Integration Services
Database services
Application Services
SAP HANA platform includes application services to build web
based applications and support open development standards such as
Java, JavaScript, C++, Node, JS, SQL, JSON, ADO.NET, JDBC,
ODBC, OData, HTML5, MDX, XML/A
Webserver Supports Server side JavaScript and OData.
Fiori UX libraries allow developers to build beautiful HTML5
User interface that are accessible from any device.
Built in Application life cycle management tools helps to perform
version control, bundle, transport and install application
Processing Services
SAP HANA platform also includes processing capabilities that
enable advanced analytics on diverse type of data. Optimize graph,
planning and rules applications on the data
Empower your business via built-in predictive analytics, business
functions and data quality
Integration Services
Organizations generate and store data in multiple systems. SAP
HANA platform includes integration services to handle various
integration strategies from variety of data sources. It can access
information stored in data silos while keeping the data in place
Help Replicate and move any type of data in real time to the cloud
and on premise when necessary
Capture and analysis live data streams and route to appropriate
storage or dashboard
Synchronize data between HANA and thousands of remote
database (SQL Anywhere, Ultra lite)
Multiple access points from HANA to Hadoop data: thru spark,
Hive, HDFS and Map Reduce
Database services
SAP HANA Platform is an ACID Complaint
Turns data into real time information
No database tuning required for complex and adhoc queries
Run transactions and Analytics together on one system and one
copy of data
Ready for cloud, Hybrid or On-Premise deployment
Not limited by the size of memory
SAP HANA provide solution for most of the above business challenges.
Few reasons why companies want to choose SAP HANA is as follows
As you are aware SAP HANA has become the fastest growing software
product in the world. So there is no surprise in plenty of career
opportunities in this field.
SAP has released HANA as platform and database on which entire
applications will function in future. Also HANA remains as one of the best
platform that offers to improve business, hence every customer is interested
to invest in this new platform. The growth in SAP HANA career
opportunities are steadily increasing and it is expected to continue in long
run.
Even though there are few in memory solutions and database products in
the market, SAP is clear and proven leader in memory technology that can
enable and support growth of next generation enterprise business.
Step 2: Who is eligible to choose SAP HANA
Career?
Since HANA Core is database platform, it helps if you already know
database concepts and have basic understanding of SQL or SQLScript.
Even if you don’t already have database experience don’t worry, it’s not so
hard to learn and start your career in SAP HANA. All that you need is
willing positive attitude to embrace on HANA career path.
There are different roles inside HANA Platform you can choose from that
would best suited your current and desired set of skills. The role name may
differ sometimes based on country or project.
For any HANA related project below 6 roles are important. Let’s have a
look
HANA Project Manager
HANA Architect/Lead/Techno functional Consultant
HANA Technical Consultant/System admin role
HANA Development Consultant/ Application developer
HANA Security Consultant
SAP BW on HANA Consultant and BO consultant
Here the title consultant is used in the roles assuming below responsibilities
Lead the planning, design, implementation and support of SAP
HANA based solutions.
HANA consultant is responsible for rolling out technical and
functional knowledge to the Project team.
Takes part in decisions on topics like Security, Performance,
Installation, Product shipment etc.
An excellent verbal and written communication skill is required
because HANA consultant also needs to interact with both business and
technical stakeholders of company.
Now let’s see what each role is demanding and match your expectations
with these roles
HANA Project Manager
For any implementation project, Project Manager (PM) is crucial role to
play.
From my experience, I feel HANA PM in addition to strong project
management skills should already have good knowledge of HANA and
good understanding of Business process and functions. HANA Project
execution is little different from traditional SAP project execution due to its
landscape and object transport life cycle management. PM should also have
exposure to ASAP, PMBOK, PRINCE2 Agile methodology and choose
right approach for right project situation. Project execution approach is the
key.
This role might not be right fit for beginners as this role need deep
understanding of technical area and functional experience.
SAP Provides HANA developer’s guide that you can download following
this link
https://cloudplatform.sap.com/content/dam/website/saphana/en_us/Technol
ogy%20Documents/SAP_HANA_Developer_Guide_en.pdf
Just make sure to stay up to date with new features of SAP HANA since
with every introduction of new Support pack. SAP adds new functionality
that can impact your development or modeling approach. This is very good
developer’s guide that will help you understand SAP HANA, modeling
approaches, Authorization, Options to Persist data, Procedures etc. Strongly
recommend that you download a copy and read it.
HANA Security Consultant
In every HANA project Security should be implemented in Design phase
based on business and technical requirements and there are enough
opportunities to gain experiences.
Security is key for any business if not implemented correctly it may expose
organizations data to people who should not have access to it. Right
governance and Security approach should be in place for every SAP HANA
project.
Very few people with knowledge of SAP HANA security are there in the
market. Most of the time technical consultant or development consultant
also will pick up experience on Security and play that role in the project.
Some of the key responsibilities of SAP HANA Security experts are
Customized roles in native HANA database (DB) for Developers,
Modelers, Administrators, Power users, and end users.
knowledge and experience to control, and restrict access to
HANA DB objects based on package
Ability to setup security at data level to restrict access to data
based on functional roles.
Provide system privilege, Object Privileges and Analytic
privileges.
Create schema level access control on HANA DB.
Business Warehouse (BW) and HANA security administration
experience.
integrate SAP BW level security on HANA DB, integrate
Business Objects (BOBJ) Security on HANA,
Experience working with HANA Studio and HANA Live, HANA
Life Cycle Manager and Transport Mechanism
Troubleshooting and tracing ability to resolves issues related to
the security issues.
Administrative tasks related to HANA Security. HANA user
authentication and single sign on (SSO) setup.
If you already have background on Security you should invest time into
learning SAP HANA specific security features.
HANA BW on HANA & BO consultant
If you notice above roles can find BW and BO are the skills demanded
along with HANA roles. Generally if you are working on HANA core
system you will not need BW or BO and ERP skills. But in real scenario
most of case we need to integrate HANA with ERP system and Data
warehousing BW to enable Analytics.
Here are the various ways you can build your HANA knowledge. HANA
tutorials and information are spread across all below categories
Online resources
Books
YouTube
ELearning
Training and Certification
Networking
If you are so serious about embracing HANA career, I personally
recommend taking SAP HANA certification. Your SAP certification will
talk for you till you get more experience in projects. Generally certification
is not enough to get job in HANA career, experience does matter. But it will
be your first step of success and selling point for you.
These are SAP portal related information. Are you aware of this
information?
No SAP Portals Link
1 SAP HANA Products https://www.sap.com/products/hana.html
(Basic/Fundamentals)
2 SAP Training www.Training.sap.com
3 Open SAP https://open.sap.com/
This can be your one-stop shop
to mastering most of the
trending SAP technologies. You
can enroll for the various
courses on HANA. There are
specific timeline for the courses
and most of them can be
downloaded once they are
available.
4 The SAP HANA Academy https://www.youtube.com/user/saphanaacademy
YouTube Channel
5 SAP Community Network https://wiki.scn.sap.com/wiki/display/WHP
6 SAP Blogs https://blogs.sap.com/
7 SAP E-Learning https://performancemanager.successfactors.eu/login?
check your company whether company=learninghub&loginMethod=PWD
there is any license for E-
Learning can read all SAP
training eBooks and handbooks
and some E-learning materials
8 SAP JAM for collaboration https://jam4.sapjam.com/extranet/jamatsap.com
SAP Jam is a platform that
enables SAP customers and
partners to interact with SAP
employees and collaborate with
them in online groups upon
invitation.
9 SAP Help Portal https://help.sap.com/viewer/p/SAP_HANA_PLATFORM
For new releases and
Installation/Migration
documentation download
See if you can learn some of the skills mentioned below during your Career
Transition.
HANA XS application Development based on programming
JavaScript, CSS, HTML/XML and Java programing for Cloud platform
Tools like HANA studio, Eclipse, Web IDE, UI5, OData
Fiori development for new platform
R Script and Predictive analysis and Analytical tools are
advantage
Understanding of new SAP products like Hybris, Sucesssfactors,
Concur, Field glass etc. to know how they can be integrate with SAP S4
HANA to achieve end to end business
It’s true unless you work in project you may not feel the real taste of how
projects are executed and what happens especially when timeliness are
tight. But that’s ok it’s not too far for you if you already followed baby step
4
If your company already have SAP HANA implemented you can explore
the project deliverables, speak to team who has executed it, ask for HANA
training, user access etc.
If you already have access to the SAPHANA environment you can practice
different scenarios like below to get more familiar.
HANA Studio and View Creation
HANA administration
SQL Script/Procedures
R Programming
For more complex scenarios it might more difficult to execute with your
trial environment since those scenarios require integration with other
systems like BODS Tool, BO tools (WEBI) BW system, Hadoop tools
ETL BO Data services (Integration with ERP, BW and Legacy
systems)
Analytic Reports on HANA (BO)
BW on HANA
Hadoop Integration
The more you practice sample scenarios and relate with projects you get
more probability and confidence to explain during job interviews
Create different real scenarios and see what challenges you are facing and
how you are solving the issues
You should also know how to fix the issues when defect is raised, what are
the steps that will help you resolve the issues?
Learn how to get connected with SAP Community/blog, SAP OSS tickets
and SAP Support Portal and how it help you resolve the issues. Search SAP
notes and interpreting SAP Notes is also a skill to learn.
Below are the project options where you can look for openings
SAP HANA Implementation or support
SAP BW on HANA implementation or Support
SAP HANA and Hadoop Integration Project
SAP Cloud platform Projects
SAP Enterprise cloud Project
SAP BI HANA analytics Project
SAP IOT Digital Analytics on HANA Project
Step 8: Gain Experience & become expert
Congratulations! Let’s assume now you got the opportunities to join the
HANA project. The real fun starts now. Brush up your skills and understand
what your scope of work is in the project
Most people focus more on Technical areas, but can’t give right solution to
business problems. If you ask how many of them can explain real use case
of implementing HANA, you won’t find many. In my experience, very few
know how to explain and sell HANA to the customers.
There are two Major reasons to develop skills in SAP HANA Career Path
1) Understanding the technical HANA platform itself
2) Understanding how to sell HANA to business to gain competitive
advantages for the future
If you know both, you are an expert. because you know how to sell and
implement HANA for right business requirement. Many fail in later part
due to lack of business knowledge or industry experience.
Let me share with you few lessons learned from my previous projects.
Right mix of resources (HANA, BO, BW, Hadoop, ERP, and
ETL) in the project is critical for the project. Adding multiple skill
resources will increase your cost. Need to see how you can balance the
skills and resources.
If your project is in countries like China, Japan, Vietnam etc, then
need to make sure bilingual skill availability.
Master data integration, see if you have siloes system or multiple
legacy system in your project landscape. Different legacy system has
different type of data’s, need deep understanding and Master data
management skills to handle the data without loss of information. If
master data is not clean whole project will be in trouble.
Deciding Data Management strategy is important, where will you
keep the data, data temperature concepts (hot, warm and cold data),
very important to consider Archiving and data retention strategy. Data
management strategy should be in place before you go live the project.
You need to figure out where you want to keep the hot, warm, cold data
in your landscape. Products like Hadoop and SAP ASE are there in the
market to help you on this.
Real life experience is the key, see if you can use below SAP
HANA 2.0 express edition(virtual Machine method) in your laptop or
computer and play around to get some look and feel
https://www.sap.com/developer/tutorials/hxe-ua-installing-vm-
image.html
The overall time required to prepare and follow all 8 Baby steps could
roughly estimate from 3 to 6 months. It’s again based on your desire,
aggressiveness and volume of the content you are referring during this time.
All the best for your luck and please feel free to contact me if you have any
questions about HANA Career Progression.
Author
He is also a Bilingual who can speak both English and Japanese, capable to
communicate within local customer groups and global networks. His focus
is on working with current new edge technologies of SAP HANA related
products like S4 HANA and SAP cloud Platform and help customers to
enable digital transformation in the Japan market to maximize their
Investment on Innovation and Analytics. He is also a frequent speaker at
Major HANA conferences worldwide.
Thank you