SQL, Python, R, SAS, Requirement Gathering, Tableau, Data Mining

Akshay Kaul

469-***-****; adc9sq@r.postjobfree.com

www.linkedin.com/in/kaulakshay10

EDUCATION

The University of Texas at Dallas May 2021

M.S. Business Analytics GPA 3.84

Maharshi Dayanand University May 2015

B.Tech. Computer Science Engineering

TECHNICAL SKILLS

Certifications: Microsoft Technological Associate (MTA) in database administration Softwares/Tools: Anaconda, SAS, R Studio, Tableau, MS Excel, Oracle SQL Developer, Microsoft SQL Server, MySQL, SOAP UI Languages: R, SQL, Python

Skillset: Predictive Analytics using Python/R/SAS, SQL Analysis and Extraction, Supervised Machine Learning, Data Visualization, Data Integration/ETL, Requirement Gathering, Software Methodologies (Waterfall/Agile), Functional Specifications BUSINESS EXPERIENCE

Datamation Consultants Pvt. Ltd., Gurugram, India May 2015 – June 2019 System Analyst

• Automated insurance welcome calling on CRM by integrating multiple policy administration databases (Oracle DB’s) with CRM database (SQL Server DB), reducing dedicated team of 4 and 8 manual business reports

• Designed data flow architecture of an insurance collection mobile application designed to administer policy premium collection by agents, which resulted in 24% increase in on-time premium collection by agents

• Provided on demand data related solutions to business problems using Oracle SQL Developer and Microsoft SQL Server, which increased efficiency of business team by reducing their manual intervention in reports

• Automated 11 policy data reports related to insurance renewal process and new business by doing SQL analysis and data extraction resulting in on-time report production, thus reducing IT support team’s work by 15-20%

• Designed and delivered business rules in a Digital Agile App development project using BRMS management system in less than 3/4th of the total time allotted reducing the overall project timeline by at least 20% ACADEMIC/INTERNSHIP PROJECT

University of Texas at Dallas October 2019

• Applied statistical techniques such as Multiple Linear Regression and clustering on AirBnB dataset to predict the price, selected the best-fit model using stepwise regression techniques and assessed the model with numerical metrics and lift charts

• Created a database model on a Fires database in MySQL by reducing a single table into normalized form and forming relationships among normalized tables

• Worked on Cars dataset in SAS and implemented many statistical procedures such as ANOVA, T-Test, Chi-Sq, Regression etc to identify the relationships between categories and understand the statistical significance of variables

• Designed a recommender system on a course-topics dataset to suggest which courses could be purchased with courses such as Regression, Data Mining etc

• Implemented k-means and hierarchical clustering techniques on a cereals dataset to find out which categories are closely associated and also eventually compare these two techniques to figure out the best one in this case

• Created an animation in Tableau representing the effects of global terrorism in different parts of the world Ebix Software India Pvt. Ltd. January 2015 – April 2015

• Created an Android application called Location tracker which could track mobile devices using SMS and ringer

• Implemented concepts of PL/SQL with data modelling by creating stored procedures and ER models COMPETITIONS & ORGANIZATIONS

Ericsson AI Case Competition, UT Dallas - Winner November 2019 Hack Overflow, UT Dallas - Participated in visualization hackathon September 2019 Intelligence Analytics Club, UT Dallas - Member August 2019 – Present Indian Students Association, UT Dallas - Member August 2019 – Present Robotryst-2012 - Participant, reached zonal rounds October 2014 ADDITIONAL INFORMATION

Eligibility: Eligible to work in the U.S. for internships and for full-time employment for up to 36 months without sponsorship

Contact this candidate