Data Analysis, Business Analysis, Information System

Liuyuan Chen

***** ********* ******, ******, ** 313-***-**** ********@*****.***

SUMMARY OF QUALIFICATIONS

Information Systems and Technology graduate student with academic training at the University of Michigan. Hands-on experience on business analysis, process management modeling, data analysis and visualization, and system engineering skills. Skills & Knowledge base include:

Big Data Analysis & Visualization: Tableau, Power BI, Minitab, Microsoft Excel, Microsoft Access, Prezi

Process Modeling: SAP, Architecture of Integrated Information Systems, Microsoft Visio

Languages: SQL, HTML, CSS, XML, PHP, JavaScript, Java, JSON, PERL

EDUCATION

University of Michigan-Dearborn

Master of Science: Information Systems & Technology GPA: 3.5 Jan.2016 ~ Dec.2017

University of Michigan-Dearborn

Bachelor of Business Administration : Finance

GPA: 3.36

Sep.2013 ~ Aug.2015

PROFESSIONAL EXPERIENCE

IT/Data Intern-Specialist

Detroit, MI

@Solutions for Energy Efficient Logistics LLC 08/2016 -04/2017

• Created a tool using Excel VBA that automates the retrieval process of data and improved up to 30% in

efficiency gains in operation routing process under SEEL digital platform

• Performed data querying, data analysis, data scrubbing and took an initiative to build data visualization

dashboard on Power BI for regular Appliances Recycling Program reporting to the client

• Managed SharePoint, sever storage and troubleshot Active Directory, Group Policy, DNS, other network

services and infrastructure issues

Limited Project Coordinator/Financial Advisor

Taizhou, JiangSu, China

@TSA (SZTX) Antenna Co. 05/2015 -09/2015

• Administered and organized relationship activities with current and potential cooperated suppliers

• Provided supports on financial reports, captured, determined and analyzed long-term feasibility and forecasting

• Managed antenna products stability and quality performance warranty issues with cooperated FCA Group

Volunteer Income Tax Assistance Program

Detroit, MI

@Accounting Aid Society 01/2015 -09/2015

• Communicated effectively with clients gathering tax requirements and secured documentation to provide income

tax preparation service to low and middle income individuals and families

Financial Analyst Intern

Zhongshan, Guangdong, China

@Guang Yong Futures Co. Limited 05/2014 -06/2014

• Open new customer accounts and built a positive rapport in a fast-paced environment

PROJECT

Multivariate Statistics-Bike Production Data Forecasting (Tableau, Minitab, Excel)

• Studied 2 years total bike users parametric data and preprocessed the data by scaling and transforming

• Used ARIMA models to test and diagnose the teste values on developed training and model testing

• Used optimized model by processing residual to provide daily, weekly, and monthly forecasts

• Provided forecasted data visualization in Tableau

Business Requirement Modeling (ARIS, Visio)

• Effectively defined and translating business requirements into IT terminology by using UML

• Strategically analyzed the business process by designing software module, network location, organization

hierarchy chart, flow chart, function-data allocation diagram and EPC model

• Created SPMP and documented use case summary and specifications and designed tracking and control

mechanisms to mitigate and monitor project functions, ROI, risks and schedule

Production and Operation Management-BioPharma Optimal Production Allocation Design (Excel)

• Studied on building statistical models for optimal production allocation planning, analyzing production costs and

constraints by utilizing Solver

Contact this candidate