Support Specialist Data Analyst

IT Technical Skills: Databases, Operating Systems, Networking, Cybersecurity, Cloud/AWS MySQL Azure Language: English

PROFESSIONAL EXPERIENCE

FIRST REPUBLIC BANK THE HEITMEYER GROUP September 2022 – Lending Services Data Analyst

Utilizing Azure, SQL, and Python scripts to collect cloud-based data sets for analysis, validation, standardization, and clean-up, for future migration into a single process procedure system, Knowledge Center and AWS DMS

Collaborated with the management teams to establish a monitoring framework, and propose and facilitate the implementation of strategies aimed at minimizing losses, such as workouts, restructures, or foreclosure

Designed and implemented linked, macro-automated Pivot Tables integrating Tableau and Power BI to generate multiple dashboards, graphs, and charts used to aid executive decisions

AWS Glue to construct a data pipeline to efficiently migrate data into a centralized repository within target CMS

Employed Jira to create a progress dashboard, team collaboration, and to effectively manage migration tasks FINANCE OF AMERICA MORTGAGE COMPANIES LLC Dec 2021 – July 2022 IT SUPPORT SPECIALIST II {Company Closure}

Point of contact for over 5,000 users with technical issues related to a wide use of AWS services, onboarding, security and compliance

Active Directory (AD) account management, troubleshooting, auditing, and access for single users and Group Policy Objects (GPOs)

Utilized ServiceNow for incident and problem management, change management, and service catalog managements

Identify and resolve technical issues that were affecting loan document delivery from the ConformX website

Regularly assisted user with Fannie Mae and Freddie Mac mortgage related guidelines to resolve unique DU/DO related errors

AMERICAN PACIFIC MORTGAGE CO. May 2021 – Dec 2021

IS APPLICATION SUPPORT SPECIALIST II {Contract, Remote}

Resolve technical issues using remote technology encompassing software and AWS solutions

Provide onboarding support, LOS Administration and Enterprise systems management within established SLA

Act as liaison between American Pacific Mortgage and vendor support teams to resolve end-user issues

Assist ChatBot BA Team with phases of product software and testing lifecycles

Manage data across multiple applications and databases

Provide support, leadership, and guidance to team members

Additional ad hoc assistance as needed Accomplishments:

Chosen to be the single point of contact for several department management

Offered expert feedback on process improvements to enhance digital user experiences CONT

. 424-***-**** *.********@*****.***

*.********@*****.***

FREEDOM MORTGAGE CORP Dec 2020 – May 2021

IT BUSINESS SUPPORT SPECIALIST I {Contract, Remote}

Administration and management of remote software supporting AWS network access and business support

Prepare reports ensuring mortgage lender guidelines and investor guidelines were met

Provide summaries and recommendations using MS PowerPoint and other visual communication tools

Work with various departments to ensure processes are completed accurately

Assist with the preparation of detailed executive reports for management and other departments by analyzing and interpreting production and user data Accomplishments:

Selected to work on specialty testing (Chat Bot) products selected by management ATHAS CAPITAL GROUP April 2019 – Dec 2020

COMMERCIAL AND RESIDENTIAL ACCOUNT EXECUTIVE {Pandemic shutdown}

Build business relationships with real estate professionals, mortgage loan originators and various industry adjacent professionals to secure lending for Residential and Commercial financing programs

Review and submit high-quality credit narratives and loan files which includes analyzing multi-year trends and ratios from financial information, understanding cash flow, collateral analysis, reviewing credit reports, and analyzing KYC information

Examine tax returns, business entity, and Trust documents provided

Coordinated file process and continued communication through underwriting, consummation, and funding Consistent producer, achieving company and personal milestones Accomplishments:

Qualified for first quarterly bonus offered to sales team. MORTGAGE READY INC. July 2015 – March 2019

BRANCH MANAGER

Provided support to sales and operations teams producing residential and commercial real estate transactions

Search, hire, and train mortgage loan originators and processors

Conducted file audits for completeness, program guidelines and applicable regulations

Communicated with transaction parties to resolve and problem solve

Managed Social Advertising to procure potential relationships

Prepared monthly branch P&L

Additional ad hoc duties provided as needed In an ever-changing environment SYNERGY DIRECT MORTGAGE June 2002 – March 2015

DIRECTOR OF SALES AND MARKETING / LOAN OFFICER

• Loan Officer Sales, Tele-sales, and Marketing Manager

• Sales responsibilities included: hiring, training and continued education for all Loan Officers. Mortgage Loan Officer 1999-2002

EDUCATION & CERTIFICATIONS Delaware Technical Community College, Wilmington 2011 MLO NMLS #195209 July ‘22

Contact this candidate