Services

Business Analysis, Process Design & Documentation
Web Application Development - ASP.NET / SQL
MS Access Application Development
Database Development - MS SQL Server
Software Systems Integration
Rapid Application Development - Visual Studio
Custom Enterprise Reporting - SQL2005 Reporting Services
Dedicated 24/7 Support Services
Contact John Ellwood to find out what ESI can do for you!
Back to Top Menu Business Analysis, Process Design and Documentation
    Business Analysis / Business Intelligence  
   

 

A software system is only as solid as the business analysis behind the effort.

Every project, regardless of the size, begins with some level of business analysis. ESI will focus on clearly defining crucial project requirements. ESI has extensive experience working with all levels of personnel to discover essential business intelligence, methods and workflow. After this analysis, ESI will discover and propose ways to use current technology to facilitate your business operations. If your internal IT team has already documented required business process and workflow, then ESI can get started on your solution right away!

 
    Business Process Modeling / Workflow Diagramming  
   

 

 

A successful system is fully integrated into your daily workflow. One way to define and understand this workflow, is to create visual diagrams that describe the roles and procedures involved in your business process. ESI is adept at creating these diagrams to serve as a system "map". These diagrams provide a visual tool that precisely identifies your business workflow, promotes internal understanding, and aides in staff training.

 
    Technical Writing / Help Files  
     

ESI will always deliver the documentation necessary to support an application. This documentation includes step-by-step instruction and is generally integrated into the application in the form of Help Files. Documentation requirements vary with every project, depending on your individual needs.

 
         
Back to Top Menu Web Application Development - ASP.NET / MS SQL Server
    Experience the power of ASP.NET !  
     

If you're running Microsoft server technology, you probably have all the software components you need to support a robust web application. Whether your business has a single office location or many offices across the country, internet technology offers great possibilities for all kinds of systems:

  • Improve the delivery of your services
  • Sharpen the efficiency of internal operations
  • Build a robust reporting platform
 
    SQL Server 2005 database under the hood !!  
   

 

Take advantage of the power that SQL Server offers. This database engine has really come a long way since ESI first began programming MSSQL in 1998. SQL Server 2005 is a great database engine that can be used to:

  • Drive robust web applications
  • Analyze and process data
  • Connect other data sources together
  • Create useful business reports tailored specifically to your needs
 
    Intranet  
     

An Intranet is essentially an "Internal Internet". If your web application is for internal use only, then a secure intranet platform can offer tremendous possibilities. An Intranet offers a centralized information resource for your entire organization. By centralizing information, organizations are able to create a consistent identity. Centralization also promotes the efficient presentation and collection of information. No organization should be without some kind of Intranet.

 
    Internet  
     

Everyone knows what the internet is, but ESI will help you understand how to use internet technology to improve your business. An internet application can provide a central information resource available to anyone with internet access. By providing a central location for sharing information efficiently, users know they have the most up to date information. Internet applications can be secured to allow only validated user access.

Once your data is being efficiently processed according to your business intelligence, the possibilities for reporting on that data is extensive.

 
    No servers or IT department? Outsourcing web application hosting is NOT expensive.  
     

There are numerous web hosting companies that are capable of hosting your robust database-driven web applications. Over the years, ESI has narrowed down a shortlist of ESI preferred providers. Depending on your specific hosting needs, ESI will match you with the most cost-effective, intelligent hosting provider.

 
         
 
Back to Top Menu MS Access Application Development
    Standalone database applications  
     

Although ASP.NET web applications are usually the best choice for business applications; MS Access database solutions can be a good choice as well. Access databases "stand-alone" because the database engine and user interface are all contained in the same MS Access file.

 
    Upgrade an existing MS Access database  
     

Many companies have MS Access databases in place that they are comfortable with, but as the size of the database increased over the years, the performance of the application has begun to degrade. In some cases, some minor revisions to the coding can improve performance. Generally, however, it makes most sense to upgrade the application to utilize a SQL Server back-end.

 
    MS Access front-end / SQL Server back-end  
     

The MS Access database engine does have it's limitations. At a certain point, you will notice database application performance begin to slow down. It is at this point where it would be wise, and fairly painless to create a SQL server database to store the "back-end" data, while maintaining the MS Access front-end for the user interface.

 
         
 
Back to Top Menu Database Development - MS SQL Server
    Data Scrubbing  
     

Garbage in, garbage out. I'm sure you've heard this aphorism before. Poor data integrity renders data systems useless, and in some cases potentially dangerous. ESI is adept at efficiently cleaning up or "scrubbing" data by using advanced database procedures. When ESI delivers an application, most clients chose to have all existing data scrubbed and uploaded. If your data is in need of extensive updating, ESI can help your internal staff manage and complete the update process. Once your data is scrubbed and uploaded, ESI will help you establish a workflow definition and establish a system for keeping data integrity high down the road.

 
    Custom Reporting - Data Mining  
     

SQL Server is an excellent tool for developing applications to bring together data from different, but related data sources. This integration often occurs between Accounting databases and databases or spreadsheets from other departments. By combining the power of SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) the possibilities for enterprise reporting grow dramatically.

 
    SQL 2005 Reporting Services - WOW!!  
     

Reporting services were available with MS SQL Server 2000, but with the release of SQL 2005 SSRS Microsoft has perfected an excellent platform for dynamic business intelligence reporting. SSRS enables the creation of sophisticated online reports, including excellent graphic charting capabilities. The most complicated report can be exported to .xls or a .pdf with ease. The free edition of MS SQL Server Express edition is all that is required to harness this power.

ESI takes SSRS a step further by embedding reports in ASP.NET web pages, so that they can be seamlessly integrated into your intranet or company website. Custom reporting tools can be as complex as the client requires. ESI reports and reporting tools always strive to be as simple and intuitive as possible.

 
    Database conversion/migration  
     

Some clients have already found the perfect software solution, they just need help transitioning from their old system. If data exists electronically, it can always be moved between systems regardless of platforms, somehow! I can plan systems migrations that utilize any available in-house resources and achieve a smooth, efficient transition to your new systems.

 
         
 
Back to Top Menu Software Systems Integration
    Connect and share your data  
     

Many successful organizations have grown on the innovation and entrepreneurial spirit of it's core employees. Oftentimes rapid growth leads to a growing gap between various databases and tracking systems that have already been put into place by your star employees. ESI often recommends an Intranet solution in order to centralize information for your entire organization. By centralizing information organizations are able to create a consistent identity. Centralization also promotes the efficient presentation and collection of information. No organization should be without some kind of Intranet.

 
    Enterprise Reporting  
     

No matter where your data is, SQL server, Access database, .xls, or Oracle; ESI can pull your data together and help substantiate business decisions with accurate reporting. Recent advances in SQL Server Reporting Services (SSRS) has opened new possibilities for reporting your data, including dynamic, drill-down charting components.

 
 
    Existing system customization / transition to new systems  
     

Some clients have already found the perfect software solution, they just need help transitioning from their old system. If data exists electronically, it can always be moved between systems regardless of platforms, somehow! I can plan systems migrations that utilize any available in-house resources and achieve a smooth, efficient transition to your new system.

 
         
 
Back to Top Menu Rapid Application Development - Visual Studio
    MS Visual Studio 2005 - ASP.NET 2.0  
      If you're running Microsoft server technology, you've got to get an ASP.NET website going! ESI uses MS Visual Studio to construct ASP.NET applications. MS Visual Studio enables ESI to complete projects quickly and efficiently, enabling ESI to pass these savings on to it's clients. Furthermore, by designing your ASP.NET application in Visual Studio, it will be easy to conduct further system development down the road.  
    Phased Approach  
     

ESI believes that the best systems evolve with time and use. New ideas for software systems can not be considered successful until they have proven themselves effective. For this reason, ESI believes in a phased approach for most projects. By breaking the creative process into phases, each phase can build upon the success of the previous phase. A phased approach also keeps ESI clients happy. Each phase will reach a new benchmark and add specific functionality to the overall system plan. Depending on funding and resources, clients can slow down or speed up the completion of project phases.

 
    Adobe/Macromedia - Studio MX Graphics  
     

While Microsoft's Visual Studio is definitely the best development tool for developing ASP.NET pages, ESI uses Macromedia/Adobe - Studio MX to build custom graphics as needed. Adobe is a recognized leader in graphic design and offers seemingly endless creative possibilities.

 
         
 
Back to Top Menu Custom Enterprise Reporting - SQL 2005 Reporting Services
    Enterprise Reporting  
     

No matter where your data is, ESI can use SQL Server Integration Services to pull your data together and enable robust enterprise reporting. Reporting services were available with SQL 2000, but the release of SQL2005 Reporting Services(SSRS) has brought Microsoft into the web reporting market. SSRS makes creating online reports much more robust, and includes excellent graphic charting capabilities.

 
         
 
Back to Top Menu Dedicated 24/7 Support Services
    Training  
     

ESI provides critical training for all delivered applications. Furthermore, ESI suggests that you choose an internal system administrator to provide in-house support. ESI will work closely with this person to be sure that all questions are answered in a timely manner. ESI is adept at preparing effective training materials and conducting training sessions. Your internal staff can use these training materials to provide training for new hires.

 
    Dedicated On-call Support  
     

One of the best attributes of internet technology, is that it enables ESI to immediately service its clients. Often your questions or issues can be answered or resolved online very quickly.

 
    Service Level Agreement (SLA) Deployment  
     

Most organizations prefer to have an in house point person trained, but ESI will also provide 24/7 on-call support as needed. Any dedicated support of this nature would be clearly defined in a succinct Service Level Agreement.