SUMMARY

• SAS Programmer with over 7 years of experience in SAS v 8.2 and 9.x on Windows, UNIX in Healthcare/Pharmaceutical industry.
• Knowledge and Experience in Base SAS, SAS/MACRO, SAS ODS, SAS/GRAPH, SAS/SQL, SAS/STAT, SAS/Connect, and SAS/ACCESS.
• Strong knowledge in analyzing data from different phases of clinical trials (I - IV) and performing secondary data analysis.
• Experience in SAS Procedures like Proc Print, Proc Report, Proc Summary, and Proc contents, ProcFreq, Proc Tabulate, Proc Means, ProcUnivariate, Proc Transpose, Proc ANOVA, Proc Mixed, Proc GLM, ProcCorr, Proc Regression, ProcLifetest and Data NULL .
• Worked with statisticians to analyze clinical data and generated tables, figures and listings (TFL) for the same generated output files in RTF, HTML, and PDF format using SAS ODS and to provide SAS programming in analyzing the Clinical Trial Data, generate reports, listings and graphs
• Three years of experience working as SAS Programmer for Pharmaceutical Company.
• Experience in developing SAS Procedures, Macros, and application for data cleaning, reporting and involved in preparing documentation.
• Thorough knowledge in different phases of clinical trials and clinical trials data like Demographic data, Adverse Events data, Laboratory data and Vital signs.
• Experience in analyzing Case Report Forms (CRF) data, Clinical Trials, Clinical Data Capture (CDC), Clinical Data Management (CDM), Validations and Documentation.
• Create, manage, design, development, and maintain the programming specifications for the analysis datasets.
• Familiar with FDA regulations, GMP, ICH, GCP and GLP, Knowledge of CDISC, model and SDTM mapping and ADAM experience.
• Experience working in health insurance sector with processed Claims, Medicaid and Medicare data for Accountable Care Organizations.
• Work with development, testing team, subject matter experts and define the scope of project and objectives. Knowledge to develop and designs test cases for QA testing. Identifies the needs and make documentation for business requirements.
• Defines work flows and business flows using Visio Diagrams. Develop project scope documents.
• Knowledge of healthcare CMS/claims data, ICD9 to ICD 10 transmission for diagnosis and procedure codes.
• Knowledge and understanding of the basic concepts of healthcare business terms like Member Identification, Concept of Member Aggregation, COB, Accountable Care Organization (ACO), Care-Co-ordination, Continuous Enrollment/Member Eligibility Assessment, Coinsurance/Dual coverage.
• Expertise in Creating mapping documents for ETL data loading Source to target specifications.

TECHNICAL SKILLS

SAS: SAS®8, SAS®9, SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/ETL, Tabulate, Report, Print, Contents, Means, Freq., Univariate, Summary, SQL, Sort, Import, Export, Copy, GPlot, Gchart, Format, Sort, Transpose, ANOVA, GLM, Reg, and Compare.

Database: Oracle and MS Access

OS: windows (98, XP, Vista, Windows 7), UNIX.

MS office: Word, Excel, Power Point, Visio.

Languages: SAS, SQL, PLSQL

PROFESSIONAL EXPERIENCE

Confidential

SAS Programmer

Responsibilities:

• Extensive SAS - based analysis and the ability to read, understand and document the complex SAS programs. Writing queries in SAS and SQL to determine the functioning of the programs.
• Work as the BA with the data ingest team for Confidential and be able to explain SAS based requirements to the business and the product team.
• Used SAS/ACESS Pass-Through Facility and SAS/ACESS LIBNAME Engine to import data from mainframe relational databases.
• Worked on SAS codes to ingest .xml files (raw data) and convert it into standard layouts to be stored in DB.
• Meets with users to gather requirements and performs moderately complex data analysis and design, project planning and control while ensuring that parties who need to know are informed on the status and progress.
• Analyze the requirements and adheres to application development methodology and provides support to the project team through direct assistance, help and training. Prepares the technical / high level /functional design document for the application from which programs will be written for further refinement of business applications.
• Works on the coding and development of SAS Programs, SAS Macros, PL/SQL, etc., Involves in testing the application with Test Scripts, and document issues for future reference. Prepare guidelines for production support after rollout.
• Define the scope of project and objectives and create project scope documents. Identifies the needs and make documentation for business requirements.

Environment: SAS/BASE, SAS/MACRO,SAS/SQL, Oracle, SQL, PL/SQL, Windows, UNIX, ETL/INFORMATICA.

Confidential, King Of Prussia, PA

SAS Programmer

Responsibilities:

• Creating analysis datasets and generating safety and efficacy Tables, Listings and Graphs according to Statistical Analysis Plan (SAP).
• Create SDTM and ADAM datasets according to CDISC STDM IG, CDISC ADAM IG.
• Creating and validating pooled datasets, generating TLG’s for ISS and ISE. Validated SDTM datasets by PROC CDISC, OPEN CDISC Validator and other validation tools.
• Collaborate with senior statistician and respond to regulatory queries.
• Performed independent validation of derived datasets summary tables and graphs.
• Built macros to produce customized tables listings and graphs.
• Generate RTF, PDF, and HTML reports through SAS Output System (ODS) facility.
• Documented and maintained SAS programs/macros, including independent developed Macros and utilizing existing Macros.
• Created analysis datasets for multiple studies for ISS/ISE analysis.

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT.

Confidential, Philadelphia, PA

SAS Research Analyst (SAS)-Part-time

Responsibilities:

• Performed literature review and developed a survey questionnaire (60 questions) targeting the needs and the current health status of the residents.
• Evaluated the reliability and validity of the survey questionnaire.
• Built the final survey on online Qualtrics Data Management system, Sample size derivation and Recruitment of Subjects.
• Documented and maintained SAS programs/macros, including independent developed Macros and utilizing existing Macros.
• Designed and developed SAS programs for statistical analysis, including analysis of variance (ANOVA) and covariate analysis (ANCOVA)
• Performed independent validation of derived datasets summary tables and graphs.

Confidential, Philadelphia, PA

SAS Research Intern

Responsibilities:

• Performed Data Collection and Data entry and worked with Statisticians for various SOP procedures.
• Documented and maintained SAS programs/macros, including independent developed Macros and utilizing existing Macros
• Developed an oral health education curriculum for the dental patients based upon the needs assessment and data analysis.
• The developed curriculum focused on the preventive measures to improve oral hygiene and awareness
• Used SQL to generate list and tables.

Confidential

SAS Analyst - Clinical Trials

Responsibilities:

• Worked with different clinical trials data like Demographics, Adverse Event (AE),Serious Adverse Event (SAE), Laboratory and Physical Examination.
• Generated Tables, Listings and Graphs using various procedures like PROCFREQ, Proc Report, Proc Tabulate PROC UNIVARIATE, Data null, ProcPlot, and ProcGplot
• Performed Data Validation and Data Cleaning on Clinical data using procedures like ProcFreq, Proc Means, and ProcUnivariate.
• Extensively used BASE SASand data NULL steps to create required reports.
• Integrated with Clinical, Regulatory and Data Management colleagues to coordinate collection and reporting of clinical studies.
• Developed permanent SAS formats, templates and libraries.
• Prepared list of efficacy data for statistical analysis.

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT, SAS/AF, ORACLE 8