ORACLE - PeopleSoft Practice
We offer a wide variety of expertise with all of the PeopleSoft tools,
and many of the application modules. From a tools perspective, we
are able to understand, and resolve problems you may have installing and
maintaining all the layers in the tiered environment. Our experience
administering Oracle, UNIX, NT and BEA Tuxedo provide a very solid understanding
of the architecture enabling creative solutions to the tough problems (or bugs).
Recent projects have included the following tasks:
 | Installations and Upgrades to PeopleSoft Release 8 and 8.4. We have recently setup customers on several different platforms, and product suites including HR/Payroll, Fin/Dist and Staffing for Front Office. Configure Web, App and Batch Servers on multiple UNIX and NT platforms. |
| Upgrade/Implement custom User Interface for Voucher Entry into PeopleSoft, calling PeopleSoft Component Interface to Express Voucher entry component(PT8.4x). This interface provides simplified access throughout the country, allowing easy access with minimal training. Of the 30,000 vouchers entered monthly at this client, 27,000 are input through this custom interface. |
| Upgrade/Implement Component interfaces to PeopleSoft's Inventory module to provide simple data entry screens for widely distributed access (700+ locations), by users with minimal training. |
| Custom PS Process Type for Native Crystal ODBC drivers. To allow the use of Stored Procedures, or data source other than PS/Query for reporting, we developed a program that uses the Crystal API and interacts with the PS Process Scheduler Tables. Progress and output may be monitored via the PeopleSoft Process Monitor like any delivered process. |
| NT Service to capture PIA usage information. Data may be logged to a database to take advantage of existing Crystal Reports. Service also can be configured to send alerts if App Server Queuing reaches critical threshold, or Process Scheduler is hung. We have also implemented similar monitoring for the UNIX environment, where App Server is run on UNIX. |
| Implementation of Real Time Barcode interface to PS Inventory module, using SymbolÔ RF scanners. This was developed in java using PeopleSoft's Component Interface (PT8.4x), and Symbol's WaveLink studio. Runs very nicely in a distributed environment: Warehouse in Florida, and PeopleSoft servers in Colorado. |
| Major Release Upgrades, Service Pack application, Fix installation and Payroll updates. |
| Performance Tuning all parts of the applications, including Cobol, AE, SQR, PeopleCode, and database objects. |
| Implement custom PS Process definitions to make Process Scheduler Jobs more fully functional. These included definitions for Job Paging, Email and FTP. |
| Conversion from PS HR/Payroll to Ceridian outsourced system. |
From the applications perspective, we have worked extensively with
HR/Payroll, Benefits, GL, AM, AP, PO, INV and AR modules. Also experienced
with the new Staffing for Front Office and PayBill Management installation.
Oracle Practice
We have a very experienced group of ORACLE specialists. Recent
projects have included the following tasks:
| Performance Tuning OLTP, batch and Data Warehouse applications. |
| VLDB implementation and maintenance of multiple Terabyte system. |
| Develop test plan for upgrading to Oracle8i for enterprise system. |
Some of our other Oracle skills used everyday include: SQL*Plus,
PL/SQL, Oracle Forms, Oracle Reports.
Oracle Web Practice
| Design and implemented web interface to large system with Oracle Web Server using stored procedures with embedded JavaScript and HTML. |
| Designed and developed a dynamic web page reporting application (Oracle Web Server, PL/SQL, JavaScript, HTML) which allowed specification of columns, criteria, and sort order. |
| Designed and developed and implemented Oracle Web Forms. |
OTHER
Unix - complex scripting, using common utilities/shells: perl, sh, csh, bsh, ksh,
sed,
awk, grep, find,...
SQL Server, Sybase, Informix, MS Access, Win95/98, NT Admin, Citrix