Bernard Brideau Email & Phone Number

Saint John, Nb, Ca

Saint John, Nb, Ca

Fredericton, Nb, Ca

Fredericton, Nb, Ca

Fredericton, New Brunswick, Ca

Fredericton, New Brunswick, Ca

• Interviewed customers to determine the business and data requirements and translated these requirements into coherent Business Intelligence (BI) reports.• Strong database understanding with SQL Query creation and optimization skills.• Develop optimal and scalable Business Intelligence (BI) application to meet customer needs. • Design, develop, test and implement data warehouse systems for BI reporting and analysis. • Experience with Sub-Report, Graph, Drill-Down, Adhoc, OLAP, Parameterized and Crosstab reports. Prepare and maintain BI reporting and analysis documentations.• Identify and resolve BI report related issues. Perform BI research and provide results and findings to senior management.• Remain current on industry trends with respect to BI capabilities. Execute BI projects within assigned budget and timelines. • Analyze existing BI reporting processes and suggest improvements. • Manage upgrades, modifications, maintenance and troubleshooting of BI systems. Provide recommendations to enhance BI system performance and capacity. • Validate data warehouse system for data integrity, quality and accuracy. • Work with various business teams to improve the BI reporting and analytics.• Maintained a Call Center Web BI application written with Perl running on Tomcat and Linux.

Saint John, New Brunswick, Ca

• Acted as lead to facilitate requirement gathering sessions with the client and SMEs, and translated these requirements into articulate Business Intelligence (BI) reports and suggested improvements.• Interpret, analyze and reconciliation of data obtained from a variety of data warehouse sources to develop new reports and enhance the existing reports. • Analyze massive and highly complex data sets, performing data query, OLAP, ad-hoc analysis, data manipulation, drill-down reports, cross-tab reports dashboard and design custom reports using JasperSoft BI Enterprise for customers worldwide. As the administrator, I was able to customize, create data sources, create domains (metadata), schedule, control security and maintain the JasperSoft environment; proficient with the Jaspersoft BI (Business Intelligence) analytical tools.• Work on complex information model, logical relationships, and the data structures that support Mariner ReportVu.• Made data chart presentations, coded variables from original data, conducted statistical analysis as and when required and provided summaries of analysis.• Prepared training materials and provided hands-on, one-on-one and classroom training for customers and staff. Ability to prepare and adjust training material to support various levels of knowledge and learning aptitude.• Created numerous simple to complex SQL queries involving self joins, correlated sub-queries for diverse business and reporting requirements. Tuned and optimized queries by altering database design, analyzing different query options, and index strategies using various database tuning tools.

• Established the Application Management Services (AMS) support team to support various mission-critical applications for a large oil company.• Implemented and streamlined an AMS support process flow methodologies which included the creation of a knowledgebase repository that resulted in optimizing employee's time, thus enhancing employee efficiency.• Orchestrated and successfully implemented Service-level agreements (SLAs) with capacity, Statement of Work, incident, problem, security and financial management using the ITIL methodology for production applications.• Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization.• Manage cost, schedule, and performance of AMS projects, while working to ensure the ultimate success and acceptance of this project.• Coach, mentor and lead personnel within the AMS technical team environment.

Fredericton, New Brunswick, Ca

• Plan and develop the statement of work, test strategy, test plan and test automation documents based on corporate policies, procedures, requirements and standards for the NB Department of Health – Drug Information System (DIS).• Responsible for smoke, regression, functional, performance and system testing for the DIS.• Write, maintain and execute test scripts for DIS using the HL7 Message Standard with HP Quick Test Professional.• Create test scenarios/test cases from the Process Functions, Use Cases and Functional documents, reporting requirement documents and are entered into the HP Quality Center.• Lead and motivate a QA/Test Team to implement a new automated testing process on a large, complex integration system for the Drug Information System (DIS) using HP QC/ALM and HP QTP.• Provide a regular update for planning, resource usage, project status, issues and risks for senior management and delivery teams.• Wrote test cases for the Drug Information System (DIS).• Create appropriate documentations and artifacts for delivery to the client.

Menlo Park, Ca, Us

Menlo Park, Ca, Us

Menlo Park, Ca, Us

Saint John, New Brunswick, Ca

• Provided administrative support for Oracle including creating new databases, database design, new users, performance tuning, indexing, setup backup with scripts, created export/import procedures, performs upgrades, script migration, support, PL/SQL development, reporting, ERP Integration and system integration. • Extensive experience in the development and upgrading of database systems, analytical techniques, and Data Warehousing concepts including Meta data and Data Marts.

Overland Park, Kansas, Us

• Conducted data gathering sessions with the customer to collect the business requirement, analyzed the information gathered, documented the functional or business requirements for the telephony application.• Performed analysis on the existing systems, recommended enhancements, and implemented strategies to streamline current processes.

Cincinnati, Oh, Us

• Develops and maintains applications and databases by evaluating client needs; analyzing requirements; developing software systems. Protects operations by keeping information confidential. Arranges project requirements in programming sequence by analyzing requirements; preparing a work flow chart and diagram using knowledge of computer capabilities, subject matter, programming language, and logic.

Fort Mcmurray, Alberta, Ca

During the 10 years with Keyano College worked on number of projects from database design, database creation, tuning/indexing, development, support, security, testing to determining business processes and requirements and recommending solutions. Developed Oracle Forms and Reports for the purchasing system. Designed, developed and maintained the first web page for Keyano College. Technology: Oracle, Oracle Form, Oracle Report, PL/SQL, SQL Server, Pascal, Delphi, HTML, DOS, VMS, OpenVMS, Microsoft Word, Microsoft Excel, WordPerfect, Lotus, Waterfall

Diploma, Computer/Information Technology Administration And Management

International Software Testing Qualifications Board (Istqb)

Education record

Education record

Computer And Information Sciences And Support Services