Health Data

Sravani Soma

**** * ***** ****, ******, Texas C: 904-***-**** Email: *************@*****.***

Summary of Qualifications

2+ years of experience data collection, data analysis, and health administration

Highly proficient in MS Office tools, Access, and Visio

Experience working on public health research projects with large datasets; Lean Six Sigma Green Belt certified

Experience working with statistical analytical tool (SAS) and business objects as part of different healthcare projects

Detailed understanding of healthcare data such as claims, financial data, clinical data quality metrics and health outcomes

Skilled in performing root-cause analysis of a problem and possess excellent problem-solving skills

Proficient in analyzing problems and designing recommendations including workflow processes

Proven ability to quickly learn new systems, adapt to unique environments and thrive in difficult situations

Experience with improving processes and analyzing data to drive fact-based decision making

Sound knowledge of clinical trials, medical terminology, ICD 10, HCPCS, CPT, Medicare, and Medicaid

Experience working with state government rules, CFR, and CMS regulations

Flexible, innovative, and proactive with good interpersonal skills

High degree of accuracy and detail-oriented

Education

Master of Health Care Administration GPA:3.79

Texas State University Jan 2017 – Aug 2019

San Marcos, TX, 78666

Bachelor of Dental Surgery GPA:3.67

Dr. NTR University of Health Sciences Aug 2010 – Nov 2015

Hyderabad, India

Technical Skills

Microsoft Office skills: MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio, SharePoint, SQL

Statistical Analytical tools: SAS, SPSS

Database: MS Access

Operating System: Mac OS, Windows OS

Project Management tools: MS Project

Data Reporting tools: Tableau, Endnote

Data extracting tools: Business Objects (SAP)

Work Experience

Rate Analyst Sep 2019 – Present

Hospital Rates, RAD, Texas Health and Human Services Commission, Austin, TX

Perform rate analysis for Federally Qualified Health Centers, Rural Health Clinics, Inpatient and Outpatient hospital services for rural hospitals, urban hospitals, and children’s hospitals and update rates on a monthly basis

Build and run custom queries using Business Objects to retrieve data from TMHP database

Communicate with external stakeholders such as TMHP and internal stakeholders on a regular basis to discuss ongoing issues with the provider rates

Analyze cost reports and Medicaid claims data using advanced Excel functions to verify rates for Inpatient and Outpatient services

Creates training material and provides guidance to the team in the development and integration of new or revised methods and procedures

Consults with other agency staff and external stakeholders involved in the programs to identify potential problems, compliance requirements, and discuss program effectiveness

Analyzes data to help ensure compliance with Medicaid policies and procedures, statutes, and rules; and recommends corrective action(s) as needed

Collects, organizes, analyzes, and prepares materials in response to legislative and executive requests for program information and reports

Key Projects:

Successfully accomplished recent projects to verify historical rates for Rural Health Clinics and Federally Qualified Health Centers using advanced MS Excel for calculations and Pivot tables for analysis develops and developed action plans to improve the existing program

Accomplished a business project in collaboration with TMHP to generate automated query reports to make the monthly rate update process more efficient

Currently working on the Senate Bill 170 project to recalculate rates for rural hospitals and establish new methodology to reimburse Rural hospitals.

Program Specialist Intern/ Health Administrative Resident June 2019 – Aug 2019

Rate Analysis Department, Texas Health and Human Services Commission, Austin, TX

Developed, led, and completed major project on reimbursement rate calculations and created a consolidated document to simplify rate calculations for hospitals and clinics

Used Microsoft Visio to create and implement project plans and process workflow maps

Calculated and analyzed claims data for Medicaid population using Microsoft application tools

Restructured the training material to update monthly rate reports for staff

Performed rate analysis for inpatient, outpatient facilities, federally qualified health centers, and rural health centers

Communicated with several stakeholders to exchange and verify information, address queries, and resolve problems

Collected and retrieved large amounts of data from database and performed data analysis to determine payment rates for Medicaid and non-Medicaid programs such as Graduate Medical Education

Extracted consolidated data sets using business objects queries, analyzed, and updated rate reports on a monthly basis

Analyzed cost reports of healthcare providers to verify the reimbursement rates

Predicted and analyzed the financial impact of health plan initiatives for Medicaid population

Provided data analytic support to patient quality improvement teams working in different clinical roles

Analyzed policy documents and bills such as agency rules, state plan amendments, and Texas administrative Committee codes

Key Projects:

Researched and summarized the report outlining the Texas Administrative Code rules and associated federal regulations for Rural Health Clinics, Federally Qualified Health Centers, and Rural hospitals using Microsoft Visio and Excel

Graduate Instructional Assistant Aug 2017 – May 2019

Department of Biology, Texas State University, San Marcos, TX

Prepared and provided lab lectures focusing mainly on Human Anatomy and Physiology for pre-nursing, pre-medical sophomores, and non-biology major sophomores

Performed lab dissections, proctored, mentored, and evaluated student’s overall performance

Served as a team lead, provided guidance training, and assigned lab schedule & duties to the instructional assistant team

Integrated multimedia approaches and used instructional technology to enhance didactic approach

Facilitated student and community learning projects, both in and out of the classroom

Associate Dentist Oct 2014 – Dec 2016

FACE Dental Clinic, Hyderabad, India

Filed and maintained case reports, lab results, and other related documents into appropriate patient files

Procured detailed case histories of patients, including clinical and general examinations

Diagnosed and treated diseases, injuries and malformations of teeth, gums, and other oral structures

Performed routine oral examinations, restorations, extractions, prophylactic, and other dental services of the quality required

Successfully assisted experienced dental surgeons by performing four-handed dentistry and other chair-side duties

Counseled patients about the ill-effects of deleterious habits on oral health and educated patients about the importance of oral hygiene and plaque control procedures

Resident Dental Surgeon Oct 2014 – Nov 2015

Panineeya Mahavidyalaya Institute of Dental Sciences & Research Center, Hyderabad, India

Examined patients clinically to define the nature of the condition, diagnosed and treated accordingly

Performed various treatment procedures under the guidance of experienced doctors

Worked in teams and actively conducted and participated in healthcare education campaigns

Designed project protocol in collaboration with multi-disciplinary team including physicians, dentists,

and administrative staff

Undergraduate Research Analyst Oct 2014 – Nov 2015

Department of Oral Medicine & Radiology, Dr. NTR University of Health Sciences

Designed and structured a cross-sectional questionnaire-based study

Interviewed and collected data from 455 patients undergoing cancer chemotherapy, radiotherapy, or both

Created and maintained various data tables through statistical data analysis

Used SPSS statistical techniques for hypothesis testing to validate data and interpretations

Identified levels of anxiety and depression associated with chemo and radiotherapy and utilized multidisciplinary approach to improve overall health of patients

Honors

Inducted as a member of Upsilon Phi Delta Honor Society in Healthcare Administration 2019

Received Graduate College Scholarship - Health Professions, Texas State University 2018

Received Student Government Scholarship from Texas State University 2018

Received Academic Excellence Award from Panineeya Institute of Dental Sciences 2015

Publications

Kruse, C.S., & Soma, S. “Big Data and Health Information Technology’s role on Health Outcomes-A systematic review.” Paper under review in Health Policy and Technology Journal (HLPT-D-19-00019)

Nallan, C., & Soma, S. “Assessment of Anxiety and Depression in Oral Mucositis Patients undergoing Cancer and/or Radio Therapy-A Cross-Sectional Survey.” Paper published in Indian Journal of Palliative Care (“IJPC_12_16”)

Certifications

Base SAS certification by SAS institute Anticipated August 2020

SQL certification by MTA Anticipated August 2020

Excel programming with VBA by New Horizons Computer Learning Centers. June 2020

Service-Learning Excellence certified by Texas State University Nov 2018

Lean Six Sigma-Green Belt certified by Institute of Industrial and System Engineers May 2018

CITI certified by Texas State University March 2017

Contact this candidate