Hello. I'm Devodriq Roberts.

AUG 2023 - AUG 2024

IT Associate, Data Analytics Engineer, Hennessy Auto Group

Atlanta, GA

Hennessy Automobile Companies represents eleven brands in ten locations around the Metro Atlanta area.

• Automated ETL pipelines and reduced manual efforts by 60% by designing, refactoring, and implementing workflows using Knime, aligning data processes with business objectives and improving data reliability, consistency, and scalability within one quarter.
• Reduced human error by 30% across key processes by collaborating with cross-functional teams to gather requirements, develop proof-of-concept ETL solutions, and iteratively deploy automated workflows, improving efficiency and accuracy in data handling.
• Enhanced data security and resilience against threats by encrypting PII, reviewing configurations, and implementing MFA, proactively addressing vulnerabilities following a ransomware attack on the automotive industry.
• Improved pipeline scalability and reduced redundancy by 40% by designing and implementing reusable ETL components, streamlining development and maintenance for evolving data needs.

JUL 2021 - MAY 2023

Sr. Analytics Data Administrator, CareerBuilder

Atlanta, GA

A job board and human resources software company that leverages vast amounts of data to connect job seekers with employers and provide data-driven insights for talent acquisition and workforce management.

• Reduced administrative effort by 40% by automating Tableau reporting and permission changes using Python, shell scripting, and the Tableau API, streamlining access management processes in three weeks.
• Improved report load times by 50% by optimizing business intelligence processes with Knime, Python, and Tableau, enabling faster data retrieval and more efficient stakeholder access to insights.
• Reduced stale content by 20-25% and improved server performance by archiving low-usage, irrelevant, or legacy Tableau content, ensuring users had access to relevant and up-to-date insights.
• Mitigated data exposure and ensured secure access by creating custom fields in Tableau that restricted views based on stakeholder-defined criteria, ensuring only authorized users accessed sensitive information.
• Improved user access efficiency for 500+ users by managing and auditing Tableau Server permissions, ensuring alignment with security policies and streamlining access control.

Dec 2019 - JUL 2021

Data Analytics Engineer, LeaseQuery

Atlanta, GA

A lease accounting software company that handles vast volumes of data to streamline lease management and financial reporting processes for organizations.

• Enhanced data integration and processing efficiency by developing analytics solutions with Apache Airflow, Fivetran, and Snowflake, optimizing data pipelines and automating workflows to support business insights.
• Improved scalability and data accessibility by integrating data from various SaaS platforms into Snowflake, streamlining workflows and enabling efficient analytics across the organization.
• Reduced report load times by 30% by optimizing SQL queries and refining Tableau extracts, improving data retrieval efficiency and enhancing the user experience.

JAN 2017 - DEC 2019

Mechanical Engineer, Textron

Augusta, GA

A Global multi-industry company that leverages extensive data analytics to drive innovation, efficiency, and informed decision-making across its diverse portfolio of businesses.

• Saved $80K and improved inventory management by building a Django-based web application to streamline SAP ERP data sharing, reducing manual effort and enabling timely decision-making over two months.
• Reduced manufacturing costs and enhanced production efficiency by designing optimized mechanical components and assemblies using Siemens NX CAD, improving manufacturability and product quality.

Cloud Infrastructure, Independent Project

AWS Serverless Hosted Resume Website

• Deployed a scalable serverless website using AWS S3, Route 53, CloudFront, API Gateway, and Lambda, providing a highly available, cost-effective solution for resume hosting. Visit at:
• Implemented Infrastructure as Code (IaC) using Terraform, automating the deployment and management of cloud infrastructure, which improved efficiency and scalability.

Hashnode Blog
GitHub Code
Docker Hub

Cloud Infrastructure, Independent Project

Auto-Scaling AWS Infrastructure Deployment

• Architected and deployed an auto-scaling infrastructure using AWS services including S3, Route 53, CloudFront, API Gateway, Lambda, and DynamoDB, which enhanced workload management efficiency.
• Implemented Infrastructure as Code (IaC) with Terraform to automate the deployment process, resulting in improved scalability and availability of the infrastructure.
• Optimized system design for scalability and performance, demonstrating adaptability and resourcefulness in managing cloud resources and ensuring seamless system operations.

Cloud Solutions, Independent Project

Containerized Web Application w/ Docker

• Designed and built a containerized environment for a web application using Docker, deploying and managing containers with Docker Swarm for effective orchestration.
• Implemented a Drupal frontend with a PostgreSQL database backend on DigitalOcean, optimizing the deployment process and enhancing application scalability.
• Achieved a scalable and easily deployable web application environment, significantly improving application deployment processes and consistency while deepening knowledge of containerization and orchestration.

Hashnode Blog

AWS Data Engineering, Independent Project

Zillow Real Estate ETL Pipeline with AWS Glue & Terraform

• Developed an automated ETL pipeline for Zillow data, streamlining extraction and loading to S3.
• Implemented Infrastructure as Code (IaC) with Terraform, ensuring consistent deployment and scalability.

GitHub Code

Azure Data Engineering, Independent Project

Formula1 Data ETL w/ Azure Databricks and Data Factory

• Architected and implemented an ETL solution for Formula1 race data, utilizing Azure Databricks and Azure Data Factory to streamline data ingestion and transformation.
• Orchestrated data pipelines with Azure Data Factory, ingesting various file types from the Ergast API, and leveraged Azure Databricks and PySpark for advanced data processing and transformation.
• Managed data storage and access using Azure Data Lake Storage Gen2 and Delta Lake format, improving data processing efficiency and scalability.
• Successfully ingested and transformed large datasets, enhancing expertise in Azure cloud services and big data processing tools.

GitHub Code

Flask REST API (Backend Web Application), Independent Project

Flask Web Store REST API

• A professional REST API with Python, Flask, Docker, Flask-Smorest, and Flask-SQLAlchemy. This project was an opportunity to dive deeper into scalable API development, containerization, and database management, all while adhering to industry best practices.
• 🖥️ Flask framework for building robust RESTful APIs.
• 🛠️ Flask-Smorest for clean API creation with built-in schema validation.
• 📊 Flask-SQLAlchemy to handle database interactions efficiently.
• 🐳 Docker for containerized development and seamless deployment.
• 🔐 JWT Authentication for secure API access and user management.
• 🗃️ Working with PostgreSQL/SQLite for persistent data storage.

GitHub Code

Algorithmic Trading Bot Development, Independent Project

Freqtrade Bot Project

• This is an algorithmic trading bot built using the open-source Freqtrade platform. The bot is designed to automate cryptocurrency trading by executing pre-configured trading strategies based on market conditions.
• Integrated custom technical indicators and strategies using **Python**, enhancing the bot's decision-making capabilities and improving profitability by adapting to various market conditions.
• Configured API connections to multiple cryptocurrency exchanges, enabling real-time market data collection and execution of trades with minimal latency.
• Implemented backtesting functionality to evaluate the performance of trading strategies on historical data, optimizing for risk management and profit maximization.

GitHub Code

API Development, Independent Project

NodeJS Task Manager App

• This is a task management application built as part of Andrew Mead's The Complete Node.js Developer Course (3rd Edition). The app allows users to create, update, delete, and manage tasks while demonstrating the use of modern Node.js features, including Express, MongoDB, and JWT authentication.
• Developed a robust authentication system using JWT tokens to ensure secure access to user accounts and tasks, with hashed passwords stored securely using bcryptjs.
• Built a RESTful API for managing user tasks, supporting full CRUD operations (Create, Read, Update, Delete), optimizing database interactions with MongoDB and ensuring efficient performance with Mongoose.
• Successfully implemented file upload functionality using Multer, allowing users to upload profile pictures while ensuring input validation with Validator.js for better user experience and data integrity.

GitHub Code

Web Scraping Project, Independent Project

Scrapy, Splash, Selenium Web Scraping Project

• Developed a robust web scraper utilizing **Scrapy**, **Splash**, and **Selenium** to efficiently extract data from dynamic web pages, handling JavaScript-rendered content.
• Integrated rotating proxies and user-agent management to bypass anti-scraping mechanisms, allowing the scraper to access and retrieve large datasets without being blocked.
• Built an automated data pipeline with **PostgreSQL** to store extracted data, ensuring clean and organized storage for future analysis and reporting.
• Implemented advanced error handling and retry mechanisms to ensure scraping operations remain robust even when encountering CAPTCHA challenges or timeouts.

GitHub Code

Front-End Development, Independent Project

React Application with Hooks and Redux

• Built a dynamic and interactive front-end web application using **React**, leveraging modern features such as **Hooks** and **Redux** for efficient state management and improved performance.
• Integrated **Redux** for global state management, allowing seamless data flow between components and improved user experience through optimized rendering.
• Utilized **React Router** for client-side routing, enabling users to navigate through different pages of the app without reloading, ensuring a smooth user experience.
• Enhanced the app's interactivity and responsiveness by incorporating **React Hooks** for handling component state and side effects more efficiently.

GitHub Code: Expensify-react

GitHub Code: Indecision

Security Response, Independent Project

Splunk Instance on Localhost

• Developed advanced security monitoring solutions using Splunk, SQL, and Python on a Raspberry Pi Linux platform, enhancing real-time data analysis and threat detection capabilities.
• Applied statistical techniques and automation within Splunk, improving the accuracy and efficiency of security event monitoring.
• Enabled Splunk functionalities including SPL, dashboards, and alerts, significantly improving the ability to detect, analyze, and respond to security incidents.

Network Security, Independent Project

Network Monitoring and Intrusion Detection System (IDS)

• Deployed and configured IDS systems using Snort, Suricata, and Tshark on Ubuntu, enhancing network security and improving threat detection by automating real-time monitoring.
• Deployed detection rules and automated monitoring processes, increasing the accuracy and speed of threat identification and response.

Hashnode Blog

Network Detection, Independent Project

Blue Team Detection Virtual Home Lab

• Designed and configured a virtual network detection lab using VMWare, integrating PfSense as a firewall/router and Snort for intrusion detection, enabling in-depth network traffic analysis with Wireshark.
• Executed real-time security monitoring and analysis, applying blue team techniques to detect and mitigate network threats, enhancing cybersecurity response capabilities.