Summary
Overview
Work History
Education
Skills
Timeline
Generic

ABRHAM A. WORABO

Summary

With more than 6 years of experience, I have a strong background in data engineering and software development projects. My expertise encompasses all phases of the Software Development Life Cycle, including requirements gathering, development, implementation, testing, and support. I have worked on multiple hands-on projects involving data engineering and software development, where I have demonstrated my ability to handle complex data challenges and deliver efficient solutions. In my previous roles, I have played a key part in designing and implementing data pipelines, optimizing data storage and retrieval processes, and ensuring data quality and consistency across various systems. I have a deep understanding of data warehousing techniques, relational and dimensional data modeling, and have created efficient data manipulation strategies. I have developed and maintained a variety of data reports and visualizations, collaborating with stakeholders to translate business needs into actionable insights. My experience includes creating and managing efficient data migration processes, scheduling data workflows, and handling large-scale datasets to support business intelligence and decision-making. As an experienced software developer, I have written and debugged complex stored procedures and SQL queries, designed and implemented data structures, and managed performance optimization efforts. My project management skills have allowed me to successfully navigate both agile and waterfall methodologies, driving and maintaining scrums and sprints. My work has been focused on delivering high-quality solutions that meet and exceed business objectives, and I continually seek to stay up-to-date with the latest advancements in data engineering and software development to provide innovative and efficient results.

Overview

8
8
years of professional experience

Work History

Sr. Data Engineer

MRO Corp.
10.2021 - Current
  • Engaged directly with senior stakeholders, including the VP-level and C-suite stakeholders, to align technology solutions with strategic business needs, ensuring projects deliver value and meet stringent budgetary and timeline constraints
  • Led a team of BI developers, overseeing end-to-end project management, from gathering requirements with business SMEs and senior finance leaders to designing, budgeting, and delivering various BI initiatives
  • Pioneered the implementation of automation and integration solutions, including email-triggered workflows and cloud-based data synchronization, leveraging Power Apps and .NET technologies to optimize operational efficiency
  • Participated in a project focused on developing and deploying predictive machine learning models using PySpark and Azure MLFlow, which revolutionized business processes by boosting profitability and operational efficiency through data-driven decision-making
  • Spearheaded the development and automation of data interfaces and pipelines using Microsoft Azure, Azure Data Factory, Big Query (GCP) and SSIS, including complex ETL processes for financial data integration from ERP systems to Azure DB and on-premise SQL Server databases
  • Designed and implemented advanced processes for data governance and code lifecycle, including transitioning projects from development through UAT to production, and automating data flows and notifications with Power Automate, Power Apps, and custom Python scripts
  • Guided the BI team in data testing, quality assurance, and the development of Power BI and Tableau reports, enhancing data accuracy and accessibility, while preparing and reviewing comprehensive technical documentation
  • Developed and maintained robust data management practices, integrating data from diverse sources including SOAP and OData APIs, and ensuring data integrity through comprehensive QA processes
  • Fostered a culture of excellence within the BI team, mentoring developers in best practices for data governance, report development, and automated testing, enhancing team capabilities and project outcomes

Data Engineer II

FedPoint Systems LLC
12.2021 - 12.2023
  • Collaborated with business SMEs and terminology teams to gather requirements, leading the design and development of ETL pipelines to support NIH’s BTRIS program, enhancing data handling and usability
  • Engineered automated solutions for data integration, using SSIS packages to streamline data extraction, transformation, and loading processes from over 50 data sources into staging and production environments
  • Implemented automation for manually triggered pipelines and created SQL Agent jobs to manage various data processes, improving reliability and efficiency of data operations
  • Developed an ETL pipeline for the Observational Medical Outcomes Partnership CDM (OMOP) Common Data Model, ensuring adherence to OHDSI standards, conducted thorough code reviews, built unit tests, and ensured end-to-end data pipeline integrity
  • Prepared detailed technical documentation and conducted hotfixes and updates to existing systems, ensuring high-quality data delivery and continuous process enhancement

Sr. Data Engineer

Sirius XM Washington DC
01.2020 - 10.2021
  • Actively engaged with SMEs to understand project scope, discuss business requirements, and develop Functional Requirement Documents (FRD), ensuring alignment with business goals
  • Designed and implemented SQL Server Integration Services packages for data warehousing, and managed complex data migrations across multiple environments, including on-premise to AWS cloud infrastructures
  • Developed diverse forms of reports and dashboards using Tableau and TIBCO Spotfire, including visualizations for AWS cost breakdowns and utilization, presented to upper management
  • Spearheaded the automation of queries, setup of triggers, and scheduling systems to enhance operational efficiency
  • Designed Terraform scripts for AWS EMR clusters to automate and optimize resource use, and prepared comprehensive test cases and documentation to ensure solution integrity
  • Contributed to application development with solutions for emerging issues, built robust data pipelines with quality metrics checks before staging, and utilized Spark and Scala for processing large datasets in Hadoop environments

Sr. ETL Software Engineer

Laureate International Universities
Columbia, MD
01.2019 - 01.2020
  • Collaborated with SMEs and internal customers to understand project requirements within an Agile development framework, and played a key role in the logical and physical modeling of databases, including dimensional modeling for data warehousing
  • Supported production job executions and worked alongside Business Systems Analysts to refine specifications, ensuring database constraints were met and conducting impact analyses on proposed changes
  • Developed and maintained database integrity through normalization, referential integrity, and T-SQL elements like Stored Procedures, Triggers, and Functions
  • Extracted and transformed data from diverse sources using tools like SSIS, Informatica Cloud, and Snowpipe
  • Created Cognos Framework Manager Models to facilitate report generation and implemented CI/CD pipelines using GitHub, Snowflake, and PowerShell scripts to streamline deployments and ensure consistency across development stages
  • Prepared test cases and detailed documentation for both existing and new solutions to ensure compliance with technical requirements and support seamless project transitions

ETL Data Warehouse Developer

Cigna
Philadelphia, PA
10.2017 - 10.2019
  • Led the planning, definition, and design of databases tailored to business analytics needs, assisting DBAs in developing and validating BI solutions including reports, dashboards, KPIs, and alerts
  • Utilized Teradata for complex data management tasks
  • Conducted detailed Joint Requirement Development (JRD) sessions to analyze database requirements, and designed conceptual, logical, and physical data models using MS Visio, including Star and Snowflake Schemas for Data Marts
  • Developed shell scripts to automate repetitive database processes, created SSIS packages for database maintenance and security tasks, and implemented robust security measures including authentication and cell-level security in SSAS cubes
  • Managed the deployment of SSIS packages, scheduled jobs across development, integration, UAT, and production environments, and optimized stored procedures and user-defined functions to enhance performance and simplify reporting

Education

Bachelors -

Engineering
Hawassa, Ethiopia
01.2016

Skills

  • Cloud platforms: AWS, Microsoft Azure and Google Cloud
  • Agile project management
  • API development and integration
  • Advanced SQL and RDBMS
  • Data migration and ETL processes
  • Business intelligence and analytics
  • Data quality assurance
  • Machine learning and big data technologies
  • Team leadership and collaboration
  • Decision-making and problem-solving
  • AWS/Azure services management
  • SDLC best practices
  • Data visualization techniques
  • BI architecture design

Timeline

Data Engineer II

FedPoint Systems LLC
12.2021 - 12.2023

Sr. Data Engineer

MRO Corp.
10.2021 - Current

Sr. Data Engineer

Sirius XM Washington DC
01.2020 - 10.2021

Sr. ETL Software Engineer

Laureate International Universities
01.2019 - 01.2020

ETL Data Warehouse Developer

Cigna
10.2017 - 10.2019

Bachelors -

Engineering
ABRHAM A. WORABO