Sofia Laval Email & Phone Number

• Develop and optimize Tableau dashboards for performance monitoring and reporting
• Perform web scraping and API integration in Python to collect data for enhancing gpt-4o chatbot responses by retrieving relevant information during user interactions
• Create Azure machine learning pipelines and implement solutions for pipeline failures
• Migrate clients from Microsoft SQL Server to a cloud-based database by connecting to their local databases, using Python scripts to run SQL queries to extract tables, and feed the data into the new system

• Client: Stibo Systems
• Reduced verification time for sustainability experts by deploying a GPT-3.5 chatbot that streamlines the manual verification process for IT products with ESG certifications and provides certification predictions
• Collected, pre-processed and cleaned data sets (110k rows and 300 cols), implementing data imputation methods to handle missing values, ensuring accurate and up-to-date information for retrieval augmented generation

• Developed, optimized, and deployed a machine learning model in GCP from end to end to discover prospective customers to increase brand awareness for the marketing department
• Communicated across team stakeholders to identify and track performance metrics related to pharmacy coupon usage, leveraging insights to generate Tableau dashboards for continuous monitoring and supporting insight.
• Engaged and actively supported the data pipeline from data sources, data cleaning and database querying

Austell, GA

• Worked with a team of consultants to develop and execute data-driven strategies for warehouse optimization, including the implementation of lean inventory management practices and reconfiguration of storage layouts
• Collected inventory measurements to optimize warehouse space
• Identified and implemented inventory attributes and metrics in the warehouse management system

• Client: Delta Air Lines
• Won best overall project in Industrial & Systems Engineering out of 23 teams at the GT Capstone Design Expo
• Worked with the In-Flight Services team to address the over-supplying issues of beverages occurring across the network. Performed a data collection study and identified 70% beverage items return unused
• Delivered an optimization model using TensorFlow that calculates optimal beverage quantities depending on the aircraft and flight route
• Provided an Excel tool that reports the value of implementing these optimal quantities. For example, removing 2 beverage carts on a 739/E aircraft saves $180,594 annually, cutting CO2 emissions by 8.2 tons

Greater Atlanta Area

• Tutored elementary through high school students in various subjects, especially in mathematics, the Secondary School Admission Test (SSAT), and the SAT/ACT
• Created individualized learning strategies and sessions for students to ensure their academic success

• Created grading rubrics for R-based assignments, evaluating the submissions of 100 students and serving as the primary point of contact for clarifications and inquiries
• Reinforced fundamental regression and forecasting concepts to students

• Assisted the fundraising staff with administrative and receptionist duties, such as documenting monthly donations in Excel and utilizing development systems
• Provided customer service to office visitors and donors by answering phone calls and in-person inquiries

• Created and deployed a forecasting model that predicts daily passenger volume to provide actionable insights to leadership for staffing purposes, achieving an 8x improvement compared to the existing model
• Developed 3 KPIs for leadership to assess customer wait time and satisfaction by conducting a time study analysis over a 3 month time span
• Measured and analyzed daily station performance, including inbound and outbound flight metrics such as on-time departures, delays, cancellations and other indicators, using SAS and Excel

Master Of Science - Ms, Analytics

Computational Data Analytics Track GPA: 3.81/4.0

Bachelor'S Degree, Industrial Engineering

Concentration: General Industrial Engineering GPA: 3.79/4.0