About
Data Analyst with 1.5+ years of experience in sales and operational analytics using SQL, Power BI, and Python. Skilled in cleaning 350K+ transactional records, designing star schema models, and developing KPI dashboards for revenue, margin, and customer performance. Proven collaborator with cross-functional teams, translating business requirements into scalable reports and ad-hoc analysis that drive data-driven decisions.
Skills & Expertise (43)
Work Experience
Data Analyst – Intern
AdlerNio Pvt Ltd
Jul 2024 - May 2025
Supported ETL processes including data extraction, cleaning, and transformation using SQL and Python (Pandas), preparing datasets for downstream analysis. Conducted exploratory data analysis (EDA) to identify trends, outliers, and anomalies in sales and operational datasets, presenting findings to the analytics team. Built and maintained standardized KPI reports to improve reporting consistency, reducing manual effort in recurring data validation tasks. Participated in Agile sprint planning and daily stand-ups, managing task prioritization and timely delivery of analysis requests.
Data Analyst
AdlerNio Pvt Ltd
Aug 2025 - Present
Cleaned and validated 350K+ sales records using SQL and Power Query, ensuring accurate revenue and margin reporting across business units. Designed and implemented a star schema data model (Fact: Orders; Dimensions: Customers, Products, Returns) to support scalable and consistent BI reporting. Developed Power BI dashboards used in monthly business reviews to monitor revenue trends, order growth, margin %, and customer KPIs for senior stakeholders. Created DAX measures for MoM revenue growth, monthly comparisons, and customer segmentation analysis to enable performance benchmarking. Automated data refresh and improved dashboard performance by optimizing SQL queries and removing redundant Power Query transformations. Validated data accuracy by reconciling reports with source systems, identifying and resolving discrepancies to maintain reporting integrity. Delivered ad-hoc analysis by writing optimized SQL queries and structured performance reports, enabling data-driven decisions for business stakeholders. Collaborated with cross-functional teams (sales, operations, finance) to gather business requirements and translate them into scalable reporting solutions, maintaining clear documentation of data definitions and KPI logic.
Education
Bachelor of Engineering in Information Technology - KBT College of Engineering
2021 - 2025 · Afghanistan
