Portfolio: Best Software & Database Design, Development & Programming
The projects listed below are only a small representation of Kinetik I.T.’s portfolio of clients, projects and expertise.
Project: SalesWorkz – An Enterprise Level Custom CRM Application
Industry:
Information Technology
This enterprise application utilizes an advanced user interface and several other programs such as Outlook, Word, and MapPoint, to produce a full feature contact and sales management tool. Its inception was to resolve two major issues
the company had with its existing contact management tool ACT. First, ACT has very limited options of implementing business rules and processes. Second, ACT does not provide an easy way to view a company’s organizational structure. With its open architecture and customizable user interface, SalesWorkz resolves the issue of not being able to implement business rules and processes. To implement an organizational structure view Kinetik I.T. designed a company form to allow the user a quick and efficient way to review specific details about a company’s locations, departments, and contacts. Also, included on the form is a graphical tree view representation of this structure. Account Executives are assisted with predefined questions in various categories to help qualify leads and discover opportunities. An overnight process recalculates certain client parameters, and schedules routine follow-up calls.
Expertise: Analysis, GUI Design, Database Design, Microsoft SQL Server, Visual Basic, VB.NET, C#, Microsoft Interop Forms Toolkit, Infragistics Controls, SQL Server Reporting Services, Crystal Reports, Outlook, Word, MapPoint.
Project: Examination Tracking System
Industry: Examination Board
The company administers certification exams throughout the year in states all across country. The Examination Tracking System guides the company in this work, handling all data on the exams, candidates, schools, and examiners. Following an exam, the software is used to report scoring results back to the various parties, as well as for statistical analysis, such as evaluating an examiner’s grading habits.
Expertise: Analysis & Design, Database Design, Microsoft Access, SQL Server.
Project: Sales Incentive Plan
Industry: Hospitality
The company needed an application for hotel goal setting, achievement tracking, and incentive award calculation for their sales force. An entirely Excel based solution was a requirement because users had a strong affinity for Excel, and little time for learning new software. The workbooks also needed to support the complexity found at very large hotels without creating unnecessary complications for the smaller, simpler hotels. The resulting implementation makes heavy use of Visual Basic automation to dynamically create and modify pages to fit the needs of the hotel. Updates to business rules throughout the year were made using a lightweight Visual Basic application that modified the hotels’ workbooks without harming the data contained therein. Installation files and updates were distributed and tracked through an ASP web site application, enabling project management to see which files were in use at each hotel. User support was handled with a Frequently Asked Questions (FAQ) web site that could be accessed from within the Excel workbooks as if it were a sheet in the workbook. This database-driven, ASP-based Web page provided up-to-the-minute news and online help whose content could be easily updated by the support staff. When the users accessed the FAQ web site, information about their local installation was automatically recorded in the database to facilitate the technical support team. Kinetik I.T. also supplemented the support team, so hotels could get quick answers to their questions from the developers who created the application. This application was first rolled out in 2001 and was such a success that it was redeployed with only minor changes in subsequent years.
Expertise: Analysis & Design, Database Design, Excel, Visual Basic for Applications, Visual Basic, Visual InterDev, ASP.NET, Active Server Pages (ASP), Microsoft SQL Server, Microsoft Access.
Project:
Food-Show Database
Industry: Manufacturing &
Distribution of Food & Food Related Products
Kinetik I.T. designed and implemented a Microsoft Access
database to facilitate the printing of various reports used at the
company’s semi-annual Food Shows. The database allowed the 1500+
vendors to view and update their reports while at the show.
Expertise: Analysis & Design, Database Design, Microsoft Access.
Project:
Pension Check Information Submittal Application
Industry: Financial Service
Administration
The company needed to send Pension Check information to their bank on a monthly basis. The bank
expected to receive this information in a particular format, and required encryption. Kinetik I.T. built an
Microsoft Access database application that implements the four steps involved. First, we extract raw data from CYMA accounting package using a custom Crystal Report. Then, we transform that data to the format required by the bank. In step 3, we use the public key encryption features of PGP to encrypt the file. Finally we use FTP to send the file to the bank’s mainframe.
Expertise: Analysis & Design, Database Design, Microsoft Access, PGP, Cyma, Crystal Reports.
Project:
Import, Viewer and Web Viewer Applications
Industry: Data Entry Services
The company is one of the Southwest’s largest data entry service providers. They needed a way to import large amounts of data from their legacy data entry systems into a SQL Server database so their employees and clients could view the data. For security reasons the project was broken apart into three different applications. An import application was designed to validate and import data from comma-delimited text files into a SQL Server database. A viewer application was created to allow employees to view records and related tiff files using a sophisticated filter menu. A web viewer application allowed easy and secure access for DCA customers to review their data and tiff files.
Expertise: Analysis & Design, Database Design, Visual Basic, Microsoft SQL Server, Active Server Pages, Secure Sockets Layer, Infragistics Controls.
Project:
Chemical Analysis Program
Industry: Water Analysis
The company performs drinking water analysis services for municipalities and water companies. This application named CAP replaces a paper- and Excel-based system that had become unmanageable. The new version is very flexible – for example the user can create a new contaminant that needs to be tracked. It can import lab results in various formats and presents a uniform view to the user. The application also maintains the sampling schedule and has automated triggers for out-of-bounds values. CAP has several reports including government-mandated Chain of Custody.
Expertise: Analysis & Design, Database Design, Implementation & Installation, Microsoft Access.
Project:
Service & Claims Database
Industry: Insurance
The company provides extended warranties to auto owners.
The company utilizes a number of Clipper DOS based applications to manage the company’s data that they originally developed several years ago. The new Microsoft operating systems are no longer supporting DOS based applications and
the company wanted to rewrite the applications utilizing
Microsoft Access. The Service and Claims Database tracks insurance claims by policy holders, the approval process, and the drafting of checks. Some Clipper tables were converted to
Microsoft Access, others needed to stay in Clipper until other applications were migrated as well. The application has about 30 tables and 40 forms. A considerable amount of time was spent normalizing and scrubbing the data from the old (virtually absent) design to a normalized relational database.
Expertise: Analysis & Design, Database Design, Implementation & Installation, Microsoft Access.
Project:
SPARKLE Enterprise Activity Tracking System
Industry: Media
The company acts as a media placement broker between television stations and advertisers.
The company’s revenue is based on product sales resulting from successful advertising campaigns. The SPARKLE application allows
the company to efficiently place shows with stations and to track all orders received by partnering telephone sales companies. The system generates contracts and placement instructions automatically, processes order data from the telephone sales companies, and generates & distributes activity status reports to all interested parties. Financial information is exported to QuickBooks to streamline account/payable activity. The SPARKLE system replaced a workflow largely driven by manual labor and subsequently saves
the company 40 labor hours per week, in addition to improving data accuracy and information turnaround times. .
Expertise: Analysis & Design, Database Design, Implementation & Installation, Microsoft Access, Microsoft Word (for generating contracts), Microsoft Outlook (for report distribution), QuickBooks Integration.
Visit our Corporate Resume for Custom Software, Database & Web Application Design, Development & Programming.