Skills & Expertise (17)
Work Experience
Data Analyst
WebMinds IT Solutions
Feb 2022 - Present
Improving efficiency by 40% by using a Python-powered Data Reconciliation System, preventing data loss and engineered ETL pipelines to integrate data from MYSQL, Excel, and third-party applications. Optimized SQL queries for high-performance data retrieval, reducing query execution time by 60%. Designed and automated data cleaning workflows, improving data accuracy. Extracted, transformed, and analyzed large datasets using SQL, Python (Pandas, NumPy) for strategic reporting. Understood the existing architecture of EPICOR ERP and MYSQL data warehousing system, identified required tables and columns, and documented the same. Communicated data-driven findings to stakeholders and senior management, facilitating data-driven decision-making. Designed data models using Power BI Desktop, including calculated columns, measures, and relationships. Optimized Power BI reports by implementing best practices in DAX and data modeling. Developed visualizations including KPI’s, Column Charts, Stacked Charts, Pie Charts, Slicers, Donut Charts, Row Cards, Multi-Row Cards, Line Charts, and Table Reports using DAX Queries.
Education
MBA in Business Analytics and International Business Management - Shri Shivaji Maratha Society’s Institute of Management and Research
- 2024 · Afghanistan
BE in Mechanical Sandwich Engineering - SCES’s Indira College of Engineering and Management
- 2020 · Afghanistan