Ken Constable, Cfa, Msc Email & Phone Number

Canada

Toronto, Ontario, Canada

Machine Learning: Design and implementation of machine learning models with applications in sales forecasting, prospect scoring and prioritization, forecasting headcount and related expenses, predicting help-desk tickets, and forecasting Mergers & Acquisition activity (Python, Scikit, XGBoost, Tensorflow, Sagemaker)Data Engineering: Design and implementation of data pipelines to automate processes (Airflow, Sagemaker, Python, SQL, AWS S3, AWS Glue, AWS Redshift, ETL, ELT)Data… Show more Machine Learning: Design and implementation of machine learning models with applications in sales forecasting, prospect scoring and prioritization, forecasting headcount and related expenses, predicting help-desk tickets, and forecasting Mergers & Acquisition activity (Python, Scikit, XGBoost, Tensorflow, Sagemaker)Data Engineering: Design and implementation of data pipelines to automate processes (Airflow, Sagemaker, Python, SQL, AWS S3, AWS Glue, AWS Redshift, ETL, ELT)Data Analytics & Visualization: Design and implementation of analytical dashboards for executives to inform data-driven decisions (Tableau, SQL, AWS Redshift, AWS S3) Show less

Toronto, Canada Area

 Data Warehouse Design & Implementation: Senior Business Systems Analyst working on the design and Implementation of a new Investment Data Warehouse.  Data Analysis/Profiling: analysis of current investment systems (Eagle Investment Systems), and Integrations between systems and data sources (Bloomberg, RIMES, Factset) Development: Review current SQL queries, views, functions and procedures. Writing new advanced SQL queries for Oracle & MS SQL Server. (PL/SQL Developer, MS SQL… Show more  Data Warehouse Design & Implementation: Senior Business Systems Analyst working on the design and Implementation of a new Investment Data Warehouse.  Data Analysis/Profiling: analysis of current investment systems (Eagle Investment Systems), and Integrations between systems and data sources (Bloomberg, RIMES, Factset) Development: Review current SQL queries, views, functions and procedures. Writing new advanced SQL queries for Oracle & MS SQL Server. (PL/SQL Developer, MS SQL Server Management Studio) Report Development: Design and development of high -volume investor reports (SQL,Seismic) Process Mapping: Documentation of current and future state investment processes for newly launched ETF products (MS VISO) Show less

Toronto, Canada Area

 Process Mapping & Optimization: Analysis and documentation of current investment processes including; Sales process, reporting, client onboarding/off boarding, investment funding & trade execution Report Design & Development: Requirements gathering, design and development of quarterly investment reports, including the automation of custom market commentary (VBA, SQL, Active Reports) System Integrations: Integration of Satuit CRM with Beutel’s Investment Data warehouse. Responsible… Show more  Process Mapping & Optimization: Analysis and documentation of current investment processes including; Sales process, reporting, client onboarding/off boarding, investment funding & trade execution Report Design & Development: Requirements gathering, design and development of quarterly investment reports, including the automation of custom market commentary (VBA, SQL, Active Reports) System Integrations: Integration of Satuit CRM with Beutel’s Investment Data warehouse. Responsible for database and data analysis, integration design, implementation and testing Show less

Toronto, Canada Area

Contracted with AGF for several projects related to investments systems and processes Investment Model Analysis & Redesign: Analysis and assessment of Excel based Investment models. Responsibilities include requirements gathering, analysis, solution design and development of operationalized models using VBA and SQL databases Analysis of Investment Systems: Documentation and analysis of proprietary investment systems for one of AGF’s subsidiary’s. Responsible for liaising with… Show more Contracted with AGF for several projects related to investments systems and processes Investment Model Analysis & Redesign: Analysis and assessment of Excel based Investment models. Responsibilities include requirements gathering, analysis, solution design and development of operationalized models using VBA and SQL databases Analysis of Investment Systems: Documentation and analysis of proprietary investment systems for one of AGF’s subsidiary’s. Responsible for liaising with Investment and IT professionals to document current systems and processes. Creation of detailed process maps for daily data processing, reporting and system integrations Data Management: Analysis of Market Data in Eagle Investments systems and associated data marts. Identification and clean up of bad data through SQL scripting to update millions of records System Integrations: Integration of Eagle Investment Systems with custodian data feeds. Responsible for testing integrations, test case creation, liaising with vendors and AGF Operations.  ETF Constituent Data: Project lead to source ETF constituent data. Responsible for the research & analysis of vendors and the implementation of the solution including requirements gathering, solution design, configuration and implementation Analysis of Investment Risk Systems: Responsible for requirements gathering and analysis, data mapping, report design / configuration for a proof of concept for BarraOne and Bloomberg Show less

Toronto, Canada Area

Contracted with the Law Society of Upper Canada as a Senior Business Analyst and Solutions Architect for three SharePoint 2013 Projects:  Design and implementation of a Case Management solution for the Law Society Tribunal Design and implementation of the Law Society Tribunal public facing website Design and implementation the corporate intranetProject Management: Oversight of three projects including management of schedules, resources, vendors, budgets, project… Show more Contracted with the Law Society of Upper Canada as a Senior Business Analyst and Solutions Architect for three SharePoint 2013 Projects:  Design and implementation of a Case Management solution for the Law Society Tribunal Design and implementation of the Law Society Tribunal public facing website Design and implementation the corporate intranetProject Management: Oversight of three projects including management of schedules, resources, vendors, budgets, project documentation and scopeBusiness Analysis: Facilitation of requirements gathering and process re-engineering for all projects by working directly with business subject matter experts. Determining as-is and to-be processes and workflowsSharePoint Architecture: Design the SharePoint solutions based on requirements for the Case Management and Law Society Tribunal Website. Oversight of the architectural solution designed by a third party vendor for the corporate intranetInformation Design: Design of company wide content types, taxonomies and process/department specific folksonomies Show less

Toronto, Canada Area

Contracted with AGF as a SharePoint Implementation specialist for a company wide document management implementationBusiness Analysis: Facilitation of requirements gathering for all departments. Determining as-is and to-be document management processes and workflowsSharePoint Architecture: SharePoint portal site structure as well as department site structuresInformation Design: Design of company wide content types, taxonomies and department folksonomiesSharePoint… Show more Contracted with AGF as a SharePoint Implementation specialist for a company wide document management implementationBusiness Analysis: Facilitation of requirements gathering for all departments. Determining as-is and to-be document management processes and workflowsSharePoint Architecture: SharePoint portal site structure as well as department site structuresInformation Design: Design of company wide content types, taxonomies and department folksonomiesSharePoint Development: Implementing architectural and information designs for department sitesDocument Migration: Develop migration strategy and implementation across all company departments Show less

Toronto, Canada Area

Contracted with CIBC to implement two main projects;  Implement a Nation wide Access database solution to automate Mortgages and Secured Debt applications Implement fee changes across multiple systems and documents Business Analysis: Facilitation of requirements gathering, gap analysis, as-is and to-be definitions, data mapping, process design and process mapping, project definition, scope & planQuality Assurance: Developed test plans, use cases, test strategy &… Show more Contracted with CIBC to implement two main projects;  Implement a Nation wide Access database solution to automate Mortgages and Secured Debt applications Implement fee changes across multiple systems and documents Business Analysis: Facilitation of requirements gathering, gap analysis, as-is and to-be definitions, data mapping, process design and process mapping, project definition, scope & planQuality Assurance: Developed test plans, use cases, test strategy & design. Coordinated test case execution and variance reporting Show less

Toronto, Canada Area

Contracted with a small start-up company that provides data warehouse and analysis services to Credit Unions across the Country Business Analysis: Facilitation of requirements gathering, gap analysis, as-is and to-be definitions, data mapping, process design and process mapping, project definition, scope, budget & plan Data Warehouse Design: Analyzed existing data warehouse design and processes. Made recommendations to improve and automate processes and optimize warehouse design… Show more Contracted with a small start-up company that provides data warehouse and analysis services to Credit Unions across the Country Business Analysis: Facilitation of requirements gathering, gap analysis, as-is and to-be definitions, data mapping, process design and process mapping, project definition, scope, budget & plan Data Warehouse Design: Analyzed existing data warehouse design and processes. Made recommendations to improve and automate processes and optimize warehouse design structure for efficient uploads and retrieval Data Warehouse Implementation: Implemented design and process recommendations. This involved writing complex SQL queries, designing & implementing ETL processes to automate data loads and retrieval using SQL Server Integration Services (SSIS) Data Modelling & Analysis: Create models using SQL Server and Quadstone modelling tools for the following: Identify Credit Union members with high potential for new or existing product upsell opportunities using data mining and statistical techniques. Demographic analysis using census data to analyze locations for new credit union branches. Product & demographic analysis for Credit Unions to compare their book of business to the aggregate data warehouse statistics Show less

Toronto

Contracted with a large law firm to design and implement a compensation model Business Analysis: Facilitation of requirements gathering, gap analysis, project definition, scope, budget & plan Solution Design: Re-design of existing model to meet new requirements: Automation to minimize manual processes to setup and calibrate the model; Enable scenario analysis and forecasting capabilities; Separate input, output and model calculations to improve ease of use; Create a model that was… Show more Contracted with a large law firm to design and implement a compensation model Business Analysis: Facilitation of requirements gathering, gap analysis, project definition, scope, budget & plan Solution Design: Re-design of existing model to meet new requirements: Automation to minimize manual processes to setup and calibrate the model; Enable scenario analysis and forecasting capabilities; Separate input, output and model calculations to improve ease of use; Create a model that was transparent for audit and analysis purposes. Financial Model Development: Implement the solution design using advanced Excel and VBA techniques Show less

Toronto, Canada Area

Project Manager: Enterprise Content Management(ECM) Strategy & Implementation Responsible for building and leading a team of technology professionals to implement an enterprise wide ECM project Information Audit: Assessment and analysis of content in applications (SharePoint, Alfresco, Confluence), file shares and email servers Information Architecture: Establishing folder structures and taxonomies Document Management: Recommending strategies and delivery of supporting… Show more Project Manager: Enterprise Content Management(ECM) Strategy & Implementation Responsible for building and leading a team of technology professionals to implement an enterprise wide ECM project Information Audit: Assessment and analysis of content in applications (SharePoint, Alfresco, Confluence), file shares and email servers Information Architecture: Establishing folder structures and taxonomies Document Management: Recommending strategies and delivery of supporting technology. ECM systems evaluation, selection and implementation Information Strategy and Governance: Establishing policies and best practices that are sustainable, supportable and agreeable to the Business users Communication: Communicating technical information to non-technical audiences. Presenting to the project Steering Committee Enterprise Search: Enable Enterprise Search technologies. Product evaluation, selection and implementation Workflow: Enable content driven workflows. Product evaluation, selection and implementation Project Budget and Resources: Determining project budget, resource needs and building the project teamInterim Manager: Corporate Systems People/Project Management: Responsible for the Corporate Systems team providing solution design and delivery, application support, enhancements and project management Application Management: Responsible for managing the following technologies: SharePoint 2007, Confluence, JIRA, ClearCase, ClearQuest and a proprietary Compliance Management System Leadership: Responsible for growing a team to support the Corporate Systems area, including resource planning, budgeting, screening and hiring a team of 8 professionals Show less

 Strategy: responsible for business intelligence vision and implementation. Balancing short-term tactical initiatives with long term strategic goals. Instrumental in new product development from concept to implementation Content Management. Responsible for implementing SharePoint intranet to manage the firms un-structured content covering the following areas: Communication portals, team sites, document management, workflow and information architecture  Leadership: responsible for… Show more  Strategy: responsible for business intelligence vision and implementation. Balancing short-term tactical initiatives with long term strategic goals. Instrumental in new product development from concept to implementation Content Management. Responsible for implementing SharePoint intranet to manage the firms un-structured content covering the following areas: Communication portals, team sites, document management, workflow and information architecture  Leadership: responsible for a team of application developers; leadership, management of projects and priorities, communication of company initiatives / direction and coaching and feedback Negotiation and Influence: liaison between business unit leaders to determine competing priorities and manage expectations. Present to the management committee on project progress, strategic decisions and budget Management: responsible for managing multiple projects including vendor management, risk management and process management and budget/forecast Growth: staying on the leading edge of development best practices and technologies through self study and applying the knowledge to hands on development projects Show less

 Statistical and quantitative analysis on hedge fund portfolios Analysis and research on synthetic portfolio tracking and optimization strategies Performance attribution, reporting and quality control Data management and process improvement initiatives including development of VBA, databases (SQL, MS Access) and SharePoint sites Optimize synthetic portfolio asset mixes for domestic and international portfolios Monitor developments in derivatives markets and recommend… Show more  Statistical and quantitative analysis on hedge fund portfolios Analysis and research on synthetic portfolio tracking and optimization strategies Performance attribution, reporting and quality control Data management and process improvement initiatives including development of VBA, databases (SQL, MS Access) and SharePoint sites Optimize synthetic portfolio asset mixes for domestic and international portfolios Monitor developments in derivatives markets and recommend viable investment alternatives Financial modeling and Monte Carlo simulations Show less

 Responsible for developing the 5-year Strategic Earnings plan for Manulife Investments and its subsidiaries (Income statements, Balance Sheets, Cash flow Statements) Development of complex financial models to project earnings and key business indicators for Manulife Investments products including GICs, Segregated Funds, Annuities, Mutual Funds and Manulife Bank products Provide analysis, commentary and reconciliation between actual /plan / forecast for senior… Show more  Responsible for developing the 5-year Strategic Earnings plan for Manulife Investments and its subsidiaries (Income statements, Balance Sheets, Cash flow Statements) Development of complex financial models to project earnings and key business indicators for Manulife Investments products including GICs, Segregated Funds, Annuities, Mutual Funds and Manulife Bank products Provide analysis, commentary and reconciliation between actual /plan / forecast for senior management Projected liability cash flows for asset-liability management processes (ALM modeling) Projected Segregated Fund Reserves, asset growth, and required capital as required for business planning according to OSFI regulations Attribution / Sensitivity /Scenario analysis on Segregated Funds Portfolio to help understand the portfolio dynamics and the impact on earnings under different market conditions Show less

Master'S Degree, Data Science, 4.0

Master's degree in Data Science, Machine Learning

Cfa, Chartered Financial Analyst

B.Sc., Science, Chemistry

Advanced Training Designation, .Net Developer