Thomas LeBlanc

• Collaborated with a large utility to enhance data availability from Oracle Primavera P6 in Databricks. • Reduced failure rates from 50% to less than 1% by optimizing project data ingestion through On-premises API calls. • Streamlined data transformation processes in Delta Tables, improving analytical capabilities for Power BI measures.

State Utilities - Modernized data ingestion by architecting a medallion setup in Microsoft Fabric for monitoring incentive programs dealing with energy efficiency. Reduced multiple reports in one Power BI Semantic model. New report development can be done in hours rather days or weeks.

Mentor team members (senior engineers and architects) Empowered a large university with getting started with Fabric as an analytical platform. Implemented Bronze and Silver layer in Fabric using pipelines and notebooks to capture raw data. Delta tables used for transformed data in a meta-data driven pipeline with logging. Successfully migrated a manufacturing company's semantic model from business user developed to IT department supported semantic model on time and on budget. Improved refresh time in half and reduced size by 30%. Assisted large manufacturing company in auditing the Power BI environment for data governance. Created a solution to migrate from self-service BI to IT governed BI. Leadership: Provided project and program leadership with engineers and architects on multiple projects, including architectural design, team mentoring, and resource planning for stakeholders. Acted as technical oversight for offshore team in technical skills to help with career development.

Author of the only book on Power BI Performance Tuning - https://www.amazon.com/Microsoft-Power-Performance-Best-Practices/dp/1835082254

Azure data solution architect - migrated client system from on-premises MSBI (SSIS, SSAS and Power BI Report Server) to Azure Data Services - Data Factory, Power BI Data Set (tabular) and trained staff on Power BI visualizations. Reduced complexity by moving code from Analysis Service Tabular model into ETL code for well designed Dimension and Fact Tables.

Staff augmentation for Big 5 account firm - performance tuned stored procedures and ETL code to meet SLAs, split Power BI data set into multiple models and assisted architecture of overall Power BI eco-system.

In my role as Senior Product Manager, I managed product planning through the complete product life cycle, gathering and prioritizing customer requirements, defining the product vision, and working closely with the technical team to deliver a stellar product. A few of the key highlights in this role were: - Introduced business vault automation solution in 3D, which is now offered to clients. - Developed product roadmaps for the WhereScape 3D software, a data warehouse automation tool, prioritizing the main features to be released or updated each quarter. Wrote product requirements and translated into JIRA, leveraging Agile methodologies. - Interfaced with clients and conducted routine meetings to get feedback on the software, accelerating the successful utilization of the product. - Worked with the offshore development team in a matrixed environment, to ensure that the technical team was on track with quality updates for new features, updates, and issue resolution.

I was hired at Crescent Bank & Trust as a SQL Server and Business Intelligence Architect and later promoted to a Data Warehouse Manager (AVP-level) role, as a result of strong job performance and results. In this role, I was accountable to the daily activities and management of the team with oversight for the design, implementation, maintenance, and support of the data warehouse systems and data marts. Some of the key achievements in this role: Implemented a loan servicing analytics visualization tool to identify loan default risks, allowing for data-driven business insights. - Managed two employees and a remote DBA service, charged with data warehouse implementations, Power BI reporting service maintenance, tabular analysis services database implementations, and the transition from Crystal to SQL Server reporting. - Performed maintenance and performance tuning to SQL Server Instances (12 production, the largest handling 8TB of data). - Improved data warehouse server performance, doubling the speed through performance tuning focused on optimizing a single source of data and transitioning from multiple data silos. - Developed and launched 5 new Data Marts of 35 Dimension and Fact Tables (ETL in SSIS, 5 Tabular Analysis Service databases and reporting in Power BI and SSRS on-premises) to monitor loan servicing performance, call center performance and loan payment trends. Implemented dimensional modeling in Star Schema.

As the Owner of Data on the Geaux, I worked as an independent contractor providing data solutions services to clients. In this role, I consulted with clients on data warehouse and health care analytics, performance tuning and redesign of individual data marts. Additionally, I developed and facilitated course content as a subject matter expert in various areas for online programs. A few significant areas of focus in this role were: - Performance tuned stored procedures to run 50-75% faster, significantly impacting productivity of staff for a key client. - Designed a next generation data warehouse for healthcare analytics with SSIS and Analysis Service cubes. - Populated dimensional models and Microsoft Analysis Services on multi-dimensional cubes. Developed data modeling tools for HEDIS and PQRS measures, indicators managed by the Center for Medicare Systems (CMS) in the healthcare industry. - Built training courses for high-profile online training course providers, including, Pluralsight, LearnNow, and Pragmatic Works. Created content, facilitated, and recorded sessions in data warehousing, reporting services, and integration services

In this role, I provided focus on enterprise-wide data modeling and database design initiatives. This included creating data models, testing, monitoring, managing and validating data warehouse activity. Additionally, I collected business requirements from the Analytics and Business Development teams and converted into functional specifications. Some of the key achievements in this position: - Decreased spending significantly through effective knowledge transfer and transitioning critical work in-house from consultant. - Spearheaded the efforts to provide healthcare analytics regarding performance to CMS by extracting data for the business to leverage to understand quality metrics and outcomes, financial data for billing and revenue recovery. - Played a lead architect role in the design and development of the Dimensional Model database. - Developed ETL in SSIS 2012 and lead ETL developers in the process including Slowly Changing Dimensions. - Created reports and dashboards in PowerView, SQL Server Reporting Services and Dundas Dashboards. - Managed and performance tuned 6+ TB multiple state and commercial customer’s patient and claims databases using SQL Server 2008 and 2012. - Converted SQL Server 2008 to 2012 and converted data cubes to the new SSAS Tabular model.