David Fecht
Chicago,IL
Summary
Analytically minded and driven, I am hardworking and reliable with strong skill sets in quantitative analysis, and business intelligence. I am looking to move into a more mathematical role within finance and banking, and am eager for a new challenge.
Overview
8
8
years of professional experience
Work History
Senior Business Intelligence Analyst
Flagstar Bank
Troy, MI
01.2021 - Current
- Working within the mortgage division of the bank, my responsibilities revolve around building dashboards, data sources, and reporting for KPIs, KRIs, and operational purposes.
- Develop complex SQL queries leveraging multiple data sources and schemas that are deployed in a number of the bank's reporting layers.
- Responsible for writing operational data sources in SQL to house in numerous servers and platforms including Tableau, Oracle Databases, and IBM Cognos.
- Build Tableau dashboards that are used for both operational and executive level insights into portfolio behavior and risk.
- Introduced machine learning applications using R, and integrated with data visualization techniques using Tableau.
Business Intelligence Analyst
Flagstar Bank
Troy, MI
09.2019 - 01.2021
- Wrote SQL queries for audit requests concerning the bank's overall portfolio health within mortgage servicing and originations.
- Built Tableau dashboards for integral business units of the mortgage servicing space including (insurance, loan transfers, and MSR client relations).
- Responsible for building reporting layer for specific mortgage business units within IBM Cognos.
Escrow Operations Business Analyst
Flagstar Bank
Troy, MI
06.2016 - 09.2019
- Serving as a member of the supervising staff in the Escrow Division of Mortgage Servicing, I was the conduit for reporting, portfolio analytics, and compliance auditing.
- Regularly provided portfolio metrics and KPIs for both in-house usage and to investors, as well as coordinate with MSR (mortgage servicing rights) owners and other servicers on the operational impact of loans that Flagstar had acquired or transferred out.
- Worked closely with loan accounting to reconcile general ledgers, and attestations as it relates to servicing expenses and revenues.
Education
Master of Science - Applied Mathematics
DePaul University
Chicago, ILBachelor of Arts - Economics
DePaul University
Chicago, ILSkills
- SQL
- Tableau
- IBM Cognos
- SAS Programming
- Relational Databases
- R
- Python
- Machine Learning
- Statistical Analysis
- Monte Carlo Methods
- Time Series Analysis
- Regression Analysis
Coursework
- Time Series Analysis
- Regression Analysis
- Simulation and Monte Carlo Methods
- Financial Mathematics
- Financial Modeling
- Nonparametric Statistics
- Numerical Analysis
- Probability and Statistical Theory
- Statistical methods using SAS
Timeline
Senior Business Intelligence Analyst
Flagstar Bank
01.2021 - Current
Business Intelligence Analyst
Flagstar Bank
09.2019 - 01.2021
Escrow Operations Business Analyst
Flagstar Bank
06.2016 - 09.2019
Master of Science - Applied Mathematics
DePaul University
Bachelor of Arts - Economics
DePaul University