Adebola Durojaiye

Columbus, Ohio *****

Summary

Data engineer seeking to leverage 2+ years of experience in building data pipelines to contribute to the

Acme Corp mission of making payments easy and accessible for small businesses across the world.

Technical Skills

AWS (Athena, Lambda, S3)

SQL (Postgres, Redshift, MySQL), NoSQL (MongoDB)

ETLs

Python

Azure Data Factory, Data Lake.

Azure Databricks, Azure SQL database, Azure SQL Datawarehouse.

Data Visualization

Data Migration

Power Bi.

Azure Blob storage

Professional Experience

US National Guard Kettering, Ohio March 2020 - Present

Data Engineer

Constructed a data pipeline to process semi-structured data by incorporating 100 million raw records

from 14 data sources.

Oversaw the migration from Oracle to Redshift, saving $750,000 in 2019 with a performance increase of 14%.

Designed the data pipeline architecture for a new product that quickly scaled from 0 to 60,000 daily users

Integrated data from multiple third-party APIs that provided data around local language preferences, leading to customized landing pages that improved paid conversion rate by 6%

Led a team of 1 full-time employee and 3 contractors, and frequently collaborated with project managers and analysts

Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.

Azure Data Factory (ADF), Integration Run Time (IR), File System Data ingestion, Relational Data Ingestion.

Design and developed ETL mapping for data collection from various data feed using Python.

The data sources include feeds from mobile, social Facebook Query language YouTube, Twitter and various partner feeds.

Designed the data pipeline architecture for a new product that quickly scaled from 0 to 125,000 daily active users

Automated ETL processes across billions of rows of data, which reduced manual workload by 29% monthly

Ingested data from disparate data sources using a combination of SQL, Google Analytics API, and Salesforce API using Python to create data views to be used in BI tools like Tableau

Designed and implemented a real-time data pipeline to process semi-structured data by integrating 150 million raw records from 30+ data sources using Kafka and PySpark

Worked with client to understand business needs and translate those business needs into actionable reports in Tableau, saving 17 hours of manual work each week.

Maintained data pipeline up-time of 99.8% while ingesting streaming and transactional data across 8 different primary data sources using Spark, Redshift, S3, and Python

Built basic ETL that ingested transactional and event data from a web app with 12,000 daily active users that saved over $85,000 annually in external vendor costs

Integrated data from multiple third-party APIs that provided data around local language preferences, leading to customized landing pages that improved paid conversion rate by 6%

Designed the data pipeline architecture for a new product that quickly scaled from 0 to 60,000 daily users

Automated ETL processes across billions of rows of data, which saved 45 hours of manual hours per month.

Solid knowledge on big data framework: Hadoop, HDFS, Apache Spark, Hive, Map/Reduce and Sqoop etc

Excellent communication skills, with the ability to work and contribute to a collaborative working culture

Demonstrable knowledge of Continuous Integration/Test Driven Development and Code Analysis including its application within the software development lifecycle

DreamNet Technologies Columbus, Ohio June 2015 - March 2020

Technical Support Analyst

Test software performance throughout the network to ensure peak performance.

Installation and maintenance of LAN.

Assist end users in caring out their daily task via effective communication and observation.

Resolve ticket issues remotely using SCCM and in person visit when needed.

Provide technical support for software integrations to aid in function customization.

Install computer hardware and software on workstations to keep version current.

Remote view and control for troubleshooting, executing remote actions such as remote wipe and lastly mobile content.

Analyses utilization and performance whilst coordinating nation-wide printer rollout for new and existing projects.

Monitors the performance of computer systems and address issues as they arise.

Assist end users in caring out their daily task via effective communication and observation.

Resolve ticket issues remotely using SCCM and in person visit when needed.

System One Houston, Texas May 2015 - April 2016

Travelling Support Engineer

Monitoring and building of Scada.

Documentation of any fault.

Report of daily performance of every machine.

Education

Mapoly - B.S., Accounting

January 2007 - September 2011 Nigeria

Relevant courses

Microsoft Azure Fundamentals (April 2021).

Microsoft Azure Virtual Desktop Specialty (April 2022).

Microsoft Certified Power BI Data Analyst Associate (2022).

CompTIA Security Plus (May 2022).

Google IT Support Professional Certificate (2022).

Contact this candidate