Data Analyst / Excel Specialist
JAMES A. SANCHEZ
Skills
•
•
•
SQL (PostgreSQL, BigQuery)
Python (Pandas, NumPy, SciPy, MatPlotLib)
Excel (VLookup, Conditional Formatting, Pivot
Tables)
•
•
•
Excel VBA Programming (UserForms, Macros,
Modules)
Microsoft Power BI, Tableau, Looker Studio
Stata
Projects
PI G F A RM M AN AGE R – Personal Project (WIP) – Philippines
●
●
●
●
November 2025
Designed a macro-enabled Excel workbook using VBA to streamline sow record management for a family-run pig farm
Implemented add, update, and delete operations with change logging to ensure traceability and ease of review
Structured sample tables for sows, litters, expenses, and sales to support future expansion into full farm reporting
Released v0.3.0-alpha with semantic versioning, documentation, and a bug report template
CE NT RA LI ZE D DA T A OR GA NIZE R – Personal Project – Philippines
●
●
●
October 2025
Developed a macro-enabled Excel tool using VBA to manage dynamic structured records through a responsive UI
Engineered modular logic for ListBox refresh, record preview, and category indexing to improve performance and maintainability
Implemented search, replace, and delete functionalities with intelligent field detection to streamline record updates
RE A L- T IM E C UR RE NC Y C ON VE RTE R – Personal Project – Philippines
●
●
October 2025
Built an advanced Excel-VBA tool with a custom User Form to perform real-time and historical currency conversions
Automated exchange rate retrieval by querying external sources and implemented fallback logic for cached data
Check my portfolio in GitHub for more details.
Academic Research
FE RT I LI TY DE CI S IO N AN D FE M ALE L AB OR FOR CE P AR TI CI P AT IO N I N T HE P HI LI P PINE S – Thesis
●
●
May 2025
Employed Zero-Inflated Negative Binomial Regression to model count data with excess zeros, demonstrating
proficiency in advanced statistical techniques using Stata.
Provided policy recommendations to address fertility decline, showcasing the ability to translate complex data into
actionable insights for stakeholders.
LR RE L AT IO NS H I PS A ND FO RE C A ST S OF G HG E M I SS I ON S AN D E I IN T HE P HI L IP P INE S – Project
●
●
Dec 2024
Conducted advanced statistical analysis in Stata using the Engle-Granger Two-Step Method and ARIMA forecasting to
examine the relationship between GHG Emissions and Energy Intensity.
Interpreted findings to provide policy recommendations, demonstrating the ability to translate complex data into
actionable insights.
Work Experience
INTE RN – Department of Energy, Visayas Field Office – Cebu City, Philippines
●
●
Jun 2024 – Jul 2024
Conducted economic analysis of energy market trends, contributing to reports on electricity and gasoline prices.
Collaborated with team members to encode, visualize, and analyze energy consumption data from Visayas distribution
utilities using Excel, Google Sheets, and Looker Studio.
Education
B AC HE LO R OF S CIE N CE I N E C ONO M I CS – University of San Carlos – Cebu City, Philippines
Concentration: Environmental and Natural Resource | Graduated: Magna Cum Laude, Cum Laude Caroli Sancti
July 2025
