Champion (IU Squash Team) - 2022 US Squash College Club Nationals Hawthorn Division held at Arlen Specter US Squash Center Philadelphia

• Calculated business valuations of 10 SME companies by the discounted cash flow method to understand the COVID impact. • Analyzed financial results of 5 pharma companies and 4 FMCG companies during the COVID-19 period. • Measured the risk rating of 20 companies in an equity portfolio using financial metrics by collaborating with 2 interns.

• Assisted 40 students in 2 times a week during class in Microsoft Access and Excel topics like data retrieval and pivot tables. • Served as the first point of contact for pre-exam doubts of a group of 6 students in the class.

Lincoln Pharmaceutical is India’s leading healthcare company with a market capitalisation of 3.24 billion INR, based in Ahmedabad. Almost 99% drugs that they themselves manufacture at their own plants is exported, while they outsource manufacturing to local companies and market the products in India as well.• Retrieved data in Excel to prepare 50 large export invoices using data retrieval functions cutting time by almost 40%. • Improved 2 years of sales data using data cleansing and… Show more Lincoln Pharmaceutical is India’s leading healthcare company with a market capitalisation of 3.24 billion INR, based in Ahmedabad. Almost 99% drugs that they themselves manufacture at their own plants is exported, while they outsource manufacturing to local companies and market the products in India as well.• Retrieved data in Excel to prepare 50 large export invoices using data retrieval functions cutting time by almost 40%. • Improved 2 years of sales data using data cleansing and structuring tools in Excel for the Head of Department to analyze. Show less