Nicolas Hebert Email & Phone Number

Montreal, QC, CA

Montreal, Canada Area

- Designed a SQL Server data warehouse using a combination of stored procedures and SSIS for scheduling.- Created a Framework Manager model.- Designed 25 reports used for e-filling.- Implemented a custom filing solution using MS Excel and DOS batch files

Montreal, Canada Area

- Installed and configured IBM Cognos 10.2.2 with the DQM enabled.- Reviewed existing Framework Manager project in order to identify performance flaws.- Designed a few aggregate tables using SSIS to address performance problems and cut run times by 500%.

Ottawa, Canada Area

- Created an executive dashboard using IBM Cognos BI 10.2.2 to convey various data quality KPIs, also provided an Active Report version of the dashboard in order to provide users with a complete data analysis tool without requiring a connection to the BI server.- Worked with the data analyst to gather requirements to create a new reporting datamart..

Montreal, Canada Area

- Helped client re-install and configure three IBM Cognos environments using custom SSL encryption keys.- Tuned the servers and suggested many “advanced properties” to improve overall performance.- Reviewed and re-designed all reports used for the client-facing dashboard.

Montreal, Canada Area

- Created an elaborate series of IBM Cognos 10.2.0 dashboard reports for a user community of over 90,000:- Enhanced and simplified existing tabular reports with a blend of relational and DMR data structures.- Added a visual aspect to the dashboards with the creation of multiple charts.- Created a series of IBM Cognos 10.2.0 Active Reports meant to be.

In September of 2013, IBM partnered with LearnQuest to deliver their training offerings and I performed a combination of onsite and web hosted classes all over North America.

Vancouver, Canada Area

- Installed and configured IBM Cognos 10.2.1 and IBM Cognos TM1 9.5.2.- Tuned and administered the new IBM Cognos 10.2.1 environment.- In charge of a complete upgrade from IBM Cognos BI version 8.4.1 to 10.2.1 and IBM Cognos TM1 9.4.1 to 9.5.2.- In charge of fixing over 50 problematic reports (relational and multi-dimensional reports).- Customized the IBM.

Montreal, Canada Area

- Installed and configured IBM Cognos 10.1.1 BI in a distributed environment.- In charge of a complete upgrade from IBM Cognos BI version 8.4.0 to 10.1.1.- In charge of upgrading a set of IBM Cognos Series 7 (Impromptu) reports and catalogs.- Administered the new IBM Cognos 10.1.1 environment.- Enhanced multiple Report Studio reports for better performance.

As a technical consultant for the Ironside group, I designed and developed Business Intelligence systems, including everything from installation, meta data modeling, report development, and dashboard design.Ironside Group is an IBM Cognos Partner, and specializes in IBM Cognos implementations.I have been working with IBM Cognos tools since 2004, and in the.

Delivered multiple Cognos Framework Manager, Report Studio and Query Studio instructor-led training classes.Worked with clients to built a fully integrated web applications using Cognos to not only display data in multiple formats, but also for data entry using Oracle PL/SQL stored procedures.I was also in charge of multiple projects around upgrading older.

Was in charge of all Cognos Impromptu report creation, upgrade and delivery.Wrote VB6 applications to automate the kickoff and distribution of reports.Developed and maintained ASP XML based web applications

Dess, Programming

Ba, Economics, Business

Dec, Social Sciences