Sign in

SAS, Tableau, Statistics, Biostatistician, Actuarial Science

Winnipeg, MB, Canada
March 19, 2018

Contact this candidate


Harpreet S. Sahota

*** ****** ******, ********, ** R2R 1Y9 / 204-***-****/


Creative, insightful, and analytical professional with superior statistical analysis skills who is exploring opportunities to dive into data to look for patterns and use SAS to perform statistical analysis in clinical research applications.

Demonstrated knowledge of probability theory, statistical analysis, generalized linear models, analysis of variance, parametric and nonparametric model estimation, and regression analysis.

Knowledge of CDISC guidelines for ADaM compliant datasets, and experience implementing methods to create those datasets.

Knowledge of industry guidance including ICH E3, E6, E9, and 21 CRF part 11.

Proficient in use of Microsoft Office Suite, Visual Basic for Excel, R Programming Language, and SAS Enterprise Guide.

Expert SAS programmer including SAS Macro Facility, PROC SQL, ODS, and PROC REPORT.

Detail oriented analyst mindset with commitment to data quality assurance.


Illinois State University, Master of Science - Mathematics 2013

California State University of Fullerton, Bachelor of Arts - Economics 2007

Casualty Actuarial Society Exams 1, 2, 3L, 3F

SAS Certified Base Programmer for SAS 9 2014

SAS Certified Advanced Programmer for SAS 9 2014

SAS Certified Clinical Trials Programmer for SAS 9 2014


Emergent BioSolutions, Winnipeg, MB 2014-Present


Provide input and expertise for trial design aspects such as power calculation and sample size estimation, randomization schemes, and statistical methods for analysis of clinical endpoints.

Author statistical analysis plans and draft statistical methods sections for proposed research endpoints, draft specifications for CDISC compliant analysis datasets, and design the accompanying tables and listing shells.

Conduct interim and final analysis of clinical trial data using SAS and provide interpretation of these analyses using written, oral, and graphic methods, as appropriate to the audience.

Identify and troubleshoot missing, miscoded, or incomplete data using data manipulation and data cleaning techniques to resolve inconsistencies with clinical team members in data management and pharmacoviligance.

Maintain documentation of in-progress and completed analyses, as well as validation procedures.

Prepare statistical reports and displays for presentation at meetings, conferences and publication in regulatory documents.

Harpreet S. Sahota

100 Garton Avenue, Winnipeg, MB R2R 1Y9 / 204-***-****/


The Warranty Group, Chicago, IL 2013-2014

Analyst - Actuarial and Underwriting

Developed and implemented automated rate books, using Visual Basic for Excel, to provide dealer cost quotes to field representatives in real time.

Used SAS programming to obtain policy and claims data from external databases, clean and subset data, and perform analysis in the development of rating plans and pricing for automotive warranty products.

Routinely used the functionality of SAS in conjunction with Microsoft Excel to stage and process data, and translate results into insights to address pricing and rating plan questions.

Used a combination of Base SAS, SAS EG, and JMP to conduct analysis of claim frequency and severity on a zip code level basis to identify service centers which provide the most competitive labor and parts rates.

Contributed to research and analysis on ad-hoc projects as required.

Illinois State University, College of Education, Normal, IL 2011- 2013

Graduate Assistant

Received departmental recognition for providing excellent technical support for department faculty in both the online classroom environment and in-person.

Acted as a team leader to train and supervise new Graduate Assistants.

Standardized a format for informational kiosk presentations to highlight department news and events.

Created database using Microsoft Access to track and manage department inventory.

Ensured that department computers were tracked, monitored, and software remained up-to-date.

Options for Youth Public Charter Schools, Pasadena, CA 2008 - 2010 Small Group Math Instructor

Contributed to a charter-wide increase in the number of students who passed the California High School Exit Exam.

Utilized instructional methods and materials which were most suitable for meeting defined objectives and standards.

Instructed the at-risk student populations in various high school level mathematics courses from pre-algebra through pre-calculus.

Worked with students to negotiate a program of study which met the individual student’s needs and goals

Maintained a disciplined and controlled classroom environment.

Pacific Life Insurance, Newport Beach, CA 2007 - 2008

Annuities Information Specialist

Communicated market information to policyholders regarding the specific details of their retirement accounts.

Developed and maintained relationships with field representatives, brokers, financial planners and back-office personnel.

Executed asset allocation trades on behalf of clients for in-force annuity contracts.

Investigated, analyzed, and understood the various features of the client’s specific annuities.

Offered prospective and current clients education regarding annuities, including a balanced view of the benefits and disadvantages of their specific annuity.

Contact this candidate