Ishtiaque K.

Excel VBA Automation Expert | Power BI Developer | Python Data Analyst

With 8+ years specializing in data analysis and business intelligence (15+ years total professional experience), I help businesses turn manual, error-prone processes into automated, reliable reporting systems — using advanced Excel, Power BI, Python, and SQL. What I bring: ✅ Advanced Excel — Pivot Tables, Power Query, Power Pivot, complex formulas, VBA/Macro automation ✅ Power BI dashboard development — KPI tracking, performance & revenue reporting ✅ Python for data processing, automation pipelines, and Excel/database integration ✅ SQL (PostgreSQL, MySQL, SQL Server, SQLite) and Microsoft Access for structured data work ✅ Google Sheets + Apps Script automation Track record: Automated reporting workflows, cutting manual effort by up to 85% Processed and validated datasets with 10M+ records Delivered 50+ interactive dashboards for operational and financial reporting Completed 150+ analytics/automation projects across logistics, finance, sales, inventory, and government sectors Recent examples of my work: building a fully automated visitor management system in Excel/VBA with a live dashboard, running recurring invoice reconciliation and shipment analytics automation for a logistics company (SMSA Express, Riyadh), and developing a Python-based fuzzy-matching data classification pipeline with confidence scoring. I focus on solutions your team can actually maintain — clear documentation, clean structure, no black boxes. 100% Job Success, Top Rated, 80 plus (out of 112 completed jobs) five-star reviews. Have a manual process that's outgrown Excel, a dashboard that needs to actually drive decisions, or a dataset too large/messy for spreadsheets alone? Let's talk. 1. Custom Automated Visitor Management System (Excel VBA + Dashboard): Built a fully automated visitor management system in Excel using VBA — replacing manual sign-in logs with a tool that auto-updates a live dashboard. Eliminated data entry errors and cut admin time for the client's front-desk process. 2. MS Excel-Based Inventory & Accounting System: Designed a complete inventory management and accounting application inside Excel, combining VBA automation with structured data validation — giving the client a lightweight, budget-friendly alternative to dedicated inventory software. 3. RCTI Automation System (repeat client, multiple contracts 2025–2026) Built and maintained an automated RCTI (Recipient Created Tax Invoice) generation system, including sample-based testing and ongoing feature extensions. Long-term repeat engagement — client returned for further automation work across multiple contracts. 4. Generic-to-Specific Data Classification with Fuzzy Matching (Python) Designed a Python-based data-matching pipeline using fuzzy matching and confidence scoring to automatically classify generic product/data entries into specific categories — reducing manual classification work on a large dataset. 5. Logistics Invoice Reconciliation & KPI Dashboard (SMSA Express, Riyadh) Built Excel/VBA-based automation for invoice reconciliation and shipment analytics, plus a Power BI dashboard tracking performance and revenue KPIs — supporting operational decision-making for a regional logistics provider. Skillset includes: Microsoft Excel · Excel VBA · Macro Programming · Power Query · Automation · Data Analysis · Microsoft Power BI Data Visualization · Python · SQL · Data Visualization · Data Cleaning · Financial Modeling · Google Sheets · Spreadsheet Software · File Conversion