Deron Staffen Email & Phone Number

Regina, Saskatchewan

Maintaining continuity of the agency’s databases associated with programs, permanent collection, human resource, and administrative operations. Recognizing and documenting data irregularities or issues, identifying needs. Developing and implementing new operational workflows and managing required solutions.Ensuring grant application portal (SmartSimple) accessibility and user satisfaction. Anticipating issues, responding to questions or concerns, and taking action to resolve any actual or potential problems.Preserving working relationships with database service providers and collaborating with providers during the development, implementation, and updating of databases. Resolving complex issues and implementing of revisions and updates.Researching options for development of new databases and software, updating of existing databases, and recommendations to Management regarding the selection of off-the-shelf databases, the development of custom databases, and the enhancement of existing databases.Providing staff with training that facilitates capacity building and knowledge of best practices on the use of the agency’s databases, data, and reports, and the online application portal.Managing designated Office 365 administrative centres through Exchange Online, including identified e-mail functions.Recommending procurement and implementation of technological resources, including hardware, software, peripherals, services, and support mechanisms.Providing advice and direction on SharePoint and the expansion of its use in the agency, including the development of workflows through Power Automate.Maintaining the agency’s domains and managing related and required license renewals.

Regina, Saskatchewan

I provide administrative and program support to the Saskatchewan Arts Board's granting programs as part of the Arts Education and Community Engagement team. This includes direct administrative support to the agency's Community Engagement programs, liaising with clients regarding funding applications and reporting, and advising on administrative timelines and logistics, as well as general administrative duties such as data entry, file maintenance, directing administrative workflow, and providing project support to management.As the Arts Board's principal IT contact, I provide desktop support services for the agency, administrate the SharePoint and Exchange servers, and consult with management on equipment and software purchases.In January 2016, I was the lead on a three-month database project designed to transition us from our old DOS-based software to a more modern NoSQL database system (MongoDB). This involved a data transfer of 30,000 database records, working with the developer on the design, structure, and features of the new database, and a comprehensive data verification process.Transitioned to a full-time IT support position in October 2017 for six months in order to begin work on the implementation of our new grants management system (SmartSimple) and online application portal. As primary contact for this project, this involved the transfer of data from our interim NoSQL system to SmartSimple, an extensive data normalization process, and dealing with a sharp learning curve to understand the structure of the SmartSimple system. Nearly 30,000 database records dating back to 1991 were transferred to SmartSimple. Currently dividing my time between administrative work and continued development, administration, and implementation of SmartSimple. I am also the principal contact for our payroll and art collection databases.

Provided support to the Crew Leader as directed or when the Crew Leader was unavailable. This included supervision of Enumerators, provision of enumerating materials (census forms, pens, etc.), approval of Enumerator work hours and mileage claims, and creation of Enumerator work assignments.

Developed and designed promotional and informational materials including pamphlets, posters, PowerPoint slideshows, T-shirts.Developed and maintained the organization's web presence.General bookkeeping duties: statement reconciliations, vendor payments, bank deposits, preparing audit materials.Volunteer recruitment, training, and management.Event planning and management, including provincial, multi-territory (Western Canada Debate Tournament), and nation-level events (Canadian Student Debating Federation National Seminar; Junior Nationals Debate Tournament).