Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Timothy Abraham

Timothy Abraham

Glen Allen

Summary

Experienced data engineering leader skilled in AWS, Terraform and Spark, dedicated to
optimizing workflows and ensuring data integrity. integrity. Proven ability in mentoring teams,
and enhancing performance through strategic improvements. Committed to delivering
high-quality data solutions, and supporting organizational success.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Manager - Data Engineer

CapTech Ventures Inc.
Richmond
08.2025 - Current
  • Consolidated multiple source tables into a single fact model using dbt.
  • Simplified and optimized procurement workflows by removing redundancy.
  • Validated schema changes and data integrity in Databricks.
  • Refactored and updated downstream dbt models impacted by changes.
  • Implemented dbt tests to ensure reliability and data quality.
  • Partnered with stakeholders to confirm business logic and reporting accuracy.
  • Coached, mentored and trained team members in order to improve their job performance.

Senior Consultant – Data Engineer

CapTech Ventures Inc.
Richmond
10.2022 - 08.2025
  • Designed and implemented a serverless, event-driven ETL framework in AWS, improving data scalability and efficiency.
  • Built and optimized batch data pipelines using AWS (S3, EventBridge, Lambda, Glue) to process end-of-day files efficiently.
  • Developed a real-time streaming pipeline by integrating Kafka with AWS Lambda (event source mapping) and Kinesis for live data analytics.
  • Implemented a monitoring solution with OpenSearch by leveraging EventBridge, Kinesis Firehose (with Lambda for data transformation), and OpenSearch for real-time observability.
  • Automated alerting system using SNS and Lambda by setting up an OpenSearch pipeline to detect critical events, optimize alert data via Lambda, and trigger SNS notifications to subscribed email recipients.
  • Co-developed an XML parser for migrating complex Informatica jobs to AWS Glue, streamlining ETL processes, and integrated it with AWS Bedrock for converting Informatica SQL to PySpark-compatible Glue scripts.
  • Developed and maintained Apache Airflow DAGs to orchestrate and schedule complex ETL workflows, ensuring reliability and scalability of data pipelines.
  • Mentored junior engineers, fostering technical growth and career development.
  • Led AWS study groups (2 years Solutions Architect, 1 year Developer), guiding 30+ individuals to certification.
  • Led the financial management and timekeeping for a 100+ consultant account, ensuring compliance, accuracy, and operational efficiency.
  • Assisted in drafting Statements of Work (SOWs) to define project scope and deliverables.

Senior Software Developer

Kinsale Insurance.
Richmond
03.2022 - 10.2022
  • Delivered high-quality code for Agile projects, ensuring alignment with business requirements.
  • Developed an Underwriter Worksheet application using Angular, Spring Boot, and AWS.

Senior Consultant – Data Engineer

CapTech Ventures Inc.
Richmond
07.2020 - 03.2022
  • Developed a Data Quality application using enterprise libraries for the client, ensuring high standards of data accuracy and integrity.
  • Deployed Hive SQL scripts to transform and load software vulnerability data for a nationwide bank, improving data processing efficiency.
  • Worked in Databricks to source and transform data, storing curated datasets in Snowflake for downstream analytics and powering executive dashboards in Amazon QuickSight.
  • Designed and deployed an AWS Glue ETL pipeline to ingest data from multiple S3 locations into Aurora DB, building the Terraform infrastructure and optimizing end-to-end data processing.

ASSOCIATE SOFTWARE DEVELOPER

Commonwealth Center For Advanced Manufacturing
Richmond
03.2020 - 07.2020
  • Design, Develop and Test Rest API's for new features in Node.js
  • Created proof-of-concept prototype data pipeline using Apache Nifi and Kafka for demonstration and evaluation purposes

Project Engineer - Full Stack Developer

Wipro Limited
Richmond
07.2017 - 03.2020
  • Developed and integrated tools for data migration, validation, and authentication, enhancing data management and security.
  • Improved user experience on EMR clusters by integrating Hadoop User Experience (HUE) for easier data analysis.
  • Automated testing of 1,300+ metrics on EMR clusters, ensuring optimal performance and reliability.

Business Systems Analyst

Empyrean Benefit Solutions
Houston
09.2016 - 07.2017
  • Processed data and managed ongoing activities.
  • Oversaw ACA Reporting, ensuring timely mailing of 85,000+ 1095 B/C forms.
  • Analyzed issues with SQL/Excel, implementing solutions to reduce case volume.
  • Developed and maintained test plans for new system features.

Education

Bachelor of Science - Computer Engineering

University of Houston-Clear Lake
Houston, TX
05.2016

Skills

  • ETL development
  • AWS architecture
  • SQL optimization
  • Cloud computing
  • Software development
  • Agile methodologies
  • Team mentorship
  • Project leadership
  • Financial records oversight
  • Data Quality Assurance
  • Real-Time Data Analytics
  • Continuous Integration/Deployment
  • Apache Airflow Management

Certification

AWS Certified Developer – Associate, DVA-C01

Timeline

Manager - Data Engineer

CapTech Ventures Inc.
08.2025 - Current

Senior Consultant – Data Engineer

CapTech Ventures Inc.
10.2022 - 08.2025

Senior Software Developer

Kinsale Insurance.
03.2022 - 10.2022

Senior Consultant – Data Engineer

CapTech Ventures Inc.
07.2020 - 03.2022

ASSOCIATE SOFTWARE DEVELOPER

Commonwealth Center For Advanced Manufacturing
03.2020 - 07.2020

Project Engineer - Full Stack Developer

Wipro Limited
07.2017 - 03.2020

Business Systems Analyst

Empyrean Benefit Solutions
09.2016 - 07.2017

Bachelor of Science - Computer Engineering

University of Houston-Clear Lake

Similar Profiles

CREATE PROFILE