Tianchan (Sylvia) Deng

** *. ******* ****, *******, IL 60604 • 757-***-**** • acyw6s@r.postjobfree.com

Business Intelligence Analyst

Dedicated and innovative professional with related education, practicum, and experience to contribute to long-range operational objectives in a Business Intelligence Analyst role. Self-motivated achiever who works well independently and as a member of a team. Able to explain technical concepts clearly to non-technical team members.

Core Competencies

Data Analysis

Variable Selection Method

Model Transformation

Data Processing & Structuring

Quality Assurance and Testing

Regression Model Design

Fit Modeling

Cost and Projection Modeling

Core Skills

Languages:

Python, C#

Database:

SQL, Microsoft Access, Microsoft Excel

Data Analysis:

R, SAS, Tableau, SPSS, Hadoop, Microsoft Dynamics AX

Educational Background

Master of Science in Information Systems Concentrating in Business Intelligence – 2016

DePaul University, Chicago, IL

GPA:3.6/4.0

Bachelor of Science in Business Management – 2014

Old Dominican University, Norfolk, VA

Experience Highlights

China Lending, Urumqi, Xinjiang, China

IT Administrator 7/2016 – 9/2016

Assisted in design, implementation and operational effectiveness assessments of operating system control. Collaborated in the design of absence and leave management system, drafting management hierarchy for flow of requests. Translated legal documents, contracts, consulting agreements, and management duties.

Assisted in drafting a successful proposal for construction of financial plaza, which received approval from the Chinese government.

Tagwire Media LLC., Chicago, IL

Database Administrator 6/2015 – 8/2015

Assisted with database management and filtering of information, updating information from active users. Supervised all social media accounts for Tagwire Media, producing weekly content on each platform to increase exposure.

Corrected, edited, and uploaded thousands of database entries weekly ensuring database would be ready for application launch in the iTunes App Store.

Bank of China, Urumqi, Xinjiang, China

IT Analyst 11/2014 – 1/2015

Monitored and analyzed client business information using BI Dashboard from Oracle. Updated and maintained management team and client information within the system. Updated account information daily and reported findings to supervisor.

Developed and updated database with collected information from clients to produce client status reports.

East Virginia Medical School, Norfolk, VA

Research Analyst 9/2013 – 5/2014

Conducted research and reported findings at weekly health topic discussions. Assisted in the monitoring of patient blood sugar levels using portable medical equipment.

Assisted preparation of teaching materials for Distance Learning and Instructional Technology Program.

Projects

Online Pizza Ordering System

Designed pizza ordering application using C# and SQL utilizing 5 separate system users per order.

Road Construction Bidding Regressive Model

Designed regression model to track and establish benchmarks for bid-rigging. Tasks include Model Transformation, Fit Model, Variable Selection Method, and Prediction.

Chicago Crime Data Project

Utilized Tableau and R to analyze crime data from a time-series and geographical standpoints to determine crime rate and develop crime prediction models.

Contact this candidate