
Carlos
Excel Specialist, Data Automation, VBA Expert
Compétences

Voir mes services

Expérience professionnelle
Supply chain preparation trainee
Volvo Group • Temps plein
Nov 2025 - May 2026 • 6 mos
Process Automation & Data Validation: Developed and implemented VBA scripts to optimize Excel data entry; integrated data validation mechanisms that accelerated capture time and ensured data integrity. Data Cleaning & Maintenance: Designed advanced VBA macros focused on automated database debugging, cleaning, and maintenance, guaranteeing structural consistency across datasets. System Integration & Operational Tools: Developed a VBA solution to automatically generate personalized Word documents, as well as automate the drafting and sending of emails to multiple recipients.
Supply chain intern
Continental • Temps partiel
Oct 2024 - Oct 2025 • 1 yr
Real-Time KANBAN System (VBA): Designed and implemented an automated system to process real-time QR code scanner readings and execute categorical logic for relational and unit-level tracking; architected dual-update synchronization across floor scans, live visual dashboards, and planning databases. Performance Optimization & Reporting: Programmed advanced VBA scripts to automate the calculation of Days on Hand (DOH) inventory and optimized data structures, achieving a drastic reduction in processing and administrative reporting times. Automation Software & PDF Processing Development (Python): Designed and developed an interactive desktop application in Python for the automated splitting, organization, and archiving of high-volume PDF documents. The tool processes complex digitizations using basic computer vision techniques (PyMuPDF / Pillow) to intelligently detect black separator pages, dynamically extract file metadata, and automatically structure hierarchical directory trees (Year/Month/Day/Company), significantly streamlining the document management workflow.