Summary

• Proficient with SAS, R, SPSS, and advanced Excel functions for statistical analysis.
• Extensive Experience in SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/ENTERPRISE GUIDE, SAS/INSIGHT and SAS/SQL.
• Thorough knowledge and experience in SAS Programming, Merging SAS Data Sets, Developing SAS procedures, Macros, Preparing Data, PROCs, Producing Reports, SAS Formats, SAS Functions, SAS Informats, Storing and Managing Data in SAS Files.
• Experience in developing SAS procedures, macros, and applications for data cleaning, programming, reporting, and documentation.
• Proficient with relational database concepts such as SQL, MS Access and reporting using SAS.
• Experience in using SAS to import/export data to external file formats like flat, Excel, XML files.
• Strong abilities in structured programming logic and object oriented programming concepts.
• Outstanding organizational skills including ability to multi-task prioritize and manage complex issues.
• Excellent skills in diagnosing and avoiding errors, understanding and enhancing output to furnish reports.
• Practical experience of applying complex mathematical models statistical techniques to describe and solve various practical problems.
• Excellent knowledge and experience of using database querying tools SQL Developer and Toad
• Working experience in both PC SAS and UNIX environments.
• Extensively used procedures like PROC SQL, PROC FREQ, PROC MEAN, PROC SORT, PROC COMPARE, and PROC PRINT for the data validation.

Technical Skills:

• Technical Tools: SAS Base SAS, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ODS, SAS/ACCESS, SAS/GRAPH , SAS/ENTERPRISE GUIDE, R, SPSS.
• Operating Systems: UNIX, Windows 9x/XP/NT/Vista, MS DOS
• Databases: Oracle 9i/8i, SQL Server 2000, MS-Access, DB2, Teradata
• Software Packages: MS Office, Toad for Oracle, SQL, Adobe Acrobat, Adobe Photoshop, CDARS
• Programming Languages: PL/SQL, C

Professional experience:

Confidential

Sr. SAS Programmer.

I am currently working to develop and support a SAS based communication engine, an application with a Java web interface called Hercules. The Hercules Communication System is a controlled process for the creation, distribution and retrieval of clinical communication content. Faxes, letters and emails communications sent to or on behalf of plan participants patients and prescribers doctors are logged in the Communication History database.

Responsibilities:

• Maintain, Develop and Support the routine activities to maintain Hercules communication engine.
• Fixing programs and change existing code to ensure smooth run of the programs that are scheduled -
• Maintained programs in SAS using SAS tools for Windows and Unix in a user support environment.
• Written SAS programs using the data step and also with various SAS Procedures in Base SAS and
• SAS/Stat, including thorough knowledge of SAS Macro Language.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools
• SAS/Base, SAS/Macros, SAS/SQL. Extensively used proc sql for extracting, transforming and loading data into db2 and oracle tables.
• Running edit checks and performing data validations, investigating and troubleshooting program and data errors using SAS and SQL in Toad.
• Program documentation on all programs, files and variables for accurate historical record and for future reference.
• Produced quality customized reports by using PROC TEMPLATE and REPORT and also provided descriptive statistics using PROC Means, Frequency, Univariate.
• Formatted pdf reports, using SAS - output delivery system ODS.
• Participated in deployment and release management processes.
• Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Attended project team meetings, worked with Data Managers, and other teams as appropriate.
• Extensively used SAS/ Macro facility to provide reusable programs that can be conveniently used time to time.

Environment: SAS/Base, SAS/Macro, SAS/SQL, SAS/Access, SAS/Graph, SAS/ODS, Teradata, Oracle SQL Developer, SAS/EG, MS Excel, Word, PowerPoint, Windows XP

Confidential

Role: SAS Programmer Analyst

Responsibilities:

• Developed SAS program with SAS/Macro, SAS/Base , SAS/ODS, SAS/GRAPH and SAS/SQL to use existing ALB degree-day model for predicting emergence time, emergence proportion and population abundance of Asian Longhorn Beetle.
• Use SAS/SQL pass-through facility and SAS/Access Libname Statement to connect to Teradata and Oracle database and extract data for data analysis.
• Creation of study data specifications/DDTs Data Definition Tables for the development of Analysis Data Sets referring the ADaM IG V-1.2 and the SAP/TFL drafts approved by the Study Statistician.
• Developed SAS program with SAS/Macro, SAS/Base, SAS/ODS, SAS/GRAPH and SAS/SQL to use CLB degree-day model, and weekly implement the SAS program to predict emergence time, emergence proportion and population abundance of Citrus Longhorn Beetle for 4 locations of 3 countries including Italy, Netherlands and China . Involved in functional analysis and gathering of the data as per the project requisite.
• Used SAS procedures such as Report, Tabulate, Freq, Means, Summary and Transpose for producing customized reports.
• Interacted with Cross functional Teams and helped them in providing programming support and also raised the issues related to the Study data.
• Extracting data from SQL Server into SAS data files using SAS SQL
• Developing application for cleaning and scrubbing the data. Generated highly customized reports using PROC FORMAT, PROC REPORT, PROC TABULATE and ODS HTML
• Involved in development and enhancement of SAS programs.
• Generated graphs using SAS/GRAPH.

Environment: SAS/SQL, SAS/MACRO, SAS/BASE, SAS/GRAPH, SQL-Server, MS-Excel, MS-Access.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Generated tables, listings and graphs with the help of SAS/BASE, SAS/SQL, SAS/STAT and SAS/GRAPH in Windows environment.
• Developed programs for pooling of SDTM data for ISS Integrated Summary of Safety analysis.
• Generated analysis datasets with derived variables and performed statistical analysis on data as per the requirements in the SAP and Protocol.
• Developed and designed different SAS programs to analyze financial data.
• Developed and validated SAS programs and macro codes to produce analysis datasets and reports including non-standard ad-hoc requests for Phase-I and II studies.
• Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis.
• Involved in the creation of standard macros and applications to improve the efficiency of the department.
• Designed and created analysis database as per the CDISC Analysis Data Model AdaM standards.
• Responsible for the accuracy, completeness, quality, and timeliness of clinical programming deliverables.
• Developed reports as per business requirements and created various reports like summary reports, tabular reports etc.
• Responsible for maintenance and enhancements in reporting systems using SAS/BASE, SAS/MACRO, SAS/STAT, and SAS/GRAPH.
• Testing on large raw data file using FIRSTOBS and OBS option, use of Datalines to enter data internally.
• Use of PROC IMPORT procedure to import excel file into SAS.
• Used data step options like KEEP, DROP, and RENAME as a part of storage efficiencies. Data set options IF, WHERE, MISSOVER, TRUNCOVER etc. were used in reading raw data files.
• Submitted reports for different financial services on daily basis.

Environment: SAS/Base, SAS EG, SAS SQL, SAS Macros, Oracle, UNIX, SAS/ACCESS, Windows XP, MS-Excel

Confidential

SAS Programmer/Analyst

Responsibilities:

• Converted MS-Word documents and EXCEL tables into SAS data sets.
• Created web reports in HTML format using SAS/ODS.
• Using SAS/STAT to perform analysis of variance for balanced or unbalanced designs, multivariate analysis of variance, and repeated measurements analysis of variance.
• Worked with Fraud Analytics to develop new and modify existing process documentation and templates in implementation of fraud risk controls and reporting.
• Provided insightful and analytic based recommendations that consider fraud exposure, customer service, and operational impacts.
• Written SAS reports to Excel, the SAS content server, HTML, and PDF
• Performed Data entry and conversions, data validation and corrections, uploading/ downloading data from/to a PC, statistical Data analysis, created permanent formatted SAS data sets for present/ future analysis.
• Used Dynamic Data Exchange DDE feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Created base macros to run reports. Created standard reports to use across studies and base programs to set up data.
• Developed SAS macros for data cleaning and Reporting and to support routing processing.
• Created and updated permanent SAS formats for future analysis and reports.
• Used SAS for pre-processing data, data analysis, generating reports, statistical analysis, and graphs.

Environment: SAS, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS Macros, SAS/SQL, Oracle , SAS/ACCESS, Windows.