Sap Hana Solution Specialist
Resume:
Prasad K akarla
*************@*****.***
SAP Solution Specialist
** ***** ** ********** **** SAP HANA & also having the experience into SAP BTP, SAP DataSphere,, SLT, BO, BODS, ODATA, HANA XSA, SAP SAC, Pyspark
●
Take ownership of the solution, develop solution strategy and drive the engagement from solution standpoint independently.
●
Develop and build best practices for HANA Data Models
●
Guided different Project teams to adopt best practices and standards.
●
Performs analysis, design, development and testing of applications to solve business requirements.
●
Models after data preparation. Expertise in Graphical View and SQL View.
●
Created fact models and consumption models for consumption in SAC dashboards.
●
Good experience in data flows, replication flows, transformation flows, task chains
●
Strong Experience in Performance Tuning and Query Optimization
●
Solved highly complex and unusually challenging technical problems
●
Experience in HANA modeling in which Creating packages, information objects like Attribute views, analytical view and calculated views Graphical and SQL script based and applying privileges.
●
Capable in Handling Complex KPI’s in HANA Modeling Environment
●
Good Exposure in Calculated column, Variables, Input Parameters
●
Implementation of HANA Models by certain standards which will help full to user for long running’s
●
Handled Currency conversions
●
Handled transportation of information models
●
Good exposure on Schemas, Attributes, Measures & Hierarchies in HANA
●
Worked on HANA Live Environment (Private Views, Reuse Views, Query Views)
●
Knowledge in SAP HANA advanced features – Dynamic Tiering, Smart Data Integration, Data warehousing Foundation tools
●
Good Exposure on HANA Live Browser
●
Identifying the SAP Standard Hana Live Content Views as per requirement and Compositing the Identified Hana Live Content Views
●
Expert in Roles Implementation in HANA XSA
●
Worked on ODATA Services
●
Implemented API’s as per requirements.
●
Worked on HANA XSA
●
Worked on BODS for replication of data from ECC to HANA System
●
Worked on SAP Landscape Transformation (SLT)
●
Monitoring of data loads in SLT.
●
Capable in transformation of Tables as per requirements in SLT
●
Hands on Experience on Data Provisioning by ETL Based approach (BODS).
●
Exposure on Smart Data Integration (SDI)
●
Exposure on Transformation in SDI
●
Capable to create job flows through SDI
●
Clear focus on documentation, SAP best practices and knowledge management
●
Leading the team for SAP HANA Project.
●
Responsible for deliverables.
●
Good working exposure on SAP Source and NON-SAPSourceenvironment.
1
K Prasad
Competencies .
SAP HANA(NATIVE HANA, HANA LIVE)
LUMIRA
ANALYSIS OFFICE
WEBI
BEX QUERY DESIGNER
SAP ABAP
Languages .
Speak
Read
Write
English
Yes
Yes
Yes
Hindi
Yes
Yes
Yes
Telugu
Yes
Yes
Yes
Bachelor of Engineering from Jawaharlal Nehru Technological University.
Deloitte
Client: Deloitte Key Responsibilities
●Implemented SAP Datasphere for seamless data integration and transformation, enhancing data quality and accuracy.
●Worked on space management & Data source connection to spaces with space allocation
●Performed admin tasks like add/delete/manage users & roles.
●Created Entity Relationship models after joining Tables/Nodes, maintaining associations. Deployed/Created Data
●Models after data preparation. Expertise in Graphical View and SQL View.
●Created fact models and consumption models for consumption in SAC dashboards.
●Good experience in data flows, replication flows, transformation flows, task chains
●Worked on Enhancements of the Existing HANA model as per requirement without
●Built an analytics layer on top of a data builder. Exposing data by creating data fabric layer on top of models based on business builder.
●Analyzes Business reporting requirements. Communicates with project team to clarify requirements.
K Prasad
●
Worked on complex SQL Scripts/Procedures
●
Helping the Team in Performance optimization techniques
●
Worked on Procedures
Cognizant
Client: Bayers
Key Responsibilities
●
Analyzing the requirement what User Provided and resolving the issues
●
Worked on Performance Optimizations on Critical HANA Models
●
Worked on HANA XSA
●
Used GIT HUB for transporting HANA objects
●
Worked on PlanViz and Explain Plan
●
Worked on HANA Calculation views
●
Worked on Procedure and Table functions
●
Analyzes HANA views to investigate report related issues faced by users.
●
Working with business to collect the requirement
●
Worked on SLT & SDI
●
Worked on Security access to users based on requirements
IBM
Client: EY (Support)
Key Responsibilities
●
Worked on Enhancements of the Existing HANA model as per requirement without changing its basic functionality
●
Analyzes Business reporting requirements. Communicates with project team to clarify requirements
●
Worked on Plan Viz and Explain Plan
●
Capable to built HANA Models with Optimized Performance
●
Capable to work on SQL Scripts
●
Performs unit testing of HANA models. Applies and maintains quality standards.
●
Writes complex SQL queries on HANA database using HANA Studio.
●
Worked on WEBI, SAP Lumira
●
Helping the Team in Performance optimization techniques
●
Worked on Procedures
●
Worked on Table functions
●
Worked with Plan viz
●
Worked on SLT& SDI
●
Worked on Security access to users based on requirements
K Prasad
Capgemini
Client: ZS Associates (Development &Support) Key Responsibilities
●
Implementing New Reports in HANA, By Understanding the Existing Reports from ECC System and designing the HANA Models.
●
Replication of DATA Using SLT.
●
Participating in Requirement gathering sessions with management to understand the business requirement and implementing business rules to redesign and enhance existing Models
●
Migration of Models from Development to Production
●
Enhancing the Existing model as of requirement without changing its basic functionality
●
Responsible to provide status of Tickets handling by team to both the client and the internal organization.
●
Resolving Day to Day Incidents Change Request
●
Analyzing the requirement what User Provided and resolving the issues
●
Worked closely with WEBI Reporting Team
Capgemini
Client: CONA AM Support New(Support) Key Responsibilities
●Assisting the team implementing the best practices in HANA Models
●Proved Innovation in Critical Phase
●Strong Experience in Performance Tuning and Query Optimization
●Applies advanced knowledge of technical standards, principles and concepts. Contributes to the development of new principles and concepts
●Solved highly complex and unusually challenging technical problems.
●Responsible for assigning the work(which is actually the service request or tickets) to the team members and also will continuously monitor their timely closure
●Responsible to provide status of Tickets handling by team to both the client and the internal organization.
●Resolving Day to Day Incidents Change Request
●Analyzing the requirement what User Provided and resolving the issues
●Replication of Data from source to target as per requirements
●Enhancing the Existing model as of requirement without changing its basic functionality
●Closing the Incidents in in time to avoid Breach
●Creating Private Views and Reuse Views according to requirement.
●Working on Analytical Privileges, finding out the secured Attribute.
●Implementing New Query views
K Prasad
●Worked on Restricted key figure
KPIT
Client : GE Lighting(Implementation) Key Responsibilities
●Analyzing the requirement and identifying the SAP standard tables & custom tables required
●Understand the requirement from Present BW system & implementing in Hana system
●Modeled huge level of calculation views with complex requirements
●Worked on calculation views with Level hierarchies and parent child hierarchies
●Handled Currency conversions
●Handled Analytical privileges for views as per client requirement
●Replicated data from source system to target system using SLT.
●Handled transformation of tables in SLT
●Identifying the SAP Standard Hana Live Content Views as per requirement ● Compositing the Identified Hana Live Content Views ● Created Multiple Reuse Views as per requirement.
●Created Query views as per requirement.
KPIT
Client :Agilent Technologies(Implementation) Key Responsibilities
●Identifying the SAP Standard Hana Live Content Views as per requirement ● Created Multiple Reuse Views as per requirement.
●Created Query views as per requirement
●Compositing the Identified Hana Live Content Views
●Created Multiple Reuse Views as per requirement &Created Query views as per requirement.
●Replicated data from source to target using SLT.
●Worked on WEBI for Reporting
KPIT May 2015 to July 2015
Client : MSEDCL (Implementation) Key Responsibilities
K Prasad
●Modeled more than 20 Analytical views for different reports
●Modeled more than 10 Calculation views for different reports
●Worked on calculation views with hierarchies
●Created calculation views by using CE Functions
●Handled huge level of calculation views
●Assigned analytical privileges for views as per client requirement.
●While extracting data from Source to Target restructured the tables as per client requirements
●Handled transportation of information models
Client : PACCAR(Implementation) Key Responsibilities
●Modeled more than 15 views ford different reports
●Modeled more than 35 views for different reports
●Defined KPI's in calculation views
●Handled huge level of calculation views
●Created Hierarchies as per client requirement
●Assigned analytical privileges for views as per client requirement ● Handled Currency conversions.
●Worked on BODS
●Worked on Lumira Reporting Tool
Contact this candidate