RBC, Chief Data Office - Toronto, OntarioJune 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, Ontario2003-2017 (Corporate Restructure – package) Sr. Analytic Manager(2008-2017) Managed and Coached7 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 - Dec2001 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