Data Professional Experience

SHILPA KHAMBHATI

** ****** ****

West Windsor, NJ 08550

Cell: 609-***-****

E-mail: *********@*****.***

www.linkedin.com/in/shilpakhambhati

SAS DEVELOPER STATISTICAL PROGRAMMER SYSTEM ANALYST

Senior SAS Developer with extensive experience in design and development of applications, data analysis, reporting, data management, data profiling and data validation with large datasets.

Summary of Skills:

Possess extensive knowledge of developing, modifying and maintaining SAS program suites

Possess excellent communication and coding skills

Ability to identify data issues and efficiently navigate through large datasets and derive solution

In-depth knowledge of SAS programming, gathering requirements, data processing, data collection, data validation, quantitative and qualitative data analysis

Excellent organizational and time management skills

Possess exceptional innovative and problem-solving skills

Excellent team player with high level of personal initiatives

Ability to handle multiple tasks simultaneously

Superior skills in analyzing and managing data, generating tables, listings, graphs and reports

Technical Skills: SAS

Languages: SAS(SAS/BASE, SAS/GRAPH, SAS/SQL, SAS/MACRO, SAS/SQL, SAS/ACCESS, Perl Expressions), R, SQL, Tableau, Excel

Software: SAS v9.4, SAS Server, R, Python, VB .Net, MS Office

Database: SQL Server, Oracle, MS ACESS.

Educational Qualification:

Bachelor's Degree in Medical Technology Kean University – 1986

Professional Experience:

System Analyst

Mathematica Policy Research, Princeton, NJ

2000 – 2017

Performing the tasks of designing and developing project-specific SAS programs

oResponsible for all programming aspects within a Health and Human Services research environment, including generation of standard and derived datasets, programming documentation, and tables, figures, and listings for all analyses.

oCreated reusable programs and macros for the data transformation and data cleaning; utilized Arrays, do loops, data _null_, retain, first and last variables, Perl expressions, SAS procedures and SAS functions

oAutomated daily reports programs and implemented a process to execute them during the nightly process

oWritten efficient and intricate SAS programs to extract, manipulate, mine and merge datasets with very large number of records as well as thousands of variables

oBuilt custom SAS reports to monitor survey progress, response rate, adaptive design methodology, predictive models, correlations, statistical tests, broken down to the sub categories in form of multi tab Excel, RTF, PDF and HTML with visually compelling formats. Helped business users summarize data in the ways that enable them to solve challenging issues on the projects and better understand the trends of the responses.

Developed various application by incorporating SAS with MS Office products

oDeveloped innovative application to incorporate report tables into final document to the client, using SAS and MS Office tools like DDE triplet and MS word book marks, saving considerable administrative cost to the project by avoiding manually inclusion of the tables into the main document

oWritten application to execute multiple parameters driven SAS macros from Excel, giving capabilities to the none programmers to execute process and create final results

oDeveloped a generic process in SAS/Macros and Access to build code book as data dictionary document that accompanies the final data file sent to the client.

oWritten SAS Macros to upload verbatim responses in to the SQL database and download and incorporate coded values to the main data file.

Technical Lead for the entire spectrum of the project

oServed as a liaison between the programmers and the project team, providing technical inputs to the project

oSupervised programming work and provided assistance with the challenging technical issues

oGathered business requirements and convert to design specifications

oManaged work assignment, schedule and budget

oMentored new team members

oDirected the development of best practices and QC guide lines

oLead the development and maintenance of the standard code libraries

oEnhanced interdepartmental communication by developing data file transfer protocol

Technical Papers and Presentations:

Khambhati, S., Extending the Power of Base SAS® with Microsoft Excel.

Khambhati, S. Wright, D., and Jones, B., 2009. National Beneficiary Survey: Round 1 To 4 Public Use Data Files. Mathematica Policy Research.

Khambhati, S. Shepperson, K., Barbara, K., and Palanca, R., 2008, March. Using dynamic data exchange (DDE) and macro variables to create custom Excel workbooks with multi-sheets. In Proceedings of the SAS Global Forum 2008 Conference, San Antonio, Texas (pp. 16-19).

Contact this candidate