ANA SOFÍA GUAJARDO GUTIÉRREZ

New York, NY

917-***-**** adxx4b@r.postjobfree.com

EDUCATION

COLUMBIA UNIVERSITY, School of International and Public Affairs Master of Public Administration, Energy & Environment, Data Analysis (STEM) New York, NY

2023

Teaching Assistant of the Introduction to Text Analysis in Python course Graduate consultant to the City of Cape Town’s Water and Sanitation Department Coursework: Renewable Energy Project Finance Modeling, ESG Reporting, Data Analysis using R TECNOLÓGICO DE MONTERREY

B.S., Civil Engineering

Monterrey, Mexico

2019

Student Welfare Coordinator at the Civil Engineering Student Society Marketing Director EDIFICA, the Civil Engineering International Symposium EXPERIENCE

COLUMBIA CENTER ON GLOBAL ENERGY POLICY (CGEP)

Research Assistant

New York, NY

Fall 2022

• Assessed the Energy Market in Latin America to identify opportunity areas and potential for growth.

• Carried out a strategy and framework for developing a research project.

• Executed research activities, draft reports, and presentations related to the research results. COLUMBIA SCHOOL OF INTERNATIONAL AND PUBLIC AFFAIRS Energy & Environment Concentration Program Assistant New York, NY

Fall 2022

• Represented 300 Energy & Environment students at Columbia University and provided advice and consultation.

• Provided leadership and contribution to the planning and execution of events.

• Managed content generation and platforms, as well as disseminating the weekly newsletter. FIRST AMMONIA

Graduate Intern

New York, NY

Summer 2022

• Carried out data gathering across the multiple project development facets, including renewable power inputs, ammonia markets, offtake participants, public policy, financing, etc.

• Reviewed engineering data and documents and supported the team’s understanding.

• Researched key inputs across all jurisdictions related to green hydrogen and ammonia and reviewed how they impact the financial model – CAPEX and construction cost, power price, green hydrogen price, green ammonia price, etc.

• Developed a database with available funding and financing options for infrastructure projects related to green hydrogen and ammonia, including grant programs, tax incentives, and subsidies across different markets. COLUMBIA PRACTICUM – CARTAGENA HYDROGEN PROJECT

Operations Manager

New York, NY

2021 - 2022

• Winner of Columbia SIPA Energy and Environment Practicum Grant for Analyzing the potential of the Low-Carbon Hydrogen Industry in the Colombia Caribbean.

• Identified Cartagena’s Hydrogen potential through feasibility analysis and developed a strategic energy transition plan for the region.

CUSTOMER INTELLIGENCE INC.

Business Analyst

Mexico City, Mexico

2019 - 2021

• Created a non-profit organization, including a strategic plan to identify and seize the market opportunities in Mexico, budget, bylaws, and framework to create a positive impact in the payments industry.

• Managed large sets of databases and developed data analysis frameworks for a different range of projects.

• Researched and identified alternative payment method solutions for Bill Payments through an exhaustive market and opportunity analysis.

• Increased the use of financial products by 20% through communications campaigns in several markets.

• Developed an opportunity analysis for a German company to enter the Mexican market. ORANGE INVESTMENTS

Intelligence Unit Trainee

Monterrey, Mexico

2019

• Developed business models and executed detailed architectural and engineering design, capitalization strategies, and urban analyses for many real estate projects.

• Developed property research to create a real estate project that was feasible and profitable while also exceeding the client’s expectations and business objectives.

BRICKWALLING

Construction Management Intern

Monterrey, Mexico

2018 - 2019

• Oversaw the construction management and budgeting for real estate projects using the PMO strategy based on the PMI methodology.

• Participated in the project management strategic definition of real estate projects from the pre-construction phase to the lifecycle management of the project.

BIOCONSTRUCCIÓN Y ENERGÍA ALTERNATIVA

Sustainable Development Intern

Monterrey, Mexico

2017 - 2018

• Consulted with various companies and projects in the pursuit of the LEED, WELL, and EDGE Certifications by organizing data, classifying documents, and implemented multidisciplinary strategies and methodologies.

• Executed sustainability and energy efficiency analysis for real estate projects. ADDITIONAL INFORMATION

• Language: Native Spanish, Fluent in English, Advanced in French.

• Software: Python, pandas, geopandas, ArcGIS, R, Microsoft Office, MS Project, STATA, Tableau, AutoCAD, Civil 3D, Neo-Dada, Revit, Adobe Illustrator, Mailchimp.

• Courses: Project Management, Time Management, LEED Green Associate Course.

Contact this candidate