Data Engineer Power Bi
Resume:
Haines City
*******.******@*******.***
linkedin.com/in/asgardsquared
Matthew Lester
Data Engineer
Dynamic Senior Data Engineer with over 10 years of experience specializing in data analytics, visualization, and ETL processes. Adept at transforming complex data into actionable insights through interactive dashboards and reporting solutions. Proven track record of delivering high- impact results using Tableau, Power BI, Alteryx, and SQL across industries. Notably, migrated data with 100% accuracy and led teams to deliver projects ahead of schedule, saving clients over $100k. Skilled in designing data models, optimizing workflows, and integrating diverse data sources, Matthew brings a passion for leveraging data to drive business decisions. Experienced in Python, SQL, Data, ETL, Supply Chain, Food and Beverage technologies, Github, Snowflake, Oracle, MS SQL Server, Blue Yonder’s Forecasting and Replenishment technology, Crunchtime, data extracts, transformation, migration, uploads, agile, product, cloud, JIRA, documentation, reporting, testing, debugging, root-cause analysis, and process improvement.
EXPERIENCE
Power BI Developer Pratt and Whitney 02/2024 to 03/2025
-Developed and maintained 20+ interactive dashboards and 30+ reports, providing actionable insights that increased business efficiency by 15% - Collaborated with cross-functional teams to gather requirements, translating them into 10+ successful technical solutions that supported $2M in annual revenue growth -Designed and deployed data models with an accuracy rate of 99%, ensuring consistency across 5+ data sources such as SQL Server, Excel, and Azure -Implemented data security protocols and managed access for 50+ users, maintaining compliance with company security standards and reducing security incidents by 20% -Delivered Power BI training to 100+ end-users, improving report utilization by 25% and reducing support requests by 30%
Alteryx Data Engineer (4-month Data Warehouse Migration Project) Fountain Life 10/2023 to 02/2024
-Successfully migrated 4 years of data with 100% accuracy and zero data loss, completing the project 2 months ahead of schedule, resulting in
$100K in cost savings -Enhanced system performance by 60%, improving processing times and user satisfaction across 5 departments -Led a cross- functional team of 8 members to plan and execute ETL processes, ensuring seamless integration of data from QuickBooks to Sage for 3 key business platforms -Redesigned 10+ Tableau dashboards, integrating data from Sage, Salesforce, and web analytics, boosting marketing team's reporting capabilities by 30% -Conducted user acceptance testing (UAT) with 25+ end-users, providing training and support that increased user adoption by 40% within the first month of system go-live
Senior Tableau Developer MCA (Mobile Communications of America) 10/2022 to 10/2023
-Designed and developed 30+ interactive dashboards using Tableau Desktop and Server, delivering actionable insights to 10+ departments that improved decision-making by 25% -Optimized data processing and visualization by integrating Python scripts and SQL queries, reducing report generation time by 40% and enhancing analytical capabilities -Automated 90% of data workflows through Azure Data Factory, streamlining data integration from 5+ sources into Tableau and cutting manual processes by 50% -Integrated Business Objects with Tableau, delivering 15+ dynamic reports, providing a comprehensive view that increased report utilization by 35% -Collaborated with 6 cross-functional teams to translate business needs into robust Tableau solutions, accelerating project delivery by 20% Business Intelligence Developer Chico's 05/2022 to 10/2022
-Utilized OLAP cubes for efficient analysis of large datasets enabling faster decision making across different departments -Gathered, analyzed and reported on business data to identify trends and correlations -Developed and maintained Business Intelligence dashboards for executive management reporting -Collaborated with stakeholders to understand their requirements and develop appropriate visualizations to meet their needs -Monitored system performance by developing automated scripts to detect potential issues in the data pipelines Lead Alteryx Developer Valley National Bank 11/2020 to 05/2022
-Developed web applications using HTML, CSS, and JavaScript -Created user interfaces for websites with Adobe Photoshop -Optimized 5+ data sources for Alteryx workflows using SQL, improving data retrieval speed by 40% and ensuring seamless integration -Delivered end-to-end data solutions by combining data from 10+ sources, providing actionable insights that contributed to a 15% improvement in business performance - Collaborated with 8 stakeholders to gather requirements and deliver robust Alteryx solutions, achieving 100% accuracy and maintaining data integrity throughout the development process
Tableau Developer Lockheed Martin 09/2019 to 10/2020
-Performed ETL processes to integrate data from 7+ sources into Tableau, reducing data preparation time by 35% -Created complex calculations, parameters, and custom SQL queries, providing meaningful insights that improved reporting accuracy by 15% -Collaborated with 10+ stakeholders to translate business requirements into effective Tableau solutions, leading to a 30% increase in report utilization -Managed Tableau administration tasks, ensuring system uptime of 99% and delivering actionable data analysis that supported executive decision-making by 25% Tableau Developer Westgate Resorts 04/2018 to 09/2019
-Developed and maintained Tableau dashboards with interactive visualizations -Created custom views, charts, graphs, filters, parameters, and data sources to meet specific user requirements -Developed complex calculations using Tableau functions such as LOD expressions and table calculations
-Tuned queries for optimal performance when connecting to databases through Tableau Server or Desktop environment -Provided technical support on existing dashboards and reports by troubleshooting issues related to data accuracy or report functionality Alteryx and Cloud Developer SunTrust Bank 03/2017 to 03/2018
-Developed comprehensive and insightful reports using Python, SQL, and Azure Data Factory -Designed and developed workflows automating data integration and transformation using Alteryx Designer -Enhanced workflows with custom functions and advanced analytics using Python scripting - Optimized data sources for Alteryx workflows using SQL -Delivered end-to-end data solutions combining multiple data sources for actionable insights Report Developer Hilton Grand Vacations 11/2014 to 02/2017
-Developed complex SQL queries to generate reports from multiple data sources -Created report templates for management and executive level stakeholders in SSRS -Collaborated with business users to define reporting requirements, design and develop dashboards -Designed and developed ETL processes using SSIS to move data between different databases and servers -Optimized existing reports by improving query performance and reducing execution time
Database Analyst NBC Universal 06/2011 to 11/2014
-Developed and maintained database tables, views, stored procedures, and functions -Analyzed data requirements, designed logical and physical databases, and implemented systems to store data -Created complex SQL queries for reporting purposes -Implemented new features and functionality into existing databases as required by business needs -Provided technical support for existing applications with regards to database design and implementation
EDUCATION
SSIS Master Class Workshop
Pragmatic Works
04/2014 to 04/2014
Advanced SSIS, ETL data warehouses, performance tune SSIS, Advanced data cleansing patterns, Scripting in SSIS, De-duplicating data with fuzzy logic, implementing an SSIS continued education framework. BI Boot Camp
Pragmatic Works
06/2013 to 06/2013
SSIS, SSRS, SSAS, MDX, DAX Data Model & ETL, Cubing with SSAS Multidimensional, Power Pivot / Tabular, Presentation Layer data warehouse and KPIs.
AS Degree in Computer Science
Full Sail Edu
01/1999 to 06/2013
SKILLS
Problem Solving ETL Processes JavaScript
SSIS Data Pipelines Hadoop
Python SQL SSRS
Kafka SSAS ETL / ELT
Airflow Snowflake Redshift
BigQuery Azure Data Factory Databricks
AWS Glue Tableau Git / Version Control
Data Modeling Data Quality Automation
Performance Tuning DevOps / DataOps
Contact this candidate