Jonathan Fangmeier Email & Phone Number

- Develop and optimize SQL Server queries to extract and analyze large datasets, generating detailed reports and visualizations in Tableau.- Create dynamic dashboards in Tableau with calculated fields, parameters for custom date ranges, and sales forecasts, improving decision-making for stakeholders.- Automate Excel processes using VBA and Office Scripts to streamline repetitive tasks, significantly reducing manual effort and increasing accuracy.- Design and implement Power Automate flows to track and manage the new hire process, improving onboarding efficiency and ensuring timely follow-ups.- Collaborate with multiple departments to design tailored solutions addressing specific questions and problems, leveraging data analysis and automation tools.

Lincoln, Nebraska Area

• Troubleshoot Fiserv applications which utilizes a DB2 environment that contains confidential financial and transaction information• Query a DB2 environment with over 100 tables and data sets that exceeds 100,000 entries to make adjustments during the troubleshooting process• Collaborate with coworkers within team and colleagues in other departments to reach a resolution to a clients’ issue• Gather data from clients to predict issues and present advice on how to mitigate further incidents• Document and manage case information in an internal ticketing system to archive client issues

• Manage multiple projects to increase efficiency and improve processes while continuously supporting customers with data port related issues• Communicate with customers to explain why problems are occurring while simplifying complex technical language• Oversee the maintenance of data ports for all residence halls on-campus each summer, coordinating with hall directors, delegating tasks to student workers, and being the point of contact for all questions• Audit data port billing by reviewing reports, data usage, and checking data closets for connectivity• Oversee 4 student workers by providing training, giving feedback, and leading by example to ensure students provide excellent service• Created Excel database of power supply locations and their specific details to centralize information• Updated firmware on 150+ data closets ensuring all settings were correct and the process was done efficiently

• Resolved technical issues through investigating data ports and reconfiguring wires when necessary• Recorded and updated issues via My Support, an online service ticketing management system, to keep team members and customers up-to-date

• Supervised 4-5 employees per shift, oversaw opening and closing procedures, and multitasked in a fast-paced environment making sure operations ran smoothly• Responded to customer complaints by effectively communicating and listening to find solutions• Totaled cash and credit transactions twice a day ensuring accuracy for reporting daily sales• Promoted and took on manager responsibilities including creating schedules and assessing inventory

• Maintained high standards of customer service during high-volume, fast-paced operations by being adaptable