Work

UC Berkeley Datahub

Analyzing 700GB of data logs from Google Cloud to verify the accuracy of metrics such as Daily Active Users (DAU) via Grafana for campus Jupyterhub.
Researching data engineering processes with a focus on preserving data privacy by implementing measures to safeguard sensitive information related to individual class selections within the campus Jupyterhub environment.

Led an Agile/Scrum team in developing a mobile Incident Management app using C# in the .NET Framework, SQL, and Vue.js.
Revitalized database modeling through the proactive integration of Entity Framework with Fluent API.
Led weekly code review sessions to ensure best practices and readability. Successfully deployed the software to a global workforce of over 1000 employees.
Automated a “Team Time Reporting” software that uses Microsoft Power Automate and DAX queries to filter over 1000 datasets from SQL and automatically sends employees with missing reports and their managers a reminder on Microsoft Teams.
Created a dashboard in Power BI to monitor real-time data for over 114 Solar Turbines bots worldwide across 14 Departments. Utilized R scripts to pull data from SQL and create 50+ data visualizations for statistics such as Health, Savings, Audit Log, etc.

Integrated the ClipDrop API to generate images from text and created file management functionality such as saving and processing client-submitted image files.
Ensured cross-origin request support through CORS integration for a seamless user experience.

Developed a REST API service for the backend of a mobile marketplace using Go (programming language).
Used SQL as a database storage to store product and user lists, and JWT for user authentication.
With 2000 users and 53 million product data, the system could support 3103 qps (browse the list of products API) and 1330 tps (login API) with an average of 300ms response time for all requests.
Responsible for developing the ”Merchant” package. Formatted Requests and Response structs in hexagonal architecture and utilized SQL queries to implement functions such as ”GetMerchantList” to get the list of merchants based on multiple filters from user input.
Coded an error handling package for an HTTP server using the validator and echo library. The code determines the HTTP status code and the error message based on the error type and sends a JSON response back to the client. Achieved 96% accuracy during testing.