John Garner
Woodstock,GA
Summary
Intelligent Business Analysis Manager with a 26-year record of leadership experience in areas such as development of tools to increase efficiency and management, application support, and price optimization. Focused on satisfying customer needs through robust, innovative and forward-thinking solutions. Demonstrated success as operational leader, articulate communicator and practiced influencer. Collaborates across departments to outline and achieve team targets. Skilled in building solid business solutions based on methodologies and economic principles. Complex problem-solver skilled in developing proposals, integrating technologies and managing projects.
Overview
27
27
years of professional experience
Work History
Business Analyst Manager
T-Mobile
Atlanta, GA
04.2021 - Current
- Created and maintain Power BI dashboards to identify and measure performance KPIs and measure performance against each team's OKRs.
- Created and maintain weekly reports for senior management that displays current workload for Bid Management and summarizes all bids with pending outcomes.
- Created and maintain an Excel VBA based tool that calculates Total Cost of Ownership for prospective subscribers based on proposed plans and devices.
- Created and maintain and Excel VBA based tool that calculates ROI for prospective subscribers and determines number of months to break even by switching providers.
- Work with Bid Management team on RFP's to convey pricing strategies to prospective subscribers and show value of T-Mobile offers.
Sports Official
North Georgia Amateur Umpire Association
Woodstock, GA
01.2018 - Current
- Manage the behavior of players, coaches and crowd to facilitate gameplay.
- Adhere to and enforce game rules and regulations.
- Foster sportsmanship among players and coaches to minimize in-game conflict.
- Execute high-pressure decisions, award points and impose penalties under time constraints.
- Assist new referees with training and learning specific game rules and regulations.
Analyst
BNBC
Woodstock, GA
01.2014 - Current
- Created and maintain an Excel VBA based tool that updates currently foreclosure list with opening bids and marks houses that have dropped off the list.
- Provide ad hoc reports to owner upon request to evaluate AVR of homes.
- Analyze trends in volumes of homes on the foreclosure list in 13 counties.
Solution Support Engineer
Sprint
Atlanta, GA
04.1997 - 04.2021
- Created and maintained an Excel VBA based tool that optimized rate plans for current subscribers and estimated cost savings for switching cellular plans.
- Created and maintained an Excel VBA based tool that summarized all Sprint Rate plans for prospective subscribers in order to compare vs. their current providers rates.
- Partnered with Bid Management and Special Pricing group to ensure accuracy in pricing for Enterprise and Strategic RFPx's.
Education
Master of Science - Economics
Georgia Institute of Technology
Atlanta, GA12-1995
MBA - Finance
Georgia State University
Atlanta, GA06-1993
Bachelor of Science - Management
Georgia Institute of Technology
Atlanta, GA12-1991
Skills
- Power Platform - Power BI, Power Apps, Power Automate
- Office 365 - Excel, Word, Power Point, Teams
- Sharepoint
- Salesforce
- Excel VBA
- SQL
- Critical Thinking Abilities
- Business Process Improvement
- Project Scheduling
- Data Analysis
- Teamwork and Collaboration
- Organizational Skills
- Professionalism
- Problem-Solving Aptitude
- Time Management
- Excellent Communication
- Analytical Thinking
- Goal Setting
- Self Motivation
- Active Listening
Languages
Spanish
Elementary
Accomplishments
- Peak Award Nomination 2023
- Peak Award Nomination 2022
Affiliations
- Youth Basketball coach
References
References available upon request.
Timeline
Business Analyst Manager
T-Mobile
04.2021 - Current
Sports Official
North Georgia Amateur Umpire Association
01.2018 - Current
Analyst
BNBC
01.2014 - Current
Solution Support Engineer
Sprint
04.1997 - 04.2021
Master of Science - Economics
Georgia Institute of Technology
MBA - Finance
Georgia State University
Bachelor of Science - Management
Georgia Institute of Technology