Carol Page Email & Phone Number

New York, Ny, Us

Key Responsibilities• Analyze health care cost and utilization trends geared toward providing physician and healthcare leaders savings opportunities and insight into performance budgets • Manage large datasets of Medical Claims, Pharmacy and Enrollment Membership• Build an Analytics Datamart • Maintain and design Excel data models and dashboards • Construct reconciliation tasks to ensure attributed membership and payments from the Analytics Datamart tie out to Financial Reports• Troubleshoot data issues

Canton, Ma, Us

Key responsibilities include measurement and investigation of health care cost and utilization trends to help identify opportunity areas, valuation of proposed medical cost initiatives to support critical business decisions, return on investment analysis of vendor-based and internal programs, and creating a variety of clinical and population profiling reports. Topics of focus include trend analysis, product development, provider reimbursement analysis and financial planning and projection using SQL, SAS, Tableau, Excel and PowerPoint. Performance process includes communicating initial requirements with stakeholders from cross-functional teams, extracting and processing data results, performing self-QA on code and final results, placing results in appropriate presentation tool (Excel, Tableau), presenting or providing deliverable in timely manner.

Responsible for the coordination of data received by the Delivery System Reform Incentive Program (DSRIP) to support the greater Nashua region Integrated Delivery Network (IDN3), including patient enrollment/attribution, claims data, as well as performance-related clinical outcomes. Identifies and presents improvement opportunities, enhancement and redesign in order to accomplish greater efficiency among the provider partners in the network.

Carrollton, Texas, Us

Convert an existing Excel tool to SAS and provide advanced SAS programming support to other business units. Additional data analyst tasks include maintaining a pipeline database of FDA new drug (NDA) and biologic applications (BLA) for oncology drugs on a monthly basis and performing ad hoc analysis of custom product deliverables.• Lead the transition of Excel-based tool to SAS. This process includes: - Convert advanced spreadsheet formulas (vlookup, indirect, pivot) to SAS code while utilizing iterative do loops, hash objects, retain, macros, dow loops and SQL pass through facility; - Recode and create new variables; - Merge datasets; - Pull data from the server of relational database consisting of nearly 400,000 cancer patients and 11 million administrations of drug therapy using either SQL Server Management Studio or SAS (PROC SQL).• Use advanced SAS knowledge to assist in the development of analytical methods - Created estimated patient counts of supportive care drug utilizing proc SQL, macros, data steps, and external databases (IQVIA, Wolters Kluwers). - Wrote code to allocate top line patient counts for a particular drug across drug regimen - Prepared graphs and charts to validate new drug patient counts to existing drug patient counts using SGPLOT and ODS; - QA SAS code of other developer. Methods include checking macro logic, converting hard code to tokenized macro variables, and validate datasets - Built Excel tool with pivot report indicating various attributes of NDA or BLA including

Concord, Ma, Us

Primary research including assisting in questionnaire design, management of data collection, list preparation, programming questionnaires, processing and analysis of data, preparing graphs and charts for reports and presentations. Primary tools included SPSS, Excel, PowerPoint. Statistical methods include descriptive, inferential (t test, cf), conjoint analysis, cluster analysis.

Primary research including managing survey process, database analysis, statistical testing, report generation using SPSS, and written analysis of survey results.

Needham, Massachusetts, Us

Manager of IDC's Global IT Survey, consisting of interviews from over 13,000 businesses and 9,000 households in the United States, Japan, and Western Europe. Served as the primary contact to all nine participating country offices. Role included data cleaning of country databases, merging datasets, data analysis and reporting on global trends in technology use and IT spending

An IDG Company. Responsible for planning, implementing and delivering customized database analysis. Managed an on-going, quarterly B2B survey. Customized and supported the user-friendly lead generation PC system (Paradox/PAL format).

Bachelor Of Arts, Health And Society

Masters Of Science, Analytics