Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
References
Timeline
Generic

Anthony Hampton

Lake Charles

Summary

Skilled Data Warehouse Engineer with background in designing, implementing, and maintaining data warehousing solutions. Strengths include knowledge of ETL processes, database design principles, and advanced SQL skills. Past work includes successful efforts to optimize system performance and improve data quality. Demonstrated ability to collaborate effectively with cross-functional teams and deliver value through innovative technical solutions.

As a Data Engineer I’ve had successful design and implementation of cutting-edge data warehousing solutions. Have consistently delivered robust ETL processes and seamless RESTful API integrations, utilizing a blend of technologies such as SSIS, Python, SQL and PySpark. Adept at automating workflows, played a crucial role in refining data pipelines, ensuring system efficiency and reliability. Project management and collaborative efforts are the cornerstones of my approach, focusing on delivering real-time reporting solutions and optimizing system interoperability. Ensuring data integrity by moving data through DEV, QA and Production environments. With my hands-on experience in data loading, I have helped to maintain the agility needed in today's data-driven landscape, ensuring that stakeholders are equipped with the most relevant and actionable insights.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Data Warehouse Engineer

Greystone
11.2021 - 01.2025
  • Designed and implemented modern data warehousing solutions leveraging Microsoft Fabric for scalable data integration and storage
  • Developed and optimized ETL processes using SSIS, Python, PySpark, and Biml to ensure seamless data transformation and integration
  • Built and consumed REST APIs for data exchange and system interoperability, enabling efficient and secure communication between systems
  • Automated workflows and maintained data pipelines across various projects to improve system reliability and efficiency
  • Designed and maintained SQL-based reporting solutions, ensuring real-time data availability for stakeholders
  • Managed multiple projects simultaneously, focusing on quality, deadlines, and collaboration with cross-functional teams
  • Investigated existing databases and identified areas where improvements can be made in terms of performance or scalability.
  • Created and maintained a library of reusable SQL code components to facilitate rapid development of new ETL processes.
  • Optimized query performance using indexing strategies while ensuring compliance with security policies.

SQL Developer

Lake Charles Memorial Hospital
10.2014 - 11.2021
  • Built a pure HTML and JavaScript website integrated with a C# Web API for emergency downtime scenarios
  • Designed and implemented a complete database structure, including tables, stored procedures, and SQL jobs for data tracking and reporting
  • Developed SQL jobs to cache data for UI controls, enhancing application performance and real-time updates
  • Integrated UI testing with Web API JSON responses using Postman
  • Designed SQL and SSIS-based processes for automated notifications via email and fax
  • Transformed XML data into HTML for attachment delivery using a ZetaFax integration
  • Developed SSRS reports for detailed tracking and movement of notifications
  • Created a WinForm application for tracking patient billing information
  • Built and optimized SQL stored procedures and integrated them into a C#-based data access layer
  • Designed a dynamic UI with CRUD functionality for detailed patient tracking

C# Full Stack Developer (Systems Analyst)

Foxconn
08.2012 - 09.2014
  • Developed a .NET application for managing and displaying electronic SOPs
  • Integrated user notifications for SOP approvals and status changes
  • Worked as a full-stack developer on warehouse distribution applications and hardware integrations
  • Created reports and handled TFS source control for the development team

Education

Some College (No Degree) -

ITT Technical Institute
Virginia Beach, VA

Skills

  • Databricks
  • Microsoft Fabric
  • ETL development
  • SQL optimization
  • Data pipeline automation
  • REST API development
  • Performance tuning
  • Technical documentation
  • Python programming
  • Master data management
  • NET
  • Data analysis
  • API development
  • Indexing strategies
  • SQL programming
  • Data modeling
  • Data pipeline development
  • PySpark
  • JavaScript
  • T-SQL
  • SQL Server
  • SSIS
  • SSRS
  • Biml
  • C#
  • HTML5
  • CSS
  • JQuery
  • ASPNET
  • REST APIs
  • Visual Studio
  • SSMS
  • Postman
  • GITHub
  • Database design
  • Data integration
  • Debugging
  • Reporting

Accomplishments

United States Navy, Damage Controlman (E5), 04/01/01 - 04/01/05

Certification

  • Databricks

References

References available upon request.

Timeline

Data Warehouse Engineer

Greystone
11.2021 - 01.2025

SQL Developer

Lake Charles Memorial Hospital
10.2014 - 11.2021

C# Full Stack Developer (Systems Analyst)

Foxconn
08.2012 - 09.2014

Some College (No Degree) -

ITT Technical Institute
Anthony Hampton