RITESH DHAKAD

Syracuse, NY - ac8sfm@r.postjobfree.com - 315-***-**** - https://www.linkedin.com/in/ritesh-dhakad/

EDUCATION

M.S. in Information Management, Syracuse University, NY GPA: 3.9

May 2019

Certificate of Advanced Study (CAS) in Data Science

Relevant coursework: Big Data Analytics, Applied Data Science, Natural Language Processing, Data Warehouse, Database Management, Business Analytics, Information Systems Analysis, Project Management, Risk Management, Information Policy

B.E. in Electrical & Electronics, Rajiv Gandhi Proudyogiki Vishwavidyalaya, Madhya Pradesh, India GPA: 3.8

Jun 2016

Relevant coursework: Advanced Mathematics & Statistics, Basic Computer Engineering, The Internet of Things

TECHNICAL SKILLS

Programming Languages : Python, R, PL/SQL, T-SQL, C, C++, Java, HTML, CSS, VBA

Database Technologies : Microsoft Visio, Microsoft Access, Microsoft SQL Server, SQL Server Management Studio, MySQL, NoSQL, PostgreSQL, Alteryx, SAP HANA, QSEE SuperLite

Data Visualization Tools : Tableau, Power BI, SAS Visual Analytics, SAP BO, QlikView, Google Data Studio

Web Analytics : Google Analytics, Adobe Analytics

Software Applications : Apache Hadoop, Apache Spark, MATLAB, AutoCAD, SAP ERP, Advanced Microsoft Excel, Microsoft Project, Microsoft SharePoint, Microsoft Office, Jupyter Notebook, Django, Pymakr, Prezi

PROFESSIONAL EXPERIENCE

Data Analyst Intern, National Grid, Syracuse, NY (Python, VBA, Alteryx, MySQL, Tableau, Excel)

May 2018 - Dec 2018

* Pioneered an Automated Exceptions Handling and Scheduling tool in Excel using VBA codes reducing manual effort by 95%

* Proposed Predictive models in Tableau, Multiple Regression in Excel to forecast next 2-years job count with 80% accuracy

* Performed data extraction and cleansing using MySQL and Alteryx, generated python codes to automate Statistical Reports

* Designed live interactive dashboards in Tableau and Excel for stakeholders which enhanced the user experience by 70%

Database Developer, iConsult (Non-Profit Organization), Syracuse University, NY (Excel, Visio, Access, SQL)

Jan 2018 - Apr 2018

* Delved Healthcare concepts to create a database system resulted in avoiding manual managing of humongous data in Excel

* Drafted an ERP Project Charter to implement client’s requirement, and data migration solutions design to enhance CRM

* Imported Excel data, generated Queries, Functions, Procedures, Triggers in SQL, and User Interface, Forms, Reports in Access

* Built a multi-user database saving 3 hours daily by importing and retrieving records quickly also reducing 90% human efforts

Graduate Research Assistant, Syracuse University, NY (Internet of Things, Python, SQL)

Jan 2018 - Apr 2018

* Innovated an IoT System to extract and analyse data from sensors, increasing security and tracking efficiency by 70%

* Automated data collection feature (OLTP) in SQL Server reducing processing time by 60%, also improving data access by 40%

* Executed System Testing for Quality Assurance using python codes and performed Data Mining to generate new information

Data Visualization Intern, GAIL (INDIA) LIMITED, India (SAP ERP, SAP BW, SAP HANA, SAP BO)

Jun 2015 - Aug 2015

* Gathered requirements and troubleshot the Technical Issues of GAIL in order to gain experience of SAP BW and SAP HANA

* Provided Tags to equipment using SAP GUI for ERP and tracked Salesforce Key Performance Indicators (KPIs) to view sales

* Coordinated with Cross-Functional Production, Inventory, and Testing department to generate Financial Report using SAP BO

* Strengthened Vendor-Supplier Relationship and communication among leaders reducing weekly monitoring time by 25 hrs

ACADEMIC PROJECTS

Predicting Readmission of Diabetic Patients (Logistic Regression, Random Forest, Neural Network)

Aug 2018 - Dec 2018

* Incorporated Supervised Machine Learning on Big Data using PySpark to predict readmission of patients with 86% recall rate

* Executed Feature Engineering on Nominal and Ordinal Attributes to detect Correlation among numerical and target variable

* Built k-means algorithm to create categorical classification, achieved 72% prediction accuracy using Gradient boosting model

Consultant, Hyatt Hotel (R Programming Language, Text Mining, Decision Tree, Naive Bayes)

Feb 2018 - Apr 2018

* Ameliorated NPS by 70% by converting Passive and Detractor respondents into Promoters through the Predictive model

* Developed Word Cloud which determined 90% key factors affecting NPS, performed Exploratory Data Analysis by graphs

* Created SVM, Associative Rule Mining algorithm to perform machine learning to extract useful data and form Regression

Business Analyst for Recruiting Strategy Development, Syracuse University, NY (Microsoft Excel)

Feb 2018 - Apr 2018

* Performed Retrospective, Descriptive Analysis to recruit best students by GMAT scores with optimised budget for 2018-19

* Quantified Marketing Funnel using Correlation and Regression, determined the trends by Pivot Tables, Power View, 3D Maps

* Accomplished Predictive, Prescriptive, Sensitivity Analysis by VLOOKUP, Power Pivot, Solver, Pivot chart, Graphs, Sparkline

ata Warehouse Architect, Fudgemart, Syracuse University, NY (ETL, SSIS, SSAS, SSRS, Excel)

Feb 2018 - Apr 2018

* Interviewed clients to gather Business Requirements to design Fudgemart Data Warehouse (a Commodity-Trading platform)

* Improved data consistency by 47% by using SSIS, SSAS, and SQL to translate the functional data into technical solutions

* Systematized extensive test cases, executed them by the Agile Scrum Methodology to generate Business Intelligence reports

Database System for Columbus Deli & Grocery Store, Syracuse, NY (Microsoft Visio, Access, SQL)

Sep 2017 - Nov 2017

* Created a centralized database application integrated from multiple sources reducing data redundancy by 30%

* Designed UML Diagrams and ERD in Microsoft Visio and a normalized database in SQL to simplify managing system by 80%

* Delivered UI/UX Designs, Forms and Reports in Microsoft Access which enhanced customer interaction by 60%

LEADERSHIP EXPERIENCE

Event Manager, Nanhi Kali (Non-Profit Student Organization), Syracuse University, NY

Sep 2017 - Present

* Providing Primary Education to underprivileged girls in India by creating awareness and raising funds through events

* Conducted Social and Cultural events on campus, managed 80 volunteers and raised funds of $500 in a year

Contact this candidate