Nicholas Funke Email & Phone Number

Jefferson City, MO

- Eliminated millions of dollars and counting in credit card risk by developing a proactive credit line management program- Built ETL feed for and currently run CECL loss provisioning models- Consolidated redundant data sets in Tableau into multipurpose, multi-faceted line-of-business specific data sources

Maryland Heights, MO

• Increased efficiency of reporting and analytics for the business planning, credit services and collections divisions by managing projects to replace manual reporting solutions with dynamic solutions in Microstrategy.
• Educated users on the features of new reporting products by hosting demo sessions, producing documentation such as user guides and key operating metric explanations, as well as providing ongoing support to business users
• Ensured accuracy of reporting solutions by overseeing validation and quality assurance efforts with the business units that we support

Jefferson City, Missouri

• Eliminated manual and labor-intensive reporting efforts to reconcile general ledger to customer accounts by replacing the process with a dynamic data warehousing solution which leverages accounting data. Project.
• Monitored daily changes in liquidity by assisting the Asset-Liability Management team with building and maintaining dashboards in Power BI and Tableau
• Enhanced customer experience by building reporting to assist management with coaching and guidance of employees, measuring employee performance and cross sell initiatives
• Increased efficiency and effectiveness of targeted marketing efforts by collaborating with Retail BI team on building Next Best Action and other propensity score models, as well as generating customer communication.
• Other various ad-hoc analyses as needed using tools such as R, MS SQL Server and Visual Studio (SSRS and SSIS), MS Power BI, and MS Excel.

Jefferson City, Missouri

• Assisted in data gathering, organization, cleansing, and database maintenance tasks
• Performed statistical analyses to forecast balance sheet items and build consumer behavior models
• Collaborated on e-mail marketing, attrition / retention, and online banking feature usage studies
• Delivered several presentations to teams of executives

Columbia, Missouri

Maintained working knowledge of textbook sales and tracking system, assisted customers with finding things on the floor as well as filling and delivering orders. Managed logistics of mass publisher return and buyback processes each semester.

Jefferson City, MO

Fenton, MO Store 23002

Master Of Science - Ms, Analytics

Bachelor Of Science (B.S.), Statistics

Activities and Societies: Phi Sigma Theta National Honor Society Marching Mizzou Trumpet Section (2014-2017) Mini Mizzou Trumpet Section.

High School

Activities and Societies: Silver Falcon Marching Band Trumpet Section (2010-2014) Silver Falcon Marching Band Trumpet Section Leader.