Doctors, patients, locations, bills, payments and transparent reporting must be the bullet points outlining this project. This custom application serves a user base of 30, runs 24/7 and is the mission-critical software for the business using it. From creating Timeslots to scheduling appointment to creating billing and collecting payments— all are managed. One part of this application is a website for doctors to see their upcoming patients. One of the main factors for this solution is the possibility to update and change the functionality of the application itself as the business needs and rules change. This goal has been reached with this solution. We are able to change and deploy within minutes’ notice. It is built using C# for windows to provide for a stable, fast, rich and user-friendly experience. The backbone/database of this application was realized in SQL Server 2005.
Iteon has designed and deployed innovative solutions for clients with exacting and demanding requirements for high-availability and site resilience, often leveraging virtualization to great effect. We’ve designed and deployed networks distributed all across the United States, rising to the occasion for clients who required both remote access and branch office VPN solutions - including fault tolerance, voice-over-IP and special traffic management requirements – at a considerable savings over competing proposals.
One of the country's largest charitable organizations managing tens of millions of dollars in energy assistance programs for economically disadvantaged families in California and Nevada approached iteon for help with writing the application to manage this energy assistance program. The original application was written in MS Access and would not scale to the needs of the organization. One of the requirements was to make the application accessible from 300+ locations and even over dial-up access. Utilizing Microsoft SQL Server, Microsoft C#, Microsoft ASP and Microsoft Reporting Services, we created a brand new version of the application. The final result was a highly scalable application that drastically reduces manual data re-entry and improved reporting capabilities for system users and the management.
This highly sophisticated and complicated system was a complete re-write of a system previously written in mySQL and Excel. Before we took a crack at it, it was taking about 18 hours for a user to process all data and generate reports each week. Our version of the system was migrated to Microsoft SQL server back-end database, MS Access front-end forms and Microsoft Excel for final reports. The system also integrates with Standard and Poor's Research Insight application for stock market historical data. The new version of the application reduced the processing time to about 75 minutes per week.
How do you integrate SQL Server, MS Access, mySQL, R, Matlab and MS Excel into one application? That is the secret mix we brought to this project. The functionality, well, we are not at liberty to disclose.
This application automates the e-mail communication from business to business. It enables a user to schedule e-mails with daily changing attachments. This a very helpful tool to use for daily or weekly reporting needs. An easy-to-use interface allows sending and verifying the status of sent e-mails and the whereabouts of the attachments needed for the e-mails. Having your PC do the work and remember what needs to be done are the benefits of this custom piece of software.
Bridging the divide between two stock analytical systems was the task at hand for this project. In order to facilitate this without compromising either installation, we chose to use Excel as the go-between to handle the exchange of data. This solution provides a transparent view of the data exchange’s workings. The familiarity of Excel was used to eliminate the need to learn yet another interface.
Iteon developed this application to manage all information about more than 100 clients in three different categories: institutional, individual, and advisors. Special attention was devoted to fully automate quarterly reporting. The application integrates reports generated by Moxy Advent and text blocks that are generated for each client or each client group. The result is the production of highly personalized, yet fully automated quarterly reports.
Patent lawyers are familiar with the pain of generating freedom to operate reports. Most of the time, a user ends up copying and pasting data from the USPTO website or other source into a Word document. This application copies and pastes data from USPTO automatically, presenting patent and claim information in a simple-to-use database and allowing lawyers to mark and annotate relevant patents and claims. The final result of the analysis is presented in a Word, Word Perfect or PDF "Freedom To Operate" document.
This .Net C# windows application allows for downloads of public USPTO patent information in a convenient, fast and robust way. We created a solution that enables a user to specify a list of patent numbers to be downloaded. With the click of a button, a multi-threaded web scraping of the patent numbers starts. Successfully downloaded patents are then parsed and transferred to an Access database that offers forms and reports for users to look over and mark patents to their relevance.
This application aids in report generation and distribution to limited partners for venture capital firms. The first step for this project was to import the existing data from a FilemakerPro database. The application consists of a “Limited Partner” database and report generation logic. Capital calls and quarterly reporting become an easy task with this application. The files needed are simply selected on a user form and then the application will handle the rest. Data files and templates are merged, PDFs are generated and then automatically e-mailed to their intended recipients. This application can be used not only for electronic communication, but also to print out reports, including labels to send documents by mail. The use of this application has greatly reduced the amount of time needed to comply with reporting needs.
This application manages hundreds of projects and 10,000 consultants providing work for US AID across the globe.
This is a web-based order management system for a residential kitchen supplier. The system serves six stores and seamlessly integrates with legacy accounting and inventory managements systems (Sage Business Works and Pervasive database). We had the pleasure of turning an existing Access database into a web application. This solution manages customers, orders, inventory and deliveries. A major benefit of this architecture is the ease of deployment: For a new location or employee, simply open a browser and access the application.
Here we created a simple and intuitive way to generate reports for executed trades in specific formats. This entire system is web-based and hence easily accessed from any PC. A bare Excel report for the trades is received by e-mail and saved on the local PC. Next, a user logs in to the application, selects the file and generates the reports, which can differ in format from client to client. As a last step, the application also provides a way to directly e-mail the reports and data files to the appropriate recipients.
In this project, we were able to connect graphs on Excel worksheets to PowerPoint presentations. You might think that this is no big deal, but with 10 Excel/PowerPoint pairs containing 20 graphs each that need to be updated on a monthly bases, the situation becomes more complicated. We programmatically linked the graph and data sections from the Excel worksheets to PowerPoint slides. The next step was to create a control Excel sheet that would provide a way to trigger these updates one at a time or all at once. Before the implementation of our solution, the process of updating a single PowerPoint would take close to half a day. Now updating one PowerPoint presentation takes one minute.
This solution pulls data from and pushes data to various financial Systems. Automated downloads gather data every morning, import, parse and calculate performance values for the previous trading day. This data can then be viewed in active Excel sheets. These sheets provide links to financial system to get real time pricing data. The major calculations are handled in the SQL backend database. The now parsed data is then also pushed out to Risk analysis systems. This application is also used to create compliance reports on a daily basis. These reports can be automatically e-mailed.
Recurring reporting needs stand at the center of this application. Rather then spending time on writing e-mails or calling people on the phone to request reports, we created an online reporting interface that handles this work. Recurring reports can be set up in the administration portion of this web application. They have associated templates for recurrence (weekly, monthly, quarterly, yearly) and the reports are added automatically as they become due. Reminder e-mails are sent at a set interval before and after the reports are due.
This project presented us with an opportunity to install and customize the Google Mini application and server. Files and folders residing on the local network are served through a web browser and are accessible within the confines of the network. Regular expressions are used to filter out certain folders with sensitive information. We also created a custom look and feel for our client, so that Google Mini would blend seamlessly into their IT environment.
As the title suggests, this application is all about exposing key information in an easy, concise and understandable way. This system gives the user the ability to specify files that are then exposed through the application. These files can then be viewed, e-mailed and printed. These files are also made available offline. Every time the application is started, all the files are downloaded to the local PC. The application does not stop here. Files in this system have a lifespan, meaning they get outdated and need to be changed. To aid in this, we color-coded all the files to create an alert. There is one more feature worth mentioning: We also have a way to show employee-specific files. This region of the application is protected and can only be accessed by supplying a valid username and password. The application directly communicates with the Active Directory in order to avoid creating a second login scheme for the users.
Need a web shop and don’t have a lot of time? Talk to us! This is how this project started: We were faced with the challenge of rewriting a web shop in a mere 3 weeks. This meant moving the inventory, a complete redesign of the pages, creating an order management system, providing a Content Management System, moving users and creating an e-blast to all the users of the web page. Rather then reinventing the wheel, we opted to go for an open source project and customize it to our clients’ needs. We are proud to say that the system was completed and running stable on time. The switch to an updated look and functionality has translated in noticeable increase in traffic and sales for our customer.
This application can be divided in three parts: download of data files, generation of reports, and report distribution by e-mail. Every morning, this service scrapes the specified web pages and downloads data. Next, custom reports are generated using the gathered data. Then these reports are sent by e-mail. The system can be administered and changed through a Windows user interface.
The first step for this client was moving from Windows 2003 and Exchange 2003 to Windows Server 2008 R2 and Exchange 2010 as well as SQL 2005 on a VMware ESXi server. Then, after that was done, we set up with a colocation site and used the internal DR functionality of Exchange 2010 and Sql2005 to replicate data over to the new colocation center. This was all done with 100% uptime and minimal cost