URVI MISTRY

adchfr@r.postjobfree.com New York 315-***-**** www.linkedin.com/in/urvimistry

EDUCATION

Syracuse University Masters in Information Management Certificate of Advanced Study in Data Science May 2020 Coursework: Business Analytics, Systems Analysis, Big Data Analytics, Data Warehousing, Cloud Management GPA: 3.89 University of Mumbai Bachelor of Engineering in Information Technology, Secured 8th rank out of 3428 Jul 2018 Coursework: Database Management, Project Management, Data Mining and Business Intelligence, Data Science GPA: 4.0 WORK EXPERIENCE

Data Analyst Intern: PACCAR – Peterbilt Motors Company Jun 2019 – Aug 2019 Business Intelligence: Tableau dashboards creation and Snowflake data warehouse re-engineering

• Developed interactive Tableau dashboards and visualizations for Customer Service team to track customer’s truck performance metrics and make informed decisions to improve customer retention, truck efficiency and service quality

• Re-engineered 65M rows of data stored in Snowflake data warehouse using SQL to ensure data maintainability Development: Automation of MS Excel processes using Python Programming

• Collaborated with key stakeholders to re-design the current system using Jupyter Notebook for process improvement

• Improved process efficiency by automating existing MS Excel processes in Python to reduce 90% of manual effort

• Achieved a goal to reduce process execution time, eliminate chances of human error and improve data scalability TECHNICAL SKILLS

• Data Science: R(dplyr, ggplot, shiny, caret, jsonlite), Python(Pandas, Numpy, Matplotlib, Scikit-Learn), PySpark, Hadoop

• Database: SQL, MS SQL Server, MySQL, T-SQL, SSIS, SSAS, SSRS, Snowflake, NoSQL

• Business Analytics: Tableau, PowerBI, SAS Visual Analytics, Google Analytics, Adobe Analytics, Qlik Sense

• Microsoft Products: MS Office Suite (MS Excel: VLOOKUP, Pivot table, Macros), MS Visio, MS Project, MS Visual Studio

• Tools: Jupyter Notebook, Apache Hadoop, Amazon Web Services (AWS), VMWare, Git, GitHub ACADEMIC PROJECTS

Data Warehouse: FudgeMart Data Warehouse Aug 2019 – Dec 2019

• Designed, architected and created a unified data warehouse for online movie and DVD rental companies using SQL

• Identified functional requirements and slowly changing dimensions to perform detailed level dimensional modelling

• Implemented ETL process using SSIS and deployed multi-dimensional OLAP cubes for more instantaneous analysis

• Rendered analytical reports using SSRS and interactively visualized business requirements using PowerBI dashboards Database Development: Book Tracking Jan 2019 – Apr 2019

• Designed ERD, DFD and UML diagrams using MS Visio for stakeholders to develop SQL database for SU Library

• Created joins between different tables in database by identifying dependencies using referential integrity constraints

• Performed database normalization and executed optimized SQL queries including triggers, functions and indexes

• Designed user interface consisting of forms and reports using MS Access to allow users to interactively use the system Big Data Analytics: Grocery Sales Forecasting Aug 2019 – Dec 2019

• Analyzed large grocery shopping dataset using Python and Apache Spark (PySpark) to predict sales of items by month

• Performed feature engineering, hyperparameter optimization and created data pipelines for programming efficiency

• Compared model performance of Random Forest and Linear Regression prediction models considering RMSE values

• Improved inventory management and retailer sales strategies; Visualized quantitative analysis results using Python Data Analysis and Visualization: Customer Satisfaction Analysis Sep 2018 – Dec 2018

• Identified and visualized KPIs using R programming to generate actionable insights for increasing customer satisfaction

• Performed data preprocessing and data munging techniques on dataset and analyzed data using descriptive statistics

• Executed supervised machine learning algorithms to achieve accuracy of 81% and improve the company’s NPS score

• Created and presented interactive dashboards to identify trends in data using Tableau for informed decision making PUBLICATION

Data Science: Voyageur Jul 2017 – Apr 2018

International Conference on Computing Communication Control and Automation (ICCUBEA 2018), IEEE, 25 April 2019

• Developed a web application to automate travel itinerary generation process based on user inputs and preferences

• Cleaned and processed raw data acquired from APIs and by performing web scraping techniques using Python scripts

• Generated alternative itineraries using Genetic algorithm and provided detailed itinerary for 8 days in 90 seconds

• Conducted surveys to compare application performance and effectiveness from existing applications in the market LEADERSHIP AND VOLUNTEERING

• Active member of Data Science Club and iSchool Graduate Organization (iSGO) at Syracuse University

• Directed 20 people and managed multiple events as the Events Head of the DJ-Computer Society of India (CSI)

Contact this candidate