Summary
Overview
Work History
Education
Skills
Timeline
Generic

Henry Tuffuor

Columbia,MD

Summary

Experienced data analyst with over 7 years of expertise in Data Analytics, Engineering and Business Intelligence. Adept at delivering impactful insights in the healthcare, bank and insurance domains through a combination of technical proficiency and exceptional communication skills. Passionate about leveraging data to drive business growth and profitability. Skilled in collaborating with cross-functional teams to develop innovative solutions and strategies that exceed expectations. I am a team player who values communication and collaboration and is always willing to work efficiently with diverse groups. With a strong work ethic, I am eager to take on new challenges and contribute to the success of the organization.

Overview

7
7
years of professional experience

Work History

Senior Data Engineer/Analyst

LifeBridge Health
Baltimore, MD
09.2021 - 09.2024
  • Designing, developing, and modifying data pipeline infrastructure to expedite data analysis and reporting
  • Implementing end-to-end delivery of Azure and Snowflake data solutions that includes building, managing, and optimizing data pipelines across environments; curating and modeling the data for various types of consumers/products and their pattern of usage to include data marts, data lake, and operational analytics applications
  • Designing and developing databases that are compatible with company needs in snowflake
  • Developing data pipeline for continuous data ingestion into snowflake data warehouse from custom OLTP systems using Coalesce data integration tool
  • Designed and developed ETL pipelines using Azure Data Factory, effectively transforming raw data into actionable insights
  • Collaborated closely with data architects and analysts to define data models, ensuring alignment with business goals
  • Pioneered the implementation of Git-based version control within the Azure ecosystem, promoting collaboration and stability
  • Engineered data workflows within Azure services, optimizing data transformation processes and fostering collaboration within the data team
  • Collaborated closely with data architects and analysts to define data models and optimize data transformation processes using dbt

Data Engineer

Citizens Bank
Boston, MA
07.2019 - 07.2021
  • Engineered end-to-end data solutions on AWS, focusing on high-throughput data ingestion and integration using AWS Glue
  • Pioneered the adoption of modern data engineering methodologies, utilizing AWS Glue to orchestrate complex ETL workflows
  • Developed custom data processing scripts in Python, streamlining ETL workflows and improving overall efficiency
  • Collaborated with cross-functional teams to define data requirements and implemented dimensional data models
  • Spearheaded the implementation of a CI/CD pipeline using Jenkins, ensuring automated and reliable deployments
  • Designing, building and maintaining AWS Data Analytics solutions
  • Integrating AWS data services with other tools and platforms
  • Translating business requirements into system design specification to manage data pipelines
  • Designing, developing, and implementing data integration processes to transform unstructured and disparate source data into the target Data Stores, Data Warehouses and / or Data Marts
  • Overseeing implementation and maintenance of ELT processes that support feature development and testing
  • Monitoring ELT processes and implementing tuning as needed to address scalability, recoverability, and performance impediments
  • Designing and Implementing Data Pipelines: Create and manage data pipelines that ingest, transform, and store data
  • Utilize Databricks’ capabilities to process large datasets efficiently
  • Designing comprehensive data integration and ingesting pipeline from OLTP source systems into AWS Data Lake using Glue studio
  • Maintaining and improving existing continuous integration/delivery (CI/CD) pipelines
  • Using Snowpipe for continuous integration of S3 source data into snowflake data warehouse
  • Developing snow-sql to structure semi-structured files into a NoSQL tables in Snowflake data warehouse

Database Developer/Analyst

Humana Insurance
Louisville, KY
06.2017 - 06.2019
  • Designed and developed Database systems using SQL and Erwin Data Modeler
  • Developed and maintained documentation for all database-related activities
  • Created ETL packages leveraging SSIS for daily data ingestion
  • Tested system integrity, and implemented designs, application developments, and other processes related to infrastructure, making improvements as needed
  • Deployed product updates as required while implementing integrations when they arise
  • Created data models and designed database schemas
  • Developed database queries and stored procedures to support business needs
  • Collaborated with cross-functional teams to implement new database features and functionality
  • Troubleshooting: Diagnose and fix any issues that arise in data workflows or the Databricks

Education

Bachelor of Science - Computer Science

University of Science and Technology (KNUST)
Ghana

Skills

  • MS SQL Server
  • MySQL 52
  • MySQL 57
  • Oracle 9i
  • Oracle 10g
  • Oracle 11g
  • Db2
  • PostgreSQL
  • AWS RDS
  • Vertica
  • Snowflake
  • AWS S3
  • Azure
  • AWS Glue
  • Erwin Data Modeler
  • DBT
  • Azure Data Factory
  • ER Assistant
  • SQL Management Studio 2008
  • SQL Management Studio 2012
  • SQL Plus
  • SQL Developer
  • PL/SQL
  • PgAdmin 4
  • DB Visualizer
  • SQL
  • TSQL
  • SPL
  • Python
  • Tableau 91
  • Tableau 92
  • Tableau 102
  • Tableau 105
  • Tableau 20182
  • Tableau 20216
  • Power BI
  • Excel
  • PowerPivot
  • Swowsight
  • Qlikview

Timeline

Senior Data Engineer/Analyst

LifeBridge Health
09.2021 - 09.2024

Data Engineer

Citizens Bank
07.2019 - 07.2021

Database Developer/Analyst

Humana Insurance
06.2017 - 06.2019

Bachelor of Science - Computer Science

University of Science and Technology (KNUST)

Similar Profiles

CREATE PROFILE
Henry Tuffuor