Varun Prakash Email & Phone Number

Wilmington, Delaware

Houston, Texas Area

• Analyzed the theoretical loss of a patron based on demographic factors and customer behaviors• Built models to predict the gaming preferences of the patron and also quantified the impact of hotel stays on theoretical loss using SAS Enterprise Miner• Imported and Exported data files to and from SAS using Proc Import and Proc Export from Excel and various delimited text based data files such as .TXT (tab delimited) and .CSV (comma delimited) files into SAS datasets for analysis.• Generated final study reports, tables, listings and graphs by using PROC Tabulate, PROC SQL, and PROC GChart• Computed the likelihood of patrons responding to the offers and also segmented the patrons misusing the offers• Identified the most valuable patrons and built models to predict the theoretical loss of a patron• Optimized offer campaign by identifying the patrons visiting in ‘T+2’ month and effectively reduced mailing costs

Chennai Area, India

• Performed extensive ETL activities for data consolidation, cleaning and transformation data sets containing different variables using DATA step, PROC SQL, PROC MERGE and PROC FREQ • In Data Transformation and Manipulation process, extensively used procedures like Means, Transpose, Tabulate, Copy, Sort, Datasets etc • Created Analysis Datasets, Summary Tables, Listings and Plots according to the specification of the study for statistical analysis • Constructed and edit check programs to find data discrepancies in raw datasets provided by Data Management Group• Designed daily, weekly and monthly reports using Proc Tabulate, Proc Report and SQL • Visualized data using tableau and provided business recommendations to boost revenue and increase customer base of the company

Chennai Area, India

• Experienced all facets of SDLC including requirements gathering, designing, coding, testing and deployment • Optimized complex queries of the interface batch processes through tuning the logical structure of the databases, and access paths, which resulted in 50% lesser execution time • Improved overall performance of processes by creating new SQL queries • Built series of complex programs using Cobol-DB2/CICS/EZYTRIEVE/REX languages• SQL Stored procedure and query development to transform business rules into data functions

Master'S Degree, Computer And Information Systems Security/Information Assurance, 3.41

Activities and Societies: Cricket, Dance(1) Executed a real time academic project where Analysis and Prediction of Theoretical Loss.

Bachelor'S Degree, Electrical, Electronics And Communications Engineering, 3.51

Secured a GPA of 3.51 with a 'Distinction' degree. Won many intercollegiate project competitions. Chairperson of the Judging and Marketing.