Top Gun Sports USA
When one thinks of the name "Top Gun", images of Tom Cruise screaming through the sky in an F-14 might come to mind. But there was a line from the 1986 blockbuster movie that rings true still today. It was said that being in Top Gun means you're the "best of the best". That is what founders of Top Gun Sports, Robin Phillips and Donnie Broome, are striving to achieve...and they are getting there fast.
- Jason Huddle , Cabarrus Business Magazine
Client Information
Client Description
Top Gun Sports USA is a North Carolina-based, travel baseball company (similar to little league) which offers a platform where teams can sign up to be paired against other teams to play at venues in tournaments ran by free agent regional directors throughout the year. Additionally they host special events that are open to players from all regions.
Client Size
- Employees: 11-50 Employees [playtopgunspots] [zoominfo]
- Annual Revenue: ~6-7mil yearly [TGS Database]
- Tournaments: held in 2024 [TGS Database]
- By sport:
- 300+ Softball
- 300+ Baseball
- By State:
- Virgina: ~31
- West Virgina: ~2
- North Carolina: ~523
- South Carolina: ~177
- Georgia: ~21
- Florida: ~11
- By sport:
- Teams: across all tournaments held in 2024 [TGS Database]
- ~11.4k Softball
- ~10.7k Baseball
- Players: across all teams in tournaments held in 2024 [TGS Database]
- ~145k Softball
- ~142k Baseball
'Players' represents a count of unique player-team combos, not necessarily unique players.
TGS Database Source
- Tournaments
- Teams
- Players
- States
-- Tourn count
SELECT
SportID,
COUNT(*)
FROM Tournament
WHERE startDate >= '01-01-2024'
AND StartDate <= '12-31-2024'
AND (CompletionStatus = 2 OR CompletionStatus = 3 OR TournamentName NOT LIKE '%cancelled%')
GROUP BY SportID
-- Team Count
SELECT
T.SportID,
COUNT(T.TeamID)
FROM Tournament TRN
INNER JOIN TournamentAgeGroup TAG
ON TAG.TournamentID = TRN.TournamentID
INNER JOIN TeamEntered TE
ON TE.TournamentAgeGroupID = TAG.TournamentAgeGroupID
INNER JOIN Team T
ON T.TeamID = TE.TeamID
WHERE TRN.startDate >= '01-01-2024'
AND TRN.StartDate <= '12-31-2024'
AND (TRN.CompletionStatus = 2 OR TRN.CompletionStatus = 3 OR TRN.TournamentName NOT LIKE '%cancelled%')
GROUP BY T.SportID
-- Player Count
SELECT
T.SportID,
COUNT(R.RosterID)
FROM Tournament TRN
INNER JOIN TournamentAgeGroup TAG
ON TAG.TournamentID = TRN.TournamentID
INNER JOIN TeamEntered TE
ON TE.TournamentAgeGroupID = TAG.TournamentAgeGroupID
INNER JOIN Team T
ON T.TeamID = TE.TeamID
INNER JOIN Roster R
ON R.TeamID = T.TeamID
WHERE TRN.startDate >= '01-01-2024'
AND TRN.StartDate <= '12-31-2024'
AND (TRN.CompletionStatus = 2 OR TRN.CompletionStatus = 3 OR TRN.TournamentName NOT LIKE '%cancelled%')
AND R.IsActive = 1
AND R.RosterTypeID = 3
GROUP BY T.SportID
-- State location Count
SELECT
L.[State],
COUNT(TRN.TournamentID)
FROM Tournament TRN
INNER JOIN [Location] L
ON L.LocationID = TRN.LocationID
WHERE TRN.startDate >= '01-01-2024'
AND TRN.StartDate <= '12-31-2024'
AND (TRN.CompletionStatus = 2 OR TRN.CompletionStatus = 3 OR TRN.TournamentName NOT LIKE '%cancelled%')
GROUP BY L.[State]
Points of Contact
- Chief Financial Officer, Co-Founder
- Robin Phillips (robin@playtopgunsports.com)
- Customer Service Manager
- Holly Gray (holly@playtopgunsports.com)
- Office Manager
- Kristen Hogue (kristen@playtopgunsports.com)
FortisureIT team
- Project Lead - Full Time
- Lucas Miller
- Developer / Client Soluions - Full Time
- William Waller
- Developer - Full Time
- Michael Shields
Please note that this list of team members may not always be perfectly up to date. If nothing else though, any member listed here should be able to direct you to the accurate, current members if this list is outdated.
Objective
Our goal for Top Gun Sports USA is to continue support of their legacy Visual Basic / .NET website (Play Top Gun Sports), which will hit its end of life date in 2027, while we continue to rebuild and migrate features to a more modern Next.JS website (Top Gun Stats).
Additionally, our original objective for Top Gun Sports USA was to create stats profiles for their players by leveraging data collected by coaches using GameChanger. We hope to continue to expand on this feature to ecourage more interest in the site and Top Gun Sports USA's events.
Altogether, our goal is to facilitate and increase entries and payments for Top Gun Sports USA's tournaments and events, and support the business critical tech features needed to host and run said tournaments.
Associated Technology / Stack
- Next.JS
- MS SQL
- Firebase
- React Beautiful D&D
- Authorize.net
- Visual Basic Modernization
Additional materials
Business Operations Graphic
