Description

The Jeopardy Code Analyzer or "Jep Leaderboard" is a project I created during my third internship at AT&T. My team was tasked with working with Sales and finding areas in need of improvements in regards to efficiency. As Sales works with potentially thousands of Support Requests a day, they needed a way to organize SRs with problems that needed to be closed. Jeopardy (Jep) Codes were created to help with this.

So that my team could better pinpoint areas in need of improvement in Sales, I created the Jep Leaderboard. It takes in thousands of lines of SR information, including any attached Jep Codes, and analyzes it to create a spreadsheet summary. The spreadsheet has a breakdown of which departments submit the most Jep Codes, indicating that they may need more assistance or a different way of categorizing codes.