Blog No. - Total: 3538; 7days: 0; Today: 0
2017-01-25 - My one year work anniversary at MHCD! Starting Algorithms II as the celebration.
2017-01-11 - My web migrated to rkeagle.com (hosted by GoDaddy).
2016-11-11 - I created my first Android app using Android Studio.
2016-11-07 - I set up an autiomation process for transfering, restoring, backup databases between serveral servers using PowerShell and SQL Server.
2016-10-31 - I successfully loaded data from Rally to the database using Python.
2016-10-29 - My single page website demo shows computer science textbooks using Angular 1.
2016-10-27 - I used PowerShell to automatically control an Azure virtual machine for turning it on/off, transfering backup files, restoring databases etc.
2016-10-15 - Got dropdown menus for all categories for easyly editing and reading, and fixed the editing bug using a search function.
2016-10-10 - I have sucessfully completed Algorithms, Part I taught by Prof. Robert Sedgewick and Kevin Wayne on Coursera!
2016-10-02 - Added a few new features to my website such as redirecting to a page by inputting a number, and fixed a bug for editing main webpages by login as an administrator online.
2016-09-28 - I set up an email notification system for residential site mangers and their director using C#, SSIS, and SQL Server.
2016-09-05 - I found out the compitable issue between Tableau Server and SQL Server, and sucessfully migrated Tableau Server to the other server and backup all files and databases between servers using PowerShell.
2016-08-15 - New roles (SQL Server and Tableau Server Administration) were added to my position.
2016-08-08 - I set up a process for downloading email attachements, parsing pdfs, and sending emails using C#, SSIS, T-SQL, and PowerShell.
2016-07-22 - I attended Presenting Data and Information presented by Edward Tufte!
2016-07-11 - I finished CS 61B: Data Structures instructed by Prof. Jonathan Shewchuk on Youtube!
2016-07-07 - I attended Pathways to Leadership Process training II.
2016-07-01 - I designed a uploading SSIS package for transfering files to a SFTP server and set up an alert email containing all detailed information of the files by reading from the audit database.
2016-06-23 - I designed an SSIS package for transfering database backup files and restoring databases on the other server using Visual Studio, PowerShell, and T-SQL.
2016-06-03 - I designed an SSIS package for parsing JSON files to database using Python and Visual Studio.
2016-05-22 - New funcitons of my web: search function, hashed ids, email reminder on comments, and pagination limited in 10 pages.
2016-05-12 - My PHP version website is responsive now! All pages can be modified through the internet.
2016-05-08 - I made a staff table by combining three-source information using T-SQL.
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).
I have a real passion for programming and database technology.
Current company (mainly C# and SQL Server):
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.
• 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.
