weechien

Developed B2B dashboards from the data team's analyses using Next.js and Tailwind CSS. Maintained Yearn Finance's main web app to give the best UX and enabled users to seamlessly connect to various protocols' wallet to view their investment portfolio. Analysed wallet activities such as deposits and transfers between Yearn vaults using Jupyter Notebook. Maintained vault strategies from various protocols with their given risk levels and expected returns. Built data pipeline that ingests data from The Graph and piped the transformed data to the database for further analyses, and the findings would be presented in a dashboard.

Collaborated with an Agile team to develop the web app's features including saving as draft, digitising paper forms and mail merging announcements using React and AWS. Set up infrastructure for file upload and storage, including permissions, audit and logging using Terraform for multiple environments. Designed database schemas and indexes, prepared migration files, and tested the performances of the newly implemented schemas. Built and maintained software documentation sites using Confluence and Swagger. Wrote unit, integration, API and E2E tests using Jest, Cucumber.js and Nightwatch.js. Configured CI/CD pipelines for multiple environments using Bamboo.

Developed web app for machine learning (ML) models’ upload, training, inference and reporting using React, Django and TensorFlow. Deployed and managed containerised app using Docker and Kubernetes. Built a GraphQL API server and designed its schemas and resolvers using TypeGraphQL and TypeORM, and integrated it with the Apollo Client.

Built ETL pipeline to store transformed data in Excel for the team to generate reports. Automated Excel data cleansing and processing using Visual Basic and Python. Prepared and analysed management reports to incorporate trends into forecast models. Built management dashboards using React, MySQL, Tableau and Power BI.