Aaron Castle Email & Phone Number

Plano, Texas, United States

Senior Technical Project Manager supporting Single Family Real Estate in the Collateral Risk Organization.Certified SAFe 6 AgilistCertificate ID: 98177747-8413

Plano, Texas

Single Family Real Estate | REO Sales | Sr Asset ManagerNovember 2017 through May 2021, I was a Senior Asset Manager in REO Sales responsible for end to end REO Asset disposition including property management, repair renovation, offer negotiation, expense reimbursement and sale of distressed Fannie Mae owned Real Estate properties in three separate territories including states in the Northeast US, Central US, and the Southeast United States. June 2021 through April 2022, I worked in the Loan Quality Center doing reporting and loan quality underwriting audits for the Homestyle Renovation Loan program focusing on production, reporting, and process improvements. We onboarded loan programs into our enterprise Loan Quality Control system during this time.

Dallas/Fort Worth Area

Single Family Mortgage Ops | Master Servicing | Investor Reporting Analyst II & Integrated Business Operations Analyst II

Dallas, Tx

Single Family Real Estate Analyst III: Rental & Strategic Initiatives - Occupied Property ManagementStrategic Initiatives Process Owner:+Manage the Former Owner Rental, Release to Sales and Owner Repurchase processes from end to end+Operations Project Management+Write business process documents for organization+Create process flows in Visio, process documentation for training, auditing and oversight purposes. Vendor and Business Support:+Train, manage, provide oversight and process recommendation to outsourced vendors (Legal Firms, Agents, Property Management Companies and Outsourced Analysts)+Provide training and technical support to peers related to SQL reporting (SSMS), IBM Business Objects, Microsoft Excel, Access and SharePoint Business Analyst Proxy:+Query data from workflow system ODS using SQL Server Management Studio and Access to create departmental operational reporting +Utilize Excel macros, v-lookups, pivot tables, charts and graphs, and deliver ad-hoc reporting+Audit outsourced vendor business processes, provide process improvement recommendation and scorecard coaching to drive outsourced vendor performance

Plano, Tx

Consumer Product Strategy Analysis in the Data Reporting Analytics organization delivering business analysis and project management support to investor and regulatory agency reporting teams.+Liaison between operational reporting, operational business, and technology+Contribute to project meetings on behalf of Investor and Regulatory Reporting to help shape company reporting processes to become compliant with Consumer Financial Protection Bureau rules and regulations +Assign, track and complete project deliverables related to Systems Integration, User Acceptance, and Post Implementation data reporting systems testing +Update data mapping from loss mitigation, underwriting, and loan modification systems of record showing the data lineage from SOR through the provisioning, staging and landing tables in a SQL Server 2008 operational data store.+Define project scope and assess impact to Agency Reporting teams+Recommend strategic systems enhancements to maximize risk vs. reward tradeoff for the business unit+Review and vet technical documents; accelerated change, business requirements, high level and low level design documents for technical enhancements to SQL table objects and reporting system user interfaces (UX)+Complete user acceptance testing process in Quality Center by creating and executing test plans, test cases, and test scripts in SQL Server Management Studio (SSMS)+Design, organize and maintain SharePoint sites for team processes and communications

Richardson And Dallas Tx

Project Manager, Business Analyst and Loan Servicing Team Lead focused on internal data reporting, re-mediating loans stuck in loan modification processes. Created solutions during the roll-out of servicing operations business processes, loss mitigation and loan modification programs for BAC's Fannie Mae serviced loan portfolio.+Train and lead a team of four business control specialists on all loan modification process functions including processing, reporting, auditing and quality control for Fannie Mae loan modifications+Liaison between Government Sponsored Enterprises, Held for Investment, and Private Investor loan portfolios, loan quality audit groups, vendor management, and external vendors. + Create SQL queries (SSMS) for internal operational reporting and provide data analysis using Excel V-Lookups, Pivot Tables, charts, graphs, trend tables, and data analysis formulas+Launch FNMA loan modification and loss mitigation programs from the ground up with emphasis on streamlining operations and process improvement +Create business alliances with Investor Reporting and work through key operational issues related to manual and systemic FNMA Home Saver Solutions Network (a.k.a. HSSN) reporting+Provide mass systemic decisions on large loan batches through Excel sort and filter features, concatenate and data analysis formulas while interpreting and adhering to investor delegation criterion+Audit loan modification decisions made in workflow system, and perform root cause analysis on any defects. Lead project meetings to present findings and solution options

Richardson, Tx

+Process FNMA loan modifications by ensuring adherence to company guidelines and standards, and providing top notch service throughout the underwriting, loan processing and funding cycle.+Analyze financial documents including bank statements, pay stubs, income tax statements, credit reports for accuracy and completeness to deliver for underwriting+Preform escrow analysis, order property valuations and process trial and official loan modification offers for FNMA loans+Reduce reputational risk by creating and nurturing relationships with Bank of America homeowners+Top Performer for May through October 2010; most loan modifications produced for FNMA NACA team

Lubbock, Tx & West Plano, Tx

Concurrent with fulltime studies. This was my college job in Lubbock, and I worked at the West Plano location for a little over a year after I graduated. Supervised two separate areas of the business in multiple stores including Logistics/Operations and Customer Service/Points of Sale and Cash Office. Fully committed to doing the right thing for the customer. Primary handler of large cash bank deposits and high cost inventory shipments.+Acted as Manager on Duty+Critical thinking and problem solving+Inventory management and cash office management+Logistics, shipping and receiving, supply chain+Strategic personnel resource planning and scheduling+Excellence in customer service+Multiple employee of the month, and employee of the quarter awards