SAHIL GUPTA
*** **** **** ****** • New York, NY *0028 • acf0s5@r.postjobfree.com• 347-***-****
EDUCATION:
RUTGERS UNIVERSITY New Jersey
Rutgers Business School
Master of Finance, Major: Quantitative Finance, December 2013 GPA: 3.44
Selected Courses: Investment Analysis and Management, Investment Banking: Valuations and Corporate Finance, Financial
Statement Analysis and Portfolio Theory.
VISVESWARAYA TECHNOLOGICAL UNIVERSITY Bangalore, India
PES Institute of Engineering
Bachelor of Engineering in Electronics and Communication May 2012
Academic Excellence Award for December 2011 and May 2012
BIWS Investment Banking Financial Modelling Training Program
Received Certification after scoring above 90% in an online modelling test
WORK EXPERIENCE & LEADERSHIP SKILLS:
ARGUS INFORMATION & ADVISORY SERVICES White Plains, NY
Consulting Analyst, Client Services & Financial Modelling Feb 2014-Present
Analyzed the Shopper Migration trends for a top 5 retailer and identified lost opportunity of $3billion and average
uncaptured opportunity per year of $150 billion over a three year time period.
Provided insights into the prevailing consumer retail market trends through due diligence, financial analysis and
benchmarking the selected group of comparable competitors
Analyzed the E-commerce strategy of a top 10 retailer and provided insights into the average increase in revenue of
$5 million per month.
Analyzed the business development and acquisition strategy of one of the top 5 retailer and identified in cremental
revenue of $3 million from the targeted cohorts.
Streamlined the analysis process of multiple projects that reduced the timeline by 30% and increased revenue by 20%.
BARCLAYS BANK Wilmington, DE
Summer Analyst, Strategic Analytics Department Summer 2013
Built an NPV model for a product upgrade campaign that generated $3.1 MM annual PBT.
Developed a customer engagement segmentation model for existing card members to optimize targeting criteria for
marketing campaigns.
Automated the performance tracking report for product trade using SAS 9.2 (100K accounts)
Conducted statistical and profitability analysis in order to identify the most profita ble segments of the cobranded
credit card portfolio($20B in receivables)
INVESTMENT BANKING CASE COMPETITION New Jersey
Group Leader, Rutgers Business School Fall 2013
Valuation and Analysis of strategic Acquisition of William Carter Co. (Retail Apparel Business) by Berkshire
Partners (Boston Based Private Equity Firm).
Lead a four member team to complete the M&A report, consisting of th e company and industry research, acquirer’s
strategy and synergy analysis, financial statement analysis and evaluation of target’s financials.
Valued the deal using comparable company analysis, DCF and LBO analysis(bid range of $412mm to $480 mm)
Received the ‘Best Valuation and Analysis Award’ amongst 15 other participating teams.
QUANTITATIVE FINANCE STUDENT ASSOCIATION New Jersey
President, Rutgers Business School Aug 2013-Present
Organized panel discussions comprising of distinguished alumni and other professionals targeting specific industries
and current market trends
Managed the organization’s funds for year around activities such as communication and presentation skills workshop
Laid foundation for the annual MQF career fair and assisted in organizing the Quant Summit at NYSE.
ADDITIONAL:
Advanced Proficiency in Microsoft Office, SQL, C, C++, MATLAB and Bloomberg and experience with SAS, STATA
Volunteer, NGO “YUVA BENGALURU”, independently supported education and one meal per day of two children for
two consecutive years.
Hobbies: Boxing and Mixed Martial Arts.