David Lee

United States

@davidleelhw

Badges

Python
Sql

Certifications

Work Experience

  • Software Engineer

    AstaTech•  November 2019 - Present•  PA, US

    Designed and optimized ETL pipelines using Python, SQL, and AWS Glue, automating data ingestion and transformation for scalable analysis in AWS Redshift, reducing processing time by 20%. Streamlined report generation by automating pipelines with Python, SQL, and Power BI, cutting report generation time significantly. Led system upgrades integrating CRM, order management, supply chain, and analytics, improving business efficiency.

  • Data Analyst

    City of Fort Collins•  September 2019 - July 2020•  CO, US

    Analyzed and visualized large public datasets, transforming complex data into easily understandable charts for the City of Fort Collins. Developed dashboards to communicate findings on various public projects.

Education

  • Colorado State University

    Computer Science & Engineering, MS•  September 2017 - May 2019

Skills

Git
GitHub
Linux
Power BI
Jira
MySQL
AWS RDS
AWS Redshift
AWS Lambda
Python
SQL
AWS (Amazon Web Services)
Data Structure