Ver categorias
Explorar
Fiverr Pro
Português
$
USD
Steeven
@mrredd_
Excel Automation Architect, VBA and Power Query Specialist, BI Dashboards
Camarões
Francês, Inglês
Sobre mim
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
Habilidades
Steeven
offline •
Tempo médio de resposta: 419 horas
Conheça meus serviços
Painéis de dados
I will design an automated excel dashboard with power query and vba
Fórmulas e Macros
I will automate your excel work with vba macros, formulas, and dashboards
Experiência profissional
Lead Excel Automation & Business Intelligence Consultant
DataCamp • Autônomo
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 • Período integral
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.
