Aayushi Agarwal

Experience

• 

  HFCL Limited

  May 2019 - Jun 2019

  Intern

  - Assisted in preparation of financial reports - Streamlined financial reports by finding gaps - Observed and summarised meetings for further action

• 

  Tata Strategic Management Group

  May 2020 - Aug 2020

  Analyst

  - Collected data for digital payments in India and performed regression analysis using SPSS software for market analysis- Performed competitor research in field of online payment getaways and found major key factors affecting the same- Analysed and reported daily steel output for a month (30 reports) and prepared monthly and quarterly reports with analysis, helping the organisation to increase month-end output by 2%- Identified key gaps in the production process and provided solutions to increase efficiency- Analysed TATA insurance data with over 500,000 data points and created pivot tables to answer over 20 critical questions- Researched trends in production of Railway cabins for India by gathering data from tedious government sites Show less

• 

  HobbyStation

  Sept 2021 - Mar 2022

  Entrepreneur In Residence Intern

  - Aided the founder on various business functions like operations, recruitment, marketing, finance and product development- Created, drafted and implemented social media strategy, growing social media activity by 20%- Managed a team of 5 people across divisions like marketing, HR and operations- Coordinated with other team members to organise a promotional event and achieved 10% rise in memberships- Handled the workforce of the organization. Hired 30% employees for various roles to be filled in the organisation- Conducted analysis of business performance using a number of metrics and researched the gaps- Budgeted monthly expenses, product pricing and sales; improved overall sales by 10% by use of effective budgeting- Collaborated with the founder to research ways to raise funds for expansion Show less

• 

  Serturner

  Mar 2022 - May 2022

  Finance Intern

  - Recorded over 100 accounting entries using ZOHO Books displaying attention to detail- Calculated 5 financial ratios such as profit margin, debt-eqity etc for analysis of company performance- Developed over 3 analytical reports using ZOHO analytics and solved over 6 financial questions- Prepared financial model for the company and calculated future cashflows, profit and balance sheet for purpose of raising funds- Communicated with clients and suppliers to gain information and solved financial queries Show less