Available to hire
Hi, I’m Omkar Sawant, a data engineer and developer with 14+ years of experience designing, implementing, and leading chatbot, AI, and digital integration initiatives in the banking and financial services sector. I specialize in enterprise-grade chatbot platform deployment (IBM Watson Assistant, Google Dialogflow CX, Microsoft Bot Framework) and seamless multi-channel integration across mobile, web, WhatsApp, and contact centers. I’m passionate about building secure, scalable data architectures, orchestration pipelines, and compliant solutions that enhance customer experience and digital engagement.
I enjoy leading cross-functional Agile teams, partnering with business stakeholders, and delivering impactful conversational AI systems. My experience spans Rails-based development, HMS integrations, cloud ETL, and advanced RAG/LLM solutions, and I’m always eager to apply AI/ML to real-world business problems while ensuring governance and security best practices.
Skills
Experience Level
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Language
English
Fluent
Work Experience
GEN AI Analytics Engineer at Confidential
February 1, 2024 - PresentLed design and implementation of scalable data pipelines and RAG-based knowledge platforms using Llama-2, LangChain, and AWS services, reducing query resolution time by 65%. Developed chatbot solutions improving accuracy and customer interaction. Managed dbt Cloud modular transformations, optimized PySpark ETL jobs for LLM training data, and built vector embedding pipelines for semantic search. Architected enterprise data lakes for large-scale generative AI workloads, integrating multiple AWS tools such as Glue, EMR, Lambda, Redshift, and S3. Collaborated on migrating treasury data to Data Lake and developing master data management solutions.
GEN AI Analytics Engineer at NewForce Inc
November 30, 2023 - August 26, 2025Delivered end-to-end AWS architecture assessment including Amazon EMR, Redshift, S3. Automated CI/CD pipelines with dbt tests and Great Expectations. Built sentiment analysis chatbots and deployed fine-tuned LLM with RAG using Pinecone handling 10K+ queries/day. Architected multi-source RAG systems integrating 50+ data sources and led dbt training for analysts. Developed real-time Kafka/PySpark data ingestion pipelines and automated data validation frameworks for LLM training data.
GEN AI Analytics Engineer at IKEA (Freelance Contract)
June 30, 2022 - August 26, 2025Developed security frameworks for AWS S3 access control with Lambda and DynamoDB. Automated and optimized dbt pipelines using Airflow. Led deployment of multi-tenant RAG systems with Llama-3 and Pinecone enhancing retrieval accuracy and performance. Designed large-scale petabyte data lakes on AWS and optimized Spark SQL ETL workloads for cost reduction. Built retail e-commerce RAG pipelines integrating knowledge graphs. Supported cluster security and Kerberos authentication setup.
GEN AI Analytics Engineer at HTC Global Services (Client: AIA Insurance)
December 31, 2021 - August 26, 2025Developed real-time PySpark data ingestion systems for LLM training datasets at scale. Migrated legacy ETL to dbt Cloud with 200+ reusable models. Built document-based RAG search with LangChain for financial reports. Led 15-person analytics engineering team delivering AI initiatives across healthcare and finance. Created automated fine-tuning pipelines and optimized Spark SQL queries by 10x. Managed AWS resources including Lambda, EMR, DynamoDB, and orchestrated cloud deployments.
GEN AI Analytics Engineer at Virtual Calibre
August 31, 2020 - August 26, 2025Developed Ansible playbooks for AWS node management, deployed GPT-powered chatbots reducing support load by 30%. Built Spark Structured Streaming architectures for LLM usage analytics processing 500GB/hour on EMR clusters. Enhanced monitoring dashboards detecting prompt injection with high accuracy. Created data models using Erwin and developed Power BI reports, dashboards, and complex SQL queries. Involved in Informatica MDM setup and customer data integration.
Analytics Engineer at Elite IT Inc (Clients: Prime Therapeutics & Payfactors LLC)
February 28, 2019 - August 26, 2025Designed conceptual, logical, and physical data models and developed star schemas using BigQuery and other cloud tools. Automated Salesforce data ingestion and processing using SOQL, Spark, Scala, Python, and GCP services. Developed source-to-target mappings and validated data pipelines. Collaborated with data architects and business analysts for data model reviews. Produced reports and dashboards in Tableau and maintained Informatica MDM metadata.
Analytics Engineer at IQuest Solutions Corp (Client: Recorded Books Inc)
November 30, 2016 - August 26, 2025Built machine learning pipelines using Apache Airflow integrated with AWS SageMaker. Developed streaming data pipelines with Apache Spark and Python. Implemented security frameworks for AWS S3 access using Lambda. Developed AWS serverless orchestration using Step Functions and Lambda. Participated in requirements gathering, data model development, and data warehouse migrations. Created DAX expressions for Power BI and optimized ETL mappings using Talend and Oracle PL/SQL.
Analytics Engineer at Tforge Investments LLC
September 30, 2015 - August 26, 2025Collaborated with ETL and BI teams to analyze data issues and design OLAP models. Developed dimensional models and star schemas. Designed billing and payment databases and developed Power BI reports and dashboards. Utilized IBM Datastage for ETL processes. Delivered logical and physical data models using Erwin and performed data cleansing and massaging with Power Query.
Analytics Engineer at IQuest Solutions Corp (Client: Bluestem Brands Inc)
December 31, 2013 - August 26, 2025Created physical and logical data models using Erwin. Developed database objects including tables, views, indexes, triggers, and stored procedures in Oracle and Teradata. Designed ER diagrams and data warehouse object strategies. Developed complex ETL mappings via IBM Datastage from various sources into data marts. Delivered Power BI visualizations and reporting solutions. Managed performance tuning and data validation.
Analytics Engineer at United Supermarket (CAABI Department)
April 30, 2013 - August 26, 2025Designed and customized real-time data warehouse models, applying data cleansing techniques and developing OLTP, ODS, and OLAP data flows. Developed data governance and transformation rules for Master Data Management. Created logical and physical data models using ER-Studio. Implemented complex SQL queries for business reporting and participated in requirements gathering and solution reviews.
AI Data Engineer at Master Works
May 1, 2025 - May 1, 2025Led end-to-end technical design, development, and delivery of enterprise chatbot and conversational AI solutions for retail and corporate banking; integrated across web, mobile, WhatsApp, and digital channels; built and managed API/SDK integrations with core banking, CRM, and payment gateways; architected a RAG-based enterprise knowledge platform using Llama-2 and LangChain, reducing internal query resolution time; mentored developers on AI models, data pipelines, and middleware integration.
AI Data Engineer at NewForce Inc.
November 1, 2023 - November 1, 2023Assessed and implemented end-to-end architectures across AWS (EMR, Redshift, S3); developed multilingual chatbot flows with contextual understanding; established CI/CD with dbt tests and Great Expectations for data quality; built multi-source RAG systems with LangChain and LlamaIndex; trained 15 analysts and led enterprise data platform initiatives processing 20TB+/day of unstructured data for LLM training.
AI Data Engineer at IKEA (Freelance Contract)
June 1, 2022 - June 1, 2022Designed security framework for fine-grained access to AWS S3 objects using Lambda and DynamoDB; documented chatBot architectures and workflows; ensured 24x7 uptime, incident management, and governance; automated dbt workflows and set up multi-tenant RAG systems; built legal/contract RAG platform using BERT-based retrievers and Cohere generators.
AI Data Engineer at HTC Global Services
December 1, 2021 - December 1, 2021Developed real-time data ingestion for LLM training datasets; migrated legacy ETL to dbt Cloud; built document-based RAG search pipelines; led MDM scaffolding and data lake architecture; deployed multi-cloud data pipelines and monitored governance/compliance.
Data Analytics Engineer at Virtual Calibre
August 1, 2020 - August 1, 2020Built GenAI-powered chatbots with OpenAI; implemented streaming analytics (Kafka/Spark Structured Streaming) for LLM usage analytics; created real-time monitoring dashboards to detect prompt injection attacks; processed 500GB/hour of inference logs on AWS EMR.
Data Analytics Engineer at Elite IT Inc
February 1, 2019 - February 1, 2019Architected dimensional models and loaded data into BigQuery for sales and marketing analytics; integrated Salesforce data; developed ETL mappings, dashboards in Power BI/Tableau; implemented star/snowflake schemas and data governance practices.
Data Analytics Engineer at IQuest Solutions Corp
November 1, 2016 - November 1, 2016Designed and implemented logical/physical data models using Erwin; loaded data from Oracle/Flat Files into EDW/data marts; built data mappings and governance; created Power BI dashboards and conducted data model reviews with stakeholders.
Data Analytics Engineer at Bluestem Brands Inc
December 1, 2013 - December 1, 2013Created physical/logical models using Erwin; implemented Star/Snowflake schemas for data warehouses; built Power BI dashboards and data visualizations; contributed to end-to-end data warehousing lifecycle.
Data Analytics Engineer at United Supermarket (CAABI Department)
April 1, 2013 - April 1, 2013Developed enterprise data warehouse solutions and data models; implemented star schema data marts; performed data governance and mappings; built dashboards and reporting using Oracle/SSAS/SSIS.
Education
Bachelor of Engineering – Computer Engineering at University of Mumbai
January 1, 2006 - January 1, 2010Master of Science - Management Information Systems at Texas University
January 1, 2012 - January 1, 2014Bachelor of Engineering at University of Mumbai
January 11, 2030 - January 1, 2010Master of Science - Management Information Systems at Texas University
January 11, 2030 - January 1, 2014Qualifications
MCSE 70-466
January 11, 2030 - August 26, 2025GEN AI LLM Development Certificate
January 11, 2030 - August 26, 2025Build RAG Applications
January 11, 2030 - August 26, 2025Cloud Pyspark Certification
January 11, 2030 - August 26, 2025Oracle Certificate 9i, PL/Oracle PL/SQL 11g
January 11, 2030 - August 26, 2025MCSE 70-466
January 11, 2030 - November 4, 2025GEN AI LLM Development Certificate
January 11, 2030 - November 4, 2025Build RAG Applications
January 11, 2030 - November 4, 2025Vector Databases for RAG
January 11, 2030 - November 4, 2025Advanced RAG with Vector Databases and Retrievers
January 11, 2030 - November 4, 2025Cloud Pyspark Certification
January 11, 2030 - November 4, 2025Oracle Certificate 9i, PL/SQL, 11g
January 11, 2030 - November 4, 2025Industry Experience
Computers & Electronics, Financial Services, Healthcare, Retail, Software & Internet, Professional Services, Education
Skills
Experience Level
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Hire a AI Engineer
We have the best ai engineer experts on Twine. Hire a ai engineer in Mumbai today.