Peter Merritt
Summary
Dynamic web and database application developer with over 25 years of extensive IT experience, specializing in ColdFusion, SQL, and Oracle. Expertise in the Fuse-Box site architecture methodology, complemented by a commitment to expanding knowledge in .NET with C#. Proven success in all facets of web application maintenance and development on relational databases, including coding, analysis, debugging, and documentation, while ensuring compliance with Government of Canada standards and Web Content Accessibility Guidelines (WCAG) 2.0. Exceptional communication skills facilitate effective collaboration within teams or independent work, consistently delivering innovative solutions to complex challenges.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Programmer Analyst/ Web Application Developer
Environment Canada (ECCC)
Ottawa, ON
06.2022 - 09.2025
- Mr. Merritt participated in the development and maintenance of numerous web applications that conformed to the Web Content Accessibility Guidelines (WCAG) 2.0 Level A and Level AA. This involved implementing changes to code, screen design, and database modifications. He utilized ColdFusion 2023 and MS SQL 2019 and he performed development using standards that are Government of Canada Common Look and Feel (CLF) Standards. Assisted in the migration of several web applications from on-prem to cloud based server. Performed data exports using MS SQL Server and MS Excel spreadsheets including the development of stored procedures and functions.
- The framework of web applications maintained and developed was Fusebox 5.5 with MVC.
- Web application code written using Visual Studio Code.
- Writes application code and maintains applications using ColdFusion 2023 and MS SQL 2019.
- Designed and documented data model change requirements.
- Performs SQL integration with web-based content via ColdFusion.
- Utilized XML for use of application configuration settings and retrieval of items within language repository files.
- Performed application development, testing, troubleshooting and analysis for implementation of web-based application systems.
- Environment: ColdFusion 2023, ColdFusion FuseBox 3-5.5 MVC, ColdFusion CFC components, MS SQL 2019, HTML, CSS, JavaScript, XML, XHTML, Government of Canada Common Look and Feel (CLF) 2.0 Standards, WCAG 2.0, Visual studio Code, GIT/Azure DevOps Portal
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Provided ongoing support for users experiencing issues or requiring assistance with application functionality.
- Contributed to successful project completion with effective time management and prioritization skills, meeting tight deadlines consistently.
- Collaborated with cross-functional teams to ensure seamless integration of new features into existing applications.
- Provided technical support using knowledge of complex technology to solve problems and support new projects.
- Developed and maintained applications supporting environmental data collection and reporting processes.
Programmer Analyst/ Web Application Developer
Natural Resources Canada (NRCan)
Ottawa, ON
09.2014 - 06.2022
- Mr. Merritt participated in the development and maintenance of numerous web applications that conformed to the Web Content Accessibility Guidelines (WCAG) 2.0 Level A and Level AA. This involved implementing changes to code, screen design, and database modifications. He utilized ColdFusion 10-2016 and MS SQL 2012-2016 and Oracle 11g, and he performed development using standards that are Government of Canada Common Look and Feel (CLF) Standards.
- The framework of web applications maintained and developed was Fusebox 5.5 with MVC.
- Web application code written using Sublime Text.
- Writes application code and maintains applications using ColdFusion 10-2016 and MS SQL 2012-2016 and Oracle 11g.
- Designed and documented data model change requirements.
- Performs SQL integration with web-based content via ColdFusion.
- Utilized XML for use of application configuration settings and retrieval of items within language repository files.
- Performed application development, testing, troubleshooting and analysis for implementation of web-based application systems.
- Environment: ColdFusion 10-2016, ColdFusion FuseBox 3-5.5 MVC, ColdFusion CFC components, Oracle 16, MS SQL 2012-2016, HTML, CSS, JavaScript, XML, XHTML, Government of Canada Common Look and Feel (CLF) 2.0 Standards, WCAG 2.0, Adobe Dreamweaver CS4, TortoiseSvn/Subversion
- Developed and maintained applications supporting environmental data collection and reporting processes.
- Collaborated with cross-functional teams to enhance system functionalities for improved user experience.
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Performed regression and system-level testing to verify software quality prior to release.
- Updated documentation with project deviations to capture changes.
Programmer Analyst/ Web Application Developer
Agriculture and Agri-Food Canada (AAFC)
Ottawa, ON
09.2014 - 07.2017
- Mr. Merritt was involved in the maintenance and development of the Agricultural Industry Market Information System (AIMIS) application. AIMIS is a web-based system with bilingual functionality utilizing ColdFusion and Oracle 11g. The code utilized the FuseBox framework with ColdFusion CFC components and Data Access Objects. Mr. Merritt implemented the Common Look and Feel (CLF-1 and CLF-2) requirements in various application websites including the most recent version of the guidelines for conformance to the Web Content Accessibility Guidelines (WCAG) 2.0 Level A and Level AA.
- Reviewed available software programs and selected appropriate applications based on the client's infrastructure.
- Created, developed, wrote and modified application code, screens and reports, and maintained the application.
- Performed modifications on Oracle 11g database (RDBMS), including creating tables, indexes and foreign keys.
- Used SQL as an information retrieval package and performed SQL integration with web based content via ColdFusion and the FuseBox framework with ColdFusion CFC components and Data Access Objects.
- Performed application testing, troubleshooting, and analysis using the ColdFusion application development tools.
- Reviewed and revised instructions and altered sequence of operations as required correcting program errors.
- Liaised with technical personnel and staff to discuss planning programs and translated detailed flow charts into coded instructions.
- Developed as part of a team to deliver applications using ColdFusion and Oracle 10g by creating and interpreting Use Cases and UML diagrams.
- Developed stored procedures for Oracle 11g Database Server and performed modifications to the database including creating tables, foreign keys and indexes.
- Implemented customer-facing solutions including enterprise backend integrations.
- Environment: ColdFusion 10, ColdFusion FuseBox, ColdFusion CFC components, Oracle 11g, TOAD, HTML, CSS, JavaScript, XML,XHTML, Government of Canada Common Look and Feel (CLF) 2.0 Standards, MS Windows XP, MS Word, MS Excel, Linux and HP Unix Servers, AAFC/Agrisource Wrapper, Eclipse 3.7, MS Visual SourceSafe, JIRA Bug & Issue Tracking
- Collaborated with cross-functional teams to enhance system functionalities for improved user experience.
- Developed and maintained applications supporting environmental data collection and reporting processes.
Programmer Analyst/ Web Application Developer
Natural Resources Canada (NRCan)
Ottawa, ON
08.2012 - 09.2014
- Mr. Merritt participated in the development and maintenance of numerous web applications that conformed to the Web Content Accessibility Guidelines (WCAG) 2.0 Level A and Level AA. This involved implementing changes to code, screen design, and database modifications. He utilized ColdFusion 9-10, MS SQL 2008 and Oracle 11g, and he performed development using standards that are Government of Canada Common Look and Feel (CLF) Standards. He was also responsible for implementing requirement changes for the ERD Authorized Explosives websites as well as providing maintenance for the ePayment web application.
- Defined database model changes required for implementing change requests for materialized views and tables.
- The framework of web applications maintained and developed was Fusebox 5.5 with MVC.
- Designed and documented data model change requirements.
- Performs SQL integration with web based content via ColdFusion.
- Performed modifications on MS SQL Server database (RDBMS), including creating tables, triggers, indexes and foreign keys.
- Utilized XML for use of application configuration settings and retrieval of items within language repository files.
- Environment: ColdFusion 9-11, ColdFusion FuseBox 5.5 MVC, ColdFusion CFC components, ASP.Net, Oracle 11g, HTML, CSS, JavaScript, XML, XHTML, Government of Canada Common Look and Feel (CLF) 2.0 Standards, WCAG 2.0, Adobe Dreamweaver CS4, TortoiseSvn/Subversion
- Mentored junior analysts on best practices in coding standards and software methodologies.
- Responded to and remedied critical issues to limit downtime.
- Identified causes of issues within applications and determined which modifications needed to be made.
- Safeguarded sensitive information by incorporating robust security measures into application design.
Programmer Analyst/ Web Application Developer
Agriculture and Agri-Food Canada (AAFC)
01.2012 - 07.2012
- Mr. Merritt assisted in the conversion of various web applications for conformance to the Web Content Accessibility Guidelines (WCAG) 2.0 Level A and Level AA. This involved implementing changes to manual code, screen design, and database modifications. He utilized ColdFusion and Oracle 10g, and he performed development using standards that are Government of Canada Common Look and Feel (CLF-2) Standards compliant utilizing Extensible Hyper Text Markup Language (XHTML), Cascading Style Sheets (CSS), and JavaScript compliant code.
- Wrote application code and maintained web application using ColdFusion 7 and Oracle 10g RDBMS.
- Develops and modifies manual code, screens, software and report changes using ColdFusion and Oracle 10 g.
- Designed, documented, and implemented data model changes.
- Performed database modifications, including the creation of tables, columns, assignment of primary and indexes.
- Performs SQL integration with web based content via ColdFusion utilizing Extensible Hyper Text Markup Language (XHTML), JavaScript and Cascading Style Sheets (CSS) compliant code.
- Liaised with technical personnel and staff to discuss planning programs and translated detailed flow charts into coded instructions.
- Implemented a customer facing solution including enterprise backend integration.
- Performed application development, testing, troubleshooting and analysis for implementation of computer systems.
- Reviewed and revised instructions and altered sequence of operations as required correcting program errors.
- Integrated content within the new Agrisource Wrapper including menu and mapping modules and worked with the quality assurance team to implement this application.
- Environment: ColdFusion MX 6-10, ColdFusion FuseBox, ColdFusion CFC components, Oracle 10-11g, TOAD, HTML, CSS, JavaScript, XML, XHTML, Government of Canada Common Look and Feel (CLF) 2.0 Standards, WCAG 2.0, Adobe Dreamweaver CS4, Coldfusion Builder, Eclipse 3.1, MS Visual SourceSafe, JIRA Bug & Issue Tracking
- Analyzed and resolved technical issues, ensuring consistent application performance and reliability.
- Led initiatives to streamline software development processes, increasing efficiency within the programming team.
- Developed and maintained applications supporting environmental data collection and reporting processes.
- Collaborated with cross-functional teams to enhance system functionalities for improved user experience.
- Provided ongoing support for users experiencing issues or requiring assistance with application functionality.
- Collaborated with cross-functional teams to ensure seamless integration of new features into existing applications.
- Improved systems with addition of new features and infrastructure.
- Updated documentation with project deviations to capture changes.
Programmer Analyst/ Web Application Developer
Public Works and Government Services Canada (PWGSC)
Gatineau, QC
07.2011 - 12.2011
- SELECT, a web-based system with bilingual functionality utilizing ColdFusion and Sybase 12, is a database of approved suppliers providing Construction, Architectural and Engineering services as well as related Maintenance and Consulting services. It is used by Public Works and Government Services Canada (PWGSC) to invite firms to bid on Real Property opportunities for Consulting up to $76,500 and Construction up to $100,000.
- Mr. Merritt assisted in the conversion of the SELECT web application for conformance to the Web Content Accessibility Guidelines (WCAG) 2.0 Level A and Level AA. This involved implementing changes to manual code, screen design, and database modifications. He utilized ColdFusion and Sybase 12, and he performed development using standards that are Government of Canada Common Look and Feel (CLF-2) Standards compliant utilizing Extensible Hyper Text Markup Language (XHTML), Cascading Style Sheets (CSS), and JavaScript compliant code.
- Wrote application code and maintained web application using ColdFusion 7 and Sybase RDBMS as backend.
- Performs SQL integration with web based content via ColdFusion utilizing Extensible Hyper Text Markup Language (XHTML), JavaScript and Cascading Style Sheets (CSS) compliant code.
- Performed modifications on Sybase database (RDBMS), including creating tables, indexes and foreign keys.
- Implemented a customer facing solution including enterprise backend integration.
- Utilized ColdFusion to produce web-based forms, manuals, programs, data files and procedures.
- Identified and analyzed issues identified by system analysts and designers. These included issues surrounding variety of items to be processed, extent of sorting, information transferred to and from storage units and issues surrounding format and style of final printed results.
- Reviewed and revised instructions and altered sequence of operations as required correcting program errors.
- Integrated content within the PWGSC Wrapper including menu and mapping modules and worked with the quality assurance team to implement this application.
- Environment: ColdFusion MX 6-8, ColdFusion FuseBox, Sybase, SQL, HTML/XHTML, CSS, JavaScript, XML, Government of Canada Common Look and Feel (CLF) 2.0 Standards, WCAG 2.0, Adobe Dreamweaver CS4, Subversion
- Facilitated knowledge transfer among team members by creating comprehensive technical documentation for developed solutions.
Education
Bachelor of Arts - Psychology
University of New Brunswick
01.1995
Skills
- HTML
- XHTML
- SQL
- CFML
- PHP
- ASPNET
- C#
- CSHTML/Razor
- XML
- JavaScript
- CSS
- CF/PHP FuseBox 2 - 56 MVC
- Oracle 8 - 19
- Oracle Toad/Oracle SQL
- Plus
- MS SQL Server 2000-2019
- MySQL
- Sybase
- MS Access 2000
- ColdFusion MX 7-2025
- UNIX
- LINUX
- MS Visual Studio
- MS Visual Studio Code
- Eclipse
- Sublime
- Dreamweaver
- MS VSS
- Tortoise Subversion SVN
- GIT
- Azure Dev Ops
- Information security
- Technical support
- API development
- Code review
- Data migration
- IT troubleshooting
- Programming
- Web application development
- Client communication
- Debugging code
- Application design
- Systems analysis
- Application database architecture
- Software development
- Web development
- Program development documentation
- Software deployment
- Source and version control: git, github
- Website development
- Debugging
- Documentation writing
- Report writing skills
Languages
English
Native or Bilingual
Certification
- Oracle Certified Professional - Internet Applications Developer
- Oracle Certified Professional - Application Developer
Security Clearance
Secret
Technical Summary
- HTML, XHTML, SQL, CFML, PHP (Beginner/Intermediate), ASP.NET (Beginner), C# (Beginner), CSHTML/Razor (Beginner), XML, JavaScript, CSS, CF/PHP FuseBox 2 - 5.6 MVC, Oracle 8 - 19, Oracle Toad/Oracle SQL
- Plus, MS SQL Server 2000-2019, MySQL, Sybase, MS Access 2000, ColdFusion MX 7-2025, UNIX / LINUX, MS Visual Studio, MS Visual Studio Code, Eclipse, Sublime, Dreamweaver, MS VSS, Tortoise Subversion SVN, GIT / Azure Dev Ops
Timeline
Programmer Analyst/ Web Application Developer
Environment Canada (ECCC)
06.2022 - 09.2025
Programmer Analyst/ Web Application Developer
Natural Resources Canada (NRCan)
09.2014 - 06.2022
Programmer Analyst/ Web Application Developer
Agriculture and Agri-Food Canada (AAFC)
09.2014 - 07.2017
Programmer Analyst/ Web Application Developer
Natural Resources Canada (NRCan)
08.2012 - 09.2014
Programmer Analyst/ Web Application Developer
Agriculture and Agri-Food Canada (AAFC)
01.2012 - 07.2012
Programmer Analyst/ Web Application Developer
Public Works and Government Services Canada (PWGSC)
07.2011 - 12.2011
Bachelor of Arts - Psychology
University of New Brunswick