Konan Joel Kouakou

Design and development of data pipelines to extract data from internal databases via API. Storing data in JSON format in a Snowflake Stage. Orchestration of workflows with Apache Airflow to automate ETL processes. Configuration of Snowpipe for automatic data loading into Snowflake tables. Optimization of SQL query performance through indexing and clustering keys. Development of a Power BI dashboard for tracking pharmaceutical product sales, identifying out-of-stock medications, and detecting spoiled products. Tools: Snowflake, SQL, Power BI, Airflow, Python

Orchestration of workflows with Airflow, automation of ETL/ELT pipelines. Data ingestion via Snowpipe. Building and managing a Data Warehouse in Snowflake to centralize and structure data. Data ingestion, preparation, and transformation for advanced analyses. Data modeling and architecture to support decision-making and business analyses. Optimization of SQL performance and queries to reduce processing times. Implementation of sales forecasting models using SNOWFLAKE.ML.FORECAST to anticipate trends. Creation of BI reports in Power BI and regular KPI updates. Operational support and Run to ensure data availability and quality. Tools: Snowflake, SQL, Power BI, Airflow

Sensor data collection, IoT data processing, data visualization, AI model development, AI model deployment in a ROS environment, AI model optimization. Tools: TensorFlow, gradio, Scikit-Learn, OpenCV, Pandas, Power BI, Docker, CNN, Linux, ROS, SQLITE