Open to opportunities

Richi Gomez

@richigomez

I transform raw operational data into actionable business insights through advanced SQL, BI dashboards, and IoT analytics.

Mexico

Message

What I'm looking for

I’m looking for a data/BI role where I can build reliable SQL-to-warehouse pipelines, automate KPI reporting, and support cross-functional teams with operational insights—especially when combining ERP data with real-time IoT analytics.

I’m a Data Analyst focused on turning raw operational and ERP data into clear, decision-ready insights. I use advanced SQL (complex joins, transformations, and data quality validation) plus BI tooling like Power BI and Grafana to deliver operational KPIs that stakeholders can actually use.

In my current role at Rio Grande Comercial, I’m building cloud data warehouse integrations and real-time IoT analytics pipelines to improve stock visibility and reduce manual checks. I’ve also engineered automation with VBA/Macros and Google Apps Script to strengthen data integrity in MicroSip ERP workflows, cut reporting time, and surface actionable findings for logistics, finance, and operations teams.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst & Inventory Specialist

Current

Rio Grande Comercial

Jul 2025 - Present (1 year)

Built SQL-based data quality validation and VBA automations to reduce MicroSip ERP data-entry errors and improve inventory reconciliation accuracy. Developed IoT-to-warehouse integrations and Power BI/Grafana KPI dashboards to deliver real-time cold-chain stock visibility to stakeholder teams.

Data Validation Power BI Grafana Microsip ERP Inventory Finance Data Quality Data Warehouse MQTT IoT ESP32 CAM and ESP32 InfluxDB Node RED Google Apps Script

Production Data Supervisor

Encapsuladoras MX

Jan 2025 - Apr 2025 (3 months)

Tracked OEE using Excel pivot tables and applied Lean Manufacturing analysis to identify bottlenecks and improve line throughput. Performed spreadsheet-based root-cause analysis to reduce unplanned downtime by correlating machine error codes with production schedule data.

Excel Pivot Tables Lean Manufacturing Root Cause Analysis

Accounting & ERP Data Analyst

Veterinaria Gomez

Jan 2023 - Mar 2024 (1 year 2 months)

Maintained financial record accuracy by entering accounting entries in MicroSip ERP (Ventas & Inventarios) and organizing fiscal documentation for monthly reconciliation. Built Excel-based dashboards to consolidate bank reconciliation, invoice tracking, and payment verification, while improving document control and audit trails.

Microsip ERP (Ventas)Inventarios Excel Financial Reporting Accounts Payable Receivable Bank Reconciliation Data Integrity Document Control

Automotive Diagnostic Technician

Renault

May 2023 - Aug 2023 (3 months)

Performed structured data analysis on electronic diagnostic scan reports to isolate root causes and prioritize corrective actions. Reduced service turnaround time by improving fault resolution workflows across multi-system issues.

Automotive Diagnostics Diagnostic Imaging Reports Root Cause Analysis Data Analysis Remediation Prioritization

Education

Degrees, certifications, and relevant coursework

UNIR México

Master of Science, Industry 4.0

2025 -

Pursuing a Master of Science in Industry 4.0 with a focus on data-driven decision-making, AI & analytics, and digital transformation.

Universidad Tecnológica de la Babícora

Bachelor of Science, Industrial Maintenance Engineering

2023 - 2025

Completed a Bachelor of Science in Industrial Maintenance Engineering, including projects such as OEE analysis, PLC automation, and process efficiency optimization.