Athulya Kollipara

Data Analyst @Silicon Valley Bank

FL, US

Data Integration and Risk Management: Successfully managed and integrated over 50 million records from various sources (CSV files, flat files, and APIs) into the data warehouse. This critical initiative enhanced the bank\'s capacity to identify high-risk loan customers and optimize risk management strategies.Predictive Analytics for Loan Default: Utilized advanced analytics and machine learning techniques, including logistic regression and random forest algorithms, to refine loan default predictions. This resulted in a notable 20% increase in the accuracy of risk assessments.Strategic Risk Communication: Effectively communicated complex project results to senior leadership, facilitating the implementation of targeted strategies based on predictive insights, which reduced loan delinquencies by 15%.Interactive Risk Assessment Dashboards: Developed and deployed interactive Tableau dashboards that provided real-time, actionable risk assessments to enhance strategic decision-making processes.Automation and Efficiency in Access Management: Implemented a Python-based access revocation system that efficiently removed access for terminated employees across all applications, saving 4 hours daily and enhancing operational efficiency.Data Reconciliation System: Developed a sophisticated automation system using Python and SQL that reconciled user data across applications, reducing the time spent on monthly user access reviews by 75%.Advanced SQL Reporting: Designed and wrote complex SQL queries for data analysis and reporting, including ad-hoc queries and real-time dashboards, which supported the team\'s capacity to gauge and interpret business trends efficiently.