INTRODUCE MYSELF

I want to build a Tao follows nature society. Please hire me.

I was born in Huadian city, Jilin province, China, a beautiful city in Northeastern China.

I got my PhD degree in Physical Chemistry from University of Tennessee in December 2012.

I am a Microsoft certified tech for database technology (MCSA, MCSE) and web development (MCSD).

MY EXPERIENCE

I have a real passion for programming and database technology.

Current company (mainly C# and SQL Server):

• Support the core system.
• Finished the paper claim enhancement project.
• Finished call qualifying enhancement for a Windows Form application.
• Added several new functions for a claim adjudication application (VB6).
• Finished notes migration for a Windows Form application by following CRUD principle.

Previous company:

•  Created an intranet website using C#.NET and SQL Server. Set up everything on an IIS server. It is domain-driven, responsive, dynamic. The layout of the website is controlled by database tables for less effort on maintenance. It is for collecting data and displaying Tableau dashboards. There are several good features: upload and paste images in the text editor using user-defined methods without using comercial software, uplaod mutiple files from different directories and remove files, different people see different web contents, sending email with attachments, anonymous data collection etc.

•  Created a data transfer & sync software for Coupa and Microsoft Dynamics NAV using C# and SQL Server. It mainly transfers invoices and expense reports between the two. It guarantees data flow and reports failure to accounting staffs. When they fixed the issues, the correct invoices or expense reports will be transferred to NAV from Coupa. The failure cannot affect the data flow.

•  Created an Angular 7 + Java Spring Boot application for API, data collection and presentation. The original idea is just to prevent Tableau Server crash because one simple dashboard was read 10000 times a day. Since this web application displays the data directly, it frees up Tableau Server. I love this modern design alot, and add more and more features to the application such as angular integration, logging, security etc.

•  Created an Alexa application for displaying Tableau dashboards using C#.NET and Azure SQL.

•  Created a C# application for manipulating users' emails, calendars etc. using Microsoft Graph.

•  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.

•  SQL Server and Tableau Server Migration: all are in production, and no mistakes, short downtime due to DNS lagging.

•  Eliminated duplicates in several main stored procedures. One table has millions of rows.

•  Set up a Hadoop system on distributed Linux servers.

Personal projects at my spare time:

•  Developed several websites and applications using C#, PHP, Java, JavaScript, Node.js, Angular, React, SQL Server, MySQL, Mongodb etc. Please see demos from the Projects dropdown list.

•  Rewrote 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 and Hackerrank 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 Pluralsight, Safari Books Online, Lynda, and Coursera.