Welcome to my professional space! I'm a passionate data enthusiast, currently interning at BCG Expand Research and pursuing an M.Sc. in Business Analytics at Simon Business School. Join me on my journey as I blend real-world consulting experience with advanced analytics to unlock powerful business insights.
Check Out My Projects!
Hi there!
I'm Mitali, a passionate data enthusiast interning at BCG Expand Research while pursuing an M.Sc. in Business Analytics at Simon Business School. With a Bachelor's in Economics, I've honed skills in econometrics, statistics, public policy, and financial economics, leading me to the world of advanced data analysis. As a Business Analyst, I'm skilled in statistical analysis, data visualization, and predictive modeling using Python, R, SQL, Tableau and Power BI.
I thrive at the intersection of consumer behavior, data analytics, and cutting-edge technologies, aiming to help businesses navigate market complexities with data-driven strategies. Proven in enhancing profitability, optimizing financial returns, and driving growth, my approach combines technical expertise with soft skills like problem-solving, teamwork, and effective communication.
Here, you’ll find a curated showcase of my projects reflecting my dedication to excellence and creativity in business analytics.
Here are some of the languages / platforms I work with:
Certifed Tableau Desktop Specialist by Tableau
R Basics from Harvard Online (EdX)
R Visualization from Harvard Online (EdX)
Business Analytics with Excel: Elementary to Advance (Coursera)
Power BI - Beginner to Advance (Udemy)
Python Development Course by Quastech
SQL for Data Science (Coursera)
Business Intelligence Essentials by IBM (Coursera)
Data Visualization with Tableau Specialization (Coursera)
June 2024 - Present
Conducted in-depth research and analysis on commercial banking for flagship projects, evaluated the OTC derivatives market for total cleared and outstanding volumes, and performed key financial analyses, including RORA and RWA, for major Japanese banks.
Jan 2024 - May 2024
As a member of Simon Vision Consulting, I collaborated with a team of five to deliver pro bono consulting services focused on boosting profitability, maximizing financial returns, and re-strategizing initiatives for enhanced business growth and success.
May 2022 - July 2022
Leading a team to a 12% increase in market penetration, I utilized strategic insights and communication to reduce financial risks by 20%. My implementation of advanced predictive modeling boosted loan approval accuracy by 25%, demonstrating my proficiency in driving success through data-driven decisions.
March 2021 - May 2021
Through detailed SWOT and competitor analysis, I shaped product strategies that boosted market share among target demographics. My leadership in social media strategy on Facebook and Instagram fueled a 24% increase in follower engagement.
STEM M.Sc. in Business Analytics
July 2023 - December 2024
· GPA: 3.6/4
· Merit Scholarship Recipient
· Relevant Coursework: Core Statistics Using R, Predictive & Causal Analytics in R, Data Warehousing & Visualization using SQL and Tableau, Prescriptive Analytics with Python, Python Analytics for R Programmers, Advanced Pricing, AI & Business
· MS Rep for Relations & Outreach in Simon Pricing Club, Simon Women in Business, Simon Volunteers
B.Sc. in Economics
July 2020 - May 2023
· GPA: 3.61/4
· Relevant Coursework: Intermediate Mathematical Economics and Statistics, Econometrics, Game Theory, Financial Modeling
· Developed proficiency in Advanced Excel, SPSS, R, Applied Econometrics, Time Series Analytics, and ARMA Modeling
· Member: Entrepreneurship Cell, Management Interaction Club, Publicity and Marketing Committee in Fests and Art Club
Led a team to evaluate three educational programs at Cobblestone Learning Centers (CLC). Using statistical analyses and tools like Python, R, Tableau, and Excel, we found Program B to be the most effective, with a 62.26-point score improvement. We also implemented a questionnaire for student feedback and deployed an AI chatbot for targeted support, enhancing educational outcomes and providing data-driven insights for improvement.
Python | R | Tbleau | AI Chatbot | Clustering
City Lights of China is a consulting project focused on analyzing the restaurant takeout market, particularly in the American Chinese cuisine sector. We examined the market size, growth projections, and key trends while assessing the competitive landscape and customer feedback. The project aimed to identify strategic opportunities for cost control, marketing, and operational efficiencies. Ultimately, the team provided actionable recommendations for enhancing profitability and market expansion.
Excel | Financial Analysis | Inventory Management
Using advanced econometric techniques like the Box-Jenkins methodology to forecast Bitcoin prices from 2017 to 2022 to identify the most suitable ARIMA model, through rigorous statistical criteria and diagnostic checks.
R | Visualization | Forecasting | Statistics
TravelMeta is an AI-driven travel assistant designed to revolutionize travel planning by providing personalized, seamless experiences. It integrates real-time data and advanced algorithms to offer tailored itineraries, streamline bookings, and ensure user safety with up-to-date health advisories. The platform aims to enhance user satisfaction, reduce planning time, and expand travel accessibility by including real-time updates and a 24/7 support chatbot.
Gen AI | API Integration | Adv Algorithms | Python
Using Power BI for Procurement and Spend Analysis and delivering real-time insights and interactive visualizations. The dashboard displayed key metrics like total purchases, order quantities, and purchasing patterns. It included dynamic filters for allowing stakeholders to drill down into data. The project highlighted top items ordered and supplier purchases, enabling data-driven decisions and cost optimization.
Power BI | Interactive Visuals | Real Time Data
Created an HR Analytics Dashboard using Tableau and SQL, providing insights into employee metrics. The dashboard featured key statistics like employee count, attrition rate, and job satisfaction, along with visualizations of attrition by department, education, age group, and gender. By utilizing SQL for data extraction and Tableau for interactive visualizations, I enabled real-time analysis and informed HR decision-making.
Tableau | SQL | Data Warehousing & Management
05. What's Next?
Hi, I’m currently exploring new opportunities in the Business Analyst field, and my inbox is wide open. Whether you’re interested in a chat, a potential collaboration on a project, have a question, or just to say hi, feel free to reach out. I’ll do my best to get back to you.
Say Hello!