Database Coordinator
Current• Database Administration of two major databases of the company named Blackbaud Raiser’s Edge (RFDS VIC Donor Database) and COVID19 Victoria Section database• Maintaining back end database architecture, dictionaries, naming conventions, integrity checks, troubleshooting to ensure accuracy, completeness and smooth functioning of database• Generating regular and Ad-hoc reports with useful insights to cater different organisational levels ranging from executive management to operational teams• Undertaking data extraction. Analysis, manipulation and reporting• Requirement gathering, data and process modelling and associated documentation creation for two major projects currently in progress• System and functional specification recognition through stakeholder meetings and duly documentation• Business process re-engineering to identify, analyse and evaluate current inefficiencies and action better technology oriented solutions and automations for optimal business practice. • Creation and maintenance of user procedures, knowledge bases for other users in order to make the best use of technological resources organisation host• Working with a project team to move data across whole organisation to a cloud warehouse in snowflake which involves tasks such as data modelling, curating, flow settings and re-creating existing regular reports directly from cloud warehouse• Carrying out fundraising benchmarking project with external providers through proper data extractions, preparations and coordinating with the fundraising teams in generating required reporting