Assistant Data

SANDHYA GORTHY

*************@*****.*** *** University

Street, Chattanooga

phone no: 618-***-**** TN-

37403

Objective

To pursue a challenging career and be a part of progressive organization

that gives me the scope to utilize my knowledge and skill in the fields of

data modeling/analysis and SAS programming.

Summary

. SAS certified predictive modeler using Enterprise Miner 5.3.

. SAS Certified base programmer for SAS 9.

. SAS Certified advanced programmer for SAS 9.

. Received SAS/OSU Data mining certificate.

. Sound knowledge of relational databases, MS-ACCESS, SQL, Oracle, SPSS,

STATA & MS-EXCEL including macros.

. Thorough knowledge of business systems development life cycle, project

management and various Business Intelligence tools and techniques.

. Nearly two years of experience on various data mining tools such as

regression, neural networks, decision trees, classification and

prediction algorithms on large scale datasets using SAS Enterprise

Miner, SPSS, STATA with a focus on business development.

. Good Understanding of statistical tests like sample t-test, chi-square

t-test, hypothesis testing, ANOVA, Crosstabs, Multivariate analysis,

time series analysis and various other data analysis concepts with

extensive focus on SAS.

. Experience in analyzing data and generating reports, tables, listing

and graphs etc. using SAS Enterprise Guide 4.

. Experience in employing macros and various SAS procedures like Proc

SQL, Proc Print, Proc Report, Proc Tabulate, Proc Mean, Proc Freq, and

Proc Transpose.

. Expert level skills in Microsoft Word, PowerPoint, Outlook, Access.

. Highly motivated, result oriented team player with excellent

organizational and interpersonal skills.

Education

Masters Degree in Management Information Systems

GPA-3.78

Additional coursework in Statistics and Finance

Oklahoma State University, Stillwater, OK

Bachelors Degree in Mechanical Engineering

GPA- 3.7

Jawaharlal Nehru Technological University, INDIA

Work Experience

Blue Cross Blue Shield of Tennessee

3 Months

Accreditation and Research Medical Informatics Intern

. Identifying factors affecting member compliance with evidence-based

guidelines

. A data table containing demographic, utilization, benefit

structure, enrollment history and 15 months compliance data is

extracted.

. Thorough literature review was conducted to understand business

case and its data.

. Data preparation which includes imputations, transformations,

variable and data reduction was performed.

. For each Medai measure, multiple predictive models (Logistic

regression, Decision tree, Dmine Regression, Neural and Auto

neural etc.) were built using SAS Enterprise Miner.

. PPV/NPV was used as primary measures to assess the model along

with sensitivity and specificity to explore factors driving member

compliance for each measure.

. Extensive use of SAS EM, SAS Enterprise Guide and SAS base &

advanced programming languages.

. Producing ad-hoc reports on a regular basis using data steps, proc

SQL, proc gchart, proc gplot and various other procedures.

Oklahoma State Health Department (OSDH)

4 Months

Research Assistant

. Developed a prediction model for Oklahoma State health department.

. Factors accounting for Non-Renewal of Medicaid were indentified.

. Employed CRISP-DM approach.

. Involved in data preparation, developing various models using

methodologies like Decision Trees, Neural Networks, Regression, SVM,

Ensemble and Clustering to identify the existing patterns in the data.

. Used SAS Enterprise Miner, SAS Enterprise guide and SAS Base

extensively.

Projects (Data Mining & Database Marketing)

. Developed direct response (logistic regression) models in SAS to

identify prospective and vulnerable consumers for offensive and

defensive direct mail marketing.

. Data Mining - 2009 shootout

. Top three states and counties most profitable to grow energy grass for

ethanol production were identified.

. Data on soil, weather, and plant was analyzed and cleaned.

. Developed models using various data modeling techniques to obtain the

best model.

. Employed scoring to identify the top 3 states and counties based on

the profit matrix evaluation.

. Used SAS Enterprise Miner, SAS Enterprise guide and SAS Base

extensively.

. Fund Raising Model

. Potential charity donors who would respond to a mailing campaign were

identified.

. Involved in working through various stages of data cleaning, modeling

and scoring.

. Used SPSS Clementine extensively.

. Database Management System for University Dining Services

. Designed and developed a database management system that allowed

administrator to manage employee data, schedules and weekly reports

using Microsoft Visual Studio and SQL Server 2005.

. E-commerce application - University Book Store

. Developed a 3-tier web based e-commerce application by using various

technologies like ASP.Net, XML, XSLT, HTML and CSS. The back end was

developed and maintained by SQL Server 2005.

Professional Experience at Oklahoma State University

. Graduate Assistant at Institute for Teaching and Learning Excellence

Oklahoma State University: Responsible for recording, editing and

posting media files online. Extensively converted media formats for

online viewing using conversion tools and web development tools.

. Graduate Assistant at International Students and Scholars Oklahoma

State University: Responsible for updating and maintaining student

database. Experienced in generating weekly reports and queries on the

student database.

. IT-Tech Assistant at OSU IT Help Desk: Assisted students and faculty

with computer trouble shooting, installing, configuring and upgrading

operating systems and software.

Other Professional Experience

. Project Assistant:

Dec 2007- April 2008

Bharath Heavy Electricals Pvt. Ltd, Hyderabad

. Involved in "The Heat and Flow Analysis of an Air Pre-heater"

project for calculating various physical parameters of a mechanical

structure.

. FLUENT language was extensively used for coding

Technical Skills

Programming Languages : C, C++, JavaScript, .net, VBA, XML and

SAS Base

Web development skills : HTML, DHTML, CSS, XSLT, FrontPage

Tools and Packages : Enterprise Guide 4.0, Enterprise Miner

5.3, SPSS, STATA, CART, SAP & MS-Office

Databases : SQL server 2005, Oracle and MS-ACCESS

Operating Systems : MAC, UNIX, Windows Vista, XP, 2000, MS-

DOS

Contact this candidate