Jishanth Gopalakrishnan

Designed and deployed a Snowflake-based data infrastructure for digitising laboratory scheduling and resource allocation workflows across multiple operational sites. Developed ETL pipelines, SQL stored procedures, and automation tasks to refresh and prioritise data daily, enhancing reporting accuracy and timeliness. Built Power BI dashboards integrating KPIs, DAX-based scoring, and dynamic slicers to visualise overdue samples, staff workload, and testing turnaround. Collaborated with data architects, BI developers, and AI engineers to translate complex business rules into data-driven algorithms, improving lab efficiency. Delivered a production-ready analytics solution recognised for enabling 60% faster prioritisation and real-time visibility into over 10,000+ samples.

Administered and optimised MS SQL Server databases, ensuring stability and high availability. Designed and deployed ETL pipelines in Azure Data Factory, integrating diverse data sources into consistent workflows. Improved stored procedures and queries, which reduced processing time. Created Power BI dashboards to track KPIs and provide real-time insights for business leaders. Worked directly with stakeholders to gather requirements and deliver accurate, timely reporting solutions.

Supported live SQL databases for Pret A Manger’s retail systems, resolving inconsistencies and improving reliability. Enhanced stored procedures to streamline processing and reduce execution time. Assisted in ETL pipeline development and end-to-end testing to ensure deployment stability.