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…
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.
Experience
Data Analyst
<p>Worked across complete SDLC phases: requirements analysis, solution design, development, testing, deployment, and support.</p><p> Gathered and analyzed data from multiple systems to support risk reporting and operational decision-making.</p><p> Conducted report validation and quality assurance to ensure consistency and accuracy.</p><p> Collaborated with Risk and Business teams to define KPIs and reporting requirements.</p><p> Designed and developed interactive Power BI dashboards for Loan Risk, Deposit Analysis, and Client Segmentation.</p><p> Built optimized Snowflake data models with fact and dimension tables.</p><p> Developed complex DAX measures, calculated columns, and time-intelligence functions.</p><p> Connected Power BI to Azure SQL Database and configured scheduled refresh in Power BI Service.</p><p> Partnered with Azure Data Engineers to validate full load and incremental (watermark-based) load pipelines.</p><p> Worked with Azure Data Factory (ADF) pipelines for data ingestion from heterogeneous sources.</p><p> Utilized AutoResolve Integration Runtime for cloud-based data movement and transformation.</p><p> Supported ingestion from on-premises SQL Server using Self-Hosted Integration Runtime (SHIR).</p><p> Validated data quality including duplicate handling, null checks, and reconciliation.</p><p> Implements Azure RBAC for secure data access.</p><p> Participated in system testing and supported UAT sign-off with business stakeholders.</p><p> Optimized Power BI performance by improving model relationships and reducing data cardinality.</p><p> Published and maintained reports in production and provided ongoing support.</p><p> Participated in Agile ceremonies including sprint planning, backlog grooming, and retrospectives.</p>
Integration Developer
<p>Integrated data from attendance, HR, and payroll systems into a centralized database.</p><p> Developed SQL queries and ETL workflows to extract, transform, and load data.</p><p> Performed data cleaning, validation, and deduplication to ensure data accuracy.</p><p> Mapped source data fields to target system and applied required transformations.</p><p> Implemented basic error handling, logging, and monitoring for data pipelines.</p><p> Resolved data discrepancies between source and target systems.</p><p> Supported data validation and testing during system updates.</p><p> Collaborated with business users to understand requirements and deliver solutions.</p><p> Documented data flows, mappings, and processes for future use.</p>
Web Developer Intern (PHP Developer)
<p>Developed an Online Mock Testing web application using PHP, MySQL, HTML, CSS, and JavaScript.</p><p> Built backend database connectivity and implemented data validation.</p><p> Assisted in debugging and improving application performance.</p>
Azure BI developer
<p>Designed and implemented end-to-end automated data pipelines in Azure Data Factory.<br>
Integrated healthcare data from EHR, Billing, HR, PMS, and Finance systems.<br>
Configured AutoResolve Integration Runtime for cloud ingestion and Self-Hosted IR for on-prem connectivity.<br>
Built watermark-based delta incremental load framework to replace full loads.<br>
Developed staging, transformation, and curated layers in Azure SQL Database.<br>
Created MERGE stored procedures and post-load watermark update procedures.<br>
Designed Snowflake data models for reporting and analytics.<br>
Developed interactive Power BI dashboards for executive and operational reporting.<br>
Created complex DAX measures and time intelligence calculations.<br>
Implemented Row-Level Security (RLS) and Azure RBAC for secure data access.<br>
Optimized pipeline and report performance to improve refresh efficiency.<br>
Performed data quality assurance checks including validation, reconciliation, duplicate detection, and exception reporting.<br>
Created and maintained reporting documentation and process guidelines.<br>
Supported SDLC lifecycle including requirements, development, testing, deployment, and support.<br>
Led and supported User Acceptance Testing (UAT) and business sign-off.<br>
Participated in Agile ceremonies (sprint planning, stand-ups, retrospectives).<br>
Established monitoring, alerting, and production support processes.<br>
Collaborated with cross-functional teams including architects, SMEs, and business users.</p>