Adrian Otieno
San Antonio
Summary
Data Engineer proficient in designing and implementing data modernization solutions that transformed complex datasets into analytics ready formats. Delivered robust ETL pipelines and executed exploratory analysis using Python to ensure data integrity and uncover insights. Passionate about utilizing Azure tools to drive impactful data solutions and enhance user engagement.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Engineer
SkillStorm
11.2025 - Current
- Designed and delivered a proof of concept data modernization solution for more than 50 GB of historical U.S. imports manifest data, transforming raw CSV exports from an automated manifest system into a cleaned, normalized, and analytics ready Conducted in depth exploratory analysis in Python to identify schema patterns and data quality issues across ports and commodities.
- Defined robust rules for managing nulls, malformed records, and outliers, and modeled the solution as a relational schema with an ERD.
- Profiled multi year shipment data using Python Pandas and NumPy to generate statistical summaries and detect anomalies.
- Designed and implemented a data cleaning methodology to standardize formats and enforce quality thresholds for completeness.
- Created a normalized database schema and ERD for shipments, ports, carriers, and commodities to enhance SQL analytics capabilities.
- Developed Python and SQL based ETL routines to ingest raw files, apply transformations, and load curated data into a relational store.
- Implemented operational logging mechanisms that document each transformation step, ensuring full lineage and auditability of the pipeline.
Technical Support Associate
Rainbow Trinity
Middlesex
02.2022 - 08.2025
- Addresses, device-specific issues, network performance, and internet connectivity, resolving an average of 15 support tickets per week with a 98% customer satisfaction rate.
- Provides customers with an overview of installation activity, site-specific information, and access to technical contacts.
- Monitored and managed daily performance of computer systems, ensuring reliability and efficiency.
Full-Stack Developer
Actors Pocket Guide
02.2025 - 05.2025
- Collaborated with team members to develop a full-stack Learning Management System using Angular (frontend) and Spring Boot (backend) for Actors/Directors.
- Developed dynamic course views in Angular that improved data accessibility and user engagement by 20%.
- Coordinated with stakeholders to design UI components in Angular with HTML/SCSS and ensured seamless integration between frontend models and backend DTOs via RESTful APIs.
Education
Bachelor of Science - Computer Science
New Jersey Institute of Technology
Newark, NJ05-2025
Skills
- Python
- PySpark
- T-SQL
- KQL
- NumPy
- Pandas
- Matplotlib/Seaborn
- ETL/ELT Pipelines
- Medallion Architecture
- Delta Lake
- Data Modeling (Star/Snowflake Schema)
- MSSQL
- Azure SQL
- ADLS Gen2
- Azure Blob Storage
- Azure Data Factory
- Azure Databricks
- Azure AI Services
- Azure OpenAI Service
- Lakehouse/ Warehouse
- Dataflows Gen2
- Fabric Pipelines
- Unity Catalog
- Spark SQL
- Auto Loader
- DirectQuery
- Row Level Security
- Git/Github
- CI/CD
- Jupyter Notebooks
Certification
- Microsoft Certified: Azure Data Fundamentals (DP-900)
- Microsoft Certified: Fabric Data Engineer Associate
- Databricks Certified Associate Developer for Apache Spark
- Microsoft Certified: Azure Fundamentals (AZ-900)
- Microsoft Certified: Azure AI Fundamentals (AI-900)
Projects
- Development of a Retrieval-Augmented Generation (RAG): Developed a RAG system to support robotics developers with ROS2, resulting in a 30% reduction in time spent searching documentation.
Timeline
Data Engineer
SkillStorm
11.2025 - Current
Full-Stack Developer
Actors Pocket Guide
02.2025 - 05.2025
Technical Support Associate
Rainbow Trinity
02.2022 - 08.2025
Bachelor of Science - Computer Science
New Jersey Institute of Technology