SAS Programmer

Rajesh I

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

Employer Email: **********@**********.***

Ph: 732-***-**** x 3039

PROFESSIONAL SUMMARY:

Certified Advanced SAS Programmer around 9 years of experience working in Health care, Clinical and Financial Industries.

Extensively worked on Medicaid, Medicare, Medicare Advantage, MyCare (Medicaid-Medicare dual eligible program) and several market place products.

Using the SAS Macros created reusable programs for the purpose of data cleaning, data validation, report generation, date manipulation, connecting to databases etc. in order to avoid the redundancy.

Extensive business knowledge on Claims (Medical, Dental, Rx, vision etc.), Member data, Provider data, case management data, call center data, authorization and pre-authorization data etc.

Extensive knowledge about the HIPPA guidelines, health care data, their terminology, the claim processing and payment methods, the various types of files (834, 837 etc.) and their data structure etc.

Played an important role in the SDLC process of creating a centralized portal where all the reports would reside which were accessible to various groups across the company.

Used the HP Quality center to load the test results and track down the defects.

Importing and exporting various types of files across SAS environment using the Import and

Export procedures, Dynamic Data Exchange methods etc

Expertize in using the SQL pass through facility and code in SQL language.

Customizing the variables to user defined formats using Proc Format during report generation

Responsible for creating several adhoc reports by connecting to different database engines using the libname statement.

High level understanding of the VB script to convert the XML files to XLS format.

Used the advanced concepts of MS Excel such as pivot tables, graphs and advanced functions VLOOKUP, IFELSE etc., Macros.

Created several MS-DOS batch files to schedule them on a Tidal Scheduler.

Experience in using the FACETS and Care Advance data for various reporting and analytical purposes.

Deployed the code through different environments using the BMC service Desk Express.

Peer reviewed the code and validated the test results generated by the other developers.

High level understanding of the ACG process and the John Hopkins Software that classifies members into various clinical groups which would help to forecast the future of their business.

Created several stored procedures in both SAS and SQL Server.

Proficient in analyzing clinical trial data, generating reports, tables, listings and Graphs according to Standard Operating procedures (SOPs).

Worked on several domains of SDTM like EX, CM, AE, MH, PD, LB,VS,EG, PK,TA, TV, SUPPQUAL and also on ADSL and BDS datasets of ADAM.

Involved in planning, writing and executing statistical programs designs to analyze data.

Preparing reports and listings in accordance with client specifications, analysis plans and industry guidelines.

Creating and deriving the datasets, listings and summary tables for Phase-I, II, III and IV of clinical trials.

Created datasets in CDISC SDTM V 3.1.2 format, based on CDISC SDTM implementation guide.

Statistical Knowledge to interpret the models and make valid conclusions from volumes of data.

Determining the one –way frequencies, multi-way frequencies for variables using Proc Freq

Experienced in data preparation for statistical modelling which includes data cleansing, descriptive statistics, missing data analysis, data validation and data reporting.

Performed predictive modelling, pattern discovery, market basket analysis, regression models, clustering.

Strong skills in Data Analysis, data requirements analysis, data mapping for ETL purposes.

Experience to handle large data for data cleansing, data profiling, and data scrubbing.

Knowledge of the statistical analytical methods like the Correlation analysis, ANOVA, t-test, market basket analysis etc.

Experienced in performing various unsupervised techniques like the Dimensionality reduction and clustering.

Knowledge in dealing with the association rules.

TECHNICAL SKILLS:

Statistical Packages

SAS 9.1, 9.2, 9.3

SAS Tools

SAS/BASE, SAS/MACROS, SAS/EG, SAS/STAT, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/GRAPH, SAS/Enterprise Minor

Operating Systems

Windows 98/2000/XP, UNIX, MS-DOS

Databases

SQL SERVER 2008 R2, SQL SERVER 2012,Teradata,MS Access

Languages

SQL, C, C ++, R, Python

Office Tools

MS Office (Word, Excel, Power Point, Visio, Access), Ultra edit

Business Intelligence

SAS Management Console, SAS Data Integration Studio, SAS Web Report Studio, SAS Information Delivery Portal, SSRS

EDUCATION: Bachelor of Pharmacy from GITAM College of Pharmacy, India

PROFESSIONAL EXPERIENCE:

CareSource, Dayton, OH Jun 2013 - Till Date

Sr. SAS Application Specialist (Multiple Assignments)

CareSource is a Non, profit Medicaid healthcare organization providing services primarily to Medicaid and Medicare populations across Ohio, Kentucky, Indiana, West Virginia and Georgia states.

1)Bridge To Home(BTH):

This is one of the CareSource innovate program to identify all inpatient admitted members that have been discharged from the hospital and to follow-up with them about the care that they received and would require after being discharged.

Developed the SAS code behind the project, been maintaining it and updating it as per the changes in the business needs using data step and proc SQL steps.

Was responsible for the automation of the business process using SAS Macros, creating a batch job, scheduling it on Tidal and for the centralized publication of it on a portal.

2)BI reporting:

Primarily responsible for the creation of new reports or updating the existing reports to include the parameters for HIX IN, HIX KY and HIX WV using proc sql.

Responsible for generating several adhoc operational reports using SAS EG for various business areas like the claims, enrollment, provider, customer advocacy, case management, finance areas.

Generated reports in various formats like the RTF, HTML, XLS, PDF, TXT, CSV etc using SAS/ODS and tagsets ExcelXP.

3)ICD-10 Project & Automation:

Responsible for modifying and updating most of the SAS reports and programs that uses the ICD 9 diagnosis and procedure codes.

Had to tune in a lot of reports to improve their performance using the “hashtag” concept in SAS.

Using the SQL pass through facility and the creation of temp tables the run time for many of the jobs have been improved.

Automated the reports using SAS macros and parm file, scheduled them on Tidal using a batch job and had the outputs published to a common portal.

4)SAS and Facets Upgrade Projects:

Was primarily responsible to test and analyze most of the SAS reports and ADV Programs to make sure that they run well without any breakage due to the SAS upgrade and /or the Facets upgrade.

Documented all the test results on the HP Quality control to track down all the defects.

5)Encounter Data Submissions & Regulatory Data Submissions:

Worked with the Encounters team for the data extraction and data submissions of the claim and encounters data to State and Federal bodies using SAS and SQL.

Worked with the finance team for the rate setting of the member for financial years of 2014 and 2015 using SQL Server Management Studio and Teradata SQL Assistant.

Made several data submissions to the vendors like AON, HSAG, ODM, KDMS, Scion (dental), CVS (pharmacy) etc.

Several regulatory reports for the KY Medicaid plan were generated and submitted to the KY State.

Generated MyCare regulatory reports for the CMS, CAMS files for the ODJFS departments etc.

6)Model Building and Assessment:

Data Preparation: includes identification of the data sources, data pulling through complex joins, maintaining data integrity during different phases of extraction, manipulation, processing, analysis & storage.

Data Exploration: includes treating the outliers using various SAS procedures, computing missing values, summarizing categorical data and reducing the amount of information to focus on the key elements of data.

Model Establishment: includes partitioning into validation, test & training datasets, planning appropriate model based on the data available, developing models through hypothesis testing, interpretation of the data, regression evaluation and to draw relevant conclusions.

Blue Cross and Blue Shield of Florida, FL Feb 2012 - Jun 2013

SAS Consultant

BCBS is one of the largest health care providers in Florida. This Project involves supporting the Actuarial and Analytics group with building ETL processes, reports to accommodate their new business needs.

Responsibilities:

Worked with Business team to analyze and understand the changes involved for the new business needs.

Analyzed the oracle data warehouse to design the ETL process and implement the business logic required using Data Integration Studio.

Hands on experience working on health care data including revenue, membership, claims and cost of health care data.

Built automated process to pull data from Oracle and load the resulting Flat files into Access and SQL Server.

Responsible for running of productionalized programs on monthly, quarterly basis.

Extensively used SQL Pass through for pulling data from Oracle and SQL Server

Designed and developed code using SAS/EG.

Built Cubes using OLAP cube studio which were utilized in Web Report Studio and Information Delivery Portal.

Hands on experience in using Enterprise Guide for building Stored Process.

Automated reports using SAS Add in for Microsoft Office.

Extensively used Humming bird for FTP purposes.

Mellon Financial Corporation, Pittsburgh, PA Jan 2011 – Jan 2012

SAS Programmer/Analyst

The project deals with assisting Data marketing team to understand customer behavior and reduce attrition rates, enabling the company to understand customer expectations. Marketers and product managers rely on these reports and analysis as they build marketing strategies and campaigns. This analysis uncovers best customers to give them better rates and services. My major role was to perform data analysis by using various SAS tools.

Responsibilities:

Developed statistical models using SAS programs that generated automated reports when run by the users to uncover new business opportunities

Developed an estimated model to derive new predictions and forecasts.

Data Extraction: Retrieved ORACLE tables and converted them into SAS data sets using with Proc SQL pass through facility and within Oracle by using SAS/Access, SAS/Connect, and SAS/SQL.

Extract, transform and load data from Teradata using SQL and fast export utility into SAS datasets, excel sheets, flat files, etc. and performed summary statistics no the data.

Reports: From the processed data, several reports were generated and also converted the data into dbf format and sent to the client. Also the reports were sent on to web, creating Universes using web intelligence.

Data uploading: Uploaded SAS data files into ORACLE tables using SAS ‘Dbload’ procedure.

Created Ad hoc reports and graphs as per the marketing team requirements

Sanjeevani Clinical Research Services, Hyderabad, India June 2009 – Dec2010

Jr. SAS Programmer

Sanjeevani is a reputed CRO working with several Pharmaceutical and Bio technological industries providing their services in pre-clinical research, clinical research and clinical trial data management.

Responsibilities:

•Developing the SAS programs for listings & tables for data review & presentation including ad-hoc reports, CRTs as per CDISC, patients listing mapping of safety database and safety tables.

•Experienced in statistical procedures like PROC MEANS, PROC FREQ, PROC REPORT, PROC TABULATE, PROC TRANSPOSE, PROC UNIVARIATE, PROC ANOVA and PROC GLM.

•Developed Macros for Data import, Tables and Listings.

•Involved in validating the TLF’s generated by the CRO’s and interacted with them for any data issues.

•Worked on several domains of SDTM like EX, CM, AE, MH, PD, LB, VS, EG, PK, TA, TV, SUPPQUAL and also on ADSL and BDS datasets of ADAM.

•Involved in planning, writing and executing statistical programs designs to analyze data.

•Preparing reports and listings in accordance with client specifications, analysis plans and industry guidelines.

•Generating the demographic tables, adverse events and serious adverse events reports.

•Involved in multiple projects and interacted with other SAS programmers, statisticians and data managers to analyze data.

•Exported data to various clients in the form of SAS Transport files over secure servers or on electronic media on regular basis.

Contact this candidate