SAS PROGRAMMER / SAS DATA ANALYST

• Certified SAS/BASE and SAS Advance programmer
• 8 years of experience in SAS Programming, with proficiency in SAS/Base, SAS/Macro, SAS/SQL, SAS/Stat, SAS/Graph, SAS/Access, SAS/Intrnet and SAS/EG.
• Well versed with merging SAS data sets, macro facility, preparing analytical aatasets, and producing reports using advanced programming techniques.
• Provided data management and data quality control to various research projects like HIV surveillance, clinical trials and healthcare data.
• Implemented best practices and develop solutions to promote effective data management and analysis in several critical research projects.
• Performed various statistical analytical procedures to derive intelligence from public health data enabling CDC public health project coordinators to improve project specific procedural decisions.
• Collaborated with statisticians and Principle Investigators to develop statistical analysis reports, tables and graphs by using statistical software like SAS and SPSS for various research papers.
• Working experience in SAS Data Integration DI studio, SAS Management console and SAS BI suite.
• Proficient in working on Unix /Linux and Windows platform.

PROFESSIONAL EXPERIENCE

Confidential

• I am working as SAS Programmer ETL , responsible for performing healthcare data analysis and programming that supports health plans operations in Confidential
• Following are my job duties in detail:
• Develop ETL processes using SAS Enterprise Guide, Data Integration Studio, and DataFlux Data Management Studio to populate Data Warehouses
• Design and develop SAS programs to manage health insurance claims transaction data, prescription drug claims, enrollment data and provider data, particularly. Extract data from Medicare-Advantage data files including Monthly Membership Report MMR , the Model Output Reports MOR and RAPS files or the Medicare Standard Analytical Files.
• Analyze source data/file structures, profile source data and develop data mapping and transformation rules.
• Integrate data from various system sources flat files, CSV, text form, and other formats into warehouse.
• Develop utilities for QC/QA and analyses of the data
• Design and develop project-specific SAS programs, and produce analysis datasets, reports and graphics
• Prepare and maintain documentation to support design, review and validation of ETL developments.
• Coordinate and communicate customer and system issues with internal resources.
• Follow policies and procedures to insure organization is compliant with HIPAA and other privacy and security requirements.

Confidential

• Worked as a SAS programmer for ANISA study in the Respiratory Diseases Branch at NCIRD, CDC. The ANISA study was designed to improve newborn and young infant survival by characterizing the causes of serious infections in early life in Bangladesh, India and Pakistan. As a primary data manager, I was responsible for providing technical consultancy over data management system to the study sites. I was also responsible for monitoring the quality of the lab data and tracking key indicators to identify any problems with either the laboratory or field work requiring further investigation.
• Following were my job duties in detail:
• Import data files from Microsoft SQL server into SAS Data Sets for cleaning and analysis using Proc Import and SQL ODBC connection
• Perform Data cleaning, merging and formatting of datasets using SAS/Base, SAS/Macros SAS/SQL
• Develop a series of SAS reports to monitor and assure quality of lab data using statistical procedures like PROC REPORT, TABULATE, PROC MEANS, PROC SUMMARY, PROC FREQ etc.
• Assist the coordination team by developing Data Management guidelines for data cleaning and delivering data to CDC
• Develop and maintain data dictionary and data management SOP
• Monitor, analyze, and synthesize large volumes of laboratory data received from multiple study sites using SAS

Confidential

• Worked as a scientific data analyst in division of HIV/AIDS prevention at CDC. I provided data management and data quality control to various research projects like HIV surveillance, clinical trials and other HIV related intervention and cohort studies. I was responsible for implementing best practices and develop solutions to promote effective data management. I was responsible for receiving incoming data, process the data into appropriate data warehouses, provide quality assurance SAS programming and provide analytical programming support.
• Following were my job duties in detail:
• Import/convert data files from Excel, MS Access tables, Microsoft SQL server into SAS Data Sets for cleaning and analysis using Proc Import and SQL ODBC connection
• Perform Data cleaning, merging and formatting of datasets using SAS/Base, SAS/Macros SAS/SQL
• Maintain and update master database
• Produce SAS reports using procedures like PROC REPORT, TABULATE, Data Null, and also provide reports on descriptive statistics using PROC MEANS, PROC SUMMARY, PROC FREQ, and PROC ANOVA
• Statistical analysis of data using SPSS and SAS procedure like Proc Logistic, Genmod , Univariate, Phreg regression analysis , lifetest Kaplan-Meier Survival Analysis , t-test, Wilcoxonsigned-rank test
• Generate reports, tables, listings and graphs using SAS/Base, SAS/Macros, SAS/GRAPH and SAS/STAT
• Creating analysis data sets and also validates analysis datasets
• Import and export SAS datasets into other formats like SPSS and excel
• Create ad hoc reports and analytical datasets for research abstracts and manuscripts upon request of the Statistician
• Collaborate with statisticians/laboratories/principal investigators as needed
• Provide automated SAS programs for on-site international study personnel to use
• Provide data management assistance and trainings to the international sites

Confidential

• Assisted at the Department of Pharmacology, Emory University Atlanta. Working on chromatin immunoprecipitation assay for iNOS gene using NFkB P65 antibody in rat hepatocytes and rat liver treated with LPS and IL-1. Studying the transcriptional effect of NfkB regulation on genes involved in inflammation.
• Assisted in the Department of Cell Biology Involved in screening of third chromosome of drosophila at Emory University Atlanta.