KIRAN PUPPALA
4221 Hawkins Drive, McKinney, TX 75070
(214) 585-4695 (home); (214) 783-6219; Email: [Send email using form at
bottom]
________________________________________________________________________________
• Seven years of experience in applied statistical analysis and interpretation
(design of experiments, ANOVA, correlation and regression analyses) in fields
ranging from agricultural/food research to artificial intelligence, business
applications and pharmaceutical research.
• Four years of experience in Database Marketing, Quantitative Market Research
and Marketing Analytics.
• Strong knowledge in KDD (Knowledge Discovery in Database), Data mining and
Pattern recognition.
• Permanent Resident
PROFESSIONAL EXPERIENCE
Society of Petroleum Engineers, Richardson, TX
Data mining consultant Oct’ 08 – Present
Currently working as a Consultant on all the data mining projects identified by
SPE to understand the customer base and identify trends within the realm of
usable data resources.
• Conducted the Attendance and Purchasing behavior of the members study to
understand the geographical, demographic, and membership profiles based on any
meeting/conference attendance and the technical disciplines the members originate
belong to. Identified the data resources, performed extensive cleaning and
modification of the data to fit the needs of the analysis.
• Developed profiles of all the members to understand SPE Meeting Attendee
profiles across the SPE specific segmented regions and within each region to
understand the member movement and behavior.
• Conducted email tracking and success rate study to measure Email Broadcast
campaign success, deliverability, and measure marketing response for each of the
campaigns. Number of emails, percentage of who opens, forwards, and
clicks-through were the metrics collected to conduct this study. The above
metrics were analyzed and merged with the member profile data and also the
attendance and purchasing data to understand the overall profiles of the
members.
Environment: Base SAS 9.1, SPE Membership databases in Oracle.
Citigroup, Irving , TX
Project Manager
Mar’ 07- Nov’07
Worked as a consulting project Manager with Proactive sales Management group to
identify and revive the lapsed customer base.
• Campaign Management
o Implemented criteria for Marketing and Risk mitigation programs to ensure
effective customer selection for proposed marketing campaigns.
o Matched business requirements by internal clients (Marketing and Risk) with
implemented criteria.
o Assisted in reviewing the resultant coding reports to look for anomalies which
suggest any issues with any candidate programming code to final release into
production systems.
o Translated program criteria specifications into programming code usable by
Citigroup proprietary tools set and into SAS to facilitate analysis and
validation.
• Project Management
o Identified business needs and ensured the deadlines are met based on the
campaign requirements
o Played a major role in communicating with business partners both on-shore and
off-shore (India) to identify business needs and proper implementation of
campaigns on timely manner.
Environment: MVS, JCL in TSO/ISPF, SAS v9.1, Reporting tools Specific to
Citigroup, Validation in UNIX environment.
Countrywide Financial Corporation, Plano, TX
Sept’06 – Dec’06
Performance Analyst
Worked as a consulting analyst hired to identify key performance metrics and
measure the performance of the web application.
• Performance monitoring
o Identified key performance Metrics for Performance monitoring from the test
results of the application testing scenarios by researching each of the access
database which is a result of each test case scenario.
• Data Warehousing
o Developed a Data Model to warehouse the performance testing data in SQL Server
2000.
o Developed ETL process to import the data from the access databases resulting
from the test scenarios using the Data Transformation Services in SQL Server
2000.
• Performance reporting
o Performed descriptive statistics to understand the utilization to
response-times relationship.
Environment: Base SAS v 9.2, Mercury Load runner (Software testing tool), SQL
Server 2000, and Access 2000.
American Heart Association, Dallas, TX Nov’05 – Sept’06
Customer and Marketing Research Analyst
• Quantitative Market Research
o Performed Correlation of Customer Satisfaction data with data from the
existing database and observing correlations of various variables from both
(overlay analysis) using SAS.
o Validating the existing customer satisfaction survey model by observing the
Canonical correlations among and between the variables to observe the model fit.
o Observing and selecting variables that correlate well with Overall
satisfaction ratings by using Stepwise Regression analysis to understand the
dependency of Customer Loyalty on Overall Satisfaction.
• Data mining and developing descriptive models from the Customer database.
o Analysis on various segments of the Customer populations using SAS to
understand overall customer behavior.
• Developed Lifetime value models for one segment of the database to get
Customer Lifetime Value.
• Developed Customer profiles and Survival data mining observing survival and
Cox proportional hazard estimates and life table estimates to understand the
customer lapse rates.
Environment: Base SAS v 9.2, SAS /STAT and Access 2000.
Kansas State University, Manhattan, KS
KSU Honor System Aug’ 99 – Aug’00
Graduate Assistant
• Designed and implemented KSU Honor system web page using Front Page 2000.
Dept. of Grain Science & Industry Sept’98 – June’99
Research Associate
PROJECT: Pre-harvest Prediction of Wheat yield.
• Provided statistical design and analysis expertise. The goal of this project
was to develop statistical models to accurately forecast yield of wheat grain
based on analysis of agronomic and geographical conditions.
• Techniques such as multiple regression, multivariate analysis (MANOVA),
correlation, and paired-t test procedures were used to explore, and identify
best-fit models that can accurately predict wheat yield.
• Best fit model selection was performed using backward elimination and forward
propagation procedures.
• Designed an Access Database to gather data required to analyze Wheat yields in
different
Dept. of Horticulture, Forestry, & Recreation Resources Jan’95 –
Sept’98
Research Assistant
PROJECT: Drought Resistance of Perennial Rye grass cultivars
• Responsible for design, implementation, and management and analyzing the
results.
• This project investigated the stress physiology of Perennial Rye grass
cultivars typically used on golf course fairways. Critical survival responses
(leaf moisture, root length density, % viable area) were analyzed using Analysis
of Variance, and correlations were determined with environmental factors (air
temperature, soil temperature and moisture, and amount of precipitation)
• Data collection, management, analysis, and interpretation
KSU Student Family Housing Jan’97 – Sept’98
Student Manager
EDUCATION
MS Software Engineering
Department of Computer and Information Sciences
KANSAS STATE UNIVERSITY
MS Turf grass Science – Environmental research
Department of Horticulture
KANSAS STATE UNIVERSITY
TECHNICAL SKILLS
Statistical Packages: SAS V.9, Matlab
Programming Languages: Java, C, C++, SQL, T-SQL
Operating Environments: DOS, Windows, Windows NT/2000/XP, Unix, MVS/TSO
Web Technologies: XML, HTML, JavaScript, CGI
Databases: Oracle 9i, MS Access, SQL Server 2000, Business Objects
Tools: MS Office (Word, Excel, PowerPoint, FrontPage), Rational Rose, UML,
Crystal reports, VISIO, Siebel Analytics
PROFESSIONAL TRAINING
• SAS Business Intelligence (BI) Architecture and Data Integration (SAS
Institute, October 2006).
• Advanced Statistical methods I and II University of Texas at Dallas – Fall
2008 and Spring 2009.
References: Provided upon request
|
