|
David Rose
|
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
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
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