SUMMARY

• 6+ years of extensive experience in analysis, design, development of Statistical data models including data extraction, manipulation, writing macros and reporting on various projects, for healthcare, Financial and Insurance industries
• Extensive experience in Base SAS, SAS/MACROS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, SAS/ODS.
• Comprehensive skills in working with Base SAS, SAS/MACRO in UNIX and Windows environments.
• Skilled in SAS Programming, Macro Facility, Preparing Data, PROCs, Producing Reports,
• Validating Reports, SAS Formats, Storing and Managing Data in SAS Files.
• Experience and excellent command in producing reports employing various SAS Procedures and handling large databases to perform complex data manipulation using multiples files in SAS data steps.
• Extensive knowledge in data management like Merging, concatenating, interleaving of SAS datasets.
• Proficient in producing reports employing various SAS procedures, like Proc Print, Proc Report, Proc Summary, Proc Freq, Proc Tabulate, Proc Means, Proc Univariate, Proc Transpose, Proc SQL, etc.
• Skilled in generating reports to communicate key findings and articulate strategic implications using Proc Print, Proc Report, Proc Tabulate, Proc Mean, Proc Gplot, and Proc Gchart.
• Experience with data analysisto produce and reportdescriptive statistics
• Experience in developing code for data manipulation, scrubbing, merging/joining, and table lookups
• Proficient in exporting generated outputs to other environments or the web using various SAS method like create delimited, text files, ODBC.
• Generated output files in RTF, HTML, and PDF format using SAS ODS.
• Effective team player with excellent Communication & Interpersonal skills and strong leadership qualities.
• Self - motivated individual with strong Technical & Analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.

TECHNICAL SKILLS

Operating Systems: UNIX, WINDOWS 98/2000/XP, MS-DOS

Programming Languages: C, SQL, PL/SQL

Hardware Platform: SUN Solaris, Windows 2000/NT Servers

Databases: MS SQL Server 2000/7.0/6.5 , MS Access 2000, Tera Data, Oracle8i,9i,10g,PL/SQL

SAS Skills: PROC SQL/Transport/Repot/Summary/Univariate, SAS 9.1.3 BASE SAS, SAS/MACRO, and SAS/CONNECT, SAS-SQL, SAS/STAT, SAS/GRAPH, SAS - ODS, SAS/ACCESS Enterprise Guide

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

SAS Consultant/Bio-Statistician Associate

Responsibilities:

• Extraction of data from different sources and creation of data sets in required formats for analysis and fraud investigation.
• Gathering the requirements from user.
• Providing SAS programming support for the analysis and reporting.
• Used Macro routines to convert xls, .rtf and .txt files to produce SAS reports and graphs.
• Used Proc SQL, Proc import, Proc export statements to load SAS data sets from and to Oracle.
• Wrote efficient SAS templates and Modifying Data Mining Queries using SAS/BASE, SAS/MACROS & SAS/SQL and validating the data before use the same for final analysis.
• Managed wing-to-wing delivery of Healthcare Insurance fraud reports to other teams to analyze and recover from providers.
• Developed UNIX fast load shell scripts to schedule the load of vendor flat files on daily, weekly and monthly basis to corporate data warehouses.
• Wrote cross validation queries for checking the validity and integrity of the data on the loaded on to the data warehouse with respect to the source datasets in SAS.
• Extensively used SAS ODS along with PROC REPORT facility to create customized reports.
• Loading data for analytical processing, typically in (detail & summary) SAS datasets, .xls, csv and html reports.
• Constructed, tested, and validated statistical models.
• Develop programs and perform unit test using SAS.
• Created robust and efficient analytical data sets.
• Extensive use of SAS/Access, SAS/Connect to connect to databases.
• SAS/STAT was employed to produce statistical analysis such as regression, multivariate.
• Quarterly and annual sales and profit summary reports were prepared using the Proc Report.
• Involved in segmentation and response analysis for direct marketing campaigns.
• Implemented data management plans designed to meet project deadlines.

Environment: SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Macros, SAS/Access, MS-Excel.

Confidential, Columbia,SC

SAS Programmer/ Clinical Data Associate

Responsibilities:

• Producing analysis datasets for generating Reports.
• Created and maintained SAS Datasets extracted from Database.
• Created Tables, Listings, Graphs and customized reports using various procedures like Proc Report, Proc Tabulate, Data null and Proc Gplot.
• Involved in writing the SAS code to help in the process of Quality control by implementing various statistical procedures like Proc Freq, Proc Means, Proc Univariate and other procedures like Proc Summary, Proc Transpose, Proc SQL and Proc Print.
• Extensively used SET, MERGE, UPDATE statements and Proc SQL for adding new variables or observations, creating subsets or modifying datasets.
• Produced RTF, PDF and HTML formatted files using SAS/ODS.
• Documented data sets using specifications worked out in conjunction with senior manager.
• As a clinical data associate performed UAT on EDC Software and reported the edit checks.
• Wrote SAS Programs for the edit checks that were detected manually.
• Performed validation of SAS-generated output (tables, listings and graphs) via independent programming. Also performed QC checking and validation of SAS programs written by other programmers.
• Used the SAS Macro facility to modify existing departmental macros and to replace repetitive codes.
• Involved in CRF review, SAP development, Protocol development and review of TLG
• Participated in team meetings to discuss best programming practices. Established and maintained sound working relationship and effective communications within Biostatistics, Statistical Reporting, and the Data Management group.

Environment: SAS v9.1, SAS/BASE, SAS/GRAPH, SAS/MACROS, SAS/SQL, SAS/ODS, SAS/ACCESS, UNIX, Windows XP and oracle

Confidential, Cranford, NJ

SAS Programmer/Analyst

Responsibilities:

• Extracted and analyzed data from the database using SAS/Access, SAS/SQL PROCEDURES and created SAS datasets.
• Participated in direct analysis of data and definition of efficient, cost effective application solutions which support client business processes and functional requirements.
• Performed coding, testing, debugging, documentation, and installation tasks for on-line and batch processes reports in accordance with client specific internal procedures and standards.
• Utilized SAS SQL and SAS/ACCESS tools extensively for data location, extraction and retrieval from the main server. Imported workable data into SAS from various data types and formats like metadata, MS Excel and MS Access files, delimited text files, and comma separated values (CSV) files.
• Involved in creation of Data Definition Tables (DDT) & SAS Export files for FDA submission.
• Extensively used Proc Report, Proc Tabulate and DATA NULL technique to to create reports, Tables, listings and used Proc Gplot to create graphs in various formats like cgm, pdf, jpeg with help of GOPTIONS statement.
• Performed data analysis on the data sets using Proc Means, Proc Freq, and Proc Univariate etc.
• Developed summary reports using SAS Procedures like Proc Freq, Proc Univariate, Proc Summary, Proc Report, Proc Means, and Proc Tabulate etc.
• ProvidedsummarizedSAS datasets to UI team to generate dynamic graphs.
• Gave significant contribution in modifying or rewriting an entire report section using SAS MACRO, SAS/FUNCTIONS, Proc Content, Proc Means, Proc Freq, Proc Tabulate, Proc Report, etc. according to Oracle database format.
• Used ODS statements and Proc Template to create reports in style format.
• Used SAS Macros, PROC SQL to extract, sort, match test accounts and ODS to HTML, PDF and RTF.

Environment: UNIX, VI Editor, Base SAS v9, SAS/Access, SAS/Connect, SAS/SQL, SAS/ODS, SAS/MACRO, SAS/GRAPH, SAS/STAT, MS Excel, Tera Data, Oracle 10g, PL/SQL

Confidential, Atlanta, GA

SAS Programmer/Analyst

Responsibilities:

• Worked closely with research team of scientists and Biostatisticians to analyze data, summarize tables and listing specifications.
• Developed project analysis plans, including table specifications, statistical analyses and report formats.
• Reviewed study Protocol, Annotated Case Report Form (ACRF), and performed validation of clinical trial data to identify illogical data entries.
• Review of specifications, mock tables and listings.
• Performed Statistical Analysis and generated reports using SAS/MACRO, SAS/ODS, Proc Report, Proc Print, Proc Summary, Proc Freq, Proc means, Proc tabulate and Proc SQL.
• Used Base SAS to perform sorting, indexing, merging of datasets and generated reports.
• Modified existing SAS programs using SAS macro variables to improve the ease, speed and consistency of the results.
• Extensively used SAS DICTIONARY tables to get updated information on datasets.
• Extensively used BASE SAS functions like ROUND, SCAN, INDEX, SUBSTR, TRIM, LENGTH, PUT, INPUT, DATE, MAX, MIN and MEAN.
• Used SAS/ODS to generate the Statistical reports in HTML format.
• Used SAS macros functions to simplify the process and to get consistent results.
• Developed routine SAS Macros to create tables, graphs and listings for inclusion in clinical study reports and regulatory submissions and maintained existing ones

Environment: SAS v8, SAS/BASE, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/MACRO, UNIX, Windows and MS Office

Confidential

SAS Programmer

Responsibilities:

• Created SAS datasets from Oracle database with random sampling technique and created Oracle tables from SAS datasets by using SAS Macros.
• Created required financial reports using analysis output and export them to other environments or the web using various SAS method like create delimited, text files, ODBC, CPORT, ODS having formats such as HTML, RTF, or XML.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE
• Analyzed data using various statistical procedures like Proc Summary, Proc Means, Proc Freq, Proc Univariate, Proc Reg and Proc ANOVA.
• Used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction
• Proposed a set of action plans to mitigate the risks identified with the sourcing decision
• Generated HTML, Listings, EXCEL and RTF reports for presenting findings of various statistical procedures using Proc Report, Proc Print, Proc Freq and also SAS ODS.
• Developed programs for analyzing exposure to risk and loss by performing complex analysis and modeling using REG, ANOVA, GLM and LOGISTIC procedures.