Clear Connections Consulting
Computer Software, Websites, E-Commerce, and more!
Profile for:
Keywords
Username: clearconnections
Minimum Hourly Rate: $20/hr
Location: United States, Elmhurst
Summary
We are a small independent technology consulting firm located in the west suburbs of Chicago that is dedicated to providing your company the best service possible at the fairest prices. We have over 15 years of on-the-job experience with expertise knowledge in the publishing, insurance, and financial industries. We cater to all sizes of businesses, from the small business entrepreneur to Fortune 1000 companies.
We specialize in several areas and work on our projects in-house, thus saving you valuable time and resources.
We specialize in several areas and work on our projects in-house, thus saving you valuable time and resources.
Experience
About Us
Profile Type: Business
Year Founded: 1995
Number of Employees: 9 or fewer
We are a small independent technology consulting firm located in the west suburbs of Chicago that is dedicated to providing the best service possible at fair prices. We have over 15 years of on-the-job experience with expertise in the publishing, insurance, and financial industries. We cater to individuals, small businesses entrepreneurs, and large corporations.
Our team:
Robert Mattson, Director
Craig Haygood, President
Our team:
Robert Mattson, Director
Craig Haygood, President
Credentials
Certifications
Microsoft, Microsoft Certified Solution Developer
Awarded: 1998
Awarded: 1998
References
Raymond Mitchell - Personal Reference - 1999
The Foodservice Database Company, Owner
This project consisted of creating windows-based software for querying data on foodservice operators across the United States to run on multiple operating systems. I used Visual Basic 6.0 for the user interface. Microsoft Access 2000 was used as the database. COM ActiveX DLL components were created to facilitate business and database functionality. Crystal Reports 8.0 was used to create the reports and mailing labels for the software. This application is internet enabled so that software updates can be downloaded automatically.
I designed data flow diagrams, algorithms, and an ERD to construct the application. I met with the owner of the company and talked with a few key customers to gathering the requirements. I also created object classes to facilitate the business and database functionality. All phases of the project were documented.
Daily business processes were also re-engineered to increase productivity. The previous database systems ran under DOS and needed to be converted to Windows. A custom Visual Basic front-end with SQL Server 2000 running on the back-end was created to conduct day-to-day business. Computer and network upgrades were essential for operations to succeed.
In addition, an e-commerce website was also created in Classic ASP, using SQL Server 2000 for as the database. The website also encapsulated an administrative back-end which allowed data entry people to update critical publishing data. COM ActiveX DLL components were created were used to create the business and database functionality. These objects were run in the environment of MTS. JavaScript was used on the client-side to validate the data so that round-trips to the server were saved. The website has both consumer and administrative interfaces for administering the website as well as updates to all publishing data.
A major upgrade is currently taking place to port the code from Visual Basic 6 to Visual Basic 2008 using Visual Studio 2008.
The Foodservice Database Company, Owner
This project consisted of creating windows-based software for querying data on foodservice operators across the United States to run on multiple operating systems. I used Visual Basic 6.0 for the user interface. Microsoft Access 2000 was used as the database. COM ActiveX DLL components were created to facilitate business and database functionality. Crystal Reports 8.0 was used to create the reports and mailing labels for the software. This application is internet enabled so that software updates can be downloaded automatically.
I designed data flow diagrams, algorithms, and an ERD to construct the application. I met with the owner of the company and talked with a few key customers to gathering the requirements. I also created object classes to facilitate the business and database functionality. All phases of the project were documented.
Daily business processes were also re-engineered to increase productivity. The previous database systems ran under DOS and needed to be converted to Windows. A custom Visual Basic front-end with SQL Server 2000 running on the back-end was created to conduct day-to-day business. Computer and network upgrades were essential for operations to succeed.
In addition, an e-commerce website was also created in Classic ASP, using SQL Server 2000 for as the database. The website also encapsulated an administrative back-end which allowed data entry people to update critical publishing data. COM ActiveX DLL components were created were used to create the business and database functionality. These objects were run in the environment of MTS. JavaScript was used on the client-side to validate the data so that round-trips to the server were saved. The website has both consumer and administrative interfaces for administering the website as well as updates to all publishing data.
A major upgrade is currently taking place to port the code from Visual Basic 6 to Visual Basic 2008 using Visual Studio 2008.
