Parcourir les catégories
Explorer
Fiverr Pro
Français
$
USD
Steeven
@mrredd_
Excel Automation Architect, VBA and Power Query Specialist, BI Dashboards
Cameroun
Français, Anglais
À propos de moi
Most businesses are drowning in data but starving for insights. I specialize in transforming fragmented, manual Excel files into high-performance, automated "Command Centers" that run your business on autopilot.
Whether it’s a complex Financial Model, a real-time Sales Dashboard, or a custom VBA tool that replaces hours of manual entry with a single click, I build systems that are scalable, error-proof, and visually stunning.
Why work with Me?
-Clean Architecture
-Power Query First
-User-Centric Design
Compétences
Steeven
hors ligne •
Temps de réponse moyen de 419 heures
Voir mes services
Tableaux de bord des données
I will design an automated excel dashboard with power query and vba
Formules & Macros
I will automate your excel work with vba macros, formulas, and dashboards
Expérience professionnelle
Lead Excel Automation & Business Intelligence Consultant
DataCamp • Indépendant
Dec 2019 - Present • 6 yrs 6 mos
Senior-level consultant specializing in end-to-end workflow automation for SMEs and Fortune 500 departments. I architect custom Excel-based ecosystems that eliminate manual data entry and provide real-time executive insights. Key Achievements: -Automated Reporting: Engineered a Power Query-driven financial engine for a $50M retail firm, reducing monthly reporting time from 3 days to 15 minutes. -VBA Systems: Developed custom "Command Center" tools with complex UserForms and VBA logic to manage inventory across multiple warehouse locations. -Dashboard Design: Designed high-impact KPI dashboards using Power Pivot and DAX to visualize multi-source data (Shopify, QuickBooks, and SQL). Client Impact: Saved an average of 20+ hours of manual labor per week for long-term contract clients through systematic process optimization.
Senior Data Analyst & Spreadsheet Architect
IntelligIS • Temps plein
Jan 2012 - Dec 2020 • 8 yrs 11 mos
Focused on the structural integrity of complex datasets and the development of robust financial models. This role was dedicated to mastering the technical core of Excel—from legacy VBA to the modern "M" language in Power Query. Key Achievements: -Data Integrity: Audited and repaired "broken" legacy spreadsheets containing 50,000+ rows, implementing advanced error-trapping and data validation. -Financial Modeling: Built 5-year rolling forecast models with sensitivity analysis (What-If scenarios) for project stakeholders and investors. -Optimization: Refined existing workbook calculation speeds by 60% by replacing volatile formulas with efficient Index-Match and Array logic. Training: Conducted internal workshops for staff on spreadsheet best practices and advanced lookup functions to improve company-wide data literacy.
