mmaru@simon.rochester.edu
Hello! I'm

Mitali Maru

Business Analysis | Data Visualization | Financial Analysis | Pricing | Strategy | Research

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!

01. ABOUT ME

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.

Profile Image

Skills I'm Proficient With

Here are some of the languages / platforms I work with:

Programming Languages
  • Python (NumPy, Pandas, Matplotlibs)
  • R (Dpylr, Tidyverse, ggplot)
  • Advanced Excel
  • SPSS
  • HTML
Tools
  • Tableau
  • Power BI
  • MySQL | SQL Server
  • Google Analytics
  • MS Suite
  • SEO
  • Google Ads
  • Jupyter Notebook
  • Google Colab
Microsoft Office
  • Regression Analysis
  • Hypothesis Testing | A/B Testing
  • Generative AI | APIs
  • K-means Clustering
  • PCA
  • Decision Trees
  • Pivot Table | Analysis ToolPak
  • Macros and VBA
  • Data Modeling | DAX
  • Probability & Statistics

Certification

  • 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)

02. Where I've Worked

Expand Research - A BCG Company @ New York City, NY, USA

Summer Intern

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.

City Lights of China @ Rochester, NY, USA

Consultant

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.

AHN Consultants Private Limited @ Mumbai India

Loan Syndication Analyst and Project Work Intern

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.

Nuvvagen Nutraceuticals @ Mumbai, India

Management Intern

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. 

03. Education

Simon Business School, University of Rochester Rochester, NY

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

Sarla Anil Modi School of Economics, NMIMS Mumbai, India

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

    

03. Something that I've build

Cobblestone Learning Center Analysis

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

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


Bitcoin Prices & Forecasting

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


Travel Meta (AI-based Travel Kit)

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


Procurement and Spend Analysis

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


HR Analytics Dashboard

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?

Get in Touch

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!