Summary
Overview
Work History
Education
Skills
Extra Curricular Activities
Awards
Academic Projects
Timeline
Generic
Ishrat Kaur

Ishrat Kaur

Ludhiana

Summary

Highly motivated and well-organized management graduate, skilled in financial modeling and data analysis. Proficient in excel, with strong management and decision-making skills. Demonstrates ability to lead and work with teams. Emphasizes the need for lifelong learning, recognizing the industry is constantly evolving, and approaches challenges with a creative mindset.

Overview

2
2
years of professional experience
4
4
years of post-secondary education

Work History

Financial Analyst Intern

DistrictD
03.2023 - 06.2023
  • Worked as a Financial Analyst, developed and enhanced Excel financial models, managed quarterly updates, projections and formulated operational metrics for a varied portfolio of 150+ companies like café coffee day, Mahindra Holidays and resorts etc., emphasizing accuracy
  • Conducted comprehensive Secondary research, analyzed data from various sources such as conference calls, investors presentations, quarterly results and segment results. Monitored and tracked the ongoing performance and evaluated the impact of variables on the business dynamics

Audit & Tax Intern

S.P. S & Co.
09.2021 - 05.2022
  • Collaborated with the tax team to file 30+ ITR and 50+ TDS returns using software, also worked alongside the audit team ensuring compliance
  • Utilized tax-related software such as Spectrum to prepare and process returns.

Education

PGDM - Finance

SOIL School of Business Design, Manesar Gurgaon
03.2024

B. Com - Commerce & Management

Sri Aurobindo College of Commerce & Management, Ludhiana, Panjab University
07.2018 - 08.2021

12th -

Sacred Heart Convent School, Ludhiana, Punjab
03.2017 - 03.2018

10th -

Sacred Heart Convent School, Ludhiana, Punjab
01.2016

Skills

  • Financial Modeling
  • PowerPoint
  • Tableau
  • SQL
  • Collaborative
  • Solution oriented
  • Analytical skills
  • Effective communication

Extra Curricular Activities

  • Assisted Fateh Parivar Sewa Society, an NGO, in the distribution of essential supplies to those in need & supported initiatives like organizing blood donation campaigns
  • An active member of Finance club at Soil School of Business Design, responsible for executing finance related events
  • Served as the Associate Student Editor in the magazine committee at Soil School of Business Design, overseeing the design and content creation and responsible for bridging the gap between all stakeholders

Awards

Received Award of Excellence for attaining 95.4% in the 12th grade examinations by Sacred Heart Convent School in Ludhiana, Punjab


Academic Projects

  • Evaluated 5 FMCG firms' cost of capital using financial records and Excel to determine which had the lowest cost and what are the implications of the same on business dynamics
  • Used the discounted cash flow method to assess the value of Jubilant Food Works, involving revenue projections and determining the terminal value
  • Applied time series forecasting techniques, specifically ARIMA and Prophet, in an effort to forecast the exchange rate between the Australian dollar and the United States dollar
  • Developed a Cloud adoption framework for small and medium-sized enterprises to undergo digital transformation, transitioning from traditional IT setups to cloud-based systems
  • Conducted a survey to know the Impact of Social Media Marketing on Purchase Decision in quick service restaurants industry, utilizing statistical techniques like Cronbach's alpha, to understand and cater to business needs and problems



Timeline

Financial Analyst Intern

DistrictD
03.2023 - 06.2023

Audit & Tax Intern

S.P. S & Co.
09.2021 - 05.2022

B. Com - Commerce & Management

Sri Aurobindo College of Commerce & Management, Ludhiana, Panjab University
07.2018 - 08.2021

12th -

Sacred Heart Convent School, Ludhiana, Punjab
03.2017 - 03.2018

PGDM - Finance

SOIL School of Business Design, Manesar Gurgaon

10th -

Sacred Heart Convent School, Ludhiana, Punjab
Ishrat Kaur