Saranya John Sathish

Working within the Data & Analytics team, delivering enterprise reporting, analytics, and Azure data platform solutions supporting operational and strategic decision-making across the University.

Key Achievements

• Developed, enhanced, and supported more than 50 Power BI reports and dashboards across multiple business areas.
• Supported over 200 business users through report enhancements, troubleshooting, training, and user adoption activities.
• Delivered Power BI training sessions and reporting guidance to business stakeholders.
• Mentored apprentice and junior technical resources, supporting their technical development and onboarding.
• Contributed to reporting governance, deployment standards, and Power BI best practices.
• Worked extensively with Microsoft Fabric, Power BI, Azure Data Factory, SQL Server, Azure Data Lake, and Azure Synapse Analytics.

Student Journey Transformation Programme (SJTP)

A major University transformation programme replacing legacy student systems and reporting solutions.

Responsibilities:

• Developed over 30 Power BI reports supporting operational and strategic decision-making.
• Designed semantic models, DAX calculations, KPIs, and interactive dashboards.
• Gathered reporting requirements from stakeholders and translated them into business-focused reporting solutions.
• Managed deployments using Power BI Deployment Pipelines across Development, Test, and Production environments.
• Supported testing activities, UAT sign-off, and production releases.
• Produced user guidance, technical documentation, and support materials.

PICS Apprenticeship Reporting Solution

Designed and implemented an automated Azure-based reporting solution for Apprenticeship reporting data.

Responsibilities:

• Developed Azure Data Factory pipelines to automate ingestion and processing of daily Excel file submissions.
• Implemented data validation, schema checks, duplicate detection, and automated failure notifications.
• Built Power BI reporting solutions and Data Marts to support operational reporting requirements.
• Improved reporting reliability, governance, and accessibility of apprenticeship data.
• Reduced manual reporting effort by approximately 4–5 hours per week.

Enterprise Data Integration & Reporting Platform (SSLive)

Designed and developed Azure Data Factory pipelines to automate the movement of Oracle data into a central SQL Data Warehouse.

Responsibilities:

• Developed scalable ETL pipelines supporting full-load and incremental-load processing.
• Implemented watermark-based incremental loading frameworks.
• Developed SQL Stored Procedures and transformation logic supporting enterprise reporting requirements.
• Implemented monitoring, validation, logging, and automated alerting processes.
• Worked closely with reporting teams and stakeholders to support reporting enhancements and data quality improvements.

• Designed and developed Azure Data Factory pipelines supporting migration of business-critical applications and reporting data.
• Developed ETL processes to support business reporting and operational analytics.
• Designed and implemented ETL solutions loading data from multiple source systems into reporting environments.
• Built Azure SQL Data Mart solutions using dimensional modelling and star schema principles.
• Implemented monitoring, logging, and automated alerting solutions using Azure Logic Apps.
• Developed Databricks notebooks and data quality validation processes.
• Created SSIS packages to automate data integration and enhance reporting processes.
• Contributed to large-scale Azure data platform and reporting initiatives facilitating ASDA's separation from Walmart and migration to ASDA-owned Azure services.
• Collaborated with Data Governance, DevOps, and business teams to support secure and reliable data delivery.
• Participated in Agile delivery processes including sprint planning, reviews, retrospectives, and backlog management.
• Performed data validation, reconciliation, and troubleshooting activities.
• Supported business reporting requirements and delivery commitments.
• Developed technical documentation and operational support materials to ensure knowledge transfer and support for users.
• United Kingdom

• Designed and developed enterprise Power BI reports and dashboards.
• Developed Power BI and SQL-based reporting solutions for retail clients, enhancing data visibility and decision-making for Spencer's Retail and More Retail.
• Developed DAX calculations, KPIs, and business measures.
• Created dimensional models and star schema solutions supporting analytics and reporting.
• Developed sales, inventory, and operational performance dashboards.
• Worked directly with business users to gather requirements and deliver reporting solutions.
• Trained business users on Power BI reporting capabilities and best practices.
• Implemented Row-Level Security (RLS) and data governance controls.
• Implemented incremental refresh techniques reducing refresh duration to approximately 20 minutes.
• Created master reporting model, reducing refresh times by approximately 9 hours, streamlining data processing and reporting efficiency.
• Built SSIS packages to integrate Oracle and SQL Server data.
• Implemented automation improvements, achieving significant operational efficiencies and reducing manual workload.
• Contributed to projects in India, collaborating with local teams to enhance reporting solutions.
• Received recognition for training and supporting business users.