Project Information Technology

YIXIN LUO

801-***-**** *********@*******.*** https://www.linkedin.com/in/esheenluo

**** *. ******* **** ** Unit B15, Midvale, UT 84047

OBJECTIVE

Seeking an internship or full-time position focused on Data/ Business Analysis, utilizing my proficient knowledge in statistics and mathematics, and further developing my analytical and technical skills to contribute profitability of the organization.

EDUCATION

Duquesne University, Pittsburgh, PA

Master of Science in Information Systems Management Expected Graduation: Jun 2017

Current GPA: 3.83

The Bachelor of Science in Business Administration, Supply Chain Management May 2014

GPA: 3.90

RELATED SKILLS & KNOWLEDGE

Database/Statistical languages: SQL, T-SQL, SSDT, SSAS, OLAP, OLTP, R, Excel

UI/UX Design: Sketch, Illustrator, After Effects, Photoshop

Web: HTML, CSS, JavaScript, XML, XSD, XSLT, Git, Visio

Programming: Visual Basic, ASP.NET

INFORMATION TECHNOLOGY EXPERIENCE & CLASS PROJECT

Data Warehouse Project – Data Analyst, Business Intelligence Class Project Spring 2017

Used T-SQL queries to correct errors and update transactions.

Employed Server Data Tools (SSDT) to Extract, Transform, and Load data from database into Excel.

Interpreted data to draw conclusions and proposed solutions by utilizing Scenario Manager and Solver in Excel to improve system efficiencies and operations.

Clemente Data Migration Project – Database Analyst, Database Class Project Fall 2016

Collaborated as a team to plan, design and develop a centralized Database for the client.

Formulated the data migration plan and developed SQL code in MS SQL Server.

Generated report of each customer’s transactions to show correct balance for each customer.

ASP.NET Web Application Project – Web Developer, IT Infrastructure Class Project Fall 2016

GitHub: https://github.com/Esheen

Created a website with five ASP.NET web pages, used an HTML form to store registration content.

Applied CSS and JavaScript to style and validate the form.

Generated an XML file to retrieve data, validated it with an XSD file and formatted it with XSLT file.

Yuchai Logistic Group Co., Ltd. – Web QA Tester, Nanning, CH 06/2015 – 01/2016

Provided clear and concise feedback on bugs, usability and other test results.

Used Sketch to design website icons and Visio to create models and diagrams.

Worked with engineers/developers to define the acceptance criteria of new features and improvements.

Contact this candidate