SUMMARY

• SAS Analyst with 10+ years of professional experience in working with SAS and SAS tools with strong emphasis on analysis of data for Health Care department.
• Experience in analysis of data for statistical analysis and reporting.
• Expert in using PROC SQL, PROC TABULATE, PROC GCHART, PROC REPORT, PROC FORMAT, DATA MERGE, PROC SORT to generate ad - hoc and customized reports.
• Strong experience in using SAS/ACCESS (LIBNAME Engine, SQL Pass-Through Facility) to extract large volume data from databases.
• Excellent skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on UNIX, Windows.
• Extremely energetic, detail oriented, organized team player with strong analytic abilities, communication skills, interpersonal skills, and problem-solving skills.
• Experience working with ContractResearchOrganizations (CROs), expertly gathering and analyzingdatafor highly confidentialclinicaltrials.
• Created Ad hoc reports by using SAS ODS in different format, like PDF, RTF & HTML
• Strong knowledge of SAS visual analytics by using SAS, SQL& Advanced Excel by putting reports in Dashboard.
• Works collaboratively with Programming (Clinical and Statistical), Clinical Operations, Biostatistics and other internal teams.
• Track progress of clinical studies, ensuring projects meets timelines and quality expectations.
• Experience working with SAS coding used in data extraction.

TECHNICAL SKILLS

SAS Tools: SAS/Base, SAS/Macro, SAS/Stat, SAS/ODS, SAS/ACCESS, SAS /Graph, SAS Enterprise Guide, SAS BI, SAS DI Studio

Languages: SAS, SQL

Operation System: Windows

Other Technologies: Microsoft Office (Word, Excel, PowerPoint)

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, Texas

SAS Analyst

Responsibilities:

• InvolvedSAS/BASE,SASEG, Macros to develop dynamicSASprograms to extract, validate data for Statistical analysis.
• DevelopedSASprograms usingSASEnterprise Guide for tabulation counts, correlations and check for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.
• DevelopedSASBase procedures FREQ, SQL, SORT, MERGE, UPDATE, PRINT, SUMMARY, TABULATE, and MEANS to analyze the data.
• Designed and coded ETL processes with varied source systems like SQL Server and flat files
• SASdata sets are validated usingSASprocedures like Proc Means, Proc Frequency
• Optimized, automated and production daily / weekly / monthly scripts for increased efficiency and intelligence.
• Performed statistical data analysis, generated reports and graphs usingSAS/Base,SAS/Macros,SAS/SQL,SAS/Access andSAS/Graph.
• Built and presented demos inSASVisual Analytics using client data.
• Generated reports using Microsoft Excel Pivot tables.
• Created ad hoc reports, match merge and created graphs by usingSAS/GRAPH. Generated output usingSAS/ODS in CSV, XLS, DOC, PDF and HTML formats.
• Implemented Set, Merge andSAS/SQL to perform suppressions and exclusions on the data.
• Extensive use of PROC SQL,SASMacros for process automation
• Updated business specifications, created system flow charts and prepared test plans.

Environment: SAS/BASE,SAS/MACRO,SAS/ACCESS,SAS/ETL,SAS/SQL,SAS/STAT,SAS/GRAPH,SAS/CONNECT,SAS/SQL,SAS/Enterprise Guide,SASBI.

Confidential, Houston Texas

SAS Analyst

Responsibilities:

• Applied CDISC standards on clinical trial data for converting raw datasets to SDTM datasets with reference of mapping documents prepared by following SDTMIG.
• Created CRT (Case Report Tabulations) datasets using CDISC standards for submissions to the FDA.
• Created macro program to create Macro variables to pull data from SQL server for monthly daily data extracting.
• Proc summary, proc means, proc tabulate are used for report generation.
• Developed the reports to support decision making effort with SAS ODS (Output Delivery System).
• SAS/graph is used to generated the monthly is the history graph.
• Extracted data from different sources like text files usingSAS/Access,SASSQL procedures and createdSASdatasets.
• DevelopedSASMacro programs to create ad-hoc reports.
• Worked on generating ad hoc reports, tables and graphs for presentations and data modelling usingSASWeb Report Studio.
• Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting.
• A sound working relationship and effective communication within (worked with) Bio-Statistics and Statistical Reporting and Clinical Research and Database personnel.
• Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.

Environment: SAS9.3,SAS/Access,SAS/Base,SAS/Macro,SAS/Stat,SAS/Graph,SAS/SQL, SASBI,SASweb reporting studio,SASDI, MS Office.

Confidential, Austin Texas

SAS Analyst

Responsibilities:

• Performed analysis on the data arrived from client side and generated customized reports according to the requirements.
• ExtensivelyusedSASforgeneratedcodewhichcangiveoutputtothedesiredformats.
• Sorting, printing and summarizing the SAS data is modifying and combing SAS datasets (sort, set, merge).
• Performed data validation by creating SAS code to clean up the invalid data entries.
• Creating waterfall reports and analyzing data and creating ad-hoc's on deliverables.
• Advanced analytics and reports created based on the criteria provided.
• Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports
• Conducted Regression testing after the bugs have been fixed by the development team
• Responsible for source control, versioning, and configuration management of test scripts, test results, defects. Developed Test Strategy, Test plan, Test cases, and Test scripts. Created test plan and executed test cases using Rational Test Manger
• Performed Regression Testing on weekly builds. Monitored the workflow transformations in Informatics work flow monitor.
• Contributed to integration of data across marketing research and clinical trials data.