Kyer Ivan C. Jayme
Cebu City, Philippines • *************@*****.*** • Github • Portfolio
Professional Summary
Detail-oriented Information Technology student with experience in data analysis, SQL, Power BI, Excel, Python, video editing, data entry, and AI annotation/training. Skilled in organizing and cleaning data, building dashboards, handling detail-focused tasks, and creating edited content with accuracy and creativity. Has worked on academic and personal projects involving data modeling, reporting, and content editing. Seeking online internship, freelance, or entry-level opportunities where I can apply technical, creative, and organizational skills while continuing to learn and grow. Technical Skills
Technical: SQL, Excel, Power BI, Python, SSIS, SQL Server, MySQL Workbench Tools & Platforms: Git/GitHub, Figma, VMware, GNS3, Packet Tracer, After Effects, Premier Pro, Canva Language: English, Cebuano, Tagalog.
Projects
Layoffs Data Cleaning in MySQL
Personal Project
Feb 2026
● Cleaned and standardized a 2,361-row layoffs dataset in MySQL to improve data quality and usability.
● Identified and removed duplicate records using ROW_NUMBER, staging tables, and SQL-based validation checks.
● Standardized key fields such as company, industry, country, and date to ensure consistent analysis-ready data.
● Handled missing values with self-joins, null checks, and row filtering for cleaner downstream analysis. Manufacturing Downtime Analysis
Emerson x DAPH National Data Challenge 2025 May-Jun 2025
● Developed a Power BI dashboard to analyze 38 production batches and 1,388 minutes of downtime in a manufacturing line.
● Modeled 4 manufacturing tables for efficiency, downtime, operator, and product analysis.
● Diagnosed top downtime drivers, led by machine adjustment, machine failure, and inventory shortage.
● Reported 64.02% line efficiency and 55.91% preventable downtime to guide improvements. Leadership & Activities
UNIVERSITY OF SAN CARLOS SCHOOL OF ARTS AND SCIENCES - Badminton Club Team Captain Aug 2024 - Present
● Led team coordination by organizing schedules, roles, and training plans for a competitive university team.
● Conducted structured practice sessions to improve preparation, time management, and use of team resources.
UNIVERSITY OF SAN CARLOS - Pawrolinian
Logistics Committee Member Sept 2025 - Present
● Organized, labeled, and distributed food, equipment, and first-aid materials to support campus operations.
● Coordinated inventory and logistics for animal welfare initiatives, helping ensure accurate tracking and timely availability of supplies. .
Education
University of San Carlos Cebu City, PH
Bachelor of Science in Information Technology Expected Graduation: 2027