Mr. Parth M. Thakkar aczhe0@r.postjobfree.com

979-***-****

Relevant Experience

A master level SAS Certified Business Systems Analyst with three years of total health care experience in the United States.

Scrum, User story writing, sprint and PI planning and working knowledge of Agile and Rally.

Extensive knowledge of business analysis and subject level expert on HealthCare Data Analysis

Created Business Requirement Documents for Quality Metrics for Oncology patient health data as well as claims data for Episodes of Care

Experience in Toad for data Analysis, SQL Server Management Studio, Teradata, Db2, Oracle, Microsoft Access in Windows environment

Extracted HealthCare Data from SQL Server, DB2, MS Access and Teradata using SQL queries

SQL experience including detailed knowledge of root cause data analysis and risk management in health care domain.

Business Analysis experience in provider data, member data, medical claims data and pharmacy claims data

Worked extensively on data quality checks for data migration assessments.

Created process flowcharts and data flowcharts using Microsoft Visio.

Extracted data from SQL databases using series of SQL queries and compiled excel reports as a deliverable.

Ability to write SAS codes using SAS Base and create SAS Macro and strong ability to write SQL queries using PROC SQL

Involved in coding and pulling data from various tables using UNION, UNION ALL, LEFT JOIN and INNER JOIN

Writing Reports, Methods, Results and conclusion for the project and communicating them with team

SAS 9.4 experience including detailed knowledge of statistical analysis and risk management in health care domain

Developed Microsoft Access Database to provide a user friendly database system

Developed spatial database using ArcGIS for spatial research purposes

Descriptive and Statistical analyses using SPSS and STATA

Performed T-test and chi – Square test for continuous and categorical dependent variable respectively to compare the similarity of the demographics across included and excluded population

Work EXPERIENCE

Cigna Health Care / Rang Technologies

Business Systems Analyst April 2016 – Present

Business Analysis and HealthCare Data Analysis

Writing User stories, Attending Scrum meetings, Task updates in Rally and involved in PI planning

Validated Performance and payment reports for OBGYN and Oncology Specialty Care Providers

Created PowerPoint Decks and Flow Charts using Visio and PowerPoint

Very extensively worked on extracting HealthCare Data from SQL Server, DB2, MS Access and Teradata using SQL queries

Writing Reports, project plans and communicating them with team

Involved in coding and pulling data from various tables using UNION, UNION ALL, LEFT JOIN and INNER JOIN

Created Business Requirement Document, Mock data and methodology build up as well as technical requirement specifications

Created flow charts to demonstrate data flow and worked extensively on root cause analysis for data validation.

California State University – Transport Department

Statistical Health Data Analyst December 2015 – April 2016

Created a Business Requirement Document explaining the database creating requirements

Created a functional and technical document including test cases and pseudo codes.

Developed a Statistical Analysis Plan for data analysis.

Extracted data from SAS Database using Data steps and Sql queries by using PROC Sql

Performed Statistical Descriptive Data Analysis in SPSS including T-test on Health and Transport Data

Wrote Methods, Results, and conclusion for peer reviewed research papers acceptance in an academic journal

Student Health Services – TAMU, College Station, TX

Healthcare Business Advisor April 2015 – December 2015

Created a business requirement document for Quality metrics on Rhino Sinusitis diagnosis

Quality Analysis of case referrals and case management services

Data Analysis using Sql queries, Access and Excel

Creating Reports of the results using SAP Crystal Reports

Presented the results and recommendations using PowerPoint to the SHS Medical and Administrative staff

Quality Assurance of hospital and care services

Database Management using Microsoft Access

Patient Vitals measurement and Electronic Medical Records data entry using Point and Click System

Projects:

Quality Analysis on Sinusitis Diagnosis

Performed an extensive analysis of the quality of the sinusitis diagnosis in comparison with the recommended guidelines

Extracted data from electronic medical records using SAP Crystal reports and created ad hoc reports

Managed the data and prepared the reports and graphs using Microsoft Access and Excel.

Communicated the results and the recommendations to the Administration and Physicians by a PowerPoint presentation

Casa Management Performance Evaluation

Evaluated the quality of the database management by the case management staff

Performed the analysis of the data using SQL queries on the Referred cases’ in the database

Communicated the results to the Case management staff and Administration and suggested recommendation using PowerPoint.

COMPUTER SKILLS

Statistical tools: STATA, IBM’s SPSS,SAS, SQL, ArcGIS

Databases: MS Access, Titanium, Point n Click, IBM’s DB2, Teradata, Oracle, SQL Server

Business and Reporting tools: SAP Crystal Reports, MS office, MS Publisher, MS Visio, MS PowerPoint, MS Excel, MS Word

CERTIFICATIONS

Base SAS programmer certification

RESEARCH EXPERIENCE

Peer -Reviewed Journal Publications

Chandra, S., Thakkar, P., Pandya, N., & Zalavadia, A. (2016). P04-Investigating Impacts of Gasoline Price on Transit Ridership in Low-Income Communities. Journal of Transport & Health, 3(2), S64.

Chandra, S., Thakkar, P., Pandya, N., & Zalavadia, A. (2016). P02-Investigating Impact of Crowd sourcing on Transit Ridership. Journal of Transport & Health, 3(2), S63.

Peer -Reviewed Conference Presentation

Thakkar, P. (April 2015). Prevalence of MRSA in Dentistry – A Public Health Concern. Awarded second prize at the Texas A & M Student Research Week.

Directed Research [Spatial Epidemiology]

University IRB approval paperwork for the research study

Extracted patient addresses from the database

Used ArcGIS to do geocoding and ‘multi-ring’ buffer analysis

Wrote Background, Methods, Results and conclusion for the study

EDUCATION

Texas A&M University – School of Public Health, College Station, TX

Master of Public Health – Epidemiology December 2015

Karnavati School of Dentistry, Gujarat University, India

Bachelor of Dental Surgery September 2012

References available on request

Contact this candidate