=

desalasworks presents:

a selection of works by steven de salas

Barclays PEDM Application

PEDM is a commercial application for internal-use of Barclays Private Equity.

This AJAX-based web application is used daily to track information about ongoing and historical deals.

Functional Enhancements to Barclays “Private Equity Deal Manager” application

PEDM version 4.0 release included functional enhancements to support entering post-deal lifecycle investment data including ownership breakdown by legal entity, financial instrument detail and historical transactions.

This release also included some advanced features such as reporting of investment snapshots, portfolio analysis (rate of return calculations) and auditing and version snapshots with roll-back capabilities.

The new ‘Investments’ section developed for Barclays Private Equity Deal manager v 4.0.

The new 4.0 version of Private Equity Deal Manager includes capabilities for adding post-deal Investment information and collating this information for managing a portfolio of Private Equity assets.

Imperial College Service Desk

A web front end for existing Imperial College Service Desk software so that users can access the problem ticketing system and check status directly.

Designing the Landing Page

  • Contents of landing page are largely dictated by existing application
  • Marval API is used to link up with core CGI and database.
  • Users are able to create tickets or view existing requests.

Imperial College Service Desk

Template for Adding Incidents to the Database

  • Query information is largely based on existing database fields
  • Interaction via CGI into Marval Database
  • Once form completed, a new incident is flagged and forwarded to the Service Desk or the appropriate IT person.

Imperial College Service Desk - New Problem

Template for Viewing Current Incidents in the Database

  • Screen allows current users to read into existing Service Desk database.
  • Its possible to update current problems so as to notify relevant staff in charge of this problem.

Imperial College Service Desk - View Problem


Imperial College PC Shop

Online PC shop for Imperial College staff and departmental needs. Featuring a bespoke administration interface capable of expanding the product range.

Developing the Landing Page

  • Purchasing Process based on a 5 step “wizard” configuration to improve user experience
  • Project Developed in ASP Classic, Javascript and SQL Server

Imperial College PC Shop - Main

Completing the Purchasing Process (Confirm Order)

  • Pruchase process completed
  • Order Confirmation Email sent to user
  • Details of the order are stored and forwarded to procurement department

IC PC Shop Confirm Order

Designing the Administration Interface

  • Add New Products, Edit and Delete Existing Products.
  • Integrated into existing Imperial College web templates.
  • User Interface simple and easy to use.

Imperial College PC Shop - Admin

Nandos’ End of Day Uploads

A daily upload process carried out by each of Nandos’ stores that copies daily Point-of-Sale information into a central database repository for analysis.

Start of Process

  • Nightly process run by store manager
  • Launched as a popup with pass-though authentication (POST variables)
  • Pushes data from local Point-of-Sale system into central database

Nan

Nandos End of Day Completed

  • Wages Information, Cash Registry & Inventory File uploaded from local till system into central database
  • Data insert using BULK INSERT (TRANSACT-SQL)
  • Data parsing is performed on SQL server using stored procedures for faster execution.

Nandos - End of Day Completed

The TOTE

E-Commerce website featuring access to TOTE’s central betting database, performed system integration and UI enhancements an ongoing project to improve the web portal of this well-known bookmaker.

Creating The Front End

  • Front end design and implementation with a Javascript Dropdown menu
  • Enabled web access to betting data held in a proprietary database.
  • Project was coded in Classic ASP and Javascript.

TOTE Betting Site