• Leveraged SQL, Excel, Python daily to investigate data discrepancies and answer ad-hoc data inquiries• Collaborated with database architect to troubleshoot ETL errors, develop new database structures, modify existing processing code, and translate business needs into technical specifications• Built and maintained numerous Tableau dashboards providing insight into asset performance and market trends• Developed pipeline to normalize, validate, and load data from 50+ distinctly formatted investor remittance reports to data warehouse which ranged significantly in formatting and data quality• Effectively communicated with internal management and 30+ external counterparties including clients, sellers, servicers, and auditors to deliver data reporting, resolve data discrepancies, and coordinate efforts• In the development of an automated remittance report processing application, I translated business needs, performed quality control / user testing, and provided oversight on PostgreSQL database.

• Scraped, aggregated, cleaned, and loaded data to construct website foundation• Analyzed website performance metrics to maximize user interaction and retention• Helped develop ETL pipeline to process and load user data to MongoDB database

• Gathered, entered, and analyzed data for client actuarial reports• Investigated drivers behind recent increase in California General Liability costs• Researched and recorded nationwide Benefit Level and Loss Development trends