Jingting Chen — Software Developer with a Computer Science Master’s Degree and Experience in Turning Data into Insights.

Data Analyst Skills

Excel | SQL | Power BI | Tableau

Software Developer Skills

HTML | SCSS | Javscript | TypeScript | Angular Material | Angular | Node.js | Express.js | Mysql | AWS | Git | Linux

Selected Data Analysis Projects

Power BI Projects

Hospital Insights on Visits Costs Coverage and Demographics

Data analysis of over 1000 patients from a leading Massachusetts hosptial (2011-2022), covering demographics, insurance coverage, and medical procedures.

North American Grocery Analysis

Analysis of 1997-1998 North American grocery market data, focusing on sales performance, profitability, and return rates.

Tableau Projects

Mexican Restaurant Ratings

Analyzed 2012 Mexican restaurant ratings using real consumer data, examining how customer demographics and preferences (age, budget, lifestyle, and location) and restaurant attributes (cuisine type, price range, services, and geography) influence customer ratings.

Bank Customer Churn

Analyzed churn behavior of 10,000 European bank customers, identifying key factors influencing churn such as geography, age, credit score, account balance, tenure, product usage, and customer activity.

MySQL & Excel Projects

US Baby Names Analysis

Analyzed U.S. baby name data over three decades using MySQL and Excel, uncovering trends in name popularity, gender usage, and regional variation. Presented the results through an interactive Excel dashboard, enabling users to easily explore long-term naming trends across genders and regions.

Manufacturing Downtime Analysis

Analyzed productivity and downtime data from a soda bottling production line to uncover operator performance gaps, product efficiency differences, and key downtime drivers. Transformed raw batch-level data into interactive Excel dashboards, providing actionable insights to support data-driven production optimization.

Selected Software Developer Projects

BMI Weight Assistant

BMI Weight Assistant allows users to record their daily weight and calculates their BMI and body fat percentage based on their gender and age.

Get In Touch