Sprint Corporation is one fo the biggest telecommunications company that provides wireless services and is an internet service provider. We worked on the following projects with Sprint:
- TITAN system
3 interface – web, windows and blackberry platform based solution for wireless provider to let their field technicians to perform preventive maintenance inspections. Web services were used to synchronize data between the 3 platforms. This was the next release of the PMI System mentioned below and was embraced by Nextel Communications first as a national tool for cell-tower maintenance inspections as well as by Sprint after their merger with Nextel Communications.
A nightly process to import data for several different text, csv and excel files on the network and consolidating it in a relational SQL Server database. The program used SQL Server Bulk import within the C# code and each file (some were more than 200 MB) was imported in less than 90 seconds. The program also queried the client’s Oracle database and imported additional information in the SQL Server database as well.
- Outlook Add-in
Created an add-in for Microsoft Outlook to enable General Business Resource Center (GBRC) agents to archive their emails as activities to SQL server 2000 database. This enabled them to archive the required data using 2 clicks directly from their outlook interface instead of using the web-based application to add the activity. The web-based interface was written in ASP
- Preventive Maintenance Inspection (PMI) system
Web-based solution for wireless provider to let their operators do cell-tower preventive maintenance inspections on their cell towers. A number of business rules were required to be implemented to decide if the inspection was complete and if it qualified for a monthly/quarterly or annual inspection. This project done in 2001 enabled our company to get much bigger projects with Nextel.
- PMI Client server
Client application to mirror the web-based application that allowed the inspections to be done offline and then the data to be synchronized with the main database using SQL Server replication techniques.
Technologies used : C#.NET, XML, Web services, SQL Server, LLBLGenPRO for data access layer, ASP, , VB 6.0, COM+, MSDE