Ahmed Ali
Data Analyst
About
No bio added yet
Skills & Expertise (17)
Work Experience
MIS Executive
Pikpart Spare
Present - Present
Designed and implemented 20+ MIS solutions, dashboards and automation systems using Google Sheets, Google App Script, and Advanced Excel to streamline inventory, procurement, order management and reporting processes. Developed and automated Inventory Management, Current Stock, Top Moving Stock, Parts Requirement, Purchase Order, Engine Oil, Monthly Tracker, and Inventory Summary dashboards, enabling real-time business insights and data-driven decision-making. Build custom business applications and automation tools, including PI Builder, CSV Generator, Vehicle Tracking System, MRP & Supplier Price Comparison tools, reducing manual effort, improving data accuracy, and increasing operational efficiency. Automated end-to-end workflows such as completed row archiving, report generation and sharing, inventory updates, procurement tracking, and validation processes, significantly reducing manual intervention and turnaround time. Collaborated with Operations, Procurement, Warehouse, and Management teams to gather business requirements, optimize workflows, and deliver scalable MIS reports, dashboards, and automation solutions that improved productivity and process transparency.
Process Analyst – Healthcare BI
Provana India Pvt. Ltd.
Present - Present
Designed and implemented an automated data validation framework to enforce file naming standards, schema checks, header validation, date-range verification, and row count reconciliation before reporting. Developed ETL automation scripts to manage Azure data pipelines, including archiving historical files and routing validated datasets to structured destination folders. Built automated data consolidation workflows to merge multisheet files from SharePoint, generate standardized output datasets, and deploy them to Azure storage. Enhanced report performance by optimising DAX queries, refining data models, and implementing best practices for measure design, resulting in faster dashboard refresh and improved user experience.
MIS Analyst
Data Solution India
Present - Present
Built clinic-wise performance dashboards to track 90+ AR metrics and identify high-risk accounts. Designed automated incentive calculation models based on team performance and individual contribution. Developed KPI-driven dashboards to monitor loss hours, break time, and user-wise utilization. Delivered team-level analytics reports to improve productivity, efficiency, and performance transparency.
Data Analyst Intern
Softmind Technologies
Present - Present
Completed tasks assigned by a supervisor. Gained technical skills related to the industry. Created dashboards using Power BI.
Education
Bachelor of Computer Application - IGNOU University
2022 - 2025 · Afghanistan
12th with PCM - SBV No 1 Molarband New Delhi
2020 - 2021 · Afghanistan
Master of Computer Application - IGNOU University
- · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Need Sponsorship
Relocation
Open to Relocation
Skills (17)
Click a skill to find developers with the same skill
