SUMMARY:

• SAS Developer with over 6 years of programming/analysis experience in SAS on Windows and UNIX environment.
• Strong SAS Programming experience in Health care, Retail and Pharmaceutical industries.
• Strong SAS programming background for creating, maintaining existing code, ad hoc reporting and supporting the reporting functions.
• Worked with the marketing department to develop marketing campaigns for customer acquisitions that involved liaising with third party Data Providers, setting up internal IT systems and Campaign data analytics.
• Expertise in using various SAS report generating procedures such as: PROC REPORT, PROC FORMAT, PROC GPLOT, PROC GCHART, PROC COMPARE, PROC EXPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABLATE, PROC TRANSPOSE, PROC COPY, PROC SUMMARY, PROC IMPORT.
• Generated reports using PROC REPORT, DATA _NULL_ and PROC TABULATE for customized report writing.
• Generated daily, weekly and monthly reports using PROC REPORT and SQL.
• Experience in requirement gathering, analysis, planning, designing, coding and unit testing.
• Experience in SAS to extract data from a variety of operational data sources on multiple platforms, and build a data warehouse and data marts that integrate the extracted data.
• Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and MS Access tables.
• Additional experience includes using Procedures, Graph, Macros, Data Step, SQL, and Data Mining, extracting internal/external data including cleaning and validation, use of formats and in formats.
• Experience in producing HTML, RTF, CSV and PDF formatted files using SAS/ODS.
• Experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS Information Map Studio, SAS/Web Report Studio, SAS/ENTERPRISE GUIDE, SAS/ENTERPRISE MINER.
• Involved extensively in Data Extraction, Transformation, Loading.
• Experience in developing complex SAS programs, macros for data updates, data cleansing, and reporting.
• Worked extensively on Oracle, SQL Server, MS Access Database & Creating Korn shell scripts.
• Good understanding in designing and implementing statistical reporting processes for regular data collection and clinical data analysis in Phase I, II and III Clinical Trials.
• Trained in Good Clinical Practice (GCP), Regulatory Compliance, FDA Guidelines, Data interpretation, supporting statistical methodologies and review SAP.
• Dedicated to maintaining a reputation built on quality, service and uncompromising ethics.
• Highly motivated individual with excellent organizational and interpersonal skills.
• Possess strong ability to quickly adapt to new applications and platforms.

TECHNICAL SKILLS:

SAS Skills: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/STAT, SAS/GRAPH
Database: Oracle7x/8x, MS SQL Server, MS-Access, SQL
Operating: Windows (XP/2000), UNIX
Office Tools: MS Office, MS Project, MS-Visio

Confidential, Dec 2010 - Present
SAS Benchmark Process Engineer Greenwood Village, CO

Description: Thomson Medstat designs information solutions to strengthen healthcare policy and help decision makers achieve better results through uncovering, understanding and managing healthcare cost and quality issues in their organizations. Processed large amounts of healthcare data through a complex grouping and data manipulation process to produce benchmarks used in decision support system.

Responsibilities:

• Created, modified/Updates SAS code to incorporate changes in new releases of the product.
• Produced ad hoc reports in SAS using .txt files upon request for in-depth analysis.
• Data manipulation by merging, appending and sorting datasets.
• Extensive use of PROC SQL to create subsets of data for further analysis.
• Extensive use of DATA STEP, PROC MEANS, PROC SQL, MACROS, PROC FREQ, PROC TABULATE, DATA _NULL_, PROC MEANS, PROC SUMMARY, RETAIN.
• Used SAS - output delivery system ODS to format reports in HTML, PDF, CSV and RTF reports.
• Optimized SAS code to reduce run time and make the process more efficient.
• Generated output files in various formats like text, MS Excel.
• Analyzed demographic data to identify outliers.
• Participated in code reviews.
• Developed SAS code using Macros to run recurring jobs and optimized code.
• Troubleshoot process failures and implemented process improvements.
• Designed and executed data quality and system tests.

Environment: SAS/BASE 9.1.3, SAS/MACRO, SAS/Enterprise Guide, SAS/ODS, UNIX, SQL Navigator 4, MS Office products.

Confidential, Sep 2008 – DEC2010
SAS Programmer/Analyst Park Ridge, New Jersey

Description: Hertz is the world’s largest airport general use car rental brand and is the number one airport car rental brand in the U.S. and 81 airports in Europe. As a SAS analyst, I prepared ad-hoc reports, assisted in the development of detailed strategic fleet acquisition, rotation, and remarketing recommendations based on analytics, including alternative scenarios, and supported the development and improvement of proprietary models.

Responsibilities:

• Analyzed various database containing sales, titles, account, region etc data of the releases of various titles.
• Used SAS Macros and procedures like Proc SQL, Proc Transpose, Proc Univariate, Proc Means, Proc Freq.
• Developed SAS macros for Data cleaning, Data mining and Reporting and to support routing processing.
• Formatted HTML, PDF, CSV and RTF reports, using SAS - output delivery system ODS.
• Extraction of data from Data Ware housing tables and Data marts.
• Modifying data using SAS/BASE and Macros.
• Gathered the requirement business team and analyzed the data.
• Participated in plan, design, and conducted simultaneous complex market research projects in support of the annual global strategic plan (GSP) and global commercial plan (GCP).
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools–SAS/BASE, SAS/MACROS and SAS/GRAPH, SAS/SQL, SAS/Connect, SAS/ACCESS.
• Creating Customized reports in Enterprise Guide for the users. Trained end users on simple ad hoc report creation.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Prepare ad hoc reports, as needed.
• Extracting data from the database using SAS SQL procedures and create SAS data sets.
• Coding SAS programs with the use of BASE SAS and SAS/MACROS for ad hoc jobs.

Environment: SAS/BASE 9.1.3, SAS/Enterprise Guide V3, SAS/MACRO, SAS/ACCESS, SAS/Enterprise Miner, SAS/Web Report Studio, Oracle9i, Teradata, MS Office products.

Description: Biogen is a Biotechnology company developing drugs to improve the safety of the world’s health in Oncology and conducting clinical trials. As a SAS Programmer, my role was in analysis of clinical trials data and generating required reports, listings, summaries and graphs for submission to FDA and other regulatory authorities.

Responsibilities:

• Successfully designed and implemented statistical reporting processes for regular data collection and clinical data analysis. Analyzed Phase I, II and III Clinical Trials.
• Reading the raw clinical data (weekly and monthly), validating, manipulating, sorting, and merging the data. Generate summary tables, patient listings and develop different types of statistical reports by using different types of procedures.
• Developed programs using SAS/Base & SAS/Macros to extract data from oracle tables.
• Generated Tables, Graphs and Listings for inclusion in Clinical study reports and regulatory submission.
• Reviewed data from clinical trials and developed a strategy for how to present results to FDA.
• Trained in Good Clinical Practice (GCP), Regulatory Compliance, FDA Guidelines, Data interpretation, supporting statistical methodologies and review SAP.
• Proficient in understanding of Study Protocols, SAP (Statistical analysis plan), and CRF.
• Excellent ability in problem solving, data analysis, complex reports generation.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• 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.
• 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.
• 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.
• Extracting data from the database using SAS/Access, SAS /SQL procedures and create SAS data sets.
• Creating SAS dataset from tables in Database.

Environment: SAS/BASE 9.1.2, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Base, UNIX.

EDUCATION:

B.S. in Computer Science