ANNA KAWAMBWA
London
Summary
A motivated Database Manager with experience in maintaining database integrity and driving improved user experiences. Proficiency in database management, data segmentation, data analysis and writing system processes.
Overview
20
20
years of professional experience
8
8
years of post-secondary education
Work history
Data Manager
Cruelty Free International (Leaping Bunny Programme)
02.2024 - 10.2024
- Set up daily auditing of key CRM systems and build health-check dashboards of data flows
- Support the Senior Data Manager develop, deliver, and maintain the organisation's data strategy
- Create data export routines for a variety of planned recurring activity as well as in response to ad hoc operational requests
- Work with the Senior Data Manager in the development of new ETL processes and in the construction and implementation of programme improvement and optimisation
- Support the Senior Data Manager finesse and optimise the organisation's new Direct Debit processes
- Collaborate with Data team colleagues develop and deliver new Gift Aid claims data audit and ongoing maintenance processes
- Import donations and contacts into the CRM and reconcile with Finance on a monthly basis
- Ensure that all data is held securely and managed in accordance with the organisation's data protection obligations under GDPR and the Data Protection Act
- Support the Senior Data Manager with the financial management of the department and report budgetary information
- Work in conjunction with the Senior Data Manager and CRM Manager to harmonise data applications by remediating pain points identified through business analysis
- Support the Data Officer in troubleshooting existing data processes.
Data & Process Manager (contract)
Ovarian Cancer Action
03.2023 - 12.2023
- Capturing, processing, and recording of transactional and donor data from a variety of channels
- Data selection and segmentation for various campaigns and communications
- Improved database business rules, streamlined data processes and automation solutions to optimise the smooth running of the fundraising programme
- Ensure the accuracy, validation and integrity of data at Ovarian Cancer Action
- Support the Data & Insights manager to run reports for the overall team to help the fundraising team better understand their audiences and campaign performance
- Import and manipulation of demographics data and consent information collected from various OCA and 3rd party platforms into RE using tools like Alteryx and ImportOmatic
- Work with Supporter Care Officer to coordinate the correct coding of all financial data onto Raiser's Edge via the Fundraising Team
- Work with FR team and Finance to support the month end income reconciliation process
- Support the Finance department with any relevant Gift Aid claims
- Support the Individual Giving Manager in the development and application of appeal/package codes and requisite campaign reporting on any mass appeal on Raiser's Edge.
Supporter Data Executive (contract)
Crisis
09.2021 - 03.2023
- Analyse requests through data selection briefs and deliver complex segmented extracts for all communications
- Assist with data integrity and quality checks relating to data marketing selections, ensuring that new selections are checked and tested appropriately before delivery
- Work with Data & Technology department to ensure online digital marketing is developed and coded accurately to capture online donor behaviour and transactions for complex live and post appeal data analysis
- Work closely with Supporter Services and Finance teams to ensure postal marketing is coded accurately to capture offline donor transactions for complex live and post appeal data analysis
- Maintain proper documentation, work to and support improvement of practice within the team, ensuring understanding across the Individual Supporters team
- Assist with data specifications and requirements for the extraction of complex data sets for analysis projects with third party agencies
- Maintain and update Individual Supporters constituent records through regular pre and post appeal data cleansing and appending
- Ensure that data is processed in such a way as to be compliant with: Data Protection Act 2018 (DPA), GDPR, Telephone Preference Services (TPS), Mailing Preference Services (MPS) & HMRC and other legislative/best practice requirements.
Data and Insight Manager
Goodenough College
03.2016 - 10.2019
- Designing, implementing and maintaining all policies and procedures in relation to the use of Raisers Edge
- Ensure that all data is recorded and in compliance with the UK GDPR and keep up to date with new legislation
- Data capture of all donations and gift aid received by the College
- Develop and maintain gift management and reconciliation processes in collaboration with the College finance department and other colleagues
- Line manage the Development Administrator and work together to ensure the accurate, consistent and timely date capture and updates of alumni details on Raiser's Edge
- Ensure data hygiene by preparing and running appropriate data checks on a regular basis and implementing Key Performance Indicators to monitor data quality
- Data selections and segmentation for fundraising and marketing campaigns and analyse the results of campaigns
- Provide financial and statistical reports as required for departmental or management meetings
- Work with relevant colleagues to develop, implement and monitor systems for efficient and consistent data capture and transfer between departments and databases
- Provide training to all new staff as relevant, ensuring all training documentation is kept up-to-date
- Ensure that the database continues to operate as an effective tool for the College by analysing, recommending and implementing further developments in its use.
Data Selections Analyst
Prostate Cancer UK
11.2013 - 11.2014
- Advise the Direct Marketing Manager, and the In-memory and Legacy Manager of selection criteria and requests to improve the supporter experience and business intelligence
- Responsibility for all data selections and integrity, and in compliance with The Data Protection Act
- Analyse performance activity of supporter against campaigns in order to improve supporter journeys
- Provide regular reports and analysis findings and make recommendations to facilitate decision making in Individual Giving Team
- Responsible for maintaining proper documentation and ensuring all procedures and templates are up to date and in line with current practices
- Support the implementation of the new fulfilment house by documenting all business rules
- Train new members of the team on using Raisers Edge and Blackbaud Direct Marketing software (BBDM)
- Responsible for importing data from BBDM to Raisers Edge and verifying quality and accuracy of data
- Responsible for generate quarterly Gift Aid reports and providing details on the welcome journey programme.
Database Marketing Analyst
Royal United Services Institute (RUSI)
09.2011 - 11.2013
- Manage, develop and maintain RUSI's CRM, Blackbaud's Raisers Edge and corresponding online CMS NetCommunity
- Keep up to date with developments of Blackbaud software and identify any new developments which would be of benefit to RUSI
- Provide support for users of Raiser's Edge and NetCommunity, including delivering training and creating procedure documents
- Ongoing maintenance of contact data including cleaning, de-duping, and archiving
- Produce regular monthly reports for director level liaison, monitor Key Performance Indicators and meet any ad-hoc reporting needs
- Generate quarterly Gift Aid claim for the Finance team
- Create mailing lists for regular communications including RUSI's flagship publication the Journal, membership correspondence and conference marketing activities
- Create and implement policies to ensure the accuracy, integrity and security of the Raisers Edge database
- Design, develop and implement new functionality and advise on suitable methodologies and suggest improvements for the system
- Responsible for all imports, writing complex queries and validation of client data
- Data entry, data auditing, creating data reports & monitoring all data for accuracy.
Database and Supporter Service Manager
Seafarers UK
09.2007 - 09.2011
- Segment, prepare and deliver mailing files for use in direct marketing activities
- Managing direct debits, standing orders and running quarterly Gift Aid declarations
- Create and implement policies to ensure the accuracy, integrity and security of the Raisers Edge database
- Providing ongoing development of the database and ensuring that the database is the key tool for communications with all our donors and suppliers
- Provide training to other members of the department and ensuring compliance with policies, procedures to support fundraising practices
- Ensure that proper documentation, procedures and policies are maintained for data integrity
- Inputting daily receipts and all income from various sources including Justgiving, Virgin website and Rapidata Direct Debits on to the database
- Database clean up on duplicate records, addresses, missing information on constituent records
- Provide administrative support to the fundraising team.
Database Co-ordinator
African Medical and Research Foundation (AMREF)
02.2005 - 04.2007
- Data analysis and financial reporting from the database to ensure data is accurately reflected in the management accounts
- Set up and run a number of reports and queries
- Process all cheques, credit card payments, standing orders, direct debits and CAF vouchers
- Assist fundraising department in overseeing and updating the website and production of annual newsletters and manage Gift Aid procedures
- Provide monthly analysis to the fundraising team and assist other members with database queries
- Provide ongoing development of Raisers Edge database and regular housekeeping to ensure there are no duplicate records.
Education
Certified Accounting Technician (CAT) -
London College of Accountancy
01.2004 - 01.2005
Bachelor of Business Administration (Marketing) - undefined
Schiller International University
01.2001 - 01.2003
Diploma in Business Administration - undefined
London City College
01.2000 - 01.2001
GCSEs - undefined
International School of South Africa
01.1995 - 01.1999
Skills
- Data analysis
- Database management
- ETL development
- Reporting and documentation
- Database migrations
Training
- FastStats software, September 2022
- Salesforce CRM training, November 2013
- Blackbaud NetCommunity Fundamentals, April 2012
- Blackbaud Raisers Edge 7 Tools for the Power User and Gift Aid Management, March & May 2009
Timeline
Data Manager
Cruelty Free International (Leaping Bunny Programme)
02.2024 - 10.2024
Data & Process Manager (contract)
Ovarian Cancer Action
03.2023 - 12.2023
Supporter Data Executive (contract)
Crisis
09.2021 - 03.2023
Data and Insight Manager
Goodenough College
03.2016 - 10.2019
Data Selections Analyst
Prostate Cancer UK
11.2013 - 11.2014
Database Marketing Analyst
Royal United Services Institute (RUSI)
09.2011 - 11.2013
Database and Supporter Service Manager
Seafarers UK
09.2007 - 09.2011
Database Co-ordinator
African Medical and Research Foundation (AMREF)
02.2005 - 04.2007
Certified Accounting Technician (CAT) -
London College of Accountancy
01.2004 - 01.2005
Bachelor of Business Administration (Marketing) - undefined
Schiller International University
01.2001 - 01.2003
Diploma in Business Administration - undefined
London City College
01.2000 - 01.2001
GCSEs - undefined
International School of South Africa
01.1995 - 01.1999
Similar Profiles
Dylan MurphyDylan Murphy
Care and Enrichment Technician at American Society for Prevention of Cruelty to Animals (ASPCA), Cruelty Recovery CenterCare and Enrichment Technician at American Society for Prevention of Cruelty to Animals (ASPCA), Cruelty Recovery Center
DR. IGBAUKUM EMMANUELDR. IGBAUKUM EMMANUEL
State Programme coordinator. at International Fund for Agricultural Development Assisted Value Chain Development Programme, BenueState Programme coordinator. at International Fund for Agricultural Development Assisted Value Chain Development Programme, Benue
Samuel EhizojieSamuel Ehizojie
Communications Officer at International Road Assessment Programme (iRAP)Communications Officer at International Road Assessment Programme (iRAP)
SIMRAN NAAGARSIMRAN NAAGAR
Medical laboratory assistant at Max healthcareMedical laboratory assistant at Max healthcare
Mohammed Zia ShaheenMohammed Zia Shaheen
Founder & Principal Consultant at Loop Media-Social Media AgencyFounder & Principal Consultant at Loop Media-Social Media Agency