Kailas Warade

Warade Kailas Tejrao


Data Specialist & Engineering Lead
Pune, Maharashtra | +91 9834178759 | tech2dsm@gmail.com
www.sankalandtech.com | GitHub: tech2dsm-png

About Me

I’ve worked in software development, databases and technical training for 17 years. My main focus has always been building reliable data systems and finding ways to automate manual work to help teams get more done. For the last more than two years, I’ve been running my own technical platform, where I built everything from user analytics to AI-powered search tools from scratch. I really enjoy taking a project from an idea to a working system and using data to solve real-world problems.

Technical Skills

Databases & Analytics:
Oracle SQL & PL/SQL Google BigQuery MySQL PostgreSQL SQLite
AI, ML & Big Data:
Hadoop Machine Learning RAG Systems FAISS HuggingFace
Languages & Libraries:
Python Pandas & NumPy PHP Java C / C++
Tools & Platforms:
GitHub Actions Streamlit GA4 / GTM Power BI

Work Experience

Engineering Lead & Architect | Sankalan Data System 2+ Years (Current)

Designed and built the full web architecture, including the backend automation and server workflows that power the site.

  • Developed an analytics pipeline for sankalandtech.com that captures user interactions via GTM and GA4, streams the raw event data into BigQuery and visualizes key retention and conversion metrics through a custom Streamlit dashboard.
    Project Guide | Live Dashboard | GitHub Code
  • Automated the media publishing workflow using GitHub Actions to sync files between local storage, Google Drive and YouTube, with a SQLite backend to track and reconcile engagement statistics.
  • Built an automated content pipeline that takes a topic name as input and handles the drafting, formatting and publishing process, allowing for rapid technical content creation.
  • Built a RAG-based search assistant for the tutorial site using FAISS and HuggingFace embeddings, allowing students to query the documentation and receive context-aware answers to their coding questions.
  • Building an automated Power BI system that ingests raw CSVs and handles the entire data modeling and visualization process.
Lead PL/SQL Database Consultant | Freelance 2 Years

I audited and updated databases for healthcare organizations. I fixed slow queries and inefficient code to make sure patient records were processed quickly and without delay.

Senior Technical Trainer & Database Specialist | Freelance 11.5 Years

I created training programs for engineering teams to help them apply theory to real-world projects. I also mentored developers and DBAs on database design, Python and advanced Oracle techniques like indexing and data partitioning.

Software Developer | Mentor IT’s Linosoft Services 1.5 Years

I developed the backend for Constrodevelopers, a construction industry ERP. I handled the database design and security, making sure the system was reliable and easy to scale.

Education & Certifications

Oracle Certified Associate (OCA) | Database Administration
Microsoft HTML5 with JavaScript and CSS3

Master of Computer Applications (MCA) | University of Pune, 2006

Bachelor of Science (B.Sc.) | Mathematics, Physics & Computer Science | Dr. Babasaheb Ambedkar Marathwada University, 2003