Jack Mueller Email & Phone Number

Arlington, VA, US

Ponte Vedra Beach, Florida, United States

Ponte Vedra Beach, Florida, United States

• Develop forecasting model in R to assist in resource planning and allocation
• Deputy Reporting Team Lead
• Automate mission-critical reporting in Tableau and Tableau Server
• Enhance data science practices within client project by applying expertise in predictive analytics and statistical methods to shape and deliver data-driven modeling solutions
• Lead team of five, responsible for the coordination of events and communications for account of 600+ people
• Devise strategies to improve organizational efficiency and optimize group management

Washington D.C. Metro Area

• Developed strategic roadmap for transition of client reporting from legacy system to Tableau
• Synthesized customer data in R, identifying and presenting key areas to target for improvement of system
• Led enhancement of reporting dashboard, increasing transparency and accuracy of debt tracking within client system
• Designed and implemented comprehensive Tableau dashboard tracking the effect of COVID on client workload > Dashboard was leveraged by other projects to inform Tableau best practices across account
• Leveraged newly available consolidated financial data warehouse to address client needs not previously defined
• Responsible for designing, implementing, and maintaining multiple reports and dashboards in Oracle Business Intelligence Enterprise Edition and Tableau to coincide with functional development of the client system

Washington D.C. Metro Area

• Perform testing related to the implementation of Current Expected Credit Losses (CECL) accounting standard including cohort level sensitivity to interest rate and home price movement
• Work with the application development team to refine design and solution specifications for our Loss Allowance Valuation Analytics (LAVA) model
• Flag high-risk loans and determined risk characteristics for future analysis
• Execute loss forecast analysis and prepare monthly and quarter-end reporting
• Execute analysis on new acquisition loans to determine performance trends and patterns; developed comprehensive dashboard to track and showcase results to management
• Consolidate and track budget of over $30M for the CECL strategic initiative

Washington D.C. Metro Area

• Third rotation responsibilities with Single Family Loss Allowance team:
• Gained hands-on experience with both SAS and SQL, by maintaining and updating models for monthly and quarterly reports related to the FAS 5 and FAS 114 allowance
• Produced bank comparison analysis comparing Fannie Mae to outside competitors using financial results
• Coordinated with teams across Financial Business Analytics department to manage and consolidate the quarterly Enterprise Risk Committee deck, presented to leadership of the Finance division
• Utilized SAS to evaluate results from LAVA (Loss Allowance Valuation Analytics) test runs and provided feedback on the model
• Performed analysis on the effects of the 2017 Natural Disasters, and assisted in the formulation of our adjustment of nearly $1B to the allowance

Washington D.C. Metro Area

• Second rotation responsibilities with Enterprise Data Strategic Planning and Engagement team:
• Utilized Tableau Software to develop and automate the Enterprise Data Roadmap, tracking 600+ project milestones across 16 different workstreams
• Assisted in the automation of the quarterly business review metrics package in Tableau, supporting leadership’s successful management of the $130M budget for the 700+ person division
• Created the Enterprise Data PMO Digest newsletter, sent out to VPs/Directors and Project Managers within Enterprise Data, keeping everyone apprised of each teams’ work
• Worked with both internal and external customers in support of the Demand and Capacity Management process, preparing presentations for the leadership group on each project

Washington D.C. Metro Area

• First rotation responsibilities with Enterprise Data Architecture and Analytics CoE teams:
• Interfaced with multiple business partners to understand and develop an overview of applications and data flow diagram for final architecture document presented to the Design Working Group
• Engaged with Senior Data Architects and developed training guides for internal customers, providing insight into how data architecture, data governance and data management processes work
• Supported the transition of five teams to an Agile Methodology o Worked with management team to develop Kanban Boards o Identified/defined key management reports o Defined daily cadence for huddle meetings

Harrisonburg, VA

• Chosen out of field of applicants for the Risk Management Project Area
• Responsible for ensuring safety of all Fraternities and Sororities on campus
• Coordinate with leadership of all Greek Organizations to guarantee all are educated on FSL Policies

Falls Church, VA

• Worked as a member of the Operations and Demand Management Team
• Assisted the project team with gathering requirements from a business perspective
• Assisted in designing and implementing new methods, procedures, and systems (both automated and manual) to improve the processing and flow of information within the company
• Assisted in creating and updating data/process models in relation to requests from client organizations (both internal and external)

Los Angeles, CA

• Compiled and maintained annual business event calendar and streamlined transfer of information to an online database format
• Conducted research, analyzed survey data, and determined ROI in relation to different events
• Analyzed production costs and compiled detailed comparisons relative to client requests and project budgets
• Collected and organized internal data relative to Mid-Year Review
• Worked alongside the agency’s account, production, administrative and digital departments to gain comprehensive understanding of the company’s business model

Bachelor Of Business Administration - Bba, Management, Minor In Business Analytics

High School Diploma

Activities and Societies: Ski and Snowboard Club President, Campus Ministry Team, Kairos Retreat Leader