Information Technology Data Analyst

Yiling Li

213-***-****; **** Haverwood Ln, Dallas TX 75287 ***********@*****.***

SUMMARY OF QUALIFICATION

Three years’ professional experiences in SQL, R, Tableau, Visio, data analysis and visualization.

Technical skills: Access, Excel, Word, Power Point, Visio, SAP Business Warehouse, Tableau, Crystal Report, SQL, SSAS, SSIS, SAS, VBA, R, Java

Curriculum: Accounting, Corporate Finance, ERP Systems, Statistics, Marketing Management, Business Data warehouse, R programming, Data visualization

BUSINESS EXPERIENCE

Quicken Loans, Detroit, MI

Business Analyst Intern June 13th 2016 – August 12th 2016

Bridged between business and engineering team, identified title source’s ERP platform bottleneck for 20 business teams through requirements gathering and extensive SQL data mining

Calculated historical pipeline volume for all business teams through SQL data pull

Optimized the stored procedures for UAT partners and generated business intelligence report using R and SQL, subscribed daily by 35+ business team

Provide weekly KPI monitor report to related business teams

Planed and prioritized production system development projects for 14 business leaders and proposed solutions to improve system efficiency

Sherwin Williams, Cleveland, OH

R&D Data Analyst (engineer) July 25th 2011 – June 5th 2015

Helped SQL database star schema design, built data input, maintained data integrity and monitored products’ key factors

Analyzed risk model for commercial products portfolio, troubleshoot and monitored pipeline conditions

Liaised between sales team and customers, presented project results and report using Tableau and R

Conducted statistical researches to collect testing data, cleaned and visualized data via excel Tableau

Developed root cause analysis for raw material expense and commercial products projects, verified and balanced by real testing results data

Shell Ltd China May 10th 2010 – August 6th 2010

Engineer Consultant Intern

Delivered and sold a $2 million refinery kits to clients

Coordinated bi-weekly meetings with clients and provided technical support EDUCATION

The University of Texas at Dallas May 2017

M.S., Information Technology Management

University of Southern California May 2011

M.S., Chemical Engineering

ORGANIZATIONS

SAP User Group, The University of Texas at Dallas -Active member September 2015 – Present MIS Club, The University of Texas at Dallas -Active member September 2015 – Present Toaster Master, Sherwin Williams-Timer August 2013 – June 2015 Project

Case study of a mortgage company’s different products and profit model Optimize the portfolio achieving goal of minimizing risk given certain return ratio or maximizing return at certain risk rate

ADDITIONAL INFORMATION

Eligibility: H1B visa on hold, reactivation needed without lottery process

Contact this candidate