Director Data and Analytics Integration
BMO Financial Group
Total years of experience :26 years, 3 Months
• Worked on Design for Migration of petabytes of data to be transferred in a bank acquisition via AWS Cloud technologies (DMS, SCT, Snowball, S3, Redshift) so that a $16 billion USD merger would be able to be completed on time
• Collaborated with Program, Cloud Engineering, Requirements, Capabilities, and Engineering Teams to align on design options to ensure each department understood their areas of responsibility and authority
• Worked to ensure our design for the Data Warehouses (along with all other databases) ensured 100% match between source and target systems so project execution (development, testing, and signoff) would not be delayed by several months
• Provided a gap analysis to the Senior Leadership Team on missing deliverables which would have delayed implementation by several months
• Worked on several high profile projects with the Business and Data Analytics portfolio, bringing each to successful conclusion
• Secured funding for enterprise projects
• Provided cross-functional support across different business teams to ensure best corporate result
• Worked with business units to hone the value proposition of their products and ensure cohesion in the end product as well as the roadmap
• Help business teams to define their KPIs, their measurement and ensuring all stakeholders are satisfied with our products, balancing Customer Experience (CX) needs along with Sales, Finance and Operations
• Acting as a trusted advisor and internal advocate to help refine the business vision to tangible offerings
• Presenting to management findings of analysis and encouraging data-driven decisions using PowerPoint
Worked with Hortonworks Hadoop, HUE, Hive, and Pig as well as Data Vault on several high profile projects
•Worked on major projects dealing with Vendor Performance Management, Promotion, Supply Chain, Financial Reporting, Product and others
•Used Erwin data modeling tool
•Fulfilled multiple roles within the project, based on project need
•Worked on a portfolio of data integration projects spanning over 30 different subject areas
•Worked on an agile team which delivered over 70 concurrent small to large projects over the period of 4 years.
•Created a series of extremely complex reports
•Optimized reports to run within a narrow window
•Optimized ETL and metadata so that batch report run time was decreased from 7 hours to 25 minutes
Designed conformed dimensions for a maturing Business Intelligence environment
•Wrote technical specifications for a high-profile project
•Performed reviews on technical specifications for several Data Warehousing projects involving over 100 developers
•Aided in determining database optimization for over 150 tables in Teradata
Architected, and oversaw development of projects in Healthcare, Manufacturing, Government, Finance, Insurance and other industries on over 30 projects
•Mentored junior members for Operations and Development roles
•Worked with a team of report writers to develop high impact reports
•Created Business Requirements as a Business Analyst on over 12 projects
•Development experience in Windows and UNIX environment, including scripting
•Developed ETL processes to pull high volumes of data at hourly intervals
Maintained company wide data warehouses for an international Magna group
•Worked extensively with COGNOS products and Oracle PL/SQL creating start to finish data warehouses
•Reported to the AVP Business Information and Analysis
•Co-ordinated, designed, built and lead implementation of a broker bonus system spanning three hardware platforms (OS390, Unix, Windows NT)
•Worked with the Executive to define useful corporate metrics, performed analysis, and presented findings
•Worked with the Executive to define a system of analysis based on approved metrics within a Data Warehouse environment
•Translated the system of analysis into Business Requirements for current and future projects to be undertaken by the Access To Information team in Application Development
•Liaised with an Applications Development team to perform systems analysis where required
•Co-ordinated and performed testing of systems development and maintenance
•Wrote and edited system and user manuals for new and existing systems
•Trained staff across the country on use of new systems and analysis techniques to better meet corporate objectives
•Worked in Information Services in the Application Development team to rewrite a broker bonus system
Working at a leading insurance company, worked with management to design and build a Project Tracking database resulting in a business process flow which allowed for projects to be monitored more effectively, management to be “kept in the loop”, and resources to be allocated more efficiently
•Redesigned several financial systems improving business processes resulting in turnaround time in annual processing to be reduced by 50% and more efficient use of resources in three departments
Worked in a variety of computer languages on a variety of hardware platforms to learn the basics of programming, project workflow and project management.
Work in marketing in an international context
Majored in Accounting. As a result of my education, I wrote and passed my entrance exam to the Certified Management Accountant program but deferred for a year (then changed direction). Also enjoyed languages (French, Spanish, Russian, Japanese).
This is my high school education. Probably considered not overly telling for someone at my stage in his/her career.