About
Data Analyst with 1+ year hands-on experience in Advanced Excel, SQL, Power BI, Tableau. Strong expertise in writing complex SQL queries, utilizing Advanced Excel functions, performing data cleaning using Power Query and building interactive Power BI dashboards with DAX that boosted operational efficiency of banks and airlines by 25% and improved match performance of football teams by 30%. Experienced in delivering actionable insights across banking, aviation, and sports analytics domains. Seeking a data related role where I can leverage my expertise to support organizations with data-driven decision making.
Skills & Expertise (30)
Work Experience
Project Management Officer (Intern)
Srushty Global Solutions
Sep 2019 - Nov 2019
Managed more than 8 existing organization projects with the support of 25 people across various departments, ensuring timely completion for more than 75% of the projects. Company provides Engineering design services and Manufacturing Engineering products.
Football Analyst Intern
StepOut Play
Oct 2022 - Aug 2023
Transformed raw video footage from 70+ football matches into detailed actionable insights, through automated dashboards, on opponent strategies and tactical inefficiencies that directly enhanced coaching decisions. Improved the scouting performance of teams by 25% by providing player related data-driven insights, resulting in superior recruitment. Recommended performance related data driven insights through interactive Dashboards to NEROCA FC for 2022-23 I-League season which increased their winning percentage by 30%.
Business Analyst
Aristocrat IT Solutions
Nov 2017 - Nov 2018
Negotiated with Phd Scholars and Guides to generate sales revenue of more than 10 Lakhs in 1 year converting more than 50 Research Scholars in the process, ensuring customer satisfaction and retention.
Business Analyst
Deepija Telecom Private Limited
Mar 2021 - Nov 2021
Served as the primary liaison between the Client and the developer. Gathered and analyzed the client requirements, translating complex requirements into actionable tasks. Assigned workflows to the developer, achieving on-time delivery for more than 40+ customization projects consequently ensuring client satisfaction.
Data Analyst Intern
AI Variant
Feb 2024 - Aug 2024
Optimized the credit lending process of Banks and increased the operational efficiency of airlines by analyzing large datasets of 39,000 rows (Bank Loan Project) and 5.8 million rows (Aviation Analytics Project) using Advanced Excel, SQL, Power BI and Tableau. Utilized SQL, Excel and Power Query for complex ETL operations, including data cleaning and transformation improving dashboard accuracy by 30% enabling better decision making by stakeholders. Transformed raw complex data into clear, intuitive dashboards and KPIs which reduced bad loans(Bank Loan Project) and reduced flight delays(Aviation Project). Provided actionable insights to stakeholders which increased the payment collections by 25% in Bank Loan Analytics project and reduce the arrival delays/cancellations by 30% in Aviation Analytics Project.
Education
MBA (Marketing) - PSG Institute of Management
- 2017 · Afghanistan
B.E (Mechanical Engineering) - St. Joseph’s College of Engineering
- 2014 · Afghanistan
Certifications
Data Analyst Course
ExcelR · 2024
Advanced Analytics Football Masterclass
Mad About Sports · 2022
Football Analytics Using Python Workshop
Mad About Sports · 2022
Business Analyst Training Course
COEPD, Chennai · 2020
