Mayur Kripalani Email & Phone Number

London, England, Gb

Chelmsford, England, United Kingdom

• Designed and implemented ETL processes using SQL and SSIS and Azure Data Factory to consolidate energy consumption data from various sources into Snowflake data warehouses, significantly enhancing audit capabilities.• Developed robust data models and automated processing with dbt and Azure, improving workflow efficiency and accuracy in energy reporting.• Created dynamic visualisations and interactive dashboards with Power BI, conducted A/B testing to evaluate and enhance their… Show more • Designed and implemented ETL processes using SQL and SSIS and Azure Data Factory to consolidate energy consumption data from various sources into Snowflake data warehouses, significantly enhancing audit capabilities.• Developed robust data models and automated processing with dbt and Azure, improving workflow efficiency and accuracy in energy reporting.• Created dynamic visualisations and interactive dashboards with Power BI, conducted A/B testing to evaluate and enhance their effectiveness, and generated detailed reports using SSRS to present energy insights, making complex data easily accessible and actionable for clients and stakeholders.• Conducted in-depth analysis of energy consumption survey data using SQL, Python and R, providing clients with actionable insights to optimise their energy management strategies.• Developed and presented summary insight reports, pulling together key findings and recommendations to support client decision-making processes. Show less

• Enhanced design processes through CAD modelling and stress analysis simulations, contributing to robust engineering solutions.• Automated routine data processing tasks with Excel VBA, improving workflow efficiency and reducing analysis time.• Analysed customer and operational data using advanced statistical techniques to identify inefficiencies and forecast future needs, thereby optimizing service offerings, and enhancing project planning accuracy.• Regularly engaged with project… Show more • Enhanced design processes through CAD modelling and stress analysis simulations, contributing to robust engineering solutions.• Automated routine data processing tasks with Excel VBA, improving workflow efficiency and reducing analysis time.• Analysed customer and operational data using advanced statistical techniques to identify inefficiencies and forecast future needs, thereby optimizing service offerings, and enhancing project planning accuracy.• Regularly engaged with project stakeholders to present data insights and progress updates, leveraging Power BI dashboards for clear and effective communication. Show less

Master Of Science - Ms, Data Analytics, Merit (2:1)

Bachelor Of Engineering - Be, Mechanical Engineering

University of Mumbai