About
Data Analyst with over 2 years of experience transforming complex datasets into actionable business intelligence using Python, SQL, and Power BI. Proven track record of designing robust end-to-end ETL pipelines, automating operational workflows, building interactive dashboards and delivering ad-hoc reports that significantly reduce manual reporting effort and drive strategic executive decision-making. Adept at performing rigorous data validation and query optimization to ensure maximum data quality and governance.
Skills & Expertise (22)
Work Experience
Data Analyst
MacTrigon Pvt Ltd
Aug 2024 - Present
Developed 17+ interactive Power BI and Advanced Excel dashboards for 50+ business users, reducing manual reporting effort by 60% and enabling data-driven decision-making across Revenue, AOV, Order Performance, Customer Retention, Seller Performance, Product/Category Trends, Payment Behaviour, and Delivery KPIs. Integrated and transformed data from CSV, Excel, AWS, GCP, Snowflake, and PostgreSQL, performing ETL, data validation, data cleansing, data modelling, and KPI development to deliver scalable business intelligence and automated reporting solutions. Automated daily PostgreSQL ETL/ELT workflows using Python and pgAgent, including data ingestion, staging, validation, incremental loading, and import logging to improve data-processing efficiency and reporting reliability. Analyzed SAP financial transaction data across invoices, payments, vendor/customer transactions, and FI/CO records, performing data validation, reconciliation, discrepancy analysis, and financial reporting support to improve data accuracy. Performed ABC/Pareto, Cohort, RFM, Customer Segmentation, and Trend Analysis across sales, customer, product, and transaction data to identify revenue drivers, high-value customers/products, purchasing patterns, and business growth opportunities.
Business Operations
Turito India Pvt Ltd
Mar 2023 - Mar 2024
Collected, validated, reconciled, and consolidated data from Sales, CRM, Finance, and Operations teams, identifying data discrepancies and maintaining accurate business records for management reporting. Developed and maintained Daily, Weekly, and Monthly MIS reports using Advanced Excel to track sales performance, lead conversion, operational KPIs, and business trends, supporting leadership decision-making. Analyzed sales funnel, customer touchpoints, conversion trends, and pipeline performance to identify revenue growth opportunities and provide actionable insights for operational strategy. Performed data reconciliation, quality checks, Excel-based analysis, and cross-functional reporting to improve data accuracy and ensure timely delivery of business-critical reports.
Education
BBA in Economics - Lovely Professional University
2018 - 2021 ยท Afghanistan
MBA in Data Science (Distance Education) - Lovely Professional University
- 2027 ยท Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (22)
Click a skill to find developers with the same skill