m
mrnaineo

Erick Ruiz

@mrnaineo

Mechatronics Engineer Excel VBA and Automation Expert

Mexique
Anglais, Espagnol
Certaines informations sont présentées en anglais.
À propos de moi
Mechatronics Engineer | Excel VBA & Automation Expert I am a Mechatronics Engineer specializing in process optimization. I turn complex, manual spreadsheets into fast, automated tools using Excel VBA, Power Query, and dynamic dashboards. Services: VBA Automation: Streamline repetitive tasks. KPI Dashboards: Dynamic visual tools. Power Query: Data cleaning & file merging. UserForms: Custom inputs & file speed optimization. Engineering precision, bilingual support (EN/ES), and clean code. Let's optimize your workflow!... Plus d’infos

Compétences

m
mrnaineo
Erick Ruiz
hors ligne • 
Temps de réponse moyen de 1 heure

Voir mes services

Formules & Macros
I will advanced excel vba macros, automation, and dashboards
De5 $US / projetPlus de détails

Expérience professionnelle

Optibelt_GmbH

Quality Laboratory Engineer

Optibelt GmbH • Temps plein

Apr 2023 - Present • 3 yrs 5 mos

Automated Reporting Systems: Engineered advanced Excel VBA automation modules and dynamic dashboards to process complex laboratory testing data, reducing manual reporting time and generating automated weekly/monthly KPI analytics. Data Integration & Analytics: Implemented Power Query workflows for SAP data extraction, cleaning, and consolidation to track quality documentation (QM/ISO standards) and department workload metrics. Process Optimization: Designed mechanical process improvements—including custom tooling for production calenders—and developed Power Apps prototypes for internal project tracking.

Hanon_Systems

PPAP Administrator & Metrology Supervisor

Hanon Systems • Temps plein

Jan 2019 - Apr 2023 • 4 yrs 3 mos

PPAP & Core Tools Management: Supervised the Production Part Approval Process for new product launches, applying Automotive Core Tools (SPC, MSA, FMEA, PPAP) to ensure compliance with strict industry standards. Quality Assurance & Auditing: Led root-cause analysis and problem-solving initiatives using 8D methodology and VDA 6.3 standards to maintain low defect rates during product rollouts. Automotive OEM Approvals: Programmed 3D CMM equipment (PC-DMIS CAD++, Romer Arm, OPTIV optical systems) and conducted GD&T first-piece inspections, securing new project measurement approvals for Tier-1 OEMs including Volkswagen, Mazda, Mercedes-Benz, and Ford. Laboratory Operations: Managed daily operations for metrology and testing labs, overseeing calibration schedules, vendor relations, and destructive testing protocols (tensile, burst, and technical cleanliness).