Asanka Hemachandra

Design and implement enterprise-scale analytics solutions across sectors, delivering insights that support strategic decision-making and operational efficiency. Led end-to-end data pipelines using Medallion and Lakehouse architectures on Microsoft Fabric and Azure Databricks, enabling faster, data-driven decision-making across business units. Managed cloud resources (Power BI capacities, Azure Databricks, Lakehouse, warehouses and storage accounts) to support scalable analytics platforms. Designed and executed advanced data models and interactive BI dashboards, integrating data from diverse sources via automated ETL workflows to accelerate access to actionable insights.

Developed a global S&OP forecasting model across manufacturing sites in the UK, USA, Poland, Sweden, Germany, Canada, China and India, integrating ERP and HRM data to anticipate demand and bottlenecks. Built forecasting models for sales, operations, financials, HRM, and skill matrices to enhance planning and performance tracking. Implemented ERP, HRIS, and EAM solutions, designed scalable BI architecture, and established data science models including labour time prediction for manufacturing. Automated ETL processes and optimised data pipelines to improve speed and accuracy of decision-making, while improving data warehouse performance and scalability.

Led requirements gathering, system analysis, and design for custom software solutions, developing middle-tier integrations and ensuring reliability and performance. Collaborated with cross-functional teams to deliver scalable software applications using agile methodologies, streamlined development workflows, and managed multiple projects with a focus on quality and client satisfaction.