SQL, PL/SQL
 |
SQL, Structured Query Language, is a database computer language designed for managing data in relational database management systems (RDBMS). Its scope includes data query and update, schema creation and modification, and data access control. It is the most widely used language for relational databases. The core of SQL is formed by a command language that allows you to retrieve, insert, update, and delete data, and perform management and administrative functions. SQL also includes a call-level interface (SQL/CLI) for accessing and managing data and databases remotely. |
PSA has successfully completed and delivered a large number of various projects.
PSA selects development approaches which meet specific business objectives of our
customers and help them to organize their business and technology strategies cost
effectively and in accordance with high quality standards. PSA's team of high skilled
professionals has a wide experience of software development using cutting edge technologies
and tools. Some projects accomplished by PSA are described and classified below.
 | The project aimed at performing implementation of a new product that determines user access rights on a Windows file system and providing a reporting interface to convey the results. The system includes a set of scanner services which scan a file system and active directory repository, all results go to the database on the server. Web based user interface on SilverLight technology allows managing the system, generating reports and getting quick information on user rights for some particular object. |
Access Rights Solution Data Sheet
Download| The purpose of this project was to update an inventory control system based on the Oracle tools including the Warehouse Management System (WMS) module. The goal for the project was to reduce the current number of inventory organizations from seventeen consisting of a main warehouse and satellite stores. The new system combines these into two separate systems consisting of one system for Generation and the other for Transmission and Distribution. To improve the tracking and tracing of items within the inventory the system allows printing and applying barcodes to inventory items. To expedite the inventory cycle count process the use of barcode devices is included. |
| This computer telephony IVR system allows callers to access their mutual fund account information via an IVR system. PSA designed and developed the IVR and Voice Mail system using Mediasoft IVS software development kit and Dialogic voice processing board. The IVR system allows a user to access account information and historical information. The voice mail system features are: allowing the caller to record voice messages, having a name associated with each mailbox, passwords protection of individual mailboxes, options to add new and delete old mailboxes. Custom features designed into the voice mail system were added to provide the caller with an option to listen, erase or re-record his just recorded message, recover deleted messages, include up to 9 personal greeting messages for every mailbox, message forwarding capability with or without comments attached, message notification and replaying feature, group boxes, message confirmation, directory search and a new User Tutorial. |
| The Hotline IVR (Interactive Voice Response) system informs customers of the latest news and information. Developed IVR accepts incoming and process outgoing calls. The implementation allows routing calls using DNIS (Dialed Number Identification Service). The application provides an option for the caller to be externally transferred. A welcome message greets the caller to the hotline after which the caller has two options: press 1 for more information and be transferred, or press 2 to return to a briefing message and be prompted again |
| The Outbound Calling System is a notification system that automates the process of transmitting messages. PSA designed and developed an Outbound calling system. This task was accomplished by reading a Microsoft SQL database input file. This file contained the telephone number to call and type of message to leave. If the call is successful (live person or answering machine is detected) in leaving the message, it writes the success to a log file, and moves on to the next record. If, for some reason, the service is not able to leave a message, it will retry until it successfully leaves a message, or it tries a total of 3 times for that record. If it reaches the maximum number of retries, it writes the call as unsuccessful to the log file and moves to the next record. |
| The project objective was to develop the prototype IVR (Interactive Voice Response) system and a web-interface for system management using Microsoft's Web Telephony Engine. The Registration IVR system allows a caller to register and be assigned an account number and password. Within the system the caller may add and update a variety of personal information, leave and retrieve voice messages with other users. The system also includes storing and retrieving caller information from a Microsoft SQL database. A custom web interface was designed for the system maintenance capabilities. |
| This computer telephony IVR application automates workshop registration and distribution of information. PSA developed an IVR system and complete the database design and implementation to handle storing of data and information for workshops, locations, and registration information. |
PSA's Contact
Learn more
Copyright © 1993-2010 Professional Software Associates,
Inc. All rights reserved.