Analytics & Optimization Engineer-in-Training

Pedro Kawamura

407-***-**** ● ***********@*****.*** ● he/him/his ● Websites: LinkedIn, GitHub

EDUCATION

Georgia Institute of Technology Aug. 2022 - Present

● Bachelor of Science in Industrial Engineering - Analytics and Data Science Concentration Atlanta, GA

● Minors in Computer Science and Mathematics

● GPA: 3.5/4.0

Relevant Courses: Regression & Forecasting, Advanced Optimization, Finance & Investments, Decision & Data Analytics, Database Management, Simulation Analysis & Design, Applied Combinatorics

● Study Abroad experience in Metz, France.

EXPERIENCE

Delta Airlines Aug. 2024 - Present

Ground Standards Assurance Analyst Co-op Atlanta, GA

● Optimized an inventory distribution model with Python (Gurobi, statsmodels), cutting costs by 50% (~$12K).

● Automated a Tableau-Excel-SQL dashboard to streamline employee performance analysis by 70%.

● Modeled agent proficiency trends with Python, Excel, and SQL to deploy a tool targeting weakest performing areas. Health, Wellness, and Ergonomics Analyst Co-Op

● Developed a worker injury tracking system with Excel (VBA) and SQL, improving dashboard refresh speed by 75%.

● Implemented tailored training based on historical injury data, projected to reduce high-risk injuries by 33%. TranSystems Corporation Jun. 2024 - Aug. 2024

Transportation Analyst Intern Orlando, FL

● Created an intersection data extraction tool (Python, JS, HTML/CSS), to reduce manual data processing by 80%.

● Standardized traffic signal volume and timing metrics (Python, Synchro) to support bike-lane addition to a roadway.

● Visualized historical crash data to identify car accident hot spots, presenting findings to FDOT representatives. PROJECTS

Sigma Nu Yellow Pages May. 2025 - Present

● Designed backend architecture and data integration for an alumni networking platform with PostgreSQL and React.

● Engineered database schema and built automated data pipelines to populate the backend from 2,000+ alumni records. Traffic Accident Influence on Public Transportation Usage Mar. 2024 - May 2024

● Tested the correlation between NYC traffic accidents and transit ridership with Python (Pandas, BeautifulSoup).

● Aggregated 4 diverse datasets, parsing through 15M+ entries of data to model and visualize monthly transit utility.

● Concluded from the analysis there was no significant statistical correlation between crash rates and subway ridership. Ping Pong Elo Rating System Jan. 2024 - Feb. 2024

● Calculated a dynamic Elo rating algorithm (Java) based on probabilistic success for a 64-participant tournament.

● Deployed a JavaFX GUI to manage tournament play and visualize real-time rankings. ORGANIZATIONS

Sigma Nu Fraternity Jan. 2023 - Present

Treasurer Oct. 2024 - Present

● Structured dynamic financial forecasting in Python and Excel to manage a $240K+ budget over 105 active members.

● Recovered $60K in national debt and increased dues compliance by 50%, enforcing a strict collections process. Georgia Tech Undergraduate House of Representatives Nov. 2023 - Aug. 2024 Industrial and Systems Engineering Representative Atlanta, GA

● Advocated for and presented academic and community initiatives for Industrial and Systems Engineering students. SKILLS

Programming & Data Science: Python (Pandas, BeautifulSoup, yfinance, Gurobi, statsmodels, Matplotlib), SQL, R Developer Tools & Platforms: Microsoft Excel, VBA, Git, Tableau, PowerBI, Simio Web & Other: Java, React, JavaScript, HTML/CSS, Supabase, LaTeX Languages [3]: English (native), Portuguese (native), Spanish (fluent) Interests: Soccer, surfing, chess, poker, cooking

Contact this candidate