Get documents about "KEITH
Shared by: yaohongm
-
Stats
- views:
- 3
- posted:
- 2/7/2012
- language:
- pages:
- 43
Document Sample
J O
B
O J
H E
C
N T
C I
. V
E
M
E
N
E
A
R
Go
lde
n
Tr
um
pet
Ser
vic
es
Inc
orp
ora
ted
ca.li
nked
in.co
m/in
/gol
dent
rum
pet
Rele
ase
98 /
02
Nov
emb
er
2011
Cit
ize
n:
Bri
tis
h/
Ca
na
dia
n/
EU
Cer
tifie
d
Ora
cle
DB
A
8,
8i,
9i
SE
CR
ET
Cle
ara
nce
En
han
ced
Cle
ara
nce
Lo
cati
on
Rel
o
c
a
t
e
R
e
m
o
t
e
G
l
o
b
a
l
La
n
g
u
a
g
e
s
Eng
l
i
s
h
Spec
ializi
ng
in
perf
orm
ance
tuni
ng /
opti
miza
tion
appl
icati
ons
usin
g
year
s of
expe
rien
ce
havi
ng
work
ed
on
forty
four
(45)
proj
ects
to
date.
Cert
ified
Ora
cle
DBA
–
8, 8i,
9i,
Busi
ness
anal
yst,
Data
integ
rity
anal
yst,
SQL,
PL/S
QL,
For
ms
and
shell
scrip
t
prog
ram
mer
/
deve
lope
r, T-
SQL,
SQL
serv
er -
Enh
ance
d
and
SEC
RET
clea
ranc
e.
SEL
EC
TE
D
AC
HIE
VE
ME
NTS
R
e
s
o
l
v
e
B
a
c
k
u
p
I
s
s
u
e
s
/
i
n
t
e
g
r
a
t
i
o
n
w
i
t
h
N
e
t
B
a
c
k
u
p
D
a
t
a
g
u
a
r
d
S
y
n
c
h
r
o
n
i
z
a
t
i
o
n
i
s
s
u
e
s
,
a
n
d
m
a
n
a
g
e
m
e
n
t
/
D
B
A
n
o
t
i
f
i
c
a
t
i
o
n
O
p
t
i
m
i
z
a
t
i
o
n
o
f
s
e
a
r
c
h
-
e
n
g
i
n
e
/
O
r
a
c
l
e
T
e
x
t
u
s
i
n
g
P
L
/
S
Q
L
t
o
a
r
c
h
i
v
e
S
L
A
D
e
s
i
g
n
a
n
d
b
u
i
l
d
B
a
c
k
u
p
v
a
l
i
d
a
t
i
o
n
p
r
o
c
e
s
s
/
d
i
s
t
r
i
b
u
t
e
d
r
e
p
o
r
t
i
n
g
s
y
s
t
e
m
f
o
r
U
p
p
e
r
m
a
n
a
g
e
m
e
n
t
,
U
n
i
x
a
n
d
D
B
A
t
e
a
m
u
s
i
n
g
P
L
/
S
Q
L
/
s
h
e
l
l
s
c
r
i
p
t
/
C
e
n
t
r
a
l
r
e
p
o
s
i
t
o
r
y
D
a
t
a
b
a
s
e
/
R
M
A
N
C
a
t
a
l
o
g
D
a
t
a
M
i
g
r
a
t
i
o
n
/
V
a
l
i
d
a
t
i
o
n
p
r
o
c
e
d
u
r
e
s
/
E
r
r
o
r
r
e
p
o
r
t
i
n
g
u
s
i
n
g
P
L
/
S
Q
L
D
e
s
i
g
n
a
n
d
i
m
p
l
e
m
e
n
t
F
i
n
a
n
c
i
a
l
A
p
p
l
i
c
a
t
i
o
n
/
r
e
p
o
r
t
i
n
g
a
p
p
l
i
c
a
t
i
o
n
u
s
i
n
g
F
o
r
m
s
/
R
e
p
o
r
t
s
B
u
i
l
d
D
a
t
a
M
i
g
r
a
t
i
o
n
V
a
l
i
d
a
t
i
o
n
/
r
e
p
o
r
t
i
n
g
r
o
u
t
i
n
e
s
u
s
i
n
g
P
L
/
S
Q
L
&
S
Q
L
D
a
t
a
b
a
s
e
R
e
s
o
u
r
c
e
P
l
a
n
n
i
n
g
f
o
r
E
u
r
o
p
e
a
n
C
o
m
m
i
s
s
i
o
n
–
V
I
S
A
p
p
l
i
c
a
t
i
o
n
E
D
U
C
A
T
I
O
N
O
r
a
c
l
e
F
i
n
a
n
c
i
a
l
1
1
i
I
m
p
l
e
m
e
n
t
e
r
J
a
v
a
O
r
a
c
l
e
K
n
o
w
l
e
d
g
e
B
a
s
e
O
C
P
C
e
r
t
i
f
i
e
d
O
r
a
c
l
e
D
B
A
E
X
P
E
R
I
E
N
C
E
Experience in: Vehicle Sales/Maintenance System, Insurance, Pharmaceutical,
Aeronautical, Certified Oracle DBA
Electronics, Services, 8, 8i, 9i
Training, Industrial,
Construction,
Consumer Products,
Transportation,
Food/DIY Retail and
Distribution,
Government,
Security, Financial,
Health, Technical
Support, On-line
Gambling,
Telecommunications,
The Arts, Schengen
(European Security),
Mining.
Experience working
with all Oracle releases 6.0
through 11.2.0.1.0 on
Windows, Linux
and Unix platforms.
SQL Server
2005/2005R2/2008/2008R2
. Sybase/Oracle
Migrations.
45 – CN –
Canadian
National Railway
Company
Montreal, Quebec –
September 2011 ~ October
2011
http://www.cn.ca
SQL Server 2008
R2
o SSRS,
SSAR, SSIS
– Guides
o 2005-
2008R2 –
programme
r’s
Upgrade
Guide
Performance tuning
Refresh/Restore
44 – Xstrata -
Copper ( Xstrata
Nickel, Xstrata Zinc)
Montreal, Quebec –
May 2010 ~ September
2011
http://www.ccr.ca
http://www.xstrata.com/
24x7 On-Call
Development /
Acceptance Testing
/ Production
Support
o Oracle
- Wi
nd
ow
s/U
nix
o SQL Server
- Wi
nd
ow
s
Clu
ste
r/
Wi
nd
ow
s
Oracle Data Guard
– Unix/Windows
environment – 9i,
10g, 11g
o Physical
o Logical
(with
scheduling)
Installation of, and
upgrade of
Application Server
10g R2/R3
Refresh of
Databases
Resolve backup
issues
o NetBackup
o Recovery
Manager –
RMAN
o SQL Server
/ VERITAS
Shell scripting
o Unix shell
script
o Dos script
o Powershell
Installation of .Net
Installation of
Oracle Warehouse
Builder
Database
Upgrades
o Oracle 8i
to Oracle
11gR1/R2
o Oracle 8i
to Oracle
10gR1/R2
o Oracle 9i
to Oracle
11gR1/R2
Migration
o Oracle to
SQL server
2005/2008
Server Migration –
to VMWare
o Oracle 9i,
10g,
11gR1/R2
Databases
System Center
Operations
Manager 2007 R2
43 – Golden
Trumpet Services
Incorporated (GTSI)
Montreal, Quebec –
September 2009 ~ March
2010
http://www.gtsi.ca
Installation of
Oracle 11.1.0.6.0
and upgrade of
10.2.0.4 to 11.1.0.6
Upgrade /
verification of
RMAN catalog
Creation of
Standby Database
Creation of an
automated
documentation
distribution system
using PL/SQL
39/42 – STERIA /
ARTEMIS
BRUSSELS, BELGIUM
- AUGUST 2008 ~ AUGUST
2009
http://www.steria.be
Create scheduler
package to allow
for the equally
distributed
day/night
processing between
countries using
PL/SQL packages
Five year capacity
planning for an
estimated 40
million
applications
Optimization of the
load process –
SQL*Loader
Optimization of the
search engine –
removal of
duplicate code,
creating shared
procedures and
restructure of
dynamic queries
being generated to
ensure SLA using
PL/SQL including
images / Oracle
Text
38 – VITERRA
REGINA,
SASKATCHEWAN, CANADA
– OCTOBER 2007 ~ JUNE
2008
http://www.viterra.ca
Create a number of
PL/SQL routines to
migrate / validate
data being
migrated from
Sybase to Oracle to
allow for a
centralized system,
and the archiving
of the Sybase
application
Create a number of
Dynamic reports
based on input
from a Power
builder front-end to
replace the existing
report utility used
on the Sybase
application
37 – NATIONAL
GALLERY OF
CANADA
OTTAWA, ONTARIO –
MAY 2007 ~ JULY 2007
http://www.gallery.ca
Resolved a number
of backup issues
Produced a number
of Process /
Procedures
documentation
36 – LAFARGE
Mississauga, Ontario
– October 2006 ~ March
2007
http://www.lafarge.ca
Identified errors in
the backup process
and backup
reporting systems.
Created a
centralized
repository listing
all databases/nodes
and associated
backup schedules
Created ksh shell
script to extract
and validate
backups for each
Database/Node
Produced reporting
system to distribute
detailed
information to
Unix/DBA teams
and summary
information to
management
Update and
creation of
procedures
35 – Nortel
Networks
Global (May 2006 –
October 2006)
http://www.nortel.ca
Production Support
10gR2
Upgrade/Migration
Performance &
Troubleshooting
procedures
review/update
SOX enhancement
evaluation
o Oracle
Vault
o Secure
Backup
o Secure
Enterprise
Search
34 – Motorola
Global (September
2005 – April 2006)
http://www.motorola.com
Production Support
– On-call rotation
o Oracle
Application
s–
Financials
and
Manufactur
ing
o Data
Warehousi
ng
RMAN
performance
enhancements
Performance
Review
o Configurati
on –
Hardware,
Software,
Application
33 – Golden
Trumpet Services
Incorporated (GTSI)
Westmount, PQ
http://www.gtsi.ca
Installation and
validation of fixes /
new features
10.2.0.1
Migration test
plans / test cases
32 – Régie
Régionale de la
Santé et des Services
Sociaux de la
Montérégie
Montreal, PQ (May
2005)
http://www.santemonteregie.qc
.ca/agence/index.fr.html
Database Health
check
o Configurati
on,
security,
Disaster
Recovery,
Performan
ce
Performance
Review
o Application
Code, and
Database
Model
31 – Golden
Trumpet Services
Incorporated (GTSI)
Westmount, PQ
(March 2004)
http://www.gtsi.ca
Installation and
validation of new
features –
10.1.0.2.0
30 – BT Ignite
( North America
/ Computer Science
Corporation )
Montreal, PQ and
Reston, VA (November
2002 – July 2005)
http://www.btignite.com/uk/
CONCISE Data
Mart Production
Support /
Application
development
CAMPRS Data
Mart Production
Support /
Application
development
CVTM Production
Support /
Application
development
Application
knowledge transfer
/ documentation
review
Microstrategy 7i (
Support Only )
Migration of
Production
Database from
Windows NT to sun
Solaris
CAMPRS
Application
upgrade
CVTM Application
migration from
windows NT to
Windows Server
2003 and upgrade
from 7.3.4.0.0 to
9.2.0.2.0
29 – Golden
Trumpet Services
Incorporated (GTSI)
Westmount, PQ (May
2002 – November 2002)
http://www.gtsi.ca
Setup 9i Data
Guard – Physical /
Logical
Installation of 8.1.7
and upgrade to
9.1.1.1 – 9.2.0.1.0
Installation of
Oracle Financials
– Applications 11i
Installation of
Oracle Financials
– Applications 11i
NLS
Installation of
Oracle
Applications
Desktop integrator
Installation /
Configuration of 9i
Application Server
Installation /
Configuration of 9i
Application
Developer Suite
Application
upgrade – forms 6i
to forms 9i
Forms 9i
development
Reports 9i
development
Implementation of
VPD ( Virtual
Private Database )
28 – FRI
Corporation
Montreal, PQ
(October 2000 – February
2002)
http://www.fri.ca
Data Warehouse
load automation /
performance tuning
/ additional load
processes
o ETL –
extract,
transformat
ion and
load
Conversion of Pro-
c code to PL/SQL /
Unix shell scripts
Upgrade of
Database – 7.3.4 to
8.1.7
Technical
documentation
o SR&ED –
Scientific
Research
and
Experiment
al
Developme
nt
27 – Fifth
Dimension
Information
Systems,
Edmonton, AB (May
2000 – September 2000)
http://www.haemonetics.com
Data Migration
development /
support
Forms 3
development /
support of plasma
application
Reports SQR$
Data migration
Unix shell scripting
Q.A. test cases
according to
USFDA ( United
Stated – Food and
Drug
Administration )
requirements
26 – Readers
Digest Selection,
Montreal, PQ
(December 1999 –
February 2000)
http://www.readersdigest.com
DBA support for
Oracle Financials
development team
Installation of
Oracle Discovery
accessing Oracle
financials 10.7 –
Prod 16SC
Installation of
Oracle Discovery
accessing Oracle
financials 10.7 –
Prod 16SC using
Noetix views
Unix shell scripting
25 – Datachest,
Montreal, PQ
(October 1999 – March
2000)
http://www.datachest.com
Performance tune
Oracle 8i Database
on windows NT4
service pack 5
Install oracle 8i
standard edition
and Oracle 8i
enterprise edition
Upgrade 8i
standard edition to
8i enterprise
edition
Create two
databases
Create Unix shell
script to create and
maintain a Standby
Database
24 – Ideas &
Associate,
Montreal, PQ
(November 1999 –
December 1999)
http://www.freelotto.com
Installation and
creation of
database
performance /
security review -of
existing system
23 – Cognicase,
Montreal, PQ
(November 1999)
http://www.cognicase.com
Installation of 8i
enterprise edition
and creation of
database
22 – IMS Canada,
Pointe Claire, PQ
(October 1998 – May 1999)
http://www.imshealth.com
Development DBA
and Analyst /
PL/SQL
programmer
Data Warehouse
DBA
ETL – Extraction,
Transformation
and Load
21 – FRI
Corporation,
Montreal, PQ (July
1998 – November 1998)
http://www.fri.ca
Performance tuning
/ upgrade Oracle
7.3.4 database
20 – Martindale
Pharmaceuticals
UK (March 1998 –
April 1998)
Oracle Financials
upgrade 10.5 to
10.7
Convert Oracle
Financials to
Multi-Organization
Convert database
from Western
European / Turkish
to Western
European
Database upgrade
from 7.1.6 to 7.3.3
Migration of
GEMMS users to
correct location
within Database
19 – Norwich City
Council,
UK (February 1998)
Shadow Oracle
Financials upgrade
10.4. 2 to 10.7
18 – Oracle
Corporation
U.K. Limited -
Emea-Training (February
1998)
Installation of
Oracle
Applications -
client
17 – Fife Council,
Fife, Scotland
UK (March 1998)
Performance tuning
and production
setup guide lines
16 – SavaCentre
UK (February 1998)
Performance tuning
Database
Implement a sizing
package to run
nightly
Index rebuild script
to run nightly
Resolution of TAR
for FSG file
transfer
15 – Frito-Lay
UK (February 1998)
Restoration of lost
data in a
Manugistics
application
14 – PPG
Industries,
UK/Italia (January
1998 – February 1998)
Performance tune
GEMMS Database
Performance tune
GEMMS Bespoke
Application
DBA Production
support – Italy,
France, Spain and
the United
Kingdom
Produce Upgrade
recommendations
documentation
13 – Alcan
Aluminum Limited
Montreal, PQ (June
1997 – December 1997)
http://www.alcan.com/
http://www.alcan.com/About.ns
f/Topics-E/Global - Canada
Installation of
Oracle 7.3.2.3 and
Oracle Financials
10.7 Prod 16.0
Upgrade /
migration to Oracle
7.3.3.3 and Oracle
financials 10.7
Prod 16.1
Installation of MSL
( Multi-Language
support – Oracle
Applications)
Database / Oracle
Applications
replication – via
Unix shell scripts
Maintain global
Network
Performance
Tuning Database /
Application
12 – Alcan
Aluminum Limited
U.K. (May 1997)
http://www.alcan.com/About.ns
f/Topics-E/Global-uk
Installation of
Oracle 7.3.2.3 and
Oracle Financials
10.7 Prod 16.0
11 – Sphere Drake
Holdings Limited
UK (April 1997)
Taken Over by :
Fairfax Financial Holdings
in June 1997
http://www.fairfax.ca/
Installation of MSL
( Multi-Language
support – Oracle
Applications)
10 – Knoll
UK (March 1997)
Database / Oracle
Applications
replication – via
Unix shell scripts
9 – Interlight
Training
UK (March 1997)
Installation of
Oracle (
Incomplete due to
errors in the
Operating System )
8 – Toshiba
UK (March 1997)
http://www.toshiba.com/
Installation of
Oracle and
performance tuning
of Database
7 – Unilever
Foods Limited
UK (September 1996
– February 1997)
http://www.unilever.com
Evaluation,
implementation and
staff training in
PVCS version
manager 5.2.20/21
Creation of internal
web page for
documentation
Installation of
Express, financial
Analyzer
6 – Smith
Industries Limited
UK (September 1996)
Identify and
change views into
tables to improve
performance
Create database
triggers to populate
new tables
5 – Ministry of
Defense,
UK (September 1996)
http://www.mod.uk
Installation of
Oracle 7.3.2.3 and
Oracle Financials
10.7 Prod 16.0
Upgrade /
migration to Oracle
7.3.3.3 and Oracle
financials 10.7
Prod 16.1
4 – Unilever
Foods Limited
UK (September 1996)
http://www.unilever.com
Database creation
and importation of
data from
Argentina
3 – SmithKline
Beecham,
UK (May 1996 –
September 1996)
http://www.sb.com
DBA coverage for
wind-down project
2 – RAND
Information Systems
Limited
( Commercial
Union Europe –
Insurance )
UK/Belgium
(February 1992 – April
1996)
Took on DBA role
within the project
in 1994.
Preparation of
working
environment for
both
development/Q.A
team and client
acceptance
Q.A. and
Development
1 – Kalamzoo –
Placement
UK (August 1991 –
January 1992)
Q.A within the Elite
project ( Vehicle
sales / Maintenance
system )
0 – Kalamzoo –
Training
UK (October 1990 –
August 1991)
00 – Oracle
Corporation – Oracle
Application, United
Kingdom
UK (May 1996 –
April 1998)
Certifications
Skype Birmingham, E-Mail
United Kingdom
gtsi06 gtsi@gtsi.ca
0044 121 286 1664 gtsi@gtsi.eu
0121 286 1664
Telephone
Website
Facsimile
Montreal, Quebec,
http://www.gtsi.eu
Canada: 001 (514) 800 0687 http://www.gtsi.ca
001 (514) 993 6886 http://www.gtsi.tel
West Virginia, USA Linked In
001 (304) 816 0536 linkedin@gtsi.ca
ca.linkedin.com/in/goldentrumpet
Xstrata Copper
Canada
“The best Database
Administrator I've ever had
working for us. Thourough
knowledge of both Oracle and
SQL combined with initiative
and a commitment to doing
things right. Works well
autonomously or as part of a
team. Top notch!”
January 26, 2011
Dean Cavanaugh, IT
Infrastructure
Superintendent, Xstrata
Copper
http://ca.linkedin.com/pub/dea
n-cavanaugh/1b/398/b08
“john is following up the
tasks that are attributed to
him in a professional way
and reported correctly on
them.”
February 14, 2010
Marc Berghmans,
Project Director,
European Commission
Brussels, Belgium
http://be.linkedin.com/pub/mar
c-berghmans/2/b1/5b3
European Commission
Brussels, Belgium
Schengen
European (VIS)
Visa Entry System
European Union
Canada
Operating Systems
NT4, NT4 SP5,
NT Workstation , 2000,
2000 SP4, 2000 Professional,
XP, XP Professional,
Server 2003/2003 R2,
Server 2008/2008 R2,
7, Windows Cluster
HP UX 10.01, B.10.20,
11.10, 11.11.0,
B.11.00/11.11/11.23,
IA, (Compact) Tru64
OSF1, A 9000/819
sparc SUN-Sun-Fire
T200, V210,V240,
V280R, V480, V880,
V890
Sun-Blade-100,
SunOS 5.8, 5.9, 5.10,
Sun SPARC Solaris 2.6/2.7
Sun Cluster
Others:
SCO UNIX, Sequent,
DG/UX
AViiON PentiumPro,
AIX 3 4, Unisys
Storage:
LAN/SAN
Databases
2005 / 2005 R2
2008 / 2008 R2
Certified Oracle DBA
8, 8i, 9i
6, 7, 7.0.16.4,7.1.6,7.1.6.2,
7.3.2.1, 7.3.2.3, 7.3.3.3,
7.3.3.5, 7.3.4, 7.4.3.4,
8, 8.0.5, 8.1.5S, 8.1.5E, 8.1.7,
9.0.1.1.1, 9.2.0.1.0,
9.2.0.5.0, 9.2.0.7.0,
9.2.0.8.21,
10.1.0.2.0,10.2.0.2.6,
10.2.0.3, 10.2.0.4,
10.2.0.5,
11.1.0.6.0, 11.1.0.7.0
11.2.0.1.0
Regina, Saskatchewan,
Canada
Albert Kaufman
Owner of Albertideation
Portland, Oregon Area
Quote :
“It was the most interesting
resume I've ever seen”
Canada
Application
Software
Financials 10.4.2, 11.0.28,
10.7,10.7 Product 16.0/16
.1,11.5.5,11.5.6,11.5.9 GEMMS,
Manugistics Tools,
Manufacturing,
Multi-Organizations,
Noetix views,
Enterprise One (JD Edwards)
Cognos, Citrix, Altaris
Tools:
Oracle Forms
3, 4.5, 6, 6i, 9i, 10g,11g
Oracle Reports,
SQL, PLSQL, T-SQL,
sqr4, rpt
shell script, C Shell, K shell,
Bourne Shell,
sed, awk,
Dos Batch script
Willoughby – MIMSY *XG,
Oracle Discoverer
3.1.36.01 / 3.1.38.01,
Remedy,
Jira, I.T. Governance,
OEM, 10g AS, 10g DS (9.0.4)
toad, LDAP
Oracle OLAP, Oracle Text,
Citrix, Noetix Views
Altiris
United Kingdom
Backup Tools
NetBackup
6.5.4
“At Xstrata Copper John`s
extensive knowledge of
Oracle helped me to
configure our RMAN
Backups and resolve our
Database issues”
Neil Patel,
Data Centre Administrator,
Xstrata Copper
December 2010
http://ca.linkedin.com/pub/neil
-patel/10/718/121
Research:
SR&ED –
Scientific Research and
Experimental Development
http://www.rprdevcorp.com
United Kingdom
Italy
Standards:
Sarbane Oxley
http://www.soxlaw.com
Food and Drug
Administration
http://www.fda.gov
United Kingdom
Canada
Methodologies
Kimball,
Structured Systems
Analysis
and Design Method
(SSADM), Case, SDLC
Databases Types
Data Warehouse, OLTP,
General, Custom
National Gallery
of Canada
Fife County Council
Scotland
Golden Trumpet Services
Incorporated
4557 Sherbrooke Street West,
#301
Westmount, Quebec,
Canada, H3Z 1E8
Relocate / Remote work
Global
Release 98 / 02 November 2011
