Sofia Laval Email & Phone Number

California, United States

• 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 discovery for leadership decision-making• 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