Mr. John Pottie

PROFILE

Mr. Pottie has been working as a professional in the IT industry for over 24 years. He has strong technical expertise and is a dedicated worker who excels at providing clients viable solutions when needed most. Mr. Pottie is a Consultant with several years of experience in the design and implementation of enterprise wide information systems and BI solutions. He has been involved in all areas of the system development life cycle including project management, business analysis, technical business analysis requirements definition, system design, implementation, training and post-production support. He specializes in the development of large-scale systems utilizing a Windows based and World Wide Web user interface. He has a strong background in Active Directory and Cognos BI applications, integrated with relational databases. He also possesses a broad knowledge of the system development tools currently available in the market and industry trends in this area. Mr. Pottie’s technical skills are complemented by his strong ability to develop excellent working relationships with client personnel. With over 18 years of BI experience, Mr. Pottie has played a lead role in implementing Cognos BI applications example: Cognos 11 & 10, Cognos 8, Framework Manager, Reportnet, Impromptu, Upfront, IWR, Power Play, Transformer and PPES for several clients. The main objective of these implementations was to design Cognos Framework models, OLAP cubes and reports plus configure and implement stable Cognos BI environments while providing key knowledge transfer to client personnel and assisting users in familiarizing themselves with Cognos BI solutions. In addition to his Cognos BI experience, Mr. Pottie has ETL knowledge working within Microsoft DTS as well as Data Stage. Email: adpvtx@r.postjobfree.com

Mr. Pottie has recently provided the IM/IT BI services required by Global Affairs Canada (GAC) for over the past 64 months.

Global Affairs Canada (GAC): As a Programmer/Analyst & Technical Business Analyst; Mr. Pottie has worked closely with Business Analysts, Data Modelers, DBAs and technical infrastructure sections to ensure that the data delivery environment met project requirements for the Grants and Contributions Program Delivery Transformation Project as well as the Integration of GAC’s two IBM Cognos BI platforms to provide Business Intelligence and Analytics Solutions across the Finance, Human Resources and Operations domains.

PROFESSIONAL EXPERIENCE

Project 1

Global Affairs Canada

Lead Technical Business Analyst

Dec 2020 – Dec 2021 (12 Months)

Project Description:

Global Affairs Canada (GAC) Grants and Contributions (G&C) Program Delivery Transformation (PDT) Project is to modernize and transform GAC’s Grants and Contributions (Gs&Cs) platform within a cloud based solution, delivering $5 billion in Gs&Cs across the department in support of the Government of Canada (GC) objectives. These objectives include open and transparent government, better service for Canadians, and evidence-base policy and programming. This effort was leveraged to enable the department to achieve its business processes, streamlining and simplification objectives for Gs&Cs, as well as to achieve digital service modernization and integrated data usage for improved accountability and results-based decision-making.

Tasks Performed:

Participated in requirements gathering sessions with project stakeholders and relevant end–users to gather and analyze business and technical data requirements for the new Results Based Management-Monitoring and Reporting system (RBM->MRT). The MRT Proof of concept (PoC) would kick –off the third pathfinder solution implementation within GAC’s MS dynamics365 cloud based solution.

Designed mock-up detailed MSR+ reports used within the (PoC) of the RMT solution.

Worked within an agile process, building user stories within DevOps for the RMT-POC solution.

Performed a detailed feasibility study of leading data intelligence technology and cost of the proposed architecture to validate and document functional and system design requirements.

Produced an Erwin Data Intelligence Proof of concept proposal to perform a technical evaluation of a Data-Intelligence suite as a proof of concept (PoC) to build an cohesive data catalog within a two- to three-month timeframe.

Captured and documented the high level business requirements from 27 business units, which interacted with Grants and Contribution via GAC’s APP processes.

Analyzed and documented the G&C data landscape health check assessment; The assessment aimed to perform and provide a general health assessment on the current state of GAC’s grants and contributions (Gs&Cs) partner, programme and project related data.

Performing inventory of existing data to highlight G&C current state by reviewing all business unit processes and verifying application shared data points within 12 individual systems.

Established purpose of use (value) for operational, analytics and management decision-making

Documented and captured SAP-PS module (Table/Field) data points in order to begin building the SAP master/reference data mapping document from SAP-Project -> TBS-EGCS model.

Development a source-to-target mapping from the SAP PS module to the Enterprise Data Warehouse (EDW) that documented 40+ tables that contained relevant SAP-Project data points.

Spear headed multi JAD sessions with solution and system architects (dynamic 365) as we mapped out the current dynamic solutions, capturing conformed data points while leveraging business glossary’s.

Aid in the development of SAP source to target mapping that documented the three dynamics systems that were derived and developed from the TBS-EGCS data model.

Provided status updates to upper management based on timeline gates and check points.

Mentored computer science co-op student building python scripts to automate data analyzes through schema data comparison.

Project 2

Global Affairs Canada

Programmer/Analyst

August 2016 – Dec 2020 (52 months)

Project Description:

With the amalgamation of the Department of Foreign Affairs and International Trade (DFAIT) and the Canadian International Development Agency (CIDA), Global Affairs Canada required the integration of the CIDA and DFAIT Business Intelligence/Data Warehouse (BI/DW) environments. The Business Intelligence and Analytics Solution Program (BIAP) is an ongoing major multi–year project to ensure that all BI solutions would be accessible from one platform, serving users at HQ and missions in the domains of Finance, Human Resources and Operations. As a Programmer/Analyst, Mr. Pottie has been providing IM/IT BI services to support the integration of the BI/DW environments into the IBM Cognos BI platform solution utilizing versions 8, 10 and 11 to accommodate different directories. This platform is intended to support the nature and scope of the Department’s Business Intelligence and Analytics needs, which require integration of data from complex source systems. Tasks Performed:

Participated in requirements gathering sessions with project stakeholders and relevant end–users to gather and analyze business and technical data and requirements for the amalgamated CIDA and DFAIT BI/DW environments. Performed a detailed feasibility study of the technology and cost of the proposed architecture from the context of the Logical Data Model to validate and document functional and system design requirements and specifications to baseline the development plans and support required for this multi–year project.

Used Cognos versions 8/10.2/11 to design and develop the IBM Framework Manager Model, OLAP Cubes, Report Studio reports and Cognos Metrics to design Framework Manager Model Packages, including Dimensionally Modeled Relational (DMR) and Relational Model packages, as well as canned reports for end users.

Used IBM Cognos Framework Manager versions 8/10.2/11, including star schema grouping and bilingual functions as well as custom SQL within Framework Manager, to develop the Framework Manager Model to generate dimensionally modeled data within the data warehouse environment.

Used IBM Cognos Report Studio 8/10.2/11, including bursting reports, to create, edit and distribute canned reports for end users.

Developed Transformer Cubes for the Cognos 8/10.2/11 BI platform, using IBM Cognos Transformer to build secure and fast data organized into customized dimensions and measures.

Established and documented design procedures and standards in accordance with IBM best practices and methods for the amalgamated BI/DW solution.

Developed Relational Model packages using Framework Manager to design star schema data structure to provide a foundation for developing Dimensionally Modeled Relational (DMR) packages for the amalgamated Cognos version 8/10.2/11 BI platform. Developed the DMR packages to enable an OLAP presentation of the metadata, provide drilling up and down capability and a variety of OLAP functions.

Used built–in Framework Manager tools to create query subjects and determinants to enable multiple–fact, multiple–grain querying capabilities. Created model regular dimensions to represent descriptive data with hierarchical levels, and model measure dimensions to represent quantitative data.

Generated and modified code, screens and reports from approved design documentation using SQL, Cognos Framework Manager and Cognos Report Studio.

Developed visualization of Proof of Concept (POC) data using Cognos Analytics 10.2 and later 11 including Dashboard, Story and Data Modules to provide end users with a POC high–level view of their business data. Level of effort developing visualization in Cognos Analytics 11 was 20 months.

Used Dashboard module to review, edit and develop POC business dashboards.

Reviewed, edited and developed POCs for the Grant & Contribution (G&C) business stories, using Story module.

Used Data modules to import new data fields within Cognos Framework Manager and to design data pre–filters within Framework Manager.

Performed unit testing and de–bugging for problems identified in system or user acceptance testing. Project 2

Office of the Superintendent of Financial Institutions Regulatory Returns System (RRS)

Programmer/Analyst

May 2014 – July 2016 (27 months)

Project Description:

The Regulatory Returns System (RRS) is a web–based system designed to collect and process regulatory data used by OSFI, the Canadian Deposit Insurance Corporation (CDIC) and the Bank of Canada (BoC). Regulatory data is collected, validated and transmitted to OSFI for further Extraction, Transformation and Loading (ETL) into various data warehouses to be consumed by OSFI’s Business Intelligence set of tools, within project applications such as Cost Effectiveness Management (CEM), Property and Causality

(P&C), Life Insurance (LIFE) and Risk Assessment System for Pensions (RASP). As Programmer/Analyst, Mr. Pottie provided IBM Cognos development support for these in–house proprietary systems used for analyzing financial data, including IBM Cognos versions 8 and 10. This project was delivered within a Business Intelligence, Enterprise Data Warehouse, On–line Analytical Processing (OLAP) data and application environment. Tasks Performed:

Collected and analyzed requirements and preliminary analysis materials from project stakeholders to assess feasibility of recommended technologies and architecture design. Used approved business and technical requirements to develop and document functional and detail design specifications in accordance with RUP Modeling methodology.

Conducted requirements gathering sessions with relevant end–users and then analyzed their proposed changes to the OSFI databases from the context of the Logical Data Model.

Prepared and implemented coding procedures, application design methods and standards, version control and migration/configuration processes for the design and development of the in–house financial systems using iterative agile development framework and SQL/MDX, SSAS, Cognos report studio and JavaScript.

Used Microsoft Office, Cognos 10 BI suite as well as MSAS 2014 tool sets to prepare various project documentation for the RRS system integrating with enterprise applications including CEM, P&C, LIFE and RASP including; forms, manuals, technical specifications, design documentation, code libraries, programs, data files, procedures and installation/implementation instructions.

Developed data models related to the design and development of a 3rd normal form (3NF) normalized data model and report design for the following enterprise applications (CEM, P&C, LIFE and RASP) within a MS SQL server environment to provide canned reports to end users. These data marts were then used to determine the data warehouse changes required to support corporate fact and dimensional data from source to target applications

Developed a conceptual data model consisting of facts and dimensions for the CEM enterprise applications within a MS SQL server environment. This conceptual data mart included design and development of Relational Data Model packages and Dimensionally Modeled Relational (DMR) packages using a star schema data model.

Designed and developed Relational Model packages for the Cognos 8 and 10 BI platform as part of developing the star schema data model to meet requirements for list–style reports and to provide a foundation for Dimensionally Modeled Relational (DMR) packages.

Utilized the star schema data model to develop Dimensionally Modeled Relational (DMR) packages for the Cognos 8 and 10 BI platform to enable an OLAP presentation of the metadata, provide drilling up and down capability and a variety of OLAP functions.

Used functional design documentation to develop, code, test and implement OSFI’s CEM application code, screens and reports using SQL/MDX, SSAS, Cognos Report Studio and JavaScript within an Agile environment, in response to issues through incremental, iterative work processes.

Designed and developed models using IBM Cognos Metrics Designer (v.8 and v.10).

Reviewed existing and developed new ETL (Extract, transform, load) development jobs in order to pin–point problem areas within the proof of concept Data Marts.

Designed and developed the CEM IBM Framework Manager Model, OLAP Cubes, Report Studio reports and Cognos Metrics within the Cognos 8 and 10 BI platform, working with and in a Business Intelligence Enterprise Data Warehouse, On–line Analytical Processing (OLAP) data and application environment.

Developed Transformer Cubes for the Cognos 8 and 10 BI platform, using IBM Cognos Transformer functions, to define OLAP cubes structure and data to provide multidimensional analysis capabilities. Performed tasks including defining the dimension map to manage dimensions and levels hierarchy in the data model.

Developed and coded within the Cognos application using IBM Cognos version 8 and version 10, including IBM Cognos Report Studio 8 and 10, Analysis Studio, Event studio and Cognos Framework Manager to design and develop solution components for loading regulatory returns information received from the Financial and Pension Plan into OSFI’s Master Data Hub (MDH).

Used IBM Cognos Report Studio 8 and 10 to create, edit and update multi–page and multi– query reports for field employees and the finance department. Created union queries, join relationships and pre–filters.

Helped in the creation of data marts, which required designing, developing and maintaining the logical data models and data dictionaries for the implementation and creation of database designs.

Acted as a Tier II and Tier III support go to person for production down issues through phone and email for the CEM, P&C, LIFE and RASP BI report applications.

Developed a set of application and database development standards as well as instruction on the use and optimization of data modeling techniques for all team members. Provided technical expertise to junior staff. All data models were created using entity relationship diagrams.

Involved in conducting formal data model reviews against a set of well–defined data architecture standards

Designed the enterprise Data Architecture so it increases and facilitates the sharing of data across the enterprise.

Created and maintained roles and responsibilities within the distributed enterprise Data Architecture to facilitate the management of data. This required a working relationship between the business user organizations and information services (IS).

When designing or modifying a database, reviewed the Metadata Repository for existing standard and proposed data elements before implementing a new database to ensure data elements are defined according to Metadata Repository standards.

Took the Entity–Relation (ER) model to the third normal form, and then de–normalized where necessary for performance.

Designed the data access infrastructure to support the transparency of the location and access of data by each application). In return these standards are being used as the benchmark for conducting further data model reviews.

Provided technical assistance, guidance, direction and advice to end users, executives and director level employees with varying degrees of data knowledge regarding data analysis and modeling.

Modified and developed MS SQL Server 2000–2014 database views, constraints, triggers, stored procedures and user defined functions in order to retrieve data from source to target databases.

Consulted with business users and the project team on data quality, issues and analysis concepts to ensure that everyone was performing at peak performance. Provided assistance to those who were lacking knowledge in certain areas.

Involved in the development and troubleshooting fixes for Microsoft SQL Server Analysis Services multi–dimensional cube to address problems found in Cognos Analysis Studio Reports.

Implemented Cognos 11 POC environment to validate security upgrade process guide lines which included the design and implementation of access security on their Cognos 11 BI platform using Active Directory and IIS via single–sign–on.

Used CA Erwin 8x data modeling tool to review and help design POC data models to be tested and used as a baseline mart within the development environment.

Led the development of business models, data models, metadata policies /standards / procedures, common tool sets and approaches.

As a result of new and updated requirements and specifications, worked with stakeholders to analyze new data and validate all gathered requirements to ensure all updates meshed well with the current database.

Technical Environment:

AllFusion ERWin Data Modeller 8.1; Microsoft SQL Server 2000 to 2014; Microsoft Visual Studio 2008 to 2013; Microsoft Team Foundation Server; Microsoft SQL Server Integration and Analysis Services Project 3

HRSDC

Programmer/Analyst

October 2013 – March 2014 (6 months)

Project Description:

Mr. Pottie returned as Programmer/Analyst for this phase of HRSDC’s Appeals Delivery Management System–Social Security Tribunal (ADMS–SST) application project. The ADMS–SST was developed as a web–based system designed to collect and process Old–Age Security Pension data for senior citizens within Canada on behalf of Health Canada. This project involved upgrading IBM Cognos BI platform from version 8 and 10, which required extraction, transformation and loading (ETL) data into various data warehouses to be viewed by the ADMS end users within Cognos 10 set of tools. Tasks Performed:

Analyzed client documentation and data and performed a detailed feasibility study (technology and cost) of the proposed system architecture to validate and document functional and system design requirements and specifications to baseline the development plans and support.

Analyzed and elaborated BI business, system, non–system requirements and information models leading to the BI project design, including development, test, maintenance and performance usability with the components being used within the Cognos 10 BI solution

Analyze and evaluate alternative technology solutions to meet business problems.

Developed technical architectures, frameworks and strategies, for ADMS group for their systems appeal application area, to meet the business and application requirements.

Generated and modified code, screens and reports from approved design documentation of the ADMS-SST using IBM Cognos 8 and 10, Oracle 11, Toad 10.6 and SQL 2005 SQL Server 2010 Enterprise. Performed unit testing and de-bugging for problems identified in system or user acceptance testing.

Designed and developed the dashboards and BI reports within Cognos 8 and 10 Query Studio, Report Studio, Analysis Studio.

Designed the ADMS Framework Manager Model and OLAP Cubes and drill–through reports within Cognos 10.

Produced functional specifications, developed, tested and implemented this phase of the ADMS BI Project. Developed Cognos Framework Manager Models and complex reports using Cognos Transformer and Cognos Report Studio within the DEV\UAT and PROD environments.

Reviewed and recoded PL–SQL scripts, views and logic used within the DEV/TST/UAT and PROD environments.

Designed and developed models using IBM Cognos Metrics Designer (v.8 and v.10) for HRSDC Business Intelligence Project.

Designed and developed BI OLAP cubes and OLAP reports using Cognos Transformer, Powerplay Client and Analysis studio within Cognos version 8 and 10.

Identified the policies and requirements to help determine a BI scorecarding solution via metric studio for the ADMS–SST application.

Formulated and analyzed SQL queries against large databases with over 900 gigabytes

Created the business information view, analyzed data and published customized reports

Designed and developed dimensional and advanced analytics/analytical frameworks consisting of facts and dimensional data for sourcing the OLAP data models in a data warehouse environment for the Cognos version 8 and 10 BI platform.

Utilized a star schema data structure approach to develop the Relational Model packages for the Cognos version 8 and 10 BI platform, providing a foundation for the DMR packages in order to provide OLAP data models in the data warehouse environment.

Developed Dimensionally Modeled Relational (DMR) packages to enable OLAP presentation of the metadata, including drilling up and down, for the Cognos version 8 and 10 BI platform.

Worked closely with the client, preparing and conducting JAD sessions to further detail the client’s requirements and also demo POC designs.

Deploy migration packages to the environments as well as documenting BI build books that details the environments as well as the reports and packages being used within their Cognos 10 environment.

Provided technical analysis and advice to client management and technical team on the design and development of performance scorecard solutions

Review ETL jobs in order to pinpoint problem areas found within the ADMS–SST data mart.

Review application and program design or technical infrastructure design to ensure adherence to standards and to recommend performance improvements.

Deploy FM packages within ADMS DEV\UAT and PROD environments. Technical Environment:

MS Windows XP; Cognos 10 Suite (Framework Manager / Transformer/ Report Studio/Analysis Studio and Query Studio) Oracle 11, Toad 10.6, SQL 2005 SQL Server 2010 Enterprise, MS Office Suite, Microsoft Visio

Project 4

Canadian Food Inspection Agency

Programmer/Analyst

June 2013 – September 2013 (4 months)

Project Description:

Mr. Pottie provided programming/analysis services on this project to support the design and development of the License Management System (LMS), a regulatory–based system that required all federally registered food processing plants in Canada to develop and implement an in–plant quality control program for export or for inter–provincial trade which must be registered with the Government of Canada.

Tasks Performed:

Analyzed and elaborated BI business, system, non–system requirements and information models leading to the BI project design, including development, test, maintenance and performance usability with the components being used within the Cognos 10 BI solution;

Identified the policies and requirements to help determine a particular solution for the LMS application

Designed and developed BI report specifications, developed and designed dashboards and BI reports within Cognos 8 and 10 Query Studio, Report Studio, Analysis Studio.

Prepared and conducted JAD sessions with the client and their IT/DBA team

Produced functional specifications, designed and developed LMS and DQ Framework Manager Model and OLAP Cubes that included trend analysis and forecasting within the OLAP cubes for Cognos 10.

Tested all elements of the LMS BI Project within Framework Manager, Transformer and Report Studio within the Dev\UAT and PROD environments

Formulated and analyzed SQL queries against large databases.

Designed and developed dimensional and analytical framework and dimensional OLAP data models, including Relational Model and Dimensionally Modeled Relational (DMR) packages, for the Cognos 10 BI platform using Framework Manager, Report Studio and Analysis Studio.

Created a star schema data structure, developing Relational Model packages for the Cognos 10 BI platform to provide a sound foundation for the DMR packages and enable OLAP data presentation.

Developed Dimensionally Modeled Relational (DMR) packages for the Cognos 10 BI platform to enable an OLAP presentation of the metadata, provide drilling up and down capability and a variety of OLAP functions such as SQL queries to enable more powerful set–based analysis.

Used built–in Cognos Framework Manager functions as well as star schema grouping and pre– filters to create query subjects and determinants to enable multiple–fact, multiple–grain querying capabilities. Created model regular dimensions to represent descriptive data with hierarchical levels, and model measure dimensions to represent quantitative data.

Designed and developed BI OLAP cubes and OLAP reports using Cognos Transformer, Powerplay Client and Analysis studio within Cognos version 8 and 10.

Designed the LMS portal integrating Cognos Metrics Designer Studio within CFIA’s Cognos 8 & 10 environments.

Deploying migration packages to the environments as well as documenting BI build books that details the environments as well as the reports and packages being used within the Cognos 8 & 10 environment.

Created the business information view, analyzed data and published customized reports

Reviewed and designed ETL jobs in order to extract/transform and load source data into CFIA’s data warehouse consisting of facts and dimensional data elements.

Implemented new project requirements within their MS Server POC environment working with Microsoft (T–SQL), SSIS and SSAS

Provided technical analysis and advice to client management and technical team on the design and development of performance scorecard solutions

Reviewed and designed ETL jobs within Data Manager in order to ETL data within the LMS Data Mart.

Designed and developed the LMS Framework manager model’s within Cognos 8 & 10 Framework Manager.

Developed & deployed Framework Manager Packages (v.8 & v.10) within CFIA’s Dev\UAT and PROD environments.

Documented all design code with regards to the ETL jobs and Cognos Framework manager. Technical Environment:

MS Windows XP; Cognos 8 &10 Suite (Data Manager / Framework Manager / Transformer/ Report Studio/Analysis Studio and Query Studio) Oracle 10, Toad 10.4, MS Office Suite, Microsoft Visio Project 5

HRSDC

Programmer/Analyst

March 2013 – May 2013 (3 months)

Project Description:

HRSDC mandated this business intelligence and analytics project to design and develop the Appeals Delivery Management System–Social Security Tribunal (ADMS–SST) application, to provide a web–based solution to collect and process Old–Age Security Pension data for senior citizens within Canada. The ADMS–SST collected and reported on data on behalf of Health Canada, and required processes for the extraction, transformation and loading (ETL) of data into various data warehouses to be viewed by the ADMS end users within the IBM Cognos version 8 BI platform. Tasks Performed:

Identified system and non–system requirements through business analysis of BI requirements and information models, leading to the development of detailed functional specifications and BI project design, including development, test, maintenance and performance usability with the components being used for the client’s BI solution;

Reviewed OAS canned report specifications, developed and re–designed Canned and OLAP reports within the Cognos 8 BI platform via Query Studio, Report Studio and Analysis Studio.

Unit tested the OAS reports within the Dev environment in order to setup deployment migration packages.

Helped in the configuration and usage of their MS Server POC environment working with Microsoft

(T–SQL), SSIS and SSAS

Participated in JAD sessions with the client

Developed Cognos Framework Manager Models for the IBM Cognos version 8 BI platform, including Relational Model and Dimensionally Modeled Relational (DMR) packages, and validated data accuracy within a star schema data structure comprised of facts and dimensions in a data warehouse environment to enable an OLAP presentation of ADMS-SST metadata, provide drilling up and down capability and a variety of OLAP functions.

Utilized the star schema data model to develop the Relational Model and DMR packages, creating query subjects and determinants to enable multiple–fact, multiple–grain querying capabilities. Developed model regular dimensions to represent descriptive data with hierarchical levels, and model measure dimensions to represent quantitative data.

Upgrade and developed Cognos Framework Manager Package and

Contact this candidate