Colin Développeur ADABAS NATURAL
Education and qualifications
Bachelor of Science Computing and Data Processing, 1986
Edinburgh Napier University, Edinburgh, United Kingdom
Scottish Higher National Diploma in Computer Data Processing, 1982
Falkirk Technical College, Falkirk, United Kingdom
Scottish National Certificate in Business Studies, 1981
James Watt College, Greenock, United Kingdom
Architecture et communications (Computer networks), 1994
Conservatoire National des Arts et Métiers, Paris, France
PRINCE2 certified ITIL V2 + V3 certified
IT Service Management, Foundation CNAM Computer Networks
Business Analysis and User Requirements MERISE (Procedure and data modelling)
Oracle Data Integrator Oracle eBS Essentials for Implementers
Logical data base design ADABAS, physical data base design
Software and support tools
Micro Complex EXCEL, WORD, VISIO, POWERPOINT, PC, WINDOWS, MS-DOS
Modelling ER/Studio, UML, Use Case
ERP ORACLE eBS 11.5, SQL queries, TOAD for ORACLE, Discoverer (Admin & Reports),
XML Publisher, Walker Financial Packages
Databases Oracle, Microsoft SQL Server, ADABAS, PREDICT, DB2
Languages Microsoft VBA, VB.NET, SQL queries, NATURAL, COBOL, zOS JCL, REXX, CLIST
Systems zOS, CICS, TSO, ISPF, VM/CMS, DOS/VSE, UNIX, CONTROL-M, CONTROL-T
Hardware IBM ES90XX, 30XX, 43XX
World Health Organization (WHO), Geneva, Switzerland, 2001 – 2012
In 2008 the WHO IT Business Applications department went live with a highly structured, ITIL based service architecture, an on-shore / off-shore vendor based outsourced service model, an off-shore transaction processing centre (Kuala Lumpur) and an Oracle ERP administrative system.
Stakeholder management. Stakeholders based locally and remotely. Frequent formal and informal meetings to discuss needs and requirements. Workshops and presentations to discuss business functional and technical requirements and validate common understanding.
Functional and technical requirements gathering using interviews, meetings, workshops.
Documentation using various tools including MS Office products, Sharepoint sites, data modelling tools. Data analysis using various discovery tools.
Design of complex business systems based on validated requirements.
Acting as liaison between stakeholders, users, staff and IT infrastructure providers, managed service providers. Enabling communication of complex business issues to service providers and presenting in business terms of benefits of complex IT solutions.
Analysing features of vendors’ software and solutions compared to business requirements and documenting gaps or missing functionality.
Continuous validation of business requirements versus on-going implementation to ensure quality, accuracy and completeness.
Continuous review of service delivery model and discussions with vendor on how to improve throughput, increase quality with a view to improving KPIs and lowering costs. Suggesting updates and improvements for the next set of SLAs.
In-depth analysis of Payments System including review of end to end process, security, hardware, software, versions, system architecture and business logic. Recommendations to improve security of the end to end process including hardware and software changes.
Experienced in working with outsourcing vendors with on-shore and off-shore based team elements (Satyam, then Wipro).
Weekly reviews of service levels provided by vendor versus agreed service levels in cooperation with the vendor (prioritization of incidents, incidents unresolved, incident post-mortems, etc …)
Weekly review of KPIs in cooperation with the vendor (average priority 1 turnaround, quickest turnaround, slowest turnaround etc) using Excel based spreadsheets and formulas.
Ensuring that basic incident data is captured, and that the database (Siebel) has the correct structure to allow further analytics to be performed.
Complex analytical reports based on Excel spreadsheets including formulas and pivot tables for senior management.
Clear and concise verbal and written reporting for senior management, including Excel and occasionally PowerPoint presentations.
Chase Manhattan Bank, Bournemouth, United Kingdom, 1995 - 2001
Requirements gathering with Business users, functional analysis, design of complex systems, developing systems, system testing, user acceptance testing and production implementations and follow-up.
Team Partners Informatique, Paris, France 1991 - 1995
Represented Team Partners at 3 major French banks and one industry brand name. Requirements gathering with Business users, functional analysis, design of complex systems, developing systems, system testing, user acceptance testing and production implementations and follow-up.
Career and achievements
Project Specialist World Health Organization, Jun.2001 – Sep.2012
(ORACLE ERP, business, analysis, service management) o Business analysis o Technical analysis o Management of enhancements, incidents, problems and projects using Prince2 and ITIL o Monitoring and control of the Managed Service Provider (MSP) performance o Ensuring smooth communications between MSP team, Business users and internal IT team o Supervision of MSP team and service levels o Ensuring stakeholder requirements were fully reflected within the SLAs o Close working relationship with the network technical and management team during “End to end payments processing security review” o Continually reviewing and suggesting improvements to the overall service process o Being an expert in Siebel incident/problem analytics o Communicating service levels to senior management mainly with verbal presentations of complex Excel analytics
Systems Analyst Chase Manhattan Bank, Aug.1995 - Jun.2001
Bournemouth, United Kingdom
(Business analysis, systems analysis, systems design, programming, testing, NATURAL, ADABAS, PREDICT) o Corporate Actions, Early Client Instructions project o Corporate Actions, Agent Instruction Automation project o Corporate Actions, French Dividend Options project, Entitlement Calculator o Corporate Actions, File Number Re-use project o Corporate Actions, Proxy Voting Holdings Extract project o Corporate Actions, EURO project o 1099 US Tax IRS reporting system o Morgan Stanley Transition, Offshore and Onshore Cash Sweep projects o Morgan Stanley Transition, US Dollar Cash project o Captive Foreign Exchange project o Foreign Exchange 2000 project o Supervised a small team of analyst programmers.
Senior Analyst Team Partners Informatique, Jun.1991 - Aug.1995
Programmer Paris, France (various client projects, on-site)
GIE CARTE BANCAIRE (NATURAL, DB2, PREDICT) o Maintained an X.25 network configuration application.
SOCIETE GENERALE (NATURAL, ADABAS, PREDICT) o Maintained corporate client data base o Developed an application to consolidate clients with financial links o Developed an application to merge reference data of two large clients.
YOPLAIT (NATURAL, ADABAS, CLIPPER 5, RELAY GOLD) o Developed an application to manage product promotion contracts o Developed an application to stimulate sales which allowed the daily update of 150 remotely located micro-computers o Developed an application to predict the impact of sales promotions on product margins and volumes.
BANQUE LA HENIN (CLIPPER 5) o Maintained a loan repayments calculation application.
Senior Analyst World Health Organization, Sep.1988 - Jun.1991
Programmer Geneva, Switzerland
(NATURAL, ADABAS, PREDICT) o Responsible for the development of the WHO payroll system. 5000 employees in 52 countries. Automated monthly calculations of pay, benefits and deductions. Standardized pay procedures for permanent and contractual employees o Supervised a small team of analyst programmers.
Analyst Société de Services et Conseils en Informatique, Sep.1987 - Sep.1988
Programmer Geneva, Switzerland
RJ REYNOLDS TOBACCO (NATURAL, ADABAS) o Analysed and developed general ledger and telephone exchange reporting software.
Programmer Rothmans (UK) Ltd, Jan.1987 - Sep.1987
Aylesbury, United Kingdom
(NATURAL, ADABAS, COBOL) o Developed software for a telephone sales application o Maintained COBOL programs.
Programmer CERN (Centre for European Nuclear Research) Jun.1986 - Sep.1986
Geneva, Switzerland (UNIX, FORTRAN) o Designed database to store experimental data for the LEP3 project.
Programmer Edinburgh District Council, Jun.1984 - Jul.1985
Edinburgh, United Kingdom
(NATURAL, ADABAS, WALKER International) o Customized Walker General Ledger and Purchase Ordering packages o Developed software for a tourist information application. o Maintained COBOL programs.