Hi, I'm Mohan
Azure Data Engineer | Microsoft Fabric | Lakehouse | BI
Azure Data Engineer with around 5 years of experience across SQL Server, SSIS, SSRS, Power BI, Azure Databricks, PySpark, Spark SQL, Azure SQL and Microsoft Fabric. Focused on Fabric-first lakehouse development, ETL/ELT pipelines, SQL-to-notebook migration, data warehousing, governance-aware delivery and analytics-ready data products.
Fabric-first Data Engineering
Building clean pipelines, lakehouse-ready datasets, BI reporting layers and validated data products for business users.
Profile
Based in Dublin, Ireland. MSc Artificial Intelligence for Business at National College of Ireland. Professional background includes Cognizant healthcare and finance data platforms, with earlier BI project delivery at Sharp Digital.
I have worked closely with senior architects, analysts, testers, SMEs and client stakeholders on migration, reconciliation, UAT validation, release evidence and multi-environment delivery.
Core Skills
Professional Experience
Fabric, Azure, Databricks, MSBI, Power BI, migration, validation and production release experience across healthcare and finance platforms.
Optum Finance / UnitedHealth Group
Associate Engineer @ Cognizant | Jul 2024 - Dec 2024
Delivered Microsoft Fabric and Azure modernisation work by migrating legacy SQL reporting logic into Microsoft Fabric notebook patterns and Azure Databricks notebooks.
- Engineered scalable ETL/ELT pipelines using Microsoft Fabric Lakehouse patterns, Azure Databricks and PySpark to ingest, transform and validate finance datasets.
- Migrated 50+ SQL scripts into parameterised notebook-based workflows aligned with lakehouse-ready processing, audit columns and curated reporting layers.
- Designed reusable PySpark transformations across 20+ datasets covering schema alignment, deduplication, null handling, data quality rules and row-count validation.
- Improved pipeline execution by 25% through Spark SQL refactoring, partition-aware logic and notebook parameterisation.
- Delivered curated finance datasets and Power BI reporting layers for 10+ KPIs, reducing recurring manual Excel preparation by approximately 30%.
CareSource BI Reporting 2.0
Associate Engineer @ Cognizant | Oct 2023 - Jun 2024
Delivered a 2-month cloud migration and modernisation POC from on-premises SSIS/SSRS to Azure Databricks and Power BI, improving report performance and supporting client sign-off.
- Re-engineered legacy SSIS control-flow and data-flow logic into modular Databricks SQL and PySpark ETL/ELT pipelines.
- Reconciled 10M+ records between SQL Server, SSIS outputs and Databricks datasets using row counts, aggregate checks, exception reports and source-to-target mapping.
- Rebuilt 15+ SSIS/SSRS workflows as cloud-ready Databricks pipelines while maintaining HIPAA-aware handling, validation discipline and governance-focused documentation.
- Supported version-controlled delivery through Git/TFS, release notes, deployment evidence, defect tracking and multi-environment validation.
CareSource Reporting
Programmer Analyst @ Cognizant | Nov 2021 - Sep 2023
Built and supported SQL Server, SSIS and SSRS reporting workloads for healthcare finance, claims, provider and member reporting.
- Developed 20+ T-SQL objects including stored procedures, views, functions, indexed views, triggers and constraints.
- Built and supported 120+ SSIS workloads integrating SQL Server, flat files, Excel, ODBC and OLE DB sources.
- Optimized average query performance by 20% through execution-plan review, index tuning, join rework and stored procedure refactoring.
- Supported 200+ report and ETL releases across DEV, INT, CRT, UAT, EUAT, PRE-PROD and PROD with zero P1 incidents.
Sharp Digital
Software Engineer - Business Intelligence | Jan 2020 - Oct 2021
Delivered BI client projects using Power BI, SSRS, SQL Server and SSIS.
- Built 8 Power BI and SSRS reporting outputs using slicers, matrix visuals, KPIs, drill-down views, drill-through navigation, parameters and expressions.
- Developed 25+ SQL scripts and database objects using joins, subqueries, views, stored procedures, functions, indexes and ranking functions.
- Created and maintained 12+ SSIS packages using Lookup, Merge Join, Conditional Split, Derived Column, Aggregate, Sort, Union All, OLE DB and Execute SQL Task components.
Selected Projects
Academic and portfolio projects focused on Fabric, lakehouse ETL, automation, optimisation and applied AI.
Medallion ETL Flow
Designed an end-to-end ETL flow from CORDIS API/ZIP extracts into Landing, Bronze, Silver and Gold layers with schema cleaning, deduplication, audit checks and curated outputs.
Read BlogHybrid ML-ACO Route Optimisation
Developed a routing model using the LaDe dataset with 1.4M+ delivery trajectories. KNN-ACO achieved a 2.46 km best route and 68.46% Hit Rate @ Top 3 across 30 test routes.
Student Leap Card Automation
Built a UiPath proof-of-concept for student Leap Card triage using OCR extraction, rule checks, CSV audit reports and email notifications.
Power BI Reporting Layers
Delivered curated datasets and Power BI reporting layers for finance KPIs, reducing recurring manual Excel preparation and improving stakeholder reporting speed.
Migration Reconciliation
Validated large-scale migrations using source-to-target mapping, row counts, aggregate checks, exception reports, UAT evidence and release validation across environments.
Let's Connect
Open to immediate Data Engineering, Microsoft Fabric, Azure Data Engineering, BI and analytics roles in Ireland.