Karthik Lavangu

ljtkc2@r.postjobfree.com

*** ******* *** #*, **********, OK 74074

305-***-****

Summary

• Motivated graduate student seeking work in Business Analytics, Data Analysis, Database Marketing and Data Mining areas

• Proficient in Regression, ANOVA, Factorial Design, RFM Codes

• Proficient in different predictive modeling techniques like Neural Networks, Decision Trees

• Excellent knowledge of the statistical analysis tools like T-tests, Chi-square tests, correlation

• Excellent SAS and SQL programming skills

• Excellent working knowledge of different analysis tools like SAS, SPSS and Microsoft Excel

• 2+ years of academic experience in SAS, Predictive modeling, Database Marketing and Data Mining

• Experience in handling large databases and performing data interpretation

• Knowledge of the financial concepts like Capital Budgeting, CAPM

• Good at Accounting aspects of Time Value of Money, Income Statement and Balance Sheet

• Good knowledge of Relational Databases, web development

• Highly proficient in MS Word, MS Excel, and MS Powerpoint

• Excellent presentation, communication, analytical and problem solving skills

• Highly motivated and dependable in achieving set goals

• Ability to establish priorities, work independently and execute projects

• Good organizational and time management skills

• Team player with experience of working diplomatically and collaboratively

Academic Profile

Master of Science – Management Information Systems Aug’08-July’10

William S. Spears School of Business, Oklahoma State University, Stillwater, OK, USA GPA: 3.55

Bachelor of Engineering Computer Science Sept’03-May’07

University of Pune, Pune, India GPA: 3.5

Technical Skills

Enterprise Software: SAS Enterprise Guide, SAS Enterprise Miner, Base SAS, SPSS - Clementine

Operating Systems: Windows NT/9X, 2000, XP, VISTA, UNIX, Linux, DOS, Macintosh

Languages: C, C++, J2EE

Databases & Query Languages: MS Access, Oracle 9i, SQL Server 2005, MySQL, PL/SQL

Web Development: XML, XSL, HTML, ASP, ASP.NET, PHP, VB, VB.Net, Open Laszlo

Servers: IIS, Apache Tomcat

Other Packages & Environments: Microsoft Visual Studio, Adobe Dreamweaver CS3, Net Beans, Eclipse, TOAD, Crystal Reports, Adobe CS

Certifications

• Predictive Modeling Using SAS Enterprise Miner 5 May’09

• SAS Certified Base Programmer for SAS 9 Dec’09

• OSU/SAS Data Mining Certificate Nov’09

• Graduate Certificate in Business Data Mining, OSU Nov’09

• Introduction to ArcGIS Server by ESRI June’09

• Introduction to the Multiuser Geodatabase by ESRI June’09

Work Experience

Business Systems Intern - Hartsfield-Jackson Atlanta International Airport May’ 09-Aug’09

Position: Business Systems Intern

Responsibilities

• Successfully reviewed the business systems used by the Information Services Division (ISD) of the Hartsfield-Jackson Atlanta International Airport (HJAIA) and submitted assessment reports to the manager of Business Systems.

• Conducted an extensive review of the airport facility management system, IBM Maximo and its modules including work orders, inventory, tools, equipment, locations, routes, and labor. At the end of the review, a well-written report of the findings was submitted to the CIO of the HJAIA which is now the basis of their current effort to upgrade and fine tune their IBM Maximo system.

• Was involved in reviewing system issues/incidents and providing feedback on the issues/incidents, testing information security products and providing feedback.

• Worked on migration of airport’s intranet website onto Microsoft SharePoint web portal

• Was responsible for researching, analyzing and recommending new hardware and software systems

Client: Oklahoma State Department of Health Jan’ 09-May’09

Position: Predictive Modeler

Project: Predicting factors that contribute to the denial of Medicaid Insurance to customers

Built a Predictive model for Oklahoma State Department of Health to analyze & decrease the number of Medicaid denials because of non renewals, which helped them to recoup the lost dollars by developing a targeted campaign. Used SAS EM, SAS EG and BASE SAS to cleanse & analyze data. Modeling was done using Neural Network, Decision Trees, Regression, and Ensemble models.

Responsibilities

Was responsible for business understanding, data understanding, data preparation, model building, model evaluation and deployment of the model.

Software Developer - Syntel, Inc Nov’07 - June’08

Position: Software Developer

Responsibilities

• Successfully developed GUI and middleware using Open Laszlo, XML and J2EE for Sterling Java Development for their background checking application.

• Was responsible for raising and resolving tickets for system and resource maintenance

• Was responsible for maintaining activity/error logs and system inventory

Research Intern- Capsilon Aug’06 – Apr’07

• Involved in developing “Text Based Classification Engine” using Bayesian Decision Theory using JAVA and Oracle 9i for Capsilon as a research intern

Academic Experience

Course: Business Intelligence Tools and Techniques

Project: Predicting which customers are likely to switch from their network to the newly launched (3G) network

• An Asian telecom operator had launched a third generation (3G) mobile telecommunications network. They wanted to know the number of customers who would respond positively to their campaign. The customers were more likely to be the ones who would be switching from their existing networks to the newly launched network. We were provided with existing customer usage data and demographic data. Three-quarters of the dataset (18,000 records) was used for model building while the rest for scoring the data (6,000 records). Data preparation was done using SAS Enterprise Guide and SAS Enterprise Miner while the model building was performed using Clemetine.

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.

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.

Relevant Courses

Database Marketing, Data Mining and CRM Applications, SAS Programming, Financial Accounting, Business Intelligence Tools and Techniques, Advanced Systems Development, Advanced Database Management Systems, Information Systems E-Commerce

Visa Status: F1 Willing to relocate

Contact this candidate