David Petiot Email & Phone Number

Calgary, Alberta, Canada

Calgary, Canada Area

Calgary

Calgary

Calgary, Canada Area

Steelwedge is a leading SaaS company that offers integrated business planning solutions, uniting a company’s demand, supply and financial forecast.•Database Architect and lead database and .net developer for Steelwedge analytics projectCustomized SSAS database is deployed for each customer o Designed multi-tenant relational database that holds the meta-data that define each SSAS database. o Designed and coded .net libraries that are used to create and maintain each SSAS database using AMO. o Implemented a proactive caching strategy that ensures a maximum data latency of 5 minutes. o Created data services that supports an Excel based reporting system, a web based dashboard and mobile apps. The service interprets a request, creates the appropriate MDX query, executes it, and returns the results.•Provide technical leadership and mentoring for development team located in India.•Ran training sessions on dimensional modeling, building cubes in SSAS, and learning MDX•Provided technical support to the services and operations teams

Calgary, Canada Area

Teck is Canada’s largest diversified mining, mineral processing and metallurgical company.• Assist in defining the BI Road map• Develop and maintain business intelligence logical and physical models• Analysis Services architecture, design and development• Work with DBA’s to ensure optimal data performance• Design and implement ETL to bring data from the AX database into the data warehouse• Provide expert SQL support and mentoring to the report writing team.

Calgary, Canada Area

• Responsible for all relational and multi-dimensional modeling and the corresponding SQL Server and Analysis Services databases.• Technical lead for the design and implementation of Right90’s key applications:o Forecaster application - a forecast entry tool that uses real-time OLAP to enable users to view and alter forecast data at both detailed and aggregate levels. o Comparative Analytics - an OLAP application that allows users to compare different forecasts at various points in the past and pinpoint key reasons for variance.o Change analytics – an OLAP application that enables analysis of how a forecast has changed over time.o Trust Analytics – an OLAP application that analyzes past forecast performance using various metrics and applies the results to future forecasts offering guidance as to how trust worthy they are.• Developed the ability to deploy the standard Right90 Analysis Services database and customize the dimensions and facts to each customer’s specific business.• Designed and developed an MDX query writing engine in .Net that hides the complexities of the language from the developer.

Calgary, Canada Area

• Designed a Data Warehouse based on a star schema and implemented it in Oracle 8i.• Developed ETL primarily written in PL/SQL combining data from various legacy sales systems, a new web based sales system built on SQL Server and an Oracle Financials backend.• Designed and implemented an analytic reporting suite. The backend was an Analysis Services database that drew data from a SQL Server database that used DTS to stay synched with the main Oracle data warehouse. The front end was a web based reporting portal built around the Microsoft Office Web Components.• Provided marketing with the ability to analyze various types of marketing campaigns and perform advanced customer analysis such as RFM profiling.• Lead a technical team of between 3 and 5 people including technical evaluations of skill sets.

Bsc., Computerscience

Msc., Theoretical Physics

Bsc., Physics