Experience

• 

  Bykea

  Dec 2019 - Dec 2020

  Associate data analyst

  Extracted, transformed, reported, and visualized data using Google Data Studio.Identified patterns and trends in datasets.Worked alongside teams within the business or the management team to establish business needs.Defined new data collection and analysis processes.Conducted churn analysis, cohorts, and customer retention

• 

  Afiniti

  Jan 2021 - Sept 2024

  Planned and Executed end-to-end migration of ETL processes and Database from Mysql to Greenplum.Deployment of productionized data pipelines from legacy system to Airflow deployed on Linux Docker Engine.Optimized SQL, PostgreSQL and Greenplum processes (Stored procedures,ETL pipelines) to accelerate data flows and avoid bottlenecks.Deployment of Reporting Alerts using SQL and Python for the visibility of gain to cross-functional team and higher management.Conducted detailed studies on potential third-party data and incorporated it into the data-pipeline while verifying compliance with internal needs and stakeholder requirements.Performed large-scale data transformations to yield potential features (Feature-Engineering) to be integrated into the AI models for maximum value.Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.Formulated evolved and stable strategies for overall process improvements, efficiencies and innovation. Show less

  • Data Engineer ||

    Jan 2022 - Sept 2024

  • Associate Data Engineer

    Jan 2021 - Dec 2021
• 

  Puresquare

  Sept 2024 - now

  Senior data engineer

  Optimized database queries, reducing query execution time by 50% and implemented efficientscheduling to eliminate deadlocks, improving overall system performance.Developed and tested robust event-driven workflows by simulating event streams throughRabbitMQ to ensure system reliability and scalability.Designed and implemented critical hotfixes to address parent-child relationship issues in theevent-driven architecture, enhancing system integrity and functionality.Managed and customized Power BI dashboards, improving data visualization and enablingstakeholders to derive actionable insights from analytics. Show less