Jacob MacDougall

Data Analyst at Applied Systems
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Waterloo, Ontario, Canada, CA
Languages
  • English Native or bilingual proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Software Development
    • 700 & Above Employee
    • Data Analyst
      • Oct 2017 - Jan 2022

      - Delivered over 80 data migration projects, converting insurance brokerage data from multiple sources into Applied Systems’ flagship insurance management software Applied Epic. - Analyzed how insurance data migrates between systems, reviewing data pipelines for any potential errors. - Responded to clients’ requests with detailed explanations and solutions to errors in a time sensitive manner. - Advised clients on how to structure, filter and customize their individual data… Show more - Delivered over 80 data migration projects, converting insurance brokerage data from multiple sources into Applied Systems’ flagship insurance management software Applied Epic. - Analyzed how insurance data migrates between systems, reviewing data pipelines for any potential errors. - Responded to clients’ requests with detailed explanations and solutions to errors in a time sensitive manner. - Advised clients on how to structure, filter and customize their individual data migration. - Providing custom T-SQL scripts to add to their conversion in order to fulfill their specific requests. - Implemented fixes to main ETL process for all future conversions. - Coordinated timelines and scheduling for database delivery between clients and internal support teams. Show less - Delivered over 80 data migration projects, converting insurance brokerage data from multiple sources into Applied Systems’ flagship insurance management software Applied Epic. - Analyzed how insurance data migrates between systems, reviewing data pipelines for any potential errors. - Responded to clients’ requests with detailed explanations and solutions to errors in a time sensitive manner. - Advised clients on how to structure, filter and customize their individual data… Show more - Delivered over 80 data migration projects, converting insurance brokerage data from multiple sources into Applied Systems’ flagship insurance management software Applied Epic. - Analyzed how insurance data migrates between systems, reviewing data pipelines for any potential errors. - Responded to clients’ requests with detailed explanations and solutions to errors in a time sensitive manner. - Advised clients on how to structure, filter and customize their individual data migration. - Providing custom T-SQL scripts to add to their conversion in order to fulfill their specific requests. - Implemented fixes to main ETL process for all future conversions. - Coordinated timelines and scheduling for database delivery between clients and internal support teams. Show less

    • Canada
    • Government Administration
    • 700 & Above Employee
    • Finance Investments Analyst
      • May 2016 - Aug 2016

      - Calculated daily records of holdings in order to track cash flow of the city. - Designed macros in VBA to automate banking processes in MS Excel for the Treasury of Mississauga. - Predicted long term and short term trends of bonds and securities. - Scrutinized records for any discrepancies or anomalies in the cashflow data. - Calculated daily records of holdings in order to track cash flow of the city. - Designed macros in VBA to automate banking processes in MS Excel for the Treasury of Mississauga. - Predicted long term and short term trends of bonds and securities. - Scrutinized records for any discrepancies or anomalies in the cashflow data.

  • Infoplicity
    • Kanata, Ontario
    • Informatics Analyst
      • Sep 2015 - Dec 2015

      - Provided support to clients updating SQL databases to correct outdated or missing mappings. - Coordinated with internal business analysts to ensure that business rules were reflected in the database. - Constructed SQL queries for clients that required specific data to be taken from databases. - Provided support to clients updating SQL databases to correct outdated or missing mappings. - Coordinated with internal business analysts to ensure that business rules were reflected in the database. - Constructed SQL queries for clients that required specific data to be taken from databases.

    • Canada
    • Software Development
    • 700 & Above Employee
    • Quality Analyst
      • Jan 2015 - Apr 2015

      - Analyzed PointClickCare application, an online database system used to store EHRs for medical care facilities - Archived detailed reports on issues found within application for use by developers. - Coordinated with a team of developers and other quality analysts to fix issues, implement new features and determine anything that should be addressed within the application. - Tested features within the application and gave detailed feedback to determine if they were suitable for release. - Analyzed PointClickCare application, an online database system used to store EHRs for medical care facilities - Archived detailed reports on issues found within application for use by developers. - Coordinated with a team of developers and other quality analysts to fix issues, implement new features and determine anything that should be addressed within the application. - Tested features within the application and gave detailed feedback to determine if they were suitable for release.

    • Canada
    • Higher Education
    • 700 & Above Employee
    • Collaboration and Telepresence Tools Support
      • May 2014 - Aug 2014

      - Supervised videoconferencing sessions for faculty at the University of Waterloo. Jobs included setting up equipment, calling other systems, and ensuring a stable connection. - Addressed and solved any problem that occurred during these sessions in a timely and appropriate manner to ensure that the meeting was not delayed. - Maintained Adobe Connect servers and provided timely support to its users via contributing to written online documents, responding to emails and offering one-on-one… Show more - Supervised videoconferencing sessions for faculty at the University of Waterloo. Jobs included setting up equipment, calling other systems, and ensuring a stable connection. - Addressed and solved any problem that occurred during these sessions in a timely and appropriate manner to ensure that the meeting was not delayed. - Maintained Adobe Connect servers and provided timely support to its users via contributing to written online documents, responding to emails and offering one-on-one meetings. Show less - Supervised videoconferencing sessions for faculty at the University of Waterloo. Jobs included setting up equipment, calling other systems, and ensuring a stable connection. - Addressed and solved any problem that occurred during these sessions in a timely and appropriate manner to ensure that the meeting was not delayed. - Maintained Adobe Connect servers and provided timely support to its users via contributing to written online documents, responding to emails and offering one-on-one… Show more - Supervised videoconferencing sessions for faculty at the University of Waterloo. Jobs included setting up equipment, calling other systems, and ensuring a stable connection. - Addressed and solved any problem that occurred during these sessions in a timely and appropriate manner to ensure that the meeting was not delayed. - Maintained Adobe Connect servers and provided timely support to its users via contributing to written online documents, responding to emails and offering one-on-one meetings. Show less

    • Canada
    • Higher Education
    • 700 & Above Employee
    • Instructional Support Assistant
      • Sep 2013 - Dec 2013

      - Coordinated with professors to ensure that the course “Concepts for Advance Computer Usage” was meeting course goals and strict deadlines. - Curriculum for the course included SQL, HTML/CSS, and MS Excel/Visual Basic. - Reviewed, marked and provided constructive feedback on exams and weekly assignments. - Constructed and delivered over 16 different 10 minute long tutorial lectures based on course material. - Coordinated with professors to ensure that the course “Concepts for Advance Computer Usage” was meeting course goals and strict deadlines. - Curriculum for the course included SQL, HTML/CSS, and MS Excel/Visual Basic. - Reviewed, marked and provided constructive feedback on exams and weekly assignments. - Constructed and delivered over 16 different 10 minute long tutorial lectures based on course material.

Education

  • University of Waterloo
    Bachelor of Mathematics - BMath, Statistics
    2012 - 2017

Community

You need to have a working account to view this content. Click here to join now