Financial Analyst, Economic Researh Intern, Excel, Modeling

KOMAL N. VIRANI

** ****** ****, ******* ** ***** ****@****.*** 682-***-****

EDUCATION Rice University, Houston, TX Graduation: May 2023 (Expected) Bachelor of Arts in Economics, Intended Minor in Data Science, 3.4 CGPA Relevant Coursework: Microeconomic Theory, Macroeconomics, Financial Accounting, Probability and Statistics for Data Science, Single Variable Calculus II

FINANCE/ANALYTICS EXPERIENCE Data and Financial Analyst Intern August 2020- Present Seedstages Inc., Remote

• Conducting industry-specific market research for assumption figures to model the company’s growth rates

• Creating Excel PivotTables and visualizations, using VLOOKUP’s and Macros to clean and analyze datasets

• Building basic financial models for equity valuation to aid investment pitch decks for the startup Treasurer/Executive Board Position August 2020- Present Deeds not Words, Houston, TX

• Managing a double-digit budget to fund and organize activities on campus throughout the semester

• Keeping a record of revenues and expenses in an Excel Spreadsheet, aiding it with visualizations and forecasts Finance Insight Program Trainee January-March 2020 Rice Undergraduate Finance Club, Houston, TX

• Selected from a wide pool of Rice Students to learn about financial instruments and investment methodologies

• Built introductory financial models based on Discounted Cash Flow Analysis and 3-Statement models

• Developed an investment pitch in teams of 3 for a case study cohort Citi Bank Institutional Banking Internship Program Participant June 2020 InsideSherpa, Virtual

• Participated in a ‘mock’ internship and prepared company and industry overviews while for M&A Rationales

• Learned how to perform Discounted Cash Flow Valuations, analyze Portfolios and conduct Risk Assessments SUMMITS/EXTERNSHIPS

• Women in Business Summit Participant September 2020 PNC, Virtual

• Career.edYOU Sophomore Program Participant September 2020-Present JPMorgan Chase & Co., Virtual

• Extern January 2020

Federal Reserve Bank of Dallas, Houston, TX

ADDITIONAL EXPERIENCE Community Bridges Fellow August 2020-Present

Kinder Institute for Urban Research, Houston TX

• Awarded a fellowship to conduct research on socioeconomic development in the Greater Houston Area

• Expected to partner with a community building organization by the end of the year to assist me with my research and provide me with relevant resources

Caller and Ambassador September 2019-August 2020

Rice Annual Fund, Houston, TX

• Initiated phone calls to prospective donors to ask for donations and pledges for the university

• Built rapport and updated alumni on the new events at Rice by serving as a university representative CERTIFICATIONS/AWARDS

• Introduction to Data Analysis Using Excel- Coursera Issued: May 2020

• Global Financial Markets and Instruments-Coursera Issued: June 2020

• Python Programming Essentials- Coursera Issued: June 2020 SKILLS Software: Microsoft Excel, Microsoft Office 365, Power BI, Python, R Languages: English, Urdu, Hindi

Other: Financial Analysis, Market Research, Modeling, Presentations, Communication, DCF, Accounting

Contact this candidate