Post Job Free

Resume

Sign in

SQL, Python, Airflow

Location:
La Puente, CA
Posted:
September 09, 2022

Contact this candidate

Resume:

Jennifer Wu

909-***-****, Bay Area, CA / Open relocate

WORK EXPERIENCE

HomeLight - Data Engineer Intern Python, SQL, ES, Redshift May 2022 - Aug 2022

● Built Data Integrity Project by using SODA SQL to do backend validation and perform data quality analysis for ingestion of data from hundreds of 3rd party api partners on Redshift.

● Set daily schedule dag on Airflow that brings data from ElasticSearch and Redshift, executes tests and saves results on Redshift for monitoring, and sends alert messages to teams.

● Investigated in failed tests with over million failed records, resolved inconsistency data by developing Python scripts to fix the execution of ETL.

● Designed an analytical dashboard in Periscope that provides market intelligence. CSUF - Teaching Associate C++, Python Aug 2021 - Present

● Served as Instructional Lab Assistant for an entry level “Introduction of Programming” course.

● Served as the tutor for computer science lab courses.

● Served as a grader for a graduate level “Advanced Algorithms” course. Top Shoe - Software Engineer PHP, SQL, JavaScript, HTML/CSS, XAMPP May 2020 – Dec 2021

● Built a retail inventory Web Application with PHP and MariaDB in XAMPP.

● Developed a fully responsive frontend for users using HTML/CSS, Javascript, Bootstrap, and fetch content from the back-end by setting up Ajax scripts.

● Deployed and hosted the system on an AWS EC2 instance. EDUCATION

California State University, Fullerton Expected Graduate Dec 2022

● MS in Computer Science, GPA 3.93/4.0

SKILLS

● Programming Languages: Python, SQL, C++, C#, PHP, Javascript

● Frameworks & Tools: Docker, Airflow, Django, HTML/CSS, Bootstrap, MySQL/SQLite, PostgreSQL

● Cloud Service: EC2, Redshift, Elastic Search, S3, DynamoDB

● ML Libraries: Numpy, Pandas, Matplotlib, TensorFlow, Keras, Scikit-learn, OpenCV

● Course Knowledge: Database Management Systems, Applied Machine Learning, Artificial Intelligence, Artificial Neural Network, Advance Algorithms, Data Structure, OOP, Software Verification and Validation ACADEMIC PROJECTS

Image Recognition Machine Learning Modeling Python, Django, Scikit-learn, Keras, Tensorflow, OpenCV, SQLite

● Converted 2000+ images to RGB and GRAY arrays by using openCV and numpy.

● Developed the Machine Learning Classification Models to identify the color and category of footwear images. Used Jupyter Notebook/Google Colab platform to train data with the classifiers with 92% accuracy.

● Implemented a Django web app to integrate the frontend and classification model. Sending a predicted result request back to the frontend. Store image information in SQLite. Fake News Classification Model Python, Scikit-learn, PostgreSQL, Jira

● Responded to lead a team of three, maintained an agile board in Jira and updated the sprint backlogs.

● Collected 5,000 news headlines data from three sources in Kaggle and stored in PostgreSQL.

● Build a MLP Model to verify the authenticity of news headlines with 94% accuracy VOLUNTEER WORKS

Orchid Island Health Bureau - Public Health Promote

Jingjue Private Orphanage - Math Tutor for Kindergarten Children



Contact this candidate