While the effort to become fully employed continues, assisting a very busy realtor with broad back-office support, including comparative market analyses (CMAs), listing contracts, offers, Multiple Listing Service (MLS) onboarding and ad hoc queries as needed.

A certified public accounting specializing in forensic accounting, litigation support and business valuation while continuing to provide tax and investment advice to select clients.Assisted the firm with adept document inventory and forensic accounting inquiries as needed.Accomplishments^ Implemented a "list and rename" tool to streamline file renaming, resulting in a notable 20-30% reduction in typical inventory time. ^ Identified multiple transfers and withdrawals necessitating additional clarification, often revealing undisclosed accounts during the discovery process.

A third-party reviewer specializing in the re-underwriting of residential mortgages for securitization.Designed and coded a comprehensive quality control process for third-party mortgage reviewer, writing hundreds of queries and functions in the process. Collaborated in the preparation of final reports for delivery to the rating agencies. Began learning Python, Tableau and Power BI.Accomplishments: ^ Engineered the interface between LauraMac, the Access databases and Excel worksheets, automating the entire process, saving hours per day in processing time.^ Used Visual Basic in Access and Excel, plus SQL in MySQL Workbench, to code each step in the process. ^ Automated labor-intensive reporting tasks, such as redaction, leading to an impressive 75-80% reduction in the typical processing time.^ Created a report that our loan software vendor offered to produce at a cost of $100 per hour and 40 hours (the vendor’s minimum ad hoc report fee), spending approximately 1.50 hours on the effort.^ Anticipated and wrote ad hoc queries to address observed anomalies in completed datasets.

A private equity investor specializing in distressed debt, including commercial real estate (CRE) mortgages.Directed the CRE valuation effort for acquisitions culminating in a structured report to disclose findings, value and net operating income, if applicable. Collaborated with asset management in the disposition of REO assets and the hold/sell decisions of other assets. Accomplishments:^ Assisted in the design of an underwriting database (Azure), including field level design and descriptions to improve the efficiency and transparency of the underwriting process. ^ Created a front-end database in Access to efficiently export underwriting data to the SQL Server back- end database, greatly reducing processing time relative to reporting.^ Attended credit committees and provided candid collateral assessments.

A private equity company with a deep servicing platform, actively engaged in the acquisition of performing and non-performing/distressed residential and CRE mortgages.Conducted valuation activities, including thorough appraisal reviews, market research and independent searches for comparable sales and rentals across major CRE asset types. Analyzed CMBS assets, including valuation and cash flow modeling. Executed all data support functions relative to targeted acquisitions and the portfolio of acquired transactions..Accomplishments:^ Analyzed performing and non-performing loan portfolios in the CRE sector.^ Performed site visits and financial modeling on assets earmarked for acquisition.^ Designed the first database used by the real estate group to capture CMBS data, saving tens of thousands of dollars in third party vendor fees and putting all work product in one searchable repository. ^ Redesigned CMBS front end database to accommodate a SQL Server backend database.^ Created and maintained the robust DCF models used by the real estate group.

A mortgage company specializing in small CRE assets.Directed and managed all loan underwriting operations, ensuring seamless coordination between underwriters, internal staff appraisers and other team members. Effectively communicated with external stakeholders, including credit rating agencies, building rapport while discussing project details in order to secure buy-in from critical partners.Accomplishments:^ Managed and developed employees in commercial real estate analysis and valuation.^ Supervised loan underwriters, instilling best practices for pertinent loan underwriting.^ Created and instituted a contemporary database that improved appraiser identification efforts, enabling the firm to contract and work with the most competent appraisers for a given project.