Esther D. Chen's Email Addresses & Phone Numbers

Investment Banking Analyst @ Food, Consumer & Retail Group From July 2014 to Present (1 year 6 months) Undergraduate Career Service Office Student Assistant @ From August 2013 to November 2013 (4 months) Financial Analyst Intern @ • Completed a 13-week internship focusing on corporate reporting and strategy • Built monthly financial models to integrate four global...

Investment Banking Analyst @ Food, Consumer & Retail Group From July 2014 to Present (1 year 6 months) Undergraduate Career Service Office Student Assistant @ From August 2013 to November 2013 (4 months) Financial Analyst Intern @ • Completed a 13-week internship focusing on corporate reporting and strategy • Built monthly financial models to integrate four global reporting systems and automate recurring close processes • Conducted due diligence and offered recommendations to CEO on North America long steel industry and special bar quality market including competitor analysis, value chain mapping and end market attractiveness • Validated production capacity of 95 North America long steel plants to assist developing five-year CapEx plan • Generated division financial deck for high-level management mid-year review and constructed plant operating report, raw material receipts and consumption report, and checkbook reconciliation on a daily or weekly basis From May 2013 to August 2013 (4 months) Greater Chicago AreaHonors Business Technology Tutor @ • Served as first point of contact for student questions and coached 80+ students with sophisticated data analysis using Microsoft Access and Excel simulation and optimization modeling: @Risk and Solver From March 2011 to May 2013 (2 years 3 months) Bloomington, Indiana AreaMarketing Intern @ • Analyzed two million dollars sales data using Excel to determine the influences of season, region, and product line • Compiled and translated documents for a marketing project including company background, product series, assembly and maintenance manuals of 27 foreign luxury furnishing brands • Led negotiation with management for a 10,000 reusable bags contract with suppliers, resulting in 25% budget savings • Monitored industry news reports on print and social media in order to prevent a bad press release for the company From June 2012 to August 2012 (3 months) Beijing City, ChinaTeaching Assistant for Honors Business Law and Introductory Accounting @ • Collaborated with other two TAs to write business law quizzes and exams, and developed project scenarios • Helped improve grades of struggling students by delivering individualized instruction on introductory accounting From March 2011 to May 2012 (1 year 3 months) Bloomington, Indiana AreaChinese Tutor @ • Selected as one of three out of 30 mentors based on student feedback for an extension of employment • Tutored and improved learning of 16 American students in Chinese grammar, vocabulary, and research essay • Collaborated with Institute staff to prepare picnic and Chinese recreation activities for 80+ faculty and students From March 2011 to August 2011 (6 months) Bloomington, Indiana AreaBachelor of Science in Business, Finance, Economic Consulting, 3.92/4.00 @ Indiana University - Kelley School of Business From 2010 to 2014 Beijing High School Four From 2007 to 2010 Esther D. Chen is skilled in: Adobe Bridge, Digital Photography, Creative Problem Solving, Attention To Detail, Microsoft Office, Microsoft Excel, Leadership, Social Media, Team Leadership, Financial Analysis, Teamwork, Research, Access, Data Analysis, Analysis, PowerPoint, Photoshop, Public Speaking, Event Planning