Manan Dedhia

Redwood City, CA - ***** adex9h@r.postjobfree.com 315-***-**** linkedin.com/in/manan-dedhia/ github.com/Manandedhia SUMMARY

Data Analyst with experience in interpreting and visualizing insights from raw data to derive successful Business solutions Proficient in data analysis Python, R, SQL, Excel and Tableau, working with large databases and Data/Business analytics EDUCATION

Masters in Information Management, Data Science Syracuse University New York GPA-3.7 Aug 2018 - May 2020 Bachelors in Computer Engineering University of Mumbai India GPA – 3.5 Aug 2014 - May 2018 Relevant Coursework: Big Data & Statistics, Business Analytics, Project Management, Data Warehouse and Mining, Database Management, Data Visualization, Data Structures, Machine Learning, Algorithm Analysis, Cloud Computing, Artificial Intelligence TECHNICAL SKILLS

- Languages: Python, R, SAS, MATLAB, Json, Alteryx

- Database & Cloud: SQL Server, MySQL, PostgreSQL, T- SQL, AWS (Redshift, EMR, S3), Microsoft Azure

- Tools & Frameworks: Tableau, Looker, SSIS, SSAS, MS Excel, MS Power BI, Hive, MapReduce, Hadoop, JIRA

- Libraries: Pandas, Scikit-Learn, Statsmodels, Spark, TensorFlow, Mrjob, NumPy, Matplotlib, Seaborn, Plotly, NLTK PROFESSIONAL EXPERIENCE

Data Analyst Intern Arizona Department of Economic Security June 2019 – Aug 2019

- Preprocessed & analyzed data for an automated system that reduced customer wait time at company’s office using SQL, Python, Tableau

- Modeled and queried relational Database using Stored procedures, unions, materialized views, window functions to structure, remove duplicate and combine the customer arrival information dataset

- Developed data cleaning, wrangling & visualization Python scripts to identify correlation and patterns in customer visit hours, customer details, benefit plans, and claim approvals

- Designed interactive Tableau dashboards to track customer waiting time KPI for making data-driven decisions that reduced waiting time for a customer by 20%

- Performed complex SQL query tuning to reduce ETL time by 10% for the organization’s employment database Graduate Teaching Assistant Data Analysis and Database Management Syracuse University Aug 2019 – May 2020

- Designed coursework, labs and graded assignments based on NumPy, Pandas, Scikit-learn libraries in Python for Data analysis class and SQL concepts for the Database management class

- Mentored students in writing Python scripts for preprocessing, analyzing, classification and regression algorithms

- Taught core relational database modeling, normalization, forms concepts and implemented SQL Joins, triggers, views using MS Access and SQL server in Teaching Assistant demo sessions Data Scientist NEXIS Research Lab Syracuse University Aug 2019 – May 2020

- Analyzed data to identify trends and patterns in NY Airbnb house prices based on location, reviews, and availability factors

- Programmed Linear regression and Decision tree model in Python to predict New York Airbnb house prices with 85% accuracy Business Analyst Intern Sunshine Enterprise June 2017 - May 2018

- Collaborated with cross-functional agile scrum teams to deliver new functionalities for an on-demand-doctor app ‘Feel Better’

- Detailed out acceptance criteria for user stories & created business workflow documents for features in JIRA

- Modeled and developed a relational database for the application using MySQL, MS Access and performed UAT, A/B testing

- Created dynamic reports and charts using Tableau to get business insights which increased the application’s efficiency by 30% PROJECTS

Patient Readmittance analysis Sept 2019 – Nov 2019

- Carried out exploratory Data Analysis to identify patterns for patient readmittance using Pandas, NumPy, and MapReduce libraries

- Implemented Logistic regression, Random forest classifier techniques to classify whether a patient will be readmitted based on medicine, diagnosis, and other features in Apache PySpark.

- Evaluated the pipeline model using ROC area under curve and confusion matrix resulting 0.66 AUC Data Warehouse Jan 2020 – March 2020

- Modeled and Implemented Data Warehouse for food marts and movie rental service with ETL pipelines using MS SSIS

- Designed SSAS MOLAP cube to generate insights in a data warehouse using MS Power BI Dashboards Parking Management System Jan 2019 – March 2019

- Administered an automated system which efficiently allocates parking slot to users using advanced SQL features like triggers

- Developed a relational database for the system and complex queries in SQL Server to extract and manipulate data using filters, joins LEADERSHIP AND EXTRACURRICULAR

- Communication Head at Worldwide Innovation Technology club (WiTec): Headed club meetings, seminars, and hackathons

Contact this candidate