Professional Profile

Turning complex information into clear decisions.

Public & International Affairs · Business Analysis

I help translate complex institutional challenges into clear priorities, actionable recommendations, and informed decisions by combining public affairs experience with analytical methods.

Rodrigo Garza García
10 yearsPublic & international affairs
7+ yearsOffice of the Chief of Staff to Mexico's Secretary of Foreign Affairs
15+ areasInternal institutional coordination
12 skillsmicro1 AI Interview Certification
Foreign Policy & Government RelationsGeopolitical Risk & Security AnalysisStrategic Planning & Performance ManagementStakeholder EngagementBusiness Analysis & Process ModelingData Analysis · SQL · Python · Excel · Tableau
01 / About

Experience across public affairs, international relations, and business analysis.

A career spanning foreign policy, government relations, institutional coordination, and analytical work.

I am a public and international affairs professional with degrees in International Relations and Public Administration. My experience spans Mexico's Ministry of Foreign Affairs, the Government of the State of Mexico, and the Embassy of Mexico in Brazil, covering foreign policy, government relations, international cooperation, and security affairs.

At Mexico's Ministry of Foreign Affairs, I spent 7+ years in the Office of the Chief of Staff, progressing from Advisor to Director and serving six months as Acting Director General. I coordinated work across 15+ internal areas and with federal public administration agencies, including follow-up on presidential priorities with the Technical Secretariat of the Presidency of the Republic. This included the foreign policy components of the 2019–2024 and 2025–2030 National Development Plans and related programs: the Foreign Affairs Sectoral Program and AMEXCID's international development cooperation program, which I supervised. I also coordinated four government management reports for 2018–2024, integrated performance information from 27 responsible units into a Results Indicator Matrix, and coordinated activity reports and work programs for more than 160 Mexican missions abroad.

Earlier in my tenure at the Ministry, I also served as Advisor and Liaison to the Senate of the Republic, preparing international analysis and decision-support materials on foreign policy and monitoring Senate resolutions and committee proceedings. I also served as liaison to the Technical Secretariat of the National Security Council and the National Intelligence Center, contributing to a national security program and report.

I complement this experience with applied Business Analysis and Data Analysis capabilities. I completed TripleTen's Data Analyst Bootcamp and am pursuing IBM's Business Analyst Professional Certificate, developing practical skills in SQL, Python, Excel, Google Sheets, Tableau, statistical analysis, requirements elicitation, and process modeling.

02 / Expertise

Two complementary areas of expertise.

Capabilities developed through executive coordination in government and applied business and data analysis projects.

01

Public & International Affairs

Foreign policy and international cooperation; federal and state government relations; legislative liaison; geopolitical and geostrategic analysis; national security and geopolitical risk; strategic planning and priority tracking; institutional performance monitoring, executive reporting, accountability, and audit follow-up.

02

Business Analysis

Stakeholder analysis, requirements elicitation and documentation, process mapping, user stories, use cases, and solution evaluation. Project work includes process flowcharts and UML diagrams in Lucidchart; training also covers agile workflows, Jira, and Confluence. SQL, Python, Excel, and Tableau support complementary data analysis.

03 / Selected Projects

From process models to business performance.

Selected work in process analysis, data exploration, performance measurement, and decision-oriented reporting.

IBM Business Analysis · Academic Case
Mobi-e-rides entity relationship diagram linking Customer, Bike and Rental

Mobi-e-rides — End-to-End Business Analysis

Developed an end-to-end business analysis case for a proposed bicycle and e-bike rental platform, translating stakeholder needs into prioritized requirements, traceability and solution models.

Key takeaway: Three priority requirements documented with MoSCoW and traceability, plus ERD, UML use-case and rental-process models. The academic case includes alternatives for bike unavailability and payment rejection.
StakeholdersRequirementsMoSCoWTraceabilityUMLERDProcess Modeling
IBM Business Analysis
QuickService Delivery order management process flowchart created in Lucidchart

QuickService Delivery — Process Mapping

Mapped a food and grocery delivery order from placement to fulfillment, clarifying five participants, handoffs, decision points and exception paths.

Key takeaway: Five participants, four process stages and controls for order completeness, payment, readiness and fulfillment. Exception paths are identified as modeling assumptions.
LucidchartProcess MappingFlowchartProcess Analysis
IBM Business Analysis
News Channel Program UML use case diagram created in Lucidchart

News Channel Program — UML Use Case Modeling

Defined the scope of a prime-time news program through five actors, six use cases and their associations in a UML diagram.

Key takeaway: Defined the system boundary, five actors, six use cases and eight actor-to-use-case associations in the UML model.
UMLUse CasesLucidchartRequirements
TripleTen · Data Analytics
RappiPlus executive business performance dashboard

RappiPlus — Business Performance Analysis

Combined data-quality review, product-level profitability, funnel and retention analysis, and checkout A/B testing using Python, SQL, statistical testing and Tableau.

Key takeaway: Extreme-quantity records accounted for 81.45% of reported revenue. The adjusted view excludes extreme and invalid quantities; the checkout test showed no statistically significant improvement (p = 0.4161).
PythonSQLTableauA/B Testing
TripleTen · Data Analytics
Andes Capital executive real estate dashboard

Andes Capital — Real Estate Sales Analysis

Analyzed 8,500 real estate sales across 2023–2024, comparing revenue, property types, sales channels, geography and customer cohorts.

Key takeaway: Brokers accounted for 73% of revenue; total revenue reached $6,010 million, up 11.14% year over year. Initial-cohort sales fell from 224 to 26, supporting recommendations to diversify channels and strengthen customer acquisition.
TableauKPI AnalysisCohortsData Storytelling
TripleTen · Data Analytics
Andes Retail commercial performance dashboard overview

Andes Retail — Commercial Performance Analysis

Compared 2024–2025 revenue, margin, orders, customer segments, products, geography and seasonality to identify changes in commercial performance.

Key takeaway: Revenue declined 6.8% in 2025 alongside lower order volume and average order value. Recommended follow-ups focus on category and customer patterns; causes were not established.
TableauCommercial KPIsDashboard Design
TripleTen · Data Analytics
MercadoLibre conversion funnel and retention analysis executive summary

MercadoLibre — Funnel & Retention Analysis

Used SQL to assess conversion-funnel performance and D7–D28 retention across ten Latin American countries and compare customer cohorts.

Key takeaway: The largest funnel drop was 65.89 percentage points between product selection and add-to-cart. In the first cohort, retention fell from 86.2% at D7 to 56.2% at D14, supporting early-retention initiatives.
SQLCTEsFunnel AnalysisCohort Analysis
TripleTen · Data Analytics
Comparison of conversion rates and average spending for Page A and Page B in a landing page A/B experiment

A/B Landing Page — Experiment Analysis

Evaluated two landing page versions across 40,000 users, comparing conversion, spending and associations with traffic source and user type.

Key takeaway: Page B had higher conversion (15.96% vs. 12.57%) and spending among converted users. Traffic source's association with conversion was statistically significant but very weak.
PythonA/B TestingHypothesis TestingConversion Analysis

More analytical work is available on GitHub ↗ and Tableau Public ↗.

04 / Publications & Analysis

Writing on foreign policy and international affairs.

Selected Spanish-language articles and columns on foreign policy, public policy, and international affairs.

Milenio Diario · 2020

El Libro Blanco para articular la política exterior con la defensa nacional

Analysis on the relationship between foreign policy, national defense, inter-agency coordination, and Mexico's strategic security planning.

Foreign PolicyNational SecuritySpanish
Milenio Diario · 2019

Pendientes en la planeación nacional y ajustes en la política exterior de México 2019–2024

Commentary on national planning, Mexico's foreign policy priorities, and the role of sectoral and special programs in long-term public policy.

Public PolicyStrategic PlanningSpanish
COMEXI · 2019

Suspensión del INF: México en medio del ajuste en el equilibrio internacional de poder

Analysis of the implications of the suspension of the Intermediate-Range Nuclear Forces Treaty for Mexico and the international balance of power.

International SecurityGeopoliticsSpanish
Foreign Affairs Latinoamérica · 2018

El querido tirano. Del genocidio a la Unión Africana

Published contribution examining African political history and the institutional evolution of the African Union.

International AffairsAfricaSpanish
COMEXI · 2018

Derechos humanos en la migración y el refugio

Contribution addressing human rights considerations in migration and refugee protection.

Human RightsMigrationSpanish
COMEXI · 2018

El proceso de paz en la península coreana

Commentary on the peace process on the Korean Peninsula and its regional and international implications.

International AffairsEast AsiaSpanish
Mexican Times · 2018

Río de Janeiro: ¿seguridad pública, cortina de humo o elecciones presidenciales?

Analysis of public security and the political context surrounding Brazil's 2018 presidential election.

BrazilPublic SecuritySpanish
Milenio Diario · Columnist · 2016–2017

Selected Columns on Public and International Affairs

Wrote a biweekly column covering public affairs, politics, and international issues for the newspaper's Estado de México edition.

Public AffairsPoliticsInternational AffairsSpanish

For publications without an active publisher page, see the LinkedIn publication record ↗.

Selected Speaking Engagement

05 / Professional Experience

Public service, institutional leadership, and international affairs.

Roles in Mexico's federal and state government and diplomatic service.

Mexico's Ministry of Foreign Affairs

February 2018 – April 2025 · Office of the Chief of Staff to the Secretary of Foreign Affairs

Supported executive priorities through institutional reporting, cross-government coordination, and legislative follow-up.

Acting Director General for Program Support and Institutional Information

17 October 2024 – 30 April 2025 · Acting assignment concurrent with Director role

Coordinated the Ministry's input to the 2025–2030 National Development Plan with internal areas and the Ministry of Finance, and consolidated 2024 activity reports and 2025 work programs for more than 160 Mexican missions abroad. Also followed up on institutional control and performance agreements, contributed information for the 2024 Public Account review, and coordinated two quarterly transparency updates.

Director of Program Support and Institutional Information

February 2023 – April 2025

Coordinated input from more than 15 internal areas for four government management reports covering the 2018–2024 administration and the Ministry's three decentralized bodies. Consolidated narrative and indicators for the Foreign Affairs Sectoral Program's January 2023–June 2024 Progress and Results Report; coordinated the Ministry's response to presidential priorities in liaison with the Technical Secretariat of the Presidency of the Republic, organizing requests, reviewing inputs, and coordinating responses with internal areas and federal agencies; handled Senate follow-up and audit responses; fulfilled 100% of transparency obligations under my responsibility and answered citizen requests within legal deadlines.

Deputy Director of Information and Institutional Liaison

February 2019 – February 2023

Supported the foreign-policy component of the 2019–2024 National Development Plan and the 2020–2024 Foreign Affairs Sectoral Program. Integrated narrative and quantitative progress from 27 responsible units into the Results Indicator Matrix (MIR), maintained liaison with the Ministry of Finance, and coordinated inputs for four government reports, four activity reports, and three progress-and-results reports.

Advisor and Liaison to the Senate of the Republic

February 2018 – November 2018

Prepared international analysis and decision-support materials; monitored Senate resolutions and committee proceedings; served as liaison to the Technical Secretariat of the National Security Council and the National Intelligence Center, contributing to a national security program and report.

Government of the State of Mexico

January 2015 – February 2017 · International Affairs Advisor · International Affairs Coordination

Advised on the governor's international agenda and supported his role as chair of CONAGO's International Affairs Commission. Prepared briefing materials for bilateral and multilateral meetings and organized approximately ten international visits, coordinating protocol, logistics, and English–Spanish interpretation.

Embassy of Mexico in Brazil

June – August 2014 · Brasília · Professional Internship

Supported information monitoring and the organization of diplomatic activities and cultural events in the Local Government Liaison Area.

06 / Professional Development

Education & Certifications

Academic degrees and specialized training in public administration, international affairs, business analysis, and data analytics.

Academic Degrees

Master's Degree

Master of Public Administration

Universidad del Valle de México (UVM) · January 2016 – December 2017 · With honors

Bachelor's Degree

Bachelor's Degree in International Relations

Universidad Iberoamericana · January 2011 – December 2015

Professional Training & Certifications

Professional Certificate · In progress

IBM Business Analyst Professional Certificate

IBM · Coursera · September 2026 – Present

Professional Course · Completed

Introduction to Business Analysis

IBM · Coursera · October 2026

Covers business analysis fundamentals, requirements gathering, stakeholder analysis, process improvement, gap analysis, and solution evaluation.

Professional Course · Completed

Business Analysis: Process Modeling & Requirements Gathering

SkillUp · Coursera · November 16, 2026

Completed an online course focused on process modeling and requirements gathering for business analysis.

Bootcamp · Completed

Data Analyst Bootcamp

TripleTen · May 2026 – October 2026

Completed an intensive Data Analyst bootcamp focused on applying SQL, Python, Google Sheets, Tableau, and statistical analysis to solve business problems and support data-driven decision-making.

Diploma · Completed

Public Policy and Evaluation

Center for Research and Teaching in Economics (CIDE) · January 2016

Public Finance Course · Completed

¿Cómo entender el presupuesto? El gasto público a través de los datos

Secretaría de Hacienda y Crédito Público · April 2020

Specialized Course · Completed

Introductory Course on National Security

National Defense College and Naval Higher Studies Center · April 2019

Specialized Course · Completed

Terrorism and Counterterrorism: Comparing Theory and Practice

Leiden University · Coursera · September 2018

Professional Course · Completed

English Communication for Tech Professionals

Arizona State University · Coursera · September 2026

Completed approximately 73 hours of training in professional and technical English, covering business communication, interviewing, networking, written communication, and cross-functional collaboration.

Language Training · Completed

100 Hours of Russian Language Lessons

Preply · October 2026

Completed 100 hours of Russian-language instruction, with lessons conducted entirely in English. Approximate level: A1 (CEFR).

Professional Course · Completed

Protocol and Ceremonial

Matías Romero Institute · November 2015

Professional Courses · Completed

IBM Data Analysis & Visualization

Excel Basics for Data AnalysisIBM · Coursera · October 2026
Data Visualization and Dashboards with Excel and CognosIBM · Coursera · October 2026
07 / Contact

Let's connect.

Open to opportunities in public and international affairs, business analysis, strategy, and operations.