US Open/ Yipeee Web-based and Mobile Application
Challenge: Yipeee Inc required an application which allowed the management of over 500 Service Professional, required the applications to be mobile, and needed to produce invoicing and reporting on a daily basis(Real-Time), and some processes needed to be conducted within an outdoor environment.
Technologies: SQL Server, Windows mobile, SQL Replication services, Asp.net C# Web Application, SQL Reporting Services
Solutions: Developed a robust application which allowed Yipeee staff managers to collect time from various locations with the US Open venue and synchronized data over a wireless connection utilizing Windows Mobile technologies. When synchronization was complete a asp.net web based application allow the creation of invoicing and reporting which allowed HMG to manage hundreds of staff members and clients for the event seamlessly.
The General Contractors Association of New York (GCA) Web 2.0 and Reporting Application
Profile: In New York City, there is one organization exclusively devoted to the issues facing heavy construction contractors: the General Contractors Association (GCA). Since 1909, the GCA has been a strong and forceful advocate on behalf of its member contractors who build the foundations and transportation and utility infrastructure that define New York City.
Acting as an authoritative source for industry, government, and the region’s opinion leaders, the GCA has dedicated itself to promoting infrastructure investment, private development, fair contract provisions, enhanced bidding opportunities, and a safe work environment.
Challenge: The GCA required a way to manage Members and Government Projects which have been awarded to members and non-members. The data is maintained by a third party and the GCA needed to import the data in a efficient and coherent way on a daily basis. The application also needed to maintain historical data of past projects to allow GCA analysts in-depth insight into project bid to better assist members. Requirements of the project also included the ability to maintain invoices, contact information, and union information.
Technologies: C#, ASP.Net, Ajax, SQL Server, MS Reporting Services
Solution: SupersumWeb developed a Web 2.0 application for the management of member data and gave staff a efficient way to import and enter data on a daily basis. The project also integrated a ad-hoc reporting solution to allow GCA analysts to view data in various dimensions and create new reports when needed. The web application was developed with a modular architecture to allow for the expansion of new features.
Vanuatu Marine Time Desktop Data Management Application
Profile: Vanuatu Maritime Services Ltd is a privately held Vanuatu company operating under contract to the Vanuatu government as the Maritime Administrator. VMSL operates the central registry office and handles all details of vessel registration, mortgage recordation, crew documentation, and all matters relating to safety and proper vessel inspection and documentation.
Challenge: Vanuatu was in need of improving an existing application which manages the documentation and registration of large tanker vessels. The current implementation was an Access database which lacked on performance, functionality and usability. Some users had familiarity with MS Access and wanted to know if it was possible to continue using a similar UI for reporting.
Technologies: SQL Server, Access 2003 + 2007, VBA
Solutions: Utilizing the services available in SQL server and maintaining a MS Access User Interface Supersum was able to develop a robust application which allows Vanuatu and its staff to generate report without the use of a developer. The end result was a multi user network application which solved all of Vanuatu’s issues.
HMG Web-Based Staffing Management Service
Challenge: HMG, a premier staffing company based in New York City needed a way to consolidate various software solutions which was used to manage events, produce invoicing, and communicate with Service Professional.
Project: When Supersum was approached all managements was done using many different application such as Excel, Quick Books, CaterEase Staffing software, and email. Supersum was approached to develop a solution to overcome all the white noise associated with the management of hundreds of events and service staff.
Technologies: SQL Server, ASP.Net C# Web Application, a various third party UI components
Solution: Developed a web based application which allowed clients to submit requirements of a event, track staffing status, and Invoicing. The application also allowed service professionals to manage a calendar of events staffed to, Track time and payment, and allowed communications with HMG for cancellations and acceptance of events booked to. A third component was also developed to allow Yipeee a window to view and manage all activities occurring within a event. Currently the application supports 100- 200 users per day.