XIAOWEI ZHANG 614-***-****
*** ****, ***** ******, ***. 1407
New York City NY 10025
******@********.***
Data Scientist
P ROFILE
Ø Master of Science in Data Science along with Bachelor of Science in Actuarial Science (Summa cum Laude) with comprehensive theoretical and applied studies backed by qualifications and experience including: ü P, FM and MFE exams passed; SOA
ü Economics and Statistics requirements passed; VEE ü Capitalized on opportunity to gain real world experience as Healthcare Analyst Intern in various audits and reviews on behalf of Centers for Medicare and Medicaid Services; 2016 ü Collaborated as Research Assistant in conducting behavioral study subsequently published in New York Times and The Onion; 2015-2016
Ø Sharp data generation, analysis, documentation, and reporting skills Ø Adept in planning, coordinating and managing workflow/projects to optimize productivity and efficiency, meet deadlines and achieve performance goals
Ø Technology savvy, with proficiency in Java, C++, Python, SQL, Spark, Hive, Wrangler, SAS, Minitab, Excel, Access, Tableau, and CARTO
Ø Strong communication and interpersonal relation skills instrumental to productively interfacing with all stakeholders; bi-lingual English and Chinese
E DUCATION
Master of Science-Data Science, Columbia University-New York, NY; Dec 2016 GPA: 3.67/4.0 scale
Bachelor of Science-Actuarial Science, The Ohio State University-Columbus; May 2015 Minor: Statistics and Economics
GPA: 3.97/4.0 scale; graduated Summa cum Laude
WORKING E XPERIENCE
HEALTHCARE ANALYST INTERN, Hay Group Inc.-Philadelphia, PA 2016
§ Collaborated in auditing and reviewing CY 2016 bids for Centers for Medicare and Medicaid Services
§ Efficiently assessed and determined reasonableness of trends based on complex healthcare data; included analyzing data across wide range of high-profile healthcare issues via Excel spreadsheets (Pivot Tables and Macros)
§ Thoroughly reviewed rate filings and recommended strategic changes to quarterly premiums along with cost and utilization rates based on findings
RELATED E XPERIENCE
AVIATION SAFETY, Synergic Partners, -Madrid, Spain 2016
§ Created a distributed scraping system and gathered 24 days of Flights information with python BeautifulSoup
§ Designed
a
detection
algorithm
with
PostgresSQL
and
identified
flights
with
possible
air
conflicts
§ Employed
feature
engineering
techniques
and
generate
useful
features
including
air
traffics
§ Built
a
random
forest
classification
model
with
scikit- learn
and
evaluated
performance
with
cross
validation
§ Produced
a
dashboard
to
present
the
result
with
Tableau
§
INVENTORY MANAGEMENT WEB APPLICATION FOR CLOTHING BUISNESS 2016
§ Designed database schema with ER modeling
§ Translated the model into Postgres on Google Cloud Platform and loaded the data
§ Built the front end on top of the Flask Python Webserver for users to interact with the database and generated insights