Resume

 Shivangi Agrawal

EDUCATION
Master of Science in Business Analytics | Northeastern University | Boston, MA                 Sep 2023 - Dec 2024
Relevant Courses: Data Analysis for Business, Data Wrangling, Info Visuals & Dashboards, Data Mining &Machine Learning, Business Info Design, Quality, and Strategy, Operations and Supply Chain Management, Enterprise Growth & Innovation

Bachelor in Information Technology | Medi Caps University | Indore, India                          Sep 2019 - May 2023

TECHNICAL SKILLS
Programming Languages: Python, SQL (DDL, DML, DCL, TCL, DQL), R, JavaScript, HTML, CSS
Database Technologies: MS SQL Server, MySQL, Oracle, PostgreSQL
Visualization & BI Tools: Tableau, Power BI, Alteryx, Excel (V Lookup, Pivot Table, Macros)
Python Libraries: NumPy, Pandas, Scikit-learn, Matplotlib
ML Techniques: Predictive Analytics, Time Series Forecasting, Clustering, Decision-Tree, NLP, LSTM
Productivity Tools: GitHub, Docker, MS Office Suite, Azure, G Analytics, Jupyter Notebook, Jira
Soft Skills: Strategic Thinking, Financial Acumen, Negotiation, Adaptability, Stakeholder Management

PROFESSIONAL EXPERIENCE
Thermo Fisher Scientific | Boston, MA       Business Analyst-Supply Chain Apprentice     Sep 2024 – Dec 2024

• Analysed purchase behavior of 62K+ customers across 5K+ SKUs using Python (EDA), uncovering insights into driving personalized recommendations and cross-selling

• Developed Power BI dashboards & reports to deliver key insights, enabling sponsors with clear, data-driven decisions

• Built a predictive model to forecast future purchases, optimize inventory planning and improve engagement strategies

• Worked with finance & business teams to improve data quality, refine financial models, and enhance retention strategies

Spicy Leaf | Indore, India                                Project Coordinator                                        May 2020 - Aug 2022

• Forecasted demand for health-conscious products using Python & Excel, optimizing supply chain and inventory planning to reduce stockouts and excess inventory. Launched 3 new product lines, leading to an 18% revenue increase

• Conducted 10+ UAT for new products, analyzed customer behavior, and launched promotions to drive adoption & reach

• Integrated Uber Eats for last-mile logistics, reduced operational costs by 15%, improved order fulfillment efficiency

• Built Power BI dashboards and monthly & quarterly financial reports to analyze revenue trends, expense, cost structures, and profit margins to assess financial health and strategic decision-making

• Analyzed pricing strategies with A/B testing, aligned price points with customer demand to maximize sales profitability

PROJECTS
Financial Analysis: Portfolio Performance & Risk Analysis | Excel, Python, Pandas, Numpy

• Analyzed risk-return metrics (Sharpe Ratio, Beta, VaR) to assess portfolio performance across stocks, bonds, and ETFs

• Applied Monte Carlo simulations and historical price data to evaluate volatility trends and forecast potential returns

• Built a dashboard visualizing asset allocation, market trends, and performance insights for investment decisions

Sentiment Analysis on Amazon Product Reviews | Python, NLP, TF-IDF, Logistic Regression 

• Built a predictive model to classify 10k+ Amazon product reviews, tuning unstructured feedback into actionable insights

• Achieved 88% model accuracy by applying TF-IDF vectorization and logistic regression on preprocessed review data

• Validated Predictions using precision, recall, and F1 score to ensure accuracy across both positive and negative reviews

SQL Analysis on Pizza Sales Data | Python, SQL, Power BI, DAX                    

• Analyzed 40K+ records and 15+ features, using sub queries & joins to identify revenue-driving and top-selling products

• Transformed data with DAX queries to develop 2 interactive dashboards for sales and consumer behavior insights

• Defined 4 KPIs to evaluate market trends, driving data-backed promotional strategies and business decisions

LEADERSHIP SKILLS

• Led financial literacy workshops for 200+ small business owners on budgeting, forecasting, and profit optimization

• Led sustainability drives, plantations and thrift donations to reduce waste, reuse resources, and support 500+ children

• Awarded the Community Wellness Leadership Award for organizing yoga workshops during COVID, promoting mental and physical well-being in the community

• Awarded the Event Strategy & Promotion Award for leading sales and operations during E-Summit for 1,000+ attendees