Detailed project notes

• Produced conceptual, logical and physical models of data marts to be used for reporting purposes and for feeding data into online analytical models developed with the Cognos suite of business intelligence tools on premise and with Power BI on the Azure Cloud.
• Analyzed the sources of data for those data marts, mapped target data stores and elements to their sources, and identified data gaps.
• Produced and presented the entity-relationship diagrams and supporting documentation, including data dictionaries, making up the data models.
• Participated in the elaboration of standards and guidelines in the area of dimensional data modeling.
• Analyzed and modeled the data required for reporting on the agency’s trusted traders, on its postal modernization initiative, on the kiosk sessions, traveller inspections and other operations performed by the agency in airports, on its drug enforcement activities, on import and export declarations, on notices destined to carriers of imported goods, on its entry-exit initiative, and on high risk and low value shipments.
• Planned the delivery of my data analysis and modeling services.
• Used an agile DevOps-based methodology on the Azure Cloud and an agile JIRA-based methodology on the Amazon Cloud (AWS).

• IBM InfoSphere Data Architect, Version 9.1.1.0
• TortoiseSVN, Version 1.9 (a Subversion client for Microsoft Windows)
• IBM Netezza data warehouse appliance, Version 7.2.1
• Microsoft Office

• Proposed and presented three architectural options for a Human Resource Reporting Solution (HRRS) at AAFC.
• Produced a logical data model and a physical data model of the operational data store (ODS) and of the dimensional data warehouse that are integral parts of that solution.
• Extracted metadata from the PeopleSoft data dictionary.
• Developed business terms, in English and in French, to be included in a business glossary destined to the users of the HRRS.
• Mapped the data entities and elements of the ODS to their sources of data in PeopleSoft and in files received from other departments.
• Specified data extraction, transformation and loading rules.
• Worked on an inventory of data holdings for Canada’s “Open Government” initiative.
• Gathered documentation on common reference tables sourced from SAP and defined the relationships between those tables.
• Maintained operational data models up to date.
• Analyzed the impact of the Business Number Adoption Program on the department’s data assets.

• Erwin Data Modeler, Workgroup Edition, Release 8.2.06.3570
• Oracle SQL Developer, Version 4.0.1.14
• Microsoft Office

• Mapped existing reports to their current sources of data in a data warehouse.
• Mapped data entities and elements of the data warehouse to their current and new sources of data in operational data stores that currently exist and others that are to be implemented.
• Modified the logical data model of the above data warehouse to take into account new data entities to be sourced from ESDC’s new software suites in the areas of financial management (SAP) and human resource management (PeopleSoft).
• Analyzed some office location data requirements, some of which will have to be implemented in the existing data warehouse.
• Defined and modeled a database to be used for the production of reports on the processing of requests submitted through certain gateways and portals of ESDC’s Intranet.
• Built a logical model of the data in the current Corporate Management System (CMS), in the area of human resource management.
• Defined and modeled a database to be used for the production of reports on data extracted from the PeopleSoft software suite.
• Specified data extraction, transformation and loading rules.
• Specified the detailed logic to use to generate values for the reports’ calculated fields with pseudo code.

• Oracle SQL Developer, Version 4.0.1.14
• Microsoft Office

• Gathered, analyzed, classified, prioritized, documented and modeled the business requirements to be satisfied by a system tracking projects and activities planned and undertaken for the purpose of protecting the ecosystem of the Saint-Lawrence river.
• Produced a logical data model, use case scenarios and a document covering all business requirements not covered by either the data model or the use case scenarios.

• Microsoft Office

• Produced conceptual, logical and physical data models for the purposes of developing new data stores and of integrating them, along with existing data stores, into the agency’s data warehouse.
• Produced dimensional data models of data marts to be used for reporting purposes and for feeding data into online analytical models developed with the Cognos suite of business intelligence tools.
• Analyzed potential sources of data for those data marts against analytical data requirements.
• Produced and presented the entity-relationship diagrams and supporting documentation, including data dictionaries, making up the data models.
• Worked with subject-matter experts and developers to facilitate the specification and understanding of the business requirements expressed in the data models.
• Led work group sessions with those same subject-matter experts and developers.
• Analyzed and modeled data in numerous business areas of the CRA, such as individual identification, benefit program administration, corporate financial reporting, tax return assessment, other tax levies, payment processing, case management, communication production and content management.
• Planned data modeling activities for numerous system redesign, data warehousing and business intelligence projects.
• Elaborated some best practices and standards to guide the data modeling activities.
• Designed and delivered a data modeling workshop.
• Coached junior data modellers.

• Microsoft Office
• AllFusion ERwin Data Modeler release 7.1 and 7.2

• Analyzed and documented the reports to produce from a future data warehouse in seven areas of health surveillance activities.
• Interviewed representatives of the users of the reports and of the data warehouse.
• Analyzed and documented the informational and functional requirements to be satisfied by the data warehouse.
• Mapped the tables and columns of the data warehouse to their sources of data, and defined the rules of extraction, transformation and loading of data.
• Supervised and coordinated the development and testing of the extraction, transformation and loading modules.

• Microsoft Office
• SQL Server 2005

• Updated policies, procedures, forms and other documents used by the Telehealth programme of the Government of Nunavut.
• Developed policies, guidelines, standards and procedures in the area of informatics planning and services.
• Put the above documents on the GN’s Intranet.

• Microsoft Word
• Dynamic HTML (HTML + JavaScript + cascading style sheets)

• Reviewed and analyzed documentation and recommendations on and about the peer review process as applied to CIHR’s open-competition grants.
• Identified high-level business requirements to be addressed by the business intelligence strategy.
• Interviewed CIHR’s program staff, program managers and information technology specialists.
• Identified, defined and prioritized key performance indicators and their dimensions, and mapped them to the peer review sub-processes and to the high-level business requirements.
• Identified sources of data for the performance indicators and dimensions.
• Produced mock-ups of the required performance management reports.
• Participated in the writing of the business intelligence strategy report.

• Microsoft Word
• Microsoft PowerPoint
• Dynamic HTML (HTML + JavaScript + cascading style sheets)

• Modeled and defined two areas of DND’s EDM:   Location and Realty Assets.
• Produced, as part of those data models, entity-relationship diagrams and a complete dictionary of data entities, data attributes and data relationships.
• Correlated those logical data models with physical data models produced from existing data bases.
• Reviewed those diagrams and definitions with subject-matter experts from the directorates of Infrastructure Engineering and Construction Engineering.
• Documented the user-defined properties required by DEA as part of those data models.

• Microsoft Word
• ERwin version 4.0

• Identified, documented, analyzed and evaluated sources of data for the CDD.
• Modeled and described the components of the CDD’s staging area database.
• Interviewed database managers, data analysts, report distributors and users.
• Identified, defined and prioritized key performance indicators and their dimensions, to be made available via the future CDD.
• Mapped the sources of data to the CDD’s indicators and dimensions.

• Microsoft Office
• Silverrun-RDM

• Visited 15 school boards and 7 schools throughout the province of Ontario to gather their answers to a survey on the subject of student achievement.
• Interviewed superintendents, educational counsellors, principals, managers and teachers at the visited sites.
• Assessed the capacity of those sites to manage and use information related to student achievement.
• Translated answers from French to English.

• Microsoft Office

• Developed the charter for the whole project, identified elements to be written, organized those elements into a hierarchical structure, and planned the research and writing activities.
• Interviewed managers and technicians in IS.
• Wrote the definitions, guidelines, standards and procedures to include in the ISM.
• Suggested a list of topics for indexing the elements of the ISM.

• Microsoft Office

• Analyzed, modeled and described the business processes performed by three services of the Application Environment Services Directorate (AES).
• Mapped data requirements of future RPS' systems to RPS' Enterprise Information Model (EIM).
• Wrote a business case and submitted a proposal to get the funds required to assess the sensitivity of RPS' national systems to threats and risks in the area of information security.

• Lotus WordPro
• Visio 2000
• Oracle Designer

• Modeled and described the business functions within the Finance Group.
• Interviewed financial managers and users of financial data.
• Analyzed those functions and their interfaces in terms of their strengths and weaknesses, defined opportunities for improving those functions and interfaces, and identified the consequences of not making those improvements.
• Matched the business functions to specific initiatives in the areas of data warehousing and information management in general.
• Identified issues to be resolved to ensure the success of those initiatives.

• Visio 5
• Microsoft Word
• Microsoft Excel

• Produced a charter and detailed plan for the preliminary phases of the project.
• Produced detailed data specifications consisting of an entity-relationship diagram and a detailed data dictionary.
• Produced detailed functional specifications consisting of a functional decomposition diagram, a data flow diagram and a detailed process dictionary.
• Produced detailed user interface design specifications using HTML and JavaScript.
• Presented the specifications at group review sessions.
• Started the Request For Proposals (RFP) for the development and implementation of the future TSMS.
• Planned the subsequent development and implementation phases.

• Microsoft Word
• Visio Professional
• HTML and JavaScript

• Wrote use case descriptions for the administration of budgets, service contracts, travel claims, court fines and user fees, and for the import of financial transactions from the Integrated Financial and Materiel System (IFMS).
• Interviewed financial managers and users of financial data.
• Developed training material.
• Participated in the delivery of training sessions.

• MS Office
• HTML

• Planned the project.
• Reviewed the results of the implementation of CRMIS.
• Documented new functional and data requirements to be satisfied.
• Proposed some changes to the technical environment.
• Specified additions and changes to the data and processes.
• Produced a requirements document and detailed analysis and design specifications.
• Generated a new physical data model.
• Generated a new database loaded with data from the existing one.
• Developed a test strategy and plan.
• Supervised a software developer during the build and test phase.
• Produced an implementation strategy and plan.
• Tested the revised system.

• DataArchitect (part of the PowerDesigner CASE tool)
• Microsoft Word
• Seagate Crystal Reports Version 7

• Planned the documentation of the Financial Management System for Reporting (FMS/R).
• Reviewed and analyzed existing documentation on FMS/R.
• Assessed documentation gaps.
• Analyzed and documented the requirements for system maintenance documentation and for end user documentation.
• Developed data dictionary templates in HTML.
• Gathered metadata from various sources, including text files, spreadsheets and old data models.
• Interviewed financial experts.
• Produced a complete data dictionary covering data tables, views, elements and relationships.
• Designed, developed and populated a database of data dictionary information using MS Access 97.
• Designed and developed data dictionary extracts for the creation of pages to be published on one of PWGSC’s Intranet sites.
• Developed procedures for maintaining the data dictionary up to date.
• Translated data dictionary information from English to French.

• Lotus WordPro
• HTML
• SQL
• MS Access 97

• Assessed the year 2000 compliance of strategic and tactical assets of the Department of National Defence (DND).
• Researched technical documentation.
• Interviewed supply managers, life cycle material managers and representatives of original equipment manufacturers.
• Produced numerous assessment reports, risk analyses and contingency plans.

• Microsoft Word
• Microsoft Excel

• Reviewed the existing CRMIS, a prototype developed in Microsoft Access and a pay system for the Reserve Force that the future CRMIS will have to interface with.
• Documented the functional, data, technical and other user requirements to be satisfied by the future CRMIS, mainly in the areas of personnel and financial management.
• Conducted a work group session to get feedback from representatives of the Communication Reserve.
• Documented and analyzed alternative technical environments for the system.
• Developed a conceptual data model, including data definitions and rule specifications.
• Generated a physical data model from the conceptual one, including the specifications of triggers and other procedures to store in the future database.
• Planned the development, testing and implementation of the new system.
• Devised a data security and data replication strategy.
• Supervised the development team.

• DataArchitect (part of the PowerDesigner CASE tool)
• Microsoft Word

• Helped set up a business planning framework to be used to plan and control all major marketing and sales initiatives.
• Participated in the planning of the team’s activities.
• Defined, modeled and mapped business processes, information groups and information technology supporting CPC’s marketing and sales activities.
• Participated in the prioritization of the initiatives, in the analysis of the issues, and in the preparation of presentation material.

• Microsoft Word
• Microsoft Project
• Lotus Freelance
• Lotus 1-2-3
• CPC’s Novell LAN

• Interviewed managers and users of Human Resource Management (HRM) legacy applications to identify, analyze and design reports to be produced by the future data mart of personnel information.
• Specified views and stored procedures for reporting purposes.
• Identified data elements missing from the data mart and other data inconsistencies.
• Consolidated similar reports into more general reports.
• Developed report menus and descriptions in HTML for publication on DND’s Intranet.

• Crystal Reports 5.0
• Microsoft Word
• Microsoft SQL Server
• Intranet

• Developed policies, standards and procedures for the management of HRDC’s information resource.
• Defined metadata for the purpose of documenting a data warehouse’s data sources.

• Designer/2000 (Oracle)
• Microsoft Word

• Participated in group workshops for the purpose of creating Work Breakdown Structures (WBS) and work package descriptions for different types of projects and project phases managed by the Bureau of Physical Resources.
• Among the types of projects studied were new construction, renovation, purchase fit-up and lease fit-up projects.
• Among the project phases studied were feasibility studies, site acquisition, design, construction and disposal phases.

This is an on-going project that I work at between my other projects.  I am developing a set of integrated stand-alone applications in Java, which applications I use to help me in the administration of my consulting business and to demonstrate my knowledge and command of the language.

To this day, I have developed and am improving upon the following applications:

• an application that maintains code tables referred to by the other applications;
• an accounting management application that maintains an hierarchical general ledger of accounts, accounting transaction codes, journal entries and invoices;
• a metadata management application that maintains data on information systems, on their components, and on those components' properties, methods and relationships;
• a contact management application that maintains information on individuals, organizations and geographical locations; and
• a content management application.

I have also developed logic that allows the above applications to maintain and share their data via a common database and set of indexes, and via classes specially designed to manage those data and indexes.

• Java Development Kit (JDK)
• Flying Saucer, a renderer of XHTML code using CSS rules
• Apache Formatting Objects Processor (FOP)
• JavaMail

• Acted as a planning facilitator on two of the projects comprised in the Canadian Firearms Program sponsored by the Department of Justice Canada:
  • Quebec Transition Project, and
  • RCMP Transition Project.
• Helped project teams develop:
  1. project charters,
  2. work breakdown structures,
  3. work package plans,
  4. schedules, and
  5. budgets.
• Used the Bates project management methodology and Microsoft Project to develop plans.
• Produced work packages in Microsoft Excel from plans in Microsoft Project.
• Automated part of the production of those work packages.

• Seven distinct phases, each with their own specific activities and deliverables, were defined for the pilot project:
  1. Define the Scope of the Pilot;
  2. Prepare Pilot Implementation;
  3. Define and Model Data Warehouse;
  4. Identify and Analyze Sources of Data;
  5. Develop and Issue RFP for the Development and Implementation of the Pilot;
  6. Develop and Implement Pilot; and
  7. Analyze Results of Pilot and Make Recommendations to D2000 Committee.
• Participated in first four phases and in phase 6 of the pilot. Phase 5 was skipped because of lack of time.
• Designed an output framework model to capture information requirements linked to outputs, performance indicators and business processes.
• Defined and modeled the data structures of the business planning prototype.
• Participated in the detailed analysis of information requirements and of candidate feeder systems.
• Identified data gaps and recommended solutions for the pilot.
• Participated in the selection of an EIS/DSS tool.
• Wrote specifications for the extraction of data from the various data sources (10), for the population of the data warehouse and for the generation of user views from the data in the data warehouse.
• Participated in the writing of a report summarizing the pilot’s results, in particular the work done, the results obtained and the lessons learned, and proposing next steps and an LFC-wide implementation plan.

project definition and scoping, identification of performance indicators, data analysis and modeling, analysis and description of information technology architectures, writing of processing specifications, and implementation planning.

• Participated in the analysis of the applicability of data warehousing concepts to the business planning process being implemented at the Department of National Defence (DND).
• Visited the sites selected for a pilot implementation of a data warehouse to gather specific requirements in the areas of performance management and cost management.
• Participated in the identification of candidate feeder systems, in the technical description of the required data warehouse, and in the description and comparative analysis of possible architectural configurations for the data warehouse.
• Formulated a recommended approach.

• Worked on a study for the purpose of defining data contents of bar codes to put on mail products.
• Interviewed numerous system managers and brand managers at Canada Post.
• Documented the existing situation in terms of bar code usage and potential uses of bar codes by business function and by mail product.

• Revised the technical contents of a request for proposals for the acquisition of equipment, software and services destined to two departments of the government of Mali.
• Developed the evaluation methodology, the evaluation criteria and the evaluation grid.
• Participated in a mission in Bamako, Mali, to review these evaluation items and to finalize the material to include in the request for proposals, with representatives of the two departments.

• Wrote data and process specifications to modify Evenchick’s Order Processing and Invoicing System (OPIS) so that it can input electronic purchase orders received from Eaton and produce the corresponding electronic invoices.
• Worked from a standard format for Electronic Data Interchange (EDI), namely the standard called ANSI X.12, version 3020, and Eaton’s mapping documents.

• Defined a number of information management options available to the Civilian Personnel Branch of DND to address its functional, technical and organizational requirements which were previously defined in a requirements statement report.
• Analyzed and compared these alternatives.
• Formulated a recommended approach.
• Participated in the definition and planning of the recommended projects and initiatives.

• Analyzed the users' requirements for one or many databases of aggregated results produced from census and survey data maintained by the Mineral Industry Commodity Information System (MICIS).
• Produced a design document addressing the requirements to be satisfied, and containing a data model and a complete data dictionary describing the new and modified entities, relationships, and data elements.
• Reviewed the design document with users.
• Wrote the detailed design specifications for the new and modified processes.

• Wrote technical standards to be included in the request for proposals for the development of an interface between the planned Public Service Compensation System (PSCS) and a suite of existing Personnel Management Information Systems (PMIS).
• Developed the evaluation methodology and the evaluation criteria which were also included in the request for proposals.

• User Guide;
• System Administration Guide;
• Training Manual for the User; and
• Training Manual for the System Administrator.

• Assessed existing tracking system.
• Interviewed evaluators of medical device submissions.
• Documented the user requirements in the area of submission tracking (pre-market review process).
• Modeled their information needs.
• Recommended a course of action for the short term and one for the long term.

• Modified marking guide to be used to grade answers to a CS-3 board.
• Marked answers to 5 questions based on DMR’s Productivity Plus methodology.
• There were about 75 papers to mark.

• Coached people on using the Elections Management System (EMS), electronic mail on a Banyan LAN and Windows.
• Reported problems encountered to the development team.

• Matched data elements that can be obtained from SSC’s systems, mainly SSC’s Departmental Personnel Management System (DPMS), to elements in CSC’s new Human Resource Information Management System (HRIMS), which CSC got from Statistics Canada.
• Researched the documentation that was available and interviewed people at SSC and at Statistics Canada.

• Interviewed HR and operational staff to document their requirements for a Human Resource Management Information System (HRMIS).
• Compared and analyzed seven options against each requirement.
• Rated the options and recommended one.
• Participated in the writing of both the requirements and the feasibility documents.

• Produced the conceptual and logical data models corresponding to a records management system called OfficeRecords that was to serve as the basis for the development of an MGIH (Management of Government Information Holdings) prototype for DND.
• Participated in interviews of DND personnel to gather their needs in the area of information holdings management.
• Documented, analyzed and prioritized these needs, and recommended changes to the OfficeRecords package for the first prototyping round.
• Produced data and process models for the MGIH prototype.

• Documented the flow of eleven superannuation documents within five departments' compensation units, four departments' pay offices in the Pacific region and SSC’s superannuation branch in the Atlantic region.
• Used modified data flow diagrams and a CASE tool to document the flows.
• Matched the flow diagrams to descriptive text.

Delivered this five-day course in French to a class of six (the 1st time) and a class of five (the 2nd time) public servants coming from different departments of the federal government.

The course was entitled: Gestion de projets informatiques dans la fonction publique; in English: Management of informatics projects in the public service.

• Revised and made corrections to two French courses offered by PSC to employees of the Federal Government:
  • C707: Gestion de projets informatiques dans la fonction publique;
  and
  • C804: Gestion de la technologie de l’information.
• Translated some new material added to the corresponding English versions of those courses.

• Presented the System Architect CASE tool to a group of analysts at RMOC.
• Documented the data entities, relationships, elements and associated rules using the CASE tool.

• Participated in the elaboration and in the execution of the quality assurance activities associated with the production of the business and information models, the model management blueprint, the data flow diagrams and the data element dictionary.
• Participated in walkthrough sessions with members of the user community.
• Populated Excelerator data dictionary with data element definitions.

• Working from the existing file design, developed a new system in dBASE IV to maintain statistics on cases and workload in the area of social services.
• Added some files to make the application as data-driven as possible without changing the existing files.
• Installed and demonstrated the application.
• Trained the system’s main users in the National Capital Region.
• Wrote the user guide for the system.

• Defined and modeled the personnel functions and data to serve as reference for the rest of the planning activities.
• Interviewed representatives of personnel units and line management in all six administrative regions of CSC.
• Defined the major requirements to be addressed by the information systems plan.
• Assessed 41 existing automated systems.
• Described the initiatives and projects to be undertaken as part of the systems plan.

• Identified and documented data elements that are commonly used across multiple applications of SSC’s Departmental Personnel Management System (DPMS).
• Elaborated a strategy for the integration of all of DPMS data, functionality and technology.
• Presented this strategy to managers of the DPMS Enhancement Project.
• Devised an overall data model and data dictionary for the future integrated DPMS.

• Documented the existing census processing flow.
• Documented the logical data and functional requirements with data and process models and high-level descriptions of the data entities and logical processes.
• Participated in meetings of the design group and in the elaboration of new processing alternatives.

• Designed the module and screen structure of a classification tracking system and a staffing system.
• Wrote part of the pseudo code and supervised another analyst in writing the rest of the pseudo code.
• Presented and defended the design.

• Worked with a subject matter expert to specify the requirements for a classification tracking system and a staffing system to be integrated into SSC’s Departmental Personnel Management System (DPMS).
• Documented the data and functional requirements with data and process models and a complete data and process dictionary.
• Participated in meetings and presentations to the future users of the systems.

• Led a team of three analysts in the specification of program and file changes resulting from the conversion of social insurance numbers (SIN) to personal record identifiers (PRI).
• Looked at all programs in Personnel systems, maintained or developed by the Personnel Systems Group.
• Wrote the change specifications for the COBOL and NATURAL programs.
• Planned the implementation of the changes.

• Produced the data and process models for the whole system using a CASE tool (System Architect).
• Produced a data dictionary comprising entities, relationships, data elements and processes.
• Wrote the detailed design specifications for four of the eight subsystems.
• Helped the project manager supervise the three to five programmers involved in the development of the system, and replaced that same manager during his absences.

• Wrote the user requirements for an Office Systems Environment (OSE) to support the operations of the Excise Branch at Revenue Canada - Customs and Excise.
• Participated in the process of preparing Requests For Proposals (RFPs) for the acquisition and development of office systems, and external information services as those provided by service bureaus.
• Planned the implementation of projects.
• Organized and chaired user and work groups.
• Interfaced between the users of office systems and external services, and the organization in charge of procurement and implementation.

• Reviewed the status of their documentation on the Departmental Personnel Management System (DPMS).
• Interviewed people involved in the maintenance of the set of manuals and some representatives of typesetting and/or printing outfits.
• Documented and analyzed documentation alternatives.
• Participated in the writing of the final report.

• Gathered, documented and analyzed the requirements of the Moncton Regional Office in the area of subsidy control.
• Interviewed staff in Moncton and in the National Capital area.
• Modeled information and processing needs of the Office in the area of subsidy control.
• Built a data dictionary of all system components.
• Designed the new Subsidy Control System with the help of structure charts and pseudo code.
• Supervised the development of the new system and participated in it.
• Demonstrated the system on three separate occasions, once in Hull and twice in Moncton.
• Wrote conversion programs to recuperate data stored in the old subsidy control system.
• Helped with the production of the user guide.

• Reviewed and analyzed specific urgent issues that could affect the plan, including the situation in Moncton.
• Interviewed the Agency’s senior management in all the branches.
• Described and analyzed the current business environment and the current situation in terms of applications and technology supporting the business functions.
• Participated in the elaboration of the strategy and three-year plan.

• Developed all components of a PC-based correspondence management system using the prototyping approach.
• Developed interfaces with a word processing package and with an electronic mail package.
• Developed many reports.
• Made changes so that it can function in a LAN environment.
• Converted system from dBASE III Plus to CLIPPER.
• Prepared complete system and user documentation.
• Conducted system test.
• Trained users.

• WordPerfect
• 3 Com 3+

• Conducted interviews, in French and in English, to gather information on the business of the Branch and on the current situation.
• Participated in the analysis of the business environment and of the current situation in terms of applications and technology support.
• Built business information flow models for the four divisions and the whole Branch.
• Built a conceptual data model showing major subject data bases and relationships between them.

• Helped the project manager to manage the analysis phase of the BCIP.
• Assisted the architecture and design team in designing the conceptual and logical data models.
• Acted as a facilitator of JAD (Joined Application Development) sessions with the users.
• Mapped the logical data model to the source systems.

• Evaluated the technical soundness, the level of adaptability and the performance of the Mutual Funds System (MFS).
• Evaluated Royal Trust’s plans for adding new functionality and data to the current system.
• Drew general conclusions and made general recommendations.
• Made two presentations to information systems managers and wrote the evaluation report.

• Participated in two planning sessions with employees of the branch.
• Conducted interviews, in French and in English, to gather information on the business of the Branch and on the current situation.
• Participated in the analysis of the business environment and of the current situation in terms of applications and technology support.
• Built a conceptual data model showing major subject data bases and relationships between them.

• Delivered 15 hours of training at the rate of three hours per week, for five consecutive weeks.
• Taught BASIC language programming to five adults using a "hands-on" approach.

• Acted as a mentor on this project.
• Coached a team of five analysts in using the MINI-ASYST systems development methodology for the development of the Social Insurance Registry (SIR) system.
• Made transition from the general design to the detailed design.
• Taught these analysts the practical use of data and systems modeling techniques.
• Did data modeling at the conceptual and logical levels using Entity-Relationship diagrams.
• Did detailed design of the conversion subsystem.
• Modeled the subsystem at the logical and physical levels using data flow diagrams.
• Defined the processes, data flows, data stores and data elements appearing on the process models.
• Did structure charts for subsystem.
• Specified the modules with pseudo code.

• Modeled business functions of the Office and participated in defining the overall applications architecture.
• Developed process models for the following business functions:
  • Orders In Council (OIC),
  • Cabinet Papers,
  • Machinery of Government,
  • ATIP,
  • OPPC,
  • PM Correspondence and
  • PM Switchboard.
• Documented the current applications supporting the business functions.

• Acted as a mentor on this project.
• Coached a team of three analysts in using the MINI-ASYST systems development methodology for the development of the Overpayment Recovery system.
• Made transition from the general design to the detailed design.
• Taught these analysts the practical use of data and systems modeling techniques.
• Did data modeling at the conceptual and logical levels using Entity-Relationship diagrams.
• Did detailed design of the Recovery subsystem.
• Modeled the subsystem at the logical and physical levels using data flow diagrams.
• Defined the processes, data flows, data stores and data elements appearing on the process models.
• Did structure charts for subsystem.
• Specified the modules with pseudo code.

• Assisted in defining enhancement requirements.
• Implemented major enhancements to pilot system using the prototyping approach.
• Liaised regularly during the project with a user representative.
• Prepared system and user documentation.

• Developed conceptual and logical data models for the following business areas:
  • Prime Minister’s Correspondence,
  • Cabinet Documents,
  • Orders in Council, and
  • Records Management.
• The conceptual data models consisted of entity relationship diagrams, descriptions of entities, relationships and elements or attributes, and definitions of constraints affecting the models.
• The logical data models consisted of data structure diagrams (modified Bachman diagrams) and associated descriptions of data structures.

• Supervised a maintenance and development team as project leader.
• Coordinated maintenance and development activities on the Grants and Scholarships systems.
• Documented present systems to uncover deficiencies and ease up maintenance.
• Uncovered the major deficiencies of those systems while making their maintenance feasible.
• Introduced the use of structured analysis and design techniques along with optimized programming and documentation standards.
• Designed and developed a full-screen interface making application programs capable of interacting with the user through video-displayed forms.
• Introduced use of decision table logic as input to application programs.
• Participated in the analysis, design, development and testing of an on-line travel claim system executing on microcomputers.
• Produced the logical and physical data models for that system.
• Supervised the conversion of procedures and programs from a TSS environment to an MVS/XA environment, while participating in that same conversion.
• Created and maintained VIEWPOINT files and reports.
• Developed menu-driven software in APL including file transfer utilities and report functions.
• Managed projects following an established systems development life cycle methodology.
• Supervised a team of two to three people responsible for assisting users of microcomputers, including members of grant selection committees.
• As the person in charge of a microcomputer centre at NSERC, evaluated numerous software packages such as spreadsheets, software development tools and word processing software.
• Maintained excellent relationships with users, data processing staff and managers.

• Was responsible for unit, integration, system and acceptance testing of various programs manipulating the central Census data base.
• Elaborated testing strategies and wrote test plans.
• Designed test cases, conducted tests and reported on testing activities and test results directly to management.
• Reviewed system design and user manuals as part of system testing.
• Designed, developed and implemented a test data generation utility to simulate Census questionnaires.
• Analyzed users requirements described in decision table format.

• Created SPSS system files.
• Produced frequency tables and cross-tabulations.
• Taught TSO to the user and got to use SPF (Systems Productivity Facility).

• Participated in the development of a transaction-oriented inventory system using COBOL and a network-based data base management system (EDMS).
• Was responsible for the design and development of the data base update subsystem.
• Integrated subsystems into one system.
• Set up production control procedures using CP-V.
• Designed test data.
• Tested entire system from the data entry and edit subsystem to the report programs.
• Documented the programs with pseudo code.
• Helped train the users.
• Supervised new programmers assigned to the project.

• Maintained various batch systems including the Canadiana catalogues and microfiches (SELECT and CANADIANA).
• Prepared integration of batch systems into an on-line bibliographic system called DOBIS.
• Wrote new job submission procedures for the monthly production runs.
• Supervised clerks in running them.
• Designed, developed and tested programs for new products from the bibliographic master files.
• Worked directly with librarians.

• Reviewed and modified specifications in decision table format to correct errors and inconsistencies in survey data.
• Analyzed results of corrections and wrote specifications to reformat the survey file to be used by SPSS.
• Designed, developed and tested the reformatting programs.
• Documented the contents of the final survey file for external users.

• Developed a system of payments to the provincial and territorial governments for the purpose of financing post-secondary education.
• Designed, coded and tested the first two programs, i.e., the data edit program and the payment calculation program.
• Used pseudo code and structured programming techniques.
• Supervised another programmer in completing the rest of the development.
• Tested the complete system with own data with and user-supplied data.
• Recuperated all data captured by the manual system.
• Met target date while working under constant pressure.

• Worked with user in defining the bibliographic requirements.
• Evaluated previous data entry system and recommended use of an on-line data base and transaction files.
• Designed and built a data base for storing a list of documents published and sent by the CCITT to DOC every month.
• Designed, developed and tested the on-line data entry and edit subsystem.
• Wrote system and user documentation for the data entry and edit subsystem.
• Trained the user.

• Did statistical analysis and modeling of unemployment legislation.
• Developed utility and report programs on a request basis.
• Produced work files to be used by report programs.
• Set up test and production procedures.
• Maintained program libraries (source and object) and documentation.
• Satisfied numerous urgent requests.

• Produced regular and ad hoc reports from an on-line corporate profit data base.
• Dealt directly with the data base users.
• Converted production procedures from an OS/MVT/HASP environment to an OS/MVS/JES3 environment.
• Designed, developed, tested and documented a comprehensive extract system to produce a batch version of the data base.
• Set up on-line procedures.
• Trained other programmers in using the data base and the related procedures.
• Enhanced the quality of results delivered to the users.

• Programmed a bilingual system of questions and answers using a programmable terminal with tape drives.
• Supervised a data entry clerk.
• Wrote user documentation to be used by the visitors at the display site.

• Designed and coded the edit programs of the following subsystems:   expenditures, journal vouchers, cash flow and budget allocation.
• Designed input forms for entering test data.
• Created test data.
• Worked under a very tight schedule.

• Performed as a programmer/analyst in a section responsible for providing computing services to economists and policy analysts.
• Produced statistical reports such as a cross-tabulations, regressions and frequency tables.
• Defined specifications for reports and statistical tables with users.
• Converted and manipulated survey files coming from external sources.
• Designed and developed programs to produce user-tailored statistical tables.
• Worked on a simulator of welfare policies with a policy analyst.
• Designed and programmed a password generation system for on-line accounts.
• Trained clerks and co-op students.
• Acted as a consultant to users in running the systems and in their own programming tasks.

• Maintained a record of data base usage by application programmers.
• Was in charge of backing up, reorganizing and recovering the data base.
• Acted as an interface between the data base users and the data base administrators.
• Programmed a utility that generates a standard set of data dictionary commands.

• Documented a loan authorization system using a kit of documentation techniques and forms called SCOT.
• Investigated the system by interviewing its responsible officers, its programmers and some of its users.
• Uncovered some flaws in the system.

• Started as an operator of a remote job entry station.
• Assisted the operators of an IBM mainframe.
• Programmed segments of a general ledger system and accounts receivable system.
• Maintained source programs and documentation using an automated file management system.