Analytics Engineer

• Improved a manual scorecard process by using Python to process csv files, update Tableau Server through its REST API, download reporting in PDF format, and create paginated reporting for consumption with the PyPDF2 library
• Developed Tableau dashboard enhancement that allows users to view penetration rates of orderable options, which helped to provide visibility into complexity reduction efforts
• Improved the data quality of part to vehicle program and part to part category relationships, moving accuracy from less than 50% to 95%+
• Created ETL pipelines for plant sustainability reporting, utilizing Hadoop, Spark, and Hive, which allowed the automation of annual public reporting

• Utilized PySpark and AWS Glue to create ETL pipelines, contributing to the company’s shift toward AWS from on-premises resources
• Created ETL pipelines with Python and Apache Airflow to facilitate AWS cloud to on prem data warehouse ingestion patterns
• Developed and maintained data warehouse SQL structures (tables, stored procedures, views, etc.) related to mortgage servicing
• Worked closely with the default communication team to develop a production scorecard by determining data requirements, Power BI visual specifications, and validating query results
• Facilitating migration of on premises data warehouse to cloud through refactoring existing pipeline objects and implementing new ingestion patterns using a combination of Spark SQL and AWS Glue Dynamic Frames

• Reported and analyzed $100m+ in outstanding receivables
• Identified optimal collection campaign populations by analyzing customer repayment frequency, resulting in the collection of $180k and creation of new collection efforts
• Automated reporting of outstanding advances by learning and implementing Power BI solutions, saving 14 hours of manual work monthly

• Received a companywide award for automating the daily transfer of funds between investor custodial accounts through use of SQL Server Reporting Services (SSRS), eliminating manual wire forms
• Created monthly account comparison in SQL which condensed the retrieval of three manual reports, increased reconciliation accuracy, and saved hours of work monthly
• Built SQL procedure to track the daily collection of escrow funds, avoiding outsourcing to Black Knight Financial Services