ANU AJIMAFOWOKU
Dallas,TX
Summary
Accomplished Data Engineer with a proven track record at Fractal Business Consulting, enhancing data accuracy by 95% through optimized ETL pipelines. Proficient in AWS services and data modeling, I leverage critical thinking to drive impactful data solutions, ensuring efficient data processing and strategic insights for stakeholders.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data Engineer
Fractal Business Consulting and Service
, US
06.2024 - Current
- Develop robust ETL pipelines in Python and AWS Lambda for automated data transfer and accuracy.
- Create and maintain Docker containers for efficient deployment and scaling of data modeling applications.
- Design and implement data models for effective data warehousing solutions, optimizing storage and retrieval.
- Utilize lambda architecture principles to build robust, scalable data processing pipelines for real-time analytics.
- Craft a Python ETL pipeline on EC2, integrating the Google Drive API for seamless data transfer.
- Design PostgreSQL tables and schemas using SQL for improved data accessibility and retrieval.
- Collaborate with data scientists, project managers, and developers during agile sprints for data tasks.
- Enhance efficiency and accuracy by automating CSV data transfer from S3 to PostgreSQL RDS.
- Contribute to weekly presentations, sharing results and insights with stakeholders for informed decision-making.
- Key Accomplishments.
- Improved data accuracy by 95% through ETL pipeline enhancements, ensuring reliable insights for decision-making.
- Increased data processing capacity by 150% by optimizing EC2-based Python pipelines, and scaling infrastructure for growing needs.
Data Analyst I
RWJBH - Monmouth Medical Center
West Orange, US
07.2019 - 10.2023
- Designed and refined data models for optimized database structure and efficient retrieval processes.
- Implemented snowflake schema structures to organize and manage complex data relationships within data warehouses.
- Executed Linux-based Bash scripting to automate data processing tasks and enhance system efficiency.
- Employed Snowflake and Metabase for data ingestion, transformation, and visualization, facilitating ETL and ELT processes.
- Transformed data into actionable insights through proficient SQL querying and aggregation techniques.
- Applied statistical software and SQL tools for thorough analysis, delivering comprehensive results.
- Enforced data validation and quality control measures in SQL databases to maintain accuracy and compliance.
- Identified and resolved complex data issues using SQL troubleshooting methods for consistent system performance.
- Utilized SQL reporting and visualization tools to effectively communicate findings, aiding decision-making processes.
- Conducted exploratory analysis on intricate datasets using Python libraries such as NumPy and Pandas.
- Key Accomplishments
- → Optimized database structure, improving retrieval efficiency by 30%, enhancing overall analytical processes' speed.
- → Implemented data validation measures, resulting in 99% accuracy, ensuring regulatory compliance and data integrity.
Education
Bachelor of Science - Chemical Engineering
New Jersey Institute of Technology
Newark, NJ01.2023
Skills
- AWS Architecture Design
- AWS Infrastructure Operations
- Incident Response and Security Issues Investigation
- Project Management Tools
- AWS Services
- Azure Services
- Data Modeling
- Data warehousing
- Lambda
- Snowflake schema
- Linux
- Bash scripting
- Snowflake
- Metabase
- ETL process
- ELT process
- DBT (Data Build Tools)
- Virtualization
- Continuous Integration
- Change Management
- Data Science and Analytics
- Data Pipelines and Structures
- Data Transformation and Integration
- Data source identification
- Airbyte Data Ingestion
- Data Strategy and Governance
- Highly detail-oriented
- Critical Thinking and Decision-Making
- Flexible and adaptable
Certification
- Applied Data Engineering and Architect, WeCloud Data, ON, 02/01/24
- AWS Certified: Data Engineer - Associate, credly, 12/01/23
- Tableau Desktop Specialist, credly, 02/01/23
- CompTIA Security+ ce Certification, credly, 12/01/22
Projects
Data Engineering Project, Led the ingestion of diverse data sources into Snowflake data warehouse for Business Intelligence (BI) purposes., Transformed data to support comprehensive dashboards and detailed reports utilizing Metabase., Managed data primarily from TPCDS, focusing on Retail Sales, utilizing AWS RDS and S3 for storage., Integrated raw tables into a consolidated table for streamlined data handling and enhanced efficiency., Created a new fact table to introduce additional metrics and enhance data analysis capabilities.
Personal Information
Work Permit: Fully authorized to work in the US
Skills Highlights
- AWS Architecture Design
- AWS Infrastructure Operations
- Incident Response & Security Issues Investigation
- Project Management Tools
- GCP Cloud Services
- AWS Services & Azure Services
- Data Modelling
- Data Warehousing
- Lambda
- Snowflake Schema
- Linux, Bash Scripting
- Snowflake
- Metabase
- ETL process & ELT process
- DBT (Data Build Tools)
- Virtualization
- Continuous Integration
- Change Management
- Data Science & Analytics
- Data Pipelines & Structures
- Data Transformation & Integration
- Data Source Identification
- Airbyte Data Ingestion
- Data Strategy & Governance
- Highly Detail-oriented
- Critical Thinking & Decision-making
- Flexible & Adaptable
Timeline
Data Engineer
Fractal Business Consulting and Service
06.2024 - Current
Data Analyst I
RWJBH - Monmouth Medical Center
07.2019 - 10.2023
Bachelor of Science - Chemical Engineering
New Jersey Institute of Technology
Similar Profiles
Yashvi TekriwalYashvi Tekriwal
Strategy & Insights Consulting at Fractal ConsultingStrategy & Insights Consulting at Fractal Consulting
PRAVEEN KUMARPRAVEEN KUMAR
Senior Technology Manager at Business Consulting and Solutions, RXG Business Consulting and SolutionsSenior Technology Manager at Business Consulting and Solutions, RXG Business Consulting and Solutions
Linda AnciraLinda Ancira
New Build Marketing Development Administrator at Optimum Business ConsultingNew Build Marketing Development Administrator at Optimum Business Consulting
Martin TangumaMartin Tanguma
Driver Helper at AmazonDriver Helper at Amazon
Alex NkeshimanaAlex Nkeshimana
Federal Work Study Student at Spartan CollegeFederal Work Study Student at Spartan College