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 Contract Research Organizations (CROs), expertly gathering and analyzing data for highly confidential clinicaltrials.
• 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:

• Involved SAS/BASE,SAS EG, Macros to develop dynamicSASprograms to extract, validate data for Statistical analysis.
• 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.