SUMMARY:

• Result - driven IT Professional with 8+ years of experience in data analysis including data extraction, manipulation and validation techniques, writing macros and reporting on various projects.
• Expert in data preparation for various statistical modeling which includes data cleaning, descriptive analysis, missing data analysis and data validations.
• Proficient in SAS/BASE, SAS/SQL, SAS/Macro, SAS/Access, SAS/ODS, SAS/STAT and SAS/GRAPH
• Expert in developing SAS procedures, macros, merges, and data steps for data cleaning, formatting and reporting.
• Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and Access tables.
• Experience in migration of data and current SAS programs to new versions.
• Experience in using various MS office tools for analyzing, arranging and presenting data.
• Experience in pharmaceutical and medical data statistics.
• Experience in coding using SQL, Procedures/Functions, SAS macros
• Expertise in Problem solving and Created Macros to improve the efficiency of report generation and automation of programs and data creation.
• Excellent background in general linear models, categorical data analysis, survival analysis, multivariate analysis, design of experiments, randomized trial designs and survey design and analysis, as well as creating SAS datasets, debugging programs, and documentation.
• Strong knowledge on drop, keeps, retain, and date manipulations, formats, and informats.
• Hands on experience in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS tables using LIBNAME and SQL PASSTHRU facility.
• Generated reports using PROC REPORT and PROC TABULATE for customized report writing.
• Excellent command in writing routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel and SAS on various environments.
• Proven skills in Data Cleansing, Data Archival, Data Migration, reporting and coding utilizing SAS on Windows and UNIX.
• Experience in creating SAS programs for EDIT CHECKS and performed data validation on raw data sets and created data set for analysis.
• Experience with developing predictive models for risk assessment arena using large data sets for high transactional volume environment

TECHNICAL SKILLS:

SAS Skills: SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/GRAPH, SAS/STAT, SAS/SQL, SAS/ODS

SAS Procedures: Print, Transpose, Contents, Means, Chart, Plot, Printto Tabulate, Univariate, Summary, Sort, Sql, Proc Format, Freq, Forms, Upload, Download, Datasets And Format, Import, Export, Report, Gchart, Glm, Mixed, Gslide, Copy, Anova, Reg

Languages: SAS 9.4/9.3, SQL

Office Tools: MS office (Word, Excel and PowerPoint)OS: Windows NT/XP Prof/2003 UNIX

WORK EXPERIENCE:

SAS Programmer

Confidential, Austin, TX

• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/Base and SAS/ Macro facility.
• Prepared new Datasets from raw data files using Import techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Used SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Automating several SAS Reports by using Base SAS, which will drop the reports in designated location at the scheduled date and time without any human effort?
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets by using Set and Merge for generating Reports and Graphs.
• Used SAS and SQL to perform ETL from Oracle database and created SAS datasets, SAS Macros, Proc/data steps and SAS formats as required.
• 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.
• Extracted data from the database using SAS/Access procedures and create SAS data sets.
• Developed SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets.
• Extensively used company standard macros, generating graphs, listings, PDF and RTF files using various Base SAS Procedures.
• Involved in establishing connections to different data sources (SQL Server and web site data) and pulling relevant data from these source systems for data modelling.
• Wrote SQL Loader code in SAS using SAS as an interface to load the tables into the Oracle database.
• Developed Financial Monthly and Quarterly summary reports, graphs using SAS procedures like Proc Freq, Proc Graph, Proc Univariate, Proc Summary, and Proc Report etc.
• Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROCFREQ and PROC CONTENTS to generate different reports on different data sets.
• Extensively used SAS/ Macro facility to provide reusable programs that can be conveniently used to update reports.
• Participate in statistical program validation and quality control activities.
• Coordinated the production of monthly, quarterly, and annual performance reports for senior management.
• Created documentation, desk levels and process flow documents for all the processes.

Environment: s: SAS 9.4/9.3, SAS/BASE, SAS/REPORTS, SQL, SAS/MACROS, EXCEL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/CONNECT, UNIX, Windows

SAS Programmer

Confidential, San Diego, CA

• Collaborated with clinical researchers in the design of clinical trial selection of clinical endpoints, sample size requirements, protocol development, and Research and Case Report Form.
• Designed & developed SAS application for monitoring, reporting, analysis of Clinical Trial data.
• Produced data listings, summary tables and graphics for interim and final analyses and publications.
• Reviewing CRF's, Protocol, SAP of the clinical trial and company SOP.
• Created SDTM and ADAM datasets from legacy/ raw datasets.
• Produced HTML, PDF and RTF reports using SAS ODS Generated graphs using ProcGChart and GPlot.
• Created standard TLG's for ISS, ISE, CSR and Exploratory analysis for regulatory submission.
• Developed Analysis datasets for Safety and Efficacy data. (Demographics, LAB, Adverse
• Events, Medical History, Physical Examination, ECG, Concomitant Medications, Overall Pain, Vital Signs, and Concomitant Medication) as per Statistical Analysis Plan (SAP).
• Assisted statisticians, medical writers, Data and system analysts.
• Developed SAS macros to generate graphs and reports based on combined datasets, performed statistical analyses with output delivery procedures.
• Cross-validated SAS programs authored by other SAS programmers as a part of QA (quality assurance).

SAS Programmer

Confidential, Grand Junction, CO

• Designated to assist the DMSP (Division of Major Sector Productivity) team in the development of a consistent approach to data management, data manipulation, and calculation of measures using SAS programming language to produce major sector productivity statistics for publication using repeatable transparent business processes.
• Working mainly on conversion of TSP (Time Series Processor) programs into SAS programs.
• Responsible for guiding team members in the efficient use of data manipulation, Lookup tables, base SAS, Macros, IML and other necessary information related to the specific practices and methodologies for the development of SAS-based programming.
• SAS Enterprise Guide was used to convert existing SAS programs to SAS stored processes using dynamic prompts and produced packaging and streaming outputs as required.
• Proposing solutions and provide SAS programming code to import data into SAS, primarily from Excel, CSV, and text files to create a data sets.
• Provide consistent technical coordination and approach among contracted personnel and to communicate such to DMSP team members and management.
• Develop SAS code according to DMSP requirements as outlined in the project plan, to support the DMSP software conversion (both independently and as a team) following established guidelines and preparing easy to read documentation.
• Proposing solutions and provide SAS programming to manipulate, add, subtract, multiply, divide, average, aggregate, roll up, interpolate, extrapolate and carry out other calculations of data that are organized in time series formats covering many years and across different time periods.
• Reviewing and discussing requirements and project schedule with DMSP staff in order to provide technical expertise and write code to address the following (non-exhaustive) list of requirements.
• Creating individual and universal macros for similar procedures.
• Design, development and unit-testing of SAS program code, functions and scripts to efficiently extract merge and manipulate data
• Involved in developing, testing, and writing programs and reports in SAS according to client specifications as required in an UNIX environment.
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Generated highly customized reports using SAS macro facility, Proc Report, Proc Tabulate, and PROC SQL.
• Performed data cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, PROC RANK, and macros in SAS.
• Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.

Environment: SAS 9.4, SAS Enterprise Guide, SAS/SQL, SAS/MACROS, SAS/BASE, SAS/STAT, SAS Visual Analytics, SAS Grid, SAS Data Integration Studio (ETL tool) 4.4, VBA, UNIX, Oracle, SQL Server, DB2, SAS Enterprise Guide, WinSCP, MS Office.

SAS Programmer

Confidential, McLean, VA

• Validate and document SAS programs, tables, listings and graphs Coordinated with the lead statistician and the lead programmer.
• Developed reports using PROC REPORT.
• Created tables & listings based on List of Tables (LOT), Mock tables provided by the statistician's team.
• Conduct data quality and consistency check and write edit check using SAS programs
• Derive analysis safety and efficacy analysis data sets from raw SAS datasets

Environment: SAS, SAS MACROS, SAS/SQL, SAS/ACCESS, SAS/CONNECT, SAS/STAT, SAS/GRAPH, MS Excel, MS Access, Oracle, and Windows.