Shan He Email & Phone Number

California, United States

Alameda, California, US

Burlingame, California, US

• Served as the statistical programmer for several projects providing data consulting services of Medicare Part A, B and D claims to Centers for Medicare & Medicaid Services (CMS).
• Developed statistical and analytical methodologies; applied, tested and evaluated statistical methods on large-scale data using SAS, SQL and advanced Excel; built data-visualization deliverables and presented results.
• Provided policy recommendations on beneficiaries’ behaviors patterns, fraud activities, provider behavior, healthcare utilization and health outcomes.
• Created and kept updating the COVID-19 monitoring analysis by writing SAS programs and applying statistical methods. Captured the total utilization, potential billing fraud from providers and billing trend of all.
• Renovated and maintained the program of the Year-to-Date analysis for Clinical Laboratory Fee Schedule (CLFS) projects. The running time of program was improved 60% by restructuring all the main and child SAS macros.
• Created internal-used SAS macros and SQL queries to improve the efficiency of programs for some projects.

Burlingame, California, US

• Created the entire PDF auto-filling and email sending system through huge data set processing with R, improved the efficiency for at least 95% when periodically sending personalized files to customers
• Created the renewal email reminder sending system based on real-time customer database with R to targeted customers which directly increases the renew rate for approximately 10%
• Created the Enrollment Dashboard by Excel which tracks KPI of the marketing team and reports real-time stats regarding customers including age distribution, enrollment trend through years and plan distribution etc.
• Created the internal School Info Card from the School Database for the media team to get updated information of targeted schools to compose propaganda articles by writing SQL queries in MS Access Forms
• Generates periodical data reports with comprehensive marketing and sales strategies using Excel, R or Tableau
• Keeps updating the insurance information of targeted colleges by data crawling with Python

Shenzhen, Guangdong, CN

• Collected, withdrew and cleaned the data from the data base by using R and SQL
• Used R and Excel (vlookup, pivot table, etc.) to calculate statistics and automate data visualization and finally created the first ever data analysis report for the entire facultative team of headquarter
• Created professional PowerPoints and performed presentations in front of the leaders from entire headquarter

New York, NY, US

• Create a scaling system for each category (PE, non-PE, Real Estate, etc.) of entire data in the Filemaker database by using R with several statistical methods (relative importance, Random Forest, etc.)
• Operated Filemaker database including fixing wrong data, typing in new data and withdrawing desired data.
• Created R data report showing the differences between categories in scaling system and discussed rationality.

Seattle, WA, US

Leads and manages all 30+ student employeesDirects student employees to processes cash, husky card and credit card transactionsConducts food supply and arrangementBuilds connections between classified and student employeesGuides student employees and answer their questions

Seattle, WA, US

• Research Assistant of Foster Business School at University of Washington
• Titled as ‘Analysis for Political Economics’, and worked within a group of seven RAs
• Gathered, manipulated and classified over 100,000 data into respective candidate groups
• Operated calculations on programming software such as R and Excel
• Communicated with the PhD students about political economic issues such as how economics could influence the trend of election and what suggestions we could make for the politicians to adjust their investment direction

Beijing, CN

• Introduced new financial products of Bank of China to customers with describing current economic situation and guided customers to fill required forms for receiving further financial services
• Guided customers about depositing and withdrawing money by talking to a banker or using ATM
• Went to major clients’ places to discuss further investment plan and assisted manager to do paperwork

Master Of Arts - Ma, Statistics

Bachelor Of Science (B.S.), Statistics And Economics