Built a Python automation to scrape parcel-wise tax, lien, and payment data from a county tax portal using Excel inputs. The script dynamically navigates records, handles missing/no-tax cases, and outputs a structured Excel report with multi-year tax totals and status tracking.
Tech: Python, Playwright, Pandas, Excel Automation
0
10
Title: BrokerCheck Advisor Scraping & Compliance Analysis
Role: Python Automation Engineer / Data Analyst
Description:
Developed an automated web scraping solution to extract registered advisor and firm data from FINRA BrokerCheck. Built a robust Playwright-based scraper with smart selector fallbacks, resource blocking for performance optimization, and multiprocessing to handle large firm lists efficiently.
Implemented advanced filtering logic to refine search results, handled edge cases like no-record firms, and ensured data reliability with structured logging and error handling. Processed and normalized scraped data using Pandas, generated disclosure-level analytics, and delivered outputs in both JSON and Excel formats with automated pivot tables for compliance and risk review.
0
11
Title: Delinquency Monitoring Dashboard – Axos Bank
Role: Data Analyst
Description:
Designed and built a delinquency monitoring dashboard for Axos Bank to track loan defaulters across quarterly and annual periods. Used Python and SQL to process and aggregate large datasets, automate reporting logic, and ensure data accuracy. Delivered Tableau dashboards that improved visibility into delinquency trends, reduced manual reporting effort, and supported risk and compliance teams in faster decision-making.
0
13
Title: Third-Party Risk Monitoring Dashboard
Role: Data Analyst
Description:
Designed automated risk monitoring dashboards using Python, SQL, and Tableau. Integrated third-party risk data, reduced manual assessments significantly, and improved visibility into vendor risk exposure for compliance and audit teams.