Matthew Reader
Dallas,TX
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Sr. Laboratory Data Manager
CTI Clinical Trial and Consulting Services
03.2022 - Current
- Responsible for business unit's design of data models using PostgreSQL designed to facilitate storage and reporting of laboratory results to biostatistics groups and for internal operations reporting and external client reporting.
- Creates data quality reports using Python and Jupyter Lab notebooks that connect to PostgreSQL database, retrieves information about biological samples received for long-term storage, and compares information to shipping manifest documents (Excel files).
- Suggest adding interaction with third party software vendor to identify and expand software capabilities to meet business needs.
- Suggest adding the work that you perform cross functionally troubleshooting systems issues.
Lead Programmer/Analyst
University of Rochester Medical Center
12.2019 - 03.2022
- Created extract, transform, and load (ETL) pipelines with Apache Airflow to process raw medical and pharmacy claims data, healthcare member roster data, and clinical data into actionable insights at accountable care organization
- Projects included calculating HEDIS metrics for value based care, and calculating population metrics such as per member per month (PMPM) healthcare costs, attributed line of business (LOB), and total member months (MM) per line of business
- Collaborated with pharmacy managers to provide custom data analytics using Python and R programming language
- This included calculating potential cost-savings from switching percentage of attributed population from proprietary medications to generics.
- Performed research and analysis to develop new projects, proposals and system modifications
Clinical Data Manager
Eurofins Scientific
10.2018 - 12.2019
- Participated in code reviews to ensure SAS programs written by other data management team members satisfied specifications outlined in client agreements
- Wrote SAS macros that helped standardize the extraction and transformation of laboratory data from a relational database
- Programming changes were tracked using version control (git) and helped establish programming standards in the data management department.
Clinical Trials Data Analyst II
ACM Global Laboratories
12.2014 - 10.2018
- Created a script using Python that aggregated the data of approximately 2000 separate Excel spreadsheets and summarized the entire inventory of biological specimens stored at the US, UK, and Singapore offices of ACM
- The analysis was crucial for assisting our billing department in automating a portion of their billing process and projecting the number of specimens ACM can expect to store at each office over time
- Created interactive data visualizations of clinical trial performance metrics using R/RShiny and static metrics reports using R/rmarkdown
- The data visualizations and reports retrieved data from a SQL database and displayed common quality issues made by clinical trial investigator sites across entire studies, with a breakdown of which errors were most prominent at each investigator site.
Technical Associate
University of Rochester
12.2012 - 11.2014
- Gathered pharmacokinetic data and calculated the half-life of biological molecules in a mouse model using the R statistical programming language
- The resulting analysis and graphs were used to support patent applications of therapeutic antibodies used to control bone infections
- Analyzed environmental monitoring data collected from a cGMP manufacturing facility using the R statistical programming language
- The data reports and visualizations allowed us to readily identify data outside of acceptable limits, and if our data showed any obvious trends.
Education
Master of Science - Statistical Data Science
Texas A&M University
College Station, TXMaster of Science - Bacteriology
University of Wisconsin
Madison, WI12.2006
Bachelor of Science - Biotechnology
Rochester Institute of Technology
Rochester, NY05.2001
Skills
- Programming: Python, SQL, R, Java, SAS
- Data Processing: Apache Spark, Databricks
- SQL: Microsoft SQL Server, PostgreSQL
- Visualization: Tableau, R/Shiny, R/Markdown, Jupyter
- Cloud Providers: Amazon Web Services (S3, Lambda, Athena, Glue, Redshift, DynamoDB, QuickSight)
Certification
SAS Base Certified Programmer for SAS 9
AWS Certified Cloud Practitioner
AWS Certified Solutions Architect – Associate
AWS Certified Developer – Associate
AWS Certified Data Analytics – Specialty
Epic – Clinical Data Model
Epic – Caboodle Data Model
Epic – Clarity Data Model
Epic – Cogito Fundamentals
Timeline
Sr. Laboratory Data Manager
CTI Clinical Trial and Consulting Services
03.2022 - Current
Lead Programmer/Analyst
University of Rochester Medical Center
12.2019 - 03.2022
Clinical Data Manager
Eurofins Scientific
10.2018 - 12.2019
Clinical Trials Data Analyst II
ACM Global Laboratories
12.2014 - 10.2018
Technical Associate
University of Rochester
12.2012 - 11.2014
Master of Science - Statistical Data Science
Texas A&M University
Master of Science - Bacteriology
University of Wisconsin
Bachelor of Science - Biotechnology
Rochester Institute of Technology
SAS Base Certified Programmer for SAS 9
AWS Certified Cloud Practitioner
AWS Certified Solutions Architect – Associate
AWS Certified Developer – Associate
AWS Certified Data Analytics – Specialty
Epic – Clinical Data Model
Epic – Caboodle Data Model
Epic – Clarity Data Model
Epic – Cogito Fundamentals
Similar Profiles
JILL L. DORANJILL L. DORAN
Manager, Account Management at CVS Health - Clinical Trial ServicesManager, Account Management at CVS Health - Clinical Trial Services
Arielle RomanoArielle Romano
Nurse Coordinator at Clinical Trial MediaNurse Coordinator at Clinical Trial Media
Fatuma ShiwokoFatuma Shiwoko
Patient Enrollment Specialist at Cognitive Clinical TrialPatient Enrollment Specialist at Cognitive Clinical Trial