Ruchi Patidar

415-***-****

adv3qy@r.postjobfree.com

*** ***** ****. *** **-N

Jersey City, NJ 07302

EDUCATION

Fordham University, New York

MS, Information Systems

Graduated Dec 2016, GPA - 3.5

DAVV University, India MBA, Hospital Administration

Graduated May 2011

DAVV University, India BBA, Hospital Administration

Graduated May 2009

PROFESSIONAL EXPERIENCE

Population Health data Analyst (ACO)

New York Presbyterian Hospital November 21- May 22

Created, maintained, and Updated tableau dashboards for total attributed population among different entities of ACO for Medicare Fee for Service (FFS). Created Demographic trend analysis for last 5 years of Attributed population among all the entities of ACO using tableau dashboard and presented to Upper Management.

Maintained and updated tableau dashboard using Sql Stored procedures for pilot project for determining population that completed Annual wellness visits among all the entities to Maximize the number of Annual wellness visits for Beneficiaries who are new to Medicare as well as beneficiaries that did not complete the AWV. To increase the quality of care as well as maximize the shared saving costs.

Coordinated and participated in planning, definition, design, and implementation of the reports with appropriate Stakeholders.

Created, maintained, and updated reports on Excel for Expenditure and Utilization of attributed Beneficiaries based of attribution files provided by CMS on Quarterly Basis.

Presented the data and Findings to care management teams and practice management teams for all Entities.

Created stored Procedures to determine New to Medicare beneficiaries to provide quality care by keeping in check of Chronic Conditions, maintaining correct Diagnosis code, and maintaining risk Scores and Increase attribution.

Have thorough Understanding of HIPPA, HCPCS Codes, Medicare FFS plan.

Understand CCLF claims data. Part A part B claims.

Basic Understanding of Epic Database, Extensively Used Patient electronic medical record (EMR)data as well as external sources of data to gather information.

Helped quality project to perform chart reviews for Quality measure reporting.

Created Ad hoc reporting for billing team to understand the gaps for unpaid claims and provided the solution.

Risk Adjustment Analyst/Financial Coordinator August 2017- November 2018

Fidelis care (Centene Corporation) (New York)

Extract data from various internal and external databases and integrate into one database by building SQl queries.

Examine every weekly submitted Medicare encounters from facets to CMS by building the process using SQl queries.

Staging the data into single integrated process by creating views in postgre database, sql server database.

Manipulating data by creating flags and indicators to determine, gaps, exclusions, rejections, acceptance of each Medicare encounters submitted on weekly basis.

Create weekly reports in excel using pivot tables to get an overview scenario of the encounters.

Build the complete process of submission of encounters from facets to CMS using Complex queries. Stored the integrated data into single table.

Performs analytics on the data and give the solution to each and every claim.

Maintain a report in form of tracker to reflect the status of each encounter submission.

Develop and revise system design as per the reporting requirements for upper management to ensure quality and standards.

Volunteer

Jersey City Medical Center, Foundation department, May 2017 – August 2017

Performs social media analysis of Facebook, twitter and Instagram for competitor Non Profit hospitals using various key performance indicators using various online tools.

Conducted Data Analysis of tickets sold for fund raising events using Pivot table.

Conducting Research on future community events such as leadership summits, Business conferences, Arts and Cultural events, Gala, Shows, events focusing on any particular group of people etc. organized at Jersey City, Bayonne and Hoboken.

Analytics Intern

St. Barnabas Hospital, Sept 2015 – Dec 2015

Conducted meaningful use analysis for clinical and Nonclinical data. Primary care physician’s report.

Performed in depth analysis of hospital’s data to capture high resource consumption, high readmission rates, Mortality rates with the help of important KPIs like Case Mix Index (CMI).- Avg stay/diagnosis, DRG- Avg cost/Pt/day by creating advanced tableau dashboards.

Analyzed data and prepared data trend reports.

Designed reports for the use of clinicians and administrators.

Created HIV reports using tableau based on survey and study with the help of patients and provider’s Notes.

Helped database administrator to manage tickets from different departments to solve them in timely manner

Performed analysis of Patient’s satisfaction with the help of written questionnaire surveys as well as Phone surveys.

Involved in ICD10 Implementation.

Communicated with different departments for their performance and areas of improvements.

Participated in DSRIP PPS Performance reporting meetings.

Supported DSRIP Project Managers with data collection, validation, analysis, presentation, and dissemination of information as requested.

Very well understanding Of HIPAA and PHI.

Operations Analyst

Rajshri Apollo Hospital, Oct 2011 - Oct 2012

Served as liaisons between business users and department to identify strategies for evaluation of key performance indicator (KPI’s), quality metrics, outcome evaluation.

Worked with departmental staff to identify requirements for reporting and intelligence tools.

Data analysis of clinical and operations data sets.

Maintained consistency and integrity of data collection and storage.

Performed Analysis of functional requirements to identify information, procedure and decision flow.

Prepared departmental reports for performance improvement activities.

Reviewed data to assure accuracy and analyze trends using statistical tools and graphs.

Created presentations and ad hoc reports for upper management.

Created reports and queries using MS office programs, and in various relational databases such as oracle, MySQL server.

Created daily, monthly and yearly reports for management using excel.

Operations Analyst

Rare Hospitality Services, May 2011 - Oct 2011

Created Business Intelligence reports, statistical reports for finance department.

Analyzed and interpreted large sets of data by maintaining the integrity of data.

Created analytical reports using statistical software like SAS, MS Excel, MS Access.

Designed the process to optimize patients discharge procedure/process to save time.

Created reports on the sustainable solutions, which are crucial to report on the success, we have achieved in order to build support within the organization.

Involved in data mining, data analysis, data discovery, data modeling.

Prepared reports and presentations for upper management using MS Powerpoint.

SKILLS

SQL

Excel

Tableau

SQL Server Management Studio

Business Intelligence

Business Analysis

Project Management

Microsoft Project

Microsoft Access

Microsoft Office

Epic

Contact this candidate