IAS
  • Home
  • Cardio-1
  • Caribbean Boutique Hotels
  • Plummy
  • HiPoint
    • Agricultural Pollution
  • Terratonics
  • Contact
  • About
  • Services
    • Startup to Unicorn
    • Funding Europe
    • Funding India
    • Digital Transformation
    • Digital Strategies
    • IT Asset Management
    • Data Ecosystems
    • Cloud Services
    • Strategic Implementation
    • Virtual Leaders
    • Audit & Accounting
      • Accounting & Financial Reporting
      • Internal Audit Outsourcing
      • Accounting Outsourcing
      • IFRS
      • Transaction Services
    • Risk and Compliance
      • Enterprise Risk
      • Operational Risk
      • Third-party Risk
      • Basel III
      • Corporate Social Responsibility
      • Training
    • Covid/BCP
    • Credit
      • Basel IV
    • AML
      • AML Training
    • Cyber Security
    • Marketing
    • Trading
    • Privacy
    • Change Management
  • Industries
    • Financial Services
    • Capital Markets
    • Structured Finance
    • Pension Services
    • Credit Unions
    • Asset Management
    • Brokerage
    • Corporations
  • Experts
    • Ken Clarke
    • Bijan Alagheband
    • Basel Anbari
    • Andrea Aimi
    • Wadih Antoun
    • Kapil Arya
    • Katia Barakat
    • Sharon Bauer
    • Mo Bhamra
    • Tim Boucher (CIA)
    • Dan Brennan
    • Michael CamilleriI
    • Michael Castro
    • Chiranjib Chatterjee
    • Mumtaz Chaudhary
    • Shaheen Chaudhary
    • Sudha Datta
    • Mark Dougherty
    • Warren D'Souza
    • André Fortier
    • Mike Firth
    • Frank Grigg
    • Paul Hedges
    • Andrew Hockin (Compliance)
    • Ken Green
    • Harry Gundy
    • Jim Harris
    • Mitch Hirshhorn
    • Sumit Jha
      • Sumit Experience
    • Elyan Jabre
    • Balveen Kaur
    • Kshitij Kaushal
    • Rohin Khurana
    • Data - Kieng Iv
    • Ron Kusano
    • 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
    • David Rose
    • Dhritiman Roy
    • Nandini Roy
    • Dhruv Sachdev
    • Dominic Vogel
    • Bing Wang
    • Terence Yhip
    • Digital Solutions
  • Careers
  • Privacy Policy
  • Disclaimer
  • Home
  • Cardio-1
  • Caribbean Boutique Hotels
  • Plummy
  • HiPoint
    • Agricultural Pollution
  • Terratonics
  • Contact
  • About
  • Services
    • Startup to Unicorn
    • Funding Europe
    • Funding India
    • Digital Transformation
    • Digital Strategies
    • IT Asset Management
    • Data Ecosystems
    • Cloud Services
    • Strategic Implementation
    • Virtual Leaders
    • Audit & Accounting
      • Accounting & Financial Reporting
      • Internal Audit Outsourcing
      • Accounting Outsourcing
      • IFRS
      • Transaction Services
    • Risk and Compliance
      • Enterprise Risk
      • Operational Risk
      • Third-party Risk
      • Basel III
      • Corporate Social Responsibility
      • Training
    • Covid/BCP
    • Credit
      • Basel IV
    • AML
      • AML Training
    • Cyber Security
    • Marketing
    • Trading
    • Privacy
    • Change Management
  • Industries
    • Financial Services
    • Capital Markets
    • Structured Finance
    • Pension Services
    • Credit Unions
    • Asset Management
    • Brokerage
    • Corporations
  • Experts
    • Ken Clarke
    • Bijan Alagheband
    • Basel Anbari
    • Andrea Aimi
    • Wadih Antoun
    • Kapil Arya
    • Katia Barakat
    • Sharon Bauer
    • Mo Bhamra
    • Tim Boucher (CIA)
    • Dan Brennan
    • Michael CamilleriI
    • Michael Castro
    • Chiranjib Chatterjee
    • Mumtaz Chaudhary
    • Shaheen Chaudhary
    • Sudha Datta
    • Mark Dougherty
    • Warren D'Souza
    • André Fortier
    • Mike Firth
    • Frank Grigg
    • Paul Hedges
    • Andrew Hockin (Compliance)
    • Ken Green
    • Harry Gundy
    • Jim Harris
    • Mitch Hirshhorn
    • Sumit Jha
      • Sumit Experience
    • Elyan Jabre
    • Balveen Kaur
    • Kshitij Kaushal
    • Rohin Khurana
    • Data - Kieng Iv
    • Ron Kusano
    • 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
    • David Rose
    • Dhritiman Roy
    • Nandini Roy
    • Dhruv Sachdev
    • Dominic Vogel
    • Bing Wang
    • Terence Yhip
    • Digital Solutions
  • Careers
  • Privacy Policy
  • Disclaimer
Search
Picture

David Rose

​
Data Analytics

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
  • Cardio-1
  • Caribbean Boutique Hotels
  • Plummy
  • HiPoint
    • Agricultural Pollution
  • Terratonics
  • Contact
  • About
  • Services
    • Startup to Unicorn
    • Funding Europe
    • Funding India
    • Digital Transformation
    • Digital Strategies
    • IT Asset Management
    • Data Ecosystems
    • Cloud Services
    • Strategic Implementation
    • Virtual Leaders
    • Audit & Accounting
      • Accounting & Financial Reporting
      • Internal Audit Outsourcing
      • Accounting Outsourcing
      • IFRS
      • Transaction Services
    • Risk and Compliance
      • Enterprise Risk
      • Operational Risk
      • Third-party Risk
      • Basel III
      • Corporate Social Responsibility
      • Training
    • Covid/BCP
    • Credit
      • Basel IV
    • AML
      • AML Training
    • Cyber Security
    • Marketing
    • Trading
    • Privacy
    • Change Management
  • Industries
    • Financial Services
    • Capital Markets
    • Structured Finance
    • Pension Services
    • Credit Unions
    • Asset Management
    • Brokerage
    • Corporations
  • Experts
    • Ken Clarke
    • Bijan Alagheband
    • Basel Anbari
    • Andrea Aimi
    • Wadih Antoun
    • Kapil Arya
    • Katia Barakat
    • Sharon Bauer
    • Mo Bhamra
    • Tim Boucher (CIA)
    • Dan Brennan
    • Michael CamilleriI
    • Michael Castro
    • Chiranjib Chatterjee
    • Mumtaz Chaudhary
    • Shaheen Chaudhary
    • Sudha Datta
    • Mark Dougherty
    • Warren D'Souza
    • André Fortier
    • Mike Firth
    • Frank Grigg
    • Paul Hedges
    • Andrew Hockin (Compliance)
    • Ken Green
    • Harry Gundy
    • Jim Harris
    • Mitch Hirshhorn
    • Sumit Jha
      • Sumit Experience
    • Elyan Jabre
    • Balveen Kaur
    • Kshitij Kaushal
    • Rohin Khurana
    • Data - Kieng Iv
    • Ron Kusano
    • 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
    • David Rose
    • Dhritiman Roy
    • Nandini Roy
    • Dhruv Sachdev
    • Dominic Vogel
    • Bing Wang
    • Terence Yhip
    • Digital Solutions
  • Careers
  • Privacy Policy
  • Disclaimer