I am a goal-oriented professional with experience in team support, data analysis, and performance optimization. Utilizing my proficiency in spreadsheets, front-end tools, and business intelligence solutions, I deliver actionable insights that enhance efficiency and support data-driven decisions.
Project | Description | Skills Applied |
---|---|---|
InsTranSQL – Instant SQL Query Tool for Large Datasets | Developed a lightweight SQL tool that runs queries on large CSV/TXT files, avoiding spreadsheet limits and complex database setups. Speeds up data processing by 95% compared to common methods. | Python (Pandas, SQLite, Tkinter), SQL, JSON. HTML and CSS for the page that presents the portfolio piece. |
Excel-Based Evaluation Solutions | Developed an Excel-based evaluation system, subsequently enhanced with VBA macros to automate key processes that increased the efficiency of the evaluation process by around 80%. | Microsoft Excel and VBA macros. HTML, CSS, JavaScript, and Google Apps Script for the page that presents the portfolio piece. |
Google Sheets - Data Cleaning and Transformation | Developed a Google Sheets-based data transformation workflow, automating complex data processing tasks, reducing manual effort by approximately 90%. | Google Sheets. HTML and CSS for the page that presents the portfolio piece. |
Interactive Online Resume | This very site is my interactive online resume, presenting my professional information while demonstrating my front-end development skills. A PDF version of this resume can be downloaded at https://ramoncitosantiago.neocities.org/resume/CV 2025 - Ramoncito Santiago.pdf | HTML, CSS, and JavaScript. |
Excel Helpline
AMA Computer College