Summary
Overview
Work History
Education
Skills
Profile Summary
Timeline
Generic
RAVI KUMAR LALAM

RAVI KUMAR LALAM

Visakhapatnam

Summary

Around 7+ Years of experience SAP BI consultant with a robust skill set in requirement analysis and technical documentation. Drives project success through effective collaboration, ensuring alignment between business needs and technical capabilities. Committed to delivering high-quality solutions that enhance operational efficiency.

Overview

8
8
years of professional experience

Work History

SAP BI Consultant

Unique IT Solutions Pvt Ltd
Hyderabad
08.2022 - Current
  • Working as SAP BI Consultant in Unique IT Solutions Pvt Ltd from August 2022.

SAP BI Consultant

Unique IT Solutions Pvt Ltd
Hyderabad
03.2025 - Current

Project #5: IT POD Performance Optimization

  • The Project is to improve the performance of the ODW Model by following optimization techniques of which how better performance is improved in terms of memory and execution time.
  • Analysing the model and finding the root cause of the memory spike.
  • Performing analysis and working on complex technical issues, designing the solution by taking memory into consideration before optimization and after optimization.
  • Designing new table functions by optimizing memory consumption.
  • Performing analysis on logic and building solutions.
  • Communicating to business stakeholders by detailed explanation business needs into technical solutions.
  • Optimizing Hana models for better performance using different methods.
  • Sometimes changing design structure based on performance issues.
  • Interacted with Business stakeholders in order to understand their structured and ad-hoc reporting requirements, business rules for finance, sales and marketing domains.
  • Debugging objects node by node to check the real.
  • Designed scripted calculation view based on requirement where graphical view is not suitable.
  • Work on code optimization, optimizing business logic and replacing direct source tables in place of views wherever possible and testing the model before and after data match.
  • Identifying and fixing real time issues and providing alternate solutions.
  • Seeking design and code approval.
  • Handover the optimized model to business stakeholders for UAT testing and seeking approval.
  • Seeking all the approvals as part of the MTP process requesting the change management team to proceed with the MTP changes moved to Production system.

SAP BI Consultant

Unique IT Solutions Pvt Ltd
Hyderabad
09.2023 - 02.2025

Managed 50+ JIRA stories involving technical and collaborative duties, ensuring product alignment with business requirements and project goals.

  • Developed calculation views, table functions, stored procedures, and data models in SAP HANA to meet project specifications.
  • Design the requirements into HANA database models (views, procedures, table functions).
  • Testing and Validation: Develop unit test cases, validate solution outcomes, and perform code reviews to ensure quality.
  • Documentation: Update Jira tickets with technical design notes, resolution steps, and validation evidence. Maintain up-to-date technical documentation for requirements traceability.
  • Collaboration: Communicate with business analysts, testers, and other stakeholders to clarify requirements and refine acceptance criteria tracked in Jira.
  • Jira Management: Move tickets through workflow stages (To Do, In Progress, Review, Done), log progress, add comments, and provide status updates.
  • Analyze the business needs and technical requirements in the Jira.
  • This Project is to work on requirements from the Jira tool which is responsible for finding project tasks and user stories.
  • Project #4: Simplify BI CSS Enhancements and Fixes

SAP BI Consultant

Unique IT Solutions Pvt Ltd
Hyderabad
09.2022 - 08.2023

Secured requirement gathering from business, collaborated on data flow, design flow, technical flow, and UAT.

  • Created data flow architecture illustrating the model and what tables are involved in the model.
  • Created reports based on data model aligned with business requirements.
  • Collaborate closely with business, functional analysts, and other technical teams throughout the project lifecycle.
  • Led the simplification of the BI implementation project
  • This Project is newly implemented project from scratch named Annuity contacts and Quotes using CRMS4D tables as source tables.
  • Maintain comprehensive documentation covering data flows, technical design, user guides, and testing outcomes.
  • Worked with business stakeholders as part of UAT testing.
  • Identified and resolved data or performance issues during development and post-deployment phases, ensuring system reliability.
  • Provide support during go-live and hyper care phases ensuring system stability.

SAP Hana Consultant

Swiftsoft Infotech Services Pvt Ltd
10.2020 - 07.2022

Project #2: SAP Hana Support & Enhancements

  • Performed data modelling by creating calculation views in HANA Studio to support analytics and reporting needs.
  • Executed SAP HANA security tasks, managing user access and role assignments to ensure data integrity and compliance.
  • Interacted with Business stakeholders in order to understand their structured and ad-hoc reporting requirements, business rules for finance, sales and marketing domains.
  • Developed proficiency in SQL and writing stored procedures for data manipulation.
  • Gained experience with ETL tools such as SLT, BODS, and SDA for data integration.
  • Bringing Data from ECC, Oracle and Flat files to the Target system.
  • Integrated HANA views with reporting tools such as MS Excel, Analysis for OLAP, Web Intelligence, and Tableau to enhance data accessibility for stakeholders.
  • Acquired knowledge of SAP HANA architecture and various deployment options.
  • Welch Allyn is an American manufacturer of medical diagnostic devices, patient monitoring systems like stethoscopes, horoscopes, and medical thermometers. It is the headquartered in Skaneateles Falls in New York. The company is in the manufacturing, sales and distribution the domain in SAP since 2006.

SAP Hana Associate

Swiftsoft Infotech Services Pvt Ltd
01.2018 - 10.2020

Project #1: SAP Hana Enhancements

  • Loading Data into the SAP HANA Database using SLT and SDA.
  • Transferred data from ECC and flat files into the target system using established protocols.
  • SAP HANA Security activities like User Management, Assigning Roles to users and managing Analytics.
  • Privileges to enable course gained and fine-grained access control.
  • Developed analytical views for transactional data, attribute views for master data, and calculation views in HANA Studio to optimise data modelling processes.
  • Managed transport of HANA content from development and testing environments to production using HTA T-code, facilitating seamless deployment and integration.
  • Collaborated with business stakeholders to gather and clarify structured and ad-hoc reporting requirements, ensuring alignment with finance, sales, and marketing business rules.
  • Integrating HANA views with Reporting tools like MS Excel, Analysis for OLAP, Web intelligence and Tableau.
  • ArcelorMittal S.A. is a multinational steel manufacturing corporation headquartered in Luxembourg City. ArcelorMittal is the second largest steel producer in the world.

Education

MTECH -

VIT University
Vellore
01-2016

BTECH -

Kaushik College of Engineering
Kakinada
01-2013

Skills

  • SAP BW on HANA
  • SAP NATIVE HANA
  • S/4HANA
  • SAC
  • Power BI
  • Azure Databricks
  • SQL
  • SQL performance tuning
  • Datasphere Modelling
  • Business intelligence
  • Analysis for OLAP
  • Requirements analysis
  • Unit testing
  • Technical documentation
  • Microsoft Excel
  • SAP implementation

Profile Summary

  • IT POD Performance Optimization, Unique IT Solutions Pvt Ltd, HP, SAP BI Consultant, 2025-03-01, 2026-12-31, This Project is to improve the performance of the ODW Model by following optimization techniques of which how better performance is improved in terms of memory and execution time., Analysing the model and finding the root cause of the memory spike., Performing analysis and working on complex technical issues, designing the solution by taking memory into consideration before optimization and after optimization., Designing new table functions by optimizing memory consumption., Performing analysis on logic and building solutions., Communicating to business stakeholders by detailed explanation business needs into technical solutions., Optimizing Hana models for better performance using different methods., Sometimes changing design structure based on performance issues., Interacted with Business stakeholders in order to understand their structured and ad-hoc reporting requirements, business rules for finance, sales and marketing domains., Debugging objects node by node to check the real., Designed scripted calculation view based on requirement where graphical view is not suitable., Work on code optimization, optimizing business logic and replacing direct source tables in place of views wherever possible and testing the model before and after data match., Identifying and fixing real time issues and providing alternate solutions., Seeking design and code approval., Handover the optimized model to business stakeholders for UAT testing and seeking approval., Seeking all the approvals as part of MTP process requesting change management team to proceed with the MTP changes moved to Production system.
  • Simplify BI CSS Enhancements and Fixes, Unique IT Solutions Pvt Ltd, HP, SAP BI Consultant, 2023-09-01, 2025-02-28, This Project is to work on requirements from the Jira tool which is responsible for finding project tasks and user stories. Worked on 50+ Jiras stories in this project which includes both technical and collaborative duties, ensuring the delivered product matches business requirements and project goals., Analyze the business needs and technical requirements in the Jira., Design the requirements into HANA database models (views, procedures, table functions)., Developing calculation views, table functions, stored procedures, and data models in SAP HANA., Testing and Validation: Develop unit test cases, validate solution outcomes, and perform code reviews to ensure quality., Documentation: Update Jira tickets with technical design notes, resolution steps, and validation evidence. Maintain up-to-date technical documentation for requirements traceability., Collaboration: Communicate with business analysts, testers, and other stakeholders to clarify requirements and refine acceptance criteria tracked in Jira., Jira Management: Move tickets through workflow stages (To Do, In Progress, Review, Done), log progress, add comments, and provide status updates.
  • Simplify BI Implementation Project, Unique IT Solutions Pvt Ltd, HP, SAP BI Consultant, 2022-09-01, 2023-08-31, This Project is newly implemented project from scratch named Annuity contacts and Quotes using CRMS4D tables as source tables. Securing requirement gathering from business and work on Data flow, Design flow, technical flow, UAT. Created multiple reports on the Data model as part of Business Requirement., Created data flow architecture illustrating the model and what tables are involved in the model., Maintain comprehensive documentation covering data flows, technical design, user guides, and testing outcomes., Collaborate closely with business, functional analysts, and other technical teams throughout the project lifecycle., Worked with business stakeholders as part of UAT testing., Identify and resolve data or performance issues during development and post-deployment., Provide support during go-live and hyper care phases ensuring system stability.
  • SAP Hana, Swiftsoft Infotech Services Pvt Ltd, Welch Allyn, SAP Hana Consultant, 2020-10-01, 2022-07-31, Welch Allyn is an American manufacturer of medical diagnostic devices, patient monitoring systems like stethoscopes, horoscope, and medical thermometer. It is headquarters in Skaneateles Falls in New York. The company is in manufacturing, sales and distribution domain in SAP since 2006., Performed data modelling Creating calculation views in Hana Studio., Understanding of SAP Hana Architecture and different deployment options., Bringing Data from ECC, Oracle and Flat files to the Target system., SAP HANA Security activities like User Management, Assigning Roles to users and managing Analytical., Interacted with Business stakeholders in order to understand their structured and ad-hoc reporting requirements, business rules for finance, sales and marketing domains., Experience in SQL, Stored Procedures., Experience in ETL Tools like SLT, BODS, SDA., Integrating HANA views with Reporting tools like MS Excel, Analysis for OLAP, Web intelligence and Tableau.
  • SAP Hana, Swiftsoft Infotech Services Pvt Ltd, Arcelor Mittal, SAP Hana Associate, 2018-01-01, 2020-10-31, ArcelorMittal S.A. is a multinational steel manufacturing corporation headquartered in Luxembourg City. ArcelorMittal is the second largest steel producer in the world., Performed data modelling and developed Analytical views for the transactional data, Attribute Views for the master data and the calculation views as final model in HANA Studio., Loading Data into the SAP HANA Database using SLT and SDA., Bringing Data from ECC and Flat files to the Target system., SAP HANA Security activities like User Management, Assigning Roles to users and managing Analytics., Privileges to enable course gained and fine-grained access control., Interacted with Business stakeholders in order to understand their structured and ad-hoc reporting requirements, business rules for finance, sales and marketing domains., Transported HANA content from development, testing environment to Production environment using HTA T-code., Integrating HANA views with Reporting tools like MS Excel, Analysis for OLAP, Web intelligence and Tableau.

Timeline

SAP BI Consultant

Unique IT Solutions Pvt Ltd
03.2025 - Current

SAP BI Consultant

Unique IT Solutions Pvt Ltd
09.2023 - 02.2025

SAP BI Consultant

Unique IT Solutions Pvt Ltd
09.2022 - 08.2023

SAP BI Consultant

Unique IT Solutions Pvt Ltd
08.2022 - Current

SAP Hana Consultant

Swiftsoft Infotech Services Pvt Ltd
10.2020 - 07.2022

SAP Hana Associate

Swiftsoft Infotech Services Pvt Ltd
01.2018 - 10.2020

MTECH -

VIT University

BTECH -

Kaushik College of Engineering
RAVI KUMAR LALAM