SUMMARY

• Over 6 years of professional experience as a SAS Programmer in the pharmaceutical, clinical research and healthcare industry .
• Extensive experience in SAS products including SAS/BASE, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/ODS, SAS/SQL.
• Professional experience with Importing various external data files into SAS Dataset / SAS Library by Using SAS/ACCESS, SAS/INFILE, SAS/IMPORT, SAS/SQL.
• Excellent experience in developing, designing and debugging SAS Programs and SAS/MACRO to access, extract, modify, merge, and analyze data, and output statistical analysis files, Tables, Listings, Figures.(TLF’s)
• Highly proficient in statistical analysis using PROC FREQ, PROC MEANS.
• Excellent working experience in manipulating datasets: Cleansing, Merging, Sub - setting by using SAS data steps and procedures like PROC SORT, PROC TRANSPOSE, PROC APPEND, and PROC SQL.
• Expertise in producing customized Tables, Listings and Figures (TLF) by using PROC REPORT, PROC TABULATE, PROC SUMMARY.
• Super work knowledge of SAS/ODS to export SAS results into different formats including RTF, HTML and PDF etc.
• Extensively dealt with SAS Macro facility in coding macros for reusable programs.
• Good knowledge in SAS BI suites including Enterprise guide, Information map studio, Web report studio and Information delivery portal for efficient use of SAS applications
• Understanding of reviewing business requirements for standard reportingand Using SAS Business Intelligence (BI) to drive the automation of standardized analytics
• Proficient in developing my own codes as well as modifying existing ones.
• Highly developed teamwork skills, influencing and as well as strong presentation skills.
• Quick learner with good communication skills and an excellent team player.

TECHNICAL SKILLS

SAS Tools: SAS/BASE, SAS/STAT, SAS/MACROS, SAS/ODS, SAS/SQL.

Languages: SAS, HTML, SQL and PL/SQL.

Databases: Oracle, MS ACCESS.

Office Software: MS Office 2003.

Operating Systems: Windows 2000, Windows XP.

PROFESSIONAL EXPERIENCE

Confidential, Bloomfield, CT

SAS Developer

Responsibilities:

• Used SAS for reporting and analysis of Healthcare data like demographics, medical claims data, health insurance data, pharmacy claims data etc.
• Used SAS/Access to extract data into SAS and created the datasets and analyzed data based on the Demographic Information.
• Produced Case Report Tabulation (CRT’s) for submissions to the regulatory bodies.
• Imported/Converted data files from Excel, Word, and Text based data files into SAS data sets for analysis.
• Used various statistical procedures like proc SQL, proc report, proc tabulate, proc format, proc import, proc export, proc print, proc sort, proc compare, proc append, etc.
• Generated Tables, Listings and Graphs for the Study Reports.
• Responsible for Database Management and SAS Programming for Statistical Analysis, documentation and reporting.
• Submitted PDF, RTF, and HTML Listings, Tables and Reports using SAS ODS.
• Developed SAS Macros for data Cleaning and Reporting and to support routing processing.
• Created datasets and generated reports using PROC Tabulate, PROC Report, Data Null, PROC SQL and Macros.
• Generated Last Observation Carried forward data (LOCF) for handling missing data.
• Developed Edit Check Programs to clean invalid data from the database.
• Performed Data Entry, Data Modification, Data Validation and Corrections, uploading data into SAS.
• Manipulated data on SAS datasets using techniques or functions such as Merging, Appending, Concatenating and Sorting.
• Participated ingroup consisting of Bio-Statisticians and Research and Development members to analyze the results obtained from various Statistical Procedures.
• Worked on with large data and able to clearly communicate results of complicated analyses to technical and non-technical audiences.

Environment: SAS 9.2, SAS BASE/MACRO/SQL/ODS/STAT, DATA NULL, Proc SQL, Proc Transpose, Proc Format, Proc Means, Proc Freq, Proc Tabulate, Proc Report.

Confidential, PA

SAS Developer

Responsibilities:

• Performed advance analysis of Pharmacy and Medical Claims data, Membership data, and Support data using BASE SAS, SAS Macros, and SAS SQL.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Developed new and/or modified existing SAS programs to load data from the source and created study specific datasets in UNIX and Windows Operating System.
• Stored and distributed SAS results in different formats (HTML, PDF, RTF ) based on different user groups
• Worked with large data sets (20+ million records) using Pass Thru SQL technique
• Worked on wrapping up a SQL code into SAS using pass through SQL facility for automation of report generation process for a mid-vendor
• Created new datasets from raw data files using Import Techniques and modified existing datasets using SET, MERGE, SORT, UPDATE, and conditional statements
• Worked with complex datasets to extract customized reports using PROC SQL, PROC REPORT, PROC TABULATE for creating a preferred list of customers as per the given requirements from business analysts
• Developed SAS/SQL codes to perform QC of incoming data by comparing the data counts on ODS side and the warehouse side
• Extensively used DATA NULL and SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY and TRANSPOSE for producing ad-hoc and customized reports and external files
• Performed Code Reviews and tested SAS codes written by other programmers
• Documented methodology, data reports, and model results, and communicated with project manager to share knowledge.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ODS, SAS/ACCESS, SAS/CONNECT.

Confidential, OH

Business Analyst II

Responsibilities:

• Developed several SAS programs according to campaign specifications and communicated with users to develop and document specifications.
• Extracted data from various database sources like Teradata, Oracle using Proc SQL passthrough facility and SAS/ACCESS libname statements.
• Worked with complex datasets and generated highly customized reports using PROC SQL, PROC FREQ, and PROC MEANS for creating a preferred list of customers as per the given requirements.
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Performed data cleansing by analyzing and eliminating duplicate and inaccurate data.
• Generated SAS/ MACROS for reusability and to minimize data processing.
• Created reports in the style format (Excel, RTF, PDF, HTML) using ODS statements.
• Worked with SharePoint to assign task and share reports.

Environment: Base SAS, SAS/MACROS, SAS/CONNECT, SAS/SQL, SAS/GRAPH, SharePoint, Teradata, Business Objects, Oracle, and MS-Office

Confidential

SAS Consultant

Responsibilities:

• Prepared SAS datasets from raw data files and modified existing datasets using Set, Merge, Sort, Update, Formats, and Functions.
• Provided SAS programming and Statistical support to clinical studies.
• Created RTF, HTML, PDF listings, tables and reports using SAS ODS.
• Extensively used SAS/Macro facility to provide reusable programs that can be conveniently used time to time.
• Had experience in ETL (Extraction Transformation and Loading) applications.
• Performed statistical data analysis, generated ad-hoc reports, tables, listings and graphs using tools such as SAS/Base, SAS/Macros, SAS/SQL and SAS/STAT.
• Produced quality customized reports by using PROC TABULATE, PROC REPORT, and PROC SUMMARY and also provided descriptive statistics using PROC MEANS, PROC FREQ .
• Created new datasets from raw data files and modified existing datasets using Set, Merge, Sort, Update, and Conditional statements.
• Derived and used analysis data sets for statistical analysis and generated reports for FDA submission.
• Verified accuracy and integrity of clinical data by performing validation checks written in SAS and data cleaning by investigating data related errors and missing values.
• Performed various ad-hoc analyses as per guidelines and requests.
• Assisted fellow programmers in validation and data review listings.

Environment: SAS 9.1.3, Unix, SAS/Base, SAS/Macros, SAS/SQL, SAS/Stat, Oracle and Windows.