Matthew Falcon
Summary
Results-driven Data Analyst with 3.5 years in mortgage servicing operations and enterprise reporting. Expertise in advanced T-SQL, SQL Server, and Python automation to analyze loan-level data, enhance servicing workflows, and resolve data discrepancies. Demonstrated success in managing large-scale datasets, ensuring data integrity, and delivering actionable insights through SQL-based reporting and Power BI.
Overview
9
9
years of professional experience
Work History
Senior Automation & Reporting
Essex Mortgage
Ocala, Florida
02.2023 - Current
- Developed, optimized, and maintained complex T-SQL queries, stored procedures, and views to support mortgage servicing operations, enhancing existing SQL logic and ensuring reliable reporting.
- Analyzed mortgage servicing and loan portfolio data to identify trends, investigate data discrepancies, and deliver actionable insights that supported business and operational decision-making.
- Developed Python automation scripts that extracted data from SQL Server, transformed reporting data, and reduced manual reporting efforts while improving reporting accuracy and consistency.
- Assisted in developing and maintaining Power BI reports, leveraging SQL datasets to support business reporting, data analysis, and business intelligence initiatives.
- Partnered with servicing, operations, and business stakeholders to deliver business intelligence solutions, translate reporting requirements, and ensure data integrity across enterprise systems.
- Supported the migration and onboarding/offboarding of 35,000+ mortgage loans across enterprise servicing platforms, validating data integrity, troubleshooting integration issues, and ensuring accurate, compliant data transfers.
- Performed data validation and root-cause analysis to resolve reporting discrepancies, improve data quality, and ensure the accuracy and reliability of business-critical datasets.
- Leveraged Microsoft SQL Server, T-SQL, Python, Excel, and Power BI to automate workflows, analyze large datasets, and streamline recurring operational processes.
- Oversaw the integration of large datasets into company systems, ensuring seamless data flow and compliance with requirements.
IT Specialist
ABF Learning Center Inc
05.2022 - 10.2022
- Provided technical support for educators by managing IT service requests, troubleshooting system issues, and ensuring timely resolution to maintain operational continuity.
- Supported deployment of software updates, patches, and system configurations to ensure stable and secure performance across user devices.
- Diagnosed and resolved hardware and software issues, reducing system downtime and improving reliability for end users across the organization.
- Communicated technical solutions clearly to non-technical users, improving understanding and reducing recurring support issues.
- Proactively identified recurring technical issues and implemented preventive troubleshooting steps to reduce downtime and improve system stability.
Food Server
Applebee's Grill + Bar
02.2017 - 05.2022
- Delivered high-quality customer service in a fast-paced environment, ensuring positive guest experiences and satisfaction.
- Managed multiple tables simultaneously while maintaining accuracy, efficiency, and service quality under time constraints.
- Followed strict food safety and sanitation procedures to ensure compliance with health standards.
- Built customer relationships by providing personalized service and anticipating guest preferences.
- Mastered menu knowledge to provide accurate information and helpful suggestions to guests.
- Trained new servers on menu offerings, service standards, and operational procedures to maintain consistency.
Education
Bachelor of Science - Data Analytics
Miami Dade College
Miami, FL12-2023
Skills
- Power BI reporting
- SQL expertise
- Data warehousing
- Database management
- ETL processes
- Data integration
- Data quality assurance
- Data validation
- Python automation
- Advanced Excel
- Business intelligence
- Process improvement
Accomplishments
- Upon starting my position, I oversaw data integration processes to migrate a large dataset into a new system, helping establish the foundation for the company’s current data infrastructure and growth.
- Collaborated with the IT team to support the company’s migration from the Google ecosystem to Microsoft 365.
- Promoted from Junior Data Analyst to Senior Data Analyst in my second year with the company.
Timeline
Senior Automation & Reporting
Essex Mortgage
02.2023 - Current
IT Specialist
ABF Learning Center Inc
05.2022 - 10.2022
Food Server
Applebee's Grill + Bar
02.2017 - 05.2022
Bachelor of Science - Data Analytics
Miami Dade College