Sally Lee Email & Phone Number

Los Angeles, CA, US

Building custom web applications and backend data infrastructure to support our Investment Group -- in an agile, startup-like environment.

Los Angeles, CA, US

• Throughout the 2-year program, I was given the unique opportunity to work in three distinct areas of Capital Group's technology organization, each for an 8-month rotation.Data Engineer - Enterprise Data Platform:
• Wrote custom, business-logic based PySpark processes to support new cloud-based data platform, transforming our existing SQL-based ETL pipelines to be optimized for cloud infrastructure
• Contributed to the development of a PySpark job execution framework to be used by all teams across the Data Engineering group
• Developed end-to-end data pipelines, taking data from a delimited file to Parquet to external tables to physical tables
• Developed user-ready, proof-of-concept web app in 8 weeks to enable users to see list of potential clients and reasons to contact them. App was built using React with Hasura GraphQL Engine + Python backend, deployed on.
• Technology/Languages: Python, Spark, Azure DataLake, Cloudera Hive/Impala, SQL (Azure SQL DW, SQL PDW, SQL/T-SQL), Unix Shell, Autosys; ReactJS, Hasura, OCPProduct and Enterprise Architect - Client Experience.

Los Angeles, CA, US

• Designed and built web-based portal using ASP.NET framework to execute automated functional tests for applications and view reporting for executions, allowing real-time updates in testing results
• Integrated the web portal with existing testing framework including several REST APIs and multiple databases using AJAX, Javascript, and Entity Framework
• Introduced the web portal to senior leaders both within and outside the testing organization
• Designed a program in R to traverse a graph and find unique paths more efficiently than a random graph walker, supporting a larger effort to use machine learning to automate regression testing

London, England, GB

• Performed statistical analysis and QA on brand assessment study to determine preliminary results for use in campaign reporting to the client and internal performance analysis
• Researched and created POVs on topics of company-wide interest to assist other teams in scoping out vendors in new spaces and determining the best partners to work with
• Built digital dashboard with data visualizations for regular reporting to planning team for analyzing spend, delivery, and overall campaign performance

Los Angeles, CA, US

• Assistant in Professor Suzanne Paulson's research working on determining investigating components of particle matter to determine which are response for production of reactive oxygen species
• Performed statistical analysis using JMP, StatPlus, and Minitab Express on urban aerosol particle data to determine correlations between reactive oxygen species and components in particle matter that could be.