Senior Business Intelligence Analyst
Reporting to Director, IT, was a member of a team responsible for all enterprise reporting for a rapidly growing telecommunications startup.
Design and development of processes to support a special client promotion with value of over $8 million (25% of annual revenue) using Informatica, SQL*Loader, OBIEE and PL/SQL
Operational activities related to monthly commission/bonus process for sales force.
Analysis, Design and Implementation of OBIEE+ reports
and dashboards.
Analysis, Design and Implementation of MS Excel based
reporting solutions.
Analysis, Design, and Implementation of ETL using Informatica, SQL*Loader, PL/SQL
Installation, Configuration and Administration of OBIEE+ in a mixed Linux and Windows environment
Sourcing data from Oracle eBusiness, Seibel CRM, Oracle CCA (Call Center Anywhere), Flat Files, Oracle Business Intelligence Applications
Tools: OBIEE+ 10g and 11g (development and admin), Oracle Database (9, 10, 11), Microsoft Project, Oracle ERP (eBusiness), Seibel CRM, Oracle CCA (Contact Center), MS Excel (including macros, charting, pivot tables), PL/SQL, SQL
Manager, Reporting and Dashboarding
Reporting to Director, Business Intelligence, led a
team responsible for all enterprise reporting
including a suite of tools that included OBIEE+,
Business Objects, Hyperion and Oracle Discoverer.
Performance reviews and general management of 4
direct reports.
Coordination and implementation of changes to Oracle
eBusiness reporting as a result of a system upgrade.
Coordination and implementation of changes to Oracle
eBusiness reporting as a result of the consolidation
of General Ledgers of a newly merged company.
Analysis, Design and Implementation of Oracle
Discoverer queries.
Analysis, Design and Implementation of OBIEE+ reports
and dashboards.
Analysis, Design and Implementation of MS Excel based
reporting solutions.
Mentored client development staff in the area of
PL/SQL and SQL optimization.
Maintenance of portal based reporting facility.
Tools: Oracle Discoverer, OBIEE, Oracle 10g, Oracle
11i, PL/SQL, SQL, Excel, SharePoint
Senior Business Intelligence Analyst
Analysis, Design and Implementation of Oracle
Discoverer queries.
Analysis, Design and Implementation of OBIEE+ reports
and dashboards.
Analysis, Design and Implementation of MS Excel based
reporting solutions.
Mentored client development staff in the area of
PL/SQL and SQL optimization.
Maintenance of portal based reporting facility.
Tools: Oracle Discoverer, OBIEE, Oracle 10g, Oracle
11i, PL/SQL, SQL, Excel, SharePoint
Senior Business Intelligence Consultant
Gathered business requirements and designed Order
Entry Data Mart for a leading direct mail media
company
Mentored client development staff in the effective
use of such tools as Oracle Warehouse Builder as well
in the area of PL/SQL and SQL optimization.
Tools: Oracle Discoverer, Oracle 10g, Oracle 9i,
PL/SQL, SQL, Excel
Senior Principal Consultant, Business Intelligence
Oracle
Mississauga,ON Feb 2006 - Jan 2007
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
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 - May
2007
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
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
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