Cheryl Potter

PROFESSIONAL EXPERIENCE

Payments Canada

June 2017 – July 2017

Enterprise Data Modeller/Architect

Technology Used : DB2, SQL Server, Google G-Suite, Confluence, Jira

Working with the Enterprise Architecture group at Payments Canada, my prime responsibilities include establishing an Information Governance program to support the organization’s modernization mandate.

In order to stand up the Information Governance program, my responsibilities include composing and obtaining the approvals from senior management for the overarching policy document, setting up the organizational roles and responsibilities and supporting the development of the policies, practices and Data Trustee working groups.

Elections Canada

March 2016 – May 2017

Enterprise Data Modeller/Architect

Technology Used : EA Sparx, Office Suite tools, Oracle 11g, Embaradero ERStudio

To support Elections Canada in their modernization efforts, it was my responsibility to prepare a comprehensive data management assessment of the current applications and their respective data integrations. This work entailed; discovering and documenting current state data architecture, reviewing all data models, noting any security policies and other governance practices.

To prepare for moving forward, it is critical to identify the gaps and propose a roadmap of activities to allow for the migration from current state to target state data architecture. By identifying gaps and opportunities, allowed for making recommended changes and action plans to help manage enterprise data and strategic goals.

The Target state will include a comprehensive Data Management Strategy, Business Intelligence and Decision Support component and Security process points with the appropriate governance (policies, processes and technology) to support the architecture.

In conjunction, one other major aspect to the development of a successful, modern data architecture is to stand up a Data Management Services Working Group. This working group are made up of business stakeholders who will be required to provide the policies, standards, legislation and resulting processes to enable Elections Canada to have a foundational Information Management Governance profile. This IM Governance is crucial to the success of the target Data Architecture and its frameworks.

Canada Mortgage and Housing Corporation

June 2015 – February 2016

Enterprise Data Modeller/Architect

Technology Used : Erwin v9.5, Lotus Notes, InfoShare (OpenText), Office Suite tools, MsDynamics (CRM), Sparx EA

As a member of the Operational Excellence and I&T Governance team, I am responsible for the development, publication and evolution of the information-related elements of the CMHC’s Enterprise Architecture (EA) Blueprint and Roadmap. The EA team will be responsible for making a key contribution to the establishment and delivery of an effective EA program, and for participating in enterprise architecture activities, global or in other domains (applications, security and infrastructure) including enterprise business architecture. I am asked to provide expert technical advice to Information & Technology (I&T) staff and I&T stakeholders on the evolving state of the Corporation’s information architecture needs, and for the provision of related architectural frameworks, standards, policies, plans and models.

Build and maintain relationships with a wide variety of internal organizations (business owners, practices) to understand current and future information and data needs and strategy

Support the development of the CMHC Business Capability model to allow for application, data assets and infrastructure components to have a common business focus

Develop, maintain and support conceptual, logical and physical models for a variety of structured (data dictionary, data flow charts, etc.) and unstructured data types as the basis of an enterprise data strategy;

Take ownership of architectural artifacts such as data model (logical, conceptual and physical), data dictionary, and data flow chart etc.;

Define best practices for data design and modeling, and maintain associated documentation;

Develop data life cycle management framework (data aging, archiving, etc.);

Identify gaps and opportunities and recommend changes and action plans to help manage enterprise data and strategic goals;

Architect, design and lead implementation of high throughput, large volume and variable data ingestion supporting back-end services;

Serve as an expert in data migration, data ingestion, data quality and governance;

Provide technical expertise in the area of data architecture, data analytics, design and feasibility of Big Data, and EDW (Enterprise Data Warehouse) solutions to realize more value out of data assets;

Work with ITM management and architecture teams to set architectural vision and create implementation road maps;

Design and enhance enterprise data solutions with focus on data quality, performance and scalability;

Assess technologies, processes, procedures and develop associated roadmaps related to data architecture;

Develop a Master Data Management Framework and reference documents

Collaborate with the EA team members to develop a base EA Blueprint document which will provide the different EA domain architects sections where their artifacts can be summarized or drilled down into. This Blueprint is for the CMHC business and technical audiences to socialize EA standards and principles across the entire corporation

Initiated a review of the data modelling capabilities within Sparx Enterprise Architect, comparing features and gaps with Erwin. This analysis was to promote a single ‘architecture’ repository for all IT domains to begin working from a single, common repository.

RCMP

Enterprise Data Warehouse Modeller/Architect Oct 2013 – June 2015

Technology Used : Erwin v9.5, Mindjet MindManager 14, LiveLink doc mgtmt, Office Suite and Groupwise, InfoSphere suite, Data Architect, Data Stage, IBM MetaData workbench, FastTrack, and Business Glossary

Characterize and develop an enterprise data model

Evolve and maintain an enterprise warehousing strategy and detailed architecture support of Business Intelligence and Data Management Services, while working with Enterprise Architects and key stakeholders

Develop an organizational strategy and plan for the provisioning of three of the eight IM Services: Information Architecture, Data Management and Business Intelligence and Decision Support Services. This project is part of the IM Renewal program (GC IM Strategy) being management and adopted by the RMCP.

Acting in the capacity of an advisor and designer, providing guidance and definition for the target state governance structures, organization structure and related work descriptions for the three new IM Services across the whole of the RCMP

Deliver an overall strategy for the implementation of the Business Intelligence, Information Architecture and Data Architecture services within the RCMP which includes designing, developing an enterprise data warehouse framework and architecture, designing a metadata management implementation strategy, enterprise data integration patterns, reviewing and revising database and data modelling standards and best practices

Designed and delivering an Implementation Strategy Plan for BI Services which includes; Current State, Target State, Gap Analysis, Business Drivers and Requirements, Solution Design and Strategy (application/infrastructure), Governance structures and proposed Road Map

Responsible for designing new Enterprise Data Architecture Frameworks. The architecture takes into account the data requirements for existing legacy applications, the new enterprise data warehouse, the new Records and Document Management system and all the supporting infrastructure and related tools.

I have been directly responsible for designing and developing the Architecture and Data Models for corporate and project specific initiatives. This responsibility includes the identification of current data sources, the documentation and analysis of existing data models, design of the future state data architecture, and the development of the resulting data models.

Here, at the RCMP, and at Brookfield, I worked with the IM/IT staff and business users to explore and understand the business and technical requirements through JAD and facilitation sessions. Designed corporate data architecture patterns, strategies and supporting frameworks. I am very familiar with designing and implementing logical and physical data models.

A major part of my role was to transfer expertise and knowledge to current team members in the areas of:

Data modelling (enterprise information management EIM models, dimensional OLAP models and relational 3rd normal form OLTP models),

Data management practices,

Metadata management processes,

Data quality,

Data Integration techniques and patterns (ETL, EAI),

Data Security, Archival and retention techniques,

Cognos Framework Manager modelling methods,

Data governance practices such as defining a Master Data management process to support the Enterprise Data Warehouse project

October 2013 – (present)

Brookfield Renewal Power

April 2008 – October 2013

Enterprise Data Architect, Data Quality and Information Governance Architect

Technology Used : Oracle, SQL Server, AccessDB, Excel datasets, Embarcadero’s ER/Studio data modelling toolset, Cognos Framework Manager and Cognos reporting studios, SharePoint 2010, PowerPivot, Sql Server 2012, Analysis Server, ITIL Service Strategy

Collaborated with business clients (middle management and senior directors) to establish an Information and Process and Data Governance Program, the focus areas include the following stacks:

Information Architecture (enterprise data model development, data dictionary, metadata management, master data management, and data integration patterns),

Information Delivery (BI and Analytic reporting policies and capabilities),

Data Quality (establishing data quality determinants, related policies and practices),

Business Process (aligning strategic objectives of the company with associated business process and the informational requirements to support these processes)

Engage with project teams and business clients at the onset of releases and projects to create an ‘information blueprint’ which includes such aspects understanding and advising on any required interface points to related applications, collaborate with data and process owners to determine System of Entry and System of Record for the project’s informational needs; and determining data quality requirements for the project to ensure that data moving in or out is “fit for business process” purpose.

Developed the BI Architecture Framework document including all required architecture components and their related design standards and governance structures; Authoring/BI component, Data Warehouse logical data and technical platform architecture, ETL design guidelines and technical architecture.

Develop an Enterprise Information data Model (conceptual) and a supporting information strategy including the underlying data management practices to ensure consistent information standard. A framework to begin capturing an enterprise data dictionary (and business glossary) and a full some metadata repository.

Design an Information Delivery framework to support both operational (application-specific reporting requirements) and strategic reporting when it is necessary to integrate information from many operational systems, in order to have a more horizontal corporate view. In addition, defined conventions, best practices and design guidelines for business requirement methods and design rules for all dimensional models including meta data models to support new data marts

Designed the BI Semantic Model to prepare for the virtual enterprise information model, with the governance and data quality components required

As the organization moved towards using Sharepoint as the ‘enterprise portal’, a framework was developed to fold this component into the enterprise Information Architecture (associating the ‘content types’ for example, to the enterprise reference information model to ensure true ‘horizontal’ search capabilities eliminating the barrier of structured and unstructured information); establishing the necessary governance layers to ensure that all information captured, stored and management within Sharepoint repositories adhere to the key Information Management principles (ownership, accessibility and retention) and to create a ‘seamless’ interface between the enterprise data warehouse and the portal’s client facing authoring tools built into the Sharepoint portal.

Worked with Solution Architect to prepare a ‘business semantic layer’ to further enable the business community to ‘self serve’ their individual business information requirements. Working with Microsoft SSAS, their BISM, Reporting Services and PowerPivot technologies as a fundamental component of this architecture layer.

Using the BI Architecture, and the new Information and Process Working Group, two new two successful data marts were delivered to our Finance and Trading users (Budget data mart and the Trade data mart). Following the new framework (including business requirement methods, and new technology stack, the new data marts were developed using the SSAS technology as the data warehouse component, and Cognos v10.1 as the BI/Authoring component.

Using the ITIL Service Strategy, experienced the processes associated with application/product deployment and release management

Department of National Defense

May 2007 – April 2008

Data Warehouse Architect

DBA, Data modeler, Data Architect, Production Support

Technology Used : SQL Server 2000, SQL, Informatica, Microsoft Office tools (EXCEL, Word, PowerPoint, etc.), Cognos toolset, Erwin, VISIO, Visual Source Safe, RedGate Professional Toolbelt (SQL Doc, SQL Dependency, etc.),

Designed and developed a GIS spatial data model to solve current performance issues and to provide integration capabilities (logical and physical architecture)

Designed the logical and physical data models for a data warehouse to support the BI reporting requirements

Developed the BI Architecture Framework documentation including all required architecture components and their related design standards and governance structures; Authoring/BI component, Data Warehouse logical data and technical platform architecture, ETL design guidelines and technical architecture.

Developed conventions and guidelines to standardize gathering business requirements for data mart development

Defined conventions, best practices and design guidelines for all dimensional data models including meta data models to support new data marts

Developed SQL stored procedures and designed the ETL processes to manage the uploading of regional data into a national data

Revised current database models for IFSMR to enable data sharing with other source databases

Worked with business process owners to review and revise any business processes affected by the changes

Provided production support for the Common Master Database, GEONET, RAIS and the current data warehouse applications

Department of National Defense

November 2006 – May 2007 (5.5 months)

Enterprise Data Architect

Technology Used : Oracle, SQR, SQL, Informatica, WebFocus, Microsoft Office tools (EXCEL, Word, PowerPoint, etc.), Cognos tools, VISIO, Erwin, PeopleSoft HR 7.5 and 8.9

Developed the BI Architecture Framework document including all required architecture components and their related design standards and governance structures; Authoring/BI component, Data Warehouse logical data and technical platform architecture, ETL design guidelines and technical architecture.

Designed the staging data models (logical and physical) to support integrating the HRMS data into the DISB data warehouse

Worked with various stakeholders and multi-disciplinary teams to help refine business requirements template

Performed the data analysis of the PeopleSoft 7.5 and 8.9 HR data in order to design the new entities required to store the merging of the two data stores

Designed the ETL transformation logic for the Informatica developers to load the HR data from the two source systems into the data warehouse

Service Canada

September 2006 – November 2006 (3 months)

Data Warehouse Requirements Analyst

Technology Used: Oracle Designer, Oracle Warehouse Builder, PL/SQL, UNIX, Microsoft Office tools (EXCEL, Word, PowerPoint, etc.), Cognos tools

Held JAD sessions with the business users to determine their new reporting requirements for the CPP system using Cognos BI tools

Reviewed and documented existing BI reports to detail the current data required for the new data marts

Designed the new data marts (logical and physical architecture) required to support the current and new requirements from the user group

Developed the BI Architecture Framework document including all required architecture components and their related design standards and governance structures; Authoring/BI component, Data Warehouse logical data and technical platform architecture, ETL design guidelines and technical architecture.

Defined conventions, best practices and design guidelines for all dimensional models including meta data models to support new data marts

Designed the ETL processes required to migrate the source data into the new data marts

Provided existing team members with assistance in the methodology required to gather user requirements for data mart design

Canada Revenue Agency

March 2005 – September 2006 (1 year, 6 months)

Enterprise Senior Data Modeler

Technology Used : MS Office Professional Suite, Visio, ERWIN 4.14, DataStage v7.5, Cognos Impromptu v7.1, DB2 UDB client v8.1.5, SQL

Worked with source systems in order perform a detailed analysis to reverse engineer the existing data structures and transform the current state into conceptual and logical models that complied with the corporate standards for data quality.

Developed, maintained, reviewed and documented the corporate data models and used them to produce a synchronized physical database design that was then created to migrate legacy data into the Agency’s data warehouse in a normalized format that complied with CRA’s corporate architecture.

Provided the data mapping and designing the data mart models using the Star Schema design approach to accommodate the Cognos BI reporting requirements dictated by the business users.

Conducted JAD sessions with clients, Database Administrators, Database developers to ensure the accurate design of the models and the gather the business rules and reporting requirements.

Participated in a Data Mart design committee to develop standards and guidelines pertaining to the design and implementation of data marts for the business users. This document also included a Best Practices component and templates for gathering business requirements

PWGSC

April 2004 – February 2005 ( 11 months)

Senior Data Modeler

Technology Used : ORACLE 8I, POWERBUILDER 7.5, TOAD, MS Office Professional Suite, VISIO, ORACLE Designer, Unix

As Senior Data Modeler for a very large production application, Ms. Potter reviewed the many change requests associated to this application, organized the outstanding problems and created the functional specifications based on JAD sessions with the functional-area experts (clients, developers, database administrators, etc…) and determined the business requirements.

Performed data analysis, and by analyzing the legacy application from a business perspective and determining what the legacy system does, how it works, what it does well, what can be improved upon.

Created a system design document (data map) and reverse engineered the legacy application and its database, using ORACLE Designer, so that was possible to describe what the system was actually doing to the business stakeholders. This allowed the development group the specifics on how to design the new application in order to successfully replace the legacy system.

Designed several data marts to accommodate the Cognos BI reporting requirements dictated by the business users.

Reviewed the proposed solution with the functional-area expects, developed, maintained, and reviewed the corporate logical data model in third-normal form, using ORACLE Designer (approximately 150 entities), and ensured compliance with corporate standards, while maintaining data integrity.

Wrote the business requirements and obtained approval (sign-off).

City of Ottawa

May 2003 – June 2003 (2 months)

Senior Data Modeler / Systems Analyst

Technology Used : ORACLE 9i, ERWin 3.52, TOAD, NT 4.0, PL/SQL, SQL, MSAccess, MS Project, Crystal Reports

Responsible for interviewing and working with subject-area experts to capture business requirements for a new web-based Capital budget application.

Conducted many JAD sessions with the functional-area expects (clients, developers, DBAs) to capture the business requirements

Designed and developed, maintained, reviewed, and documented a corporate logical data model in third-normal form, using ERWIN 3.5.2, (approximately 78 entities)

Wrote a requirements document for the new system, combined the necessary or desirable requirements of the legacy systems, with the new system

Obtained sign-off from the clients/stakeholders of the requirements documents and the design documents.

Developed data migration plans for the financial data for this new application residing in SAP Financials. This document detailed the requirements to allow for regular scheduled loads from SAP into the Oracle Budget database.

Designed and developed the PL/SQL stored procedures to transform and load the financial data into the new database.

Provided the clients/stakeholders project status, including work or tasks accomplished during the preceding period, work scheduled for the upcoming period and any problems or concerns to be identified, to be addressed and possibly corrected.

Documented the post-implementation support requirements and the needed transition-related documentation to hand over to the Project Team upon completion.

PWGSC

May 2001 – April 2003 (2 years)

Enterprise Data Warehouse Lead

Technology Used: ORACLE 8.0, ORACLE 8.1.7, Designer 6I, HP Unix, NT 4.0, PL/SQL, Oracle Designer 6, CoolBiz, DMR-P, UNIX, TOAD, VISIO, MicroSoft Office tools, including MS Project

As the Enterprise Data Warehouse Lead on the Enterprise Information Model project, Ms. Potter provided project leadership of the team members, developed the project plan and schedule, oversaw the implementation of the project tasks, conducted regular project status meetings with clients, developers, and DBAs, and managed the project plan, scope, and RPS client/stakeholder expectations.

Performed a full reverse-engineer of the twelve legacy databases into Oracle Designer, and maintained the quality and integrity of the data.

Developed a new logical data model (over 400 entities) in third-normal form and then the entity-relationship diagram, using Oracle Designer, to capture the combined information requirements.

A more detailed normalization exercise was then done to eliminate/reduce redundant entities and to provide quality, homogenous data to the clients.

This new logical data model was normalized in third-normal form, or fourth-normal form as required. Meetings were then held with the client/stakeholders to review the new entities and to document all tables, attributes, and relationships, by developing business definitions.

With the new Real Property Services logical data model, the current existing business applications have the ability to evaluate the work effort to migrate their applications over to use the new integrated data model. This migration exercise would support the replacement of the legacy applications.

Designed and documented a data migration plan to support and enable the replacement of the legacy systems to migrate over to the new database structures when their applications were prepared to do so, while maintaining the quality of the data.

Conducted focus (JAD) sessions with the functional-area experts to capture the business requirements. This allowed for the development of the functional specifications. These sessions often involved clients with competing and conflicting agendas, but she was able to work with the groups to build consensus, allowing the project to move forward.

Ms. Potter brought a lot of technical expertise to the project, especially in the use of the CASE (Computer Aided Software Engineering) tool, which was central to the definition, collection and integration of the large amount of data involved.

PWGSC

August 2000 – April 2001 ( 9 months)

Project Leader (Web based application – LGIS)

Technology Used: ORACLE 8.0, TOAD, UNIX, VISIO, HP UniX, NT 4.0,SUN Solaris 2.7, Sun Java 1.1.8, WebSphere application server 3.02, Netscape Web server, PL/SQL, Oracle Designer 6, JBuilder 3.5, Visual SourceSafe and MapXtreme 2.0, DMR-P, MS Project

Conducted the JAD sessions with the business users to determine the requirements for the new web-based GIS application

Designed the logical and physical data model

Developed the PL/SQL stored procedures to manage both the retrieval of data for the JAVA engine and the storing of data being entered through the web-based presentation layer.

PWGSC

March 1997 – June 2000 (3 years, 5 months)

Project Leader (Client Server application – PBMS)

Technology Used: ORACLE 8.0, TOAD, UNIX, VISIO, HP UniX, NT 4.0, PL/SQL, Oracle Designer 6, Visual SourceSafe, DMR-P, MS Project, Powerbuilder

Established the several procedures for maintaining and supporting a production application; she provided the client with a 'single point of contact' for application faults and/or enhancements; evaluating and assessing the enhancement request; providing recommendations to management; creating the project plans for each new release of the application and planning the team’s priorities and time according the project plan; provide periodic status reports to her clients.

Developed the logical and physical data models to support the application and its ongoing change requests

Designed Oracle stored procedures to enhance application performance by isolating the application layer from the data layer

Provided the BI reporting group with data extracts to support their data mart development work

Conducted meetings with the stakeholders/clients and provided all the functional and technical analysis required for the developers to make the necessary changes.

Established the data migration rules and standards for interfacing to the COBOL Financial system this required a thorough analysis of the data and adherence to data quality.

Technical Summary

Database Management Systems

PL/SQL

SQL

T-SQL

Oracle 7.3, 8.0, 8i, 9.0

SQL Server 2000, 2008, 2012

MS-Access

LANGUAGES

English, Read / Written / Spoken

French – Read

SECURITY CLEARANCE

Active Security Holdings –

RCMP Security Clearance (HRMIS number 000240851)

PWGSC Level: Secret

File No.: 95040081 000*******

Expiry: October 27, 2024

PWGSC Level: Top Secret

File No.: 95040081 000*******

Expiry: December 15, 2019

CONTACT INFORMATION

Mobile Phone – 613-***-****

Home Address – 73C Foxfield Drive, Ottawa, Ontario K2J 1L7

Home Phone – 613-***-****

Email – ac10y8@r.postjobfree.com

Contact this candidate