Ken B. Email & Phone Number

Ottawa, Ontario, Canada

Provide technical and functional support with Oracle EBS and Oracle Real Estate software.

Ottawa, Canada Area

Oracle Business Intelligence/ERP Consultant

Ottawa, Canada Area

Business Intelligence Architect

Ottawa, Canada Area

Business Intelligence Analyst - OBIEE, - OBIA, - Financial Analytics, - Project Analytics, - BI Publisher applications. Oracle EBS R12 Technical - Receivables - Payables - Purchasing - Time and Labour - General Ledger - Customers Online - iReceivables - Self-Service Human Resources - Alerts and Busniess Events

The Royal College of Physicians and Surgeons of Canada is the national professional association that oversees the medical education of specialists in Canada. The Royal College is dedicated to setting the highest standards in postgraduate medical education — through national certification examinations and lifelong learning programs — and to promoting sound health policy.

PricewaterhouseCoopers (PwC) LLP, Canada, is a member firm of PricewaterhouseCoopers International Limited and is one of the “big four” accounting firms.Our 5,200 partners and staff in 23 locations across the country provide industry-focused assurance, advisory and tax services for public, private and government clients in all markets.

Senior Consultant specializing in Oracle Business Intelligence and ERP.

MTS Allstream is a wholly-owned subsidiary of Manitoba Telecom Services Inc. As one of Canada's leading national communication solutions companies, MTS Allstream provides innovative communications for the way Canadians want to live and work today. The Company has more than 100 years of experience, with 6,000 employees across Canada dedicated to a mission of delivering true value as seen through the eyes of our customers. MTS Allstream has nearly two million total customer connections spanning business customers across Canada and residential consumers throughout the province of Manitoba. The Company's extensive national broadband and fibre optic network spans almost 30,000 kilometres.

Works primarily as an Oracle ERP (Technical) and Business Intelligence analyst and developer.

Senior Consultant specializing in Oracle Business Intelligence and ERP.

Ottawa, Ontario, Canada

Supported and enhanced the enterprise data warehouse system.Key Results:- Reduced the time for TC's custom PL/SQL Extract, Transform, and Load (ETL) from 8 hours to 3.- Implemented partitioning and other strategies to improve performance and query optimization.- Optimized reports and queries off of the data warehouse.- Analyzed, designed, and coded new star-schema extracts from TC's Oracle EBS R11 and other enterprise systems.- Provided impact analysis and migration strategy from Oracle EBS 11.5.9 to 11.5.10.- Migrated ETL from Oracle 9 to Oracle 10.- Provided extracts and reports needed for TCs re-organization.- Created Oracle Data Warehouse proof-of-concept.- Provided training and documentation to TC employees along with knowledge transfer of customizations.

Provided technical support to INACs Oracle EBS R10 and R11 and create an ad-hoc reporting system.Key Results:- Analyzed, designed, created, and tested many Oracle customizations using Oracle Reports, PL/SQL, Forms, etc.- Performed impact analysis for conversion from Oracle EBS R10 to R11.- Successfully migrated customizations and supported the conversion from Oracle EBS R10 to R11.- Developed several reports to assist INAC staff in fulfilling Access To Information Requests (ATIP).- Created ad-hoc reporting system using Discoverer 3.1 (Web) including materialized views for improved performance. - Provided training and documentation to INAC employees along with one-on-one guidance. As well, provided knowledge transfer to INAC technical staff on support of customizations.

Supported implementation of Oracle EBS R11 for Sleeman Breweries. Analyzed and designed AR and Inventory report customizations and PL/SQL. Key Results:Developed and customized several reports in off-hours within a compressed time period.

Supported JDS's Noetix Views and Oracle Discoverer platform for ad-hoc reporting off of their Oracle EBS R10.Key Results:- Maintained Noetix Views for JDS.- Analyzed, designed, created, and tested many additional views for AR, AP, GL, PO and Costing/Pricing.- Customized existing views as per business requirements.- Created custom PL/SQL routine to automate the creation of new business units- Nurtured power users and trained employees on the use and benefits of ad-hoc reporting.- Documented processes and developed presentations for training.

Provided analysis, design, coding, and testing for FAO's Oracle Applications Data Warehouse and Oracle Discoverer. Key Results:Analyzed, designed, created, and tested additional extracts to the data warehouse.Supported and enhanced the Oracle Discoverer meta-data.Created customized database views for new extracts.Nurtured power users and trained employees on Oracle Discoverer.Produced training documentation and performed knowledge transfer to FAO employees.

Application architect, analyst, and developer on various applications including Canada Pension Plan, Old Age Security, Corporate Inventory Management System, and Standard Payment System.