Matthew Hooper Email and Phone Number

• Write and maintain Mass Update and Automated Export queries in Dynamics 365 using SSMS.• Build and deploy Campaign Automations in Dynamics 365 for clients e-mail marketing efforts.• Build complex Advanced Finds in Dynamics 365 to identify records for ad-hoc report requests and/or marketing efforts. • Write and maintain PL/SQL queries for ad-hoc report requests and/or requested data updates in Oracle database.• Lead UAT efforts managed in Jira for Campaign Operations department to align with Developers testing requirements/specifications on upcoming sprints. Included updates/bug fixes made in Dynamics 365 and/or Oracle database testing environments.• Troubleshoot EOD reporting issues as needed by either fixing scrambled table data using PL/SQL or fixing parameter issues in internal Reports Plus application.• Troubleshoot data choke points and data inconsistencies between Dynamics 365 and Oracle database.• Build streamlined data processing efforts at the client level all the way up to division level.• Develop and train onshore/offshore teams on new/existing processes.• Assist in training department leads on data requirements/specifications needed for efficiency in data processing efforts.• Serve as back-up to Email Systems Manager on an as-needed basis monitoring email launches for high bounce rates (this would result in troubleshooting root cause) and launch times on a PostgreSQL database in Microsoft SQL Developer. Included quality checking email setups and launching through Selligent platform.• Develop custom EOD files at the client level as needed using Visual FoxPro when specifications were outside of functional capabilities within internal Reports Plus application.• Maintain client campaigns in internal digital fundraising platform (RNL Engage) as well as reporting efforts (custom and/or standard) in Reports Plus. Included segmenting/pooling records, and custom specifications requested within available functionality of the platform.

• Wrote and maintained Mass Update and Automated Export queries in Dynamics 365 using SSMS.• Built and deployed Campaign Automations in Dynamics 365 for clients e-mail marketing efforts.• Built complex Advanced Finds in Dynamics 365 to identify records for ad-hoc report requests and/or marketing efforts. • Wrote and maintained PL/SQL queries for ad-hoc report requests and/or requested data updates in Oracle database.• Led UAT efforts managed in Jira for Campaign Operations department to align with Developers testing requirements/specifications on upcoming sprints. Included updates/bug fixes made in Dynamics 365 and/or Oracle database testing environments.• Troubleshot EOD reporting issues as needed by either fixing scrambled table data using PL/SQL or fixing parameter issues in internal Reports Plus application.• Troubleshot data choke points and data inconsistencies between Dynamics 365 and Oracle database.• Built streamlined data processing efforts at the client level all the way up to division level.• Developed and trained onshore/offshore teams on new/existing processes.• Assisted in training department leads on data requirements/specifications needed for efficiency in data processing efforts.• Served as back-up to Email Systems Manager on an as-needed basis monitoring email launches for high bounce rates (this would result in troubleshooting root cause) and launch times on a PostgreSQL database in Microsoft SQL Developer. Included quality checking email setups and launching through Selligent platform.• Developed custom EOD files at the client level as needed using Visual FoxPro when specifications were outside of functional capabilities within internal Reports Plus application.• Maintained client campaigns in internal digital fundraising platform (RNL Engage) as well as reporting efforts (custom and/or standard) in Reports Plus. Included segmenting/pooling records, and custom specifications requested within available functionality of the platform.

• Wrote and maintained Mass Update and Automated Export queries in Dynamics 365 using SSMS.• Built and deployed Campaign Automations in Dynamics 365 for clients e-mail marketing efforts.• Built complex Advanced Finds in Dynamics 365 to identify records for ad-hoc report requests and/or marketing efforts. • Wrote and maintained PL/SQL queries for ad-hoc report requests and/or requested data updates in Oracle database.• Troubleshot EOD reporting issues as needed by either fixing scrambled table data using PL/SQL or fixing parameter issues in internal Reports Plus application.• Troubleshot data choke points and data inconsistencies between Dynamics 365 and Oracle database.• Built streamlined data processing efforts at the client level all the way up to division level.• Developed and trained onshore/offshore teams on new/existing processes.• Assisted in training department leads on data requirements/specifications needed for efficiency in data processing efforts.• Served as back-up to Email Systems Manager on an as-needed basis monitoring email launches for high bounce rates (this would result in troubleshooting root cause) and launch times on a PostgreSQL database in Microsoft SQL Developer. Included quality checking email setups and launching through Selligent platform.• Developed custom EOD files at the client level as needed using Visual FoxPro when specifications were outside of functional capabilities within internal Reports Plus application.• Maintained client campaigns in internal digital fundraising platform (RNL Engage) as well as reporting efforts (custom and/or standard) in Reports Plus. Included segmenting/pooling records, and custom specifications requested within available functionality of the platform.

• Served as special assistant to the Interim Director of Information Services.• Managed 2-3 Senior Information Services Analysts to ensure KPI’s are being met.• Conducted formal presentations to department heads as needed to ensure data specifications/requirements are being followed and communicated to external clients effectively.• Updated documentation on processes as well as procedural checklists.• Met with department heads regularly to troubleshoot process gaps, ongoing issues, and best practices are being managed effectively within the division.

• Wrote and maintained PL/SQL queries for ad-hoc report requests and/or requested data updates in Oracle database.• Troubleshot EOD reporting issues as needed by either fixing scrambled table data using PL/SQL or fixing parameter issues in internal Reports Plus application.• Built streamlined data processing efforts at the client level all the way up to division level.• Developed and trained subordinates on new/existing processes.• Assisted in training department leads on data requirements/specifications needed for efficiency in data processing efforts.• Served as back-up to Email Systems Manager on an as-needed basis monitoring email launches for high bounce rates (this would result in troubleshooting root cause) and launch times on a PostgreSQL database in Microsoft SQL Developer. Included quality checking email setups and launching through Selligent platform.• Developed custom EOD files at the client level as needed using Visual FoxPro when specifications were outside of functional capabilities within internal Reports Plus application.• Maintained client campaigns in internal digital fundraising platform (RNL Engage) as well as reporting efforts (custom and/or standard) in Reports Plus. Included segmenting/pooling records, and custom specifications requested within available functionality of the platform.

• Wrote and maintained PL/SQL queries for ad-hoc report requests and/or requested data updates in Oracle database.• Led UAT efforts with Developers on the rollout of the new internal Reports Plus application. Ensured reports were producing accurate numbers and that standard client reports were accessible and executed to adhere to existing division standards.• Troubleshot EOD reporting issues as needed by either fixing scrambled table data using PL/SQL or fixing parameter issues in internal Reports Plus application.• Developed custom EOD files at the client level as needed using Visual FoxPro when specifications were outside of functional capabilities within internal Reports Plus application.• Maintained client campaigns in internal digital fundraising platform (RNL Engage) as well as reporting efforts (custom and/or standard) in Reports Plus. Included segmenting/pooling records, and custom specifications requested within available functionality of the platform.• Led trainings and wrote documentation for final report processing.• Trained calling floor supervisors on the calling pool maintenance application within the internal RNL Engage calling software.• Setup and pushed into production next day letter acknowledgements and e-messaging efforts.