International Peer-Reviewed JournalOpen AccessISSN 2456-8880
irejournals@gmail.com+91-7433024337

Home / Current Issue / Paper 1713872

1713872 Vol 9 · Issue 7 Download Paper

Optimizing Finance Operations Through Data Analysis

Sujoy Das Pushkar Parulekar

Subject area: Management and Commerce  ·  Area of research: Data-Driven Financial Management

DOI: https://doi.org/10.64388/IREV9I7-1713872

Abstract

This report presents an overview of the summer internship in the finance domain, focusing on financial reporting, data analysis, and automation. The internship aimed to support the finance team in improving operational efficiency, data accuracy, and decision-making through structured reporting and analytical tools. Key contributions included the automation of investor reports using Power BI, support in a state sales tax study, and analysis of revenue and publisher cost concentration at both overall and business unit levels. The work also involved average collection and payment period analysis and evaluation of revenue receipt trends to derive insights into working capital management and financial planning. Throughout the internship, accurate documentation was maintained, collaboration with cross-functional teams was ensured, and reporting standards and timelines were strictly followed. This experience strengthened financial analysis capabilities, enhanced proficiency in Excel and Power BI, and provided practical exposure to corporate finance and data-driven decision-making.

References

[1] Bragg, S. (2022). Financial analysis: A business decision guide (pp. 1–412). Accounting Tools, Inc.https://www.accountingtools.com/articles/financial-analysis.html

[2] Wild, J. J., Subramanyam, K. R., & Halsey, R. F. (2020). Financial statement analysis (12th ed., pp. 1–720). McGraw-Hill Education.https://www.mheducation.com

[3] Gallo, A. (2017, April). A refresher on return on assets and return on equity. Harvard Business Review.https://hbr.org/2017/04/a-refresher-on-return-on-assets-and-return-on-equity

[4] Damodaran, A. (2012). Investment valuation: Tools and techniques for determining the value of any asset (3rd ed., pp. 1–992). Wiley Finance.https://pages.stern.nyu.edu/~adamodar/

[5] IBM. (n.d.). Power BI vs. Excel: Choosing the right analytics tool.https://www.ibm.com

[6] CFA Institute. (2023). Corporate finance and financial reporting standards.https://www.cfainstitute.org

[7] PwC. (2022). Finance function of the future: Digital transformation in finance.https://www.pwc.com/gx/en/services/consulting/finance-transformation.html

[8] EY. (2021). Reimagining finance for the future.https://www.ey.com/en_gl/consulting/reimagining-finance

[9] Deloitte Insights. (2023). The future of finance: How CFOs are reinventing reporting.https://www2.deloitte.com

[10] McKinsey & Company. (2020). Finance 2030: The future of finance in a digital world.https://www.mckinsey.com

[11] KPMG. (2022). Improving financial reporting through automation.https://home.kpmg/xx/en/home/insights.html

[12] BDO. (2021). Financial automation and the CFO’s digital role.https://www.bdo.com

[13] Bain & Company. (2023). Strategic cost management in corporates.https://www.bain.com

[14] Gartner. (2022). Trends in financial planning and analysis (FP&A).https://www.gartner.com

How to cite this paper

Sujoy Das, Pushkar Parulekar "Optimizing Finance Operations Through Data Analysis" Iconic Research And Engineering Journals Volume 9 Issue 7 2026 Page 2009-2016 https://doi.org/10.64388/IREV9I7-1713872
Sujoy Das, Pushkar Parulekar "Optimizing Finance Operations Through Data Analysis" Iconic Research And Engineering Journals, vol. 9, no. 7, Jan. 2026, doi: https://doi.org/10.64388/IREV9I7-1713872
Sujoy Das, Pushkar Parulekar (2026). Optimizing Finance Operations Through Data Analysis. Iconic Research And Engineering Journals, 9(7). doi: https://doi.org/10.64388/IREV9I7-1713872
Sujoy Das, Pushkar Parulekar "Optimizing Finance Operations Through Data Analysis" Iconic Research And Engineering Journals, vol. 9, no. 7, Jan. 2026. Crossref, https://doi.org/10.64388/IREV9I7-1713872
@article{1713872,
      author = {Sujoy Das, Pushkar Parulekar },
      title = {Optimizing Finance Operations Through Data Analysis},
      journal = {Iconic Research And Engineering Journals},
      year = {2026},
      volume = {9},
      number = {7},
      pages = {2009-2016},
      issn = {2456-8880},
      url = {https://www.irejournals.com/formatedpaper/1713872.pdf},
      abstract = {This report presents an overview of the summer internship in the finance domain, focusing on financial reporting, data analysis, and automation. The internship aimed to support the finance team in improving operational efficiency, data accuracy, and decision-making through structured reporting and analytical tools.
Key contributions included the automation of investor reports using Power BI, support in a state sales tax study, and analysis of revenue and publisher cost concentration at both overall and business unit levels. The work also involved average collection and payment period analysis and evaluation of revenue receipt trends to derive insights into working capital management and financial planning.
Throughout the internship, accurate documentation was maintained, collaboration with cross-functional teams was ensured, and reporting standards and timelines were strictly followed. This experience strengthened financial analysis capabilities, enhanced proficiency in Excel and Power BI, and provided practical exposure to corporate finance and data-driven decision-making.},
      month = {January},
      doi = {https://doi.org/10.64388/IREV9I7-1713872}
  }