•Automated documentation retrieval processes by developing a custom Python script to scrape Confluence pages related to the gold layer of the bank’s database schema, significantly reducing manual data extraction efforts and improving data accessibility for future projects. •Collected and consolidated collateral data for the credit risk team by writing a complex SQL CTE query in Databricks, joining multiple tables from the database's gold layer. This SQL script served as a foundation for… Show more •Automated documentation retrieval processes by developing a custom Python script to scrape Confluence pages related to the gold layer of the bank’s database schema, significantly reducing manual data extraction efforts and improving data accessibility for future projects. •Collected and consolidated collateral data for the credit risk team by writing a complex SQL CTE query in Databricks, joining multiple tables from the database's gold layer. This SQL script served as a foundation for future data analysis projects, ensuring consistent data access for credit risk assessments.•Developed interactive maps for the collateral risk dashboard using Plotly and Folium, providing the credit risk team with dynamic visual insights into geographical risk distributions, ultimately enhancing the decision-making process for asset risk management. Show less

•Processed payroll for 100+ employees with zero errors, including calculating wages, overtime, and deductions in adherence to federal, state, and local tax regulations.•Generated comprehensive payroll reports on a weekly basis for all departments and management, leading to improved transparency and decision-making processes.•Successfully audited and updated over 500 service books of retired employees in CRM, ensuring compliance with company policies and legal regulations.

•Managed and resolved a backlog of 500+ financial records, improving the accuracy and timeliness of the accounting system by 40%.•Entered and recorded financial data into the accounting system with 100% accuracy, resulting in the preparation of detailed financial reports including profit and loss statements, balance sheets, and cash flow statements.•Conducted basic data analysis to identify financial trends, discrepancies, and potential areas for improvement, supporting data-driven… Show more •Managed and resolved a backlog of 500+ financial records, improving the accuracy and timeliness of the accounting system by 40%.•Entered and recorded financial data into the accounting system with 100% accuracy, resulting in the preparation of detailed financial reports including profit and loss statements, balance sheets, and cash flow statements.•Conducted basic data analysis to identify financial trends, discrepancies, and potential areas for improvement, supporting data-driven strategies that led to a 15% increase in revenue. Show less