Kai Wang
**** ********* ****, ******** ** ***** / 410-***-**** / *****@*******.***
* ***** ** **** ********** & reporting experience in international business and health insurance; Excels both at relevant quantitative & qualitative data analytics & cleansing while maintaining the enthusiasm of accepting new challenges; MS in Business Analysis & Modeling and Information Systems across three continents; Passion for cycling racing outside of work is consistent with my fast paced and diligent work style. K E Y S K I L L S
Statistics, Database Management.,
Data Warehouse Management,
Data Reporting; Data
Visualization; Account
Management; Accounting
Management; Financial
Management; International
Business Management; ISO
Manufacturing Auditing.
C OMPUTER S K I L L S
SQL, Java, Python, MS Office Suite
(including Visio, VBA, Access,
Project), Statistics (SAS, SPSS),
Data Visualization (Qlik Sense,
Power BI), Google Analytics,
AdWords, SD modeling (Vensim,
iThink), SAP ERP, drawing
(AutoCAD, Photoshop).
I N T E R E S T S
Tennis, Cycling, Arsenal,
Taekwondo.
C A R E E R H I G H L I G H T S
D A T A A N A L Y S T ( P A R T - T I M E ) at SBZ Services LLP New York, NY June.2017 to Present
+ Data visualization building dashboards that enable effective CRM data discovery and exploration (Excel VBA, Power BI).
D A T A Q U A L I T Y A S S U R A N C E I N T E R N at Catholic Relief Services Baltimore, MD May.2016 to October 2016
+ Worked in Data Stewardship Group (DMG) as a sub-lead of 3 interns assisting to develop and validate agency-wide data standards;
+ Facilitated and summarized Data Standardization Process guidance with SME; reviewed output to ensure unit specific data standards were visible and usable across the Agency (SD modeling); collected pool of company data elements by applications and categories;
+ Reviewed and corrected the oversea partner data (Excel, Access & SQL); performed data analysis & visualization (Power BI, SharePoint). S R . A C C O U N T M A N A G E R at MSH International Shanghai January.2013 to August 2015
+ Led a team of 5 who were responsible to manage the success of relationship with various clients (Marriott, TOD’S, H&M, Maersk, Google China); provide periodically customer service reviewing to reduce claim.
+ Developed monthly outstanding balance report & analysis (e.g., debt recovery strategy); Conducted KPI report (Excel & Qlik Sense);
+ Provided and presented annual health insurance services/data report for the department (e.g., seeking the correlation between claim ratios and level of positions) (SPSS, Qlik Sense).
O P E R A T I O N S M A N A G E R at Richhood Group Shanghai September.2007 to August 2011
+ Led a team of 8; Business startup; Fall protection products market analysis, Markets Entry Strategy; client: Peakwork Canada, Product Quality Control/Analysis.
E D U C A T I O N
P E N N S T A T E U N I V E R S I T Y, MS in Information Systems (2017) GPA 3.7; JCIS Publishing: “Systems Dynamics Based Modelling of Data Warehouse Quality and Process”; Projects: Data Warehouse Deployment Strategy Plan for Mast Global (PL/SQL); Regression modelling for predicting housing values (SAS). R A D B O U D U N I V E R S I T Y, the Netherlands, MS in Business Analysis & Modelling (2013) US News Global Univ. Ranking 97; Projects: Structural Transformation to Achieve Gender Equality in Donders Institute (SD modelling); Factors Influencing Technical Aircraft Performance in Nayak Inc. (SPSS). S H A N G H A I U N I V E R S I T Y, Dual BA in Automotive Electronics/International Business Management (2007) Secretary of Student Union; Marketing Plan for Philips’ Lady Shave Product; Google AdWords Campaign for Mio & Co.; Help desk Intern in Paul Hastings LLP.