Fidel Adero

Contact- www.linkedin.com/in/fidelndai-9a5b8830 (LinkedIn) Top Skills Data Build Tool (DBT) Extract, Transform, Load (ETL) Python (Programming Language) Fidel Ndai Analytics Engineer @ cubd | Data Build Tool, ETL, Python Kisumu County, Kenya Summary I am an experienced Analytics Engineer with a strong background in data engineering, advanced analytics, and visualization. I specialize in designing data models, building automated data pipelines, and creating interactive dashboards that drive data-driven decisionmaking. My recent work has involved leveraging industry-leading tools like SQL, dbt, Snowflake, and Airflow to ensure scalable data architecture. I excel at transforming raw data into actionable insights that enable business optimization and product strategy development, with a proven ability to collaborate across departments to meet organizational goals. Experience cubd Analytics Engineer June 2024 - Present (3 months) • Spearheaded the development of automated ETL pipelines using dbt, and SQL to ensure data quality and integrity. • Architect and optimized dimensional data models for efficient query performance and business reporting. • Provided in-depth analyses leveraging advanced techniques in BigQuery and Snowflake to inform business strategy. BARBAH GAMES & VR Data Analyst January 2024 - June 2024 (6 months) • Data-Driven Gaming Insights: Extracted and analyzed data from gaming platforms to uncover actionable insights, leveraging SQL and BigQuery. • Ensured Data Quality and Integrity: Maintained high standards of data quality and integrity throughout transformation and visualization processes. Page 1 of 4 • Interactive Reporting: Built dashboards that provided dynamic and visual reporting of key metrics using Tableau and Power BI, driving improved decision-making across teams. • Data Quality Assurance: Ensured data accuracy and consistency through stringent data integrity checks and best practices in data governance. Sitruna - Amazon Experts Data Analyst June 2023 - January 2024 (8 months) Kenya • Amazon Marketplace Optimization: Applied advanced analytics to optimize product listings, sales, and customer acquisition strategies for Amazon clients, resulting in improved conversion rates and sales performance. • Automated Reporting Systems: Streamlined reporting processes with automated workflows using SQL and Google Sheets, allowing for timely, actionable insights. Medical Departures Inc. Data Analyst July 2019 - June 2023 (4 years) • Analyzed inside sales and agent productivity data to identify trends and optimization opportunities. • Developed Accounts Receivable tracking systems to monitor invoicing and collections, improving financial visibility. • Conducted in-depth analysis of collection and invoicing data, providing insights segmented by clinics, locations, and AR agents. • Managed a large data warehouse, integrating data from various CMS platforms (Livechat, Call Tracking Metrics, Zoho). DataFox Data Analyst March 2018 - July 2019 (1 year 5 months) Kenya • Developed robust data cleaning and consolidation processes for large datasets within Google Sheets and BigQuery. • Utilized Google Sheets and SQL functions and pivot tables to generate insightful summaries and reports. • Created daily, weekly, monthly, and quarterly reports on key performance metrics using Google Data Studio and PowerBI. Page 2 of 4 • Provided expert advice on data-related issues and developed effective troubleshooting solutions. World Renew Consultant - CSPro Data Processing System Developer October 2015 - March 2018 (2 years 6 months) - Develop and support CSPro system for data entry and processing for paperbased evaluation surveys. - Develop and support tablet and laptop-based computer-aided interviewing system in CSPro. - Develop a CSPro data archiving system and provide technical support for users. - Provide guidance and support to the country-level survey teams as needed, to ensure sufficient training and high quality implementation of the data entry system. - Provide country-specific data entry program and user manuals. Evidence Action Associate MLIS - Data Coordination January 2015 - October 2015 (10 months) Kisumu • Development of interfaces for data entry and management of data entry vendors and process. • Development and updating of standardized data collection instruments; for electronic data collection (ODK), phone survey. • Development of data entry interfaces on CSPro and preparing data for cleaning and analysis. • Performing data quality controls and data cleaning. ClinEval Data Analyst / Statistician July 2012 - August 2015 (3 years 2 months) Developing chronic diseases risk calculators by modelling algorithms from the risk factors. Innvations for Poverty Action 4 years 9 months Data Coordinator January 2011 - December 2013 (3 years) Busia Page 3 of 4 Data Analyst April 2009 - December 2010 (1 year 9 months) Data Entry error Checking, data cleaning and documentation related to these quality assurance procedures. Advising on design of surveys and databases. Entry of 5% sample of entered data used for Data Quality Checks. Diagnosing and solving data entry, storage and quality problems that may arise. Data Analysis, Sample size calculations and randomizations. Computer hardware and software maintenance and troubleshooting. Education Maseno University Bachelor of Science - BS, Applied Statistics · (2003 - 2007) ST. MARYS SCHOOL High School Diploma · (January 1998 - November 2001) JOSANA ACADEMY Page 4 of 4