Sap Hana Business
Resume:
PAVAN RAI
*******.***@*****.*** · +91-832*******, 942-***-****
· https://www.linkedin.com/in/pavan-rai-64153713/
SUMMARY
Over 09 years of IT experience in business domains like Iron & Steel, Pharmaceuticals, Retail, and Food Industry
SAP Analytics Cloud SAC Certified.
SAP Business Objects.
SAP HANA ( Attribute Views, Analytical Views & Calculation Views)
Experienced in SAC – Model Configuration, Data Wrangling, Story Development, Security Development.
Experienced in SAP Business Objects – IDT, UDT, Webi, BO Explorer, BO CMC.
Experienced in SAP HANA – Attribute, Analytical & Calculation Views.
Strong communication skills to liaise with business users in understanding strategic goals and key data information.
Highly motivated, detail oriented with the ability to work independently and as a part of team.
Ability to quickly learn new functional/technical areas and in adapting to a fast-paced environment.
Knowledge in Bex Queries
SKILLS
SAP Analytics Cloud – Analytics, Modelling, Data Visualization & User/Team Creation
SAP Business Objects – Webi, BO Explorer, Dashboards, BO CMC
SAP HANA – Information Model Views – Attribute, Analytical and Calculated
EXPERIENCE
Cello, Mumbai, INDIA Feb - 2023 to Till Date
Senior SAP Analytics Cloud Developer
Developed 3 dashboard for sales, 1 for FI and 1 for Stock Ageing
Balaji Wafers, Rajkot, INDIA May - 2022 to Jan - 2023
Senior SAP Analytics Cloud Developer – SAC Lead
SAC Consultant in SAP Analytics Cloud Implementation for multiple use cases.
Managed the project from Requirements Gathering, Configuration, Integration Testing, Training to Go Live, Documentation, Post Go Live Support and End User Training.
Developed SAP Analytics Cloud analytics solution involving data wrangling, multi-model setup, model development, story development, KPI dashboarding for multiple streams of reporting and business units.
Developed Dimensions set build (Calculated and Restricted)
Developed and maintained dimension properties to be leveraged in calculations.
Developed complex advance formulas using Data Action Process.
Developed complex HANA Calculation Views to support SAC back end.
Configured connections between SAC and SAP HANA system.
Security configuration at Model, Dimension, Story, and File Structure level.
Key point of contact in communicating business requirements for reporting needs
Worked with business & technical stakeholders in developing Models, Dimensions, Members and Hierarchies
Developed dashboards that provided insights using variances, time series, bar, geo-spacial charts, and tables rendering visually stunning representations of key metrics.
Involved in documentation – User Manuals and Test Case documents.
Provided training to business users.
TataSmartFoodz, Mumbai, INDIA Aug - 2021 to Apr - 2022
Senior SAP Analytics Cloud Developer – SAC Consultant
SAC Consultant in SAP Analytics Cloud Implementation for multiple use cases.
Managed the project from Requirements Gathering, Configuration, Integration Testing, Training to Go Live, Documentation, Post Go Live Support and End User Training.
Developed SAP Analytics Cloud analytics solution involving data wrangling, multi-model setup, model development, story development, KPI dashboarding for multiple streams of reporting and business units.
Developed Dimensions set build (Calculated and Restricted)
Developed and maintained dimension properties to be leveraged in calculations.
Developed complex advance formulas using Data Action Process.
Developed complex HANA Calculation Views to support SAC back end.
Configured connections between SAC and SAP HANA system.
Security configuration at Model, Dimension, Story, and File Structure level.
Key point of contact in communicating business requirements for reporting needs
Worked with business & technical stakeholders in developing Models, Dimensions, Members and Hierarchies
Developed dashboards that provided insights using variances, time series, bar, geo-spacial charts, and tables rendering visually stunning representations of key metrics.
Involved in documentation – User Manuals and Test Case documents.
Provided training to business users.
Jyothy Laboratories Limited, Mumbai, INDIA Dec - 2020 to Jul - 2021
Senior SAP Business Objects Consultant
Responsible for designing and development of Reports and Dashboards from SAP HANA Views
Closely worked with Business Analyst, BI Lead, and the Architect in understanding the BRS & SRS documents based on the business requirements.
Performed the gap analysis to understand the feasibility in designing the dashboard layout per business requirement.
Developing the Widgets to have the highlight of total sales.
Building dashboards in BO Explorer
Creation and maintenance of users in CMC
Creating publication for the reports and scheduling them to the concern users
Extracted the reports information for the KPI’s SAP HANA connecting to underlined Webi Reports
Created the underlined Webi Reports using the Hana Calculation Views and SAP tables as sources.
Developed the complex logic using Hana Calculation Views
Scheduled the reports in CMC.
Good understanding of creating Attribute, Analytical and Calculation View in Hana Studio
Extensively worked on the different locales in the Webi interactive analysis
Worked on the development of workflow reports using Webi Reports in XI 4.2
Written the documents for user manuals and test case.
Training to the end users
Post Go Live support.
Prior Experience : Jun - 2012 to Nov - 2020
Sep - 2007 to Jun – 2012 (Teaching Professional in Engineering College)
Various Clients : SAC Projects - Jivraj Tea Ltd, Moira Sariya,
BO Projects - Safari, Transrail Lightening, Glenmark Pharmaceuticals, Colourtex
Colors & Dyes, Majid Al-Futtaim Carrefour, Radiant Hi-Tech, Sierra Digital
Multiple locations : Dubai (UAE) and India.
Worked and gathered vast experience in Business Intelligence domain.
EDUCATION
Post Graduate Diploma in Business (2022) Mumbai University, India.
Management, IT & Project Management
Bachelor of Engineering, IT (2007) North Maharashtra University, India.
Contact this candidate