CURRICULUM
VITAE
for
Paul Raymond
Miller
July
2004
|
Name |
... |
Paul Raymond Miller |
|
Address |
... |
Haughton, ST18 9EU |
|
Telephone |
... |
(07000) AS/400 Home Alpha Tel: +44 7000 271400 (0700) iSeries Work Alpha Tel: +44 700 4737437 ** All Numbers Include 24hr Messaging Service |
|
Fax |
… |
|
|
Email/Web Address |
... |
Web: HTTP://www.Millennium-Computers.Uk.Com Email: Paul@Millennium-Computers.Uk.Com |
|
Age |
... |
37 yrs |
|
Date of Birth |
... |
12th June, 1967 |
|
Marital Status |
... |
Married |
|
Children |
… |
Niamh Ann Miller, Born 28/8/98 Grace Elizabeth Miller, Born 27/8/03 |
|
Availability Date |
... |
3rd October, 2005 |
|
Preferred Locations |
... |
Anywhere in |
|
Qualifications/Courses |
... |
HNC - Computing HNC - Business Studies HNC - Mathematics HNC - English NVQ - Sports & Leisure ATS - SQL/400 Course (ADB3) ATS - Net.Data Power Course (ACG3) |
Hobbies & Interests |
... |
Golf, Music, Football, Computer Games, Snooker, Pool, Scuba Diving, House DIY & Cars |
Comments
Paul has over twenty years IT experience working predominantly within the Mid Range arena specialising in Systems Analysis/Business Analysis/Programming/Technical Consultancy roles, his RPG skills span 13 years including RPG2, RPG3, RPG4, ILE, RPGSQL, RPG API’s and RPG CGI’s. His specialist skills include over 11 years experience of Banking, Finance and Stock Brokering/Share Dealing.
Not be ignored are his excellent PC skills which include PC communications with the iSeries/AS400 (session and file transfer), as well as PC package familiarisation (Packages include DOS, Windows 95/98/NT/2000/XP, PC/Support, ClientAccess, Rumba, Office, Word, Excel, PowerPoint, Access, Internet Explorer, Outlook, The Web, Basic Programming Language & some HTML/JavaScript Programming)
Paul has the ability to work on his own initiative and also to work constructively within a team environment.
|
Current Company |
... |
TD Waterhouse – |
|
Role |
... |
AS/400 Senior Technical Lead/Technical Consultant/System Analyst |
|
Duration |
... |
3rd June 2002 – 30th September 2005 (1 months Notice Period) (Initially 6 Months) |
|
Hardware Used |
... ... |
AS/400 & iSeries 9406 Models 730e, 640e & 170e (Domino Server). HP Pentium III PC’s & Laptops |
|
Software Used |
... ... |
RPG/ILE, SQL/RPG, CL, CL ILE, OS/400 V4R5, V5R1 & V5R2, ClientAccess, Query, DFU, SQL/400, Net.Data, RPGCGI, Thenon, ACMS, Robot, MiMiX, DataMirror, Figaro (Stock Broker System), S1/Fire (UK/Dutch Regulatory Reporting), ICBS (Fiserv Banking System) V7.2, Transaction Manager (TranMan), CRS, BranchTeller, PT2000, i-Point, ATMOS, Base24 and Visa. Windows XP, 2000, NT4,
Office2000, IE6, Lotus Notes & Domino.Doc |
|
Job Description |
... |
|
|
I am currently contracted to ‘TD Waterhouse’, who launched “TD Waterhouse Bank NV” in December 2002. I was originally contracted as a Lead Technical Analyst for the launch of the Bank. This involved Banking Analysis, Testing Analysis, Technical Support, Go Live Scheduling, Data Conversion, Banking Support and Coding (using RPGLE, SQL, Query, CL, SDA & DFU). My initial role included assisting TD Waterhouse in launching TD Bank on December 16th 2002, using Fiserv ICBS (V7.2), CRS (V3.2), BranchTeller, TranMan (Middleware Layer), JHC/Figaro (Stock Broker Software) and X-Link (In-house x-ref Layer). My first task was to review all the available documentation from TDW, Fiserv and JHC. Which included Business Requirements, Functional Specifications, Technical Specifications, Test Plans, Change Control, Source Control and Conversion Plans. My role also included reviewing all Testing Scripts/Procedures and produce a testing gap analysis. Scripts reviewed included Tax Withholding, Section 17 & 18, R85, S352, Tax Certificates, ATM, POS, Visa Base2, Base24, TLF (Transaction Log), PBF (Positive Balance File), CAFX (Card Account File), CAS, TCAS, CARS (Natwest Txn Files), DDI (Direct Debits), SOI (Standing Orders), GCI (Giro Credits), CCI (Cheque Credits), BGC (Bank Giro Credits), ARUDS, ARUCS, AUDDIS & ADDACS. To draft an ICBS Disaster Recovery and High Availability document, making use of MiMiX (journaling) and an extra AS/400 for DR/HA. This used the existing ICBS Extended Availability Level 2 option from Fiserv. To draft a conversion plan based on a single conversion weekend to convert 450,000 existing Figaro customers into ICBS customers. This involved pre-conversion tasks (queries, counts and reports), complete conversion of all required data (reports, counts and totals), Go/No-Go planning and disaster recovery/contingency plans. To spec/build spreadsheets required to assist in the testing of Interest Calculations, Interest Back Valuations and Interest Accruals. To oversee the testing of ICBS clearing inbound from Natwest (via I-Point Software) and outbound to Natwest (via BACS). To implement and manage an ICBS Change Control Process. Which involved writing procedures for change control, management of changes, implementation of changes, documentation and filing of forms. This was achieved using word and excel. Source control is maintained by using two products, first is ACMS (Aldon Change Management) for all Fiserv code releases and second is Thenon for all JHC code releases. Lastly it included support of the live banking system, aid in banking reconciliation, support S1/FiRE reporting, and support bank clearing via BACS/I-Point and general support. Since January 2003 I have been working for the Broker section of TD Waterhouse as a senior systems analyst. My role includes producing Gap Analysis from BRD, Analysing BRD requirements, building Functional and Technical Specifications from BRD, System Testing Deliveries, producing testing schedules, test plans, supporting of business testing and supporting of the live implementation. Projects in this role have included eContract Notes (share contract notes via email in PDF), eCorporate Actions (corporate actions via email), Corporate Actions Workflow System (using Delphi, SQL, Web and iSeries), Covered Warrants, Additional client conversions/data loads (for NatWest/RBS to ICBS), Corporate Actions (replacement of manual system), Fraud Mitigation & Reporting, Ad-Hoc Statements (web based online statements), reconciliation of Bank/Broker GL’s, Corporate Nominee (for Natwest Joint Venture) and conversion of Magnetic Stripe ATM cards to Chip & Pin. All the above AS/400 and iSeries programs, modifications, specifications and test plans were written to the TD Waterhouse Technical standards and all code was released using Thenon (for Figaro) and Aldon CMS (for ICBS). |
||
|
Company Name |
... |
Egg Plc – Dudley, |
|
Role |
... |
AS/400 Senior Analyst Programmer/Team Leader/Technical Consultant |
|
Duration |
... |
4th January 1999 – May 2002 (Initially 6 Months) |
|
Hardware Used |
... ... |
AS/400 & iSeries 9406 Models 730e, 640e & 170e (Domino Server). Dell Pentium II 333 PC’s & Laptops |
|
Software Used |
... ... |
RPG/ILE, RPG/IV, RPG/400, SQL/RPG, CL, CL ILE, OS/400 V4R5 & V5R1 (release notes only), ClientAccess, Query, DFU, SQL/400, Net.Data, RPGCGI, ACMS, Robot, MiMiX, JDE 7.3 & ICBS (Fiserv Banking System) V9502 & V9521. Windows2000, 98, 95, NT4, NT3.5, Office2000, Office97 , IE4, IE5, MS Mail, Personal Communications, Adobe GoLive 5.0 & Test Director 5.0 |
|
Job Description |
... |
|
|
I was last contracted by ‘Egg’, who were wholly owned by ‘PRUDENTIAL BANK’ until June 2000, when they were floated on the London Stock Exchange. My first task was to implement a complete set of standards, which included “Programming Standards Guide”, “Test Plans”, “Promotion Forms”, “Source Control” and “Assessment Test” (for new recruits). I took over the AS/400 Development Team Leader role. This entailed controlling the flow of work from the business into a manageable form and assigning an analyst/programmer. Ensuring the work was estimated correctly, then Spec’d/Coded/Unit Tested/UAT’d and finally promoted to live. My role also included maintaining team time sheets, holidays, sickness, self-certification forms, training programmes and general day-to-day people management. My own work involved the spec/build/test an AS/400 interface, which extracted all Mortgage/Loan applications and processed them through the Hunter fraud system. This system had to retrieve Mortgage/Loan information from the core AS/400 ICBS system, whilst matching with a PC based GUI front-end application taking system. This information was then passed to the Hunter system via FTP, so that each application could be checked for fraud. To build/test a bolt on a Section 352 Tax Deduction Certificate extract, which would trawl through all ICBS interest payments, calculate gross interest, tax and net interest for each customer and print an Egg/PruBank Tax Certificate on 6th April. This also had to cope with any online tax certificate requests, during the normal day-to-day processing. To spec/build/test an AS/400 component, which allowed a Middleware Service Object (via TOPEND) to retrieve statement/balance information from ICBS and pass back to an Internet component which allowed customers to process account enquiries via the Web. To spec/build/test an AS/400 component, which would accept a Unit Trust (sell/buy/transfer) or ISA instruction from an Internet component, via Middleware and post the relevant transaction to the ICBS banking system. This was done by interfacing via an API to the built in ICBS Teller functionality. To spec/build/test an AS/400 interface, which extracted all GL movements in ICBS on specific accounts, to extract to a PC package for Auto Reconciliation of the General Ledger. To spec/build/unit test an AS/400 interface, which received an incoming file of internet transactions (including Share Purchases, Share Sales, Dividends and Regular Savings) and process them into the ICBS AS/400 banking package. This was done using a number of API’s, that in turn use data queue processing. This functionality allowed customers with an internet connection to control their bank accounts with more flexibility and allowed them to make/sell/transfer share investments. To spec/build testing tools for stress testing the AS/400-Middleware-Internet links. To allow thousands of account creation, account maintenance and transaction maintenance functions, so that stress/performance testing can be checked. To spec/build/test an interface from the ICBS Banking System General Ledger to the J.D Edwards accounting packing. This interface replaced the current interface, which was out dated and slow. To help/support all of the Y2K “Millennium” testing in the bank, including Base System & Interfaces to/from AS/400. To support Fiserv’s off-site team and aid them in fixing any code problems arising during day to day processing. To be on call for overnight processing in case of problems. To work over “Millennium Night” from 10pm till 10am. We set our development AS/400, to the 24/12/99 (1 week previous) and restored of all live data, tested all comms links (including Middleware & The Internet), just in case the AS/400 died, which of course it didn’t. In fact we only had minor problems with BACS and LOCKBOX CHQ’s. Which I sorted out on Sunday morning and even this was nothing to do with the date, just a weekend sequence number problem. To modify the 352/TDC, which I built in 1999. To cater for new tax reporting changes. To help with the Egg Plc float preparations, with reports on numbers of customers, accounts, funds under deposit, funds on loan, trends (account open, closed and movements month by month), etc. etc. To spec/source and implement an AS/400 BACS solution, so that the current solution using Checkpoint could be scraped. This involved sourcing suppliers of AS/400 BACS Software, arranging demos and evaluating the software. The solution chosen was called “BACSTEL” from Grange Systems. Egg also purchased the BACS CHECKER, which is an API product, to validate bank account/sort code combinations. This was used to validate the entire standing order database on a monthly basis. To spec/build/unit test an auto-reconciliation package for ICBS. This would allow some of the more larger suspense accounts to be automatically reconciled, instead of using a manual tick back. This involved picking up the contents of a number of key GL accounts, then trying to match these transactions with what had been processed on previous days, using spool files & database files. To help/oversee the
implementation of MiMiX on ICBS. MiMiX was implemented to image the live
AS/400 database onto the DR AS/400 in To spec/build a Cheque Master Database, including write/update functions and full reporting on screen/printer using interactive SQL RPGLE to select/build subfile for drill down. To spec/build/unit test a system, whereas all Credit Card balance transfers transactions would need to be re-routed to FDR (Egg’s Credit Card Management Partner). So when the BACS arrived at Egg, these transactions were matched against the original request for a Balance Transfer and a new TAPTRANS file was built and sent to FDR. To spec a Chaps processing system, including extracting of chaps payments, transmitting to HSBC for processing and retrieving any responses/acknowledgements. The system used Unix type files in the iSeries IFS accessible via a set of System API’s. To look into some of the new programming techniques available for the AS/400 and iSeries, including Net.Data and CGI. This included testing the new techniques against Egg’s current methods for retrieving data from DB2 (Middleware). Some sample CGI programs were written to access customer’s accounts, statements and transactions. These proved a lot faster and easier than the current middleware option and are currently being investigated as a DR option.
All the above AS/400 and iSeries programs, modifications, specifications and test plans were written to the Prudential programming standards (which were written mainly by myself) and all are Y2K compliant. The AS/400 and iSeries program code changes were applied using the ‘Aldon Change Management System’, which controlled program versions, environments, projects, etc. My contracts with Prudential and Egg have been very valuable to me in terms of banking experience and E-Business Experience. I now understand more of how an E-commerce bank works, I have a full grasp on everything from Current/Savings Accounts to Loans/Mortgages/Personal Loans right the way through to Amortisation, Accruals, Capitalisation, Compound Interest, Overdraft Processing, Cheque Credit Processing, Revolving Credit, etc. I also now fully understand how the General Ledger works and the way money is transferred between accounts. I also gained some very valuable skills, including SQL, CGI, Net.Data and ILE. I really enjoyed these contracts. |
||
Contract
Assignments
|
Company Name |
... |
Fiserv Europe Ltd. - Dudley, (Software House on Client Site ‘Prudential Bank Plc’) |
|
Role |
... |
AS/400 Analyst Programmer |
|
Duration |
... |
3rd June 1996 – 22nd December 1998 (Initially 3 Months) |
|
Hardware Used |
... |
AS/400 Model 310 & AS/400e 640 Dell PC’s |
|
Software Used |
... ... |
RPG IV, RPG/400, OS/400 V4R2 & V3R1, ClientAccess, Query, CL, DFU, SQL/400, ACMS & ICBS (Banking System). DOS 6.2, Windows 3.1, Windows98, Windows95, WindowsNT3.51 & NT4, Office97 (Including Word97, Excel97, Powerpoint97, FrontPage97/98, Access97 & Outlook97/98), Internet Explorer3/4, Netscape3, Lotus Organiser 2, Word 6, Excel 5, Microsoft Mail, Internet Mail & Internet News. |
|
Job Description |
... |
|
|
I was contracted by a software house called ‘FISERV’ who were, in turn employed by ‘PRUDENTIAL BANK’ to supply/modify their own banking software called ‘ICBS’. My primary job was to complete the software changes for the ICBS system, so that it conforms to the Bank of England Licensing requirements for the Prudential Bank, in time for the 1st October 1996 launch (which was done successfully). This involved new amendments to the ICBS system so that all transactions (incl. Withdrawals, Deposits, Notice of Withdrawals, Penalties, Inquiries, Etc.) can be processed on one screen, this modification was called ‘Transaction Capture’, also amendments/fixes to the ICBS system which included Capitalisation, Penalties, Accruals, Amortisation, Standing Orders, BACS, CHAPS, Direct Debits, Withdrawals, Deposits, Current Accounts, Savings Accounts, Time Deposit Accounts, Personnel Loans and Mortgages. To fix a number of minor and major bugs in the general day to day running of the software. These fixes range from simple screen/printer layouts though to capitalisation/accruals not calculating correctly on the 29th Feb and a number of modifications/tests for the year 2000 (year 2K) ‘The Millennium’ modifications. To code and test changes to ‘Transaction Capture’, to allow the batching of Deposits. Which allowed user’s to balance a day’s batches, alter/fix any incorrect postings, etc. To code and test changes to ‘Transaction Capture’, to allow posting to/from General Ledger Accounts. This also allowed the transfer of funds from/to General Ledger Account to/from other accounts. To code and test an interface
from ICBS to ‘CHAPS’ (Clearing House Automated Payment System). This
involved allowing the user to process Loan disbursements as well as standard
transactions via CHAPS. These transactions would be picked up at the end of
day processing and sent into an interface file. This file would then be
transferred out of the bank to the clearing house ( To spec a change to ICBS, for Unpaid Direct Debits. Which allowed the system to post corrections automatically to the customer’s accounts and the correct any GL accounts required. This system had to cope with Unpaid Cheques, BACS & CHAPS payments. To code and test an enhancement for Loyalty Bonus, where a customer will receive a bonus amount, for staying with the Pru for a specific length of time. This was calculated by the time account opened and balances of account, the longer the account was open for and the more money deposited, the more bonuses the customer received. All the relevant reports were also changed to cater for this new bonus (Statements, Reporting, Tax Reports, GL Reports, Etc.). To code and test modifications for Prudential’s New Bank called ‘Egg’ launched on 11th October 1998. Modifications included an ATM card system (using ICBS EFT & ATOS) and splitting reports/enquiry’s by bank so that both ‘Prudential’ and ‘Egg’ could run using the same database, the same programs and more importantly the same software license. To code and test an enhancement for Account Withdrawal count, which is where a customer will have a number of free withdrawals from notice accounts. Where no penalty is calculated if the notice period is short, after which the std system of charging a penalty for any notice shortfalls will be used. All the above AS/400 programs, modifications, specifications and test plans were written to the Fiserv programming standards (which are in turn ISO9000 compliant, including Y2K compliance). The AS/400 program code changes were applied using the ‘Aldon Change Management System’, which controlled program versions, environments, projects, etc. |
||
|
Company Name |
... |
Dun & Bradstreet - |
|
Role |
... |
AS/400 Senior Analyst Programmer |
|
Duration |
... |
2nd July 1995 - 31st May 1996 (Initially 3 Months) |
|
Hardware Used |
... |
IBM AS/400 Advanced 300 & 200, B60 & B45 IBM Facsimile/400 & IBM ImagePlus/400 IBM PS/1, PS/2 & WANG |
|
Software Used |
... |
RPG IV, RPG/400, OS/400 V3R1, V3R05, V2R3 & V2R2, ClientAccess, Query, CL, DFU, UIM, SQL, OfficeVision/400, XINAS/400, Sequel/400, DOS 6.2, Windows 3.1, Windows95, Visual RPG 1.3, Word 6, Microsoft Excel, Microsoft Powerpoint, OS/2 Warp & LS/400 v1.2 (SOP System). |
|
Job Description |
... |
|
|
On my return to Dun & Bradstreet, I was involved in using an SQL/400 report writer called ‘SEQUEL/400’ which allows the IT department to write complex reports using multiple files and fields. I was involved in using ASNA Visual RPG (my personal copy) to convert a couple of inquiry programs to run in a native windows environment on a PC connected to an AS/400 using CA/400 and ASNA Datagate, this was to help Dun & Bradstreet decide when/if they should purchase VRPG as a PC programming tool for AS/400 programmers. (which I believe, they have purchased in July 1997) My biggest project was to write a new contact management system for the telesales department, so that they could keep track of their contacts and prospects. Some of the information stored about each contact included name, address, telephone, fax, contact names, follow-up date & conversation history. Their was also a lot of new information to be stored about the contact/prospect which included Type of Business, Where Trading, Turnover, No. of Accounts, Profit, Lead Source, Why Calling, Bad Debt, etc. This extra information was used for mailshots e.g. All Contacts/Prospect who replied to an Advert in THE TIMES on 5/3/96, Etc. This system had to have full help text on every field, so that even new users could quickly understand the system (this was achieved by using AS/400 Panel Groups). Also a user guide was produced using Word 6 & PowerPoint. This system also had a lot of D&B Information Sheets (including products, prices, sample reports, sample accounts, etc.) scanned onto the AS/400 (using IBM ImagePlus/400), then merged with a choice of fax covers (including covers for new customers, existing customers, friendly customers & free format), then finally all the salesperson’s signatures were also scanned into the system, these were merged with the fax covers to make them a little more personal, the completed fax was then automatically faxed out the customer or prospect using the AS/400 Autofax Facility. I was then put back onto LS/400 fixes and modifications. All the above AS/400 programs and modifications were written to the Dun & Bradstreet programming standards.(which included Year 2000 (Y2K) ‘The Millennium’ compatibility) |
||
|
Company Name |
... |
CGI LS3 - |
|
Role |
... |
AS/400 Analyst Programmer |
|
Duration |
... |
10th April 1995 - 30th June 1995 (Initially 3 Months) |
|
Hardware Used |
... |
IBM AS/400 F35 & Terminal. |
|
Software Used |
... |
RPG/400, RPG2, OS/400 V3R1, Query, CL, DFU & LS/400 v1.2 (SOP System). |
|
Job Description |
... |
|
|
LS3 the software house who created the SOP system for Dun & Bradstreet were in need of some extra programmers, already competent in LS/400 for some rush work and I needed a break from Dun & Bradstreet so that I could travel home every night. The work involved modifications & enhancements to the Works Order Processing System. This system included Time & Attendance, Labour Analysis, Product Costing, Job Costing and Scrap Analysis. Also the updating of the relevant spec’s for the programs changed. All the above work was completed to LS3 programming standards. |
||
Contract
Assignments
|
Company Name |
... |
Dun & Bradstreet - |
|
Role |
... |
AS/400 Senior Analyst Programmer |
|
Duration |
... |
January 1994 - April 1995 (Initially 3 Months) |
|
Hardware Used |
... |
IBM AS/400 B45, B60, Advanced 200, 300, PC’s IBM PS/1, PS/2 & WANG |
|
Software Used |
... |
RPG IV, RPG/400, OS/400 V3R05, V2R3 & V2R2, Query, CL, DFU, UIM, PCSupport, OfficeVision, XINAS/400, DOS 6.2, Windows 3.1, Word6, Excel, & LS/400 v1.2 (SOP System). |
|
Job Description |
... |
|
|
To trace, analyse and fix bugs in the LS/400 SOP System, amend the code, produce test plans, test results and to document all code/spec changes. To produce additions for the SOP System, which included Reports, Label Production and Letter Production (using the Office Vision/400 Mail Merge Facilities). To design and program an automatic link between the AS/400 and a WANG, using a PC as a gateway with PC Support/400 and W-LOC (WANG emulator) to attach directly to the AS/400 via an Office Vision folder. To design and program a download system to send a special format file to British Telecom, for the production of Telemessages to send to a selection of Dun & Bradstreet customers as a mailshot. To design and program an automatic link between the System36 environment on the AS/400 and the SOP system. To load up all new/changed customer details and invoices, input on the System/36 System. To design and program an addition to the SOP system, which allowed customers to pay for accounts using an Instalment Payment Plan. This involved splitting the cost of their contract over a number of payments and billing them on specific dates throughout the duration of their contract with the company. To combine the functions of Customer Search, Customer follow-ups & Customer Notes into one program, to enable the telesales people to stay in the same program all day. The program controlled Customer follow-up’s, Customer Searching (148 Search Patterns), Display Customer History & Enter New Notes while on the telephone. To implement two Advanced Series AS/400's, a model 300 & 200. These new machines were to replace the B60 & B45 respectively. I installed the Operating System, transferred the User Profiles, Security & Software to the new machines. To produce a set of programming standards, which included Program Spec Skeleton, Test Plan Skeleton, Test Results Skeleton & programming methodology (what to do & what not to do). All the above AS/400 programs and modifications were written to the Dun & Bradstreet programming standards.(of which I was the Author) |
||
|
Company Name |
... |
Barclays Mortgage Services (Inter Mortgage) - |
|
Role |
... |
AS/400 Analyst Programmer |
|
Duration |
... |
August 1993 - December 1993 |
|
Hardware Used |
... |
AS/400 Models B60, D70, E95, PC’s NCR 386 & Toshiba 4500 Portable |
|
Software Used |
... |
RPG/400, CL, Query, DFU, OS/400 v2r2, PCSupport, Rumba, Office Vision/400, Target Mortgage Processing System, DOS 5.0, Windows 3.1, PC Anywhere & Word for Windows 2.0 |
|
Job Description |
... |
|
|
To program an addition to the Mortgage Application System, to include access to a PC Fraud detection package called 'HUNTER'. This ran integrity checks on mortgage application forms to check for fraud. The ‘HUNTER’ interface was already spec'd from my previous contract with Inter Mortgage and consequently I just had to program the AS/400 to PC interface. The second part of this project was to retrieve only new business applications and pass them down to a PC disc, to be forwarded to the CML (Central Mortgage Lenders), to run their fraud detection checks, these included checks with other mortgage lenders, who may have an application from the same person. I was given a contract extension and moved onto the FMS (First Mortgage Services) Team, which was a team of programmers and analysts which worked on 3rd party business, looking after other mortgage companies accounts. This required a whole host of new systems and amendments to the current system to cater for all the features of the new companies own system (Including different type of Accrual, Penalties, Capitalisation, Interest, Late Fees, Penalty Interest, Etc.). All the above programs were written to Inter Mortgage standards and spec'd appropriately. |
||
Contract
Assignments
|
Company Name |
... |
Lucas Aerospace Ltd. - |
|
Role |
... |
AS/400 Analyst Programmer |
|
Duration |
... |
June 1993 - July 1993 |
|
Hardware Used |
... |
AS/400 Model B70 & IBM PS/2 |
|
Software Used |
... |
RPG/400, CL, Query, DFU, PC Support, OS/400 v2r2, Office Vision/400, MACPAC (Manufacturing System) & DOS 6.0 |
|
Job Description |
... |
|
|
To program amendments to the Manufacturing System ‘MACPAC’, which was used to control all purchase orders / material movements / invoices and accounts in the company. To clear the backlog of program amendments and fixes to the ‘MACPAC’ system. To assist in the development of an AS/400 to PC monitor and data transferral system. The PC would monitor messages from the AS/400 to signify when the AS/400 had data to be transferred, then would handshake with the AS/400 and transfer the data directly onto the PC database. This system used Office Vision folders to link virtually to a PC drive. All the above programs were written to Lucas Aerospace standards and spec'd appropriately. |
||
|
Company Name |
... |
Barclays Mortgage Services (Inter Mortgage) - |
|
Role |
... |
AS/400 Analyst Programmer |
|
Duration |
... |
February 1993 - May 1993 |
|
Hardware Used |
... |
AS/400 B60, D70 & E95, PC’s NCR 386 & Olivetti 386 |
|
Software Used |
... |
RPG/400, CL, Query, DFU, PC Support/400, OS/400 v2r2, Office Vision/400, Target Mortgage Processing System, DOS 5.0, Windows 3.1, Word for Windows & Lotus 123 for Windows. |
|
Job Description |
... |
|
|
To design and program an addition to the Mortgage Arrears System, called ‘VOICE LINK’. This enabled certain customer records from the arrears system to be downloaded onto a PC server overnight. The PC then dialled the customers directly using the ‘VOICE LINK’ predictive dialler and allowed the arrears clerk to discuss the state of their account, without the need to dial themselves (this system automatically monitored for answer machines, faxes and No one home). The arrears clerk could then switch to the AS/400 Arrears System to update the customers account notes. This system involved a suite of AS/400 programs to build the download file, to control the download to the PC (using PC Support) and to amend the Arrears System so that certain information was already populated (time, date, userid, etc.). To design and spec. an interface that allowed information from the Mortgage Application System, to be automatically downloaded to a fraud detection package called ‘HUNTER’. The last few weeks of my contract were spent on the SER team (System Enhancement Request) programming modifications and bug fixing the existing Target Mortgage Processing Systems (including New Mortgages, Mortgage Arrears, Late Penalties, Penalty Interest, Etc.). All the above programs were written to Inter Mortgage standards and spec'd appropriately. |
||
|
Company Name |
... |
Holiday Inns World-Wide - |
|
Role |
... |
AS/400 Analyst Programmer/Support |
|
Duration |
... |
November 1991 - January 1993 |
|
Hardware Used |
... |
AS/400 B10, B60, PC’s IBM PS/2, Compaq 386 & Compaq
LTE |
|
Software Used |
... |
RPG/400, CL, Query, DFU, PC Support, OS/400 v2r1, Office Vision/400, JDEdwards, Innsight Back Office Suite, DOS 5.0, OS/2 1.3, Windows 3.1, Display Write 4.0, Lotus 3.1+, Freelance Graphics, CorelDraw 2.0 & Laplink. |
|
Job Description |
... |
|
|
To program fixes and interfaces to/from the JDEdwards Accounts to fit in with the Brussels environment and to support all the remote hotels with their JDEdwards problems. To design and program an International help desk system, for each hotel in Europe & UK to enable hotels to send in queries via the AS/400 instead of the telephone. This system worked fine, but was never implemented while I was working for Holiday Inns. To give help to all hotels, in setting up their new remote access to the head office, via an IBM 5493 controller using IBM PS/2's. To design and program a
replacement backup system, which ran in To upgrade the operating system from V2R1 to V2R1.1 and to install all new PC's, Terminals, Scanners & Printers. To be on 24hr call out for
Banbury (including PC’s, Printers, AS/400, Software), so that Hong Kong, All the above programs were written to Holiday Inns standards and spec'd appropriately. |
||
Permanent
Employment
|
Company Name |
... |
East
Worcestershire Waterworks Company - |
|
Job Title |
... |
AS/400
Analyst Programmer |
|
Duration |
... |
April
1991 - November 1991 |
|
Hardware Used |
... |
AS/400
B70, IBM XT, Compaq, IBM Portable, Viglen 386 & Husky Hunter Handheld |
|
Software Used |
... |
RPG2,
RPG3, CL, Query, DFU, PC Support, OS/400 v1r2, Office Vision, DOS 3.3, Lotus
3.1+, Turbo Basic, DE5250 Emulation, Laplink & Water Billing System. |
|
Job Description |
... |
|
|
To
program and spec a water engineer call-out system, to assign a maintenance
engineer to a problem reported by a customer and to maintain the progress of
each problem, including a suite of reports on the current status of each call
and the work load of each maintenance engineer. To
program and spec a system for reading water meters (on an address round) and storing this
reading on a Husky Hunter Handheld machine. This round is downloaded to the
Husky from the AS/400 via PC/Support; then the meter reader goes out on a
round, when finished the meter readings are uploaded to the AS/400 via a PC and
used in the current billing system. To
program a change in the package software suite supplied by ‘SOVEREIGN’ Computers, which runs a
Water Analysis System. To include new government guidelines controlling water
analysis and the reporting of findings. To
program a change in the current water rate billing system, which controls the
bills sent to each customer. To add a feature which would send one of three
varying letters to customers who do not pay their bills on time, the third of
these was an actual court summons, which was duplicated and sent with the
appropriate solicitors letter to the solicitor, if the customer does no pay. |
||
|
Company Name |
... |
Universal
Grinding Wheel - |
|
Job Title |
... |
AS/400
Junior Programmer |
|
Duration |
... |
April
1990 - April 1991 |
|
Hardware Used |
... |
SYS/38,
AS/400, IBM XT & IBM AT |
|
Software Used |
... |
RPG/2,
RPG/3, CL, Query, DFU, PC Support, DOS & JBA Accounts. |
|
Job Description |
... |
|
|
To
be trained up in programming on the System/38 and AS/400 using RPG/2, RPG/3,
CL, DFU, QUERY, Physical Files, Logical Files, Screen Files, Sub Files &
Printer Files. To
program changes to a host of in-house JBA systems, including Sales Ledger,
Purchasing, Nominal Ledger, Stock Control, Bill of Materials &
Manufacturing Systems; as per a spec written by the analyst. My
first major project was to add another level of product details to the Bill
of Materials System, which was already on the system. This involved a lot of
minor modifications and a couple of new programs to display the new levels. |
||
|
Company Name |
... |
Wheway
Becker Ltd - Walsall, |
|
Job Title |
... |
PC/DEC
Analyst Programmer |
|
Duration |