Senior Principal Consultant, Business Intelligence
Oracle Mississauga,ON Feb 2006 - present
Held a series of facilitated workshops aimed at providing line
staff as well as management up the to C-level an opportunity to
provide input into the process of developing a roadmap leading to
a long term reporting strategy for a business implementing Oracle
E-Business suite.
Designed and developed a series of ETL processes to allow for the
addition of new capabilities to a 15 TB data warehouse for a
large retail organization in an engagement that came in on time
and well under budget.
Tools: Oracle Warehouse Builder, Oracle 10g, PL/SQL, SQL
Principal Consultant
Adelphia Communications Coudersport,PA Sep 2005 - Feb 2006
Lead ETL designer/developer, Co-Architect of 500 GB data
warehouse for a large ISP/Cable company.
Mentored client staff in the effective use of various Oracle
tools including PL/SQL code optimization. systems.
Tools: Oracle Warehouse Builder 10g, Oracle WorkFlow, AIX, Sun
Solaris
Principal Consultant
Port Wallis Technologies Dartmouth,NS Feb 2004 - present
Owner/Operator of a consultancy focused on e-commerce for small
business.
Mostly small contracts implementing shopping carts, back-end
payment processing and the like to new or preexisting small
business sites.
Tools: Excel, HTML, Javascript, LAMP (Linux, Apache, Mysql,
Perl/PHP), OpenOffice, Oracle 10g, Python, VBA, VBScript,XML,
XSLT
Senior Analyst – Business Intelligence
Medavie Dartmouth,NS Jan 2002 - Sep 2005
Technical Lead of a team of developers and analysts responsible
for the creation and maintenance for data warehouse and reporting
applications for a mid-size health insurance company in a mixed
Oracle environment.
Design and development of SQL, PL/SQL, and Pro*C code, as well as
the use of Oracle Warehouse Builder to perform ETL functions for
a 100 GB data warehouse.
Determining and implementing partitioning strategies in
consultation with DBA group.
Migration of Oracle 7 database to 8i and then 9i including the
migration of 500 Oracle Reports and 40 Oracle Forms to from
Oracle Forms/Reports 6 to version 9i.
Extensive use of Oracle Designer as a modeling and design tool.
Tools: COBOL, Easytrieve, Excel, HTML, Java, Javascript,
MS Project, Oracle 8, Oracle 9i, Oracle Designer, Oracle Forms,
Oracle Reports, Oracle Warehouse Builder, PL/SQL, PowerPoint,
RUP, SQL, UML, VBA, XML, XSLT
Technology Architect
DMR Consulting Halifax, NS Apr 1996 - Jan 2002
Designed and developed a widely distributed, high availability,
distributed Oracle database. At the time it was one of the
largest in Canada.
Designed and developed a data conversion process to extract,
transform and load 1 TB of data in a severely time constrained
environment.
Creation of UI design standards for a Power Utility.
Design and development of mobile telecommunications billing
system
Design and development of an on-line system that implemented
measures as required by a youth criminal justice law using Oracle
Forms and Oracle Application Server.
Physical Oracle DBA duties for several clients on an as-needed
basis.
Design and development of an on-line system which implemented
measures as required by a youth criminal justice law. This was a
system that had a web interface written using Oracle Forms and
Oracle Application Server to provide access to data stored in a
central Oracle database.
Management of consulting assignments ranging in size from 1 to 15
consultants and having values in excess of $1,000,000.
Tools: C, C++, COBOL, DB2, Easytrieve, Excel, Lotus Notes, MS
Project, Oracle 8, Oracle Designer, Oracle Forms, Oracle Reports,
Perl, PL/SQL, SQL, XML, XSLT
Principal Consultant
Informatique le Phare Aylmer, QC Apr 1995 - Apr 1996
Designed and developed electoral mapping application written
using Oracle with portions acquiring data from Access and Foxpro
databases.
Data Analysis using Powerplay and Impromptu.
Designed and developed Telecommunications fraud application for a
major long distance carrier.
Tools: C, C++, Cognos DSS suite(PowerPlay, Impromptu), Crystal
Reports, Excel, FoxPro, MS Access, MS Project, Oracle 8, Oracle
Forms, Oracle Reports, Perl, PL/SQL, PowerPoint, SQL, VBA
Business Development Leader – Software Development
Nutat Technologies Ottawa, Ontario Apr 1994 - Apr 1995
Oversaw the preparation of bids for government and
private sector contracts.
Management of multiple teams of software developers.
Design of rules engine for telecommunications fraud detection.
Design and creation of Decision Support tools
Oversaw the creation of and delivered presentations containing
highly technical information to various types of audiences.
Acted as Oracle DBA for various clients as required.
Tools: C, C++, Cognos DSS suite(PowerPlay, Impromptu), Excel, MS
Project, Oracle, Oracle Forms, Oracle Reports, PL/SQL,
PowerPoint, SQL
Programmer Analyst
Statistics Canada Ottawa, Ontario Apr 1988 - Apr 1994
Operational Database Administrator for corporate financial
systems.
Designed and developed Decision Support tools.
Performed custom data analysis for financial systems
Tools: C, COBOL, Cognos DSS suite(PowerPlay, Impromptu), IBM
Mainframe(JCL, ISPF macros, REXX), Oracle (various), Oracle
Forms, Oracle Reports, PL/SQL, SAS, SQL, TPL
Programmer
Coastal Oceanography Lab, Dartmouth, NS Sep 1986 - Sep 1987
Created computer models of ocean current flow in North Atlantic
Created graphical representations of radar data
Tools:Fortran, CDC Mainframe, Cray Supercomputer