Optimizing Finance Operations Through Data Analysis

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.