Tianyun Gao: Canon USA

Soon after her time with NYU, Tianyun Gao began working with Canon USA in New York during March of 2012. She maintained the same title of Business System Analyst from her prior gig, but her responsibility increased in tandem with her experience level increasing as well. Her duties consisted of the review and reproduction of various system and programming code, developing new systems for more efficient data transfer, creating new systems for better cataloguing, and producing shell scripting that created automatic system services..

Tianyun Gao

Tianyun Gao

Tianyun Gao used her knowledge of reviewing and reproducing ASP code and created a web application that could be used by business customers of Canon to view and register product model numbers and disclosure via the Mercury system. She also developed back-end Mercury systems through the use of C++ and Pro*C. Her work allowed efficient data transfer between the Canon America’s Mercury system and the Canon Inc. Master Mercury system in Japan.

Tianyun Gao also developed an Oracle database using the PLSQL of the Mercury system that catalogued products with detailed item and model number information that could be transferred between the Mercury system and other Canon systems. Alongside these developments, Tianyun Gao produced Unix bash/corn shell scripts that allowed back-end process operation, system checking, and the scheduling of various auto-system jobs. Lastly, Tianyun Gao was successfully able to carry out batch data loading through the use of the Perl programming language that also allowed for the system to automatically conduct performance tuning and reporting on its own.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s