Abhiram Hari

Senior Data Analyst @Ocado Technology

Hatfield, GB

Maintained Data warehouse by extracting and integrating data from diverse systems such as MRP (R12), Oracle Fusion, Jira, and Q-Plus channelling it into Google Big Query (enabling the presentation of live KPI data) and Apex (for reporting).• Developed data models including staging, semantic and presentation layers to ensure that data is organised and structured effectively.• Developed custom BI reports for operational efficiency and stock updates using SQL, Python, VBA and Google Scripts enhancing data visualisation and accessibility.• Formulated and implemented key performance indicators (KPIs) tailored for the supply chain ensuring adherence by cross-functional teams and bolstering overall supply chain performance.• Presented data-driven insights to the leadership team based on KPIs and conducted Root Cause Analysis to permanently address identified issues using Lean & 6 Sigma concepts and used various tools such as the 5 whys and Fishbone diagram to explain them.• Translated business requirements by Conducting requirements gathering, meticulously analysing pain points in existing processes, and opportunities for improvement into technical solutions by implementing various solutions in the form of reports, visualisations and other solutions such as Fusion Analytical Warehouse.• Managed day-to-day project activities, facilitating workshops with operational and technical stakeholders to ensure project alignment with organizational objectives.• Provided mentorship and supervision to junior colleagues, fostering their professional growth and development.

Matrusri Engineering college

Bachelor’s Degree, Electronics and Communications Engineering

Sri Chaitanya Junior College

Intermediate, Maths, Physics, Chemistery

University of Hertfordshire

Master's degree, Data Science and Analytics

Good Samaritan High School

High School