Cesar Vera
I'm a Data
About
Data Analyst, enthusiastic and team-oriented professional with a track record of over 11 years in the humanitarian sector. I have accumulated more than 6 years of specialized experience in information management for disaster response, covering the entire data lifecycle—from collection to visualization and analysis—all aimed at supporting strategic decision-making.
Data Management & Information Professional
I combine creativity, analysis, and technology to optimize information management and support decision-making.
- CV: CV Español | CV English
- Phone: +507 6630 6663
- City: Panama, Panama
- Bachelor's Degree: Systems Analysis and Computer Programming
- Email: cesarvera6@gmail.com
- Languages: Spanish, English, and Guarani
Extensive experience in data collection, processing, and visualization using tools like Kobo, Power BI, Tableau, and QGIS. Proven ability to lead data-driven projects in humanitarian contexts, supporting National Societies and international teams in disaster response, risk reduction, and emergency management.
Humanitarian Missions
Emergency response deployments supporting disaster response worldwide
Countries Worked In
Experience in field operations across Panama, Costa Rica, Honduras, Peru, Hungary, Mozambique, and Paraguay, providing technical support and optimizing data workflows for humanitarian responses.
Dashboards Developed
25+ custom dashboards for real-time monitoring and analysis.
Data Projects Completed
32+ projects integrating data collection, processing, and visualization tools like Kobo, Power BI, and SQL Server.
Tools
These are the key tools and technologies I specialize in, enabling me to analyze, visualize, and manage data effectively. From business intelligence platforms like Power BI and Tableau to data management with SQL Server and automation with Power Automate, my expertise allows me to create impactful solutions. Additionally, I leverage GIS tools like QGIS and data collection platforms such as Kobo Toolbox to support humanitarian and data-driven decision-making.
Resume
Professional Experience
Data Management Consultant
11/2024 - Present
International Organization for Migration (IOM) - Panama City, Panama
- Designed and optimized a regional database in SQL Server, restructuring standard tables to improve query performance and survey analysis collected from more than 20 geographic locations in 8 countries during 2024.
- Designed and optimized a general table in SQL Server, consolidating data from multiple tables to structure and enhance query performance and information analysis from multiple countries in 2024.
- Implemented an automated workflow for validation, cleaning, and data loading through a Python script with a graphical interface, reducing errors and accelerating SQL Server integration.
- Migrated activities from Excel to Microsoft Planner, improving task structuring and workflow management.
- Configured a work plan in Microsoft Planner with visualization in Power BI and automated workflows in Power Automate, improving task coordination and tracking.
- Implemented monitoring dashboards and validation for survey implementation and migration flow registration in KoboToolbox, with connection via API with Power BI.
Information Management Officer
02/2024 - 11/2024
International Federation of the Red Cross (IFRC) - Panama City, Panama
- Developed a regional dashboard for monitoring humanitarian assistance and estimating migration flows from 5 Central American countries.
- Implemented an information assistance point for migrants in the Darién region, Panama, facilitating access to satellite internet and establishing feedback systems.
- Managed data and information for decision-making in various emergency operations and humanitarian programs, strengthening National Societies capacities in the subregion.
- Facilitated training for information management teams in Costa Rica and Panama on HIAC certifications, mobile data collection tools such as Kobo Toolbox and ODK, and served as a mentor for the first "Regional Information Management Team for Emergency Deployment" program.
- Participated in a multisectoral assessment in Darién, providing recommendations for improvement in the collection, analysis, and visualization of data on services and activities carried out by the Red Cross Panama in that area.
- SIMS Coordinator in the Hurricane Beryl response, leading the coordination of remote support for information management, providing assistance in data processing, analysis, and visualization.
Revenue Assurance Analyst
08/2023 - 02/2024
Tigo Panama - Panama City, Panama
- Coordinated with business teams to establish and maintain control processes for revenue assurance.
- Developed automated tools for trend, variance, and loss analysis in Revenue Assurance.
- Designed and programmed controls in SQL Server to monitor anomalies.
- Implemented dashboards in Power BI for tracking revenues from roaming and electronic top-ups.
- Participated in database migrations, ensuring data integrity and accuracy during the transfer process.
- Led the execution and improvement of IC, SOX, and KPI controls.
Information Management Lead
01/2023 - 06/2023 (Full-time) / 01/2022 - 12/2022 (Part-time)
American Red Cross - Panama City, Panama
- Led information management (IM) support for the Latin America and Caribbean Division, ensuring the efficient handling of data and information.
- Provided comprehensive information management support to multiple countries with ongoing projects, including Guatemala, Honduras, El Salvador, Mexico, and Colombia.
- Documented data and information flows, developing training materials to facilitate data exchange and efficient management.
- Developed an interactive and user-friendly dashboard to monitor the LAC Portfolio, providing an overview of projects, financial status, key indicators, and relevant data for decision-making and progress tracking.
- Developed dashboards for monitoring humanitarian assistance and emergency response, enabling real-time analysis and facilitating strategic decision-making.
Information Management Officer
12/2020 - 12/2022
International Federation of the Red Cross (IFRC) - Panama City, Panama
- Coordinated information management for the health, water, hygiene, and sanitation department, ensuring quality and analysis in response reports to the COVID-19 pandemic.
- Designed a monitoring dashboard for global COVID-19 risk levels, based on a matrix of key epidemiological indicators.
- Developed a regional monitoring dashboard for the COVID-19 response, visualizing the implementation of measures across multiple countries.
- Developed a regional immunization dashboard to track 14 vaccines in 33 countries over the past 20 years.
- Deployed as rapid response personnel in Honduras to support the information management strategy coordination in response to Eta/Iota.
- Deployed as rapid response personnel in Budapest, Hungary, to support the emergency operation in Ukraine.
Information Management Consultant
11/2019 - 11/2020
International Federation of the Red Cross (IFRC) - Panama City, Panama
- Managed Information Management for the Health Department of the Americas Regional Office.
- Developed a dashboard for the Central America Dengue Outbreak for real-time monitoring.
- Created a website and forms for the Public Health Course in Emergencies.
- Developed maps for scenarios in the Public Health Course in Emergencies.
Computer skills
SQL Server
Experienced in database management, query optimization, and data integration using SQL Server. Developed automated data pipelines and consolidated datasets for reporting and analysis.
Python
Proficient in Python for data cleaning, automation, and ETL processes. Developed scripts for structured data processing and database uploads with graphical interfaces.
Power BI
Skilled in creating interactive dashboards, integrating multiple data sources, and optimizing data visualization for real-time decision-making.
Tableau
Experience in building dynamic reports and data visualizations to support humanitarian operations and emergency response.
QGIS
Proficient in GIS mapping and spatial data analysis for humanitarian applications.
Power Automate
Developed automated workflows for task synchronization, data integration, and process optimization across Microsoft tools.
Planner
Configured and managed Microsoft Planner for structured project management, integrating with Power BI for real-time tracking.
Kobo Toolbox & ODK
Extensive experience in mobile data collection, form design, and survey management for humanitarian assessments.
Excel
Advanced Excel skills for data analysis, reporting, and automation, including pivot tables, Power Query, and macros.
Education
Master’s Degree in Project Management
Currently Studying
American University of Paraguay
Bachelor's Degree in Systems Analysis
2016 - 2019
National University of Pilar (UNP), Pilar, Paraguay
Computer Programmer
2016 - 2018
National University of Pilar (UNP), Pilar, Paraguay
Portfolio
Below are some of the products I have developed. While many others are not displayed due to their internal use and confidentiality agreements, the projects showcased here have been published and are available for public viewing.
- All
- Dashboards
- Maps
- Website
- Scripts
Interests
My interests span across professional, personal, and recreational areas, creating a well-rounded balance between technology, creativity, and physical activity. While I don't always have time for everything, I strive to dedicate moments to these pursuits whenever possible, as they fuel both my professional innovation and personal fulfillment.
Photography and Drone Videography
Capturing compelling visuals and dynamic aerial footage to document landscapes.
Artificial Intelligence
Exploring the development and application of AI technologies to enhance data analysis, automate processes, and drive innovative solutions in both humanitarian contexts and personal development.
Quantitative Trading
Applying data-driven strategies and algorithmic models using Python and Artificial Intelligence to analyze financial markets, optimize trading decisions, and leverage statistical methods for consistent performance and effective risk management.
Tennis
Engaging in tennis as both a competitive sport and a recreational activity, promoting physical fitness, strategic thinking, and mental resilience on and off the court.
Video Games
Passionate about video games as a way to unwind, enhance strategic thinking, and engage in immersive, interactive storytelling experiences. 🎮
Electronic Music
Exploring electronic music for its innovative soundscapes and creative expression, blending rhythm and technology to inspire focus, relaxation, and artistic exploration. 🎧
References
Throughout my career, I have had the privilege of collaborating with exceptional professionals across various projects and humanitarian contexts.
Contact: afrida@iom.int
Frida Archibold
National Data and KM Officer
International Organization for Migration (IOM)
Contact: diana.oviedo@ifrc.org
Diana Oviedo
Coordinator, Operations
International Federation of the Red Cross (IFRC)
Contact: rmaceo@unicef.org
Benedicto Maceo
WASH OFFICER
UNICEF
Contact
Feel free to reach out to me for any inquiries, collaborations, or professional opportunities.