John C. Email & Phone Number

Edinburgh, Scotland, United Kingdom

The Database Officer is central to the effective and compliant management of Myeloma UK's CRM. The role demands a balance of technical expertise in data management and strong interpersonal skills to support and train staff, ensuring the database is used to its fullest potential across the organization. This position also involves significant collaboration with the finance team, responsibility for maintaining GDPR compliance, and a focus on continuous improvement in data management processes.Key Responsibilities Database Management Data Integrity and Clean-up. Compliance with Data Protection Laws: including GDPR, EDPR, and PECR. Cross-team Database Management: key contact for database-related issues. Reporting and Benchmarking: designing reports and creating benchmark indicators. Policy and Compliance: working with the Director of Marketing & Communications and the Digital Marketing Manager Process Development: Reviews and develops administrative processes Vendor Liaison: liaison to Blackbaud, the CRM supplier Financial Responsibilities Fundraising Reports: assists the Fiance team to deliver key monthly fundraising reports. Direct Debit Management: assists the Finance Team's direct debit process. Donation Management: ensure the accuracy of all donation records. Income Reconciliation: to reconcile income between the CRM database and the finance system. Gift Aid: ensuring that the database is up-to-date and accurate. Training and Support Training Users: provides training and ongoing support. Technical Issue Resolution: liaising regularly with Blackbaud’s helpdesk. Documentation: procedure guides, and crib sheets. Web Integration: between CRM and Myeloma UK website. Legislative Awareness: the Institute of Fundraising (IoF), Information Commissioner's Office (ICO), and the Office of the Scottish Charity Regulator (OSCR).

Glasgow, United Kingdom

The Donor Supporter Officer (DSO) is the Raiser's Edge database administrator, and helps maximise income generated from individuals across Scotland. The DSO processes individual gifts, co-ordinate the day to day running of donor recruitment campaigns, oversee social media campaigns, undertake research on behalf of the Donor Care team, produce relative publications relating to their post and be involved in donor recruitment, development, retention, stewardship and committed giving for Sense Scotland Fundraising (FR) Team. The DSO contributes to the on-going development & execution of the Donor Marketing plans and strategies & assist in maximising the income of individual donors, through a variety of direct marketing campaigns. • Deputise for Individual Giving (IG) Manager when necessary• Provide support & training to users on Raiser's Edge CRM• Take the lead in the management of the Raiser's Edge CRM• Manage all data requirements for the FR team and external agencies with whom we are working• Administer Gift Aid collection• Provide database support for telephone and face to face fundraising campaigns including data selection, criteria & data output and end of campaign analysis• Co-ordinate the daily activity concerning donor recruitment & retention campaigns, including complaint handling, activity reports & website updating • Provide strategic input to the IG Plan• DDi/SO - produce accurate regular data imports• Overseeing our online donation system & analyse/report on donor activity• Develop campaigns & appeals, with the IG Manager & Head of Fundraising• Monitor, analyse & report on individual campaigns to ensure competent and compliant campaign and financial management• Use telephone agency for recruitment, Gift Aid, conversion & upgrade campaigns• Use direct marketing agencies• Use fundraising agencies to recruit prospective & new donors• Contribute to the development of donor recruitment & retention plans, strategies and budgets

Alloa

Qualification: Blackbaud Certified (bCRE) - The Raiser's Edge: Associate. Scottish Autism is an independent Scottish charity committed to working for the rights and quality of life of people with autism. The organisation offers a range of support for people with autism including education, day care, supported living, vocational opportunities, respite and outreach.Key skills:• Indepth knowledge of Raiser’s Edge database.• Advanced knowledge of MS Office packages.• Strong communication skills with excellent attention to detail. • The ability to work in a team and prioritise workload.Key Responsibilities:• Develop and maintain Raisers Edge database as a CRM tool that is used by a wide range of services within the organisation.• Acting as a champion for data integrity and consistency.• Responding to information requests and queries through exports and reports and ensure consistent data entry. • Ensure the data held within the system is used in accordance with the Data Protection Act and meets other regulatory requirements.• Evaluate systems and processes and identify areas for improvement.• Ensure that the system is used to its full capacity.Additional "The Raiser's Edge"​ Blackbaud Qualifications:• Raiser's Edge Essentials 2• Reports & Dashboard Essentials• Query Essentials• Analytical Reporting• Import• Maintaining Your Raiser's Edge Data• Reports• Database Doctor• Tools for the Power User• Mail Essentials• Mail Beyond Essentials• Gift Aid• Financial and Pledge Reporting• Query Beyond Essentials

Alloa

NB: THESE ARE CONCURRENT ROLES I PERFORMED AS WELL AS MY DATABASE ADMIN ROLEMy Roles:- Data Migration Technician - Key User (Raiser's Edge - CRM Database)Project Goal:- Creating a single view of Scottish Autism by digital transformation, enabling us to improve the delivery of quality services to our service users, better engage staff, and transform our support activities.6 PRODUCTS INTERGRATED:- Mobizio – Mobile access People Planner – SU database, staff info Dimensions – Finance ThankQ – CRM Select HR – HR including L&D Select Pay – Payroll Also: Focal Point (expenses, procurement), Reporting & Recruitment modulePROJECT APPROACH:-Define, Build, Test and Implement approachBuild will be based on the requirements utilizing Subject Matter Experts (SME) Data Migration Strategy to be developed to create migration plan, migration scripts & testing.Business scenarios will be created by Key users & the solution will be fully tested against these scenarios by Key and end users. Business scenarios will be the focus of the training & testing phase.Provide training guides Piloting will be used to drive out issuesGo-live will be “Big Bang” DATA MAGICIAN ROLE:-Data extraction, transformation, cleansing and migration activitiesEnsuring data quality, integrity & completenessWork with subject matter experts and project team to identify, define, collate, document & communicate the data migration requirementsPerform migration & testing of static data and transaction data from one core system to anotherKEY USER ROLE:-Responsible for defining requirements and business processDevelop internal policies and procedures for system usageDefining acceptance criteria, procedures and conducting User Acceptance Testing writing of scenarios, test plans and scripts testing software in workshop scenariosAssist with developing end user training & resourcesTrain end usersBecome the expert users who provide first line support to end-users after go-live

Alloa

Volunteer position. Reachout With Arts In Mind is a community capacity-building project, an arts project, a mutual-aid project, and also, critically, a popular adult learning project. Role: Redesign and maintain company website. (reachoutwithartsinmind.org.uk) Include attending member meeting to collate content ideas & suggestions that members wanted added to the site.

Stirling

Volunteer position. SEO consultancy and web development of the Museum’s website and on-line shop (argylls.co.uk). Reviewed website to address concerns to be more user friendly and for areas of improvements. Then redeveloped website based on findings.

Edinburgh

Client facing role, requiring good analytical, communication and organisational skills. Working in a target driven environment, I am skilled in the design and build of client CMS and e-commerce websites using a variety of industry standard tools.Key Skills & Responsibilities• Obtaining design brief from clients via telephone or face-to-face meetings• Delivering interactive support in setting up web starter kits• Designing company logos and branding in line with customer requirements• Encouraging customers to maximise their ecommerce opportunities using an online business directory• Ability to manage own projects & achieve daily/monthly targets• Excellent client facing skills• Creating a design mock-up in line with the client's requirements• Building a custom CMS template in XHTML/CSS, optimizing the site for search engines• Training clients to maintain their CMS site and any additional components and functionality that's includedExample websites include: www.astra-antiques.co.uk www.lanarkprintco.com www.acu-channel.co.uk www.electrician-inmaidstone.co.uk www.transonicofsheffield.co.uk www.fideliscl.com www.houseroofcleaning.co.uk www.johnmant-solicitors.co.uk (These are active websites and may have been altered by the client since the original design)EXPERIENCE: Joomla, Photoshop, HTML, CSS, SEO, Artisteer, Front End Design, E-commerce, Google Analytics

Stirling

Senior Customer Services Representative Capita: AXA - Stirling April 2008 – Dec 2010Tier 2 Specialist - Responsible for Managing Promise Delivery System (PDS); Coaching and Call-Handling: - From IFAs, Policyholders, Trustees, Solicitors & Intermediaries, ensuring that a high level of professionalism and accuracy is maintained at all times.Key Skills & Responsibilities:• Provide technically accurate, efficient and compliant responses to client enquiries• Contact customers by telephone, fax, e-mail or letter to resolve queries/obtain information• Handling complaints in line with area guidelines• Excellent inter-personal skills and ability to quickly establish rapport with people at all corporate levels• Excellent communication, PC skills and mathematical reasoning skills• Good understanding of all relevant legislation e.g. Data Protection Act, Money Laundering• Check work of others where appropriate to ensure that standards of accuracy, clarity and financial integrity are maintained and that Treating Customers Fairly principles are upheld• Support and take active role in service and process improvement initiatives and projects• Deal with client data ethically and in accordance with Financial Services Authority rules• Ensure that compliance with the FSA and the Data Protection Act is maintained throughoutAchievements:• Project Work: Contingency Team Project consultant responsible for the successful transfer of the AXA assurance contract from Bristol to Stirling. Included the creation of training materials and coaching for all new staff. (Our entry for the repatriation of the Sun Life Direct Contact Centre from Bangalore to Stirling won the Financial Services Outsourcing Project of the Year Award, at the National Outsourcing Association Awards Ceremony in London, Oct 2010)

Stirling

To provide a good customer service by accurately processing and authorising a variety of customer transactions, including complex and non standard transactions. Then processing within agreed service levels and approved financial authority levels where appropriate.Achievements:• Project Leader in a Computer Transactions System project entitled ‘4Front’• ‘Advisor Webpage’ Editor: Activities and interests for staff within the Advisor Channel• Awarded Financial Planning Certificates 1 & 2 - Chartered Insurance Institute (CII)• Customer Care Star Performer certificate• EDI SVQ L2 in Customer Service

Postgraduate Diploma, Information Technology, Diploma

Activities and Societies: Role-playing SocietyStudies: • Programming using: Java, HTML, COBOL, C++, UML • Utilised Databases and 4th gen..

Ba (Hons), Hr Management, Honours

Additional Subjects studied: * Economics * Accountancy * Philosophy * Business Studies.

Btec National Diploma, Business And Finance, 5 Distinctions & 1 Merit (Top 1% Of College)

BTEC National Diploma, Business and Finance