Education

MS Computer Science (Present GPA *.**) Roosevelt University, IL 2015-2017

ME(MEng) Chemical Engineering (GPA 3.2) IIT, Chicago, IL 2011-2013

BS Material Physics ECUST, Shanghai, China 2007-2011

BS English Literature ECUST, Shanghai, China 2008-2011

Skills

Master degrees in engineer and science, 4 years experiences with advanced skills such as: analytical and data mining, data manipulation, data visualization, data architecture, database and data warehouse design, requirements collection and documentation. Conducted varies sophisticated and colossal projects in finance, insurance and manufacture industries, with project management skills, using waterfall, agile, build and fix process models.

Develop specific data architecture base one user/ organization need, such as application database, reporting database, analytical database, design tables and structure, stored procedures for performance and accessing.

Advanced skills in creating varies reports/ dashboards/ visualizations using SSRS, tableau, spotfire and SAS enterprise guide & miner, SAS studio; data exploring for ANOVA(Analysis of variance), t-test, classification, clustering, correlation,estimation of probability distribution, etc.

Intermediate skills using python and R plotting.

Professional in using database, writing t-sql query, procedures, excel, access, VISIO and other open source tools for data visualization, data transformation, Integration, data blending(for reporting purpose only), modeling.

Data science and statistics knowledges for data exploring and reporting, support decision making.

Documentation and presentation skills.

Academic experience with Matlab.

Skill sets details as below:

Data analysis/ Visualization/ Manipulation/ Modelling ETL Statistics Tableau SQL BI SAS Python BI R Tibco Spotfire ERP TFS Trouble shooting CRM(SalesLogix) IDO Matlab Excel

Certifications & Membership

PMI Member since 2017 MCP (7-461 SQL querying) since 2017

Experiences

SUZOHAPP

Corp Data Architect & Analyst 10/2018-present

Global SQL Analyst (Employee) 7/2016-8/2017

Responsible for analyzing and establishing global information system, including query for reporting, data Visualization, ETL, provide information to management with using Tableau, Spotfire reporting, iron python, R studio, business Intelligence. Reporting to VP. Multi-tasking in a cross-functional team, agile tracking. Trouble shooting. Massively help company cut off the budget by creating user level security dashboard, saving 200 users’ CLA fees annually.

American Society of Anesthesiologists®, Schaumburg, IL 1/2016-6/2016

AQI Application Developer (Contractor from Instant Technology)

Using variety tools to construct and leverage providers' and patients' file, query for reporting, analysis and enhance online analysis process, enhance OLAP CUBE, follow metrics to evaluate factors, differ anesthesia practice performance per provider. Efforts intensified to finalize data loading and to automate processing.

Central States Pension Fund, Rosemont, IL 8/2015-12/2015

Finance Reporting services Analyst (Contractor from Matrix)

Analyzed to developed visualizations, created ad-hoc Finance Report, significantly boost Finance managers/staffs' efficiency to get clean and organized data and simplified the client daily analysis process.

Blue Cross and Blue Shield of Illinois, Montana, New Mexico, Oklahoma & Texas, Naperville, IL 2/2014-6/2015

Application Enhancement Analyst Consultant (Employer: First tek)

Conducted data quality enhancement part, overhauled the existing regulatory data processing system, documented and reported defects and potential harmful parts, held user councils weekly, worked closely with business users(stakeholders) and managers. Accomplished the project and radically changed the process, 5 states' issuance data issue get fix in a way that was very noticeable. Largely cut off the expenses for company.

Young Innovations, Inc. Algonquin, IL 10/2013-1/2014

Online Analytical Processing Analyst Consultant (Employer: First tek)

Optimized data integrating systems. Created Visualizations, finalized history data loading. Created data models, developed OLAP cubes, analyzed retail data de-normalized and create snowflake model for facts with dimensions, with built measures based on business metrics, created KPI for different dental product brands. Conducted data analysis server migrated and sync.

Awards

Secretary of Youth League Committee in Academy 2008-2011

Social Work Award in Academy 2008-2011

The Third Prize Scholarship 2008-2011