Consumer Products Company – SQL Database Analysis
- Business Problem – The client needed to find, document, and analyze all SQL Server databases currently operating within their corporate network to simplify support issues.
- Solution – Excell analyzed and documented the existing database server and databases to create and implement disaster recovery plans. This improved the supportability of their infrastructure as well as reduced their support costs.
- Technologies Used – MS SQL Server
Back to Top
Event Management Company – Event Registration and Collaboration Tool
- Business Problem – This client plans and manages events for groups of 10 - 10,000 attendees. They needed a registration tool that would be scalable and customizable to address the needs of their diverse customer base. They also needed to allow for changes in the look and feel of the registration process. Their existing tool, developed in ASP, COM/DCOM/COM+, and MS SQL server, required custom development for every event.
- Solution – A web-based application using the .NET framework was designed and developed to support these requirements. This application utilized Web Services and a dynamically generated interface to address scalability and customization needs.
- Technologies Used – C#, ASP.NET, ADO.NET, MS SQL, XML Web Services
Back to Top
Facilities Management Company – Handheld Inspection Application
- Business Problem – The client manages facilities for large organizations around the U.S. Their inspectors periodically inspect these facilities to evaluate the condition of building exteriors, interiors, and fixtures. Prior to Excell’s .NET solution, they would process all inspections on paper and then manually enter that information into a tracking system.
- Solution – Excell designed a custom application that ran on handheld Pocket PC devices that allowed inspectors to record data while they were inspecting the facilities. The inspection notes fed into a custom database and integrated with the client’s order tracking system. The automated process significantly reduced the client’s paperwork and reporting capabilities.
- Technologies Used – Embedded Visual Basic, Pocket PC 2002, ERWin, MS SQL Server, ASP, ADO
Back to Top
Government – Office XP/Windows XP Migration
- Business Problem – Our client was facing significant challenges with the management of over 650 desktop computers. These workstations were running various versions of the Windows operating systems, including Windows 95, Windows 98 and Windows 2000. They also had an older version of Office which required an upgrade, as well as over 100 applications, scattered across the computers, which needed to be migrated.
- Solution – Excell developed an image and migration strategy to significantly reduce the complexity of support issues and Help Desk calls. They also designed and tested a system image that would work across all of the client’s computers. The solution minimized the client’s number of incoming support calls to reduce costs, improved consistency among the computers and applications, and increased support efficiency.
- Technologies Used – Windows XP, Office XP, MS SMS
Back to Top
Government – Enterprise Application Integration and Quality Assurance
- Business Problem – Our client had the need to implement, test, and deploy the upgrade of a large-scale, mission-critical system. This upgrade was a multi-version effort that involved the modification of a large custom code base, as well as numerous new modifications and enhancements. Additionally, the new system was web enabled, as opposed to the client/server architecture used in the previous version.
- Solution – Excell provided planning and strategy consulting services through the project planning phase. Excell was engaged to provide the following services:
- Creation of the project plan
- Assist with the determination of required resources
- Align project objectives with available time and personnel resources
- Provide guidance and practical knowledge of quality assurance processes and best practices
- Assist with the creation and implementation of a reusable test management infrastructure to facilitate testing efforts
- Execution of knowledge transfer to the appropriate personnel at the end of the engagement
Back to Top
Technology Company – Mobile Device Distribution Application Development
- Business Problem – The client needed a system to configure, ship and track mobile devices that are sent to internal/external customers. They also needed to provide product managers the ability to request shipment, change configuration parameters, and to quickly view and manage their device pools.
- Solution – Excell created a web-based application utilizing the .NET architecture with a SQL Server backend to process orders and track the locations of the devices. This custom application allowed the program managers to handle requests anytime, anywhere. The application launched via a web page (ASP.Net and C#) with a drag-and-drop interface and intuitive navigation. This increased efficiency for the product managers by providing an automated solution for processing their devices.
- Technologies Used – C#, ASP.NET, ADO.NET, MS SQL, XML Web Services
Back to Top
Technology Company – .NET Survey Application
- Business Problem – In an effort to measure customer satisfaction, the client needed to create an application capable of easily surveying thousands of employees with over thirty questions. They also needed to filter customer responses as they were received, as well as have the capability to reuse the application for future surveys.
- Solution – The solution modified the existing client satisfaction survey application which resulted in a 60% cost savings. The new survey was designed to be entirely driven from a SQL Server database without any static pages. All questions and answers were stored in database tables with a web interface to allow for easy creation and changes. Questions were rotated automatically each time a new user accessed the survey. Additionally, the survey gave the user a constant update of their progress (percent complete). The final solution created an efficient, scalable process for the group to complete their surveys with quick turnaround.
- Technologies Used – C#, VB.NET, ASP.NET, ADO.NET, MS SQL
Back to Top
Software Company – New Version of Commercial Software Product
- Business Problem – The client had acquired a competing company and needed to update their software with new functionality and bug fixes. They had challenges with working with the original source code, as they had little documentation or resources from the acquired company.
- Solution – Consultants analyzed existing source code, developed the project scope to fix all of the existing bugs, and provided product enhancements.
- Technologies Used – C/C++, COM, Visual Test
Back to Top
Technology Company – Corporate IT Tools and Analysis
- Business Problem – A variety of IT tools had been deployed to manage individual aspects of the client’s systems. In order to make better decisions about how to best deploy and manage these IT systems, they needed to correlate information from these tools into unified reports.
- Solution – The solution provided analysis and development services for tools and applications to support the corporate IT team. This included design of a SQL database which included queries, reports, and management of the input and output information. The solution also validated data integrity via imports from other data sources. The overall solution centralized the client’s data in a single location for easy reporting purposes.
- Technologies Used – VS.NET, VB.NET, ASP.NET, SQL Server
Back to Top
Technology Company – Website Search System
- Business Problem – This website is maintained by hundreds of the client’s business units around the world. United only by the website’s search feature, the client needed to improve their existing search functionality for performance, accuracy, and crawling content to increase the coverage of searches inside the website.
- Solution - The project team created a service-oriented search engine to be used across all of the sites and systems that make up the website. Specifications required millisecond search response time throughout a complete .NET architecture. The result was a rapid, efficient solution that increased ease of navigation and search capabilities.
- Technologies Used – SQL Server, C#, VB.Net, ASP.Net, ADO.Net
Back to Top
Technology Company – Subscription and Billing Business Intelligence System
- Business Problem – The client’s Subscription and Billing organization has responsibility for billing internal groups for usage of corporate computing assets. These assets include bandwidth, storage space, processing requirements, printing, backup systems, and support personnel. They needed a way to create a single report and charge-back system for all of these expenses.
- Solution - Excell designed and implemented a tool that provided reporting analysis for the group. This project involved creating a new environment; migrating existing data to the new environment; testing data transformations from existing scenarios to the new warehouse; and designing and documenting the mapping process for conversion. The solution improved efficiency for billing processes and centralized the reporting data for the client.
- Technologies Used – SQL Server, VB, ASP, ADO
Back to Top
Technology Company – Online Seminars (.NET Show, VBTV)
- Business Problem – The client creates a variety of seminars from their production studios which they distribute through a variety of channels (e.g., CDs, conferences, subscriptions, and web).
- Solution - Excell builds online seminars for the client including the monthly .NET Show and VBTV. In addition, Excell documents and maintains updates for media presentations and production processes.
- Technologies Used – VS.NET, VB.NET, SQL Server
Back to Top
Technology Company – .NET Seminars
- Business Problem – The client wanted to promote their .NET strategy and tools for use in the development of custom business applications. They faced challenges in providing business and technical audiences with the information required to make decisions about how to make use of .NET.
- Solution – Excell provided custom .NET seminars on behalf of the client for customers around the Northwest. This involved interviewing customers to determine their existing architecture, projects, and constraints as well as developing and presenting a custom day-long seminar based on requirements. This ongoing service saves significant time and expense for the client.
Back to Top
Parking Management Company – Business Application
- Business Problem – The client was running a commercial application built in MS Access to process notifications. To effectively communicate with various DOL offices, they had built several custom interfaces to handle the growing number of notifications. However, their customized systems were reaching capacity, causing system performance to deteriorate.
- Solution – Excell designed a .NET Windows Forms solution to address these challenges. The new system included customized interfaces for each state, integrating information cleanly into the central database. The application’s SQL Server backend and Web Services middle tier infrastructure provided the client with a scalable application that met their need for scalability, flexibility and reliability.
- Technologies Used – C#, VB.NET, ADO.NET, MS SQL
Back to Top
For more information regarding any of these solutions or for more information on how Excell can help you address your business challenges, please contact us at info@excell.com.
