Kenneth Yao Email & Phone Number

New York, United States

- Conducted daily DQI/KPI evaluation to improve data quality by using PostgreSQL, Excel, Python REGEX to write queries and detect patterns in our database- Generated reports to visualize a high-level overview of a newly imported client, such as agent name, brokerages, sales of each brokerage by year, geolocation, count of unique clients etc.- Created visualizations in Whimsical- Documented all progress and notations in separate Notion documents to emphasize coordination and organization in my work- Contacted the director of finance from Restb.ai, conducted research, and generated a Capstone presentation to depict findings such as cost of API token, potential use, similar market products, automation of API ETL pipeline- Partially automated the generation of our company's ERD using Mermaid, Python, Notion, Juypter Notebook, Redash, and Excel

New Haven, Connecticut, United States

- Increased the number of clients served by 66% by utilizing MySQL, Power BI, and Excel to collect, clean, and visualize data from multiple sources within the PantrySoft database- Applied excel analysis skills, such as VLOOKUP, heatmaps, complex formulas, and pivot tables, to demonstrate tracked KPIs and extract insightful information to present at business meetings- Reformed a single-server queuing system to increase service performance by 800%