JAY RANGARAM
Grapevine, TX (***) *** – ****
*********@*******.***
http://www.linkedin.com/in/jayrangaram
Summary Financial planning & analysis (FP&A) professional
Skills Short and long-term planning; Budget allocation, forecasting, variance analysis and transfer pricing;
Valuation and due diligence for public equity and alternative asset classes; Reporting financial and
operational information for internal and external stakeholders
Financial and search software proficiencies SAP, Hyperion, Hyperion Essbase, LexisNexis, CapitalIQ, MS Excel
Experience
Bickel & Brewer, GP Dallas, TX 2008-2010
A 50-professional boutique law firm, with offices in Dallas and NYC, specializing in complex corporate litigation
Consultant – financial and accounting analysis
Created a model to assess a $1 billion hedge fund’s alternative assets and to evaluate and ultimately decline
external offers for the fund’s portfolio and performed a market to book analysis of the fund’s real and financial
assets resulting in average write-downs of 30%
Performed due diligence work on hospitality and media operating companies targeted as potential mergers and
acquisitions by the firm's managing partner’s interests and outside investment groups
Analyzed a bankrupt insurance company, reviewing the Debtor’s Monthly Operating Reports filed with the US
Trustee, pre- and post-petition financial position and management actions and competitors
Prepared $2.5 billion in claims against the Madoff funds for investors seeking relief from the U.S. Trustee
Developed a revenue model incorporating lost and foregone revenue streams of a failed business
American Airlines Ft. Worth, TX 2006-2008
A $20 billion global air transportation company
Sr. Financial Analyst
Served as Controller for American’s Finance and Planning division, funded with $780 million of annual
spend, responsible for planning, short-term forecast, variance analysis and cost reduction initiatives
Created operating revenue analysis in support of American’s quarterly Earnings Call and monthly earnings
guidance, integrating data from Finance, Capacity Planning, Sales and Marketing
Analyzed initial business case and drafted CEO correspondence regarding a potential $100 million business
combination of domestic and international air ticket information sources
Used Hyperion Essbase to analyze flight network profitability system-wide and by data segment
United States Army USA/ Kuwait/ Iraq/ Germany/ Kosovo 1998-2004
The world’s premier war fighting and nation building force
Commissioned Officer, Captain, US Army Engineers
Directed over 150 infrastructure assessments of public facilities and oversaw the transport ation and destruction of
over 250 tons of weapons and munitions and the removal of over 4000 tons of debris in Baghdad & Falluja, Iraq
Administered security and nation-building operations for two communities spread over 25 kilometers with over
5,000 residents; adjudicated disputes between Serbs and Albanians
Education University of Texas at Austin, McCombs School of Business May 2006
Master of Business Administration - Concentration in Finance
United States Military Academy at West Point, NY May 1998
Bachelor of Science in Environmental Engineering