Allan Andrew Situma

Allan Andrew Situma

Mentor
5.0
(1 reviews)
US$12.00
For every 15 mins
1
Sessions/Jobs
ABOUT ME
Data Engineer
Data Engineer

Allan is a skilled Data & Software Engineer with a diverse range of expertise. He has over 10 years of professional experience, specializing in software and data engineering. Allan's proficiency extends to various domains, including data, web analytics, BI development, front-end architecture, and API development. His extensive knowledge encompasses Big Data mining and management, cloud infrastructure setup, digital transformations, and data warehouse management. Allan has also worked with Google Cloud Platform, Azure, and cloud architecture. In addition, his technical toolkit includes React.js, Python, R, Spark, Scala, SQL, AWS, Hadoop, ETL, Power BI, Tableau, Google Analytics, and Google Tag Manager. Allan's comprehensive skill set enables him to tackle complex projects and deliver effective solutions with teams.

English
Nairobi (+03:00)
Joined August 2020
EXPERTISE
8 years experience
8 years experience
Big Data Engineering
6 years experience
5 years experience
4 years experience

REVIEWS FROM CLIENTS

Allan's profile has been carefully vetted and approved as a Codementor. Connect with Allan now, and leave a review for them once you're done!
SOCIAL PRESENCE
GitHub
flask-metabase-embed
Embedding a metabase dashboard in a flask app
Python
1
0
sql_try
SQL Practice
0
0
EMPLOYMENTS
Web Analytics Engineer
Kinship Partners Inc.
2023-08-01-2024-03-01

As a Web Analytics Engineer at Kinship, played a pivotal role in enhancing data infrastructure and driving business value through insi...

As a Web Analytics Engineer at Kinship, played a pivotal role in enhancing data infrastructure and driving business value through insightful analysis. Implemented and maintained web analytics solutions across multiple platforms, collaborating with cross-functional teams, and providing actionable insights to drive product improvements.

  • Implemented and maintained web analytics solutions for various platforms, including a React Native mobile app, an Angular Dart web app, and a React website app
  • Leveraged Google Analytics and Google Tag Manager to track user behavior and key metrics across all platforms, ensuring comprehensive data collection and analysis
  • Collaborated closely with product managers to specify events from the UI, ensuring accurate tracking of user interactions and behaviors to inform product decisions
  • Implemented event tracking and data layer enhancements to capture relevant data points for analysis, driving actionable insights for product optimizations
  • Worked alongside the data analytics team to write SQL queries on BigQuery for advanced analysis and reporting, contributing to data-driven decision-making processes
  • Led initiatives to implement advanced tracking solutions such as cross-domain tracking and enhanced eCommerce tracking, providing comprehensive insights into user behavior and driving business growth
  • Developed custom JavaScript solutions to address specific tracking requirements and improve data accuracy, optimizing our tracking implementations
  • Collaborated with the engineering team to implement data layer standards and ensure consistency in tracking implementations across platforms
SQL
Big Data
React
View more
SQL
Big Data
React
React Native
View more
Senior Data Engineer
Indeed.com
2021-09-01-2023-06-01

As a software and data engineer, helped migrate Indeed's indexes, named data marts, from on-premises Hadoop to Amazon Web Service...

As a software and data engineer, helped migrate Indeed's indexes, named data marts, from on-premises Hadoop to Amazon Web Services (AWS).

  • Migrated 130 data mart critical indexes to AWS as part of the first phase of the project
  • Achieved 50% Leila Indeed DSL index builders, 25% Python-based index builders, and 25% Scala-based index builders
  • Developed automation for migrating Pig Latin index builders
  • Created a script to automate the templating of Terraform scripts
  • Architected a script to automate the migration of on-premises Hive tables to AWS Glue
  • Refactored Spark scripts written in Java to fit an AWS migration
  • Collaborated with stakeholders and owners to complete migrations
Python
Java
Apache Spark
View more
Python
Java
Apache Spark
HiveQL
Terraform
Apache Hadoop
AWS
View more
Software Engineer - Frontend
Apollo Agriculture
2021-09-01-2022-09-01

Developed and maintained web applications using React.js and its ecosystem, including state management libraries like Redux or MobX an...

Developed and maintained web applications using React.js and its ecosystem, including state management libraries like Redux or MobX and routing libraries like React Router. Contributed to front-end development by implementing user interfaces and UI interactions based on design specifications and wireframes. Wrote clean, efficient, and reusable code using HTML, CSS, and JavaScript.

  • Developed components by creating and maintaining reusable React components used across different parts of the application
  • Managed an app's components, handled events, and ensured code modularity
  • Carried out state management by overseeing the application state using state management libraries like Redux and MobX
  • Understood and implemented actions, reducers, and stores to manage complex application states effectively
  • Wrote unit tests and performed debugging to ensure the stability, reliability, and performance of the application
  • Identified and resolved performance bottlenecks in the application by optimizing rendering, reducing unnecessary re-renders, and improving data fetching and caching strategies
  • Worked closely with designers, product managers, and other developers to gather requirements, provide technical insights, and ensure the successful delivery of high-quality software products
  • Participated in code reviews to ensure code quality, readability, and adherence to best practices
  • Documented code and maintained technical documentation for future reference
  • Kept up with the latest trends, techniques, and best practices in React and web development
  • Proactively sought opportunities to enhance skills and knowledge through self-learning and professional development
  • Collaborated effectively within a team, communicating ideas, challenges, and progress to team members, and actively participating in team meetings and discussions
  • Developed APIs with Scala
SQL
Scala
PostgreSQL
View more
SQL
Scala
PostgreSQL
React
Elastic Stack
AWS
View more
PROJECTS
Dairy farming data platform: (dbt, github actions, python, bigquery, metabase)View Project
2020
Dairy Farmer App Data Platform—an innovative solution powered by Python, Docker, MySQL, MongoDB, DuckDB, Metabase, and dbt. This comprehe...
Dairy Farmer App Data Platform—an innovative solution powered by Python, Docker, MySQL, MongoDB, DuckDB, Metabase, and dbt. This comprehensive platform empowers dairy farmers with actionable insights derived from their farm management data. Docker ensures seamless deployment, while MySQL and MongoDB manage structured and unstructured data respectively. DuckDB serves as the data warehouse, enabling efficient data storage and analysis. Metabase facilitates intuitive data visualization, and dbt enables robust data transformation. Together, these tools create a powerful ecosystem for optimizing dairy farm operations.
Python
SQL
MongoDB
View more
Python
SQL
MongoDB
Data analysis
Docker
Docker Compose
Dockerfile
Data modeling
Data warehouse
Metabase
DBT
View more
Credit scoring data platform (Mysql, Python, dbt, Powerbi)View Project
2019
Developed omprehensive credit scoring data platform, where MySQL, Python, dbt, Power BI, and Docker converge to form a robust ecosystem. ...
Developed omprehensive credit scoring data platform, where MySQL, Python, dbt, Power BI, and Docker converge to form a robust ecosystem. MySQL serves as our pivotal data source, Python orchestrates ETL processes, dbt molds data models, Power BI visualizes insights, and Docker ensures seamless deployment. This amalgamation empowers risk assessment, furnishes invaluable customer behavior insights, and facilitates informed decision-making, marking a pivotal milestone in data-driven innovation and analytics.
Python
SQL
Docker
View more
Python
SQL
Docker
Docker Compose
Dockerfile
Data analytics
PowerBuilder
Data modeling
Data warehouse
View more