Jon Karlo Moises T. Alonzo

B.S. Computer Engineering — Cagayan State University focused on business intelligence and analytics building dashboards, automating reports, and uncovering insights that drive data-informed strategies.

Download CV
Jon Karlo Moises T. Alonzo

About Me

Detail-oriented Data Analyst with a background in Computer Engineering and hands-on experience in SQL, Power BI, Excel, and Tableau. Skilled in data cleaning, transformation, and dashboard development to support data-driven decision-making. Strong analytical thinker with experience analyzing sales and customer data to identify trends, optimize reporting processes, and deliver actionable business insights.

Key areas I can contribute to immediately:

  • Exploratory Data Analysis (EDA) and data preparation
  • SQL development (joins, window functions, aggregations) and query optimization
  • Power BI / Tableau dashboard development and DAX calculations
  • Reporting automation and scheduled deliveries
  • KPI definition and business-focused analysis

SKILLS

SQL

  • Complex joins, CTEs, subqueries
  • Window functions (RANK, DENSE_RANK, LAG, LEAD, running totals)
  • Query optimization and performance tuning
  • Database design and normalization
  • Business KPI aggregation and reporting

Python

  • Data analysis using Pandas and NumPy
  • Data cleaning and transformation (ETL workflows)
  • Exploratory Data Analysis (EDA)
  • API integration and web scraping
  • Automation of data workflows and reporting

Power BI

  • Data modeling and relationship management
  • DAX measures and calculated columns
  • Interactive dashboard development
  • KPI tracking and executive-level reporting

Tableau

  • Advanced visual analytics development
  • Data blending and calculated fields
  • Interactive storytelling for business insights

EXCEL

  • Pivot Tables and Power Query
  • Advanced formulas (XLOOKUP, INDEX-MATCH, IF)
  • Dashboard creation
  • Data cleaning and transformation
×
Data Analytics Essentials Certificate
×
Introduction to Data Science Certificate

EXPERIENCE

Business Intelligence Intern
Zoomtech I.T SolutionsJuly 2024 - August 2024

  • Developed and maintained an interactive dashboard to monitor sales performance across multiple revenue streams and service offerings.
  • Tracked and analyzed 10+ ongoing projects, improving visibility of revenue status and pipeline performance.
  • Consolidated and updated daily Excel reports to ensure accurate tracking of revenue and project status.
  • Implemented KPI tracking (monthly revenue, project status, revenue distribution), improving reporting efficiency and decision support.
  • Reduced manual data consolidation efforts by approximately 30% through improved data organization and dashboard structuring.

Bachelor of Science in Computer Engineering
Cagayan State University - Carig Campus2021 - 2025

  • Completed academic projects in data structures and algorithms.
  • Developed foundational skills in data analysis and systems thinking
  • Applied query logic and structured problem-solving in technical coursework
  • Gained experience working with databases and analytical tools

Freelance Data Analyst 2025 - Present

  • Delivered actionable insights for 10+ commission-based projects, improving client decision-making and operational efficiency.
  • Designed and implemented end-to-end ETL pipelines, reducing manual data processing time by 40–60%.
  • leaned and transformed datasets with 50K–500K+ rows, improving data accuracy by 95%+ .
  • Developed interactive dashboards (Power BI / Tableau / Excel) tracking 15+ KPIs, enabling stakeholders to identify trends and increase revenue by up to 20% .
  • Automated recurring reports, cutting reporting turnaround time from 2 days to under 2 hours.
  • Collaborated directly with clients to translate business problems into data solutions, increasing project repeat rate by 30% .
  • Produced executive-level reports focused on revenue growth, cost optimization, and performance benchmarking.

PROJECTS

HR Dashboard Report

Python SQL Excel Power BI

This report provides a comprehensive analysis of the organization’s workforce using Power BI

Sales Dashboard Report

Python SQL Excel Power BI

Provides a comprehensive high-level overview of the company’s financial and operational performance.

Inventory Management System

Excel

Tracking tool with automated low-stock alerts and buffer comparison using structured tables and conditional formatting.

Academic Performance System

Java

Java application that evaluates academic distinctions and automates eligibility checks using rule-based logic.

Water Quality Monitoring

HTML CSS JS ESP32 PHP

IoT-based monitoring system using ESP32 with a web dashboard for real-time environmental data reporting.

SERVICES

Visualization

Transform complex datasets into compelling visual stories. I create interactive dashboards and reports that make data accessible, actionable, and impactful for informed decision-making across your organization.

Data Management

Efficiently extract, transform, and load data from multiple sources. I ensure data quality, consistency, and integrity while optimizing databases and data pipelines for seamless operations.

Business Intelligence

Uncover hidden patterns and trends in your data to drive strategic growth. I provide actionable insights and comprehensive business analytics that empower stakeholders to make data-driven decisions.

KPI Tracking

Develop customized KPI frameworks and real-time performance dashboards. Monitor key metrics effectively to track progress toward business objectives and optimize operations continuously.

CERTIFICATES

23 Jun 2025

Data Analytics Essentials

CISCO / DICT-ITU

Course focused on core data analytics skills, including transforming and organizing data with Excel, querying databases using SQL, creating visualizations and dashboards with Tableau.

View Credentials
28 Jan 2026

Introduction to Data Science

CISCO / DICT-ITU

Foundational course covering data science, data analytics, and data engineering, with a focus on data-driven decision-making and real-world applications across industries.

View Credentials

CONTACT

Get In Touch

Feel free to reach out for collaborations, inquiries, or just to say hello. I'm always open to discussing new projects and opportunities.

Email alonzojonkarlo@gmail.com
Phone +63 992 705 6798
Location Tuguegarao City, Cagayan, Philippines

Social Profiles

Send a Message

Have a question or want to work together? Drop me a message!