Sheetal Chaudhary

Phone: ***- ***-****

Email: ad0n1n@r.postjobfree.com

Summary:

Sheetal has 7+ years’ experience in Data analysis and reporting in health care sector using SAS (Base and Enterprise Guide)

Experience connecting and extracting data from DB2, Oracle and RedShift Amazon database.

Experience connecting to Amazon Redshift Database using SAS Libname. Experienced in handling large data volumes for Data Cleansing, Profiling, and Scrubbing.

Experience working on SAS in Unix Environment and Red Hat Linux enterprise.

Working on large claims datasets for generating claims extract.

SAS experience includes detailed statistical analysis of healthcare data, developing and modifying SAS programs for production of reports, tables, graphs and listings, utilizing SAS Procedures, Macros, and other SAS applications.

Data Transformation/ETL.

Client reporting and support.

Collaboration across different teams.

Technical Skills:

Epidemiological data analysis using statistics software: SAS, R, SPSS.

Statistical Methods: Knowledge of Basic and Advanced Biostatistics.

Classification: Linear regression, Methods of analysis of variance including ANOVA, ANCOVA, Repeated Measures, Time Series, Categorical Data Analysis including Logistic Regression, Nonparametric Methods, Survival Analysis and Multivariate Methods.

Office Software: Word, Excel, PowerPoint,

SAS Skills:

Data Steps, SQL, MACRO, ODS, GRAPH

SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/ACCESS in UNIX, Proc SQL and Windows environments, DB2 database.

Construct SAS datasets and develop SAS coding/programs and table templates for preparing, processing and analyzing data.

PROC REPORT and ODS to generate EXCEL, PDF, CSV and HTML file formats.

SAS BADGE for programming.

Professional Experience:

Current:

Convergenz LLC

Client: US. Bureau of labor Statistics Jun2022 till date

Washington, DC 20212-0001

Role: IT Software Engineer II(SAS)

Job Responsibilities:

Working on SAS in Red Hat Linux enterprise.

Working on Agile environment with participation in grooming and scrums.

Extensive SAS development using proc and data steps.

Generation of datasets to load the oracle database.

Using advanced macro in SAS programs to increase the efficacy, flexibility, and dynamicity of the program.

Generating back-end SAS programs to support the UI screens executed at the user end.

Using JSON libname engine to create JSON MAP and convert JSON input data into SAS dataset.

Generating range of formats to be extracted from version-based tables using PROC Format CNTLIN

Regression testing of development and production data.

Creating specification documents to support the SAS programs.

Creating the unit testing document to validate the data generated.

United Medical Resources, Inc. Jul2019 till June 2022

(HSB merged with UMR in Jul2019)

Role: SAS Programmer Analyst

Job Responsibilities:

Use of SAS application for Data Cleansing, Data Profiling and Data Scrubbing.

Client Report and Support.

Use of PROC EXPORT, PROC IMPORT procedures to build external datasets, flat files and to extract claims/eligibility data.

PROC REPORT & ODS to generate EXCEL, PDF, CSV, HTML file formats.

Data Transformation/ETL. Format the data using data functions like SCAN, TRIM, STRIP, SUBSTR and other similar functions and application of strategic logic on data using INTCK, INTNX, SUM, SORT and VAR to get data in the required format.

Use of SAS macros to increase the efficiency of the code and automate the report run.

Data Analytics. Perform data analysis using PROC FREQ, PROC MEANS, PROC TABULATE, PROC SUMMARY when required. Performing sampling of claim data using PROC SURVEYSELECT.

Write SQL queries using PROC SQL to generate ad hoc report.

Use of ultra-edit to edit the flat file, perform SAS CODE comparison and accessing files from remote service.

Assisting in smooth migration of clients from HSB to UMR.

Migrating jobs from VMS to SAS environment.

Loading the open enrollment files to HAXS (IBM Unidata based system).

Reliable and competent team player. Enthusiastic to learn new skills and model into new role.

HealthSCOPE Benefits, Inc (HSB) Little Rock AR Aug 2018 to Jul2019

Role: SAS Programmer Analyst

Job Responsibilities:

Create, modify jobs and processes to load medical, dental and vision eligibility to

HealthAxis(IBM Unidata based system).

Generate outbound eligibility and claims data extract using SAS to provide to different Health Care Data Analytics companies, Pharmacy Benefit Mangers like CVS/ Walgreens.

Provide Medical Authorizations and Pre-Cert files to hospital-based organizations.

Generate ad hoc Report using SAS and from HealthAxis using Unidata coding.

As required perform medical claims and eligibility data research, analysis.

Generate medical audit claims files.

Deal directly with different vendors and clients to establish outbound and inbound file feeds.

Working Knowledge of Medical Claims and Eligibility.

Handle production issues.

Client: Arkansas Blue Cross Blue Shield, AR Nov 2015 to May2018

Role: SAS Programmer Analyst

Project: Worked on multiple internal projects for generation of Ad-hoc reports.

Responsibilities:

Gather and analyze new reporting requirements from business end users, determine resolution plan and design specifications.

Code validations, comparing code using ultra-edit, and testing.

Promotion of code/ SAS stored process from DEV to TEST and PRODUCTION environment. Use of SAS report promotion tool: IBM URBAN CODE DEPLOY

Generated programs to create SAS data sets/ import external data to generate SAS data sets, resolving Production issues, data cleansing. Export datasets and generate the desired output files.

Extract, aggregate, normalize and analyze large data sets using SAS.

Initiation of DMMI tasks

Use of Advanced Query Tool (AQT) to analyze the data and run SQL queries.

Prepared formatted output for clients and reports using ODS and PROC REPORT.

Working with Secure CRT and introductory knowledge of UNIX commands.

Clinical Research Experience:

Clinical Research Coordinator, Sahyadri Specialty Hospital, Pune, India

February 2008 to August2009

Worked on two clinical trials with following titles:

1.) Sanofi Aventis - An International, Multicenter, Randomized, Double-blind, Double-dummy, Parallel Group, Study of 3-month or 6-month Treatment With SSR126517E (3.0 mg s.c. Once-weekly) Versus Oral INR-adjusted Warfarin in the Treatment of Patients With Symptomatic Pulmonary Embolism With or Without Symptomatic Deep Venous Thrombosis.

2.) Pfizer- Prospective, Open-Label, Comparative, Multi-Center Study Of Voriconazole Compared To Itraconazole For The Primary Prophylaxis Of Invasive Fungal Infection (IFI) With Allogeneic Hematopoietic Stem Cell Transplants (HSCT).

Duties performed as Clinical Research Coordinator:

Enrolling the subjects in clinical trial based on eligibility criteria, documenting consent and completing all regulatory paperwork.

Manage and maintain clinical study observations and activities including case report forms, drug dispensation records, or regulatory forms.

Respond to quality assurance audits conducted by study sponsors.

Collecting blood samples and patient education on the medicines under testing.

Performed patient assessment and recording of patient symptoms, adverse events and side effects and reporting it to the study sponsors.

Resident Doctor, Sahyadri Specialty Hospital, Hematology Department, Pune, India

July 2005 to August 2009

Worked under the guidance of senior hematologists in managing the patients with hematological malignancies and diseases, assisted in Allogeneic and Autologous bone marrow transplants.

House Doctor, Sanjeevan Hospital, Pune, India

February 2001 to June 2005

Gynecology & Obstetrics - Individually performed deliveries and assisted in Cesarean Sections.

Pediatrics & Medicine – Conducted routine ward duties and procedures (recording vitals, performing lumbar puncture, inserting long lines, Foleys catheter insertions, venesection etc.) and managed emergency cases of cardiac arrests, respiratory arrests, convulsions.

Oncology - Administration of chemotherapy drugs and intrathecal drugs.

Internships:

Intern at University of Toledo Medical Center, Department of Urology, Toledo, Ohio.

January 2014 to May 2014

Internship Activities:

Worked on retrospective cohort study with the data base of 297 patients who had renal cell carcinoma tumor.

Data analysis of renal cell carcinoma tumors using R software, writing search paper to support the hypothesis of the data analysis.

Intern, Sanjeevan Hospital, Pune, India

January 2000 to January 2001

Rotational training in Medicine, Gynecology and Obstetrics, Surgery, ENT, Ophthalmology, Orthopedics, Pediatrics, Dermatology, Dental OPD'S and in Emergency and ICU wards.

Intern, Naidu Hospital (Infectious Disease Hospital), Pune, India

July 1997 to September 1997

The internship was part of the course for preventive and social medicine; I acquired clinical training in identifying patients with different infectious diseases and learned basic preventive measures and therapeutic treatments.

Medical Workshops:

Conducted Basic Life Support work shop. January 2004.

Performing the venesection procedure and organized health and blood donation, checkup camps April 2004 & August 2008.

Volunteered in anemia detection program for women in rural areas. May 2002.

Workshop Responsibilities:

Performed clinical examination of women’s to identify the women with anemia symptoms, recommend dietary/ nutritional guidelines to improve hemoglobin levels, provided secondary care in treatment to patients requiring advanced evaluation of anemia.

Education:

MPH - Master of Public Health (Epidemiology),

The University of Toledo, College of Medicine & Life Sciences May 2014

Toledo, Ohio, USA.

Bachelor of Science (Homeopathy Medicine and Surgery)

DSH Medical College, University of Pune, India Jan2001

Contact this candidate