Comprehensive Analysis of Unemployment in America Per US State
This project provided a comprehensive analysis of unemployment trends in the US, offering valuable insights into the factors influencing unemployment rates and helping to identify areas needing attention.
Analyzed the relationship between Super Bowl advertising expenditures and social media buzz for three automotive brands during the 2012 Super Bowl period to aid in launching a new car brand.
Super Bowl Advertising Analysis
Academic Projects
Simulation of Selected Industries for Productivity Improvement
The project aimed to enhance the efficiency of manufacturing plants by employing Tecnomatix Plant Simulation software. We designed digital models of production processes to simulate discrete events, identify bottlenecks, and optimize operations. The primary objective was to present the possibilities of using simulation tools to improve productivity in various industries.
The Unnat Bharat Abhiyan is a central government initiative aimed at leveraging technological advancements for rural development. Our project focused on systematically analyzing survey data from Bhagvati village using SPSS software to identify major challenges and propose technological interventions.
Implementation of Unnat Bharat Abhiyan (UBA) scheme through analysis of survey data of Bhagvati village
Academic Projects
Objective:
Explored a dataset containing mental health data of 82,000+ international students to identify key factors impacting their well-being.SQL Contribution:
Used SQL queries to clean and preprocess large datasets, ensuring accuracy and consistency for analysis.
Queried specific stressor-related attributes such as workload, cultural differences, and social isolation.
Created joins across multiple tables to unify demographic, academic, and mental health attributes.
Generated aggregate statistics like average stress scores per region or program using SQL functions.
Outcome:
Insights from SQL-powered analysis enabled stakeholders to identify critical stressors and propose actionable student wellness strategies.
Analyzing Students' Mental Health
SQL based Projects
Analyzing Students' Mental Health
Objective:
Analyzed debt data collected by The World Bank to identify countries with the highest and lowest debt across various categories.SQL Contribution:
Designed and executed advanced SQL queries to extract relevant debt data by country and debt category.
Applied SQL GROUP BY and HAVING clauses to compute and filter total debt by region, sector, and year.
Utilized window functions to rank countries based on their total and per capita debt levels.
Generated pivoted summary tables showcasing trends in debt accumulation across developing nations.
Outcome:
SQL analysis provided clear comparisons of debt burdens, supporting international financial organizations in allocating aid and resources effectively.
LinkedIn Cold Message Generator
The LinkedIn Cold Message Generator simplifies the process of crafting tailored messages for connecting with prospects on LinkedIn. By answering a few straightforward questions, users can generate personalized outreach messages that resonate with their target audience and align with their connection goals.
Vitepe is a digital payment solution tailored for the Canadian market, similar to PhonePe and Paytm in India. It aims to provide seamless, secure, and efficient financial transactions for users. The project involves collecting and analyzing requirements from the founder and communicating them effectively to the tech team to ensure the successful development and deployment of the application
Digital Payment Solution for Canadian Market
External Projects
Current Research Work
Analysis of US Unemployment Trends in Diverse Labor Markets
The report researches the unemployment trend in the United States of America, considering those states where one industry significantly predominates. The paper discusses how two state economies-one led by technology and the other by agriculture-meet and recover from jobless rate spikes in detail, using the history of trend visualization and what the future may be. This paper seeks to bring to light a number of important divergences in employment dynamics, resilience of sectors, and causes for differential recovery rates. In this way, knowledge of such differences will contribute to informed decisions by policymakers in resource allocation, workforce development, and strategic economic planning that will help soften the blows of future economic downturns.
Contact
Let's connect and discuss how I can help your business thrive.
work@sourabhrodagi.com