Financial Analyst Intern
CurrentResearched 9 years of flood history and balance sheets, forecasted flood likelihood, and approximated relevant costs for over 15 areas in Melbourne. Utilized Excel and Python for data cleansing, manipulated various datasets to examine cost particulars, and visualized seasonal trends. Constructed 4 Time Series models by assessing historical flood factors and conducted Monte Carlo Simulations to determine the safety budget range. Developed a Power BI application model to demonstrate the outcomes, allowing to manipulate areas and dates to corresponding predictions and visualization.