Yiyan Zhao

781-***-**** ac1wql@r.postjobfree.com MA 01610

Data Analysis Business Intelligence Systems Analysis and Design Web Development Project Management Market Analysis

Data Analytics: Analyzed 551 ServiceNow applications and over 2000 Nagios configures of UMass Memorial Medical Center to enhance its IT monitoring system by using Excel, MS Access and SQL.

Business Intelligence: Maintained the database of Bank of China and making reports by using OBIEE.

Project Management: Analyzed requirements, made preliminary design and track the process by MS Visio and MS Project.

TECHNICAL SKILLS

Programming Languages:

Python, SQL, HTML, CSS, JavaScript, Java, C++

Database Management:

MS Access, MS SQL Server, Apache Server, Hadoop

Analysis Tools:

MS Office, Excel, Access, Oracle BI Tools, Microsoft Visio, Tableau, MATLAB, ArcGIS, Photoshop, ServiceNow, Nagios, ERP

Operating Systems:

Mac OS, Windows XP/07/08/10, Linux

Others:

Familiar with Waterfall and Agile Development Process, Market Strategies, Gamer

Language:

English, Mandarin

Professional Projects

Analysis of UMASS IT Monitoring System 2017

Designed an enterprise-wide unified standard for IT monitor system to deal with the outages, application tracking and responding of UMass Medical Center that has one of the largest healthcare system in MA.

Analyzed data of the legacy system, identified the corresponding items of the whole system and figured out the gaps between applications running and maintain.

Categorized 551 applications in 28 categories and gave solutions to improve current situation.

Database Management of a Restaurant 2016

Created a Database for the restaurant to record the inventory include suppliers and consumers by using MS Access and SQL.

Design a user interface for the database.

Maintained and updated the database regularly.

10 Years Market Entry Plan for an International Toothpaste Company 2016

Compared different situation by analyzing the data of each counties’ market include materials, labor, transportation fee, tariff and competitors.

Formulated a detailed entry plan with price variation, distribution and promotion.

Calculated brand awareness and net profit.

Programmed Chinese Word Segmentation Algorithms of Search Engine 2014

Used Java to design an algorithm to analyze words, phrases and sentences in the searching bar.

Had a more than 98% accuracy that matched the correct answer.

Professional Experience

BI Consultant at Project Team in Bank of China 2015

Participated in Business Intelligence Platform developed by using Oracle BI Tools (OBIEE) for Bank of China.

Database Administrative: Maintained the database system, dealt with database break-down and updated.

Business Analysis: Assisted sales representatives to finish reports and solved technical issues of using BI Tools.

Customer Requirements Analysis: Use Excels and BI Tools to analyze bank customer’s requirements include investment, deposit and loan. Made reports to manager.

Assistant at Research Center of Ministry of Public Security for Road Traffic Safety 2014

Project Management: Recorded regular conferences, track project and deal with multiple tasks. Assisted in managing public serving platform, real-time feedback and WIDPS (Web information Dynamic Public System).

Education

Master of Science, Major in Information Technology, Clark University 2017

Courses: Business Intelligence, Systems Analysis & Design, IT Strategy Leadership, Cyber Security, Geographic Information System, International Marketing

Bachelor of Science, Major in Computer Science, Beijing University of Technology 2013

Courses: C++, Java, Software Development, Software Quality Test, Web Design, Mathematic Modelling, Game Design, Project Management, System Development, Database Management, Data Structure, System Architecture

Experience in School:

Sports Department of Student Union, Department Head, 2010-2013

Organized annual sports meeting, basketball games and other sports competitions

Beijing Marathon, Volunteer, 2012

Provided directions to competitors and audiences

Pioneer Practice Association, Secretary, 2010-2012

Assisted in organizing university activities, such as the BJUT Singer Competition and E-sports Games

Invited other institutes to hold activities in our university and corporate sponsorship

Created practice opportunities for students and connected them with the society

Bio

Sports enthusiast Game Player Outgoing Responsible Team Worker

Contact this candidate