JASON (XIAOXIN) CHEN
***********@*******.*** 617-***-**** 16 Harcourt Street #4B, Boston, MA 02116
QUALIFICATION SUMMARY
** ***** ** *********** ********** with SAS and large relational database.
9 years of healthcare experience supporting decision making for senior leaderships.
7 years of consulting experience implementing and utilizing Business Intelligence products.
Profound understanding of clinical study designs and advanced statistical models.
Expert in developing scorecards and dashboards to track performance and to achieve goals.
Specializing in providing accurate, meaningful, easy-to-interpret reports to key stakeholders.
Critical thinking to break complex projects into actionable sub-steps for implementation.
Effective communication to facilitate discussions and to recommend best-practice solutions.
Tailoring presentation to target audience and comfortable speaking in front of large group.
Independent working style to design efficient database and provide fact-based analytics.
Willingness to continuously learn new solutions and skills to be a true asset to the team.
CERTIFICATION
SAS Certified Advanced Programmer for SAS 9
SAS Certified Clinical Trials Programmer using SAS 9
SAS Certified Statistical Business Analyst using SAS 9: Regression and Modeling
PROFESSIONAL EXPERIENCE
Kaiser Permanente (San Diego, CA) Jan 2014 - Jan 2016
Surgical Outcomes and Analyses
Data Consultant / SAS Programmer III
Extracted, transformed, and loaded (ETL) hospital encounter data and claims data to support 8 orthopedics and cardiac registries nationwide.
Imported case report form (CRF) into relational database and built quality control algorithm to validate 3000+ fields in 80+ tables. Eliminated the need to perform similar tasks manually.
Prepared registry data snapshots for biostatisticians to conduct level 3 retrospective cohort studies and case-control studies on various quality outcomes.
Worked closely with surgeons and determined 20+ studies to conduct using existing data.
Designed studies to evaluate the effectiveness of the surgical techniques or implantable medical devices using multivariable survival analysis, logistic regression, and linear regression model while controlling for random effect.
Assisted surgeons to write and submit manuscripts to peer-reviewed journals as well as to prepare presentations for internationally renowned health professional meetings.
Automated annual or quarterly key reports creation and email distribution process. Enabled project managers to accurately sending reports to 600+ surgeons in 50 hospitals.
Designed 6 user-friendly metadata-driven dynamic web applications to empower end-users to generate reports on-demand to track their own quality goals.
Implemented the SAS 9.4 Unix server conversion to replace the existing PC SAS 9.2. Allowed the programmers team to seamlessly share the data, macros, formats, and SAS codes.
Developed 60+ SAS macros to simplify and standardize methods to produce statistical tests, tables, and graphs. Successfully achieved departmental brand recognition effortlessly.
Electronically documented the user-manual to explain the architectural design of each routine tasks and ensured the consistency of subsequent reporting, maintained the system process flow diagrams, inventory list of available data, and clinical outcome metric specifications.
PROFESSIONAL EXPERIENCE (Continued)
Brigham and Women’s Hospital (Boston, MA) Feb 2007- Dec 2013
Center for Clinical Excellence – Decision Support Systems
Promoted to Lead Analyst in 2010; promoted to Senior Programmer in 2012
Collaborated with physicians, nurses, or department administrators to fully understand their quality goals and financial needs. Researched available resources that will contribute to the success of their projects. Proposed cost-effective strategies to make changes that last with minimum impact to frontline clinician’s workflow.
Established healthy relationships with IT technicians to acquire clinical encounter or claims data components needed to support institutional goals as well as the ICD-9 to ICD-10 conversion.
Automated routine processes by initiating ODBC connections to MySQL and MS Access database, and setting up batch files using MS-DOS to schedule jobs on servers. Saved at least one week worth of manual data collection time every month.
Automated data submissions in XML or CSV file format to meet regulatory requirements imposed by Centers for Medicare and Medicaid Services (CMS). Eliminated over 700 manual patient record data entries by nurses every quarter.
Produced control charts to monitor the trends of organizational goals, investigated root causes when the process is out of control, then recommended actions to business owners.
Recruited staffs who fit department needs and culture. Coached and trained them to gain better understanding of the system and the supporting software.
EDUCATION
Boston University (Boston, MA) 2002-2006
Master of Arts: Mathematics (Concentration in Statistics)
Minor in Business Administration
SOFTWARE EXPERTISE
SAS: SAS/SQL, SAS/Macro, SAS/Base, SAS/Stat, SAS/Graph, Enterprise Guide, Management Console, Data Integration Studio, Stored Process, Strategic Management, OLAP Cube Studio, Visual Analytics, Information Delivery Portal, Analytics for Microsoft Office
Microsoft: Office 365, Access, SQL Management Studio (Transact-SQL)
Other RDBMS: Teradata, Oracle (PL/SQL), MySQL
Others: HTML, Java Script, XML, EPIC, EPSI, Adobe Acrobat, Adobe Photoshop, Lotus Notes
AWARD-WINNING CLINICAL PUBLICATIONS
Maletis GB, Chen J, Inacio MC, Funahashi TT (2015). Age-Related Risk Factors for Revision Anterior Cruciate Ligament Reconstruction: A Cohort Study of 21,304 Patients From the Kaiser Permanente Anterior Cruciate Ligament Registry. Am J Sports Med
Tejwani SG, Chen J, Funahashi TT, Love R, Maletis GB (2015). Revision Risk After Allograft Anterior Cruciate Ligament Reconstruction: Association With Graft Processing Techniques, Patient Characteristics, and Graft Type. Am J Sports Med
SAS PROGRAMMING PUBLICATIONS
Managing Tables in Microsoft SQL Server using SAS (WUSS 2015)
Web Reporting by Combining the Best of HTML and SAS (WUSS 2015)