Peter Merritt by pvIAdKk0

VIEWS: 0 PAGES: 25

									                                        Peter Merritt
                                       613.608.1154
                               peter.merritt@activoweb.com
                                http://www.activoweb.com



IT Related Experience          Over 12 years

Certification(s)               Oracle Certified Professional - Internet Applications Developer
                               Oracle Certified Professional - Application Developer

Security Clearance             Secret



PROFILE

Mr. Merritt is a web/database application developer with over 12 years of IT experience. Mr.
Merritt has focused his development experience primarily on ColdFusion, SQL, and Oracle as
well as the Fuse-Box site architecture methodology. He also has knowledge and experience in
developing and maintaining web applications using PHP and ASP.Net.

Mr. Merritt is experienced in all aspects of maintenance and development of web applications on
Relational Databases including coding, analysis, debugging, and documentation. He has the
ability to take initiative in analyzing the impact of any task given and is able to work
independently, and efficiently, but also within a collaborative team environment. He has the
ability to think on his feet, efficient in problem analysis and resolution. He has excellent
communication skills (verbal and written) and is effective in regard to interaction with team
members and clients.

Mr. Merritt has experience in development using standards that are Government of Canada
Common Look and Feel (CLF-2) compliant as well as developing and maintaining web
applications for conformance to the Web Content Accessibility Guidelines (WCAG) 2.0 Level A
and Level AA.

Mr. Merritt is security cleared to the Secret level.
PROFESSIONAL EXPERIENCE
Project # 1
Natural Resources Canada (NRCan)
Programmer Analyst/ Web Application Developer
July 2012 – Present

Project Description:

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.

Tasks Performed:

   Writes application code and maintains applications using ColdFusion and Oracle 10g.
   Develops and modifies manual code, screens, software and report changes using ColdFusion
    and Oracle 10 g.
   Performs SQL integration with web based content via ColdFusion utilizing Extensible Hyper
    Text Markup Language (XHTML), JavaScript and Cascading Style Sheets (CSS) compliant
    code.
   Utilized XML in the configuration of application configuration settings and retrieval of items
    within language repository files.
   Utilized ColdFusion to produce web-based forms, manuals, programs, data files and
    procedures.
   Performed application development, testing, troubleshooting and analysis for implementation
    of computer systems.
   Integrated content within the new WCAG 2.0 compliant wrapper including menu and
    mapping modules and worked with the quality assurance team to implement this application.
   Utilized sample data to implement testing and system acceptance testing which was
    performed by operating staff and personnel, also verified the accuracy and completeness of
    programs.

Environment: ColdFusion MX 8, ColdFusion FuseBox, ColdFusion MVC, ColdFusion CFC
components, Oracle 10g, 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, Tortoise Subversion, Redmine and Sharepoint Issue Tracking




2
PROFESSIONAL EXPERIENCE
Project # 2
Agriculture and Agri-Food Canada (AAFC)
Programmer Analyst/ Web Application Developer
January 2012– April 2012 (3 months)

Project Description:

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.

Tasks Performed:

   Writes application code and maintains applications using ColdFusion and Oracle 10g.
   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.
   Utilized XML in the configuration of application configuration settings and retrieval of items
    within language repository files.
   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.
   Utilized ColdFusion to produce web-based forms, manuals, programs, data files and
    procedures.
   Reviewed, selected and incorporated available software programs.
   Performed application development, testing, troubleshooting and analysis for implementation
    of computer systems.
   Identified and analyzed issues that were identified by system analysts and designers. These
    included issues surrounding variety of items to be processed, extent of sorting, information to
    be 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 new Agrisource Wrapper including menu and mapping modules
    and worked with the quality assurance team to implement this application.



3
   Utilized sample data to implement testing and system acceptance testing which was
    performed by operating staff and personnel, also verified the accuracy and completeness of
    programs.
   Installing and configuring (ColdFusion application server)


Environment: ColdFusion MX 6-8, ColdFusion FuseBox, ColdFusion CFC components,
Oracle 10g, 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



PROFESSIONAL EXPERIENCE
Project # 3
Public Works and Government Services Canada (PWGSC)
IT Services – Acquisitions (SELECT)
Programmer Analyst/ Web Application Developer
July 2011 – December 2011 (6 months)

Project Description:

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.

Tasks Performed:

   Writes application code and maintains applications using ColdFusion and Oracle 10g.
   Develops and modifies manual code, screens, software and report changes using ColdFusion
    and Sybase 12.
   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.

4
   Utilized ColdFusion to produce web-based forms, manuals, programs, data files and
    procedures.
   Utilized XML in the configuration of application configuration settings and retrieval of items
    within language repository files.
   Reviewed, selected and incorporated available software programs.
   Performed application development, testing, troubleshooting and analysis for implementation
    of computer systems as subsystems to larger ones.
   Identified and analyzed issues that were identified by system analysts and designers. These
    included issues surrounding variety of items to be processed, extent of sorting, information to
    be 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.
   Utilized sample data to implement testing and system acceptance testing which was
    performed by operating staff and personnel, also verified the accuracy and completeness of
    programs.
   Installing and configuring (ColdFusion application server)


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, Eclipse 3.1, Subversion




Project # 4
esportfolio.com
Programmer Analyst/ Web and Database Developer/ Database Administrator
January 2011 – May 2012 (1 year, 5 months)

Project Description:

Mr. Merritt performed and implemented new framework of the application to enable the system
to use a single sign on for both administrative and public users. This work required the re-design
and deployment of a mySQL database. He performed all database modifications including the
creation of tables, columns, assignment of primary keys and indexes. Mr. Merritt is also
responsible for the ongoing management of the website and database on a part time basis when
changes are required to reflect changing needs of the business model such as creating new tables
and columns or make changes to existing structures. Mr. Merritt previously performed the
migration from an MS Access database to MySQL. Integrated with third party external
assessment tool using ASP.Net


5
Tasks Performed:

   Provided business analysis.
   Compared and reviewed available software applications and incorporated programs
    according to client needs.
   Developed Use Cases and requirements documentation and participated in client
    consultations to develop design specifications.
   Designed, documented, and implemented data model changes.
   Used DeZign for Databases as the tool for database design and modeling to create and
    maintain new data model and providing entity relationship diagrams (ERDs, data models) to
    graphically design databases and provide for review to project leaders and business analysts..
   Performed database modifications, including the creation of tables, columns, assignment of
    primary and indexes.
   Utilized XML in the configuration of application configuration.
   Developed naming conventions for database tables and columns.
   Prepared briefing materials and presentation documentation for project manager and other
    senior management personnel.
   Reviewed and revised instructions and altered sequence of operations as required correcting
    program errors
   Wrote application code and maintaining application.
   Performed SQL integration with web based content via ColdFusion using the FuseBox 5.5
    MVC framework.
   Performed application testing, troubleshooting and analysis.
   Installing and configuring (ColdFusion application server)

Environment: ColdFusion 7- 9, Fusebox 5.5 MVC, ColdFusion CFC components, MySQL,
MySQL Administaror, MySQL Query Browser, Quest Toad for MySQL, Dezign For Databases,
HTML, CSS, JavaScript, XML, MS Windows XP/Vista, MS Word, MS Excel, Eclipse 3.1,
Adobe Dreamweaver CS4/CS5, ASP.Net 3-4, Cshtml/Razor, Corel Photo Paint, Paint Shop Pro,
FTP, Tortoise Subversion



Project # 5

Agriculture and Agri-Food Canada (AAFC)
Minor Use Pesticides Program System (MUPPS)
Programmer Analyst/ Web Application Developer
January 2010 – May 2011 (1 year, 4 months)

Project Description:

Mr. Merritt was involved in the full software development lifecycle of the Minor Use Pesticides
Program System (MUPPS) application. MUPPS is a web-based system with bilingual
functionality utilizing ColdFusion and Oracle 10g. The code utilized the FuseBox framework
with ColdFusion CFC components and Data Access Objects. Mr. Merritt implemented the
6
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.

Tasks Performed:

   Utilized computer systems of significant size and complexity to create and prepare
    diagrammatic solution plans for technical, business and scientific problems.
   Reviewed Use Cases, requirements and client consultations to develop design specifications
    for the reporting module.
   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.
   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.
   Utilized ColdFusion tools to develop, test, produce, implement and maintain web-based
    forms, manuals, programs, data files and procedures of computer systems and sub-systems of
    larger ones.
   Utilized XML in the configuration of application configuration settings and retrieval of items
    within language repository files.
   Performed application testing, troubleshooting, and analysis using the ColdFusion
    application development tools.
   Liaised with system analysts and designers to identify, review and analyze problems
    associated with style, format of final printed results, information to be transferred to and from
    storage units, items to be processed and the extent of sorting.
   Developed functional and systems specifications for ColdFusion and Oracle 10g
    applications.
   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 10g Database Server and performed modifications to
    the database including creating tables, foreign keys and indexes.
   Implemented customer facing solutions including enterprise backend integrations.
   Worked with the quality assurance team to implement this application into the Oracle 10g
    database.
   Implemented user acceptance testing which was performed by operations personnel and staff,
    verified the completeness and accuracy of programs by reviewing and preparing sample data.
   Performed instruction testing and gathered specifications, layouts, diagrams, flow charts,
    operating and programming instructions and performed application documentation for future
    reference or modification.

7
   Installing and configuring (ColdFusion application server)


Environment: ColdFusion MX 6.1//7, ColdFusion FuseBox, ColdFusion CFC components,
Oracle 10g, 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.1, MS Visual SourceSafe, JIRA Bug &
Issue Tracking


Project # 6
Public Works and Government Services Canada (PWGSC)
IT Services – Acquisitions (SELECT)
Programmer Analyst/ Web Application Developer
June 2009 – December 2009 (7 months)


Project Description:

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 from CLF-1 to CLF-2
standards as well as migration of the website from a Fusebox 1 to Fusebox 3 architecture. This
involved implementing the Fusebox methodology and fuses, 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)

Tasks Performed:

   Writes application code and maintains applications using ColdFusion and Sybase.
   Develops and modifies manual code, screens, software and report changes using ColdFusion
    and Sybase.
   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.
   Utilized ColdFusion to produce web-based forms, manuals, programs, data files and
    procedures.

8
   Reviewed, selected and incorporated available software programs.
   Performed application development, testing, troubleshooting and analysis for implementation
    of computer systems as subsystems to larger ones.
   Identified and analyzed issues that were identified by system analysts and designers. These
    included issues surrounding variety of items to be processed, extent of sorting, information to
    be 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.
   Utilized XML in the configuration of application configuration settings and retrieval of items
    within language repository files.
   Integrated content within the PWGSC Wrapper including menu and mapping modules and
    worked with the quality assurance team to implement this application.
   Utilized sample data to implement testing and system acceptance testing which was
    performed by operating staff and personnel, also verified the accuracy and completeness of
    programs.
   Installing and configuring (ColdFusion application server)


Environment: ColdFusion MX 6/7, ColdFusion FuseBox, ColdFusion CFC components,
Sybase 12, Unicenter DBA, 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, Adobe Dreamweaver CS4/, Tortoise Subversion




Project # 7
Agriculture and Agri-Food Canada (AAFC)
Advancing Canadian Agriculture and Agri-Food Program (ACAAF)
Programmer Analyst/ Web Application Developer
November 2008 – April 2009 (6 months)

Project Description:

Mr. Merritt designed a module that provided enhanced communication capabilities for the
ACAAF application, a web-based system utilizing ColdFusion and Oracle 10g. The solution
involved providing the client with the capability to send a reminder and monthly reports to the
program’s data suppliers and executive directors. He created a scheduled task management
system to allow the client the ability to run these processes at the desired frequency.

This involved developing functional and system design specifications with bilingual
functionality, implementing the Fusebox methodology and fuses, manual code, screen design,
and database modifications. Mr. Merritt developed using standards followed the Government of
Canada Common Look and Feel (CLF-2) Standards while utilizing Extensible Hyper Text

9
Markup Language (XHTML) and Cascading Style Sheets (CSS) compliant code. The code
utilized the FuseBox framework with ColdFusion CFC components and Data Access Objects.

Tasks Performed:

    Developed Use Cases and requirements documentation, led client consultations to develop
     design specifications for the reporting module and developed functional and systems
     specifications for ColdFusion and Oracle 10g.
    Interpreted Use Cases and UML diagrams in the integration of Cognos ReportNet
     development and the secure channel (esass/epass).
    Created and developed diagrammatic solution plans for technical problems utilizing
     computer systems of significant size and complexity.
    Prepared briefing materials and presentation documentation for project manager and other
     senior management personnel.
    Wrote application code and maintained applications.
    Developed and modified the Oracle 10g database.
    Developed and modified manual code, software, screens and report changes with ColdFusion
     and Oracle 10g.
    Utilized XML in the configuration of application configuration settings and retrieval of items
     within language repository files.
    Worked with a team to develop applications using ColdFusion and Oracle 10g by creating
     and integrating Use Cases and UML diagrams.
    Liaised with system analysts and designers to identify, review and analyze problems
     associated with style, format of final printed results, information to be transferred to and from
     storage units, items to be processed and the extent of sorting.
    Performed database modifications including developing stored procedures, creating tables,
     indexes and foreign keys in an Oracle 10g database server.
    Developed SQL/PL/SQL scripts for the conversion of existing data.
    Delivered applications after retrieving information required with SQL and related packages
     for ColdFusion and Oracle 10g.
    Integrated content within the AAFC Wrapper including menu and mapping modules.
    Compared and reviewed available software applications and incorporated programs
     according to client needs.
    Performed SQL integration with web based content via ColdFusion utilizing Extensible
     Hyper Text Markup Language (XHTML) and Cascading Style Sheets (CSS) compliant code.
    Implemented customer facing solutions including enterprise backend integration.
    Utilized ColdFusion tools to develop, test, produce, implement and maintain web-based
     forms, manuals, programs, data files and procedures of computer systems and sub-systems of
     larger ones.
    Performed application testing, troubleshooting and analysis.
    Utilized sample data to implement testing and system acceptance testing which was
     performed by operating staff and personnel, also verified the accuracy and completeness of
     programs.
    Worked with the quality assurance team to implement this application.


10
    Performed instruction testing and gathered specifications, layouts, diagrams, flow charts,
     operating and programming instructions and performed application documentation for future
     reference or modification.
    Installing and configuring (ColdFusion application server)

Environment: ColdFusion MX 6.1/7, ColdFusion FuseBox, ColdFusion CFC components,
Oracle 10g, 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, Eclipse 3.1, MS Visual SourceSafe, Secure Channel/epass




Project # 8
Agriculture and Agri-Food Canada (AAFC)
Functional Foods and Natural Health Products Database (FFN)
Web Application Developer
June 2008 – December 2008 (7 months)

Project Description:

Mr. Merritt designed and implemented enhancements for the FFN application, a web-based
system with bilingual functionality utilizing ColdFusion and Oracle 10g. Mr. Merritt performed
development using standards that were Government of Canada Common Look and Feel (CLF-2)
Standards compliant utilizing Extensible Hyper Text Markup Language (XHTML) and
Cascading Style Sheets (CSS) compliant code.

Tasks Performed:

    Created and developed diagrammatic solution plans for technical problems utilizing
     significant size and complexity computer systems.
    Developed Use Cases and requirements documentation and performed client consultations to
     develop all design specifications for the enhancements change request.
    Wrote application code and developed functional and systems specifications.
    Developed and modified manual code, screens, and software and report changes.
    Performed development as part of a team to deliver applications by creating and interpreting
     Use Cases and UML diagrams.
    Reviewed and revised instructions and altered sequence of operations as required correcting
     program errors
    Performed stored procedure development.
    Developed SQL/PL/SQL scripts for the conversion of existing data.
    Liaised with system analysts and designers to identify, review and analyze problems
     associated with style, format of final printed results, information to be transferred to and from
     storage units, items to be processed and the extent of sorting.



11
    Responsible for SQL integration with web based content via ColdFusion while utilizing
     Extensible Hyper Text Markup Language (XHTML) and Cascading Style Sheets (CSS)
     compliant code.
    Used ColdFusion to produce web-based forms, manuals, programs, data files and procedures.
    Compared and reviewed available software applications and incorporated programs
     according to client needs.
    Utilized XML in the configuration of application configuration settings and retrieval of items
     within language repository files.
    Assembled specifications, diagrams, layouts, flow charts, operating and programming
     instructions, and tested instructions to document applications for later modification or
     reference.
    Implemented customer facing solutions including enterprise backend integrations.
    Performed application troubleshooting and analysis.
    Worked with the quality assurance team to implement this application.
    Developed, tested and provided maintenance for the application.
    Installing and configuring (ColdFusion application server)

Environment: ColdFusion MX 6.1/7, ColdFusion FuseBox, ColdFusion CFC components,
Oracle 10g, 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, Eclipse 3.1, MS Visual SourceSafe.



Project # 9
Agriculture and Agri-Food Canada (AAFC)
Private Sector Risk Management Partnerships (PSRMP)
Web Application Developer
September 2008 - October 2008 (2 months)

Project Description:

Mr. Merritt implemented the GoC Common Look and Feel (CLF 2) requirements for the existing
PSRMP application. PSRMP is a web-based system with bilingual functionality utilizing
ColdFusion and Oracle 10g. Mr. Merritt performed the development using standards that were
Government of Canada Common Look and Feel (CLF-2) Standards compliant while utilizing
Extensible Hyper Text Markup Language (XHTML) and Cascading Style Sheets (CSS)
compliant code.

Tasks Performed:

    Reviewed GOC CLF-2 documentation.
    Created and developed diagrammatic solution plans for technical problems utilizing
     significant size and complexity computer systems.



12
  Wrote application code and was responsible for SQL integration with web based content via
   ColdFusion utilizing Extensible Hyper Text Markup Language (XHTML) and Cascading
   Style Sheets (CSS) compliant code.
 Developed functional and systems specifications and developed manual code, screens and
   report changes.
 Compared and reviewed available software applications and incorporated programs
   according to client needs.
 Developed as part of a team to deliver applications by interpreting Use Cases and UML
   diagrams.
 Utilized XML in the configuration of application configuration settings and retrieval of items
   within language repository files.
 Performed stored procedure development.
 Performed application troubleshooting and analysis.
 Worked with the quality assurance team to implement this application.
 Developed, tested and provided maintenance for the application.
 Used ColdFusion to produce web-based forms, manuals, programs, data files and procedures.
 Assembled specifications, diagrams, layouts, flow charts, operating and programming
   instructions, and tested instructions to document applications for later modification or
   reference.
 Installing and configuring (ColdFusion application server)
Environment: ColdFusion MX 6.1/7, ColdFusion FuseBox, ColdFusion CFC components,
Oracle 10g, 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.1, MS Visual SourceSafe.


Project # 10
Agriculture and Agri-Food Canada (AAFC)
Animal Industry Market Information System (AIMIS)
Programmer Analyst/ Web Application Developer
April 2008 – September 2008 (6 months)


Project Description:

Mr. Merritt designed a module that integrated the Enterprise Secure Access Service (ESAS)
system that provides authentication services to both internal and external Agriculture and Agri-
Food Canada (AAFC) users. Mr. Merritt enabled the AIMIS system to integrate with the secure
Channel - ESAS/epass process to provide a secure access method with a single, secure online
portal. Code utilized the FuseBox framework with ColdFusion CFC components and Data
Access Objects with bilingual functionality.

Tasks Performed:

    Reviewed Use Cases, requirements and client consultations to develop design specifications
     for the reporting module.

13
    Used ColdFusion to produce web-based forms, manuals, programs, data files and procedures
     for the application.
    Created and developed diagrammatic solution plans for technical problems utilizing
     significant size and complexity computer systems.
    Retrieved information using SQL in the development and delivery of applications to the
     client for ColdFusion and Oracle 10g.
    Integrated the application with Secure Channel (epass) and wrote application code and
     maintained application.
    Compared and reviewed available software applications and incorporated programs
     according to client needs.
    Performed SQL integration with web based content via ColdFusion utilizing Extensible
     Hyper Text Markup Language (XHTML) and Cascading Style Sheets (CSS) compliant code.
    Utilized ColdFusion applications and development tools with an Oracle 10g database to
     develop and deliver applications.
    Utilized XML in the configuration of application configuration settings and retrieval of items
     within language repository files.
    Reviewed and revised instructions and altered sequence of operations as required correcting
     program errors
    Developed functional and systems specifications including methods and procedures for small
     computer systems/subsystems of larger ones for ColdFusion and Oracle 10g.
    Utilized ColdFusion and Oracle 10g to develop and modify manual code, screens, software
     and report changes.
    Performed Functional testing for the application.
    Utilized ColdFusion with Oracle 10g to develop applications in a team environment by
     interpreting Use Cases and UML diagrams.
    Implemented customer facing solutions including enterprise backend integrations.
    Performed application testing, troubleshooting and analysis.
    Worked with the quality assurance team to implement this application.
    Documented applications for modification and reference by assembling diagrams, flow
     charts, specifications, operating and programming instructions and performed instruction
     testing.
    Installing and configuring (ColdFusion application server)


Environment: ColdFusion MX 6.1/7, ColdFusion FuseBox, ColdFusion CFC components,
Oracle 10g, TOAD, HTML, CSS, JavaScript, XML,XHTML, Secure Channel/epass,
Government of Canada Common Look and Feel (CLF) 2.0 Standards, Linux and HP Unix
Servers, SQL, Eclipse 3.1, MS Visual SourceSafe, MS Windows XP, MS Word, MS Excel.




14
Project # 11
Agriculture and Agri-Food Canada (AAFC)
Functional Foods and Natural Health Products Database (FFN)
Web Application Developer
May 2008 – June 2008 (2 months)

Project Description:

Mr. Merritt implemented the GOC Common Look and Feel (CLF 2) requirements for the
existing FFN application. FFN is a web-based system with bilingual functionality utilizing
ColdFusion and Oracle 10g. Mr. Merritt developed using standards that were Government of
Canada Common Look and Feel (CLF-2) Standards compliant while utilizing Extensible Hyper
Text Markup Language (XHTML) and Cascading Style Sheets (CSS) compliant code.

Tasks Performed:

    Reviewed GOC CLF-2 documentation and wrote application code and maintained the
     application.
    Performed SQL integration with web based content via ColdFusion utilizing Extensible
     Hyper Text Markup Language (XHTML) and Cascading Style Sheets (CSS) compliant code.
    Used ColdFusion to produce web-based forms, manuals, programs, data files and procedures.
    Performed stored procedure development.
    Developed and maintained manual code, screens and report changes.
    Performed application troubleshooting and analysis.
    Developed functional and systems specifications.
    Developed manual code, screens and report changes.
    Developed as part of a team to deliver applications by interpreting Use Cases and UML
     diagrams.
    Utilized XML in the configuration of application configuration settings and retrieval of items
     within language repository files.
    Worked with the quality assurance team to implement this application.
    Performed Functional testing for the application.
    Documented applications for modification and reference by assembling diagrams, flow
     charts, specifications, operating and programming instructions and performed instruction
     testing.
    Installing and configuring (ColdFusion application server)


Environment: ColdFusion MX 6.1/7, ColdFusion FuseBox, ColdFusion CFC components,
Oracle 10g, 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.1, MS Visual SourceSafe.



Project # 12
15
Agriculture and Agri-Food Canada (AAFC)
Minor Use Pesticides Program System (MUPPS)
Programmer Analyst/ Web Application Developer
November 2006 – April 2008 (1 year, 6 months)

Project Description:

Mr. Merritt was involved in the full software development lifecycle of the MUPPS application.
MUPPS is a web-based system with bilingual functionality utilizing ColdFusion and Oracle 10g.
The code utilized the FuseBox framework with ColdFusion CFC components and Data Access
Objects. Mr. Merritt implemented the Common Look and Feel (CLF-1 & CLF-2) requirements
in various application websites including the most recent version of the guidelines.

Tasks Performed:

    Reviewed Use Cases, requirements and client consultations to develop design specifications
     for the reporting module.
    Created, wrote and modified application code, screens and reports, and maintained the
     application.
    Performed SQL integration with web based content via ColdFusion and the FuseBox
     framework with ColdFusion CFC components and Data Access Objects.
    Analyzed flow charts into technical and coded instructions and met with technical staff to
     discuss program planning.
    Used ColdFusion to produce web-based forms, manuals, programs, data files and procedures.
    Compared and reviewed available software applications and incorporated programs
     according to client needs.
    Designed, developed, created, tested, implemented, maintained, and modified MUPPS
     application code and software of both small systems and subsystems of larger systems using
     ColdFusion application development tools.
    Developed functional and systems specifications.
    Reviewed and revised instructions and altered sequence of operations as required correcting
     program errors.
    Utilized XML in the configuration of application configuration settings and retrieval of items
     within language repository files.
    Developed as part of a team to deliver applications by creating and interpreting Use Cases
     and UML diagrams.
    Developed stored procedures for Oracle 10g Database Server and performed modifications to
     the database including creating tables, foreign keys and indexes.
    Implemented customer facing solutions including enterprise backend integrations.
    Performed application testing troubleshooting and analysis.
    Worked with the quality assurance team to implement this application.
    Documented applications for modification and reference by assembling diagrams, flow
     charts, specifications, operating and programming instructions and performed instruction
     testing.
    Installing and configuring (ColdFusion application server)

16
Environment: ColdFusion MX 6.1, ColdFusion FuseBox, ColdFusion CFC components,
Oracle 10g, 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.1, MS Visual SourceSafe.




Project # 13
Agriculture and Agri-Food Canada (AAFC)
Functional Foods and Natural Health Products Database (FFN)
Programmer Analyst/ Web Application Developer
July 2006 – October 2006 (4 months)

Project Description:

Mr. Merritt was involved in the migration of an MS Access web application with bilingual
functionality into an Oracle 9i database. Assisted in the data conversion process and modified
SQL and ColdFusion code to be functional using the Oracle backend. Mr. Merritt developed
using standards that are Government of Canada Common Look and Feel (CLF) Standards
compliant.

Tasks Performed:

    Reviewed Use Cases, requirements and client consultations to develop design specifications
     for the reporting module.
    Responsible for the creation and modification of all codes, software and reports and screens.
    Responsible for the development, testing and implementation of the computer system as a
     sub-system to a larger system.
    Compared and reviewed available software applications and incorporated programs
     according to client needs.
    Used ColdFusion to produce web-based forms, manuals, programs, data files and procedures.
    Performed Oracle - PL/SQL integration with web based content via ColdFusion.
    Responsible for performing database modifications, including creating tables, indexes and
     foreign keys.
    Implemented customer facing solutions including enterprise backend integrations.
    Produced all forms, programs, data files, manuals and procedures for the system.
    Developed functional and systems specifications.
    Developed as part of a team to deliver applications by creating and interpreting Use Cases
     and UML diagrams.
    Performed application testing, troubleshooting and analysis.
    Compared and reviewed available software applications and incorporated programs
     according to client needs.
    Utilized XML in the configuration of application configuration settings and retrieval of items
     within language repository files.
17
    Worked with the quality assurance team to implement this application.
    Installing and configuring (ColdFusion application server)

Environment: ColdFusion MX 6.1, ColdFusion FuseBox, ColdFusion CFC components,
Oracle 10g, TOAD, HTML, CSS, JavaScript, XML,XHTML, Government of Canada Common
Look and Feel (CLF) 1.0 Standards, MS Windows XP, MS Word, MS Excel, Linux and HP
Unix Servers, AAFC/Agrisource Wrapper, Eclipse 3.1, MS Visual SourceSafe.




Project # 14
Agriculture and Agri-Food Canada (AAFC)
Canadian Farm Business Advisory Service (CFBAS)
Web Application Developer
May 2006 – June 2006 (2 months)

Project Description:

Mr. Merritt participated in the data conversion process of the CFBAS application database
(Oracle 9i). He designed the data model revisions and wrote SQL and PL/SQL code to provide to
the DBA group in the implementation of data model changes. Mr. Merritt developed PL/SQL
procedures to convert data according to established business rules. Mr. Merritt was also involved
in ColdFusion code development in the integration of the new data elements.

Tasks Performed:

    Reviewed Use Cases, requirements and client consultations to develop design specifications.
    Participated in the data conversion process.
    Used ColdFusion to produce web-based forms, manuals, programs, data files and procedures
     with bilingual functionality.
    Designed, documented, and implemented data model changes.
    Responsible for PL/SQL Stored procedure development.
    Performed database modifications, including creation of tables.
    Wrote application code, software, screens, reports and maintained application.
    Responsible for SQL integration with web based content via ColdFusion.
    Implemented customer facing solutions including enterprise backend integrations.
    Developed functional and systems specifications, and designed methods and procedures to be
     followed as a sub-system to larger systems.
    Developed as part of a team to deliver applications by creating and interpreting Use Cases
     and UML diagrams.
    Utilized XML in the configuration of application configuration settings and retrieval of items
     within language repository files.
    Developed, tested and implemented the computer system as a sub-system to a larger one.


18
    Performed application testing, troubleshooting and analysis.
    Worked with the quality assurance team to implement this application.
    Installing and configuring (ColdFusion application server)

Environment: ColdFusion MX 6.1, ColdFusion FuseBox, ColdFusion CFC components,
Oracle 10g, TOAD, HTML, CSS, JavaScript, XML,XHTML, Government of Canada Common
Look and Feel (CLF) 1.0 Standards, MS Windows XP, MS Word, MS Excel, Linux and HP
Unix Servers, AAFC/Agrisource Wrapper, Eclipse 3.1, MS Visual SourceSafe.



Project # 15
Agriculture and Agri-Food Canada (AAFC)
Advancing Canadian Agriculture and Agri-Food Program (ACAAF)
Programmer Analyst/ Web Application Developer
March 2006 – June 2006 (4 months)


Project Description:

Mr. Merritt designed a module that provided data import capabilities for the ACAAF application,
a web-based system utilizing ColdFusion and Oracle 10g. The solution involved providing the
client with the capability to import large spreadsheet data delivered from their stakeholders into
their Oracle database. The code utilized the FuseBox framework with ColdFusion CFC
components. This involved developing functional and system design specifications with
bilingual functionality, manual code, screen design, and database modifications. He developed
using standards that are Government of Canada Common Look and Feel (CLF) Standards
compliant.

Tasks Performed:

    Reviewed Use Cases, requirements and client consultations to develop design specifications
     for the application.
    Wrote application code and maintained application.
    Responsible for SQL integration with web based content via ColdFusion.
    Implemented customer facing solutions including enterprise backend integrations.
    Stored procedure development.
    Responsible for the creation and modification of all codes, software and reports and screens.
    Compared and reviewed available software applications and incorporated programs
     according to client needs.
    Used ColdFusion to produce web-based forms, manuals, programs, data files and procedures
     for the application.
    Reviewed and revised instructions and altered sequence of operations as required correcting
     program errors
    Utilized XML in the configuration of application configuration settings and retrieval of items
     within language repository files.

19
    Developed manual code, screens, software and reported changes.
    Responsible for database design and modifications, including creation of tables, columns,
     assignment of primary and foreign keys and indexes.
    Performed application testing, troubleshooting and analysis.
    Worked with the quality assurance team to implement this application.
    Installing and configuring (ColdFusion application server)

Environment: ColdFusion MX 6.1, ColdFusion FuseBox, ColdFusion CFC components,
Oracle 10g, TOAD, HTML, CSS, JavaScript, XML,XHTML, Government of Canada Common
Look and Feel (CLF) 1.0 Standards, MS Windows XP, MS Word, MS Excel, Linux and HP
Unix Servers, AAFC/Agrisource Wrapper, Eclipse 3.1, MS Visual SourceSafe.



Project # 16
ILS Canada (Independent Learning Systems)
Programmer Analyst/ Web/Database Developer
June 2005 – December 2005 (7 months)

Project Description:

Mr. Merritt developed a business office management tool with bilingual functionality for Nissan
dealerships within Canada. This tool included such features as inventory management, vehicle
price maintenance, staff schedule and office tracker which maintained information in regard to
vehicle sales, deliveries, customer follow ups, dealership events and personal appointments. Mr.
Merritt integrated data feeds from Nissan Finance to create web viewable sales and leasing
contracts in both HTML and PDF formats.

Tasks Performed:

    Provided business analysis, created and modified all codes, software, reports and screens for
     the application.
    Responsible for effective and frequent client interaction.
    Performed SQL integration with web based content via ColdFusion.
    Compared and reviewed available software applications and incorporated programs
     according to client needs.
    Performed stored procedure development after designing procedures and methods to follow
     in the system for larger systems and applications.
    Developed functional and systems specifications.
    Performed database modifications, including creation of tables, columns, assignment of
     primary and foreign keys and indexes.
    Liaised with system analysts and designers to identify, review and analyze problems
     associated with style, format of final printed results, information to be transferred to and from
     storage units, items to be processed and the extent of sorting.
    Maintained both development and production web and database environments.
    Developed using Cascading Style Sheets (CSS).
20
    Produced all forms, programs, data files, manuals and procedures for the system.
    Performed application testing, troubleshooting and analysis.
    Installing and configuring (ColdFusion application server)

Environment: ColdFusion MX 7, MS SQL Server 2000, HTML, SQL, CFML, CSS,
JavaScript, Dreamweaver MX, Windows 2003, FTP.




Project # 17
CEP-Consulting
esportfolio.com
Programmer Analyst/ Web/ Database Developer/ Database Administrator
July 2001 – December 2010 (8 years, 5 months)

Project Description:

Mr. Merritt created and maintained an essential skills assessment and planning tool that helped
people prepare for entry-level occupations. Planned, designed, documented, developed and tested
the application. Mr. Merritt was also responsible for the ongoing management of website and
database. In 2006 he performed the migration from a MS Access to MySQL database. His
responsibilities also included the coordination and integration of 3rd-party application software.
In 2007 he created an administration module utilizing the Fusebox 5.5 MVC framework
integrating with the existing database.

Tasks Performed:

    Provided business analysis.
    Compared and reviewed available software applications and incorporated programs
     according to client needs.
    Developed Use Cases and requirements documentation and participated in client
     consultations to develop design specifications.
    Database modifications, including creation of tables, columns, assignment of primary and
     indexes.
    Used DeZign for Databases as the tool for database design and modeling to create and
     maintain new data model and providing entity relationship diagrams (ERDs, data models) to
     graphically design databases and provide for review to project leaders and business analysts..
    Utilized XML in the configuration of application configuration settings.
    Prepared briefing materials and presentation documentation for project manager and other
     senior management personnel.
    Reviewed and revised instructions and altered sequence of operations as required correcting
     program errors
    Wrote application code and maintaining application.
    Performed SQL integration with web based content via ColdFusion.
    Performed application testing, troubleshooting and analysis.
21
    Installing and configuring (ColdFusion application server)

Environment: ColdFusion MX 7/8, Fusebox 3, Fusebox 5.5 MVC, ColdFusion CFC
components, PHP, MySQL, MySQL Administaror, MySQL Query Browser, Quest Toad for
MySQL, DeZign for Databases, HTML, CSS, JavaScript, XML, MS Windows XP/Vista, MS
Word, MS Excel, Adobe Dreamweaver CS4, Tortoise Subversion




Project # 18
Government of New Brunswick
TeleCampus
Internet Services Manager/ Database Administrator/Web/Database Developer/
Programmer Analyst
May 2001 - May 2004 (3 years, 1 month)


Project Description:

Mr. Merritt was the lead web developer in a federal project involving the development of a
repository of learning objects according to strict metadata standards involving the integration of
XML, and ColdFusion application technologies. As the internet Services Manager, he was
responsible for the development and administration of various databases and bilingual websites
for the Department of Education written in ColdFusion and PHP. Mr. Merritt developed and
administered Oracle Databases, ColdFusion, Win 2000, Win NT, UNIX, and Linux.

Tasks Performed:

    Performed the administration of an online registration system used by community colleges
     within New Brunswick.
    Developed functional and systems specifications, designed methods and procedures to follow
     within the system, for larger subsystem applications.
    Developed as part of a team to deliver applications by creating and interpreting Use Cases
     and UML diagrams.
    Responsible for the development, testing and implementation of the computer system.
    Developed the E-Learning newsletter for New Brunswick and its e-learning industry leaders.
     An element of this position included working with and assisting other agencies and
     consortiums by developing components for their websites to enable them to utilize the
     department's database of online educational information.
    Responsible for the creation and modification of all reports, screens, codes and software
     throughout the project.
    Communicated with various stakeholders from business and technical backgrounds through
     presentations, meetings and discussions.


22
    Developed repository of learning resource feeds using XML to serve the data as an RSS feed
     to educational groups within Canada.
    Developed a data import module collecting data from external RSS feeds into an Oracle
     database.
    Performed SQL integration with web based content via ColdFusion.
    Performed application testing, troubleshooting and analysis.
    Performed database backup and recovery procedures.
    Managed Oracle 8i database.
    Database modifications, including creation of tables, columns, assignment of primary and
     foreign keys and indexes.
    Designed the layout of the website and provided image editing and optimization services.
    Installing and configuring (ColdFusion application server)

Environment: ColdFusion 5 & MX 6.1, PHP, Oracle 8, 8i, 9, 9i, Oracle SQL *Plus, Oracle
DBA Studio, ColdFusion Studio, DreamWeaver MX, HTML, SQL, CFML, XML, CSS,
JavaScript, Unix, SUN Solaris, FuseBox, FTP




Project # 19
Government of New Brunswick, Canada
Programmer Analyst/ Web/ Database Developer
March 2000 – April 2001 (1 year, 2 months)


Project Description:

Mr. Merritt designed and developed an Oracle database utilizing ColdFusion programming to
provide its web-based connectivity and interface. He was also involved in the development of a
web site for distance education and online learning resources with bilingual functionality.
Developed and maintained online resources catalogue using PHP

Tasks Performed:

    Communicated with various stakeholders from business and technical backgrounds through
     presentations, meetings and discussions. Developed functional and systems specifications.
    Developed as part of a team to deliver applications by creating and interpreting Use Cases
     and UML diagrams.
    Created, modified, and reported on codes, software and screens.
    Prepared briefing materials and presentation documentation for the project manager and
     other senior management personnel.
    Wrote application code, performed application maintenance and designed the methods and
     procedures within the project to be utilized as the sub-system for larger applications.
    Performed SQL integration with web based content via ColdFusion.
23
    Performed database modifications, including creation of tables, columns, assignment of
     primary and foreign keys and indexes.
    Performed application testing, troubleshooting and analysis.
    Produced all forms, programs, data files, and manuals for the system.
    Designed the layout of the website and provided image editing and optimization services.
    Installing and configuring (ColdFusion application server)

Environment: ColdFusion 4,5 & MX 6.1, PHP, Oracle 8, 8i, 9, 9i, Oracle SQL *Plus, Oracle
DBA Studio, ColdFusion Studio, DreamWeaver MX, HTML, SQL, CFML, XML, CSS,
JavaScript, Unix, SUN Solaris, FuseBox, FTP, Corel Photo Paint, Paint Shop Pro.



TECHNICAL SUMMARY

Languages/Methodologies                             Dreamweaver
HTML                                                Adobe Dreamweaver CS4-5
XHTML                                               ColdFusion Studio
SQL                                                 HomeSite
CFML                                                MS VSS
PHP                                                 Tortoise Subversion SVN
ASP.NET
C#
CSHTML/Razor
XML
JavaScript
CSS
CF/PHP FuseBox 2 - 5.6 MVC


DB/Application/OS Software
Oracle 8, 8i, 9, 9i, 10g
Oracle Toad/Oracle SQL *Plus
MS SQL Server 2000
MySQL
Sybase
MS Access 2000
ColdFusion MX 7-9
ASP.NET
WinNT 4, 2000, XP
UNIX / LINUX
Apple Mac - OS

Tools /Methodologies
MS Visual Web Developer
Eclipse

24
EDUCATION

Bachelor of Business Administration, E-Commerce (1998)
University of New Brunswick, Saint John Campus

Bachelor of Arts, Psychology (1995)
University of New Brunswick, Saint John Campus


CERTIFICATIONS

Oracle Certified Professional - Internet Applications Developer
Oracle Certified Professional - Application Developer




25

								
To top