EXPERIENCE/PROJECTS
Avangrid, Inc., Summer Intern Jun 2022 – Aug 2022
Avangrid, Inc., is a leading new energy company in US with 3.1 million customers.
- Developed an ETL that fetches data from a remote API and transforms the data into Excel csv format based on requirements to specified locations.
- Reviewed and discovered multiple bugs in a system written in C#, developed unit test and regression test cases for better quality control.
- Revised a legacy system in Python with improved performance and quality and Azure DevOps for source control
- Participated in project planning and system design review
Online Game Performance Analyzer, Developer Jun 2021 – Present
Genshin Impact, a popular action game that accumulates 127 million downloads since published in 2021.
- Identified the need of serving aggregated performance data to Genshin Impact game player as reference for quick selection of character and weapons during the game
- Designed and developed ETL which downloads raw data in HTML format from a third-party public website (after their agreement), extracts usage data from using Python and BeautifulSoup.
- Performs data cleansing, normalization, and generation of derived features using Python and Pandas.
- Developed Discord bot based on their REST API definition so Genshin Impact players around world can download the report in csv format by calling the REST API.
- Code at GitHub can be provided.
Malaria Parasite Predictor, Developer Sep 2020 – Dec 2020
Machine learning Project in UMD’s Big Th!nk AI.
- Constructed and optimized a data model based on CNN.
- Malaria data is processed with Keras and TensorFlow using Python.
- Model is trained with supervised data and achieved 88% accuracy.
Facial Recognition System, Lead Developer Jun 2019 – Aug 2019
This project participated New York Young Eaglelet Scintists’ Contest and won the 4th place
- Designed and developed a smart student info web site which will filter out images that contains face of certain students per their parents’ requests.
- Designed and developed ETL to load images to AWS’s image recognition tool Rekognition with Boto3, then process and store results in a MySQL database.
- Set up a LAMP web service with web pages generated by PHP based on data stored in MySQL. Web page is written in HTML with Javascript and CSS.
