SUMMARY

• Certified BASE SAS Programmer with around 7+ years of experience as SAS Programmer & Analyst in financial and Pharmaceutical industry.
• Experience in SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/ACCESS, SAS/ODS and SAS/SQL.
• Experience in Phase II and III clinical data analysis: analyzing clinical data, creating tables, listing and generating reports and graphs.
• Expertise in various SAS procedures such as Proc Report, Proc Means, Proc Summary, Proc Univariate, Proc Contents, Proc Sort, proc Freq, Proc GChart, Proc Import, Proc Export, etc.
• Proficient in performing different operations on SAS data sets of any size like Sorting, Concatenating, and Merging.
• Experience in using SAS to read, write, IMPORT and EXPORT to another data file formats, including delimited files, Microsoft Excel and access tables.
• Solid knowledge in writing complicated SQL Queries, Stored Procedures and DTS Packages. Scheduled and logged jobs in SQL Server 2000.
• Experience in file management and scripting in UNIX.
• A quick learner with an eye for detail and excellent analytical and quantitative skills, Self - motivated, and organized. Excellent written and communication skills, self-starter and good team player.
• Proactive attitude and a willingness to “go the extra mile” to get the job done well.

TECHNICAL SKILLS

SAS Tools: SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACROS, SAS/ODS, SAS/ACCESS, SAS/BI (Information Data Map Studio, Web Report Studio, OLAP Studio)

Languages: SQL, T-SQL, PL/SQL, VB.NET, C++, JAVA, HTML, XML

Databases: Oracle, Sybase, MS ACCESS, SQL Server

Scripting: Shell Scripting (K/B shells), Batch Scripting, Java Script

Office Software: MS Office 2000/2003, Open Office 3

Operating Systems: UNIX, Windows 2000/XP/2003

PROFESSIONAL EXPERIENCE

Confidential, OH

Business Analyst II

Responsibilities

• Developed several SAS programs according to campaign specifications and communicated with users to develop and document specifications.
• Extracted data from various database sources like Teradata, Oracle using Proc SQL passthrough facility and SAS/ACCESS libname statements.
• Worked with complex datasets and generated highly customized reports using PROC SQL, PROC FREQ, and PROC MEANS for creating a preferred list of customers as per the given requirements.
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Performed data cleansing by analyzing and eliminating duplicate and inaccurate data.
• Generated SAS/ MACROS for reusability and to minimize data processing.
• Created reports in the style format (Excel, RTF, PDF, HTML) using ODS statements.
• Worked with SharePoint to assign task and share reports.

Environment Base SAS, SAS/MACROS, SAS/CONNECT, SAS/SQL, SAS/GRAPH, SharePoint, Teradata, Business Objects, Oracle, and MS-Office

Confidential

SAS Programmer

Responsibilities

• Data cleansing and mapping to the Risk Analytics requirements using IDN and ODS, converting them to SAS datasets.
• As part of SAS BI establishment in the organization, working on converting escheatment process and associated data migration/integrations using SAS/BI Studio.
• Modified existing SAS programs and created new code utilizing SAS Macro variables to improve efficiency and to run monthly.
• Extensively used Proc Report, Proc SQL and SAS Macros for creating reports.
• Imported and Exported data files to and from SAS using Proc Import and Proc Export from Excel and various delimited text based data files such as .TXT (tab-delimited) and .CSV (comma delimited) files.
• Ran DTS packages in production to get data from SYBASE and DB2.
• Wrote stored procedures, scheduled and ran scheduled jobs in SQL Server.
• Modified the Traveler Checks PAPR (Paper Analytics and Profitability Report) Website to add new screens for predictive reporting details on Transaction sizes, Customer, Region etc.
• Helped DBA team in day-to-day database archiving and maintenance processes.
• Documented the production scheduling processes and details of the runs.

Environment Base SAS, SAS/MACROS, SAS/BI Studio, SAS/SQL, SQL Server 2000, Sybase, AS400, UNIX, MS Office

Confidential, NJ

SAS Programmer

Responsibilities

• Provided SAS programming and analysis support for Phase II clinical study.
• Programmed demographic, disposition, adverse events, vital signs, lab data, and efficacy summary tables.
• Developed SAS Macros for data cleansing and Reporting.
• Created analysis datasets for analysis of observed and LOCF values.
• Worked extensively in sorting, merging, concatenating, and modifying SAS data sets.
• Worked with Statisticians in generating SAS analysis datasets, production of data listings, summary tables, and statistical analysis.

Environment Base SAS, SAS/MACROS, SAS/CONNECT, SAS/SQL, SAS/GRAPH and MS-Office

Confidential

SAS Programmer

Responsibilities

• Worked with senior Bio-statisticians and clinical data managers to provide SAS programming in analyzing the data, generate reports, tables, listings and graphs.
• Read the original clinical trial data from Oracle and Excel software and filter the necessary data for SAS program.
• Used PROC Tabulate and PROC Report to create reports.
• Created and maintained SAS Datasets that are extracted from an Oracle Database using SAS/ACCESS.
• Member of the clinical team responsible for conducting Phase I-III multi center studies according to Federal Regulations and ICH guidelines.
• Responsible for assisting senior staff in planning study conduct, designing case report forms (CRFs), planning and running study meetings.
• Responsible for overseeing investigational sites to ensure protocol adherence, assuring timely enrollment of patients and retrieval of CRFs from study sites.
• Processing CRFs including data cleanup and classification of data, and completion of study summary.

Environment Base SAS, SAS/SQL SAS/STAT, SAS/GRAPH, SAS/ACCESS, SQL, ORACLE