Manager, Business Intelligence
Chicago, Il, Us
- Guided junior team members through their assigned SQL projects and assisted them in delivering results- Held regular sessions for team members that needed extra support on SQL concepts - Led weekly check-in sessions with the Compliance team for requirements gathering related to Compliance requests, and translating tasks to the data team for execution- Automated the BSA team’s process for documentation of loans under fraudulent investigation using Python and PostgreSQL in order to streamline 15 hours of work per week to a few hours of work in a day- Created and managed the data upload process for Illinois loan validations with a third party servicer, reducing workload from 3 weeks/month to 30 minutes/month, and minimized the risk of human errors- Created a Python automation to load Google Sheets data into the main database for easier storage, tracking, and reporting uses, bridging data accessibility gaps for the Operational Risk team- Streamlined storage for data records using Google Apps Script by creating auto-generating timestamps for when users input data into sheets or make modifications, reducing manual work for data entry- Scoped Compliance-raised business issues using postgreSQL, provided remediation data, and built a Periscope dashboard for issue monitoring, avoiding future business losses- Performed various Finance/Accounting requests including data validation checks to the database for their new accounting system migration and provided queries and results for quarterly and year-end audits- Provided SQL queries and reports for Compliance state examinations/filings; created an organized process for the Compliance team to submit requests as well as created documentation for historical data