Leading a team that designs, develops, and operates the company's scoring pipeline & associated data lake / data warehouse. We use an AWS serverless architecture for our pipeline - Lambda, Fargate, S3, Kinesis, SQS, SNS, RDS, DynamoDB. For the warehouse - S3, RDS, Athena and RedShift.The pipeline integrates with the various analytics workloads to serve our clients (multi-tenant)Our warehouse/datalake supports analytic model training and testing. We also provide an analytics presentation layer including dashboards & reporting.Our team works closely with governance team to ensure data management met all requirements for proper model governance. The team also collaborates with the CSO as part of our Information Security Management System (ISMS) - based on ISO 27001 and SOC2 certification.

Conducting BI architectural review and Providing recommendations for improvement

I have been working with the Business Intelligence group in their role of developing and maintaining the BI Solutions for the CWB group of companies. There have been many changes in line of business applications that required enhancing the architecture to maintain efficient, reliable, scalable, and secure BI solutions. My role at CWB has been to act as an architect and mentor to the staff and contractors that make up the BI team. The scope of work has included:• Standards and design of new reporting and data mart solutions• Data modeling of the Enterprise Data Warehouse (EDW) dimensional model• Data analysis and ETL design from new and changing operational systems• Design of meta data, audit and quality controls• Design of regulatory reporting solutions• Technical SupportThis project has been conducted on a part time basis. The work involved meeting with key stakeholders and BI team members to determine the requirements and propose solutions.Dealing with the changes in a dynamic organization – key operational systems changing or upgraded, technology transition, growing staff – have all required the team stay focus on deliverables and ensure that the base operations (including regulatory requirements) stay fully met.

Providing Senior BI Architecture and Consulting services to Silver Creek's clients. Services have been provided on a part time bases - meeting the needs of clients to support in-house team members with coaching and mentoring as required. This includes technical standards, data modelling and best practices for the Business Intelligence Environment.

Putting BI Consulting on hold as I move to an incredible opportunity in 2018

CYS InfoMartThe InfoMart is the comprehensive BI solution for the Child & Youth Services division of Human Services. It includes data from all operational and financial systems of interest and provides a BI reporting solution to hundreds of HS staff.• Role involves working closely with the department and regional authority business users to understand information requirements, design solutions and lead the development of various information products.• Responsible for data modelling, technical design and lead the development activities related to the BI environment and departments operational systems.• Extensive experience extracting and manipulating the data in the departments active, legacy and new operational systems• Training and support of business analysts to maximize benefits of the department’s information and tools• Initiatives for this project include:o Business Intelligence environment infrastructure upgrade including server virtualization and upgrades to InfoMart environment including Cognos, SQL Server and SharePoint tools and softwareo Quality Assurance reporting to assist standards and monitoring for business program areaso Data analysis for corporate implementation of Cúram business suite that is replacing key operational systems. New modules for Child Intervention and Provider Management in process of integration with current InfoMart reporting and QA processesOne of the driving principles of the InfoMart BI Team has been to remain responsive to the ongoing urgency of each business area. An Enterprise BI solution that is not responsive to business needs will fail. No matter how ideal the end objective is, if the key stakeholders and business areas are not being heard and supported, the BI project will not have the support required to attain the long term vision

• Role involves working closely with the department and regional authority business users to understand information requirements, design solutions and lead the development of various information products.• Responsible for data modeling, technical design and lead the development activities related to the BI environment.• Key initiatives include: o Design & implementation of new case and cost analysis tools for key programs; integrating direct and indirect costs to allow detailed client reporting o Develop new reporting of historic and longitudinal attributes for critical client group o Reengineering of information management solutions to support changes in technology and operational systems

Consultant through Silver Creek Solftware• Business Intelligence (BI) and Data Architect for two related projects - BI reporting and operational system• Current operational system project involves a complete replacement of multiple operational systems that managed permitting and inspecting for 100’s of municipalities and agencies.• Informational objective is to create an integrated reporting environment to meet operational reporting needs. A secondary objective is to merge data from multiple municipalities into a common data warehouse. This data warehouse will act as a Business Intelligence environment that allows data sharing amongst various organizations involved with the safety system in Alberta• Role involved data architecture consulting - modelling, technical advisor and database design for both solutions.

• Role involved support for DBA activities regarding performance and environment upgrades and migrations.• Primary activity involved the relocation of 4 DB2 environments to new server hardware providing improved performance, backup/recovery and operational management.• Project tasks performed included operational script development, environment testing, documentation and skills transfer.• The HCJDC is responsible for the statewide criminal history record information systems and maintains various 24X7 online applications.

• Business Intelligence (BI) Architect for a new reporting and data quality initiative for the Harbor division's primary operation system.• Business objective included improving the data quality of the division's financial information and allowing broader access to the information held within a packaged ERP application.• Role involved design and construction of a new reporting data mart and supporting reporting environment.Development involved custom procedures for dynamic ETL and quality assurance (QA) processing. This includes both business data and technical service operation monitoring.• Presentation interface was custom web based application using PHP that allowed data to be viewed online and downloaded to Excel.

• Business objective was to improve the existing financial reporting and extend it by adding the state's payroll transactions.• Role involved design and construction of the new payroll analysis data mart as well as enhancement and maintenance of existing financial data mart.• The ICSD Financial Data Mart is a large, statewide offering providing analysis and reporting services and is refreshed daily. The Data Mart is used by all state departments and has approximately 500 users.• Enhanced benefits to users through the addition of new data and reporting options. Improved the service levels for the operation of the BI environment though automated data quality review and monitoring.• Data Warehouse approximate size was 15GB and growing by 400MB per month.

Role was to support the EPS Business Intelligence Team to ensure the successful implementation of the EPS BI environment.Assistance was provided on a regular basis and involves working with EPS staff and the Business Intelligence Platform Team to provide direction and advice:Provide guidance to the EPS Business Analyst and Cognos Technical Analyst on the overall design of the EPS BI Environment;Assist in the development of standards and conventions that will be used, based on experience in previous projects;Perform quality review of the components being designed and developed in the BI Environment;Help resolve technical issues with the Cognos software;Assist with the design of the BI Security model;Develop an implementation plan and work with the EPS BI Team to define communication and training requirements;Transfer knowledge to the EPS resources for ongoing backup, support and performance tuning activities

BI Architect for the Information Management group within the Information Strategies BranchRole involves working closely with the department and regional authority business users to understand information requirements, design solutions and lead the development of various information products.Responsible for data modeling, technical design and lead the development activities related to the BI environment.Key initiatives include:Meeting management informational requirements driven by new legislation and operational systemsShifting reporting focus from inputs/outputs to outcomes and results. Examples include the development of National Outcomes Measures (NOMs) for the Federal/Provincial/ Territorial Directors of Child Welfare and the evaluation of new legislation.Developing new methods of understanding client base using longitudinal analysis and comparative outcome reportingDesign and implementation of Data Quality monitoring and reporting for both the BI and the operational environments.Providing a single source of information by integrating BI environment with organization's portalDesigning information, data and report architecture that meets the requirements of the departmentAnalysis of the current and anticipated requirements with respect to other initiatives such as Electronic Information and Records Management (EIRM)

Primary role involves the development of the SIE Repository data model and dimensional model to support construction of both the SIE Data Warehouse and CPS Data MartIntegrated AHRE Enterprise corporate data model with requirements for SIE Data Warehouse in developing a model to meet both CPS and SIE long-term objectivesDeveloped the ETL data source mapping from 4 operational systems into the SIE Repository, which were then integrated at the individual and services level to provide cross program reportingManaged the Data Dictionary components for the project and designed an integrated Meta Data solution using Power Designer dictionary with presentation via the webSupported the design and development of the system components as well as business data translation process to ensure solution met objectivesDesigned and supported the development of Cognos PowerPlay cubes and Cognos Impromptu reports used to access the CPS Data MartDeveloped DTS packages used to implement the ETL Processes Systems Architect 8.5Windows 2000 Professional

BI Architect / Team Lead on Information Management Data Mart initiativeScope of the project involved establishing a BI environment with the goal to bring into one place all of the elements that could be used to determine the effectiveness of the services provided, as well as the financial, HR, demographic aspects of the clients servedLeveraging existing reporting databases as staging areas, we developed an "InfoMart" using Decision Stream that utilized a wide variety of information from internal legacy systems and other external sources that had to be brought out of the traditional silos being used for reportingWorking closely with the department's business users to develop information product requirements, designed and developed multiple PowerPlay cubes that act as the foundation for information access. The information is also used to drive Metrics Manager scorecards including high level geographical representations for Senior Management.Introduced ReportNet as the common reporting tool for the Ministry, for both operational and BI/Information management reporting requirements.Provided training and mentoring to project team members on BI/DW practice as well as technical usage of Cognos toolset (Decision Stream, Impromptu, PowerPlay, Transformer & ReportNet)Integrated custom Meta Data support documentation into Upfront web environmentDeveloped business and technical documentation used during analysis, design and construction phases.First phase successfully implemented and received very high satisfaction from clients.Second phase expanded the BI environment providing additional reporting and cubes as well as integration into additional business processes. Cognos ReportNet 1.1Windows 2000 ServerSQL Server 2000 Edmonton Police Service - Plato Project Cognos Environment [SKYideas

Technical Architect / DBA for application performance enhancement projectNew version allowed for increased number of concurrent user support as well as drastic improvement in time to perform key activities within the application - approx 4 times improvement in many placesFocus on Off-line storage / Archiving and implementation of major performance improvements by redesigning key elements to take advantage of database featuresKey techniques used included SQL Profiler and Microsoft Application Center TestResponsibilities include analysis, prototype development and design of changed database components. Power Designer 9.0SQL Server 2000SQL DTSCognos Power Play 7.3Cognos Impromptu 7.3Windows 2000 Pro.Novell Netware 6.0Visual Source SafeGovernment of Alberta - Human Resources & Employment (HRE) - Strategic Information Environment (SIE) / Clients, Programs and Services

Consultant through Maxfield, RobertsData Architect and DBA for the development of initial phase of LMI Data Mart system which is part of the AHRE Strategic Information Environment (SIE) initiativePrimary role involves the construction of staging and data mart database objects, using DDL generation from Power Designer modelsResponsible for the loading of Statistics Canada data to allow analysis of external data to better understand demographic and economic trends SQL Server 7.0SQL DTSOracle 8i (8.1.6/8.1.7)VB 6.0Windows 2000 - Professional & ServerPPM 2000 Inc. - IRIMS SQL-Oracle Conversion Project, [SKYideas

• Provided technical assistance in the installation, configuration of Cognos ReportNet, allowing reports to be created by EPS staff• Guidance on use of conventions and standards for new Report development projects Systems Architect 8.5Windows 2000 ProfessionalSQL Server 7.0 / 2000Crystal Reports 9.0 Advanced - WebShare Point Portal Server NorQuest College - Data Mart Project [SKYideas

Project Lead and BI Architect for the NorQuest Data Mart project.Data Mart to provide an integrated reporting database for the college's informational needs. Key subject areas include Student, Finance, HR and OutcomesPrimary information presentation used Crystal Reports over an intranet portal. Secondary reporting uses SPSS statistical reporting.Meta Data and user interface uses Share Point Portal Server Power Designer 9.5SQL Server 2000SQL DTSCognos Power Play 7.3Cognos Impromptu 7.3Windows 2000 Pro.Visual Source SafeGovernment of Alberta - Human Resources & Employment (HRE) - Strategic Information Environment (SIE) / Clients, Programs and Services

Designing a new reporting environment for College Management SystemTraining technical staff on development & operationsTraining business staff on maximizing information through report development

Provide business process and data modeling analysis support to Computer Services with the goal to develop a college-wide Information Model.Applying the Popkin process (based on the Zachman Framework) to assist with communicating information strategyProject focus was to identify and integrate the data needs of the college and to streamline information operations Power Designer 7.5SQL Server 2000SQL DTSWindows 98 / 2000Novell Netware 6.0

System & Data Architect for the SIE Data Warehouse & CPS Data Mart Project - Phase 2This phase enhances the SIE Data Warehouse and CPS Data Mart through 3 subprojects:Addition of financial data (tripling the size of the warehouse to over 30GB/200GB+)Design and development of new data mart star to provide participant tracking analysisPreparation for the addition of a new operational source system undergoing developmentRole involves leading the design for Phase 2 enhancements with the use of JAD Workshops and requirements definitions sessions.Part of SIE Architecture committee working to ensure that all BI related projects at AHRE are coordinatedTeam lead in the development and testing of the Financials component (UAT March 2003) New development done in coordination with regular operation of the production environment, which has been running since Aug., 2002 SQL Server 2000 Enterprise EditionWindows 2000 - Professional & Advanced ServerIISVisual Studio (VB) 6.0Visual InterDev (ASP)COM+ (MTS)Visual Source Safe; Government of Alberta - Action Request Tracking System (ARTS) Project

Ensuring LGS staff were supported in the Microsoft certification effortsCreating opportunities for staff to work with new technologies to develop the skills required

Pipeline Hydraulics Modernization Project (PHAST)

Consultant through LGS GroupData Architect for the implementation of Customized Hydraulic Simulator package. This involved the design of custom interfaces, detailed business reporting and data migration into the new Hydraulic Simulator application.Development of Oracle / Unix interfaces allowing sharing of key operational data between Simulator and other Enbridge applications.Design of Data Migration subsystem allowing business data to be automatically moved from legacy RDB/VMS application to new Unix application.Data Modeling for integration and reporting database. This involved analysis of related systems and development of new data models.Technical liaison between Enbridge business teams and Application vendor (Houston TX). Ensured that business requirements were properly manifested in final application.Acceptance test coordination and business training of completed application.Project DBA creating and maintaining project database environment.Tools and technologies used for this project were: Oracle 7.3, PL/SQL Packages, Oracle Designer, Oracle Developer, Perl, Unix (Solaris, HP/UX), Unix Korn Shell, Fortran, eXceed, C/Pro*C.

Data Warehouse Architect on a Data Mart to integrate multi-jurisdictional Apprenticeship and Certification program data - 13 provinces and territories plus federal government.Involved in all phases of project including user workshops, requirements analysis, dimensional data modeling, system design, and construction.Conducted data analysis of data sources and modeling of staging & dimensional data stores done using ER/win. ER/win allowed logical and dimensional/physical models to be captured as well as transformation rules to be documented in a central repository.Meta Data made available on the Upfront web site as web pages generated dynamically from SQL ServerDesign and development of DTS packages and TSQL stored procedures for ETL process.Implemented Cognos Enterprise Server for deploying Business Intelligence over the web to a national user base. This involved integrated Access Manager with Microsoft's Active Directory for security authentication and deploying UpFront to allow users to save reports to common web site.Tools and technologies used for this project are: SQL Server 2000, Data Transformation Service (DTS), ER/win 3.52, Cognos Enterprise Server 6.61 (Power Play Web), Cognos PowerPlay 6.61, Cognos Impromptu, Windows 2000 Professional and Server, Ralph Kimball's Data Warehouse Methodology Oracle 8i (8.1.6)Oracle Designer 6Oracle Discoverer 3iWindows NTin-DW Data Warehouse Methodology; Government of Alberta - Alberta Environment, Environment Management System (EMS) Project, Operations Tracking Data Mart (OTDM)

As Data Mart Architect, developed an enterprise "Data Mart Strategy" to guide the development of new data warehousing projects at Alberta Environment.Provide Data Warehouse data modeling and design for the development of a new performance monitoring data mart.Designed ETL components using PL/SQL packages and materialized views.Conducted user workshops to improve the Meta Data management process and the business and technical issues surrounding that. Crystal Reports 8Crystal Web ServerSQL Server 7 & DTSWindows 2000 - Professional & Advanced ServerIISVisual Studio (VB) 6.0Visual InterDev (ASP)COM+ (MTS)Visual Source Safe; Government of Alberta - Action Request Tracking System (ARTS) Project

Technical Architect for a new Reporting Data Mart subsystem enhancement to the ARTS Application.Responsible for the Data Analysis, Architecture Design, Data Modeling and Development of a separate database and reporting module.Tools and technologies used for this project are: Crystal Reports 8, Crystal Web Server, DTS (SQL 7.0) as well as Windows 2000 Advanced Server, Internet Information Server (IIS), SQL Server 7.0, Visual Basic 6.0, Visual InterDev (ASP), COM+ (MTS) all to support multiple browser and operating system clients. SQL Server 7 & DTSWindows 2000 - Professional & Advanced ServerIISVisual Studio (VB) 6.0Visual InterDev (ASP)COM+ (MTS)Visual Source Safe; Government of Alberta - Action Request Tracking System (ARTS) Project

Application Performance Project; Provided technical design input for a custom Web (Microsoft DNA) Application that is in use by multiple government ministries.Performed tuning and performance testing, utilizing the Microsoft Web Application Stress Tool.Tools and technologies used for this project were: Windows 2000 Advanced Server, Internet Information Server (IIS), SQL Server 7.0, Visual Basic 6.0, Visual InterDev, COM+ (MTS; all to support multiple browser and operating system clients.

Local Microsoft Alliance Practice Leader.Responsible for coordinating our training, development and marketing initiatives for the local Edmonton office with respect to our National relationship with Microsoft.Developed specialized training and support for the Microsoft Certification candidates.Local results included four new MCP and four new Premier certified consultants. Oracle 7.3.4PL/SQL PackagesOracle DesignerOracle DeveloperPerlUnix (Solaris, HP/UX)Unix Korn ShellWindows NTFortranHummingbird eXceedC / Pro*C; Pipeline Hydraulics Modernization Project (PHAST)

Analysis, Design, Data Modeling, and Development of LMI Data Warehousing project for use by two governmental departments to share labour market environment ("eScan") data, integrated with operation input/output measures.Completion of Data Warehouse Readiness Assessment that set the framework for project development.Design, Development and Implementation of initial phase using Iterative Delivery methodology based on Ralph Kimball's framework.Data Analysis and database modeling utilized Oracle Designer. Repository also used to manage business Meta Data.Developed and implemented PowerPlay cubes and Impromptu reports and deployed over the web. This involved implementation and deployment of Power Play and Impromptu Web Server products and integration with security models.Entire user application delivered using web technology over linked intranets, allowing users from across the province access. Interface and presentation of documentation, user comments and links to information products managed through custom "portal" developed using Front Page.Project DBA creating and maintaining project development environment.Tools and technologies used for this project were: Oracle 7.3, Oracle Designer/2000, Unix (HP/UX), Windows NT, Unix Bourne shell, Microsoft Access, Microsoft FrontPage, Cognos Impromptu, Cognos Impromptu Web Server, Cognos PowerPlay, Cognos PowerPlay Web Server.

Consultant through LGS GroupBusiness Analysis and Technical Design of Upgrade and Replacement of Hydraulic Simulation software and supporting databases.Analysis of requirements leading to shortlist of potential vendors followed by detailed design sessions with selected vendor.Data Analysis of existing applications provided a basis for developing customization plan and reporting requirements.Technical design and data modeling for development of supporting custom interfaces and business reporting environment.Tools and technologies used for this project were: Oracle 7.3, Oracle Designer, Power Designer, Unix (Solaris, HP/UX), Unix Korn Shell, Fortran, Hummingbird eXceed.

Consultant through LGS GroupTechnical Design Architect and Team lead for Application Development and Implementation.Provided Business Analysis and Data Modeling for new Energy Management application.Project DBA working with Corporate Data Architect and System DBA.Developed and successfully implemented a custom application that allows information related to energy contracts, pricing, and billing to be gathered and reported on.This was one of the first Oracle Client/Server applications developed at Enbridge, and also included the use of code-generation from Designer to Developer.Reference information from related operational system was summarized and integrated to enable ongoing comparative reporting. Relevant data model components from legacy models (Power Designer, paper, database DDL) moved to new corporate standard Oracle DesignerAdditional analysis and reporting front end established using Excel and ODBC to the Oracle database.Vendor supplied application was evaluated and integrated into custom solution through development of data interfaces.Tools and technologies used for this project were: Oracle 7.3, Oracle Designer/2000, Oracle Developer/2000, Power Designer, Windows NT.

Application Integration ProjectsBusiness Intelligence / Data Warehouse ProjectsApplication Developmerporations with $1B+/year revenue.Technical and application design for the development and delivery of key modules within an integrcused on the sharing of both reference and transactional data across multiple applications to provide an Enterprise suite of functionality using "best-of-breed" components.Enterprise data modeling that included custom business applications, package application enhancements (bolt-on applications) and key functional and data elements from packaged applications.Led business support team working with marketing, production and operations to determine business requirements for a variety of projects and corporate initiatives. Team included both employee and contract resources to provide analysis, development and support activities.Data Warehouse development including logical and physical data models using Oracle to make information within vendor supplied and custom applications available to business users. Project interfaces pilots of Lighthouse EIS and MapInfo GIS.Data Architecture included complete modeling of custom developed systems as well as purchased applications. Application integration of many data elements, both static and transactional was developed to improve the operation of all corporate systems. This involved applications such as Oracle Financials, Interactive's JIT, Lab Information systems and may custom applications (purchasing, sales, etc.)Conducted business financial audit for management review of complex pricing and invoicing agreements.Detailed system design for new custom modules using Oracle Forms and Reports, integrated with vendor supplied order/invoicing system.Integration of current and legacy data using Designer/2000 CASE tool for modeling for EIS application.Development of client/server application environment encompassing both custom-developed and package applications.

• Delivery of new Data Mart Information Solutions for Agricultural Chemicals division including design and development of data models, data load modules and reports.• Development of an End User Business Information Environment / Decision Support System, using Oracle on Sun and ODBC/MS Access.• Designed and implemented a new custom module to a vendor supplied plant maintenance system (Synergen MMIS).• Designed and developed an EDI module using Oracle, Forms, and SQR following the X12 standard for 850, 856 and 404 transactions.• Tools and technologies used for this project were: Oracle 6/7, Oracle Forms 3.0, Oracle Case 5.1, SQR, VMS, Unix (SunOS), Microsoft Access, Microsoft Visual Basic, Unix C & Bourne shell scripts.

Application Development using Texas Instrument's Information Engineering Facility (IEF) CASE tool for both data and application modeling as well as code generation and construction.James Martin's Information Engineering Methodology was the basis for all Data and Process modeling used at Imperial Oil.Business Area Support including DB2 based business application systems. These applications included RWIN - the company's first data mart analysis and reporting applicationsDevelopment and technical design of DB2 based Product Costing and Pricing Invoicing applications using IEF.Application support for the national retail Esso division, which involved operation and enhancements for key business systems and high involvement with business partners.Acted as security Coordinator developing application privileges and administering security services for 1000+ users on MVS/DB2 and supported business applications (File and Database permissions)Tools and technologies used for this project were: DB/2, TSO/ISPF, CICS, MVS, QMF, Information Engineering Facility (IEF), PL/I, Cobol, SAS, MarkIV