Data Analyst

Mihir Sawant

Boston, MA 857-***-**** *************@*****.*** mihirsawant.github.io www.linkedin.com/in/mihir-sawant EDUCATION

Northeastern University, Boston, MA, United States Sept 2018- May 2020 Master of Science in Information Systems

• Relevant Courses: Designing Advanced Data Architectures for Business Intelligence, Data Science Engineering, Data Management and Database Design, Network Structures and Cloud Computing University of Mumbai, Mumbai, MH, India Sept 2013- Jun 2017 Bachelor of Engineering in Electronics Engineering

• Relevant Courses: Structured and Object-Oriented Programming, Modern Information Technology for Management Certifications:

• AWS Certified Cloud Practitioner, Amazon Web Services Training and Certification May 2020

• Tableau Desktop Specialist, Tableau Feb 2020

• Google analytics, Google Analytics Feb 2020

TECHNICAL SKILLS

Languages: Python, SQL, JavaScript, HTML, CSS, C++ Databases: MySQL, MongoDB, Microsoft SQL Server, Oracle, PostgreSQL, Cassandra, Neo4j ML Libraries: NumPy, Pandas, SciPy, Scikit-learn, MatPlotLib, Seaborn ML Algorithms: Regression, KNN, Decision Trees, SVM, Random Forest, Naïve Bayes, GBM Tools: Talend, Alteryx, Tableau, PowerBI, Azure, SSIS, SSRS, SAS, Google Analytics, Github, MS Excel AWS: EC2, RDS, RedShift, Athena, ELB, CloudWatch, CodeDeploy, Lambda, SNS, SES, S3, CloudFormation WORK EXPERIENCE

Data Management and Analytics Intern Velero Technology Wellesley, MA July 2020– Present

• Translated business needs into analytics and reporting requirements to support executive decisions and workflows

• Administered Neo4j database and interpreted and analyzed to gain meaningful insights

• Created ad-hoc reports on frequent basis to assist management in understanding, researching, and analyzing issues

• Translated data results into written reports, tables, graphs, and charts to convey information to management SQL Developer Intern Applab Technologies Mumbai, MH Jun 2017– Sep 2017

• Developed an application for management system to handle data of 500 + students in MySQL server

• Normalized the data to 3NF to eliminate the redundancy to avoid inter dependencies between entities

• Transformed SQL queries, implemented stored procedures and triggers to improve query performance 10% faster

• Extracted, interpreted and analyzed data for progress and evolution of KPI and for market survey

• Presented reports with Tableau for performance analysis which monitors customer satisfaction based on feedback ACADEMIC PROJECTS https://github.com/mihirsawant

Northeastern University, Boston, MA

IMDb Data Warehouse Integration & Visualization (MS SQL, ERStudio, Talend, Tableau) Mar 2020- Apr 2020

• Led consolidation of 5 data systems for movie statistics into snowflake data warehouse using Talend

• Fashioned 27 dimensions and 16 facts merging relational, unstructured and flat-file data structures using ERStudio

• Developed visualizations and dashboards for reporting and to satisfy ad hoc data analysis requests and tracking NYPD accidents and complaints (MS SQL, ERStudio, Alteryx, Power BI, Tableau) Dec 2019- Feb 2020

• Modeled data warehouse with 3NF, developed SQL queries for data extraction and performed data mapping

• Implemented SCD-4, researched inquiries, executed data profiling and solved complex business problems using SQL

• Achieved 17% process efficiency by data cleansing, and integrated data into MSSQL using ETL processes in Alteryx Infrastructure and Web Application (Terraform, AWS, MS Azure, PostgreSQL, Node.js, CircleCI) Sept 2019- Nov 2019

• Built a networking infrastructure in Terraform for a web application and created IAM users, roles and policies

• Administered the data in RDS instance in PostgreSQL, DynamoDB and images in S3 buckets using API calls

• Demonstrated Continuous Delivery and Integration (CI/CD) over auto-scaling group with standard size of 3 instances Movie Recommendation System (Machine Learning, Ensembled Learning, Python) Feb 2019- Apr 2019

• Chaired a team of three to implement a recommendation system for movies and performed statistical analysis

• Engineered features for feature selection and optimized hyper-parameters to gauge the effect of metrics on models

• Evaluated Hybrid Models, K-means clustering, Light FM and compared to acquire accuracy of 90.1% Movie Ticket Management System (MySQL server, Toad Data Modeler) Oct 2018- Dec 2018

• Architected a database using MySQL to hold data for movie ticket bookings, normalized data to 3NF

• Established ER model and implemented stored procedures and triggers to offer 3 reward points to redeem later

• Administered the database to prevent repetitive booking of one seat and offered selective permissions to user

Contact this candidate