Amrutha Gabbita | Business Analyst

Amrutha Gabbita

Business Analyst

Based in Lafayette

About

I am a graduate student at Purdue University with extensive professional experience in business analytics and financial analysis. I worked for HSBC as CDD Analyst and for Deloitte as a Financial analyst. I am motivated to tackle ambiguous business challenges with strong business acumen and analytical skills. My expertise includes advanced data analysis, predictive modeling, and dynamic visualization, allowing me to offer innovative solutions that enhance operational efficiency and profitability. I am ambitious in leveraging my technical skills to drive data-driven decision-making and strategic insights. You can find my resume, projects, experience, and skills in the respective sections of this website. Feel free to explore my portfolio and contact me for any opportunities or collab

Skills

Projects

Turning Data into Insights: A Comprehensive Sales Analysis for Koch Foods

At Koch Foods, the rapid growth of the company brought with it a flood of data, yet this data often lacked the necessary structure and integration to be truly informative. The sales team faced significant challenges in tracking performance, understanding customer behavior, and making data-driven dec

Maximizing Revenue for Airbnb Properties in Chicago: A Data-Driven Approach

We aimed to optimize revenue for Airbnb hosts in Chicago by analyzing key factors influencing their earnings. The team's approach involved a detailed examination of Airbnb listings, focusing on Superhost status, occupancy rates, revenue, and property specifics over multiple evaluation periods.

Exploring Machine Learning for Bankruptcy Prediction

We set out to identify the most effective machine learning algorithm for predicting firm bankruptcy using SAS Enterprise Miner. We compared various algorithms, including Gradient Boosting, Bagging, and Neural Networks, to determine which model offered the best predictive accuracy.

Analyzing Online Sports Revenue

I delved into product data, pricing, sales, customer reviews, and revenue, to derive actionable insights aimed at boosting company revenue. Leveraging SQL for data manipulation, Python for data analysis and predictive insights, and Tableau for dynamic visual storytelling.

Energy Market Time Series Forecasting

Our project focuses on identifying optimal locations for grid-scale battery installations across New York to boost energy distribution efficiency. This initiative supports our B2B offerings and has potential national security applications by enhancing power generation and storage strategies.

Experience

2024

Business Analyst - Fortune 500 Defense Contractor (Undisclosed)

In my role here, I leveraged Python and Tableau to revolutionize energy market forecasting for the New York energy grid. By employing advanced techniques such as SARIMAX, Neural Networks, and K-Means Clustering, I enhanced forecasting and predictive accuracy through detailed geospatial and time series data analysis. My work involved sophisticated feature engineering to estimate demand, load, and surplus forecasts, ultimately optimizing grid efficiency and consumer pricing. This project showcased my ability to apply cutting-edge analytics to solve complex real-world challenges and drive operational improvements.

2021-2023

Financial Analyst - Deloitte

I excelled in data analysis and financial reporting using MS Excel and SAP S/4 HANA. I was instrumental in determining project rates through meticulous financial analysis, reporting, and reconciliations. My role also involved monitoring existing rates, forecasting new ones, and collaborating with teams to uncover monetary improvement opportunities.

Intern - Analyst - Sunbird Straws

During my internship at Sunbird Straws, I developed MS Excel models for cost analysis, calculating the project breakeven timeline over 12 months across Pan India. This optimized finance and operations planning strategies, enhancing resource allocation and cost management. My analytical approach provided critical insights into project viability and supported strategic decision-making, contributing to overall financial and operational success.

2017-2019

Analyst - HSBC

As a Global Banking and Markets Analyst at HSBC, I conducted meticulous due diligence on over 30 corporate prospects, safeguarding against financial crimes and fortifying the bank's client portfolio integrity. This role highlighted my commitment to maintaining high standards of financial security and compliance.

Education

2023-2024

Purdue University - MS Business Analytics and Information Management

At Purdue University, my coursework provided a comprehensive foundation in business analytics and information management. I gained expertise in Business Analytics using Minitab, @Risk, and MS Excel, and developed proficiency in Visual Analytics with MS Excel and Tableau. My training in IT Project Management involved MS Project and Smartsheets, while Spreadsheet Modeling & Simulation was enhanced with @Risk and SimQuick. In Supply Chain Analytics, I utilized Excel Solver and SimQuick, mastering linear, non-linear, and stochastic programming. Optimization with Spreadsheets furthered my analytical skills using Analytics Solver. The IT Innovation and Advantage course introduced me to prompt engineering and Python, and my Big Data coursework included practical applications with GCP and Python.

2019-2021

Christ University - Master's of Business Administration (MBA)

At Christ University, my coursework provided a robust foundation in management, finance, and analytics. I mastered Statistics for Management with Excel, hypothesis testing, and SPSS, and delved into Management Science using linear programming, Excel Solver, and network diagrams. In Financial Management, I applied Excel for NPV and WACC calculations. Operations Management covered KANBAN, KAIZEN, and transportation methods. I advanced my Excel skills with VLOOKUP, pivot tables, and charts, and studied Enterprise Resource Planning and Business Valuation with a focus on financial modeling. Financial Econometrics with Eviews and Analytics for Finance using R further enhanced my skills. My Project Management coursework emphasized strategic planning and execution.

2014-2017

Bangalore University - Bachelor's in Commerce (B.Com)

At Bangalore University, during my Bachelor's in Commerce (B.Com), I completed comprehensive coursework in various business disciplines. I studied Business Mathematics and Financial Accounting, building a strong numerical foundation. Business Statistics and Statistical Analysis provided me with essential analytical skills. I gained insights into legal frameworks through Corporate Law, and Financial Management equipped me with knowledge of managing corporate finances. Cost Accounting and Management Accounting enhanced my understanding of internal financial processes, while Financial Markets and Services broadened my perspective on financial systems. Additionally, Security Analysis sharpened my skills in evaluating financial securities.