Charles' Website

QI SUN (CHARLES) PhD

U.S. Citizen

charlesqieagle@gmail.com

Extensive experience in data collection, analysis, and presentation using C#, Java, Python, SQL Server, MySQL, Hadoop, SSIS, PowerShell, Tableau, SSRS etc.
Extensive experience in web development using C#.NET, Java Spring MVC, PHP, Node.js, SQL Server, MySQL, JavaScript, HTML, CSS, jQuery, Bootstrap etc.
Extensive experience in SQL Server, Tableau Server, and Azure administration.
Strong skills on numerical methods such as regression, optimization, partial differential, integral etc.
Solid knowledge of Machine Learning, Algorithm, Data Visualization, Modeling, Forecasting etc.
Solid knowledge of Mathematics, Statistics, Physics, Chemistry, Optics and Engineering.
Strong team oriented and willingness to collaborate with other people.

Computer Language: Java, C#, SQL, C++, Python, PHP, JavaScript, R, PowerShell etc.

Operating System: Windows Server, Linux, Azure Virtual Machine, Docker etc.

Language: Chinese (Mandarin), English

Data Engineer & DBA, Mental Health Center of Denver, Denver, CO Jan. 2016 – present

Research associate, University of Colorado, Boulder, CO Jan. 2013 – Jun. 2015

Developed data and image analytical methods using Matlab, Python, C#, SQL Server
Conducted Finite-difference time-domain (FDTD) simulation using Matlab, Python, DDSCAT
Visualized data using Matlab, Python, Origin, Excel, Photoshop, ImageJ, Solidworks
Used Labview to control a home-build photoluminescence setup
Investigated optical and electronic properties of metals and semiconductors

Research assistant, University of Tennessee, Knoxville, TN Aug. 2007 – Dec. 2012

Teaching assistant, University of Tennessee, Knoxville, TN spring and fall, 2010, and spring 2012

MAIN PROJECTS

PDF parsing and emailing system: it is a unique feature compared to other health centers in Denver.
Developed ETLs for easy maintenance, disaster prevention, email notification, warehouse statistics, parallel execution, automation, continuous integeration etc.
EDI (837, 835, 271 etc.) parsing: our vendor Netsmart cannot do it. I finished the projects on time.
Internal website: I set up everything on an IIS server. It is domain-driven, responsive, dynamic, maily single-paged.
SQL Server and Tableau Server Migration: all are in production, and no mistakes, short downtime due to DNS lagging.
Alexa development: it was developed using C#.NET and Azure SQL for displaying Tableau dashboards.
Eliminated duplicates in several main stored procedures. One table has millions of rows.
Coupa-NAV integration. The process guarantees that it can resume at any failure points.

PERSONAL PROJECTS

Developed several websites using C#, PHP, Java, JavaScript, Node.js, Angular, SQL Server, MySQL, Mongodb etc. Please see demos from the Projects dropdown list.
Wrote Machine Learning codes using Python 2 and 3 + unittest from the Coursera course. I also added GUI for better interface for Linear Regression.
Rewrote the Java source codes from the Algorithms I and II on the Coursera using C# + Unit Test.
A lot of SQL and database administration practices for SQL Server, MySQL, Hadoop etc.
Solving LeetCode problems using Java, C++, C#, Python, JavaScript + Unit Test (still in progress).
Created an Alexa App on Azure to show different websites on the single webpage. No need to refresh the webpage manually.
Cloud development and administration on Azure and AWS.
Learned Linux and Windows Servers by taking courses and practices.
Took a lot of courses (including algorithms, web development, database technology, statistics etc.) on Coursera, Lynda, and Pluralsight.

PhD, Physical Chemistry, University of Tennessee, Knoxville, TN Dec. 2012