Associate Analyst
United Airlines
Total years of experience :0 years, 0 Months
o Part of multiple verticals including Market Analysis, Network Planning, Tech & Digital, Airport Operations, Catering,
Corporate Real Estate, Resource Planning & Marketing and have juggled between various projects
o Built a comprehensive model for financial health analysis, valuation and forecasting for 3 Partner Airlines to review their
business model and feasibility of a management or overall takeover
o Developed and modelled an analytics dashboard for Variance Analysis and racking expenses of the overall India office
o Created a Network Planning Dashboard to determine the profitability and feasibility of existing routes worldwide and
the implications of addition or removal of a route. Also made a dashboard for all the Airport Managers in 300+ United
airports to understand customer compensatory payouts and their causes and leading drivers
o Self-taught VBA to automate manual processes in the organization which would otherwise take up several hours of
manual labor. Automated over 15 processes saving 100+ hours of manual labor including 8 monthly models and reports
o Successfully took over the Close & Forecast Process for Airports in the Pacific region with a monthly budget of $100M+
and automated an Emailing procedure effectively reducing monthly runtime from 10 hours to 5 minutes
o Conducted a cost & benefit analysis on a vendor contract regarding the best Telecom contractor for United Airlines.
o Developed a benefit analysis model for a new line of snack offering on the United flights and assisted in creating a model
to determine the baggage revenue for the next 2 years. Used SQL and Excel extensively to structure and transform data
that was used in the same projects
o Studied competitors’ financial statements and annual reports for quarterly competitor analysis and to maintain a
companywide used data cube
o Worked on various other ad-hoc projects including Cost saving initiatives that saved over $50M and macro debugging
Family Services, responsible to develop and improve services of the same
o Received child neglect, sexual abuse and physical abuse complaints and worked to identify children in need
o Conducted investigations through home visits and personal interviews and initiated legal proceedings for the affected
ones
o Conducted a market research on piracy of books by the students of University of Delhi
o Calculated the loss of revenue caused to the publishers along with a report containing the list of all pirated books with
their rates
Investment Analysis) o Graduated summa cum laude. Projects- Valuation of the Energy Sector in India, Effect of INR and Crude Oil on Nifty50 o Director and Actor in the College Dramatics Society with over 30+ performances Pan India. Worked on a play for Spanish Embassy’s Instituto Cervantes. Member of the College Marketing Society and part of marketing team for various startups
IPU Entrance AIR 3, DU-JAT AIR 46, International Commerce Olympiad Rank rank 42