ADOM Solutions, Inc.

efficient achievements

ADOM Solutions is proud to have provided a diverse array of software devlopments to clients whose business needs are just as varied. From Excel spreadsheets to complete proprietary systems...from home-based sole proprietorships to international corporations...ADOM has improved efficiency through custom software solutions.

Below is a partial list of our software experience:

CLIENT:	Chicago-based financial investment firm
PROJECT:	Develop new risk management application
TECHNOLOGY:	SQL Server 2000 database, C#.Net 2005, C++/CLI.Net 2005, Bloomberg .Net API, Microsoft Excel, NHibernate, Spring.Net
GOAL:	Client had internally developed a C++ library into which they needed to feed large amounts of data from multiple data sources including Bloomberg. Several outputs were desired including an Excel workbook with a series of charts.
SOLUTION:	ADOM worked with the business and development staff to design a Client/Server application that would work with each of the data sources and the C++ library to produce the desired results.

CLIENT:	Joliet (IL)-based group management organization
PROJECT:	Public website and secure group management application
TECHNOLOGY:	SQL Server 2000 database, C#.Net 2003, ASP.Net 2003, HTML, JavaScript, DHTML, and XML
GOAL:	Client wished to update their current website and create a central place for their group leaders to access up-to-date information, forms, and an events calendar. They also needed the ability for their leaders to complete and submit specific high use forms.
SOLUTION:	ADOM developed a professional website with a large amount of content for their public visitors. ADOM also developed a private, secured events calendar, current events area, and complete content management system that included maintenance and messaging features to maintain users, permissions, calendar events, and current events.

CLIENT:	Chicago-based financial investment firm
PROJECT:	Upgrade existing custom portfolio management application
TECHNOLOGY:	SQL Server 2000 database, C#.Net 2005, Crystal Reports 10, Infragistics Controls, NHibernate, Spring.Net
GOAL:	Client had an existing custom portfolio management application in need of major overhaul to meet the current needs of the business. The Client needed the new application to exist alongside the legacy application as features would be added incrementally.
SOLUTION:	ADOM worked with internal development staff to prototype, architect, and develop new custom framework to support all internal development. Additionally, ADOM developed client and server applications which communicate via .Net Remoting. The portfolio management client supports user viewing of all historical changes and integrates seamlessly with the legacy application, which is still in use. The reporting client is designed to deliver new Crystal Reports without changing the client.

CLIENT:	Romeoville (IL)-based professional services firm
PROJECT:	Excel data analysis
TECHNOLOGY:	Microsoft Excel, Visual Basic for Applications (VBA)
GOAL:	Client was seeking a solution to help analyze a rapidly increasing amount of data delivered in Excel.
SOLUTION:	ADOM provided training (including walk through videos) for client to utilize Excel features to accomplish analysis in a fraction of the time. After the initial training, ADOM created VBA macros to further analyze the data in fewer steps to decrease the chance for user error.

CLIENT:	Chicago-based financial investment firm
PROJECT:	Custom application and Customer Relationship Management (CRM) software integration
TECHNOLOGY:	SQL Server 2000 database, C#.Net 2003
GOAL:	Client had an existing integration between custom software and CRM application that they needed extended to include an additional, user maintained, set of information.
SOLUTION:	ADOM created a new application to coexist with the current custom software; the new application creates, maintains, and delivers the new information to the CRM application.

CLIENT:	Joliet (IL)-based manufacturing company
PROJECT:	Quoting and Accounting (Q&A) consolidation
TECHNOLOGY:	SQL Server 2000 database, C#.Net 2003, Microsoft Office Small Business Accounting 2006 (SBA 2006), Microsoft Excel, Visual Basic for Applications (VBA)
GOAL:	Client was maintaining their customer quotes in both their legacy Symantec Q&A (circa 1993) and their DacEasy Accounting software, neither of which was meeting their needs. Client wished to move to one system and make quote information easily available to office personnel without allowing access to other accounting information.
SOLUTION:	ADOM mined the historical quote information from the Q&A system and imported into SBA 2006 using custom C#.Net application. ADOM assisted in the import and configuration of the DacEasy data in SBA 2006. ADOM developed an Excel workbook with the ability to search and display the appropriate SBA 2006 quote information.

CLIENT:	Joliet-based manufacturing company
PROJECT:	Custom quoting remote-enabled software
TECHNOLOGY:	SQL Server 2000 database, C#.Net 2003, Crystal Reports 9
GOAL:	Client wished to extend to their new staff the ability to create quotes while maintaining accuracy. Client also needed the ability to review and create quotes while away from the office. Finally, client desired quote outputs that were more professional in appearance.
SOLUTION:	ADOM created a custom application from the ground up loosely based on the client’s previous application. This application utilized a main database within the office and an optional remote database installed on the client machines. The user interface allowed each user to log on, create, search, and print quotes and enter and maintain contacts and manufacturing specs.