RAVI KUMAR LALAM

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.

• 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.