Senior Data Engineer & Business Intelligence

Michael Swanson

Clayton, IN • 317-***-****

*******@***.***

LinkedIn: www.linkedin.com/in/mike-swanson-667b499

SENIOR DATA ENGINEER

Senior Data Engineering and Business Intelligence professional with 20+ years of experience designing enterprise data solutions, developing scalable SQL-based applications, and delivering executive reporting and analytics. Expertise includes data warehousing, ETL development, SQL Server, Oracle, Azure Data Factory, Power BI, Tableau, and enterprise data governance. Proven success playing a key role in ERP migration initiatives, optimizing database performance, improving data quality, and partnering with executive leadership to transform complex business data into actionable insights. Strong background designing enterprise reporting solutions, data models, and cloud-based integration pipelines that improve operational efficiency and support strategic decision-making.

CAREER HIGHLIGHTS

More than 20 years of experience delivering enterprise data engineering and business intelligence solutions.

Played a key role in enterprise ERP data migration from Vista SQL Server to Oracle Fusion.

Directed Oracle 11g to Oracle 12c migration for a statewide government agency.

Designed executive Power BI dashboards supporting KPI-driven decision-making.

Developed enterprise ETL processes using SSIS and Azure Data Factory.

Extensive experience with SQL Server, Oracle, Azure, Power BI, Tableau, Informatica, and enterprise reporting platforms.

Strong history of improving data quality, database performance, and reporting efficiency.

TECHNICAL SKILLS

Data Engineering & Architecture

Data Engineering

Data Architecture

Data Warehousing

Data Modeling

Data Governance

Data Integration

ETL / ELT Development

Data Lakes

Data Quality

Relational Databases

Databases

Microsoft SQL Server

Oracle Database

Oracle PL/SQL

Netezza

SQL Development

T-SQL

PL/SQL

Stored Procedures

Query Optimization

Performance Tuning

Database Administration

Cloud & Integration

Azure Data Factory

Oracle Fusion

Informatica

GitKraken

Business Intelligence

Power BI

Tableau

Business Objects

Crystal Reports

WebFocus

SSRS

Microsoft SQL Server Technologies

SSMS

SSIS

SSRS

Methodologies

Agile

Requirements Gathering

Stakeholder Management

Project Management

Process Improvement

KPI Development

Cross-functional Collaboration

PROFESSIONAL EXPERIENCE

Senior Systems Engineer

MasTec Indianapolis, IN

February 2022 – Present

Lead enterprise data engineering initiatives supporting executive leadership through Power BI dashboards, KPI reporting, and advanced analytics.

Design, develop, and optimize SQL Server solutions for enterprise reporting and operational intelligence.

Build scalable ETL processes and data pipelines using Azure Data Factory and SQL Server technologies.

Develop complex SQL queries, stored procedures, and database objects supporting enterprise reporting and application integration.

Partner with executive leadership to define KPIs, monitor operational performance, and identify business improvement opportunities.

Design and maintain enterprise data models supporting reporting, analytics, and business intelligence initiatives.

Improve data integrity through data validation, governance practices, and process optimization.

Manage enterprise data access, ensuring security, compliance, and timely delivery of business-critical information.

Played a key role in SQL data migration efforts supporting the transition from Vista ERP (SQL Server) to Oracle Fusion.

Collaborate with cross-functional business and technical teams to deliver high-quality enterprise data solutions.

Environment: SQL Server, T-SQL, Azure Data Factory, Oracle Fusion, Power BI, SSMS, GitKraken

Senior Data Analyst / Database Administrator

Indiana Department of Environmental Management (IDEM) Indianapolis, IN

April 2020 – February 2022

Led enterprise Oracle database migration from Oracle 11g to Oracle 12c with minimal operational disruption.

Improved database performance through SQL optimization, indexing strategies, and backend tuning, increasing application performance by approximately 10%.

Coordinated migration planning, testing, deployment, and production implementation across multiple technical teams.

Administered Oracle databases supporting mission-critical environmental applications.

Developed SQL scripts supporting system maintenance, reporting, and operational analytics.

Assisted application development teams with database design, troubleshooting, and performance optimization.

Environment: Oracle 11g, Oracle 12c, PL/SQL, SQL, Database Administration

IT Consultant

Abbtech Indianapolis, IN

October 2019 – March 2020

Provided consulting services supporting enterprise technology deployments and infrastructure modernization.

Managed installation, configuration, and deployment of Dell workstation environments.

Supported operating system upgrades and enterprise technology rollouts.

Assisted clients with hardware lifecycle management and technology transition initiatives.

Environment: Windows, Dell Enterprise Hardware

IT Director

Theoris Indianapolis, IN

March 2019 – September 2019

Directed IT operations, infrastructure management, and project execution.

Managed SQL Server environments supporting ERP applications and enterprise reporting.

Oversaw server modernization initiatives that improved infrastructure reliability.

Supported Tableau reporting solutions for executive and operational analytics.

Managed vendor relationships, technology planning, and IT operational priorities.

Environment: SQL Server, ERP Systems, Tableau, Windows Server

Data Warehouse Engineer

NextGear Capital Carmel, IN

March 2015 – March 2019

Designed and maintained enterprise data warehouse solutions supporting business intelligence initiatives.

Developed SSIS ETL packages to automate data integration across multiple enterprise systems.

Built scalable SQL Server data marts supporting enterprise reporting and analytics.

Optimized ETL performance, improving data reliability and processing efficiency.

Collaborated with business stakeholders to translate reporting requirements into technical solutions.

Developed SQL Server reporting datasets and database objects supporting enterprise reporting.

Environment: SQL Server, SSIS, SSRS, T-SQL, Data Warehouse, ETL

Senior Data Analyst

MISO Carmel, IN

May 2008 – March 2015

Developed Oracle PL/SQL packages supporting enterprise reporting applications.

Managed Informatica workflows for loading enterprise data into Netezza warehouse environments.

Created business intelligence dashboards and reports using Tableau and Crystal Reports.

Supported enterprise reporting solutions through SQL development and database optimization.

Partnered with business users to deliver analytical reporting solutions supporting operational decision-making.

Environment: Oracle, PL/SQL, Informatica, Netezza, Tableau, Crystal Reports

Senior SQL Server Database & Reporting Analyst

Multiple Organizations

2000 – 2007

Administered enterprise Microsoft SQL Server environments supporting healthcare and corporate operations.

Designed and optimized SQL databases for reporting, analytics, and operational applications.

Developed stored procedures, views, functions, and complex SQL queries.

Built enterprise reporting solutions using Crystal Reports and SQL Server Reporting Services.

Performed database performance tuning, backup strategies, upgrades, and troubleshooting.

Partnered with business users to deliver custom reporting and data analysis solutions.

Environment: SQL Server, T-SQL, Crystal Reports, SSRS, SSMS

EDUCATION

Bachelor of Science – Information Systems

Database Management & Engineering

Liberty University – Lynchburg, Virginia

Associate of Science – Network Engineering Technology

Seminole State College – Sanford, Florida

CERTIFICATIONS

Microsoft Certified Solutions Associate (MCSA): SQL Server 2016 Database Administration

Contact this candidate