Brian Dewar Email & Phone Number

Ottawa, Canada Area

•Produced all financial reporting for the Foundation to ensure compliance with Board, Presidential and CRA expectations and requirements. •Worked with large datasets using a variety of database applications to produce actionable reports•Expertly used Excel to produce statistical analysis, data visualizations, and actionable intelligence•Wrote, edited, project-managed, and provided background research for the application for the largest grant in Algonquin College history•Managed license agreements and contracts•Analyzed information management trends and made recommendations to senior administrators •Conducted environmental scans to identify donor prospects within the Eastern Ontario region•Produced summaries and talking points for senior fundraisers, directly resulting in major gift donations •Worked with subject specialist staff throughout the College system to inform internal and external communications and correspondence •Administrated the CRM database of the Foundation, resulting in increased recordkeeping of interactions between staff and potential donors•Standardized, modernized, and implemented policies and procedures within the donation tracking system, dramatically increasing financial reporting accuracy •Provided technical training and support to a seven-person team

Produced critical academic literature summaries to inform policy decisions for VPs and Directors within the communications, scientific affairs, and government relations departments, resulting in shifts in policy to align with evidence-based research•Wrote two systematic reviews, one on therapeutic substitution of proton pump inhibitors and another on methodologies for assessing drug development costs•Gathered information from industry, governmental, and academic entities to facilitate the creation of the International Report on Access to Medicines and the Pharma FactBook•Utilized Excel, MS Access, and other tools to provide statistical support for the senior administration team as well as to produce speaking notes for Senator Ogilvie, Chair of the Senate Standing Committee on Social Affairs, Science and Technology •Designed, organized, and administrated a policy library of academic materials used to inform colleagues on healthcare and industry issues, including filing taxonomies and annotated bibliographies•Managed research projects throughout their lifecycles to ensure hard deadlines were met•Administrated, organized a webinar for, and acted as the point of contact for Rx&D’s Statistical Survey, leading to the highest participation rate in the 10-year history of the project•Used Zotero reference management software and online virtual drives to manage departmental information resources•Gained significant understanding of the Canadian health care system by supported the Regulatory Affairs, Health Technology Assessment, and Government Affairs committees•Underwent training on Canadian Anti-Spam Legislation (CASL)•Utilized an in-house cloud-based CRM application and trained staff in its use•Maintained high levels of independence and productivity while working with an off-site supervisor

Utilized MS Excel to automate all reporting of quantitative data from the Sales department, resulting in dramatically decreased error rates and increased productivity of senior management•Assisted with literature reviews and background research on health, legal and policy issues, resulting in one published, peer-reviewed paper, one book chapter, and several other papers currently under revision •Monitored and analyzed various information resources (online sources, newspapers, white papers, journals, and conference proceedings) to develop intelligence packages for middle and senior managers•Drafted briefing notes and presentation materials for sales and marketing speaking engagements•Used Zotero reference management software to create a central repository for collecting and organizing electronic documents•Created, implemented, and documented an electronic records management system and trained staff on its use •Trained employees and provided technical support to improve the achievement of research goals

Ottawa

•Collected and analyzed both qualitative and quantitative data for multiple projects •Utilized various information sources, including white papers, academic journals, and conference proceedings, to provide support to three senior academics, resulting in published papers •Utilized Sharepoint for content-management and information delivery. •Drafted an annotated bibliography for Dr. Marina Sokolova on the use of internet medical forums by patients undergoing treatments for infertility•Planned and coordinated events, workshops, conferences, and meetings•Communicated effectively with various stakeholders during projects to monitor progress and ensure deadlines were met•Assisted in the preparation of official documents, abstracts, press releases, and posters•Performed reference research for the principal investigator and other senior researchers

•Produced LibGuides and delivered training and education sessions on information systems•Successfully rebuilt and modernized the library system by testing, purchasing, installing, and administering library database, resulting in the inception of usage statistics, patron tracking, responsive acquisitions, and a searchable online catalogue•Managed the collection of paper and electronic files and archives, in addition to subscriptions to both physical and electronic media, and the scheduling and usage of meeting space•Developed an information literacy curriculum designed to meet the needs of students and teachers, leading classes 15 hours per week•Answered research questions for staff and patrons•Interviewed, hired, and trained three library pages while managing a budget of $18,000

Master Of Library And Information Studies, Health And Business Information Resources And Reference Service

Completed coursework in the use of health resources (final grade: A+)

Bachelor Of Arts, English

Wrote featured articles for the student newspaper, The Athenaeum