Yuan Wang Email & Phone Number

Washington D.C. Metro Area

• Reviewed and tracked KPIs monthly, calculated and run commission reports on sales harmonics, inventory situation and bit performance utilizing Excel Pivot tables and graphs.• Contributed to development of business case scenarios, built and verified Recovery Models via Excel VBA to maximize the recovery and profit of liquidation. • Developed ETL processes for initial data importing, transferring and loading from multiple data sources into IMS SQL Database through SSIS packages.• Run custom T-SQL queries and scripts to extract and consolidate the history transaction data.• Identified and tracked data quality issues and developed procedures to mitigate errors and to reconcile inconsistencies of information. • Developed Macro program to automatically combine hundreds of products manifests into one consolidated file, and then automatically filtering useful data for auction creating. • Synthesized quantitative analysis into informative and easy-to-understand deliverables and communicated findings to a wide variety of internal and external audiences.

Washington D.C. Metro Area

• Created, updated and maintained the health centers UDS ACCESS database system, queried and extracted targeted data to review community health centers’ performance.• Performed research on new policy and lasted studies about CHCs through Pubmed.gov and Census.gov weekly. Collected key CHCs’ data, combined and displayed the data to create CHCs’ mapping atlas through Tableau.• Constructed and manipulated large-scale and complex Health Care data sets using SAS Data Step, SAS Macros,SAS Sql and ODS reporting procedures.• Designed the questionnaire of the Medicaid/Medicare Outreach and Enrollment Survey, recommended thesampling method and sample size.• In SAS/Excel, conducted Poisson Regression analysis, Chi-Square Test, T-test, Difference of Proportions Testand Correlation Test on Survey results to deeply understand health center’s partnerships and barrier issue.

Alexandria,Virgina

• Assisted in creating Microsoft ACCESS Databases and writing database maintenance logs and presenting any issues to the database architects.• Developed and executed budgets including cost analysis, fiscal allocation and budget preparation. • Used One-way and Two-way ANOVA analysis via SAS so as to make sure if there is significant difference of revenue patterns between different Educational related NPOs.• Produced and document results about operational and financial performances monthly.• Contributed to newsletters, research reports, and policy papers. Presented analysis results, research reports to various audiences.

Guangzhou, Guangdong, China

• Coordinated the whole team designed crucial modules of the Municipal Government official website which containing the member registration and Login function module, tourists signup function module and background administrator function module• Improved user-friendly foreground system by applying operation interfaces with VisualBasic and assisted in building ACCESS-based Resident Information Database• Helped Design the background website system using ASP technique.

Guangzhou, Guangdong, China

• Collected and cleaned Census Summary data of Guangdong Province from 1995 to 2010. • Constructed and manipulated large-scale and complex Health Care data sets using SAS Data Step, SAS MACROS and SAS SQL. • Used SPSS and SAS to conduct Multiple Linear Regression analysis and Ridge Regression analysis to clarify the weight of vehicles influenced the Average Household Consumption. • Studied the performance of FY 2011 sales target, sales promotion and supplemental promotion based on pick-up/selling achievement rates and inventory control with Excel Pivot tables.• Utilized SAS for Time Series Analysis on large sales data with ARIMA model which including stationary analysis, seasonality analysis and sales volume prediction. • Produced reports, proposed corresponding suggestions to improve the sales performance.