SUMMARY

• Around Six years of experience in Pharmaceutical, Financial and Technology industries working on SAS, SQL.
• Proficiency in SAS, SAS/BASE, SAS/GRAPH, SAS/SQL, SAS/STAT, SAS/MACRO, SAS/ACCESS, SAS/INSIGHT, SAS/ASSIST, SAS/ODS, SAS/AF in Windows and UNIX environments.
• Thorough knowledge in SAS programming, Macro Facility, SAS Procedures, SAS formats, SAS functions, SAS statements, SAS Informats, merging SAS Data set, Preparing data, Producing reports, storing and managing data in SAS.
• Experience in developing Macros, using SAS procedures, handling various file formats including delimited files, databases and spreadsheets.
• Excellent understanding of data management principles, such as joining data sets, indexing, data aggregation, record selection and sub-setting.
• Created RTF, PDF and HTML listings, tables and reports using SAS ODS.
• Very good experience in troubleshooting and debugging SAS programs.
• Very good working experience with reporting, validation and derivation procedures using SAS.
• Involved in documentation including documenting technical requirements, creating Process Flow diagrams, Job dependency diagrams etc.
• Has extensive experience with SAS Programming, Clinical Trials Phases I IV , mainly Reporting Tools, Object Oriented Programming and SQL.
• Excellent interpersonal, organizational, leadership and oral/written communication skills contributing to project success in multi-tasking, fast paced environment.

TECHNICAL SKILLS

Work Summary

Confidential

SAS Developer

Responsibilities

• Perform data cleansing of the raw data through SAS existing macros and develop new ones to validate and detect any invalid data. Coordinate with WCDMO for fixing the data related problems.
• Create the derived datasets, listings, summary datasets and graphs using demographic, labs, vital signs, AE and other datasets.
• Adverse Experiences were listed and summarized by frequency of occurrence. Frequency, duration and severity of AE's were examined using Proc Freq, Proc Means, Proc Univariate SAS Procedures.
• The primary and secondary efficacy end points were analyzed using ANOVA model. Percentage change from the baseline at week 6 was used in the inferential analyses.
• Provided Application support for various clini-research protocols. Needed to analyze the problem for data struck in the load tables, provide fixes and deploy them.
• Primary support contact for MAESTRO Merck Adverse Experience Surveillance, Tracking and Reporting Online . MAESTRO generates the narrative for an AE/SAE, which needed to be submitted to FDA in two days. Needed to analyze the problem and deploy the fix in 3-hour time frame.
• Involved in ISOS leveling for the entire drug program. Created EzCheck utility program in PL/SQL to perform a diff between the views and core tables in different stages and instances Subsidiaries and Consolidated instances .

Environment: SAS/BASE, SAS/MACROS, SAS/ACCESS, Clinical Trial System.

Confidential

Responsibilities

• Designing and creating SAS datasets from various sources like Excel datasheets, flat files and Oracle, creating reports and files from existing SAS datasets.
• Developing and designing SAS Programs/Macros to access and analyze financial data. Statistical analysis files, tables, listings, and graphs. ETL/Extract data from warehouse /databases and created SAS statistical analysis reports.
• Developed various utility macros used by the entire project in SAS to retrieve Reporting Period Dates, Connect to the databases, Clean Up Work areas, to move data across the databases with different table structures etc
• Involved in creating various Adhoc reports using Proc Report, Proc Tabulate and mostly using Data NULL with put statements to create the customized reports using Macro variables. Also created graphs using proc template and proc Gchart.
• Created lots of wrapper scripts for executing the SAS code using shell scripts. Also created shell scripts to FTP/scp the output files to the appropriate servers and locations. Used UNIX mailx utility to send the output files to the users.
• Documented the entire process using Visio, MS Word and MS Excel. Created Process Flow Diagrams, Job dependency diagrams and documented the entire processes.

Environment: BASE SAS, SAS/ACCESS, SAS Connect, DB2 UDB 7.1, ClearCase, ClearQuest, IBM AIX, SQL Navigator

Confidential

Responsibilities

• Create electronic data sets i.e., SAS transport files for electronic submission.
• Created listings, tables, summary datasets and graphs from the cleaned data.
• Designed, built and tested a series of SAS programs for validating and reporting of Clinical data.
• Several reports were generated and also converted the data into dbf format and sent to the client. Also the reports were sent on to web, creating Universes using web intelligence.
• From the obtained data several graphs were generated using Excel for presentation. Also used PowerPoint for presentation.
• Drawing flowcharts indicating the input data sets, sorting and merging techniques to get the required output using SAS/Base includes SQL, Macros and then reporting. The validated data is analyzed using different SAS/STAT procedures to get the therapeutic value of different pharmaceutical products.
• Extracted raw data from the warehouse and created SAS data sets that are required for the project analysis.
• The Data received in tapes and CDs from data vendors, are loaded on to the data warehouse.
• Created survival graphs in Excel by transporting SAS data sets into Excel spreadsheets.

Environment: SAS/BASE, SAS/ACCESS, Oracle Clinical, SAS/MACRO, SAS/SQL, SAS/GRAPH and UNIX

Confidential

Responsibilities

• Generated required Charts, Graphs and reports using Proc REPORT, Proc GPLOT, and SAS/Graph for graphical analysis.
• Extensively used SAS Procedures such as Proc TABULATE, Proc TRANSREG, Base/ SAS, and SAS/Graph.
• Updating and maintaining systems for the user and enhancing the user interface whenever necessary.
• Managing and carrying out the analysis using Teradata and mainly Reporting.
• Maintaining accurate records of expenditures, directing preparation of expenditure projections, and submitting timely requests for additional funding marketing whenever required.
• Reporting using data null and put statements.
• Occasionally performing Case-by-Case analysis.
• Exporting and importing the data between different platforms such as SAS, MS-Excel.
• Generating the graphs using SAS/Graph to see the trends and develop forecasts.
• Provide customized output using SAS/ODS in HTML and RTF format.
• Helping clients with PowerPoint Presentations whenever required.

Environment: SAS/BASE, SAS/GRAPH, SAS/ODS, Relevant SAS Procedures, MS-Excel, Oracle 8i, Teradata, DB2, Extensive SQL, Windows 2000.