Email: Adam (at) mail (dot) com
Nationality: British
Education: 1988-1992 University of York: Computer Science Degree BEng (Hons.)
Other courses and conferences:
Java for C++ Programmers 4 day course
Lotusphere, ‘98, '99, ’06, ’07, '08 & ‘09
UNIX Systems Management and Admin ADA Programming Language
Structured testing using McCabe (C++) Kepner Tregoe Problem Solving
OSF / Motif programming Yourdon Real time analysis and design
Lotus Notes Application Development 2 Object Modelling Technique
Notes 4,5,6,7,8 Update Courses Internet Development with Lotus Notes Domino
Advanced Lotus Script for Lotus Notes Domino System Administration 1
Ives Tools: Ciaou, Analyser, Delta
Project work: (in reverse time order)May 2007 – NOW Senior Consultant at IBM Premier Partner LAN 2 LAN (Permanent Role)
July 2009
Worked with Royal Borough of Windsor and Maidenhead to add web capability to existing notes database using XPages ( Lotus Notes 8.5 ) .
Worked with Surrey County Council to fix a problem with customised resources database clashing cuased by upgrading to Notes 7.
June 2009
Added Strategic planning website application fro Skillshare to allow details to be updated in the browser from around the world, sent for approval process, and then summaries displayed in gant chart style.
Added Google Maps interface to Skillshare intranet to allow quick visualisation of global sites and current staff locations.
Consolidated forms in web site for National Autistic Society.
May 2009
Made changes to G4S’s Flowfinity Blackberry application for Aircraft Stand patrol system.
Bid work for system to handle Strategy and Initiatives Workflow for existing customer.
Bid work for Domino.Docs to Interwoven conversion work for new customer.
Extracted email log for a customer’s user who had deleted all emails by mistake.
Created code for Cega to find expired Soft Deleted emails in Notes 6.5 email boxes.
Fixed reported DXL problems in Rarmershire Interwoven customised mail template.
April 2009
Added new Deputy Roles and functionality to The National Autistic Society systems to enable more flexible handling and assigning of cases.
Added Confidential option to Skillshare MIS system to allow more secure storing of emails.
Created suitability report for customer to move all Intranet databases to Quickr.
March 2009
More customisation and testing of Mail Template for Interwoven integration for Rarmershire / Jenkins.
Constructed demonstration/taster XPages course for key customers and visited customers Air Miles, Waitrose, Deloitte, Renew, Carnival, Skillshare & Doncasters.
Created bid document for new Internet Site for customer including Facebook interface.
Created Notes 8.02 & 8.5 Composite Applcation for internal CRM system.
February 2009
Customization of Lotus Domino Quickr 8.1 for new Disaster Community product Congrego. Added picture forums, AJAX Persistent Chat, Sametime enabled contact list. (Notes 8.5)
Mail template customisation for Skillshare.
Created bid document and mocked up Website for new Skillshare Internet including Facebook integration, RSS feed, YouTube videos, credit card donations and image shows.
January 2009
Lotusphere 2009. Investigated XPages for Blackberry. Met OBM staff from Developers
Created Mime to RTF code for St Martins FileNet system.
Created Expiring version of Holiday template for BCA, allowing Notes and Web use of application which expires in 2 months.
December 2008
Worked on Quickr template for Doncasters - issues with offline working and images and style sheets font changes.
Added Print Disabling and Print Log to National Autistic Society Web System
Worked for St Martins Property Group on their FileNet Lotus Notes installation. Added Cloaked Email sending functionality to Notes Mail template.
November 2008
XPages Workshop at Hursley. Learnt basics of Xpages including best practices. Updated various VAT systems for 1st December.
Created basic Blackberry & iPhone interface for Lotus Domino Quickr for Waitrose / John Lewis Partnership, allows all documents to be viewed in a microbrowser.October 2008
Customization of Lotus Domino Quickr 8.1 for IBM SSL proposal for BAT, added blog rich text concatenation, calendar pickers for meetings and blogs, pop ups for meeting agendas, advanced profiles including photos, sametime mobile and email links. (Notes 8.02)
Added more reports to Skillshare Management Information System including a date specific situation report export to Excel using multi worksheets. (Notes 7.02 )
Extended ODB mail box integration code with the Save mail and archive databases. (Notes 6.5)September 2008
Created simple Blackberry / iPhone web interface for Quickr for internal use and possibly as a solution to John Lewis Partnership. (Lotus Domino 8.02)
Web enabled Primetime application for Porter Novelli. (Lotus Notes Domino 7.02)
Copied Interwoven mail integration into Group incoming mil box for Rarmershire. (Lotus Notes 7.02)
Analysed SITA Lotus Domino Quickr Windows Explorer connector problems for IBM Software Services Lotus and proposed possible solutions and workarounds.August 2008
Worked on solving QuickPlace to Lotus Domino Quickr upgrade issues for Doncasters.
Gave training course on Lotus Domino Quickr Customisation to Waitrose staff.
Created web based Direct Sales Lead Tracker for Titan. (Lotus Notes Domino 7.02)
Fixed problems with AVNET's sales and customer tracking systems after office move. (Lotus Notes Domino 7.02)
Updated SPP's Agents and Sales contacts databases.July 2008
Added mail template integration with Contacts database for Versutus. (Lotus Notes 7.02)
Cardiff University Shared Groups and Shared Folders database work. (Lotus Notes 8.02)
ODB: Added Save Email integration with mail templates allowing emails to many to be stored in one repository with access by links and searching. (Lotus Notes 6.5)
Absence Database bid for West Sussex county Council.. (Lotus Notes Domino 7 & 8)
Wrote code to create clean CSV export for Mandeville Recruitment Database.
Created PDF export solution for Renew Holdings. (Lotus Notes 7.02)June 2008
Customization of Lotus Domino Quickr 8.1, changing of themes, logos, layout, colours and addition of inline views to mimic rival Microsoft SharePoint offering for major 800 licence deal involving Insurance management company.
Planning session to teach Quickr 8.1 customisation for major retailer.
Write CSV Export routines for Recruitment firm.
Changed LotusScript LS2J java thumbnail jpeg code for Skillshare to handle very narrow images.May 2008
Updated and restyled Skillshare International’s Intranet with extra image resizing code and new cleaner style sheet look. Add integrated file archiving system to ODB Group’s Notes 7 mail template.
Added new reports to Skillshare MIS system to allow managers to track current development worker status, upcoming assignment issues and recruitment progress.
Convert web template for Business Intelligence company to show data captioned with German text.April 2008
Cardiff University Notes 8.01 required customisation of the Composite Application Mail interface and the
Basic client to incorporate shared access folders to duplicate GroupWise functionality. Converted web template to German language to specification. Attended Business Partner Composite Applications Course At IBM Hursley.March 2008
Created Expenses application for Mentzendorff incorporating VAT and Inland Revenue PAYE and Deductible rules and creating a .csv output file for SAGE use.
Updated internal 8.0.1 Mail Template to be integrated with CRM systems.
Made web forms ‘unprintable’, and added logged printable forms to Advocacy database for the National Autistic Society.
Invited to be an IBM Lotus Design
for Notes 8.5 pre beta release discussions after discussing XPages at Lotusphere with the IBM developers. Joined program and participate in regular pre beta meetings with IBM. February 2008
Updated Holiday database for Mitsui incorporating a web interface with date picker and .iCal attachments to allow non-notes users to add holiday dates into their calendars.
Incorporated UKAEA server audit system with PC audit data system to produce one system that tracked hardware components and software installs such as Antivirus and server software versions.January 2008
Lotusphere 2008 in Florida.
Worked on site and offsite supporting UKAEA working on various databases and trouble shooting issues that 1st line support pass over to Lan2Lan.December 2007
Cardiff University 8.0 DWA Mail customisation and 7.03 accesses controlled shared groups version of the pubnames.ntf template to add to the directory assistance service, to duplicate GroupWise functionality.
Skillshare International needed a Management Information System to allow the management of recruitment and placement assignments of development workers throughout the world. Analysed, designed and implemented a system using 7.02.November 2007
Advised Renew Holdings & Walter Lilly for INSE File Upload widget. Notes 6.52 & Java Servlets.Initial investigative work for Cardiff University on 8.0 DWA customisation.October 2007
Added specialised flat views for printing for Ramershire.
Updated news and feature links for HRi website.
Updated CEGA Air Ambulance mailing list system. Java and Notes 7.0.2September 2007
Added more functionality to CRM systems on site at ODBGroup.
Attended "Social Computing with Lotus Connections" Business Partner course at IBM Hursley where I learned to install Lotus Connections and how to extend Lotus Connections using the Atom API.
Finished Skillshare International SkillZone intranet.August 2007
Worked for The Innovation Group Plc via IBM Software Services for Lotus to extract Lotus Notes embedded and field data and attachments from Royal & Sun Alliance Lotus Notes database.
Improvements to searching of graphical website for Skillshare Lotus Notes Domino 7.02 .
Improvements to website views & search for The National Autistic Society. JavaScript, Lotus Notes 6.55July 2007
Attended Java for C++ Programmers 4 day course
Assignment at ODBGroup to update and problem solve CRM & holiday databases.
Problem solving for Cega Air Ambulance and Bernard Matthews.
Adapted Snapps Quickr templates that use Dojo JavaScript library to work with UK date formats for BBH.June 2007
Changed OpenNTF.org Mail template for SPP Pumps to allow different disclaimers to be used for different business units to external email addresses.
Went to ACAL IT to fix a CRM update agent which failed for strange bug. Lotus Notes 6.52. LotusScript.May 2007
Created new version of delayed / instant broadcast mailing database for UKAEA UK Atomic Energy Authority. Changed Mail Template for UKAEA to allow Send As functionality so that users can send emails from different mail accounts and domains from the same mailbox.Feb 2007 – Mar 2007 EuroTaxGlass, Weybridge & East Sussex (FIXED PRICE CONTRACT)
Documenting existing Car Body Insurance Estimates Workflow system and exploring ways of improving speed of LotusScript agents. Create new Disaster Recovery plan. (Notes v6.54, Lotus Script, XML )January 2007 Personal Care Consultants, Chester, Cheshire
Creating timesheet, payroll and billing system for multi-site workers and integrating with existing Personnel Database. (Notes v6.51, Lotus Script, @Functions )January 2007 Lotusphere, Florida
Will be at Lotusphere to find out the latest Lotus Notes information, trends, tips and tricks from IBM.
Feb 2006 – Dec 2006 Nokia Mobile Phones in Farnborough (FIXED PRICE CONTRACTS)Maintenance: bug fixing and improvements and integrating more projects with the Product Development Tool using Web Services. (Notes v6.54, v7, Lotus Script, Formula Language, XML, WSDL, XSD, Web Services, SOAP, JavaScript, DHTML, Excel)January 2006 Lotusphere, Florida
Will be at Lotusphere to find out the latest Lotus Notes information, trends, tips and tricks from IBM.
Oct 2005 – January 2006 Nokia Mobile Phones in Farnborough (CONTRACT)Created a new Portal for the Care team, add LEI to the Product Design Tool + a few other projects. (Notes v6.52, Sametime, Lotus Script, Formula Language, RSS, XML, Web Services, LEI, JavaScript, DHTML)September 2005 Eli Lilly – Elanco, Basingstoke (CONTRACT)
Back at Eli Lilly to work on CRM system, expanding the reporting, fixing bugs. (Notes v5.11,LotusScript)
July > August 2005 Lotus Notes Consultant for Allen and Overy, in City (CONTRACT)Bug fixing & improvement of various databases, improvement of HR database, migration of data to Doc Manager using Hummingbird tools. (Notes v6.5, LotusScript, Hummingbird, JavaScript, HTML, CSS )June –> July 2005 Consultant for Sanden in Basingstoke via Thomas Norton (CONTRACT)
Requirements capture, design and implementation of a Samples Request System used by the enterprise to request custom samples from factories around the world to supply to customers and potential customers. (Notes v6, LotusScript, Domino, JavaScript, SMTP)June 2005 Lotus Notes Consultant for Allen and Overy, in City of London (CONTRACT)
Notes 6 Migration & General Bug fixing and improvement of various databases for various international sites for these international lawyers. (Notes v6.5, LotusScript, HTML, JavaScript, CSS )May 2005 Lotus Notes Consultant for Sanden via Thomas Norton (CONTRACT)
Various databases. Connecting Notes BPCS using SQL and ODBC, PDF exporting code, Call Log, HR Absence, Customer Complaints. (Notes v6.53, LotusScript, Sametime aka IBM Instant Messaging)May 2005 Lotus Notes Consultant for Elanco (CONTRACT)
European CRM Database Adding improved colour coded customer comments, reporting and configuration to database. (Notes v5.11, Lotus Script)Apr –> May 2005 Lotus Notes Consultant for Sanden via Thomas Norton (CONTRACT)
Various databases. Sanden Air conditioners in Basingstoke. Connecting Notes BPCS using SQL and ODBC, Call Log, Absence, Customer Complaints. (Notes v6.53, LotusScript, Sametime aka IBM Instant Messaging) Mar -> Apr 2005 Lotus Notes Consultant for Elanco (CONTRACT)
European CRM Database Adding improved competitive data forms and functionality. Improved totals and category reporting to Excel. Extending visit data details. Extended excel reporting outputs. (Notes v5.11, Lotus Script)Mar 2005 Lotus Notes Consultant for Thomas Norton (CONTRACT)
US Customer Complaints Database Creating a prototype database for Air Conditioning company. Making full use of Lotus Notes 6 features and incorporating data connections to AS400 server using company’s existing user interface styles. (Notes v6.5, LotusScript)Feb 2005 Lotus Notes Consultant for Elanco, Basingstoke (CONTRACT)
European CRM Database Fixing some errors. Improving user interface for complex competitor data calculations. Extended excel reporting outputs. (Notes v5.11, Lotus Script)Jan 2005 Lotus Notes Consultant for Launch Software (CONTRACT)
Global Website Upgrading & promoting website to take advantage of Google search algorithms and to add B2B purchasing & licensing interfaces. (Notes v5.11, Lotus Script)Jan‘05 Nokia Mobile Phones (CONTRACT)
Mobile Action Database Back at Nokia to analyse, upgrade & test and holiday agents for New Year. (Notes v5.11, Lotus Script.)2nd Dec‘04 -> 21st Jan’05 at Mars ISI, Winnersh, Reading (CONTRACT) Graphical Image Database Included graphical results search engine for Notes client. Also Trouble shooting and problem solving on various other databases.
(Notes 5.09a & 6.03, Lotus Script, JavaScript, HTML, LS2J, Virtools)Sep‘04 -> Oct’04 at Nokia Mobile Phones (CONTRACT)
Mobile Action Database Back at Nokia for a week to integrate previously created Web interface to Finland’s version of the software altered to work on Symbian phones. The software is Finland’s version of the design by UK team. See description of Project Action Tracker below. (Notes v5.11, Lotus Script, XHTML, JavaScript, Symbian Series 60 mobile phones 3650 7650 9210i 9500.)Sep 2004 Lotus Notes Consultant for Elanco (CONTRACT)
Utility Database Improving disease report presentations. (Notes v5.11, Lotus Script, HTML)European CRM Database Fixing some errors. Improving user interface for complex competitor data calculations. (Notes v5.11, Lotus Script)UK CRM Database Integrating European advanced functionality back into original UK design. (Notes v5.11, Lotus Script)Apr 2000 > Aug 2004 Lotus Notes Developer at Nokia Mobile Phones (CONTRACT)
Nokia UK is the R&D area of Nokia Mobile phones. Invited back to the Application Support group to work on several projects including:Project Action Tracker Notes / Web / Mobile Phone application to track action logging and workflow for various projects. Allows managers to set up custom forms with different fields and captions and field rules such as mandatory fields, field types and values. Workflow and status driven forms. Custom views and alerts by emails, sms text messaging and MMS. Needed to work on Nokia Mobile Phones via SECURID and extranet as well as on the web via intranet and extranet to allow external sub contractors limited access. Allowed instant uploading and alerting of error photographs to engineers. (Notes v5.10, Lotus Script, XHTML, JavaScript, Symbian Series 60 mobile phones 3650 7650 9210i , Series 40 mobile phones 7250i, MMS gateways, also Sharp GX10 and Sony Ericsson P900.Overtime System Notes and web application to track overtime estimates and actual hours approval by various departments and auto forwarding to Payroll. Included novel approval trumping by program managers and complex rules on weekend working. Full intelligent email alerts (v5.10, LotusScript)HR CV System Notes and web application to track incoming CVs, organise interviews, monitor the offer process. System created statistics on the process to Business Managers to demonstrate progress made on specific and group vacancies. (v5.08, LotusScript, JavaScript, HTML, XSL)CIDS rollout Roadshow around UK and Ireland rolling out CIDS system, included giving demonstrations of software to management, administrators, HR and users, including answering questions and technical support as well as moving data from SAP system to Notes. (v5.07, LotusScript, JavaScript, Presentation skills)Mobile Services This Extranet and Intranet website allowed the team to collaborate with content companies such as Disney and Pixar etc from one website. The website was available on the extranet and used Notes security to protect contract sensitive information. (V4.67 & v5.07, LotusScript, HTML, JavaScript)Absence recording system A new system was required so Nokia could claim back the Statutory Sick pay they were missing out on. Absence could be recorded by other people, to help keep the records up to date. Automated reminders and integration with Outlook, and reports to managers. Also included categorisation of sickness for analysis by HR. After successful roll out, has now been rolled out to all of UK & Ireland (v4.67 & v5.05, LotusScript)Meeting Room booking system This existing system was a victim of it's own success. It had to be overhauled to handle 3 more buildings and twice as many (8000) bookings. The system includes Catering Requests and Room Layout changes and presentation equipment hire, and links to maps to each of the 110 rooms in 5 buildings. Automated reminders, integration with Outlook, web access functionality have made this system a powerful tool but still easily maintainable by non-technical staff. Various sites are now investigating using the templates. Ran on IE 5.0 and NS 4.07
(V4.67, LotusScript, HTML, JavaScript)
Software Installation And Registration system The existing system allowed the IT engineers to install software on user’s machines, and to keep account of what software was on each machine and how many licences needed to be registered each month. Install FTP/HTTP links only displayed when all cost centre and location information had been entered into the form. Ran on IE 5.0 and NS 4.07.
(V4.62, LotusScript, HTML, JavaScript)Home Page for Displays Research Department. This was a one-stop shop for all material used by the Displays team, including links to other web sites, storing of research data and documentation. Used ids and passwords to restrict access to confidential documents, but "intermediate" pages allowed the confidential documents to be searched for using abstracts and keywords. Ran on IE 4.0 and NS 4.07.
(V4.62, LotusScript, HTML, JavaScript)HTTP Password Maintenance. This is system was a revamp of an existing bug ridden inconsistent system. It allows users to request change and test HTTP passwords using a browser. The new passwords are sent to their email account within seconds of requesting, and the password is active usually by the time the email arrives. Monthly requests and changes are now up to over 300 saving valuable Notes Administrators' time. Users all over the world use the system. Nokia’s Global Information Management department is considering a global roll out of the system. Runs on IE 4.0 and NS 4.07.
(V4.62, LotusScript, HTML, JavaScript)Redesigned Work Logging and Requesting system for team. This database allowed customers to request new databases or modifications to existing databases. Workflow enabled management to approve or reject requests and showed the current state of the work in Progress/ On Hold /Completed etc. Developers could log hours to each project. Weekly reports were automatically generated at the end of the week. Graphical Gant charts can be generated on the web browser to show planning.
(V4.62, LotusScript, HTML, JavaScript)General Process Feedback Tool. This web-enabled database allows users to suggest modifications to the processes used to produce the mobile phone base stations. Workflow enabled management to approve or reject suggestions, assign to different experts and to forward the results to the relevant managers and departments. Weekly reports were automatically generated at the end of the week. Ran on Internet Explorer 4.0+ and Netscape 4.07 +. A global generic version of this highly successful system is planned.
(V4.67, LotusScript, HTML, JavaScript)Other work included trouble-shooting problems for over 30 existing systems and helping out junior developers with the trickier aspects of web development, Lotus Script, OLE and system architecture.Jun '99 - Mar’00 Lotus Notes Consultant at Eli Lilly and Company (CONTRACT)
Eli Lilly and Company is a global research based Pharmaceutical Corporation.
I went to Lilly Marketing and Sales IT Support on 14th June for a 3-month contract. Renewed contract 3 times until the end of March’2000.
Projects at Lilly:
Adapted Lilly's standard generic survey database template. The existing system allowed surveys to be created but had certain restrictions. Removed these restrictions to better suit the business area. This template is now being used by various projects.
(V4.62a, LotusScript, Analyser)
Created a Custom Award Nomination system. This system allowed the users to send in multiple nominations from the same stored form, to request blank forms to be sent to other users, to view only their nominations in the nomination database using a returned doclink. The database allowed the 6 different regional committees to score the nominations, to mark them as winners and to forward them as global nominees, for further scoring. System was used globally by Lilly IT staff.
(v4.62a, LotusScript, Workflow, Stored forms )
Converted 3 Access databases that used a proprietary web translator to Domino. These database used "DataViews" to produce a web search form. Restructured data to non-relational Notes format, and reproduced interface to the extent the users did not notice changes from the original.
(v4.62a, LotusScript, HTML, JavaScript, IE5, Netscape 4.05, Visual SourceSafe)Produced Notes user interface for Oracle based Group Rebates system. Created database to monitor and update an Oracle database using ODBC and to send out and process stored form emails for a multiple hierarchy approval system. The emails were used by online and offline users.
(v4.62a, LotusScript, SQL, ODBC, ORACLE)Designed, developed, tested and implemented. Europe wide database for storing drug labels. These were stored in PDF format and were available to users in 11 countries across Europe via Notes Client and IE4 browser. (v4.62, LotusScript, HTML, JavaScript)Fixed and improved a Sales Visit recording database used by the ELANCO sales force. The database had replication conflict problems due to design, and had access problems because of use of hard coded security names instead of Roles and Groups. Documented system to Lilly standards.
(v4.62, LotusScript, Excel, OLE)Produced a generic installation system for use with various applications. This system zipped up databases, replica stubs, and data files, on a per user basis, unzipped and installed them, and sent back full progress information and old existing data for archive. (v4.62, LotusScript, NotesMail)Documented and Installed a 3rd party Training Database. This had been developed months before and all documentation had been lost. The company had ceased trading. (v4.62, LotusScript)Developed prototype Sales Force calendar to store all events for use by different levels of users from Directors to Field Force (v4.62, LotusScript, Notes Calendaring)Developed extra helper routines to aid moving the company from proprietary Calendar system to Lotus Notes Calendaring. These were created for our department's users but soon spread through out the company. (v4.62, LotusScript, Notes Calendaring)Added functionality to existing Sales Force visits statistics system. This system comprised an offline interface that packaged up and zipped up a week's visit statistics sent them to a mail in database. These were then detached and processed by Excel routines. The resulting region reports were mailed out to the associated Sales Managers who were determined by querying Oracle and Access databases using SQL and ODBC. (v4.62, LotusScript, Excel, ODBC, Access, Oracle, SQL)
Sept '97 - Jun '99 Senior Lotus Notes Analyst and Application Architect at Synetics (UK) Ltd
Synetics (UK) Ltd are a Lotus Notes Premium Partner who specialise in Lotus Notes web enabled applications. Projects undertaken while working for Synetics:Lead Developer global document dissemination system for Procter & Gambol in Chertsey. System used Notes Pump to bring in Oracle files, then handled them and various other documents including MPEG files distribution using CDs and selective replication. (v4.6, LotusScript, Win API, Notes API)Consultant to ING Barings to compose specification for an enterprise wide ID administration solution to run on Notes 5 servers and Netscape browsers. This project was delayed pending Notes 5 Gold release. (Notes R5b2, JavaScript, HTML, LotusScript)
Development: Adapted Synetics' Purchase Order database template to be used by Scudder Investments. Added functionality to include escalation of POs for larger amounts, and displaying of signature bitmaps for approved POs. (v4.5 & LotusScript)
In house work: Created demonstration database using Notes Release 5 Beta 2 release. This was used to demonstrate the new functionality to the rest of the company and to several customers. Created animated graphics and applets, and also web logging system for use on company's revamped web site.
Consultant for Technical Centre at Proctor & Gamble Newcastle Reverse engineered Notes based web site created by P&G America to allow new Applications to be created for the UK. This involved writing agents in LotusScript to create new on the fly views in HTML assembled from specifications captured from the web users. This assignment included skills transfer and training.
(Notes v4.5, HTML, LotusScript, JavaScript)
Lead Developer and Project Manager responsible for producing generic web compatible version of desktop support application to show at Lotusphere in Berlin on Synetics' stand.
(Notes v4.6, HTML, LotusScript, JavaScript)
Team Leader / Lead Developer for second stage of successful ETSR desktop support project for J P Morgan. Leading a team of 2 other developers, to add user requested enhancements, and to integrate two other databases into the ETSR workflow framework. (v4.5, LotusScript)
System Architect at Proctor & Gamble. Analysed requirements for a Global Advertising Tracking database, produced Architecture design and implemented a working concept demonstrator. Project finished ahead of schedule with extended functionality. (Notes v4.52, Excel, Domino v4.6 server, LotusScript). Legal & General: analysed and costed a Notes 4.51 database to track the Recruitment of Tied Agents. I was responsible for analysing the requirements, designing the new system, and estimating the development time for a two-developer team. (Notes v4.51, LotusScript).
Wrote a program using Visual C++ and Notes C API 4.6 that replaced Bitmaps in multiple databases. This was used in the Synetics Sales Manager product suite. (Notes v4.5, LotusScript, Notes API).
Three-month project with JP Morgan in Staines and the City to redesign and build a Notes 4.1a version of their existing Notes 3 Technical Support Help desk database. As well as conserving existing functionality, the workflow was tightened up and extra Service Level measuring functionality was added. As Lead Developer I was responsible for analysing the current system, designing the new system and assigning the development work to the other three developers involved. (Notes v4.1, v3.1, LotusScript).
United Distillers, Hammersmith: Added functionality and fixed bugs on a customer sales planning database. Assignment extended to create another version of the software. (Notes v4.1, LotusScript).
Procter & Gamble, Chertsey: Architect, design and build a prototype wok flow database to replace their existing paper based R&D Study approval and results recording system. (Notes v4.5, LotusScript).
Mar '96 - Sept'97 Senior Design Engineer at Nokia Mobile Phones (UK) Ltd.
Member of the Software Technology Advisory Group. Analysed how Lotus Notes could be applied to existing paper-based processes to save time and money.
Projects undertaken while working for the group:
After premature finish of DSP project, I requested to be trained in Lotus Notes. Designed and implemented Lotus Notes to PCMS (Program Configuration and Management System) prototype interface using C++ and APIs for the company Lotus Notes Action Database. Liased with local PCMS expert and Finnish programmers who implemented original application. Worked with SQL software (producers of PCMS) on first designs. (Notes v4.1, LotusScript, Notes API, PCMS (Oracle) API).
Implemented a prototype Company Policies Database prototype editable by HR, readable by everybody at UK sites. (Notes v4.1, LotusScript).
Member of the Nokia Global LN Developers Group, attended meetings in Espoo, Finland. Helped specify development standards and guidelines for global Notes development.
Improved the training at the site by designing & implementing a Training Database. Training records were kept up to date, there were fewer vacancies on courses and training requests were processed quicker.
Implemented Leave and Flexi Day Requests Database. After successful 2-month pilot, site roll out was agreed. Designed a Roll Out procedure for 480 people on Camberley site. Created a DDI (Database to Database Interface) guide to enable developers to integrate the data with other databases.
Designed a series of Core Information Databases to store information common to all the planned databases. The Core Information Databases comprised of:
People data, including a person's project, department and location
Project data, including manager, cost code, and designated approvers
Departments, including manager, cost centre, and designated approvers
Locations, including road maps, floor plans, factory and hotel maps