SQL, Data Warehouse, ETL, SSIS, R Studio, Sas, Tableau, Spss

Shuo Jia

763-***-****, *********************@*****.***, Chicago, IL, 60610

EDUCATION

DePaul University, College of Computing and Digital Media Chicago, IL Expected March 2017 Master of Science in Information System with Concentration in Business Intelligence DePaul University, Kellstadt Graduate School of Business Chicago, IL November 2014 Master of Science in Accountancy

China Agricultural University Beijing, China June 2011 Bachelor of Arts in Economic

TECHNICAL SKILLS

Languages: Python, C#

Databases: MS SQL Server, Oracle SQL Developer, MS Access, Data Warehouse, ETL, SSIS Software Tools: RStudio, SAS, Tableau, SPSS, Visual Studio COURSE PROJECTS

Regression Analysis on Boston Suburban Housing Value Fall 2015

Conducted data quality analysis and pre-processing by performing data cleaning and data transformation.

Applied Pearson correlation and feature selection methods to analyze potential important features for predicting housing values.

Performed regression modeling with logistic regression, multivariate regression and principal component analysis to fit modes explaining the most influential factors that affect housing values.

Processed multicollinearity analysis, R square, MSE and residual plots to compare different model results in order to achieve a final prediction model.

Data Warehouse ETL Project Fall 2015

Developed a data warehouse by adopting Microsoft AdventureWorks 2015 as source system and Microsoft SQL Server as ETL tool and loading target.

Designed a star schema through data source to determine efficient extraction, transformation and loading of data. System Design and Implementation Project Spring 2015

Designed a prototype sales management system that meets the proper business functions for ordering products, generating invoices, and managing inventory and annual income through creating context diagram, data flow diagram and 3NF database.

Used Visual Studio, C#, and SQL Server on database/system UI design and implementation. INTERNSHIP EXPERIENCE

The Great Books Foundation, Data Analyst Chicago, IL August 2016-January 2017

Gathered, analyzed, compared, and translated 2000 reading comprehension scores from state standardized tests into a summary written report as well as a PowerPoint presentation.

Supported Vice President on the proposal by creating visualization dashboards and charts to illustrate key facts and student performance improvements generated by their K-12 programs.

Assisted Vice President and Senior Editor with narrative on presentation delivered to cooperative school board members. LYFE Kitchen, Accounting Administrative Assistant Chicago, IL June 2014-January 2016

Managed accounts payable by using Ctuit software as the only bookkeeper for three locations of the company.

Reconciled vendor invoices with orders and posted payments for supplies and services timely and accurately.

Verified time cards to ensure all employees recorded hours according to their schedules and processed payment adjustments for all employees.

First National Assets, Property Risk Analyst Chicago, IL May 2014-June 2014

Prepared for analysis on tax lien certificate portfolios by gathering highly intensive property data through a diligence system.

Evaluated physical conditions and financial situations on 15,000 properties based on location, construction, market price, tax payable and mortgage amount.

Minimized the investment risk for management based on the evaluation. Deloitte Touche Tohmatsu, Financial Advisory Service Department Intern Beijing, China July 2010-August 2010

Participated in preparing reports and financial analysis on the M&A of a client.

Conducted research on records and reports of similar M&A cases for a project. EXTRACURRICULAR ACTIVITIES

Good Talkers Group, Co-founder and VP Treasurer DePaul University July 2014-September 2016

International Student Experience Exchange Peer Mentor Program, Mentor DePaul University September 2014-June 2015

Ladder Up Financial Liberation, Tax Preparer Volunteer Chicago, IL December 2011-May 2014

Contact this candidate