Predictive Modelling and Automating the Quarterly Financial Analysis

As a Data Analyst Intern, my responsibilities included collecting and analyzing the quarterly financial and business data for PeopleFund's clients. I automated the quarterly reporting by creating a standard Excel template and using some advanced functions to manipulate, calculate and auto-populate data, thus reducing errors and manual efforts. Additionally, to determine the urgency of follow-up required, I also created categories to automatically assign a risk rating to each client. I was further able to analyze the correlation between the features and generate multiple models to predict the outcomes using Predictive Modelling techniques.