IAS
  • Home
  • Plummy
  • Terratonics
  • HiPoint
  • Contact
  • About
  • Services
    • Startup to Unicorn
    • Funding Europe
    • Funding India
    • Digital Transformation
    • IT Asset Management
    • Data Ecosystems
    • Cloud Services
    • Strategic Implementation
    • Virtual Leaders
    • Virtual CFO
    • Audit & Accounting
      • Accounting & Financial Reporting
      • Internal Audit Outsourcing
      • Accounting Outsourcing
        • Registration Accounting
      • IFRS
      • ESG Reporting
      • Transaction Services
    • Risk and Compliance
      • Enterprise Risk
      • Operational Risk
      • Third-party Risk
      • Fraud Risk
        • Fraud Risk Framework
      • Exempt Market Dealers
      • Basel III
      • Corporate Social Responsibility
      • Training
    • Covid/BCP
    • Credit
      • Basel IV
    • AML
      • AML Training
      • AML Checking
    • Cyber Security
    • Marketing
    • Trading
    • Privacy
    • Security, Intelligence & Investigations
      • Surveillance
      • Counterfeit, Copyright & Brand Forgery
    • Change Management
  • Industries
    • Financial Services
    • Capital Markets
    • Structured Finance
    • Pension Services
    • Credit Unions
    • Asset Management
    • Esports Gaming
    • Brokerage
    • Pharma & Healthcare
    • Cannabis
      • Cannabis Sector Risks
  • Assignments
    • IT Asset Management
    • Internal Audit
    • Credit Risk
    • Strategy & M&A
    • AML
    • Compliance
    • Project Management
  • Experts
    • Ken Clarke
    • Bijan Alagheband
    • Basel Anbari
    • Andrea Aimi
    • Wadih Antoun
    • Kapil Arya
    • Katia Barakat
    • Sharon Bauer
    • Mo Bhamra
    • Michael BiZ (Ph.D.)
    • Tim Boucher (CIA)
    • Dan Brennan
    • Chris Caldwell
    • Michael CamilleriI
    • Michael Castro
    • Chiranjib Chatterjee
    • Mumtaz Chaudhary
    • Shaheen Chaudhary
    • Terry Chong
    • James Clayton
    • Sudha Datta
    • Mark Dougherty
    • Warren D'Souza
    • Nabil Eldeh
    • André Fortier
    • Mike Firth
    • Frank Grigg
    • Paul Hedges
    • Andrew Hockin (Compliance)
    • Ken Green
    • Harry Gundy
    • Jim Harris
    • Tim Hanlon
    • Mitch Hirshhorn
    • Sumit Jha
      • Sumit Experience
    • Elyan Jabre
    • Balveen Kaur
    • Kshitij Kaushal
    • Rohin Khurana
    • Data - Kieng Iv
    • Ron Kusano
    • Tony Kwan
    • Rebecca Lai
    • Mark Levesley
    • Cecily Ma
    • Tom O'Carroll
    • Simran Makkar
    • Sahil Malik
    • Terry Martinuk
    • Ed Mathur
    • David McIntosh
    • Indranil Mitra
    • David O'Marra
    • Arlene Palango
    • Doug Pirie
    • Karthikeyan Raaj
    • Jayanth Rao
    • Andrew Richardson
    • David Rose
    • Dhritiman Roy
    • Nandini Roy
    • Dhruv Sachdev
    • Martin Seaton
    • Devanshi Sharma
    • Bill Shek
    • Jane Shen
    • Glenna Smith
    • Ben Swartz
    • Rajesh Varma
    • Dominic Vogel
    • Paul Wallis
    • Bing Wang
    • Ira Wijesooriya
    • Terence Yhip
    • Phil Zanotti
    • Digital Solutions
  • Comparison
  • Leadership
  • Careers
  • Privacy Policy
  • Disclaimer
  • Home
  • Plummy
  • Terratonics
  • HiPoint
  • Contact
  • About
  • Services
    • Startup to Unicorn
    • Funding Europe
    • Funding India
    • Digital Transformation
    • IT Asset Management
    • Data Ecosystems
    • Cloud Services
    • Strategic Implementation
    • Virtual Leaders
    • Virtual CFO
    • Audit & Accounting
      • Accounting & Financial Reporting
      • Internal Audit Outsourcing
      • Accounting Outsourcing
        • Registration Accounting
      • IFRS
      • ESG Reporting
      • Transaction Services
    • Risk and Compliance
      • Enterprise Risk
      • Operational Risk
      • Third-party Risk
      • Fraud Risk
        • Fraud Risk Framework
      • Exempt Market Dealers
      • Basel III
      • Corporate Social Responsibility
      • Training
    • Covid/BCP
    • Credit
      • Basel IV
    • AML
      • AML Training
      • AML Checking
    • Cyber Security
    • Marketing
    • Trading
    • Privacy
    • Security, Intelligence & Investigations
      • Surveillance
      • Counterfeit, Copyright & Brand Forgery
    • Change Management
  • Industries
    • Financial Services
    • Capital Markets
    • Structured Finance
    • Pension Services
    • Credit Unions
    • Asset Management
    • Esports Gaming
    • Brokerage
    • Pharma & Healthcare
    • Cannabis
      • Cannabis Sector Risks
  • Assignments
    • IT Asset Management
    • Internal Audit
    • Credit Risk
    • Strategy & M&A
    • AML
    • Compliance
    • Project Management
  • Experts
    • Ken Clarke
    • Bijan Alagheband
    • Basel Anbari
    • Andrea Aimi
    • Wadih Antoun
    • Kapil Arya
    • Katia Barakat
    • Sharon Bauer
    • Mo Bhamra
    • Michael BiZ (Ph.D.)
    • Tim Boucher (CIA)
    • Dan Brennan
    • Chris Caldwell
    • Michael CamilleriI
    • Michael Castro
    • Chiranjib Chatterjee
    • Mumtaz Chaudhary
    • Shaheen Chaudhary
    • Terry Chong
    • James Clayton
    • Sudha Datta
    • Mark Dougherty
    • Warren D'Souza
    • Nabil Eldeh
    • André Fortier
    • Mike Firth
    • Frank Grigg
    • Paul Hedges
    • Andrew Hockin (Compliance)
    • Ken Green
    • Harry Gundy
    • Jim Harris
    • Tim Hanlon
    • Mitch Hirshhorn
    • Sumit Jha
      • Sumit Experience
    • Elyan Jabre
    • Balveen Kaur
    • Kshitij Kaushal
    • Rohin Khurana
    • Data - Kieng Iv
    • Ron Kusano
    • Tony Kwan
    • Rebecca Lai
    • Mark Levesley
    • Cecily Ma
    • Tom O'Carroll
    • Simran Makkar
    • Sahil Malik
    • Terry Martinuk
    • Ed Mathur
    • David McIntosh
    • Indranil Mitra
    • David O'Marra
    • Arlene Palango
    • Doug Pirie
    • Karthikeyan Raaj
    • Jayanth Rao
    • Andrew Richardson
    • David Rose
    • Dhritiman Roy
    • Nandini Roy
    • Dhruv Sachdev
    • Martin Seaton
    • Devanshi Sharma
    • Bill Shek
    • Jane Shen
    • Glenna Smith
    • Ben Swartz
    • Rajesh Varma
    • Dominic Vogel
    • Paul Wallis
    • Bing Wang
    • Ira Wijesooriya
    • Terence Yhip
    • Phil Zanotti
    • Digital Solutions
  • Comparison
  • Leadership
  • Careers
  • Privacy Policy
  • Disclaimer
Search
Picture

David Rose

​
Data Analytics

Picture
PROFESSIONAL EXPERIENCE

RBC, Chief Data Office - Toronto, Ontario June 2018 - Nov 2018
Report Specialist (June 2018 - Present) – 5 Month Contract
Developed SQL Views and Stored Procedures to create custom Tableau Reporting for Collibra Application
Worked on developing data connectors to pull data from Collibra Data Cloud to a SQL Database
Managed the Technical Project Plan and weekly Project Status Report that was presented to Senior Management outlining status progress, issues and impediments.

RBC
, Internal Audit, Application & Audit Technology - Toronto, Ontario 2003-2017
(Corporate Restructure – package)
Sr. Analytic Manager (2008-2017)
Managed and Coached 7 technical Analyst for 3 years and 2 Business Analysts for 5 years in reaching their objectives and delivering business results, including and training required on technical and business knowledge
Collaborate with Analytic Managers and Technical Analyst to provide input and guidance in translating business requirements; improved data extract process, increased accuracy of data extraction and decrease time and effort required for current and future request.
Partner with Audit Leads to develop analytic requirements to support audits across banking, technology and finance platforms. Allowing Auditors to do full population testing instead of sample testing of risks and controls
Provided Data and Analytics to Auditors including data samples and exceptions. Presenting data in a variety of ways including pie charts, line charts, scatter graphs and heat maps. Analyze results to understand the extent of the findings and anomalies, and summarizing the results
Developed and automated audit analytic reporting including analytic task scheduling, time management, tracking actual vs planned analytic hours and ad hoc reporting. Saved 10 hours in total per week for 5 Analytic Managers in creating automated reports.

Sr. Technical Analyst (2003-2008)
Developed Internal Audit Metric Dashboard for Continuous Auditing in Adobe Flash, Action script and ColdFusion.
Extracted, compiled and tracked data and analyzed data to generate reports.
Created and automated the data extraction from the Internal Control Reporting system (ICR) used in traditional and continuous audits for Personal Banking.
Created and developed various queries to support Analytic Managers and Auditors for audits across banking platforms.

Scotia Bank, Human Recourses - Toronto, Ontario 2002
Report Analyst (Contract position – 6 months)
Assisted in the implementation of the AIM software application which provides the planning and support of the Executive Total Compensation Plan administered by Executive Services
Provided data analysis and data mapping for new application and other source systems
Created custom ad hoc web reports using Crystal Reports, Microsoft Access / Excel and SQL server 2000

Arkipelago, Toronto, Ontario April 2001 - Dec 2001
Telecom Application Development Company - specialized application for network planning, design and inventory management for the telecommunication industry
Project Manager
Project managed a team of up to 10 developers. Developing applications in C++, Visual Basic using Oracle, SQL Server and MS Access as the backend database.
Technical liaison between the development team and clients
Reviewed and wrote Functional Specifications, Test Plans and other Project related documents. Created data/process flowcharts and performed logical data analysis
Ontario Power Generation (formerly Ontario Hydro), Toronto, Ontario
1990 - 2000 Programmer / Analyst

EDUCATION and PROFESSIONAL DEVELOPMENT 

SAS, SQL, Project Management, Collaboration, Coaching, Six Sigma: RBC (Internal Training)
Collibra Level Expert I and II

Python, R and Machine learning: DataCamp.com and Udemy.com (in progress)

Programming and System Analysis (2 year program) - Fanshawe College, London Ontario
Accounting Fundamentals – Sheridan College, Oakville, Ontario
  • Home
  • Plummy
  • Terratonics
  • HiPoint
  • Contact
  • About
  • Services
    • Startup to Unicorn
    • Funding Europe
    • Funding India
    • Digital Transformation
    • IT Asset Management
    • Data Ecosystems
    • Cloud Services
    • Strategic Implementation
    • Virtual Leaders
    • Virtual CFO
    • Audit & Accounting
      • Accounting & Financial Reporting
      • Internal Audit Outsourcing
      • Accounting Outsourcing
        • Registration Accounting
      • IFRS
      • ESG Reporting
      • Transaction Services
    • Risk and Compliance
      • Enterprise Risk
      • Operational Risk
      • Third-party Risk
      • Fraud Risk
        • Fraud Risk Framework
      • Exempt Market Dealers
      • Basel III
      • Corporate Social Responsibility
      • Training
    • Covid/BCP
    • Credit
      • Basel IV
    • AML
      • AML Training
      • AML Checking
    • Cyber Security
    • Marketing
    • Trading
    • Privacy
    • Security, Intelligence & Investigations
      • Surveillance
      • Counterfeit, Copyright & Brand Forgery
    • Change Management
  • Industries
    • Financial Services
    • Capital Markets
    • Structured Finance
    • Pension Services
    • Credit Unions
    • Asset Management
    • Esports Gaming
    • Brokerage
    • Pharma & Healthcare
    • Cannabis
      • Cannabis Sector Risks
  • Assignments
    • IT Asset Management
    • Internal Audit
    • Credit Risk
    • Strategy & M&A
    • AML
    • Compliance
    • Project Management
  • Experts
    • Ken Clarke
    • Bijan Alagheband
    • Basel Anbari
    • Andrea Aimi
    • Wadih Antoun
    • Kapil Arya
    • Katia Barakat
    • Sharon Bauer
    • Mo Bhamra
    • Michael BiZ (Ph.D.)
    • Tim Boucher (CIA)
    • Dan Brennan
    • Chris Caldwell
    • Michael CamilleriI
    • Michael Castro
    • Chiranjib Chatterjee
    • Mumtaz Chaudhary
    • Shaheen Chaudhary
    • Terry Chong
    • James Clayton
    • Sudha Datta
    • Mark Dougherty
    • Warren D'Souza
    • Nabil Eldeh
    • André Fortier
    • Mike Firth
    • Frank Grigg
    • Paul Hedges
    • Andrew Hockin (Compliance)
    • Ken Green
    • Harry Gundy
    • Jim Harris
    • Tim Hanlon
    • Mitch Hirshhorn
    • Sumit Jha
      • Sumit Experience
    • Elyan Jabre
    • Balveen Kaur
    • Kshitij Kaushal
    • Rohin Khurana
    • Data - Kieng Iv
    • Ron Kusano
    • Tony Kwan
    • Rebecca Lai
    • Mark Levesley
    • Cecily Ma
    • Tom O'Carroll
    • Simran Makkar
    • Sahil Malik
    • Terry Martinuk
    • Ed Mathur
    • David McIntosh
    • Indranil Mitra
    • David O'Marra
    • Arlene Palango
    • Doug Pirie
    • Karthikeyan Raaj
    • Jayanth Rao
    • Andrew Richardson
    • David Rose
    • Dhritiman Roy
    • Nandini Roy
    • Dhruv Sachdev
    • Martin Seaton
    • Devanshi Sharma
    • Bill Shek
    • Jane Shen
    • Glenna Smith
    • Ben Swartz
    • Rajesh Varma
    • Dominic Vogel
    • Paul Wallis
    • Bing Wang
    • Ira Wijesooriya
    • Terence Yhip
    • Phil Zanotti
    • Digital Solutions
  • Comparison
  • Leadership
  • Careers
  • Privacy Policy
  • Disclaimer