Andrew James Cadogan
Email -
[email protected]
A highly adaptable and dedicated IT professional. Experienced in customer facing
consultancy, business analysis, project management, database architecture design, account
management and business liaison with third party suppliers. Confident working alone or as
part of a team; new challenges are brought to a successful conclusion through strong
communication and organisation skills allied to a flexible approach to work.
CAREER HISTORY
IT Systems Consultant
Petards Corporate Knowledge August 2001 - October 2002
Key Skills:
Defined clients requirements using data and process modelling, based on their
business objectives.
Formulated system specifications and created project plans using MS Project 2000.
Created clients CRM systems using bespoke RAD programming tool.
Prepared training course plans and documentation; delivered training courses to
clients.
Demonstrated the flexibility to fulfil any additional project requirements as required:
data migration - creation of Oracle triggers - writing management reports - ongoing
project liaison - client support.
Achievements:
Managed the design, creation and implementation of a new Incident Management System for
Bradford City Council CCTV Control Centre, running on SQL Server 7.0.
Specified and developed an eCRM system, used by Petards as the new initial platform for
all internet-based eCRM systems. Modules included: contact and opportunity management -
sales forecasting - diary - activity management - marketing campaign production and
analysis - document management - helpdesk support - management reporting.
Learnt the bespoke RAD programming language used by Petards, to advanced level, in half
the usual time.
Co-ordinated the successful integration and ongoing development of an
externally-sourced management reporting tool, subsequently included in all client
installations.
Developed a data cleansing module for a large pharmaceutical equipment
manufacturers CRM system, to automate external cleansing of existing customer data,
with fully integrated merge/purge import routines.
Database Manager
Wembley Event Management Services Ltd April 2000 - August 2001
Key Skills:
Project management of new CRM system using Prince 2/MS Project 2000, with budgetary
responsibility.
Internal business consultant - defined all system functions required to fulfil business
requirements.
Managed user acceptance testing and training of the internal project team.
Communication skills - managed the project team effectively, involving end users
throughout the process.
Sourced and managed all in-house and client data requirements.
Achievements:
Successfully specified and developed a corporate hospitality CRM system for
Corporate Innovations Ltd, completed on time and on budget, using MS Access
2000/VBA. Modules included: event management - internal resource management - supplier
management - invoicing - delegate registration - itinerary planner.
Managed the internal testing and implementation of a CTI system with IVR, ACD and
skills based routing.
Marketing Database Coordinator
Heinemann Educational Publishers. September 1998 - April 2000
Key Skills:
Proposed business processes for a new CRM system in an environment where many managers
were not confident in the use of IT systems.
Identified new or improved business opportunities through the development or
enhancement of systems and working practices.
Confident intermediary - increased the levels of communication and understanding
between the technical IT and creative marketing departments.
Achievements:
Defined and completed all sales and marketing Y2K system testing on AS400 database.
Constructed queries to produce summary reports without impacting on the AS400
transactional system.
Managed internal training of SQL product database used as the data source for the
e-commerce website.
CAREER SUMMARY
Promotions Administrator Heinemann Educational Publishers 1997 - 1998
Journal Order Processor Blackwell Science Ltd 1996 - 1997
Assistant Manager The Natural World 1996 - 1996
Student Teacher Oxford Brookes University 1995 - 1996
SOFTWARE SKILLS
MS Office 2000: Project, Access, Word, Excel, Powerpoint, VBA, Outlook
Databases: SQL Server 7.0, MS Access 2000, CRMSoft (RAD), Pro2000 (VB)
Reporting Packages: MS Access 2000, Showcase Vista, One-Up.
Miscellaneous: SQLTalk, Demoshield, Dedupe, Avalon (CTI)
PROFESSIONAL COURSES
Implementing a database in SQL Server 7.0.
Intermediate and Advanced Access 97.
Principles of Direct and Database Marketing.
EDUCATION
Degree BSc. (Hons.) Geography, 2:2, Southampton University.
A Levels Maths B - Geography B - Physics B - Ceramics D.
GCSEs Maths A - English A - Geography A - Science AA - History A -
Ceramics A - English Lit B - French C.
INTERESTS
Pottery - Gardening - Classic Motorbike Restoration - Badminton.
|