z
zee_analyst

Zeeshan Ashraf

@zee_analyst

Excel Automation Specialist : Power Query, VBA and Dashboards

Pakistan
English, Urdu, Hindi
About me
With 6+ years in supply chain and operations, I solve real data problems — messy spreadsheets, manual reporting, and dashboards that don't drive decisions. I specialize in Excel automation, Power Query, and Power BI dashboards that save time, reduce errors, and are easy to maintain. I offer services in Data cleaning, Extraction & Formatting, Excel automation, KPI dashboards, Power Query, Advanced formulas & Pivots and Operational reporting. Your data should work for you — let's make that happen.... Read more

Skills

z
zee_analyst
Zeeshan Ashraf
Offline • 
Average response time: 1 hour

See my services

Automations
I will convert PDF into excel using power query automation
From$10 / projectMore details
Automations
I will clean, transform and merge your excel data using power query
From$15 / projectMore details

Portfolio

Work experience

Pakistan_International Airlines

Pakistan International Airlines

Full-time • 6 yrs 8 mos

Supply Chain & Operations Manager

May 2022 - Present • 4 yrs 3 mos

Managed end-to-end supply chain analytics and reporting for 60,000+ aviation spare parts, supporting procurement planning, repair cycle tracking, and stock optimization across a complex, high-availability operation. Built dynamic Excel dashboards and KPI reports tracking inventory levels, procurement status, repair progress, and operational performance — used directly by management for decision-making. Automated data preparation and multi-source reporting workflows using Power Query, significantly reducing manual effort and improving reporting turnaround. Performed demand forecasting, usage trend analysis, and stock level optimization to maintain 100% parts availability for active aircraft operations. Developed advanced Excel solutions — Pivot Tables, XLOOKUP, dynamic arrays, and conditional formatting — to improve reporting accuracy and reduce dependency on manual processes. Coordinated with international vendors, OEMs, and US Government FMS programs, maintaining data accuracy and documentation compliance across procurement and repair cycles.

Warehousing & Inventory Manager

Nov 2019 - Apr 2022 • 2 yrs 5 mos

Designed and implemented Excel-based inventory management and reporting systems for 40,000+ SKUs across aviation and weapon system inventories, achieving 98% fulfillment effectiveness throughout. Built inventory tracking and reporting tools using Power Query, Pivot Tables, XLOOKUP, and dynamic formulas — improving stock visibility, reducing manual errors, and enabling real-time inventory monitoring. Performed demand, consumption, and trend analysis to identify slow-moving and dormant stock, contributing to a 20% reduction in inactive inventory. Developed interactive dashboards and KPI reports monitoring stock levels, issue effectiveness, stock movements, and warehouse performance for operational and management use. Automated data consolidation workflows across multiple data sources, reducing manual reporting effort and improving accuracy and speed of inventory reporting. Led implementation of an Automated Inventory Management System, increasing inventory accuracy and reducing dependency on manual tracking processes.