VARUN RAJ VAVILALA

adkhd6@r.postjobfree.com Boston-MA 571-***-**** linkedin.com/in/varun-raj-101150156 EDUCATION

Northeastern University, Boston, Massachusetts, United States May 2021 Master of Science in Data Analytics Engineering

Relevant Coursework: Data Management and Database Design, Data Mining in Engineering, Computation and Visualization, Statistical Methods in Engineering, Collecting Storing and Retrieving Data Jawaharlal Nehru Technological University, Hyderabad, Telangana, India May 2018 Bachelor of Technology in Mechanical Engineering

Relevant Coursework: Probability and Statistics, Managerial Economics and Financial Analysis, Operations Research SKILLS & CERTIFICATIONS

Certifications: Tableau Desktop Specialist(Tableau), Time series analysis in Python(Data camp) Core Competencies: Machine Learning, Data Visualization, Statistical Programming, Data Warehousing, Critical Thinking Programming: Python, R, C

Analysis Tools: Tableau Desktop, Power-BI, Einstein Analytics, XSV, MySQL, SAS Microsoft Office Suite: MS Word, MS Excel (Pivot tables, VBA), MS PowerPoint Databases: MS SQL Server, Mongo DB, Oracle

Data Integration Tools: Talend, SSIS, SSRS, SSAS, Visual Studio, Alteryx Other Tools: Hadoop, Spark, Pig, Tableau, Power BI, Microsoft Azure, Google Cloud Platform, Google Analytics PROFESSIONAL EXPERIENCE

Ismile Technologies, Bolingbrook, Illinois, United States Sep 2020-Dec 2020 Data Scientist Intern

• Developed an expenditure prediction model on the customers credit card data containing 130 features in an Agile development environment using Python

• Utilized XGBoost to build a Random Forest model to fit the data, applied SHAP to interpret the model to make sure that the model was performing as expected and deployed the model on Google Cloud Platform

• Built a Hybrid Recommender System using Collaborative and Content based filtering on movie lens 25m dataset and deployed the model using Flask on a website

• Predicted Customer Lifetime Value of customers in an Online Retail dataset by creating a BG NBD model and the Gamma-Gamma model

Mavericks, Hyderabad, Telangana, India May 2018-Dec 2018 Business Analyst

• Analyzed financial data to gain insights from sales and revenue using R to reduce operating expenses by 13%

• Generated interactive Dashboards, ad-hoc reports using Tableau and forecasted the revenue for subsequent months

• Negotiated and convinced all the stake holders to finalize deals and expanded the reach of the company by 200%

• Successfully worked in a team to design and implement a new business model by developing a new service to enhance the revenue of the company by 50%

ACADEMIC PROJECTS

Crypto Myth, Northeastern University Jan 2021-Feb 2021

• Formulated correlation between most valuable crypto currencies, commodities, companies and stock market indices to understand the fluctuation in prices of crypto currency

• Extracted data from various sources and joined them into required dataset for Machine Learning using PySpark

• Achieved accuracy of 88% using Decision Trees and documented the relation between the variables Design and Analysis of University Facilities Database, Northeastern University Mar 2020-May 2020

• Managed a team of 4 to design and implement a database that would maintain data pertaining to the on-campus facilities

• Collected data records from approximately 1000 students, Normalized data and analyzed it using SQL optimized queries

• Created dashboard on Tableau for Management and provided key insights that 82% students are content about overall facilities but asked for improvement in food-courts, transportation and university health services Prediction of Housing Prices in King’s County-Washington, Northeastern University Jan 2020-Apr 2020

• Examined data, reduced dimensions by performing PCA for feature engineering and eliminated outliers

• Constructed a Predictive Analytical Model using Multiple Linear Regression algorithm with MLlib and verified it using confusion matrix with an accuracy of 94%

Visualization of Farmer’s market Production Program, Northeastern University Sep 2019-Dec 2019

• Analyzed and Wrangled data pertaining to 10000+ farmers in the United States collected by USDA using RStudio

• Utilized Tableau to create visualizations (Heat map, Tree chart, Line chart), dashboards and concluded that 45% grants are issued to states in South and Mid-West regions whereas California receives most grants among states LEADERSHIP EXPERIENCE

• Supervisor-Residential Security Office, Northeastern University Sep 2019-Present

• Global Student Mentor-Office of Global Services, Northeastern University. Aug 2019-May 2020

Contact this candidate