Gagandeep Kaur

Gagandeep Kaur

Azure Data Engineer
Canada
Panjabi (Punjabi), English, Hindi

About Me

Data professional with 8+ years of IT experience, including 5 years in Data Analytics. Skilled in building end-to-end data pipelines using Azure Data Factory, Azure SQL, and Power BI, with expertise in data modeling, ETL…

Experience

Data Analyst

Meridian Credit Union · Mississauga , Ontario , Canada
Jun 2021 - Apr 2023 · 1 year 10 months

Worked across complete SDLC phases: requirements analysis, solution design, development, testing, deployment, and support. Gathered and analyzed data from multiple systems to support risk reporting and operational decision-making. Conducted report validation and quality assurance to ensure consistency and accuracy. Collaborated with Risk and Business teams to define KPIs and reporting requirements. Designed and developed interactive Power BI dashboards for Loan Risk, Deposit Analysis, and Client Segmentation. Built optimized Snowflake data models with fact and dimension tables. Developed complex DAX measures, calculated columns, and time-intelligence functions. Connected Power BI to Azure SQL Database and configured scheduled refresh in Power BI Service. Partnered with Azure Data Engineers to validate full load and incremental (watermark-based) load pipelines. Worked with Azure Data Factory (ADF) pipelines for data ingestion from heterogeneous sources. Utilized AutoResolve Integration Runtime for cloud-based data movement and transformation. Supported ingestion from on-premises SQL Server using Self-Hosted Integration Runtime (SHIR). Validated data quality including duplicate handling, null checks, and reconciliation. Implements Azure RBAC for secure data access. Participated in system testing and supported UAT sign-off with business stakeholders. Optimized Power BI performance by improving model relationships and reducing data cardinality. Published and maintained reports in production and provided ongoing support. Participated in Agile ceremonies including sprint planning, backlog grooming, and retrospectives.

Integration Developer

Ark Infotech Services · Ludhiana , Punjab , India
Aug 2015 - Jun 2019 · 3 years 10 months

Integrated data from attendance, HR, and payroll systems into a centralized database. Developed SQL queries and ETL workflows to extract, transform, and load data. Performed data cleaning, validation, and deduplication to ensure data accuracy. Mapped source data fields to target system and applied required transformations. Implemented basic error handling, logging, and monitoring for data pipelines. Resolved data discrepancies between source and target systems. Supported data validation and testing during system updates. Collaborated with business users to understand requirements and deliver solutions. Documented data flows, mappings, and processes for future use.

Web Developer Intern (PHP Developer)

IT Gurukul — Ludhiana, India · Ludhiana , Punjab , India
Jan 2015 - Jun 2015 · 5 months

Developed an Online Mock Testing web application using PHP, MySQL, HTML, CSS, and JavaScript. Built backend database connectivity and implemented data validation. Assisted in debugging and improving application performance.

Azure BI developer

Meditech
Apr 2023

Designed and implemented end-to-end automated data pipelines in Azure Data Factory.
Integrated healthcare data from EHR, Billing, HR, PMS, and Finance systems.
Configured AutoResolve Integration Runtime for cloud ingestion and Self-Hosted IR for on-prem connectivity.
Built watermark-based delta incremental load framework to replace full loads.
Developed staging, transformation, and curated layers in Azure SQL Database.
Created MERGE stored procedures and post-load watermark update procedures.
Designed Snowflake data models for reporting and analytics.
Developed interactive Power BI dashboards for executive and operational reporting.
Created complex DAX measures and time intelligence calculations.
Implemented Row-Level Security (RLS) and Azure RBAC for secure data access.
Optimized pipeline and report performance to improve refresh efficiency.
Performed data quality assurance checks including validation, reconciliation, duplicate detection, and exception reporting.
Created and maintained reporting documentation and process guidelines.
Supported SDLC lifecycle including requirements, development, testing, deployment, and support.
Led and supported User Acceptance Testing (UAT) and business sign-off.
Participated in Agile ceremonies (sprint planning, stand-ups, retrospectives).
Established monitoring, alerting, and production support processes.
Collaborated with cross-functional teams including architects, SMEs, and business users.

Skills

Azure Data Factory Azure SQL Power BI Data Modeling ETL ELT Incremental Loading DAX KPI Development Dashboard Optimization Azure SQL Database Data Profiling AutoResolve Integration Runtime Self-Hosted Integration Runtime (SHIR) Stored Procedures MERGE Star Schema Snowflake Schema Semantic Modeling Microsoft Fabric Lakehouse Data Warehouse Dataflows Gen2 Prompt Engineering AI Tools Cloud Data Warehousing Analytics Engineering Agile JIRA UAT Data Validation Reconciliation Stakeholder Collaboration Azure RBAC Row-Level Security (RLS) SQL Power BI Service Snowflake Calculated Columns Time Intelligence SQL Server PHP MySQL HTML CSS JavaScript
Report this Profile?