Profilbillede af KPuppala
@KPuppala
Member since 9. juni 2010
0 Anbefalinger

KPuppala

Online Offline
Kiran Puppala ________________________________________________________________________________ Eight years of experience in applied statistical analysis and interpretation using SAS (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 Verizon, Irving, TX Client Services Manager Aug’ 09 – Feb ‘10 Consultant - Client Services manager in Verizon Telecom Database Marketing Group. Maintained and built strong relationships with Verizon Telecom Marketing clients. Ensured that the client needs are met by understanding the campaign requirements and engaged both clients and the development team so the campaigns are implemented in a timely manner. Validated the campaign performance by auditing the offer assignment (using SAS Scripts) and identify any solutions to ensure proper implementation of the campaign for the coming cycles. Implemented monthly and ad hoc campaigns via email and bill messaging marketing media. Society of Petroleum Engineers, Richardson, TX Data mining consultant Oct’ 08 – Apr’ 09 Consultant on all the data mining projects identified by SPE Marketing group to understand the customer base and identify trends within the realm of usable data resources. Conducted a knowledge discovery study to characterize the Attendance and Purchasing behavior of members to generate geographic, demographic, and membership profiles based on meeting/conference attendance and technical disciplines of membership. Identified data resources and enhanced data quality to fit the needs of the analysis. Developed profiles of all members of SPE to understand Meeting Attendance behavior across SPE specific segmented regions and also within each SPE region to understand member’s travel patterns. 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-throughs 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. Responsible for querying the data out of databases using SQL in MS Access interfaces. Environment: Base SAS v 9.2, SAS /STAT and MS Access 2000. North West Airlines Inc., Minneapolis, MN Apr’ 03 – Mar’05 SAS/Business Analyst Consultant The project was entirely developed according to the specifications of Marketing group. Provided Statistical design and analysis, data collection implementation plans, data gathering and processing strategies, statistical analysis, sample design, presentation of data results and in-depth market research and analyses. Developed Technical requirements from Business specifications. True Origin and destination system was Designed and developed in SAS. Real time variables such as, revenue generated in particular route, number of flights and seats booked, days of over bookings were consolidated from NWA and KLM oracle databases by Proc SQL. Extracted data was merged and sorted for particular route using Merge and Proc Sort. Berlex Laboratories, Inc. Feb’02 – Jan ‘03 SAS Consultant Berlex is involved in the development of therapeutic drugs for the treatment of Alzheimer’s, Parkinson’s and is also engaged in gene therapy projects. Performed various analyses such as Regression, correlation and analysis of variance for the clinical trials (Phase II a & b) involved in therapeutic product development Data exchange between oracle and SAS data sets using SAS/ ACCESS. Generated reports using various procedures (TABULATE, REPORT and SUMMARY). Extensive experience in performing descriptive statistical analysis. Experience in handling large data sets (including sorting and merging). 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 MasterS Project: Data mining Tool tO estimate the performance of decision tree algorithms Developed a statistical analysis tool for the comparison of various machine learning algorithms (Decision tree learning algorithms like ID3, C4.5, and OC1) for their performance in terms of the Mean Square Error produced as a result of testing, training, and bootstrapping the algorithms on the data sets. The tool compares the data sets, both commercial and artificial, and performance of the algorithms. The GUI and the algorithms were implemented in Java. The project mainly integrates two software packages, SAS and Machine Learning C++ library of classes with GUI and several algorithms necessary for comparison in Java. Education ms Software Engineering Department of Computer and Information Sciences KANSAS STATE UNIVERSITY ms Turf grass Science – Environmental research (Golf Course Water Conservation) 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. Fundamentals of Geographic Information Systems – Spring 2010 Spatial Concepts and Organization – Spring 2010 References: Provided upon request
$50 USD/hr
0 anmeldelser
0.0
  • N/AJobs udført
  • N/AIndenfor Budget
  • N/ATil Tiden
  • N/AGenansættelsesfrekvens

Portfolio

Nylige bedømmelser

Ingen bedømmelser.

Verifikationer

  • Facebook forbundet
  • Foretrukken Freelancer
  • Betalingsverificeret
  • Telefon Verificeret
  • Identitet verificeret
  • E-mailverificeret

Gennemse lignende freelancere