SM Computer Consulting Ltd

Overview of Services from SM Computer Consulting...

SM Computer Consulting is a small company that prides itself on its ability to provide innovative software solutions for all your mainframe needs. Being small means that SM Computer Consulting is flexible in its approach and is totally focused on client satisfaction. SM Computer Consulting is based in Cardiff - the gateway of Wales - but has the ability to integrate its services into the client premises anywhere in the Country or throughout Europe. Our staff has extensive experience of providing software consultancy on multiple mainframe platforms for a variety of blue chip companies.

These include:

British Broadcasting Corporation (BBC)

British Telecommunications

British Gas

SW Water

G. E.

ICC Bank (Ireland)

Corus - formerly British Steel

SM Computer Consulting also has experience in working within local government and the newly deregulated power industries for water, gas and electricity.

SM Computer Consulting has a well-defined software development process that has been followed successfully for many years. All staff sent to the client site will be fully conversant with ISO 9001 and will produce full documentation for all deliverables to the client's requirements and standards.

Software consultancy services provided by SM Computer Consulting include

* Custom development and re-engineering.

* Application Maintenance.

* Production support.

* Application conversion and enhancements.

* Year 2000 services.

* System testing.

* Package evaluation

* Documentation services

The technologies covering these services are:

* IBM mainframe

* ICL mainframe

* IMS

* DB2

* IDMS

* Flat file architecture

* COBOL

* Easytrieve

* Mantis

* PASCAL

* FORTRAN

* BASIC

SM Computer Consulting has over 14 years' experience of project based support and development, and has direct knowledge in the following system areas :-

* Payroll

* Pensions

* Accounting (accounts payable and receivable)

* General Ledger

* Order Handling

* Cash-less transactions

* Billing

* Banking

* Manufacturing

Further information concerning any information contained in this document can be obtained from

SM Computer Consulting

95 Beale Close

Danescourt

Cardiff

CF5 2RU

Or by phoning (029) 2030 6733

Current availability is from April 2002

Overview of recent contracts

Oct 2001- April 2002

South West Water, Exeter

Pos. Analyst / Programmer

4 month Contract + 2 month extension

South West Water are currently preparing to migrate their Customer System from the ICL mainframe onto a bespoke package from Rapid Systems Ltd

To date approximately 20+ programs and sub-routines, file handlers have been written to download data into CSV files for upload onto the new package.

Machines Used : ICL Mainframe under VME

Languages : COBOL, SCL

Others : Flat files

May 2001 - Sept. 2001

GE Capital, Leeds

Pos. Analyst / Programmer 3 month Contract + 1 month extension

The main task on the e-payables banking project was to automate a General Ledger postings procedure.

On the client's books clawback entries had to be made to reflect the differences between the actual and estimated book amounts for each invoice (The difference in currency movements between when an order was placed & when the invoice was paid). On GE Capital's shared services ledger entries had to be made to debit invoice amounts from the client, credit & debit the relevant currency clearing accounts, initiate funding payments between clearing accounts and account for any currency movements with balancing entries.

'T-account' reports were produced to show the net effect on each account.

Machines Used : IBM Mainframe under VSE

Languages : COBOL, Easytrieve, JCL

Others : VSAM

Nov 2000 - April. 2001

Tyco Electronics, Stanmore, London

Pos. Analyst / Programmer

5 month Contract

Worked on the Tyco GEARBOX project. This was an automated cross-company ordering system. It allowed for the real time raising of orders on the buying site, automatically generate the inter-co purchase order, send it to the supply site and book automatically into the receiving sales system.

Machines Used : IBM Mainframe under VM

Languages : COBOL, JCL

Databases : DL/1

Others : CICS, VSAM, Selcopy

May 2000 - Oct. 2000

ICC Bank, Dublin

Pos. Analyst / Programmer 5 month Contract

Initially worked to produce management print reports in COBOL and Easytrieve that were downloaded via Monarch into Excel. There the data was merged with data from other sources to produce a statistical analysis of the banking executives' performance - complete with graphs, etc.

Also wrote and amended on-line and batch transactions in the bank's main enquiry system - OSCER - that encompassed the full range of banking activities from client requests, through disbursement and releasing of funds to cheque production or credit transfer.

Machines Used : IBM Mainframe under VM

Languages : COBOL, Easytrieve +, JCL, MANTIS

Databases : DL/1

Others : CICS, VSAM, VMLIB

Nov 1997 - Nov 1999 HYDER

Pos. Analyst / Programmer 4 x six month Contracts.

Worked on HCS(E) Electricity system, initially working on Accounts receivable (ARC) process. My responsibilities included:-

1) The analysis of input from 14 tapes (Tokens, Midland Bank, DHSS, Post Office, etc) then wrote specifications for 14 suites of programs to allocate financial activity to a customer account or allocate to suspense. All suites allocated activity via one central process and then reported on errors / warnings and produced a proof list. Consulted with the appropriate team’s business representatives to produce High Level Design & Physical Design documents.

2) Leading and mentoring a team of 6 programmers to code and unit test and finally link test each suite before passing to system test and user acceptance test. I was also responsible for writing and testing some application suites myself.

3) Writing multiple interface programs between IDMS DB and GUI front end (VB and SQL 7 server Unix box) to extract and update data for customer services (HCS(E)) system. The back end processing was all COBOL and maintained on IDMS Data Base.

4) Performing maintenance for all general problems reported from system test

Machines Used : ICL Mainframe under VME

Languages : COBOL, Application Master (AM), SCL

Databases : IDMS

Others : DDS, Alta-data, T-plan

Aug. 1995 - Nov 1997 LOGICA PLC

Pos. Consultant

Worked on Colossus Project based at BT, Cardiff. The project objective was to speed up the clearing of over 1000 faults on the main Customer Services System (CSS). This system is the largest IDMS database in Europe.

Had some exposure to RAD methodologies. Ran separate project doing same task for Marketing system. Eventually took over maintenance and development control of Cashless (Phone Chargecard system) adding new functionality to the existing system as well as rationalising some existing functionality.

Machines Used : IBM Mainframe under VSE

Languages : COBOL, Easytrieve, JCL

Databases : IDMS

Others : CICS, VSAM, T-plan, Xpeditor, Infoman, DML, TSO, ISPF

Courses : DSDM, COBOL II, CICS, DB2, TSO, ISPF, JCL, VIASOFT year 2000 software tools and methods jogger