PROFESSIONAL SUMMARY:

• Six years of experience as SAS Programmer and Data Analyst with Health Care and Medical Insurance providers in data processing, data integration and report generation using SAS.
• Three years of experience in using SAS Enterprise Guide and generated reports using the same.
• Performed ETL - Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and documentation.
• Using ODS to create HTML, PDF, RTF and PRINTER output.
• Experience in generating highly customized Excel reports using the special feature of ODS TAGSETS.
• Experience in generating Tables/Listings/Graphs TLG as per client's needs and requirements.
• Experience in Base SAS, SAS/Macros, SAS/SQL, SAS/STAT, SAS/Access, SAS/GRAPH, SAS/ETS, SAS/ODS. SAS/SHARE, SAS/Connect, SAS Enterprise Guide and SAS SQL.
• Strong expertise in SAS Base procedures, reporting and summary procedures.
• Experience with PROC SQL, SAS DDE and SAS Arrays.
• Experience in Data Management tasks such as data validation, data cleaning.
• Good Knowledge on ICD-9, ICD-10 and NDC codes.
• Experience using EBI tools using SAS Web Report Studio, Forecast Studio and Data Integration Studio.
• Highly experienced in working with Electronic Medical Record EMR Electronic Health Record EHR .
• Good understanding of Health care terminology such as HEDIS, CCD, HL7, Medicare, Medicaid, HIPPA, CPT, DRG and HCPAC.
• Experience working with data and claim forms such as CMS-1500 CMS-1450/UB-04.
• Quick learner with ability to understand job requirements, employ new ideas, concepts, methods, and technologies.
• Strong analytical, diagnostic skills and ability to work in a fast-paced and team-oriented environment.
• Highly persistent and motivated with willingness to assume responsibility.

TECHNICAL SKILLS:

Confidential

SAS Programmer

Responsibilities

• Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures and create SAS data sets.
• Performed data validation using SAS procedures to ensure data quality and consistency.
• Used SAS PROC SQL Pass through facility to connect to Oracle tables and created SAS Data sets using various SQL joins such as left join, right join, inner join and full join.
• Worked in both UNIX and Windows Environments.
• Maintained and enhanced existing SAS reporting programs.
• Generated formats using PROC FORMAT for frequently used variables such as CPT Current procedural terminology , HCPC, DRG Diagnosis related group , Program type, type of claim, type of service, diagnosis code, Adjustment Indicator etc.
• Validating data and creating reports using different procedures like PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORT etc. and SAS ODS facility.
• Performed documentation of the SAS Code for the better understanding of the program.

Environment: Base SAS, SAS Macros, SAS/Connect, SAS/Access, SAS/STAT, SAS ODS, SAS/GRAPH, Oracle 9i, Teradata, SAS V9.1.3, SAS Enterprise Guide, Excel, Windows XP, Toad, UNIX.

Confidential

SAS Programmer/Analyst

Responsibilities:

• As a programmer, was part of a project team that included statisticians, medical writers, data analysts and system analysts.
• Involved with data manipulation and using ODS TAGSETS in report generation.
• Assisted in development and presentation of statistical findings and conclusions.
• Worked in designing and developed data queries, analyzed reports to measure utilization, cost data, clinical outcomes, network performance and assisted in development of management presentations.
• Extensively generated reports using DATA NULL , Proc FORMAT, and Proc REPORT and also for data cleaning and validation.
• Worked on basic statistical procedures like Proc UNIVARIATE, Proc ANOVA, Proc PHREG etc.
• Created Kaplan-Meier curves for Survival analysis using Proc LIFETEST and Proc GPLOT.
• Generated output files in LST, HTML, RTF PDF formats using SAS ODS.
• Supported Statisticians to make various characteristic graphs.
• Assisted in writing analysis plans including specifications for tables and listings.
• Developed SAS Macros within the programs.

Environment: SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/MACROS, SQL, DB2, Windows XP, MS Excel, UNIX

Confidential

SAS Programmer/ Data mining

Responsibilities

• Reviewed existing literature on Medicare, Medicaid and models dealing with Medicaid fraud.
• Attended various seminar presentations on Medicaid fraud such as finding duplicate claims, service after death, multiple service providers etc.
• Modified existing SAS programs for facilitating migration from Mainframes to Oracle data engine.
• Used SAS/ASSIST to extract data from SAS Files and Oracle Data base.
• Involved in writing code using Base SAS SAS/Macros to clean and validate data from oracle tables and conducted data investigation.
• Involved in developing various fraud algorithms and validated existing algorithms against specification.
• Generated formats using PROC FORMAT for frequently used variables such as CPT Current procedural terminology , HCPC, DRG Diagnosis related group , Program type, type of claim, type of service, diagnosis code, Adjustment Indicator etc.
• Used SAS import procedure to generate temporary and permanent SAS data sets from txt, csv and excel data sets.
• Created various Graphs using SAS/GRAPH and SAS/GPLOT.
• Validating data and creating reports using different procedures like PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORT etc. and SAS ODS facility.
• Extensively used statistical procedures and predictive modeling techniques such as ANOVA, Regression Analysis, Trend Analysis, Cluster Analysis and Principle Component Analysis.
• Conducted QA for macros generated by other programmers using Macro options MLOGIC, SYMBOLGEN, MPRINT, MACROGEN etc.
• Performed documentation of the SAS Code for the better understanding of the program.

Environment: Base SAS, SAS Macros, SAS/Access, SAS/ASSIST, SAS/STAT, SAS/GRAPH, ORACLE, MS Excel, Windows XP, UNIX.

Confidential

SAS Programmer

Responsibilities:

• Managing large data sets and executing quality review procedures and worked with managers to identify and resolve data problems.
• Involved in developing statistical analyses using standard and ad- hoc reporting and data mining tools to identify patterns and trends.
• Worked on writing, editing, validating and debugging code in BASE SAS and MACROS.
• Developed and modified existing SAS code for loading data from the source to create study specific datasets.
• Involved in data cleaning, data validation and identification of bad data.
• Collaborated with statisticians and health care data managers to provide SAS programming for analyzing the data and generating reports.
• Extensively used PROC REPORT for generating detailed reports.
• Used DATA NULL for data cleaning and data validation.
• Generated HTML/RTF/PDF files using ODS output.
• Accessed Oracle data tables using SQL 'Pass through Facility' and modified data using PROC SQL.
• Presented data analysis in graphs using SAS/GRAPH.
• Worked extensively on SAS functions, arrays, formats, delimiters and labels.
• Performed various ad-hoc analyses as per user's guidelines and requests.

Environment: SAS/BASE, SAS/ODS, SAS/ACCESS, SAS/GRAPH, SAS/Macros, Oracle 8i, PL/SQL, Access, Excel.

Confidential

SAS Programmer

Responsibilities:

• Extracted the data from database using SQL queries and created SAS data sets.
• Used Proc Import statement to convert delimited files like .CSV files into SAS data files.
• Performed categorical statistical data analysis on sales and marketing information.
• Performed consumer profiling and sales forecasting, generated customer lists for various departments to determine retention strategies.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques using SAS/Base.
• Extensively used SAS/Macro facility to create macros for statistical analysis, results reporting and data extraction.
• Conducted Anova and Regression analysis.
• Generated HTML, Listings, Excel and RTF reports for presenting the findings of various statistical procedures using Proc Report and Proc Print.
• Created reports from analysis as per the client's requirements.

Environment: Windows 2000/NT, SAS 8 Base SAS, SAS/SQL, SAS Macros, SAS Graph , Oracle