Bicycling, hiking, traveling, volunteering, reading
Marc Stemmer
Royal Oak,Michigan
Summary
With a proven track record at Zeal Credit Union and MGIC, I leverage Excel and other tools such as DNA Publisher and SQL Developer for advanced data analysis, enhancing operational efficiency and strategic decision-making. I've significantly contributed to key projects with multiple departments and led two fundraisers, demonstrating a unique blend of technical prowess and interpersonal skills.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Report Coordinator/Risk Management Specialist
Zeal Credit Union
08.2022 - Current
- Managed Business Intelligence Helpdesk to assist credit union operations across departments by building reports and completing data analysis based on requests from management and staff.
- Built data analysis project using queries and SQL from Fiserv DNA/OSI core in addition to multiple third party data sources for Emergency Capital Investment Program quarterly and annual reporting requirements to the person level including income, loan data, demographics, and census tracts.
- Developed, implemented, and tracked a Demographic Collection Plan at loan closings for ECIP reporting.
- Built data analysis project on members utilizing telephone banking system to help transition members towards online banking.
- Developed a data process to target members utilizing an old routing number on ACH transactions and checks from a merged credit union to increase efficiency in the manual processing of ACH routing number errors
- Created targeted marketing email lists based on criteria using queries built and modified via DNA Publisher.
- Generated and calculated Lending and Marketing KPI metrics including on-book and off-book loans and MCIF data.
Mortgage Underwriter
Zeal Credit Union
11.2021 - 08.2022
- Approved or denied first mortgages, home equity loans, and HELOCs based on established criteria and underwriting guidelines.
- Analyzed and verified applicant income, assets and credit history to support compliance with underwriting guidelines.
- Determined credit risks by reviewing files in advance and comparing data against internal checklists and guidelines.
RPC Specialist III
MGIC
06.2015 - 08.2019
- One of two on team of twelve promoted to Smart Review team to approve low-risk mortgages for PMI based on the URLA, credit reports, FNMA DU and FMAC LP, appraisals, condo questionnaires, and titles.
- QC error rate best on team with second fastest production.
- Promoted twice during tenure from a Level I to a Level III.
Education
Bachelor of Arts - Psychology
University of Michigan, Dearborn
Dearborn, MI12-2007
Bachelor of Arts - James Madison College - Political Theory
Michigan State University
East Lansing, MI05-2005
Skills
- Excel: primary daily data analysis and reporting tool, two courses completed on Udemy (2022)
- SQL Developer: modification of existing SQL for reporting
- Google Analytics: Udemy course completed (2023)
- Fiserv DNA/OSI: primary membership look-up tool
- DNA Publisher: build new queries and modify existing queries by joining tables within core using qualifiers
- DNA Report Manager: creating automatically generated recurring reports
- Regulatory Compliance: earned certificates from Mortgage Bankers Association in TILA, RESPA, ECOA, HMDA, BSA/Anti-Money Laundering Laws, FHA, FCRA, Rights to Financial Privacy Act, Dodd-Frank Wall Street Reform and Consumer Protection Act, and FACTA
- Mortgage Underwriting
- Relationship Building: managed a fundraiser for Forgotten Harvest (2024) and a computer auction (2022) to sell used computers to raise funds for the Zeal Foundation
Certification
FastTrack: New Venture business program graduate (2012)
Interests
Timeline
Report Coordinator/Risk Management Specialist
Zeal Credit Union
08.2022 - Current
Mortgage Underwriter
Zeal Credit Union
11.2021 - 08.2022
RPC Specialist III
MGIC
06.2015 - 08.2019
Bachelor of Arts - Psychology
University of Michigan, Dearborn
Bachelor of Arts - James Madison College - Political Theory
Michigan State University
Similar Profiles
Shatha HaidarShatha Haidar
Member Service Specialist at Zeal Credit UnionMember Service Specialist at Zeal Credit Union
Angela OlsenAngela Olsen
Teller, Operations Department at Beehive Credit Union (now Security Services Credit Union)Teller, Operations Department at Beehive Credit Union (now Security Services Credit Union)
Jan SylvesterJan Sylvester
Senior Accounts Clerk/Accounts Clerk I at G.U.T. Credit Union Ltd/Nexa Credit Union LtdSenior Accounts Clerk/Accounts Clerk I at G.U.T. Credit Union Ltd/Nexa Credit Union Ltd
Liam ColoneLiam Colone
Inventory Specialist at Parts Place Inc.Inventory Specialist at Parts Place Inc.
Jurgena IsmailiJurgena Ismaili
General Nurse Clinic at Olive Medical CenterGeneral Nurse Clinic at Olive Medical Center