Kategorien durchsuchen
Entdecken
Fiverr Pro
Deutsch
$
USD
Zeeshan Ashraf
@zee_analyst
Excel Automation Specialist : Power Query, VBA and Dashboards
Pakistan
Englisch, Urdu, Hindi
Über mich
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.
Kompetenzen
Zeeshan Ashraf
offline •
Durchschnittliche Antwortzeit: 1 Stunde
Meine Dienstleistungen
Automatisierungen
I will convert PDF into excel using power query automation
Automatisierungen
I will clean, transform and merge your excel data using power query
Portfolio
Arbeitserfahrung
Pakistan International Airlines
Vollzeit • 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.
