Jacob MacDougall
Data Analyst at Applied Systems- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
Topline Score
Bio
Experience
-
Applied Systems
-
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
-
-
-
City of Mississauga
-
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.
-
-
-
PointClickCare
-
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.
-
-
-
University of Waterloo
-
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
-
-
-
University of Waterloo
-
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