Portfolio

Hi, I'm Kevin.

I am a
Kevin Gil Kevin Gil
About Me

Turning messy data
into clear answers.

Drag the slider to see how raw, hard-to-read data can be transformed into something clean and actionable.

sales_data_FINAL_v3_USE_THIS_ONE.xlsx ID Name REGION q1 sales Q2Sales q3_sales Q4 Sales $ Total Status Notes 001 johnson, mike West $12,400 15200 $14,800.00 16100 58500 active check q1 2 SARAH CHEN east 22100 $19,500 21000 $24,200 86800 Active - 003 [empty] N/A ??? - - - - MISSING needs fix 04 Marcus T. MIDWEST $9,800 11200 $10,400 12900 44300 active low performer 2 SARAH CHEN east 22100 $19,500 21000 $24,200 86800 DUPLICATE? duplicate row 005 Rivera, Ana South 18600 $20,100 17900 $22,400 79000 Active - 6 D. Patel NW fourteen thousand 16400 $15,100 17800 #VALUE! inactive fix number format 007 Kim, Jessica East 25400 $27,200 24100 $29,800 106500 Active top seller 008 Thompson, B west $11,700 13400 12200 $14,600 51900 active - 09 Nguyen, T. SOUTH 16200 $17,900 15600 $19,100 68800 Active - 010 lee sam Midwest 13100 14800 $12,600 $15,300 55800 active - TOTALS ??? need to recount scroll down for more rows...
Sales Performance FY 2024 — 10 Representatives ↑ 12% YoY 9 Active 1 Inactive # REPRESENTATIVE REGION Q1 Q2 Q3 Q4 TOTAL STATUS 001 Johnson, Mike West $12,400 $15,200 $14,800 $16,100 $58,500 Active 002 Chen, Sarah East $22,100 $19,500 $21,000 $24,200 $86,800 Active 003 Torres, Marcus Midwest $9,800 $11,200 $10,400 $12,900 $44,300 Active 004 Rivera, Ana South $18,600 $20,100 $17,900 $22,400 $79,000 Active 005 Kim, Jessica ★ East $25,400 $27,200 $24,100 $29,800 $106,500 Active 006 Patel, Dev Northwest $14,000 $16,400 $15,100 $17,800 $63,300 Inactive 007 Thompson, Ben West $11,700 $13,400 $12,200 $14,600 $51,900 Active 008 Nguyen, Tran South $16,200 $17,900 $15,600 $19,100 $68,800 Active Total (8 reps) $558,100 9 Active · 1 Inactive Last updated: Auto-refreshed · Duplicates removed · Formats standardized
BEFORE
AFTER

I'm a Financial Analyst with a deep passion for data — mining it, modeling it, and automating everything in between. My work spans media, retail, and licensing industries, where I've built financial models and streamlined processes that actually get used.

Work

Projects

A selection of tools and automations I've built.

Python Script Automation
🐍
Automation

Pull Data with a Python Script

Automate data extraction and transformation using Python scripts — turning hours of manual work into a one-click process that runs reliably every time.

Python Pandas
Email Automation
📧
Automation

Send Emails Directly from Excel

We often have recurring emails we send daily or weekly. Make your life easier by sending them straight through Excel — customize target addresses, subjects, bodies, and attachments, then run it all in one go.

Excel Outlook VBA
Database Model
🗄️
Data Engineering

Export Data to Access (or Vice Versa)

Excel maxes out at ~1M rows. Seamlessly export your data to an Access database for safer, more reliable storage — and Power Query it right back without the sluggish Excel overhead.

Excel Access VBA PowerQuery M
Capabilities

Skills

Tools, languages, and domains I work in.

🐍
Languages & Scripting
Python VBA PowerQuery M SQL R JavaScript HTML / CSS
📊
Data & Analytics
Tableau Power BI Excel (Advanced) Financial Modeling Pandas NumPy
⚙️
Automation & Databases
Process Automation Access / SQL DBs Outlook via VBA ETL Pipelines Data Cleaning
💼
Domain Knowledge
Financial Analysis Budgeting & Forecasting Media Industry Retail & Licensing Neural Networks
Background

Education

The foundations that fuel the work.

2021
Certification
Data Analytics Boot Camp
USC Viterbi School of Engineering — Los Angeles, CA
26-week rigorous program covering Excel, Python, R, JavaScript, SQL, Tableau, HTML/CSS, Big Data concepts, and machine learning with neural networks.
2012
Bachelor's Degree
Bachelor of Business Administration (BBA) — Accounting
University of California, Riverside — Riverside, CA
Business fundamentals with a focus on financial accounting, analysis, and the quantitative skills that underpin everything I do today.

Let's Talk

Have a project, a question, or just want to connect?
My inbox is always open.