Thomas Leblanc Email & Phone Number

Baton Rouge, La, Us

Downers Grove, Il, Us

Mentor team membersEmpowered 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 dataSuccessfully migrated a semantic model from business users to IT department on time and on budget. Improved refresh time in half and reduced size by 30%

As the Owner of Data on the Geaux, I worked as an independent contractor providing datasolutions services to clients. In this role, I consulted with clients on data warehouse and healthcare analytics, performance tuning and redesign of individual data marts. Additionally, Ideveloped and facilitated course content as a subject matter expert in various areas for onlineprograms. A few significant areas of focus in this role were:- Performance tuned stored procedures to run 50-75% faster, significantly impactingproductivity of staff for a key client.- Designed a next generation data warehouse for healthcare analytics with SSIS andAnalysis Service cubes.- Populated dimensional models and Microsoft Analysis Services on multi-dimensionalcubes. Developed data modeling tools for HEDIS and PQRS measures, indicatorsmanaged 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 recordedsessions in data warehousing, reporting services, and integration services

Birmingham, England, Gb

Author of the only book on Power BI Performance Tuning - https://www.amazon.com/Microsoft-Power-Performance-Best-Practices/dp/1835082254This book covers topics ranging from architecture and data modeling to Power BI premium features, DAX formulas, and collaboration, helping you to gain a deep understanding of the Power BI architecture, design efficient data models, create efficient queries, and improve visualization performance. You’ll also learn best practices to deploy and manage Power BI solutions, integrate with other tools and systems, ensure compliance and security, and collaborate with team members.

Somerset, Nj, Us

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.

Teaneck, Us

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 system.

Houston, Texas, Us

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 warehouseautomation 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 thetechnical team was on track with quality updates for new features, updates, and issueresolution.

Metairie, La, Us

I was hired at Crescent Bank & Trust as a SQL Server and Business Intelligence Architect and laterpromoted to a Data Warehouse Manager (AVP-level) role, as a result of strong job performanceand results. In this role, I was accountable to the daily activities and management of the team withoversight for the design, implementation, maintenance, and support of the data warehousesystems 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 warehouseimplementations, Power BI reporting service maintenance, tabular analysis servicesdatabase 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 performancetuning focused on optimizing a single source of data and transitioning from multiple datasilos.- 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) tomonitor loan servicing performance, call center performance and loan payment trends.Implemented dimensional modeling in Star Schema.

Baton Rouge, Louisiana, Us

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 datawarehouse activity. Additionally, I collected business requirements from the Analytics andBusiness Development teams and converted into functional specifications. Some of the keyachievements in this position:- Decreased spending significantly through effective knowledge transfer and transitioningcritical work in-house from consultant.- Spearheaded the efforts to provide healthcare analytics regarding performance to CMSby extracting data for the business to leverage to understand quality metrics andoutcomes, financial data for billing and revenue recovery.- Played a lead architect role in the design and development of the Dimensional Modeldatabase.- Developed ETL in SSIS 2012 and lead ETL developers in the process including SlowlyChanging Dimensions.- Created reports and dashboards in PowerView, SQL Server Reporting Services andDundas Dashboards.- Managed and performance tuned 6+ TB multiple state and commercial customer’spatient and claims databases using SQL Server 2008 and 2012.- Converted SQL Server 2008 to 2012 and converted data cubes to the new SSAS Tabularmodel.

Baton Rouge, La, Us

As a Senior level SQL Server Database Administrator, I installed, configured, maintained andupgraded performance of critical SQL Server databases, ensuring the availability and consistentperformance of various corporate applications. I created significant enhancements throughperformance tuning and resolving blocking/deadlocking. A few highlights in this role:- Achieved <1% downtime for all SQL Server Instances while developing a state-of-the-artvisualization from job applicant data.Built Dimensional Model Data Marts documenting the data dictionary in Excel andmodeling the structure in Visio. Utilized SQL Server 2012 Change Data Capture in SSISto incrementally load the data marts.- Managed and consolidated SQL Server instances, performance tune blocking anddeadlocking and implemented re-indexing routine for 500+ GB Data Warehousedatabases- Ensured products met or exceeded client expectations. Excelled at gathering feedbackand generating functional requirements and communicating to the technical teams.- Created SSRS reports from performance data and Quest Spotlight statistics.- Developed Multidimensional Cubes in Analysis Services with Excel PivotTable/Charts.

Baton Rouge, Louisiana, Us

On the Business Intelligence team, I was tasked with migrating ETL and ELT to SQL Server Integration Services (SSIS) from Cognos Data Manager and design of Enterprise Data Warehouse for one of the the largest Home Health companies. A highlight of this job was performance tuning the Month End accounting routine and daily Data Warehouse queries with better SQL and indexes. Then, used SQL Server Analysis Services (SSAS) to prototype data analysis for the Analytic group at Amedisys.

Baton Rouge, Louisiana, Us

I was hired as the first DBA at Amedisys, a global leader in Home Helth services. As Database Administrator, I was in charge of all production, development and test system databases and servers. The DBA work included a SQL Transaction Replication to a Data Warehouse and offline reporting system and Database Mirroring to Disaster site. The applications needed performance tuning T-SQL and proper indexing and maintenance.Eventually, the company hire 4 more DBAs over the 5 years I was there and I became a Senior DBA. We handled database design and validation, proper indexing and optimization of T-SQL queries. The OLTP and OLAP systems ranging from 100GBs to 800GBs.We implemented and maintained multiple SQL Server clusters with help from Scalibility Experts. Idera's Diagnostic Manager help use with estimating database file growth and historical performance indicators to grow the hardware systems. After using Confio's Ignite to find long wait state queries and processes in the data warehouse system, I was able to reduce the DW Monthly Process from 2 days(48+ hours) to 10 hours and maintain that performance. This enabled me to move to the Business Intelligence team.

Morrisville, Nc, Us