Seo Ho Yi
Corvallis
Summary
Data Engineer specializing in designing and maintaining data management systems. Expertise in database design and data mining, utilizing machine learning to drive business decisions. Achievements include optimizing data retrieval processes and enhancing system efficiency.
Overview
8
8
years of professional experience
Work History
Data Engineer
Alaska Airlines
Seattle
06.2024 - Current
- Designed, built, and optimized scalable ETL pipelines in AWS Glue and Apache Spark, handling over 100M rows of structured and semi-structured data monthly across reservation, loyalty, and operations domains.
- Migrated legacy data workflows to a cloud-native architecture on AWS (S3, Redshift, Lambda), reducing latency in analytics reporting by 45% and cutting infrastructure costs by 20%.
- Collaborated with cross-functional teams (Data Science, Revenue Management, and Operations) to integrate flight operations data into a central analytics platform, enabling real-time insights for delay prediction and resource allocation.
- Developed robust data quality frameworks using Great Expectations and Airflow, improving data reliability and reducing incident response times by 30%.
- Partnered with cybersecurity and compliance teams to implement data governance protocols using AWS Lake Formation and IAM, ensuring full SOC 2 and GDPR compliance for passenger data.
FullStack Developer Contractor
Alaska Airlines
Seattle
05.2023 - 06.2024
- Developed and maintained web and mobile products, improving user experience and functionality.
- Increased accessibility scores for web/mobile products, ensuring compliance with industry standards.
FullStack Developer
Verisk
Jersey City
09.2022 - 05.2023
- FlightKit, is an application designed to assist Verisk’s insurance field representatives to create a detailed log of the building’s structure and the hazards it may face when insured. Using the application the representative can quickly assess the building and get a brief overview of the cost to insure the buildings that they are inspecting.
- This project was split into two parts, the UI team, and the Scopes team. The UI team dealt with the necessary visual features of the application whereas the scopes team primarily worked on the calculation engine of the application. Being a part of the UI team, helped design the walls and floors, as well as the occupancy features of the application using XAML.
- Applications logic was built using VB on the ASP.NET framework. Used Blazor with .NET MVC extensively to create dynamic pages. Performance testing was run through MS test with MOQ framework. Bamboo CICD was extensively used for project integration and deployment.
Full Stack Developer
Tesla
Fremont
06.2020 - 08.2022
- Service Production Change Approval is designed to keep a detailed log of services to demonstrate that the design and production process will meet the client's requirements. Using the application, the servicemen can ensure that the supplies/parts required to repair, refurbish a vehicle is in stock and will meet the manufacturability and quality requirements. It also will provide evidence that the customer engineering design record and specification requirements are clearly understood and fulfilled by the supplier. Finally, it aids to demonstrate that the established service process has the potential to produce the part that consistently meets all requirements during the actual service production run at the quoted production rate of the process.
- This application has multiple modules which are Critical attributes, Non-Critical attributes, Interchangeability notes, Production Reporting, and Service Records. Helped design attribute loading forms for the Critical attributes, Non-Critical attributes, and Interchangeability notes using Angular.JS.
- Applications logic was developed using C#. Built on ASP.Net Core framework. Jenkins CICD used for fast integration and testing purposes. EF Core was used to realize object-relational mapping.
- Developed stored procedures, views, and triggers for data manipulations. Used MS SQL and MySql extensively for backend and query optimization.
FullStack Developer(intern)
Hana Bank
Seoul
05.2017 - 08.2018
- Expense Reporting is an internal application, provides administrators with a clear picture of the organization spending through automated analytics and reporting. It is to track and approve workforce-related costs, create new reports and modify existing ones, add or delete specific expense items, and leave comments.
- Developed web-based application using ASP.NET MVC, C#, Web API2, HTML5, CSS3, Entity Framework and Bootstrap.
- Implemented Action filters such as Authorize, OutputCache, ErrorHandle to handle specific behavior of each controller.
- Developed ASP.NET Web API2 controllers that involved implementation of service layer, data object layer components and provided security using OWIN authorization.
- Developed CRUD operations between the web application and database using Language-Integrated Queries (LINQ) with Lambda Expressions in C#.
Education
Master of Science - Computer Science, Data Engineering
Campbellsville University
Louisville, KY12.2023
Bachelor of Arts - CS, Economics, Mathematics, German
Kalamazoo College
Kalamazoo, MI11.2020
Skills
- C# and C
- Java
- Python
- JavaScript
- Swift
- Ruby
- Kotlin
- Visual Basic
- SQL Server and Oracle Database
- NET technologies
- ASPNET Core and Entity Framework Core
- LINQ queries
- Web APIs and Blazor framework
- Reactjs and Angular 17/18
- TypeScript
- HTML5 and CSS3
- jQuery and Bootstrap
- Visual Studio (2017, 2019, 2022) and VS Code
- SQL Server Management Studio (SSMS)
- Postman API testing
- git version control
- Azure cloud services and AWS cloud computing
- task management with TFS and JIRA
- Agile methodologies and Waterfall model
Timeline
Data Engineer
Alaska Airlines
06.2024 - Current
FullStack Developer Contractor
Alaska Airlines
05.2023 - 06.2024
FullStack Developer
Verisk
09.2022 - 05.2023
Full Stack Developer
Tesla
06.2020 - 08.2022
FullStack Developer(intern)
Hana Bank
05.2017 - 08.2018
Master of Science - Computer Science, Data Engineering
Campbellsville University
Bachelor of Arts - CS, Economics, Mathematics, German
Kalamazoo College
Similar Profiles
Pablo Enrique Medellin SuarezPablo Enrique Medellin Suarez
Line Maintenance Mechanic at Hawaiian Airlines/Alaska AirlinesLine Maintenance Mechanic at Hawaiian Airlines/Alaska Airlines
Amanda OstranderAmanda Ostrander
Reservations Supervisor at Alaska AirlinesReservations Supervisor at Alaska Airlines
DAVID LAGERDAVID LAGER
Ramp Agent at Alaska AirlinesRamp Agent at Alaska Airlines
Laulea Kukonamuaokala Malaea DurantLaulea Kukonamuaokala Malaea Durant
Customer Service Agent at Alaska AirlinesCustomer Service Agent at Alaska Airlines
Caleb-Gregory RobinsonCaleb-Gregory Robinson
Laborer at Aloha Roofing & RemodelLaborer at Aloha Roofing & Remodel