Data Analytics Intern, Data Science Intern

MANSI SAIN

Boston, MA +1-857-***-**** ****.*@************.*** https://www.linkedin.com/in/mansisain0124281b7/

EDUCATION

Northeastern University Boston, MA Expected May 2024

Master of Science in Data Analytics Engineering

Coursework: Data Management for Analytics, Data Mining, Computation and Visualization, Data Analytics

Ramrao Adik Institute of Technology (RAIT) Mumbai, India June 2022

Bachelor of Engineering in Electronics and Telecommunication

Coursework: Object Oriented Programming, Database Management System, Engineering Mathematics, Computer Communication

TECHNICAL SKILLS

Programming Languages: Python SQL R Java

Database Systems: MySQL MongoDB MS SQL Server

Business Intelligence Tools: Microsoft Power BI Tableau Microsoft Excel Microsoft Office Suite

Framework and Technologies: Pandas NumPy Matplotlib Seaborn Machine Learning - Classification, Regression

PROFESSIONAL EXPERIENCE

Larsen and Toubro Infotech June 2022 – Aug 2022

Graduate Engineer Trainee Mumbai, India

Acquired comprehensive, action-oriented training in SQL, Python, core Java, RDBMS, MS Excel, HTML, CSS

Utilized SQL queries to automate data retrieval and analysis as per business requirements, saving 80 hours of manual work

Employed Microsoft Excel to perform detailed data analysis and develop 15+ financial reports as per business requirements

Completed weekly assessments assigned by trainer to demonstrate proficiency in these technologies

Institute of Electrical and Electronics Engineers June 2021 – Aug 2021

Data Analyst Intern Mumbai, India

Devised and implemented a COVID-19 Center Management System using SQL, MS Excel, and Python

Examined and visualized COVID-19 data of 250 patients, automated tasks, and generated reports

Streamlined management and tracking of COVID-19 cases, enabling efficient decision-making and resource allocation within the center

ACADEMIC PROJECTS

Boston Crime Prediction Python, Microsoft Excel Jan 2023 – Apr 2023

Conducted a Data Mining project using Boston's crime dataset to analyze and predict crime rates in different districts, resulting in accurate crime rate predictions and increased crime prevention strategies.

Preprocessed and cleaned data; visualized data using libraries such as Pandas, NumPy, Matplotlib, Seaborn.

Applied K-means, Random Forest, Decision Tree, Naive Bayes and achieved best classification solution using Random Forest classifier with 85% accuracy and a higher ROC score.

Personal Key Indicators of Herat Disease Visualization Python, Tableau Feb 2023 – Apr 2023

Implemented interactive Tableau dashboards for heart disease prediction and visualization.

Created data visualizations (pie charts, animated bar charts, tree maps) to analyze impact of lifestyle factors, resulting in a 15% reduction in high-risk behaviors and a 60% improvement in overall heart health awareness.

Massachusetts Bay Transport Authority System Python, Microsoft Excel, MySQL Oct 2022 – Dec 2022

Developed a database for Massachusetts Bay Transportation Company, enabling easy access to passenger data for enhanced customer service and increased frequency of essential subway routes.

Designed and translated a Conceptual data model (EER and UML) into a Relational Model for MySQL database implementation.

Facilitated data-driven insights and decision-making by connecting database to Google Colab, resulting in a 30% reduction in operational costs and a 15% increase in efficiency for the Massachusetts Bay Transportation Company.

Migrated database to MongoDB, enhancing functionality and scalability.

LEADERSHIP EXPERIENCE

Indian Society of Technical Education (ISTE), Volunteer Mar 2019 – May 2020

Contact this candidate