Data Quality Control

JEWEL MARIA FRANCIS, PharmD, MPH

**** ********* ***, #**, **********, PA-15232 412-***-**** *****************@*****.***

PROFESSIONAL SUMMARY

Experienced in directing statistical analysis, management and quality control of health services outcome data

Strong comprehension of epidemiological methodologies including observational study designs and advanced research methods including Confounding, Effect modification, Bias and Measure of Association

Proficient in developing Statistical Analysis plan, inferential statistics including Parametric/Non-Parametric tests, Linear/Logistic regression models, Survival analysis methods in SAS 9.4

Competent in data manipulation through importing, merging, macros, arrays and transposing data using SAS 9.4

Expertise in data management and analysis using advanced MS Excel (pivot tables, VLOOKUP, formula and macro development and chart/graphs) and familiarity with relational databases (MS Access), REDCap database, SQL

Understanding of International classification of Disease for Oncology (ICD-O-3), ICD 9/10

Expertise in reviewing epidemiologic literature and statistical reports, and writing scientific manuscripts

2 years of clinical experience in healthcare setting in pharmacotherapy selection, retrospective evaluation of medical and pharmaceutical patient level data and IRB submission/protocol

SKILLS

Statistical Tool: SAS 9.4, SPSS Database: MS Access, EndNote, MS Office suite (Word, outlook, Advance Excel, PowerPoint)

PROFESSIONAL EXPERIENCE

Data Management Associate July2016- present

NHS Human Services, Pittsburgh, PA

Succeeded in directing management and analysis of health service quality metrics (compliance and outcomes),complying to data quality standards set by Quality control and Improvements Division

Conducted data analysis using standard statistical methodologies, including frequencies, association (PROC ANOVA/PROC GLM, chi-square/Fischer Exact test) and multivariate regression analysis

Interpreted patterns and trends of metrics by analyzing descriptive data and generating sophisticated executive level reports using SAS 9.4, MS Excel(pivot tables, charts/graph) and SPSS

Generated query/Incidence reports from various data sources (AVATAR, crystal reports)

Performed data checks for gaps or errors in data and collaborated with cross-functional teams in synthesising and improving performance metrics

Research Assistant/Data Monitor at Long Life Family Study (LLFS) February 2015- April 2016

Health Studies Research Center, University of Pittsburgh, Pittsburgh, PA

Independently lead the periodic quality control procedures to ensures data integrity for analysis and reporting (REDCap Database) and made recommendations for programming improvement opportunities

Served as a technical expert for statistical data analysis and prepared summary reports

Epidemiology Intern May 2015- September 2015 Epidemiological Data Centre (EDC), University of Pittsburgh, Pittsburgh. PA

Designed and conducted an epidemiological study on “The pattern of Statin use among midlife women and its variability across ethnicities” using data from SWAN study

Analysed large longitudinal data to developed baseline demographic characteristics, and used multivariate logistic regression model to assess the statin use based on ASCVD score (Atherosclerotic Cardiovascular Disease Risk Score)

Conducted data import (PROC IMPORT) data cleaning, manipulation (KEEP/DROP, IF,THEN, WHERE statement), and analysis (PROC FREQ, PROC UNIVARIATE) using SAS 9.4 and Excel

Clinical Pharmacist August 2012 – June 2014

Kasturba Hospital, Manipal, Karnataka, India

Supported physicians in pharmacotherapy selection, and provided medical counseling to patients

Collaborated with healthcare stakeholders at Kasturba Hospital to developed case reports on hospital-acquired infections and antibiotic resistance for hospital infection control unit

Analysed medical records(clinical and billing), and designed data collection form to obtain retrospective data on H1N1, and ARDS patients and prepared case study documents

EDUCATION

Master’s in Public health (MPH) Major: Epidemiology April 2016

University of Pittsburgh, PA

Doctor of Pharmacy (PharmD) July 2014 Manipal University, Karnataka, India

PUBLICATIONS

Awasthi, S., Prabhu, V., Francis, J. M., Kunhikatta, V., & Thunga, G. (2013). Corticosteroid an ambiguity in ARDS. Journal of pharmacy practice and research, 43, No. 3.

Singh, A., Awasthi, S., Agarwal, J., Khera, K., Thunga, G., & Francis, J. M. (2015). Analysis of Risk Factors of Death In H1N1 Influenza Patients In a Tertiary Care Hospital. Value in Health, 18(3), A229. doi:10.1016/j.jval.2015.03.1334

Singh, A., Khera, K., Agarwal, J., Awasthi, S., Francis, J. M., & Thunga, G. (2016). Fatal prognosis of H1N1 influenza in late trimester of pregnancy: descriptive analysis of four cases. International Journal of Pharmacy and Pharmaceutical Sciences( IJPPS 12133)

CONFERENCE PRESENTATION

POSTER PRESENTATION

Francis, J. M., Thunga, G., Khera, K., & Awasthi, S. (2013). Rifampicine induced acute kidney injury. Paper presented at the Dubai International Pharmaceuticals and Technologies Conference and Exhibition, Dubai.

Awasthi, S., Francis, J. M., Thunga, G., & Khera, K. (2013). Retrospective analysis of treatment of Rheumatoid arthritis. Paper presented at the Dubai International Pharmaceuticals and Technologies Conference and Exhibition, Dubai.

ORAL PRESENTATION

Francis, J. M., Thunga, G., Khera, K., & Awasthi, S. (2013). Rifampicine induced acute kidney injury. Paper presented at the Dubai International Pharmaceuticals and Technologies Conference and Exhibition, Dubai.

Contact this candidate