Project Data

[pic][pic][pic]

Abishiktha Putta

*** * **** ******, ***# F34 650-***-****

Stillwater, OK 74075

**************@*****.***

Summary

. Seeking work in the Business Analytics, Data Analysis, Database

marketing and Data Mining areas

. 3+ years of experience with Database design, Data Analysis,

Statistical Modeling, Database Design and SAS Programming

. Proficient in ANOVA, Factorial Design, RFM Codes, Customer

Segmentation, Survival Analysis, SOM/Kohenen

. Expert in different predictive modeling techniques like Neural

Networks, Decision Trees, Regression

. Excellent knowledge of the statistical analysis tools like T-tests,

Chi-square tests, correlation

. Knowledge of the financial concepts like OTC Products, Futures,

Options and Portfolio Management

. Excellent communication, analytical and problem solving skills

. Good knowledge of Relational Databases

. Excellent SAS, SAP and SQL programming skills

. Fast learner with a drive to exceed expectations

. Worked with transaction datasets of 100M+ records

. Excellent working knowledge of different analysis tools like SAS, SPSS

and Microsoft Excel

Education:

Master of Science in Management Information Systems

Oklahoma State University: Stillwater, Oklahoma, USA

May 2010 3.91/4.0

Awarded Outstanding full time student for "Graduate Certificate in Business

Data Mining Program" for 2009-2010

Master of Management Studies

Birla Institute of Technology and Science, Pilani

May 2006 3.6/4.0

Technical Skills

Enterprise Software: SAS Enterprise Guide, SAS Enterprise Miner, Base SAS,

SPSS - Clementine, Rapid miner, STATA, CART

Languages Known: C, ABAP/4, Java, SQL, PL/SQL, Oracle, C++, C#, VB,

HTML, XML, and ASP.NET

Databases : Oracle 8i/9i, SQL Server, MS Access

Operating Systems and Packages: MS-DOS, UNIX and Windows NT/9X, 2000, XP,

Vista, Microsoft Visual Studio 2008, MS Office 97/2000/XP

Certifications:

> SAS Certified Base Programmer for SAS 9

September 2009

> SAS/OSU - Data Mining Certificate

December 2009

> SAS Certified Predictive Modeler using SAS Enterprise Miner 5.2

March 2009

> SAS Certified Advanced Programmer for SAS 9

March 2010

Professional Experience

Research Assistantship: Secure Analytics Project, Dr. Rathindra Sarathy

Oklahoma State University, OK

Aug 2009 to till date

. Development of web based platform using C# for data shuffling which

uses advanced statistical techniques like ranking, correlation that

allow organizations to make full use of their numerical data while

simultaneously preventing disclosure of any sensitive information

Research Assistantship: Institute for Research in Information Systems

(IRIS)

Oklahoma State University, Stillwater, OK

Aug 2008 to Dec 2008

. Development of training website for Defense Ammunition Center(DAC), Mc

Alester, Oklahoma

using XML, ASP.NET and Java Script

Software Engineer: Infosys Technologies Ltd

Hyderabad, Andhra Pradesh, India

Jul 2006 to Jul 2008

. Development and Implementation of Core functionality for Daimler

Chrysler, Stuttgart, Germany using SAP and SQL to optimize one of the

most critical applications for Sales, distribution business and

financial management.

Intern: Globeop Financial Services India Pvt. Ltd

Jun 2005 to Dec 2005

Mumbai, Maharashtra, India

Worked on trade entry and pricing of OTC Products, Hedge funds, Swaps for

various funds like Deeshaw, CPM, Lilypond and SnailFish.

Academic Projects:

Client: Oklahoma State Department of Health

Project: Predicting factors that contribute to the denial of Medicaid

Insurance to customers

> Built a predictive model which deals with developing a targeted

campaign to decrease the number of Medicaid denials because of

non renewals. The non renewal leads to rejection of the Medicaid

in the 270/271 process. The aim of the analysis is to find out

the reasons which include analyzing variables like ICD9 codes,

Diagnosis Codes, Modifiers for non renewal and also denials

during the final billing process. Used SAS EM, EG and

programming in Base SAS to cleanse, analyze and build the model.

Used Neural Network, Decision Tree, Regression, and Ensemble

models.

Competition: SAS Data Mining Shootout M2009

Project: Prediction of Energy grass yield based on soil and weather

conditions

> Built a ranking model to rank the top three states and counties

in the US with respect to the energy grass densities based on

the soil and weather conditions. The data set included 20

independent variables and a target variable with over 20,000

records. Missing values in the target variable were handled

through cluster analysis. Data was then modeled using SAS

Enterprise Miner to predict the energy grass yield per acre in

each county. A density function was determined to rank the

yields of various counties and states. Base SAS was used

extensively to cleanse, analyze the data, and calculate

densities and ranks.

Course: Business Intelligence Tools and Techniques

Project: Predicting Customer Type for Asian Telco operator

> Project involves an Asian Telco operator who would like to make

use of existing customer usage and demographic data to identify

which customers are likely to switch to using their 3G network

for which the objective is to predict accurately as many current

3G customers as possible. The data had more than 200 variables

which were reduced to a few important variables using domain

expertise and techniques like Variable Reduction. Data mining

techniques like Decision Trees, Neural networks in SPSS

Clementine were used to predict the type of network. Training

data was used to build models and the best performing model is

to be applied on the scoring data which has 6000 customers to

predict the type of network for the future customers and target

accordingly.

Course: Database Marketing

Project: Model Selection for scoring the house-file of a catalogue

company

> A catalogue company mails between 6-12 catalogues per year to

its house file. The data sample has 2371 randomly chosen

observations from customers who responded positively to the fall

catalogue last year. Data includes a target variable specifying

the 'amount of orders placed' and the potential variables that

affect the behavior of this target variable. The main objective

is to build a good regression model using SAS EG that predicts

the 'amount of orders' on calibration data and use that model to

score the rest of the house file

Course: Database Marketing

Project: Predicting people's Response for buying in a mail campaign

> Building a predictive model to predict the potential customers

who are most likely to buy and include them in the mailing

campaign for this year. The model built should improve the

profits being generated. RFM and Logistic Regression Models were

constructed on the cleansed data and the best model was

determined based on highest profits generated. Decile Analysis

was then applied to determine the top percent customer base in

terms of generating high profits.

Client: Kids Discovery Camp, CEAT department at Oklahoma State University

Project: Information Systems Development for Kids Discovery Camp using

ASP.Net and SQL Server 2005

> Kids Discovery Camp is the summer camp organized by the

department .The primary purpose of the project was to build a

web-based registration form using ASP.Net to collect camper

information and reduce the manual effort put in maintaining the

information. The project's database was built using SQL Server

2005 to maintain the data throughout the years.

Trainings:

. Attended M2009 conducted by SAS Inc. at Las Vegas from Oct 26-27,

2008. Gained knowledge on topics such as Advanced Sampling schemes

like cross validating and bootstrapping, Neural Networks, Decision

Trees and Regression, Survival Analysis, Ensemble Methods, Two Stage

Modeling, SOM/Kohonen, Support Vector Machines

. Attended 3-day training on 'Advanced SAS and Base SAS programming'

conducted by Infinity Tech Group

Relevant Courses: Database Marketing, Data Mining and CRM Applications,

Advanced Data Mining Techniques, Advanced Marketing research, SAS

Programming, Econometrics, Statistical Experimenters II.

Awards and Affiliations:

. Awarded lifetime membership in Beta Gamma Sigma.

. Awarded "The champion for the quarter" (July-Sep, 2007) at Infosys

Technologies Ltd., Hyderabad.

. Awarded Prestigious Pratibha Scholarship by AP Government for

Excellence in 12th Grade.

. Worked for Art and Decoration Department at BITS, Pilani.

. Active member of Management Association during 2004-2005 Interface,

BITS, Pilani.

Willing to relocate

Contact this candidate