Saraswati C. Durai

EDUCATION

Savitribai Phule University (Formerly known as Pune University) 2006 - 2010

Bachelors of Engineering in Computer Science

AREAS OF EXPERTISE

Query writing: Sub-queries, Joins etc.

MS Excel: Pivot, VLOOKUP and Graphs

SQL Job Scheduling, Troubleshooting, Back Up, and recovery

SQL Server (Management Studio, SSIS, Report Builder)

Data collection, Data analysis, Data Management and Database analysis

Stored Procedure, Views, Functions and Constraints

Requirements gathering

Bulk copy program (BCP)

Strong problem-solving skills, self-motivation

capacity to work under pressure with tight deadlines and strong attention to detail

Code optimization and Review

Data Migration and Data visualization

Database Table Designing

Data Modelling

Medical Terminology Knowledge

Electronic Medical Record (EMR)- Front End and Database: Allscripts, eClinicalWorks, EPIC

TECHNICAL SKILLS

Programming Languages: SQL, Python

Microsoft SQL server data software: SQL Server Integration Services (SSIS), DTS

Microsoft's Business Intelligence Suite: ETL (Extract, Transform and Load)

Database / DB Tools: Microsoft SQL Server 2008, Microsoft SQL Server 2018, MYSQL Server, Microsoft Access 2010

Operating Systems: MAC, Windows, Android

Business Intelligence Tools: Tableau

EPIC Certification: Caboodle Data Model, Clarity Data model and Cogito

Other: Authorized to work for any US employer.

PROFESSIONAL EXPERIENCE and RESPONSIBILITIES

Senior Data Analyst- Quality and Safety October 2021 – October 2023

Hartford Healthcare Oradell, NJ

Role: The Senior Data Analyst for Quality and Safety Department; EPIC certified on Caboodle Data Model, Clarity Data model and Cogito. Reporting on EHR like EPIC and Cancer Registry system like METRIQ, Salesforce product like Riskonnect and Revenue Cycle Management projects at Hartford Healthcare Cancer Institute.

Responsibilities:

Collecting, analyzing and interpreting healthcare data related to quality and safety measures, including patient outcomes, clinical processes, patient safety incidents and patient experience.

Developed and maintain Quality Database, dashboards and other data visualization tools to facilitate data analysis and reporting.

Collaborate with clinical and administrative staff to identify areas for quality and safety improvement.

Conducted statistical analyses to identify trends, patterns, and relationships in healthcare data.

Generating ad-hoc reports and presentations for healthcare providers, leadership, and regulatory agencies, summarizing findings and recommendations like continuous quality improvement (CQI) process, Rapid Cancer Reporting System, Commission of Cancer (Coc).

Participate in multidisciplinary quality improvement teams to provide data-driven insights and support to improve patient outcomes and reduce errors.

Running report in Qlikview for Cancer Mortality and analyzing the dashboard to provide data to end users.

Generated various ad-hoc and volume based report from Cancer Registry System- METRIQ for various disease; also generating stage based cancer reports.

Developed report and analyzed data out of EHR- Epic caboodle.

Developed and analyzed various ad-hoc reports using Slicer Dicer (EPIC) for patient volume, diagnosis etc.

Developed dashboard on ‘Patient Event’ and ‘Adverse Drug Reaction’ using Salesforce product – Riskonnect.

Trained on EPIC Caboodle Data Model, Clarity Data model and Cogito; Trained on Riskonnect.

Managed File Transfer Protocol (FTP)/Sharefile to transfer Data to external vendors (Savista).

Performed predictive analysis, discovery analysis and descriptive analysis.

PROJECTS

Implementation of a Lung Cancer Screening Program:

Duration: 12 months and ongoing

Project Description: As a member of the healthcare team, I was involved in implementing a Lung Cancer Screening Program. The goal of the program was to identify patients at high risk for lung cancer and to detect the disease at an early stage when it is more treatable. My responsibilities included working with the multidisciplinary team to develop the program protocol, identifying eligible patients and Analyzing the output of screening.

To achieve this, I performed various tasks, such as:

Specification gathering and identifying eligible patients through electronic medical records.

Coordinating with the pulmonologist to understand the screening process and working to build the report.

Collaborating with the billing department to ensure proper coding and reimbursement of screening exams.

The implementation of the Lung Cancer Screening Program has improved the early detection and pushed providers to do smoke screening at each PCP appointment. The experience gained during this project helped me develop skills such as project management, communication, and collaboration. I learned to work with different departments and disciplines to achieve a common goal, which I believe would be valuable in any healthcare-related field.

Disease Management Team(DMT)

Duration: 2 months and Ongoing

Requirement gathering on Data specification, Analytics, ICD-O codes and source of data.

Generating report from Cancer Registry (METRIQ) for Breast Cancer patient with new diagnosis, Analytic and Non-Analytic cases for All HHC facility.

Generating report from EPIC EMR for all Cancer patient with Primary and Secondary diagnosis.

Data Analyst June 2015 - March 2021

St. Barnabas Health Systems. New York City, NY

Role: Data Analyst in Healthcare Analytics and Business Intelligence Team of IT Department; reporting on many EHR and Practice Management, Ancillary Systems like Pharmacy, Lab and Radiology, Revenue Cycle Management projects at St Barnabas Health systems including Allscripts SCM, eClinicalWorks and McKesson (STAR)

Responsibilities

Developed, designed and analysed the queries using MS SQL Server Management studio 2008, 2018 tool and generated Moderate to Complex reports.

Optimizing, reviewing and debugging queries and reports

Hands on experience in Data Cleansing, Data Transformation and Data visualization.

Responsible for testing out the data in the data warehouse and pulling out Ad-Hoc requests based on the requirements for the Data Analytics and Clinical teams.

Responsible on creating Monthly reports for HEDIS MEASURES and modifying the query as needed.

Collaborating with key clinical/non-clinical stakeholders across different internal/external settings to implement the strategies and operational objective of DSRIP’s data analytics and reporting needs.

Provided structured reports in various formats i.e. Excel, CSV, Pivot Tables and Graphs

Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS.

Used SSIS to schedule the Reports to run on daily, weekly or monthly basis and also emailing them to user/requester to be reviewed in Excel Sheet, CSV.

Used sub-queries and complex joins to aggregate data from various sources for reports.

Created stored procedure, views and functions to faster the querying of data.

Troubleshooting the error and bug fixing in timely manner.

Extensive knowledge about all the phases on Business Analysis Life cycle like Requirements Elicitation, Requirements Analysis, Requirements Documentation and Requirements Management.

Developed Reports out of Electronic Medical Records (EMR) like Allscripts, eClinicalWorks.

Worked on Extraction, Transformation and Loading (ETL) process for data integration, data mapping and data conversion

Assessed customer need and goals through communication and system evaluations to modify existing database.

Familiar with data dictionary/fields definition for appropriate application.

Assisting in the maintenance, update and backup of database: merging old database into new ones.

Participating in software migration, upgrade process, activation support and on call support for applications during product upgrades.

Attended training on Healthcare/Business information application like QlikView, eClinicalWorks and Allscripts-CPM (Clinical Performance Manager).

Excellent communication, analytical, interpersonal and presentation skill; expert in managing multiple projects simultaneously.

PROJECTS

HEDIS MEASURES Healthfirst/ACO (Accountable Care Organization):

Duration: 2 Months of Development and Ongoing Monthly Reporting

Analysing the requirements to find the feasibility from different applications and connecting data tables on a custom Database to make the report easy to be visualized for the end users.

Developing Quality Measurement Reports using SQL- 32+ Reports developed.

Some Examples below:

Meeting requirements on Regular Well visits like Annual physical, Dental Visits and Well Child visits.

Pain screening, Functional Screening and Medication Reviews for older patients.

Cervical Cancer Screening, Breast Cancer Screening and Post-partum depression screening.

DSRIP (Delivery System Reform Incentive Program) (RCE, Patient Engagement, P4R):

Duration: 2 Month of Development and Ongoing Monthly\Quarterly Reporting

Analysed the requirements and created the reports for monthly and quarterly submission for the Program

Developed 7 Quality Measurement Reports for the Program.

ADHD Monitoring, Annual Depression Screening Measurement on Well patients, Hypertension, Diabetes Screening/Monitoring, DM screening on Schizophrenia patients on Anti-Psychotics, Screening on Cardiovascular patients with schizophrenia

Customer Service Executive March 2014 - October 2014 Get Through Guides (GTG) Pune, INDIA

Served as a basic point of contact for customer with queries, request, complaints and feedback

SQL- Running SQL queries for troubleshooting like user credentials retrieving and update user accounts.

Scheduling training session/exams and coordinating with multiple stakeholders like trainers, candidates, administrators and logistics

VISA STATUS

Passport/Visa Status: Have Indian passport and H4 Visa with Employment Authorization Document, valid till 1st August, 2024.

Data Analyst

Data Analyst with 8+ years of experience in overcoming decision-making and scalability issues by data driven solutions in Healthcare Analytics and Business Intelligence Industry. Proficient in Predictive Modelling, Data Processing, Data Mining and scripting languages. Capable of creating, developing, testing and deploying highly adaptive services to translate clinical, business and functional qualifications into substantial deliverables.

+1 (914) 536 - 7167

ad2i7y@r.postjobfree.com

Oradell, NJ

Phone:

Contact this candidate