• Led the creation of a service fee reporting system through SQL-based ETL processes, accurately calculating fees from interest and penalties across 10 million loan documents. Automated custom report generation for 150 partner financial institutions, significantly boosting operational efficiency and receiving outstanding feedback.• Championed the deployment of Smart BI dashboards to dynamically showcase the overall scale of individual deposits and online loans. Leveraged SQL and Python… Show more • Led the creation of a service fee reporting system through SQL-based ETL processes, accurately calculating fees from interest and penalties across 10 million loan documents. Automated custom report generation for 150 partner financial institutions, significantly boosting operational efficiency and receiving outstanding feedback.• Championed the deployment of Smart BI dashboards to dynamically showcase the overall scale of individual deposits and online loans. Leveraged SQL and Python to aggregate and visualize key financial metrics, including daily and monthly balance fluctuations, product segmentation, and geographical distribution. Facilitated strategic decision-making by providing real-time insights into financial product performance and market trends.• Integrated 10+ data source systems into the data warehouse to streamline data management and accessibility. Show less