John Cigi

Background

About John Cigi

Driving AI-powered innovation as a GenAI Engineer & Data Engineer, leading and mentoring teams to develop AI and data solutions. Specializing in prompt engineering, chatbot development with LLM & RAG models, and building APIs for seamless prompt management. Experienced in designing and optimizing cloud-based data solutions using Snowflake, Oracle, AWS services, Teradata, and Denodo. Skilled in data engineering, migration, and database administration, with a passion for leveraging AI & GenAI to enhance automation, efficiency, and intelligent decision-making: & : Proven expertise in LLM & RAG models, developing chatbots using OpenAI & Google Generative AI. Skilled in prompt engineering for AI-driven biomedical workflow automation and orchestrator application. Experienced in LangSmith, Langfuse for monitoring, observability, and prompt management, ensuring optimal AI performance and reliability. Designed and built robust APIs for prompt management, streamlining AI-driven workflows. Experience in Machine learning algorithms - Regression, Classifications. Experienced in Deep learning. & : Expertise in optimizing Oracle queries and views using CTEs and complex joins, ensuring high-performance data retrieval. Migrated Denodo & Oracle views to Snowflake, leveraging Snowflake’s advanced features such as data cloning, time travel, dynamic tables, and Snowpipes to enhance data efficiency. & : Designed and deployed AWS Lambda functions, integrating data pipelines with S3 & Glue. Automated infrastructure provisioning with CloudFormation and implemented API Gateway for secure and scalable API interactions. Established CloudWatch & SNS-based monitoring to ensure performance optimization, and proactive alerting: Managing Oracle databases on AWS RDS, ensuring efficient performance, scalability, and security. Experienced in query tuning, log monitoring, patch management, and automating backup & recovery strategies to enhance database reliability and minimize downtime.