Senior Business Intelligence Analyst
Valassis Communications Windsor, CT Sep 2009 - Jul 2010
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
Valassis Communications Windsor, CT May 2007 - Sep 2009
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
Patriot Consulting Iselin, NJ Jan 2007 - May 2007
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
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
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
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 - 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
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