Clinical SAS programmer

Preeti Naik

Email id: *******@*****.***

Mobile: 732-***-****

Summary:

SAS base certified, with 3.5 years of SAS/SQL programming/analysis experience on Windows and UNIX environment with knowledge on methodologies, applied in Health care & Financial Domains.

Experience in all phases of Software Development Life Cycle (SDLC) including Requirements, Analysis/Design, Development and Testing.

Good experience in Health Administration Claims processing (Auto adjudication), HIPAA, PPACA (Patient protection and Affordable Care Act) enrollment, EDI, Medicare & Medicaid.

Extensive experience in SAS/SQL programming and data analysis on Windows environments.

Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT

Extensive experience in working with Base SAS (MACROS, Proc SQL, ODS), SQL, SAS/Graph, SAS Enterprise Guide, SAS/ACCESS in Windows environment.

Strong SAS programming background for creating, maintaining existing code, ad hoc reporting and supporting the reporting functions.

Experience in handling client meetings for updating current projects and to discuss on further projects.

Have strong experience on working with Data which includes various Healthcare claims and Membership Information.

Modified existing SAS programs and created new SAS programs using SAS Macros to improve ease and speed of modification as well as consistency of results

Quality assurance procedures of other programmers’ work, validating, debugging, documenting and optimizing SAS programs for QC and QA

Experience with export SAS Results to different formats such as XML, PDF, Excel using SAS/Export, SAS/ODS for reporting and presentation.

Familiar with RDBMS and able to handle SQL to retrieve data from the database with experience in Data profiling, Data clean up and Data analysis

Experience working with marketing team to conduct exploratory data analysis and Expertise in statistical, quantitative and analytical data in financial sector

Excellent verbal and written communication skills with strong analytical, qualitative, quantitative, and problem solving skills.

Updating with changes in technology and the business implications/applications of new technologies with constant learning urge.

Technical Skills

SAS Procedures

Report, Print, Freq, Means, Summary, Univariate, SQL, Sort, Transpose, Contents, Options, Import, Export, Format, Gplot

SAS Tools

SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/MACROS, SAS/ODS.

Operating system

Windows

Applications

MS Office, SQL, SAS Enterprise Guide

Professional Experience:

SAS programmer: Sep 2016 to Dec 2016

Zeeta Analytics – Mumbai, India

Responsibilities:

Successfully designed and implemented statistical reporting processes for regular data collection and Clinical data analysis. Analyzed safety and efficacy data from Phase I, II and III Clinical trials.

Developed and maintained programs in SAS using SAS tools for Windows in a user support environment.

Have worked on extracting raw data and creating SAS data sets those are required for project analysis.

Performed statistical data analysis, generated ad-hoc reports, tables, listings and graphs using tools such as SAS/Base, SAS/Macros, SAS/SQL.

Performed documentation on all programs, files and variables for accurate historical records and for future reference.

Extensively used SAS/Macro facility to provide reusable programs that can be conveniently used time to time.

Performed testing, documentation, review, and verification of all programs according to SOPs.

Performed sorting and merging techniques on the input data sets for Data Preparation.

Cleaned, transformed, analyzed, and presented Clinical data using PROC SQL.

Data preparation & validation and Drawing flowcharts indicating the input data sets, sorting and Merging Techniques to get the required output and then writing the code using SAS/Base Include SAS/SQL, SAS/Macros. Data is validated before use for final analysis.

Created analysis data sets and performed statistical analysis on raw data to achieve safety and efficacy objectives of the study using SAS procedures like Proc Means, Proc Freq, Proc Reg, Proc Sort etc.

Data Analysis: Based on the Protocol and guidelines in therapeutic areas, the data is analyzed using SAS Statistical Procedures such as Proc Means, Proc Tabulate, and Proc Freq.

Performed validation of data sets, tables and listings created for safety and efficacy studies which includes adverse events, Concomitant medications, Laboratory data values and Vital signs.

Generated tables, listings and graphs in different formats like PDF and RTF for safety and efficacy analysis for the study according to the specifications.

Have knowledge on CDISC and SDTM mappings.

Have knowledge of the FDA Guidance, Regulatory Compliance, and Good Clinical Practices (GCP)

Created reports based on Statistical analysis using Minitab and Excel.

Insurance Associate: May 2013-Aug 2013

Prudential Process Management Services –Mumbai, India

Customer service, MS office, Communication.

Provide service to the prudential customers which involved amending member’s record like name, address, bank details change.

Worked on Goneaway and missing payments process which involved tracing the member and dealing with members missed or failed payments.

Associate: July 2011 to May 2013

Next Services HSS Pvt. Ltd– Mumbai, India

Generated Tables and Listings for the clinical trial study as per client requirements.

Create Population file based on the specifications.

Run descriptive statistics using Proc Means, Proc Freq and Proc Univariate using SAS/Base tool.

Have worked on extracting raw data and creating SAS data sets those are required for project analysis.

Generated output in various formatted files such as Excel sheets, RTF and PDF using SAS/ODS.

Responsible for defining variables, merging datasets, creating derived datasets, data validation before processing.

Generate reports as per the client’s requirements.

Hands on experience in working on AMD (AdvancedMD), a web based EHR (Electronic Health Record) and PMS (Practice Management Sysytem) software used as a medical billing tool which is an ideal software solution for creating a paperless medical office.

Worked on eClinicalWorks a web based tool which allows users to access patient information from a hand-held device.

Worked on updating patients detail along with insurance detail in AdvancedMD.

Did process QA for the details filled in AMD.

Posting Patients billing procedure in AdvancedMD

Sending payment statement to patients.

Posting Payment details from insurance & patient in AdvancedMD.

Using LogMeIn tool, for secure remote desktop access.

Correctly coded and billed medical claims for various hospitals and nursing facilities.

Precisely completed appropriate claims paperwork, documentation and system entry.

Thoroughly researched newly identified diagnoses and/or medical procedures to expand skills and knowledge.

Verified patients’ eligibility and claim status with insurance agencies.

Researched CPT and ICD-9 coding discrepancies for compliance and reimbursement accuracy.

Maintained strict patient and physician confidentiality.

Resourcefully used various coding books, procedure manuals and on-line encoders.

Actively maintained current working knowledge of CPT and ICD-9 coding principles, government regulation, protocols and third party requirements regarding billing.

Performed billing and coding procedures for ambulance, inpatient and outpatient services.

Identified and resolved patient billing and payment issues.

Running End of the Day reports

Giving monthly & weekly summary reports to the client.

Customer Care Executive: May 2010 to June 2011

Cheryl’s Cosmeceuticals – Mumbai,India

Interacting with customers (beauticians) for explaining about pros and cons of the Cheryl’s Cosmeceuticals beauty products.

Explaining the procedures of skin, hair, heel, eye treatment etc & its maintenance to the beauticians over the call.

Taking order of the products from beauticians & placing it to the respective distributors.

Timely assistance to beauticians for explaining about the beauty products usage.

Education:

Microbiology Graduate from Mumbai University, India

Advance Clinical SAS Programming from Star IT Solutions. Mumbai (India)

Certification: SAS Certified Base Programmer for SAS 9

Work Authorization: H4 EAD

Contact this candidate