Peter Merritt - Skills

rungabbyInternet and Web Development

Nov 10, 2013 (3 years and 8 months ago)

360 views



Peter Merritt


613.608.1154

peter.merritt@activoweb.com

http://www.activoweb.com




IT Related Experience

Over 12 years



Certification(s)


Oracle Certified Profess
ional
-

Internet Applications Developer

Oracle Certified Professional
-

Application Developer



Security Clearance


Secret




PROFILE


Mr. Merritt is a web/database application developer with over 1
2

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 i
n 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
independe
ntly, 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 interac
tion 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 Ac
cessibility Guidelines (WCAG) 2.0 Level A
and Level AA.


Mr. Merritt is security cleared to the
Secret level
.


2


PROFESSIONAL EXPERIENCE

Project # 1


Natural Resources Canada

(
NRCan
)

Programmer Analyst/ Web Application Developer

July

201
2



Present



Project Description
:


Mr. Merritt assisted in the conversion of
various
web application
s

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, softwar
e and report changes using Cold
Fusion

and Oracle 10 g.



Performs SQL integ
ration 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 item
s
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

w
rapper 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 o
perating 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









3


PROFESSIONAL EXPERIENCE

Project # 2


Agriculture and Agri
-
Food Canada (AAFC)

Programmer Analy
st/ 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 util
izing 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, scr
eens, 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 inte
gration 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 ite
ms
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.



Utili
zed 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 comput
er 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 sur
rounding 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 worke
d

with the quality assurance team to implement this application.


4




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.




Instal
ling 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 Applica
tion 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 Engineeri
ng
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 u
tilized
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 JavaScr
ipt 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 w
ith 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.


5




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 system
s 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 modul
es 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
progr
ams.




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 Dreamweave
r 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 applic
ation 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 datab
ase 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 ma
ke 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




6


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 m
odel 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 lead
ers and business analysts.
.



Performed d
atabase 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 an
d 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 Fuse
B
ox 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
Col
dFusion

and Oracle 10g. The code utilized the FuseBox framework
with
ColdFusion

CFC components and Data Access Objects. Mr. Merritt implemented the

7


Common Look and Feel (CLF
-
1 and CLF
-
2) requirements in various application websites
including the most recen
t 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 FuseBo
x 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 wit
h 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 Ser
ver 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 speci
fications, layouts, diagrams, flow charts,
operating and programming instructions and performed application documentation for future
reference or modification.



8




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, L
inux and HP
Unix Servers, AAFC/Agrisource
Wrapper, Eclips
e 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:


S
ELECT, 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, an
d 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 incl
uding enterprise backend integration.



Utilized
ColdFusion

to produce web
-
based forms, manuals, programs, data files and
procedures.


9




Reviewed, selected and incorporated available software programs.



Performed application development, testing, troubleshootin
g 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 conf
iguration 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)



Environm
ent
:
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 mon
thly 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 sp
ecifications

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) Standard
s while utilizing Extensible Hyper Text

10


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 req
uirements 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 Cog
nos 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 documentat
ion 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

an
d 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
a
ccording 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 b
ackend 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, troubleshooti
ng 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.


11




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 (
ColdFu
sion

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)


Pr
oject 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 C
anada 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 uti
lizing
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 fu
nctional 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.


12




Responsible for SQL integration with web based content via
ColdFusion

w
hile 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 a
nd 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 pr
ogramming
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 t
he 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 compo
nents,
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 applicati
on. 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
Extensib
le 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.


13




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 syste
ms 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 Cas
es 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 th
e 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, f
low 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,
Cold
Fusion

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 SourceSaf
e.



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.


14




Used
ColdFusion

to produce web
-
based forms, manuals, programs, data files and procedures
for the application.



Created and developed diagrammatic solution plans for technical proble
ms 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 ap
plication 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 Lan
guage (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 setting
s 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 smal
l
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.









15


Project # 11


Agriculture and Agri
-
Food Canada (AAFC)

Functional Foods and Natural Health Products Database (FFN)

Web Application Developer

May 20
08


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. Me
rritt 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 C
LF
-
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
Col
dFusion

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 funct
ional 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 a
nd 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, f
low
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



16


Agriculture and Agri
-
Food C
anada (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 ap
plication.
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, wr
ote 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 incorporat
ed 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
wit
hin 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 cr
eating 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.



Doc
umented 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)


17



Environment:

Col
dFusion

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 W
rapper, 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:


M
r. 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. Me
rritt 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.



Responsib
le 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 applicatio
ns 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 data
base 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 function
al 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 a
nd incorporated programs
according to client needs.




Utilized XML in the configuration of application configuration settings and retrieval of items
within language repository files.


18




Worked with the quality assurance team to implement this application.



Inst
alling 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 Wi
ndows 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 200
6 (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.



Responsibl
e 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
-
syste
m 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 fil
es.



Developed, tested and implemented the computer system as a sub
-
system to a larger one.


19




Performed application testing, troubleshooting and analysis.



Worked with the quality assurance team to implement this application.



Installing and configuring (
ColdFu
sion

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, L
inux 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 2
006 (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 funct
ionality
, 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 de
velop 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.



St
ored 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.


20




Developed manual code, screens, software and reported changes.



Responsible for database design and modifications, including creation of tables, columns,
assignment of primary and foreign key
s 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

FuseBo
x,
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 So
urceSafe.




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, repo
rts 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 c
lient 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
stor
age 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).


21




Produced all forms, programs, data files, manuals and procedures for the s
ystem.



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


CE
P
-
Consulting

esportfolio.com

Programmer Analyst/ Web/ Database Developer/ Database Administrator

July 2001


December

20
10

(
8

years,
5

months)


Project Description:


Mr. Merritt created and maintain
ed

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 Pe
rformed:




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 s
pecifications.



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 relationshi
p 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 documenta
tion 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 w
eb based content via
ColdFusion
.



Performed application testing, troubleshooting and analysis.


22




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 Servi
ces 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 websi
tes
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 u
sed 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 creatin
g 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 includ
ed 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.



23




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, tr
oubleshooting 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 websit
e 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, Dream
W
eaver 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 develop
ed 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.



Develop
ed 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
ot
her 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
.


24




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 manual
s 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, Oracl
e
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

HTML


XHTML

SQL

CFML


PHP

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

Dreamweaver

Adobe Dreamweaver CS4
-
5

ColdFusion

Studio

Home
S
ite

MS
VSS

Tortoise Subversion

SVN


25


EDUCATION


Bachelor of Business Administration, E
-
Commerce (1998)

University of New Brunswick, Saint J
ohn Campus



Bachelor of Arts, Psychology (1995)

University of New Brunswick, Saint John Campus



CERTIFICATIONS


Oracle Certified Professional
-

Internet Applications Developer


Oracle Certified Profess
ional
-

Application Developer