Efren Hernandez

Recent International Trade Graduate with hands-on experience in Industrial Manufacturing sectors, specializing in B2B Market Intelligence and Quantitative Data Analysis. Proficient in transforming complex engineering and trade databases into executive Power BI dashboards to drive commercial decision-making and forecasting. Equipped with a solid technical foundation in international compliance, data integrity, and advanced prospecting tools like Sales Navigator, SICEX, and Veritrade.

An agile, results-oriented professional committed to optimizing business development strategies through data storytelling.

Business Intelligence & Trade Analyst (Intern) at GIFFIN INDUSTRIES (2026-01 – Present)

• Data Modeling & Multi-Plant Projects (DTNA): Transformed complex raw engineering databases from Daimler Truck North America (DTNA) plants in Texas and Arkansas into interactive Power BI dashboards; streamlined manufacturing metrics (%OEE, Takt Time) into C-suite KPIs to enable precise commercial forecasting.
• Strategic Market Intelligence: Formulated data-driven market insights and segmented over 100+ Tier 1 industrial accounts, cross-referencing internal CRM data with external market share databases to reveal a 15% hidden growth potential in automotive sectors (OEMs & Tier 1).
• Data Integrity, Auditing & ETL: Cleaned and structured inconsistent sales datasets using Power Query and advanced Excel logic; standardized operational and geographic customer records to support strategic decision-making.
• Field Prospecting & Industry Events: Led commercial benchmarking and direct B2B prospecting efforts at major industrial events such as FabTech 2026 (CDMX), mapping new competitors and engaging with corporate decision-makers.
• Quantitative Market Estimation: Utilized specialized international trade databases, including SICEX, Veritrade, and Data Mexico, to track import/export records and map competitor volumes, successfully calculating B2B market sizes amid scarce public data

Bachelor's Degree in International Trade – Universidad de Guanajuato (University of Guanajuato) (2026-06)

Course in Advanced Management IMMEX and PROSEC Programs – Instituto Universitario CAAAREM / Confederación de Asociaciones de Agentes Aduanales de la República Mexicana (CAAAREM) (2026-04)

Course in Certification of Origin under Free Trade Agreements (FTAs) – Instituto Universitario CAAAREM / Confederación de Asociaciones de Agentes Aduanales de la República Mexicana (CAAAREM) (2026-04)

Certification in Foreign Trade & Logistics Certification: International Logistics DNA – Secretaría de Economía (Ministry of Economy) (2026-05 – 2026-06)

Course in Compliance with NOMs in Imports and Their Customs and Logistics Consequences – Instituto Estatal de Capacitación (IECA – SEP) (2025-09)

Technical High School in Industrial Electromechanics – Colegio Nacional de Educación Profesional Técnica (2019 – 2022)