Mark O’Connor, B.Com, CPA, CMA, ITIL, LEAN-Six-SIGMA

Email adzob9@r.postjobfree.com cell 613-***-****

Mark is a Senior Business Consultant who has successfully delivered projects involving:

Business Process Design

Business Architecture

Data Architecture and Governance

Financial Management

Change Management

Data Intelligence and Data Analytics

Mark has 30+ years experience, applying and communicating to all organization levels, Data Architecture, Business Information and BI strategies and approach, innovative business capability design changes, financial control and governance.

Experience

A.Office of the Auditor General of Canada (OAG), he led a team of IT auditors documenting, reviewing and testing government IT business systems, security and controls. Mark was the architect of a government-wide financial audit sampling and data analysis system and methodology.

B.In his private professional practice as Transformational Business Architect, he reviews and documented his client project’s “AS is” states and planned and collaborated in the designed of the “To-be” transformation of controls, data architecture and processes.

Examples of systems and projects undertaken:

Financial Management and Control – 5 SAP implemented entities.

Security and Privacy - 5 enterprises

Governance strategies and processes - 4 organizations

Business plans and strategies for Climate protection research organizations

Human Resources Management – PeopleSoft - 5 organizations

Banking and Financial Institutions - Bank of Canada Alterna Bank

Design of business processes for Medical Drug and Medical Device products (see project #14 Health Canada)

Procurement of Goods and Services –

oDepartment of Transport,

oOffice of the Superintendent of Financial Institutions and

oInfrastructure Canada

He documented business requirements, designed solutions, assessed controls, mapped proposed transformational processes maps and data, and devised integration approaches for clients.

Career Work History

A.June 1977 – May 1993: Office of the Auditor General - Audit Principal, Executive Management – at the EX2 level

B.August1993 – Current: Managing Director and Associate to Public and Private Sector Clients

Education and Certifications

B. Comm, Laurentian University, Sudbury ON, majors in Accounting and MIS -Management Information Systems.

CPA,CMA Chartered Professional Accountant

ITil, Foundation V3- IT Infrastructure Library - IT service management

Lean Six Sigma Yellow Belt – based on methodology for continuous Improvement initiatives using Lean Six Sigma

Secret Security Clearance - Government of Canada

Selected project summaries and details are as follows.

Extract of Recent Relevant Project Experience

Project 1 Client: Department of National Defence (DND) Canada

Digital Transformation Office

Enterprise Data Architect

Duration: March 2023 – August 2023

Developed an Enterprise Data Model (EDM) for the SAP Hana S/4 Greenfield ERP for the Largest Department of the Government of Canada. The models created included Level 2 of EDM for the current SAP ECC version as well as the new SAP Hana S/4 Greenfield to be Implemented. Worked with other architects and the Business to develop the Business Capability models for several new initiatives and for the present systems. Developed conceptual data models, a source and use model and for the new Defence X ERP based on SAP Hana S/4. Mark did surveys and analysis of the several satellite systems, the 2 separate HRIS systems and “Black books” of DND. He Mark created and wrote a data strategy for the multi-year project. He also worked with the security, cloud and federated Data Catalog teams to assess and advice on security approach, of using the cloud, data profiling and source data feasibilities.

Mark personally has a Secret Level 2 security clearance . He has past experience of the methods and challenges of SAP and integrating and customizing 2 different ERPs; SAP ECC and Peoplesoft HR. The new SAP Hana S/4 has introduced an exciting new process wrinkle and opportunities with SAP Fiori. Mark integrated Fiori based processes models into the Conceptual Data Modeling.

Project 2 Client: Office of the Superintendent of Financial Institutions.

Procurement and contracting process modeling

Duration: November 2022 - March 2023

Through workflow reviews, interviews and Government of Canada Supply manuals Mark created Business Process Management Notation process models. The visualized process models and the executive summaries included both agency led and complex centralized government mandated contracting and procurement procedures. The As-is documentation included associated authorization, governance and data stores. These process flows and the data are intended for guidance, training, and reference for staff, executive briefing and in preparation for new business transformation architecture design.

Project 3 Client: ThinkTWENTY20, Financial Professional’s Magazine

Roles: Guest Author, Researcher, Data Analytics and Data Scientist

Duration: May 2021- present

A.For the winter 2021 issue of ThinkTWENTY20, a Magazine for Financial Professionals, Mark researched and wrote a white paper of technical and analytics design section called “Mining Data Assets”. The subject in summary includes “Data scientists and other data whisperers can be used to train data for use by the Chief Data Office, to make better governance business decisions and discover of strategic data.

B.For the Fall 2022 ThinkTWENTY20 issue Mark developed and published a Data Governance article titled “Cleaning and Maintaining Data Assets for Sustainability and Resiliency” Page 29

C.For Spring 2023 issue Mark has developed an article on the use and control of emerging Artificial Intelligence tools in ChatGPT for Financial management.

Project 4 Client: Canada Border Services Agency, Data Catalogue

Roles: Data Analytics and Data Business Intelligence Project Manager

Duration: August 2021 – October 2021 - 3 months

Mark surveyed the existing data catalogue environment inside CBSA and developed a plan of action with a Project Charter and next steps to create an agency-wide data catalogue of data assets for the new Chief Data Officer. Formal Briefings made to Director for gathering requirements and discussing approach, plans and delivery. Mark reviewed and incorporated Gartner BI and passive meta data management discovery concepts and capabilities for planning of agency democratized data catalogues and the SAP business warehouse. He explored tools and capabilities to use like IBM InfoSphere in collecting, cataloging, analyzing, the transformation, and consolidation of the agency Data Architectures, DataOps and Analytics. He reviewed enterprise data model (conceptual and logical) and data lineage of certain representative data to identify adherence to design patterns, reference model standards, and data governance and to do a quick analysis of maturity and prevalence of technical debt.

Project 5 Client: Government of Canada PSPC -MyGCHR

Role: Business Consultant

Duration: June 2022 – September 2022 –3 months

Project Description & Duties

To document and model the governance of the Managed PeopleSoft HR Service owned by the Chief HR Office (OCHRO), operated by Public Service and Procurement Canada and involving clients of all the departments and agencies of Canada.

Project 6

Client: Shared Services Canada – Service Catalogue Processes and ITil Configuration management

Role: Business Consultant

Duration: September 2019 – July 2021

Project Description & Duties:

A. He conducted and presented at various service targeted workshops attended by the service directors and managers to gather requirements. He documented existing processes for the first selected services, Wi-Fi, Video Conferencing, Cabling, Fiber data transport and Unix/ Linux Data Centres. The SSC data Centres function as a Government of Canada private Cloud. Mark Conducting current service assessment studies and service design of selected SSC offered services. He prepared and presented ITiL based maturity analysis and value stream analysis for the mid-range data center Linux service business line. He made recommendations for transition to the new ITil BMC Remedy tool and to changes to business configuration processes, the SAP FI/FM and ECC integration for revenue posting. costing and billing, prospects of using SAP in future Hana iterations, business architectures, and corporate communications.

B. The conceptual design of management processes for the build of UNIX servers in the mid-range data center for service delivery to CRA and CBSA clients. Developed conceptual, process, value streams, ITIL maturity and data models for use in the design of DevOps tools to providing Continuous Integration and Continuous Delivery (CI/CD) to the multitude of servers the construction, and configuration of server banks as well as to position for future maturity levels involving Machine Learning and DevOps. Mark’s proposed Architecture involved using, demonstration, and the application of Microsoft’s Power BI tools sets.

Transformation of Process to the Cloud

Project 7

Client: Office of the Chief HR Officer (OCHRO)

Role: Business Consultant

Duration: October 2019 – March 2020

5 months

Project Description & Duties:

Reported to two OCHRO executives - Assistant Deputy Ministers – Planned communications, prepared presentations and prepared the executives for their planned delivery to a group of senior Government of Canada Deputy Ministers. The technical presentation involved some business architecture, governance, risk management and a new cloud-based control framework for the Government of Canada Enterprise. Mr. O’Connor helped design and summarized the concept of a controls-based solution approach to whole of the Government of Canada. For part of the technical approach he researched, designed, and presented an Artificial Intelligence -based automated solution options attached to existing system technologies.

Project 8

Client: Passport Canada- Employment and Social Development Canada under Service Canada

Roles: Business Consultant/ Business Transformation Architect

January 2018 - September 2018 (5 months)

Project Description & Duties:

Mark designed, modeled, and helped create a strategic Service Delivery Model modernization, and change management plan for the Passport program and stakeholders including the system owners (IRRC) and operators ESDC Service Canada.

To support the service delivery model Mark developed a series of process model maps. These have been published by printing on large tablets and attached to ESDC Passport HQ Offices and with IRRC development team offices. The Mapping illustrated the various roles and activities performed and provided a mechanism for simulation of processes. The To/Be service delivery models provided illustrations and description:

Used Business Process Management Notation (BPMN) Modelling tools (iGrafx and cloud based Bizagi) for workflows and process simulations. These models were used within the Scrum/ Agile approach used in the development of Passport.

Created process simulation models for efficiency and effectiveness comparisons to the existing As/Is processes time and motion studies

Used the BPM models to prepare and train change management ambassadors for communicating to staff in the organization.

Models served as references points for documentation of agent procedures and training manuals.

Mark developed a potential strategy and approach to use Artificial Intelligence with Machine Learning and Robotics to cleanse and clarify scanned handwritten Passport application forms on a near real-time basis. A significant proportion of Passport applications are hand printed in full or in part.

Mark discovered and negotiated with another government service department to build on and extend trial service that provided common central remote data recognition service for machine character and word /name recognition. The strategy proposed to the DG involved emerging GC on- premises cloud services with private and secure architectural environment have AI learning processes.

Mark established initial Service Canada-based mini-test lab that would be used to simulate, test and compare the productivity impacts and results of different variants in applicant data acquisition processes.

Project 9

Client: Information Services Transformation and Renewal Planning – Ottawa Police Services / General Dynamics for the IT Consortium

Role: Business Consultant

Duration: April 2017 to June 2017. (3 months)

Project Description & Duties: Mark created Human Resources Business Requirements, planned strategic approach and Target IT Capabilities for key initial components of a 5-year overall Ottawa Police IT Transformational plan. Based on knowledge of HR systems including PeopleSoft HCM and other HR capabilities, he built business requirements for HR and identified SaaS opportunities for adoption and implementation. Target required capabilities and functionality identified included foundational support for future generations of a real-time dispatch and mobile-based systems.

For the Ottawa Police Services, Mark did and analysis and assessment of the HR systems and workflows for Officer duty scheduling. Recommendations included next steps for transforming and procuring new systems data, analyzing the possibility of implementing and integrating SAP HR in the city of Ottawa with the Ottawa Police Service, large-scale data management programs and integrating new and existing processes in a major technology strategy and plan for the revitalizing of the organization.

Project 10

Consulting Advisor to Various Government of Canada Departments

Client departments:

Indigenous and Northern Affairs Canada

Shared Services Canada,

Innovation, and Science and Economic Development.

Open data strategic advice

Roles: Business Consultant providing analysis, modeling and advice :

oOpen Data,

oProcesses,

oEnterprise Architecture,

oProcess Re-engineering, and

oInformation Management.

Duration: January 2015 to April 2017

Project Description & Duties

Mark provided advice, models, and presentations regarding the following:

Enterprise Data Model Level 1 and 2

Sparx Enterprise modelling,

Open data capability,

Organization objectives and open data inventories

The digitization and new systems change-management – resource capacity, new workforce makeup, required management organization, the required health and capability of the organization to support change and systems need.

Stakeholder’s needs and business objectives with respect of data collected

Data definitions, data models and Business Intelligence (BI) Architectures and Strategies Analysis and acceptability of stereotype generalizations

oRecommendations not to release as open the data that Indigenous leaders objected to for their inaccurate stereotype depiction.

process model (i.e. BPMN) involving the gathering of the contents, data volumes, data governance, stewardship and selection. Steps needed to close gaps on information access and Open-data/big-data governance process frameworks,

Departmental and government-wide data analytics,

IBM Infosphere (Information Governance Catalog, Data Architect), Mark tested early introduction releases of IBM’s InfoSphere with the open data collections for the INAC data catalogue

Cognos Analytics, ERWin data models

Information Architecture, Value Streams and related processes

For INAC he continued to implement plans, to help establish the business requirements, practice and automation to manage, validate and approve open data for publishing, briefing and engagement with the public.

Project 11

Client: Employment and Social Development Canada (ESDC)

Enabling Services Renewable Program (ESRP)

SAP, PeopleSoft

Roles: Business Consultant/ Enterprise Information Architect and Process/Transformation Architect

Duration: January 2014 to March 2016 (equivalent to 22 months full-time)

Project Description & Duties:

Mr. O’Connor expanded his knowledge an experience in Enterprise Architecture including Business Architecture, Data Governance, Process Governance, Information modeling and the use of Business Architecture modeling tools including:

IBM Rational Systems Architect,

IGrafx; BPMN, Value streams and Value Chains

Conceptual data models

Business process and information integration models including the Departmental Service Bus

Value networks, capability, process modeling, conceptual and Logical Data models, IBM Rational Requirements Composer)

TOGAF and Zackman Frameworks

Interpretation of “Leading Practice” As-IS model frameworks

Mark O'Connor performed analysis, modeling and design of;

The implementation, integration and interoperability of HR and salary forecast information in SAP – ECC PS and PeopleSoft HR ERPs COTS including SAP (EAM, ECC, AA and BW, AA, and PS) and PeopleSoft HCM.

Onboarding for Active Directory, access management, network security and asset management

In the capacity as an Information Architect and Business Consultant, Mark was responsible for Data Architecture, Data Governance and the related process transformations in the Enabling Services Renewal Program and Service Delivery Integration. Mark was the Information Architecture SME of the team. He performed fit/gap analysis between the legacy (current) and target state business architecture, and he prepared a conceptual design options.

He helped to test and implement IBMs SaaS Enterprise System Architect for use in SAP and PeopleSoft ESDC business lines for Data and process models. Mark performed options analyses, evaluation of application architectures, security, and privacy and information architecture. As part of the Enterprise Architecture analyses Mark developed Architecture Models of strategies process, technologies capabilities and associated meta-data. Modeling tools and products used in discovery of business and technology relationships processes, risks, technical aspects of integration and business requirements gathering have including IBM Rational System Architect, Rational Requirements Composer as well as BPMN as tools such as iGrafx for processes and value chains. Mark designed prototyped and produced analytical reports on processes and business relationships from the data in the various repositories of the IBM Rational suite.

Mark worked with a team of EAs to adapt industry practice (like TOGAF and SAP BPM) in developing a target meta model and defining the ESDC Business Architecture team’s view of structures, definitions and business and technical asset relationships.

Then working with this structure and the business as well as the SAP and PeopleSoft ERPs he produced diagrams models and analysis of the data, services, business processes, functions and reporting for management decision-making and governance.

Created and recommended an architecture for integration of data between SAP and PeopleSoft that included data content objectives, documenting data types, the capacity to handle data volumes at real time, assessing and managing timing of none-real time data updates.

Project – Selected other projects

Client: Various as noted

Procurement process documentation and governance design for a secret cleared Government of Canada Agency.

For a Aviation business research to design new aircraft propulsion systems.

Development of the Business Architecture processes and information flows for the Health Canada Health Products portfolio including medical drugs reviews and approval, Import of drugs to Canada, Health product licencing and approval to use,

Development, project management and requirements gathering for bank accounts with private individuals and with Financial Institutions at the Bank of Canada, credit risk management and collateral systems (Bank of Canada, CS Coop, Alterna Bank)

Development of early-stage Sarbanes-Oxley Controls analysis for a Alterna a commercial Bank

Installation of a Financial Management component of an ERP at a cooperative banking and savings organization Alterna Bank and CS-Coop.

Development of automated tools for modeling processes and workflows (Jetform’s iChart)

Review and testing of system sustainability and service documentation factors in the re-issue of the 10-year Infrastructure Canada outsourcing contract.

Development of an Architecture for a Chinese-based exporting and logistics firm (King Soft).

Creation of a start-up service architecture to provide information delivery to an aircraft while in-flight. Like the services now provided by Forflight and Siruis-XM

Data analysis modeling and sampling of the Government of Canada’s General Ledger.

Review of audit approaches, financial controls and use of technology in several crown corporations including VIA Rail, Export Development Corporation and Canadian Deposit Insurance Corporation.

Training of professionals in using data analysis, sampling in evaluating the performance of organizations and modeling processes (Office of the Auditor General of Canada, Stats Canada, United Nations Board of Auditors, the International Organization of Supreme Audit Institutions (INTOSAI)

Management of the DevOps (CS Software development staff and projects) for the Office of The Auditor General

Contact this candidate