Technology professional with 17+ years of experience across software development, Oracle database development, technical training, and modern data engineering.

Hands-on experience in designing and building data engineering solutions using Python, SQL, Apache Spark, Apache Kafka, PostgreSQL, Google BigQuery, FastAPI and Docker.
Experienced in designing ETL pipelines, data ingestion workflows, batch processing and real-time streaming solutions.

Built real-world data engineering projects including streaming analytics pipelines, AI-powered knowledge assistants, automation workflows and analytical dashboards as part of Sankalan Data System, a technical learning and engineering platform.
Experienced in batch processing, streaming pipelines, data modeling and building data platforms for analytics and AI applications.

• Designed an end-to-end analytics pipeline to capture and process website user activity data from Sankalan Data System.
• Integrated Google Tag Manager and Google Analytics 4 to collect page views, clicks, sessions and user interaction events.
• Used Apache Kafka as an event streaming layer for reliable ingestion of incoming analytics events.
  Designed streaming architecture using Kafka topics, Spark Structured Streaming jobs, checkpointing and fault-tolerant processing.
• Processed streaming data using Apache Spark Structured Streaming and performed transformations before storing curated data.
• Stored analytical datasets in Google BigQuery and operational data in PostgreSQL for reporting and application use cases.
• Created Streamlit dashboards to visualize website traffic, engagement metrics and user behavior analysis.
• Implemented the complete data flow including event collection, stream processing, storage and visualization.

• Built a Retrieval-Augmented Generation (RAG) based AI assistant by designing document ingestion pipelines, embedding generation workflows and semantic search architecture.
• Created document ingestion pipelines to convert website content into searchable vector embeddings.
• Implemented semantic search using FAISS vector database and HuggingFace embedding models.
• Designed a hybrid response approach where relevant internal knowledge is searched first and an LLM is used for additional context when required.
• Developed API endpoints using FastAPI to integrate the assistant with applications.
• Used this system for answering technical questions related to SQL, Python, Data Engineering and programming concepts.

• Developed an automated workflow to manage technical video content publishing.
• Created Python scripts to manage video metadata, file movement and publishing status.
• Integrated Google Drive and YouTube APIs for automated video upload workflows.
• Maintained content tracking using SQLite databases, CSV files and automation scripts.
• Reduced manual steps involved in content publishing and improved consistency of the workflow.

• Built a Python-based automation tool to generate technical tutorial content from structured inputs.
• Generated explanations, examples, FAQs and interview questions using AI-assisted workflows.
• Created reusable HTML templates to convert generated content into website-ready tutorial pages.
• Integrated generated content into the Sankalan Data System technical learning platform.
• Improved efficiency of creating and maintaining large-scale technical documentation.

Sankalan Data System

• Building practical data engineering solutions using Python, SQL, Apache Spark, Apache Kafka, PostgreSQL and Google BigQuery.
• Designed, developed and maintain www.sankalandtech.com , a technical learning platform featuring tutorials, interview questions, coding exercises and technical documentation on SQL, Python, Data Engineering, Apache Spark, Kafka, Power BI and AI technologies.
• Designed and developed real-time analytics pipelines, automation workflows and AI-powered knowledge systems.
• Developed data applications using FastAPI, Streamlit and modern Python frameworks.
• Created SEO-optimized technical content and implemented information architecture, internal linking and technical SEO best practices to improve organic search visibility and user engagement.
• Built Python automation tools for technical content generation, publishing workflows and website maintenance, reducing manual effort and improving content consistency.
• Developed and published 400+ technical tutorial pages covering SQL, Python,C,Java, Power BI and Data Engineering concepts for developers and learners.

Freelance

• Worked on Oracle database development and SQL performance optimization.
• Analyzed execution plans, optimized queries and improved database performance.
• Worked on database design, indexing, stored procedures and PL/SQL programming.
• Supported enterprise applications with database-related development and troubleshooting.

Freelance Technical Trainer

• Delivered corporate and individual training programs on Oracle Database, SQL, PL/SQL, Python and database technologies.
• Trained developers, database professionals and engineering teams on practical software development skills.
• Created hands-on training material focused on SQL queries, performance tuning, database design and programming.
• Worked closely with learners to solve real-world technical problems and improve engineering skills.

Mentor IT's Linosoft Services

• Worked on enterprise application development and backend modules for business applications.
• Designed database structures, implemented SQL queries and developed application features.
• Worked on reporting modules, database integration and application maintenance.
• Collaborated with teams to deliver software solutions based on business requirements.

• Master of Computer Applications (MCA)
  Savitribai Phule Pune University, 2006
• Bachelor of Science (Mathematics, Physics & Computer Science)
  Dr. Babasaheb Ambedkar Marathwada University, 2003
• Oracle Certified Associate (OCA)
  Oracle Database Administration
• Microsoft Certified
  HTML5 with JavaScript and CSS3