About
Detail-oriented Data Engineer Analyst with 4.5+ years of experience in delivering data-driven insights, reporting automation, and interactive dashboards across healthcare, banking, and insurance domains. Strong expertise in Power BI, DAX, Data Modeling, Advanced Excel & PowerPoint, ETL (Pentaho), SQL, and Python (Pandas, NumPy). Proven ability to manage enterprise data warehouses, automate reporting pipelines, build KPI dashboards, and translate complex datasets into actionable insights for stakeholders. Passionate about continuous learning and well-prepared to contribute effectively in fast-paced, dynamic environments.
Skills & Expertise (37)
Work Experience
Data Engineer Analyst
Paramount Healthcare Management (Fairfax Asia)
Nov 2022 - Present
Designed and automated end-to-end ETL pipelines and integrate Oracle, IBM AS/400, and MySQL data into PostgreSQL Database, improving data accuracy, consistency, and reliability. Designed data mapping frameworks using unique retention keys and designing structured data flow across multiple relational tables. Performed end-to-end data validation and reconciliation with finance systems, ensuring high data accuracy, consistency, and reporting integrity. Monitored and optimized database and ETL performance, proactively troubleshooting and resolving data pipeline and database issues to ensure high availability and reliability. Conducted exploratory data analysis (EDA) using Python (Pandas, NumPy) to validate source data, identify patterns, and support fact table design, enabling accurate and optimized data modelling. Worked with cross-functional teams to plan, track, and deliver project milestones, ensuring timely completion and high-quality outcomes. Strengthened database governance by implementing indexing standards, naming conventions, and performance optimization controls.
Subject Matter Expert (SME)
Falcon Insurance
Nov 2022 - Dec 2024
Designed and automated end-to-end ETL pipelines using Pentaho PDI, integrating Oracle and flat-file sources into PostgreSQL, improving data accuracy and automation in reporting workflows. Developed financial and underwriting fact tables, implemented monthly, yearly, MTD and YTD performance metrics, and built interactive dashboards to deliver actionable business insights. Designed and optimized PostgreSQL database objects including tables, views, indexes, stored procedures, and functions to support operational and analytical workloads. Gathered business requirements from stakeholders, developed fact tables in PostgreSQL, and built interactive reports in PowerBI. Built scalable and interactive Power BI dashboards with optimized data models and DAX calculations to support business decision-making. Created executive-ready dashboards and presentations using advanced Excel and PowerPoint, delivering clear, actionable business insights. Ensured 100% financial reporting accuracy through end-to-end data validation, reconciliation, and governance controls. Collaborated closely with cross-functional teams, managing project timelines and deliverables to ensure successful, on-time project completion. Managed stakeholder expectations by providing regular project updates, risk assessments, and milestone tracking via JIRA.
Assistant Manager Business Intelligence Unit
Kotak Mahindra Bank
May 2022 - Nov 2022
Collaborated with campaign managers to understand business goals and translate them into executable workflows. Designed and executed marketing campaigns using UNICA, Netcore, and Clevertap. Developed and tested SQL-driven segmentation logic for targeted marketing campaigns. Ensured campaign quality via end-to-end validation & reconciliation checks before launch.
Project Engineer
Fairfirst Insurance
Jan 2025 - Present
Designed and automated end-to-end ETL pipelines and integrate Oracle, IBM AS/400, and MySQL data into PostgreSQL Database, improving data accuracy, consistency, and reliability. Designed data mapping frameworks using unique retention keys and designing structured data flow across multiple relational tables. Performed end-to-end data validation and reconciliation with finance systems, ensuring high data accuracy, consistency, and reporting integrity. Monitored and optimized database and ETL performance, proactively troubleshooting and resolving data pipeline and database issues to ensure high availability and reliability. Conducted exploratory data analysis (EDA) using Python (Pandas, NumPy) to validate source data, identify patterns, and support fact table design, enabling accurate and optimized data modelling. Worked with cross-functional teams to plan, track, and deliver project milestones, ensuring timely completion and high-quality outcomes. Strengthened database governance by implementing indexing standards, naming conventions, and performance optimization controls.
Data Analyst
Pragmatic Intelligence & Analytics
Apr 2021 - May 2022
Interacted directly with client stakeholders to gather reporting requirements and convert them into functional ETL and BI solutions. Built ETL pipelines using Pentaho PDI for end-to-end data integration and automated data loading workflows. Developed cross-database integration ETL to extract data from Oracle and load into PostgreSQL, improving reporting efficiency. Analysed and understood detailed reporting requirement specifications shared by clients to develop accurate BI solutions. Developed and optimized SQL queries in Oracle SQL Developer and PostgreSQL to support reporting and analytics workflows with the proper reconciliation. Designed, modified, and enhanced client reports using JasperReports / iReport and Power BI, ensuring pixel-perfect layouts and business logic accuracy. Improved data reliability by 30% through implementation of data governance controls and automated reconciliation checks.
Education
B.E. (Information Technology) - Vidyalankar Institute of Technology (VIT)
- 2020 · Afghanistan
Diploma (Information Technology) - Shah & Anchor Kutchhi Polytechnic
- 2017 · Afghanistan
SSC Board - Saraswati High school
- 2014 · Afghanistan
Certifications
Databricks Fundamentals Accreditation
Databricks · 2026
Generative AI for Data Analysts & Professionals
Udemy · 2026
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (37)
Click a skill to find developers with the same skill
