Hello,
I am Somya.

Data science & analytics enthusiast.

I am passionate about exploring data and extracting meaningful insights. With a strong background in management information systems and information technology, I aim to utilize data-driven approaches to solve real-world problems and drive business growth.

Education

University of Illinois at Chicago

Master of Science, Management Information Systems (Aug 2022 - May 2024)

Guru Gobind Singh Indraprastha University

Bachelor of Technology, Information Technology (Aug 2018 - Jun 2022)

Experience

UIC

Graduate Research Assistant

College of Liberal Arts and Sciences, University of Illinois at Chicago

Sept 2022 - Present

  • Streamlined institutional budget data analysis by automating reports using business intelligence techniques (SQL Server, Tableau), saving 20 hours per week in manual reporting work
  • Leveraged institutional ERP system, including SAP Web Intelligence to analyze and report on 64,000 data points course enrollment data, resulting in the identification of a 5% increase in student enrollment.
  • Devised and implemented robust data quality control procedures, including data cleansing, validation checks, and error identification protocols, leading to a remarkable 30% improvement in data accuracy and reliability
Dunzo

Dunzo Digital Private Ltd

Data Analytics Intern

June 2021 - Nov 2021

  • Conducted extensive analysis of large sales and customer order datasets, using SQL queries, Tableau, and Excel to optimize 17 key business metrics, resulting in a ~$100K reduction in citywide refund losses.
  • Investigated low-performing stores by analyzing order fulfillment and customer issues to pinpoint specific performance challenges, leading to a 15% increase in overall store performance and a reduction of 100 customer complaints per month.
  • Collaborated with the operations team to forecast demand, optimize inventory levels, and minimize out of stock situations, reducing inventory costs by 10%.
Sapio

Sapio Analytics

Data Analyst Intern

July 2020 - Sept 2020

  • Utilized Python, Tableau and Excel to analyze 4 years of revenue and expenditure data of 10 unorganized sectors in the Indian economy to automate the annual financial statement for the state of Uttar Pradesh.
  • Analyzed the state level crime data and generated dashboards and reports to identify and highlight crime hot spots to assist the government in law enforcement.

Projects

Project Image

Lending Club Loan Default Prediction

Skills: Python, Data Analysis, Machine Learning

    Through this project, I conducted a comprehensive analysis of extensive loan data, scrutinizing 109,874 data points and analyzing 145 features. Leveraging various advanced ML algorithms, this analysis is crucial for assisting clients in deciding whether to invest in peer-to-peer loans and determining which loans to choose. The goal of using predictive models is to estimate the risk of default associated with each investment option, thus helping clients balance risk and return in their investment portfolio.

Project Link
Project Image

Yelp Reviews Sentiment Analysis

Skills: R, Data Mining

    In this project, I have analyzed 47,000 Yelp restaurant reviews to understand customer sentiments using various advanced machine learning algorithms. This project carries significant importance for restaurant owners seeking to enhance their Yelp ratings and attract more customers. By analyzing the sentiment within these restaurant reviews, it provides actionable guidance for improving customer experiences and making informed decisions to boost their online presence.

Project Link
Project Image

Airlines Performance Analysis

Skills: Data Analysis, Tableau, Performance Analysis

    The In-Flight Performance Analysis project explored United Airlines' 12-month performance using 2.5 million+ Bureau of Transportation Statistics' records. Interactive Tableau dashboards analyzed market share, flight frequency, delays, and reasons. The project identified the top 5 delay reasons, offering actionable recommendations for improvement. Data-driven performance analysis enhances operations and customer satisfaction.

Project Link
Project Image

Twitter Sentiment Analysis

Skills: Data Analysis, Python, Performance Analysis

    The Twitter Sentiment Analysis project understood COVID-19's impact on mental health via 16,000 tweets. It revealed prevailing emotions and sentiments during this period, providing insights into people's well-being and Twitter's collective mood. This project highlighted the importance of understanding public sentiment during crises and gaining meaningful insights from social media data.

Project Link

Contact

Email: somyamaheshwari22@gmail.com

Chicago, Illinois, 60607

Get in touch for any inquiries or collaboration opportunities.

Send an Email