XIAOMING (FRED) TIAN
*** * ********** **., ***********, IN 47408
302-***-**** acs33f@r.postjobfree.com
EDUCATION
Kelley School of Business, Indiana University, Bloomington, IN May 2016 Master of Business Administration, Finance and Business Analytics; GMAT: 720 (94th percentile); GPA: 3.73
Strategic Finance Academy, faculty-selected member, with curriculum concentration in asset valuation, treasury management, option pricing, data mining, and financial modeling
Toys R Us Latin American Expansion Strategy Project: researched macroeconomic trends, included selection methodology matrix, entry mode identification components, and financial forecasts
GLOBASE Botswana Program (1/2015-4/2015): collected and analyzed local Botswana client, market and industry data, proposed business development solutions, improving profitability for SMEs Shanghai International Studies University, Shanghai, China July 2003 Bachelor of Law, concentration International Commercial Law
Team Leader, Student Media Task for Asia-Pacific Economic Cooperation (APEC) Summit 2001 EXPERIENCE
Roche Diagnostics Corporation, Diabetes Care, Finance Department, Indianapolis, IN May – July 2015 Business Analytics and Strategic Insights Intern
Analyzed product prices relative to competitors’ by running simulations including a variety of channels, sales drivers, elasticity, and cost baselines, quantifying substantive competitive insights
Developed multi-factor forecasting model to project 5-year lancet sales, refined some predictive analytics and figured out key revenue influencers, improving market shares
Evaluated potential impacts of e-Rx, formulating solutions for changes in revenue management Bank of New York Mellon, Global Markets Division, Shanghai, China May 2012 – July 2014 Senior Trader and Corporate Treasury Manager, Vice President
Managed banking book, developed comprehensive treasury management strategies based on historical data analysis, optimizing capital utilization and improving bank profitability
Monitored liquidity, built cash forecasting models and implemented active cash management strategies, worked closely with London-based International Treasury on liquidity stress test
Oversaw and reasonably utilized foreign debt quota; supervised market fluctuations in FX, interest rates, and commodity, hedged financial market risks by executing spot and derivative transactions
Maintained relationships with banks, signed committing agreement to ensure funding availability
Implemented planned treasury management strategies, collected raw data from daily treasury operations, verified and updated model structures, enhancing accuracy and confidence level
Projected changes in macro-economy and regulatory climate, researched potential business impacts, proposed corresponding actions to senior managers, improving decision-making effectiveness Hang Seng Bank, Treasury Department, Shanghai, China November 2005 – February 2012 Senior Trader
Supervised currency trading team, managed trading talents, established team strategies, structured performance measurement matrix, outperforming peers and winning national trading award in 2007
Executed FX Swaps for funds in foreign currencies, optimizing utilization of extra local cash
Built local exchange rate data base by capturing seasonal changes in price, analyzed data and revealed the correlation between fixing level and central bank intervention, uplifting trading odds
Adjusted currency hedging plans on changes in regulatory requirements, ensuring full compliance ADDITIONAL
Advanced Excel skills, proficiency in quantitative data analysis, Monte Carlo, and regression