projects managed by steve radusovsky
TRANSCRIPT
Platform
DataBase
Application
This application is a Sales EIS analysis tool allowing drill down capabilities for regional, product, and customer detail. Users are able to perform historical trend , forecasting, and drill-down analysis functions.
Pioneer Electronics Sales
Implementation of a Student Forecasting System using Informix on a Windows NT platform. The data to be accessed includes student information, student class registration, demographics and majors.
University of California, San Diego San Diego Office of Admissions and Registrar
Platform
DataBase
Application
Implementation of a Student Financial Aid Data Warehouse / Reporting System using Informix on a Windows NT platform. The data to be accessed includes student information, student/parent financial information, loan programs, and payments.
University of California, San Diego San Diego Office of Financial Aid
Platform
DataBase
Application
Implementation of a Student Tracking Data Warehouse / Reporting System using RDB on a VAX/VMS platform. The data to be accessed includes student information, class location, grades, and free lunch program.
Los Angeles Unified School District, Los Angeles Information Technology Division
Platform
DataBase
Application
VAX/VMS
RDB
Implementation of a Financial Reporting System using RDB on a VAX/VMS platform. The data to be accessed includes Cost Center information and campus expenditures.
University of California, San Luis Obispo Office of Technology
Platform
DataBase
Application
VAX/VMS
RDB
Implementation of a Financial Reporting System using DB2 on a MVS/3270 platform. The data to be accessed includes Cost Center information.
University of California, Irvine UCI Medical Center
Platform
DataBase
Application
MVS/3270
DB2
Cellular One Caller Forecasting
A Sun/UNIX/Informix application, that tracked all cellular calls and provided billing to customers, was converted. Data accessed included customer invoice information and cellular calls.
Platform
DataBase
Application
Intensive analysis on Guest History, Activity and Spending.
Hilton Hotels Guest Information Tracking
Platform
DataBase
Application
An AS400 back office accounting system for travel agencies was converted to this new environment to enabling users to perform historical trend analysis and carrier comparisons. Data accessed included customer invoice information, general ledger information, airline/car rental/hotel information, and agent commissions.
Unisys Uniview
Platform
DataBase
Application
Web-based summary and detail financial reports were developed from the Lawson Financial System (HR, Payroll), the JAMIS System (grant and research fund project tracking system), and CASCADE Systems (hospital stay tracking system). 4GL provided a web-based application that allowed a power user to manage row level security for a series of reports from the JAMIS system.
Cedars-Sinai Hospital Financial Analysis
Platform
DataBase
Application
United Airlines Credit Card Travel
Designed and developed a Data WareHouse to integrate charge data from American Express, MasterCard and ATC. The WareHouse accommodates over 500,000 – 3 million-charge transactions annually. Summary reporting showing quarterly, annual and/or YTD : Airline, Hotel, and Car Rental charge totals are available online, hard copy and e-mail.
Platform
DataBase
Application
Developed an Integrated Juvenile Justice and Treatment Information Network (IJJTIIN) to allow community agencies of the Pima Juvenile Justice Consortium (PJJC) and its future members to collect and share relevant information concerning juveniles. Both IBM and Brio technologies were used to develop a data warehouse/reporting environment for online access.
Pima County Integrated Justice System
Platform
DataBase
Application
Analysis of sales performance and usage statistics from web-based content delivery systems. A fully functional on-line decision support environment hosting a variety of novice to sophisticated users.
Elsevier Science – Harcourt Publishing Marketing
Platform
DataBase
Application
A Java based reporting and analysis system. Showing Court calendars and Case Management.
Los Angeles County Municipal Courts WebCourt
Platform
DataBase
Application
A Java based system. Contains demographic information for each Hilton property.
Hilton Hotels Hotel Information Database
Platform
DataBase
Application
A Java based system. Tracks product distribution and warehouse inventory.
Avery Dennison Product Inventory System
Platform
DataBase
Application
A global Java web-based clinical management system used for tracking subject enrollment in all Amgen sponsored studies. The Clinical Trials Forecaster (CTF) application forecasts and tracks site initiation and subject enrollment. It also provides reports comparing planned, forecast and actual enrollment data.
AMGEN Clinical Trial Forecaster
Platform
DataBase
Application
A Java based system. Process Private and Commercial Title and Escrow.
Fidelity National Title Title / Escrow System
Platform
DataBase
Application