نبذة عني
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…
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/ELT, and incremental loading frameworks. Strong in DAX, KPI development, and dashboard optimization, delivering scalable, high-performance analytics solutions. Experienced in Agile environments, collaborating with stakeholders to drive data-driven decision-making.
الخبرة
Data Analyst
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
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)
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
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.