Graduate / How did you solve a problem and the results? - Texas Austin MSBA Essay [5]

MSBA - MS in Business Analytics

Complete prompt - Imagine that you are in a job interview. The interviewer asks you to describe a time that you have had to solve a problem, and what the results were. How would you answer? (If applicable, please describe the quantitative methods you employed.)

VERSION 1

One of the toughest problems I faced was during a client engagement at Deloitte. Our client, a Fortune 50 software publisher, was losing revenue due to breach of intellectual property. The situation was compounded because of a lack of corporate governance policies in small organizations. We had to create a Software Asset Management program for SMBs in tier-II and tier-III cities in India. Our goal was to achieve $100,000 in revenues per month for the client.

As the project lead, I was responsible for removing bottlenecks in the process. This was a very high volume engagement with 200-250 customers, mostly in inaccessible locations. Fixing meetings each day based on the location set was becoming cumbersome. I employed optimization techniques to allocate resources to meetings. The model involved linear programming to minimize the summation of time-distance product with constraints on the total time available, equations to take into consideration different directions of locations, using projections on x-axis for distances. As a result, we were able to meet meeting targets for over 90% days during the 1-year period. The engagement was ridden with problems such as educating the customer, reducing the project turnaround time, and creating personalized dashboards all of which we were able to resolve.

We met our meeting targets for over 90% days in the 1-year period, delivered $5 million in revenues to our client, reduced project turnaround from 6 weeks to 2 weeks, and most of all educated the customer on the importance of deploying genuine software. Our team received the award for exceeding client expectations by the Partners.

VERSION 2

One of the proudest accomplishments in my life is becoming financially independent and saving INR 1 million by the age of 25 despite facing financial hurdles throughout my childhood. My father was pushed into unemployment a few years back. The financial constraint that subsequently penetrated endowed me with a sense of responsibility and I started investing money at an early age.

I knew with my mathematical skills and foundation in undergraduate courses such as Securities Analysis and Portfolio Management and Statistics, would help me with stock investing. To identify potential opportunities, I first created stock screeners to shortlist companies based on ratios such as Price-Earnings-Growth and Debt-equity, and metrics such as Sales growth, operating profit margins, and dividend yield. Once, I shortlisted companies, I analyzed factors, both financial and managerial, that influence stock prices and did a regression analysis to identify the most important factors. I assigned a stock-score to each company based on the attractiveness of these factors. On the remaining companies, I calculated free cash flows and performed DCF valuation to find the intrinsic value of the stock.

Once I identified an undervalued stock, I looked for the right opportunity to make an investment. I plotted factors like Exponential moving averages (EMA) and Bollinger Bands to model indicators like MACD and Relative Strength Index and predict future stock movement direction.

I have worked 12-hour weekends to create models that work. My portfolio has given a return of 15% CAGR over the last 3 years and I've learned a lot of new techniques over the 3 years. However, I believe analytics would be the differentiator and I want to explore the application of analytical tools in portfolio management.