The purpose of this project was to augment existing systems to be able to allow TDS to report
on the current and future planned state of a given service location. This data is to be used
to steer an upgrade program spanning 10 years and 28 states. Most of the project work was
centered on combining spatial data from a GIS system with service location centric data. I
personally handled the augmentations for two applications within the ecosystem of effected
applications: SA Availability and SA SuperMetrics.
SA Availability is a read only GUI where users can see details about a service location such
as: what is the fastest speed TDS can deliver them, what network technologies are built to their
location, is there a planned speed upgrade for their area, etc. it has a wide user base, typically
across Sales, Operations, and Marketing.
SA SuperMetrics is an application software that derives location speed capabilities and best network
technology from basic service location data. This information is put into reports that the whole
organization uses, including Strategic Finance. This application also has a wide user base, typically
across Finance, Marketing, and Engineering.
This project impacted these and several other applications throughout the company, making additional
information regarding the upgrade program visible to the organization. It enabled better reporting,
providing a single source of data for all parties to work from, and making data visible that hadn’t
been derived let alone stored previously. The project took around 8 months from development to launch.
Process
Working on a team with a project manager, a tech lead, and several other developers, we used an agile
style task management system to efficiently communicate current issues and their progress during each
two week sprint. I primarily worked on SA Availability programming tasks, making updates to several
components within the web application. This includes inserting new data, maintaining the web page layout,
and improving certain button functionalities. I completed all of the tasks for this portion of the project
and submitted them for code review by the tech lead. He was pleased with the quality and speed of work I
produced, and assigned me to work on a higher risk task.
The SuperMetrics application was vastly more complex than the Availability application. I was left to
figure out most of the tasks on my own, and had to track down leads and coordinate with other people
and applications. While coding these tasks, I had to use a unique testing technique utilizing command
line to call to the service and produce report data, which I compared to the expected data. Going through
code review produced some bugs, which I was responsible for fixing. Along with updates to this application,
I was required to update and view from several database tables using SQL.
I was also closely involved with creating test cases. I made test scenarios for both of the above
applications, testing both the existing and newly added functionalities. Due to the complexity of
SuperMetrics, I was also responsible for executing the test cases for this application.
Skills
- C#
- HTML
- JavaScript
- ASP.NET
- SQL
- Command Line
- Testing Standards
Due to company policies I am unable to disclose any direct information regarding this project.