Varun Prakash Email and Phone Number
Varun Prakash work email
- Valid
Varun Prakash personal email
• Over 5 years of experience in large-scale databases, expertise in relational database design and maintenance (RDBMS), optimizing, writing complex SQL queries and Macros• SAS Certified Professional with over two years of experience in business analytics, data mining and predictive modeling using Cross Industry Standard Process (CRISP-DM) for SAS Programming• IBM certified Database Associate with strong hands on experience using SQL queries in RDBMS, improved overall performance of processes by creating new SQL queries includes Joins (Inner Join, Right Join, Left Join, Full Outer Join), Aggregate Functions (Max, Min, Sum, Avg, Count, etc.,), Subqueries, Correlated queries, Triggers, index, Constraints, etc., • Proficient in statistical techniques like ANOVA, T-TEST, Correlations, Cluster analysis, K-means clustering, One-way frequency, Summary statistics and adept in data modeling techniques such as Linear/Logistic Regression• Optimized performance using Data Validation and Data cleansing such as imputing missing values, handling transformations, dummy variable creation. • In-depth knowledge in SAS Procedures such as PROC REG, PROC CORR, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC GLM, PROC MERGE, PROC SORT, PROC TRANSPOSE, PROC IMPORT, PROC EXPORT• Generated reports using PROC REPORT, DATA_NULL_ and PROC TABULATE for customized report writing • Strong experience on Base SAS, SAS/Stat, SAS/Access, SAS/Graphs and SAS/SQL.Technical Expertise:Data Analysis: SAS Enterprise Guide 5.1, SAS Enterprise Miner 12.1, SAS/BASE, SAS/ACCESS, SAS/SQL, SAS 9.3, IBM SPSS Modeler 14.2; Data Visualization: Tableau, JMP Pro 10; Databases: MS Access, Oracle, SQL Server, MySQL, Teradata; Software: Microsoft Office Suite, MS Access, MS project, Advanced Excel - VLOOKUP, Pivot tables; Programming Languages: SAS, SQL, PL-SQL, VBA.
Jpmorgan Chase & Co.
View- Website:
- jpmorganchase.com
- Employees:
- 286575
-
Strategy AssociateJpmorgan Chase & Co. Jul 2017 - PresentWilmington, Delaware
-
Data AnalystUniversity Of Houston Nov 2015 - PresentHouston, 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 -
Data Mining ConsultantCapgemini Feb 2013 - Jul 2014Chennai 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 -
Senior Sql DeveloperCapgemini Apr 2010 - Feb 2013Chennai 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
Varun Prakash Skills
Varun Prakash Education Details
-
3.51
Frequently Asked Questions about Varun Prakash
What company does Varun Prakash work for?
Varun Prakash works for Jpmorgan Chase & Co.
What is Varun Prakash's role at the current company?
Varun Prakash's current role is Strategy Associate at JPMorgan Chase & Co..
What is Varun Prakash's email address?
Varun Prakash's email address is va****@****ase.com
What schools did Varun Prakash attend?
Varun Prakash attended University Of Houston, Anna University.
What skills is Varun Prakash known for?
Varun Prakash has skills like Leadership, Microsoft Excel, Public Speaking, Research, Microsoft Office, Sql, Requirements Analysis, Customer Service, Mysql, Sql Db2, Base Sas Certified, Sas Programming.
Who are Varun Prakash's colleagues?
Varun Prakash's colleagues are Ron Moriarty, Michelle Rachow, Daisy Vasquez, Kayla Stowers, Colleen Adam, Thuy Tran, Lewis Mbua.
Not the Varun Prakash you were looking for?
-
Varun Prakash
Seattle, Wa1amazon.com -
1edg.net -
-
Varun Prakash
Houston, Tx
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial