About
Results-driven BI Developer / Data Analyst with 2+ years of experience in SQL development, Power BI, and ETL/data engineering. Skilled in designing and optimizing data pipelines, building scalable data models (star and snowflake schemas), and developing interactive dashboards to deliver actionable business insights. Proficient in advanced SQL (CTEs, stored procedures, query optimization), DAX, and Power Query, with hands-on experience in ETL development using SSIS and Azure Data Factory, including incremental data loading and data integration from multiple sources. Strong understanding of data warehousing concepts such as SCD Type 2, dimensional modeling (fact and dimension tables), and data validation techniques to ensure data quality and consistency. Experienced in handling large datasets, performing data profiling, and delivering KPI-driven reporting solutions. Adept at stakeholder collaboration, requirement gathering, and working in Agile environments, with a continuous focus on improving performance, scalability, and data-driven decision-making.
Skills & Expertise (34)
Work Experience
Business Technology Analyst
Deloitte USI
Sep 2025 - Present
Worked on migrating legacy data to modern systems using SQL and SQLite-based ETL scripts. Handled data mapping, transformation, and validation to ensure accurate migration of historical data. Automated data extraction and transformation steps, reducing manual effort and improving efficiency. Performed reconciliation and quality checks to maintain data integrity during migration. Improved query performance to support faster data retrieval and reporting. Coordinated with development and migration teams to ensure smooth data integration. Contributed to large-scale migration activities while ensuring minimal disruption to business operations.
Junior Data Analyst
Xyenta Solutions Pvt Ltd
May 2023 - Apr 2025
Built data pipelines using SSIS to bring together data from multiple systems into a centralized warehouse. Worked on ETL workflows, improving processing efficiency and supporting both batch and incremental data loads. Tuned complex SQL queries (CTEs, joins, stored procedures) to support reporting and data analysis needs. Improved database performance by applying indexing and query optimization techniques. Designed and maintained data models (Star Schema) with SCD Type 2 to track historical changes. Created SQL objects such as views and stored procedures to simplify data access and transformations. Developed Power BI dashboards using DAX with features like drill-down and KPI tracking to support business decisions. Ensured data accuracy through validation, profiling, and reconciliation checks across multiple datasets. Worked on database design, including ER diagrams, to support efficient data storage and retrieval. Implemented role-based access (RLS) in Power BI to ensure secure and controlled data visibility. Collaborated with business and technical teams to understand requirements & deliver solutions in Agile setup.
Education
Bachelor of Technology (B. Tech) โ ECE - Guru Nanak Institute of Engineering & Technology
2020 - 2023 ยท Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (34)
Click a skill to find developers with the same skill