Megan Kwok
Los Angeles,CA
Summary
Data Engineer who enjoys solving business problems by developing optimized and scalable data-driven solutions. Professional and educational experience with ETL pipelines, database and data warehouse design. Delighted to learn new technologies and stay updated with emerging tools.
Overview
4
4
years of professional experience
Work History
Product & Data Sourcing Analyst
CALI Floors
06.2024 - Current
- Implemented Python scripts using Pandas and Numpy for extracting and transforming product data for NetSuite loads via CSV files, improving entity creation/upload times by 73%
- Developed Powershell scripts to automate digital asset downloads, publishing over 300 new items to various retail channels (Lowe's, ACE Hardware, Wayfair, califloors.com, Builder/Dealer groups)
- Performed consistent audits to identify data governance gaps, correcting over 500 items with incorrect or missing attributes across all platforms
Software Engineer - Data (Temporary)
Vertikal RMS
06.2023 - 10.2023
- Customized reports using Microsoft SQL Server for insurance metrics, improving vendor compliance by 20%
- Optimized existing visualizations and generated new dashboards, allowing stakeholders to create clear actionable items to decrease potential liabilities/risks for vendors and their projects
Data Engineer
HBOMax
01.2022 - 12.2022
- Developed microservices in ETL pipeline for transforming raw event data streamed from Kafka to create JSON objects, improving the efficiency of queries run by stakeholders by 54%
- Conducted analysis of subscriptions purchased through third-party platforms vs. DTC using SQL queries in Snowflake
- Documented implementation/architecture changes with UML diagrams and Confluence, covering 75% of the existing codebase and optimizing onboarding time for new employees
Associate Software Engineer
SS&C Advent
08.2021 - 01.2022
- Enhanced server-side query performance by 40% by applying one-to-many relational database design principles, leading to quicker access to transaction periods for Portfolio Managers and stakeholders
- Streamlined access time to trade settings by refining Portfolio object structure, utilizing Java and entity protocols
- Optimized object-oriented models for parameter expansion, supporting faster deployments and reduced load times
- Refactored server-to-cloud data sync by optimizing data associations, leading to a 20% reduction in refresh time
Education
Master of Science - Applied Data Analytics
Boston University Metropolitan College
Remote08.2025
Bachelor of Science - Computer Science
UC San Diego
La Jolla, CA06.2021
Skills
- Python
- SQL
- Java
- Power BI
- Tableau
- Git
- Jenkins
- Jira
- Docker
- Linux
- AWS
- Airflow
- Datadog
- Microsoft SQL Server
- Apache Kafka
- Snowflake
- Databricks
- PostgreSQL
- Oracle NetSuite
- Google Cloud Platform
Timeline
Product & Data Sourcing Analyst
CALI Floors
06.2024 - Current
Software Engineer - Data (Temporary)
Vertikal RMS
06.2023 - 10.2023
Data Engineer
HBOMax
01.2022 - 12.2022
Associate Software Engineer
SS&C Advent
08.2021 - 01.2022
Master of Science - Applied Data Analytics
Boston University Metropolitan College
Bachelor of Science - Computer Science
UC San Diego
Similar Profiles
Daveta DonnellyDaveta Donnelly
BUILDING CONSULTANT at Cali FloorsBUILDING CONSULTANT at Cali Floors
Jacob AndersonJacob Anderson
Sales Manager at Cali Floors LLCSales Manager at Cali Floors LLC
Margarita CalderónMargarita Calderón
Runner at Cali N Tito's East At La Puerta Del SolRunner at Cali N Tito's East At La Puerta Del Sol
Samuel WilliamsSamuel Williams
Security Guard at Casino SecuirtySecurity Guard at Casino Secuirty
Jashawn BrownJashawn Brown
Delivery Driver at Del Rio ClothingDelivery Driver at Del Rio Clothing