| Project Spotlight |
|
|
|
|
View example engagements of how our skills and expertise have benefited our clients along with successful projects and examples of software solutions we have recently completed.
Air ProductsCustomer Problem - They needed department by department reporting from a data collection server that monitored all plants activity. DEVsource Solution - We developed an Access applications that would pulled important data from Air Products® information server system allowing them to monitor, log, adjust, and report from each departments area. Result - Time lost from each department continually searching, manually inserting data and manually creating reporting saved much time, and also reduced manual errors. Our solution helped create much more efficient plant operations. Alcan®Customer Problem - Access database was slow due to the amount of data entered over a several years of use by assembly operators. DEVsource Solution - The solution that was decided upon and implemented was moving their current Access application data to a Microsoft SQL Server and converting their application to an Access Data Project which allowed the interface to remain the same and the data to be on an independent server. Result - Application Speed was greatly increased and data was now more secure. Also gained the added advantage of a more reliable data backup. Borg-Warner®Customer Problem - We having problems tracking worker sick day, disability and time off application payments for employees. DEVsource Solution -We extended their application by adding new rules, drop down list, and calendars supported with outstanding reporting capabilities. Result - They now can look at a week, view employees work history based upon shift, dates, days, and hours worked. Now the ability to see the employees actual work history aids greatly in the payment accuracy of all such claims or request. The time for manually looking at and for this data was reduced dramatically, now paired with the accuracy of employee work history the saving have been huge. Electric Energy®Customer Pain - Needed a better way to track and bill metered flow of electricity. DEVsource Solution - Created an application that actually retrieves meter readings in and out flows from hundreds of meters around the plant as well as tracking day to day reporting and logging to other regulatory entities connected to EEI®. Result - One happy customer, now in only minutes the dispatchers are able to bill exact energy flows as well as create energy schedules. Also with integrated reporting EEI® can now comply with regulatory requirements. Huge time savings benefit with this project. Holly Products®Customer Problem - Over time company had created multiple spreadsheets in different formats to track products and demo products. Because of the spreadsheet creation by numerous employees searching, finding, and reporting became a huge task. DEVsource Solution - Created an Access application to import over 50,0000 files in various formats into a very comprehensive database in a standard format. Result - Today they have a system that allows them to easily search fields, create, edit and delete data, combine these fantastic benefits with their new reporting features, our application added simplicity, accuracy, and reflects pertinent data and information. Honeywell®Customer Pain - New calculation techniques caused need for a better way of monitoring specific values without interruption regardless of format type and reporting them. DEVsource Solution - We created an application that electronically reported all monitoring stations across the plant. This update conformed to these new calculations and formats so that the information flow was consistent and without interruption. Result - Uses an Access database to track monitored values from various regions of the plant. These values are reported to several entities that regulate these values. Honeywell has had to change the process it uses to calculate these reported values several times, due to improved testing and understanding of the affects of the environment around their process. Since these values are reported electronically, we have been there to update their application to conform to these new calculations and formats so that the flow of this information continues without interruption. ICT®Customer Pain - Information was everywhere, and no one could ever find the "latest,” the “greatest” or even the last updated version of the data collected in Excel spreadsheets. DEVsource Solution - Various spreadsheets were consolidated into one Access database that automated the pull of data from collection server and updated all the calculations automatically. Result - No longer was there a reason for the duplication of data entry and huge time savings, but the new reporting functions reduced errors and improved decision making with better reporting capabilities and data accuracy. Ingersoll-Rand®Customer Problem - Part spec changes were not getting to all areas of manufacturing and changes had to be recorded in several different systems. DEVsource Solution - Created SQL application where with one entry all manufacturing plants across the US and Europe were automatically changed and key company personnel received email notifications on changes. Results - Costly manufacturing errors are now non-existent; every plant now has the latest product specifications and up to date pricing. Now one entry updates all systems. Huge cost saving, Huge time saving and Huge waste savings. Sportable Scoreboards®Customer Pain - Current business system only allowed for a one vendor shipping rate search. DEVsource Solution - Created a Carrier Quote tool. With this tool the salesman simply entered the weight of order and zip code of customer and the application automatically looked up a shipping cost from Five carriers of choice. Result - With this Carrier Quote tool shipping cost we reduced by the salesman’s ability to choose the most competitive shipping rate for the order. Now the sales staff can spend more time selling scoreboards and less time calling carriers. SteelCraft®Customer Problem - Needed a “Live” Inventory Production Tracking system with customized customer ID production notes integrating an AS400® and Oracle® database. DEVsource Solution - User needed to monitor inventories; the data was in an AS400® and Oracle® database. Wireless bar-coding scanners were mounted along production line and to fork trucks using .NET mobile applications. The application monitors the scanned the item, provides a generated “live” bill of material list that follows the item through production for specific customer wanted details as well as retrieving inventory information. Now they can control inventory live and automatically update inventory to order entry and sales. Result - They now have “Live” inventory records reported to AS400 and Oracle database. With custom noting throughout the production process errors have been completely erased. Total production and inventory control results in a huge cost saving for this company daily. Turbo® Compressor ServicesCustomer Pain - Quoting projects was becoming a huge task. Finding part numbers, in-stock information, and other highly important details was almost impossible because the data lied in many different places. DEVsource Solution - Developed a Quoting Tool that integrated with proprietary system. This tool extracted the data from other systems into our separate quoting system. This advanced quote tool assisted the salesman by providing accurate part cost and real time inventory status. This quote tool also aided in advancing “smart part” sales projections as well as lower part cost due to negotiations with vendors on estimated sales goals and better control of actual shipping and estimated delivery times. Result - A huge competitive advantage because quotes can go out faster, along with the additional benefit of smart part forecasting, sales projections, and higher levels of customer service. Wacker®Customer Pain - Company Headquarters abandoned support of application written by corporate IT. DEVsource Solution - Took old application and not only upgraded it to allow added reporting, modified data entry and enhanced user application but also upgraded it to Access 2000. Result - With the upgrade to Access 2000 users could utilize the applications new and better functionality as well as other enhancements. The applications has since been supported again by corporate IT as well as expanded use in other locations. Wagner®Customer Pain - Having to track information on products tracked by the state and based upon state regulations have to be sent electronically. DEVsource Solution - Wrote a complex application to track sales of different products with mixed reporting by area, salesmen, and region. Also automated the electronic delivery of that information to the state with (???) Result - Huge time saving for Sales manager as well as fast and accurate reporting to state, resulting in saving penalties and fines issued by state for late or non reporting (???) Westlake®Customer Problem - Accounting department wanted a way to rearrange report data generated by SAP®. DEVsource Solution - Access application that would import a CSV file, generated from SAP®, and then generate the report in desired format. Result - Today the accounting department at Westlake enjoys accurate, up to date customized reporting that can be shared among many divisions. Not only was this a time savings, but also helped streamline decision making processes. |



