Somin Ramchiary

I'm a

About

I’m a Data Analytics Engineer with expertise in building automated reporting systems, scalable data workflows, and KPI dashboards. I automate business reporting using SQL, Python, ETL, and APIs, Apache Airflow helping teams save time and make data-driven decisions. I also build machine learning and LLM-powered tools for data insights and automation.

Somin

Data Analytics Engineer & Automation Specialist.

Facts

Some key achievements

Happy Clients

Projects

Work hours

Awards

Skills

PYTHON 85%
SQL 90%
STATISTICS 80%
ETL Pipeline 80%
Apache Airflow 85%
Machine Learning 80%
LLMOps 85%
VectorDB 85%

Resume

My lifecycle from scratch.

Education

Bachelor of Science

2015 - 2018

Guwahati University, Guwahati

  • Major in Physics

Professional Exposure

Motion Graphics designer & Video Editor

2019 - 2021

The Crosscurrent, Guwahati

The Crosscurrent is a media production house and my Key Responsibilities were :

  • Designing Motion Graphics for social media.
  • Designing graphics for promotions.
  • Creative content solutions for websites.

Web & Motion graphic designer

2021 - 2023

The Firefly films, Guwahati

It was movie production house and my key responsibilities were:

  • Web UI/UX designing.
  • Designing VFX & Motion graphics for movies.
  • Editing videos.

Professional Exposure

Motion graphics & Video editor

2023 - 2024

Bada Business Pvt. Ltd., Delhi

  • Creating promotional videos & short contents.
  • Designing motion graphics to make videos more appealing.
  • Team work with graphics team & video team to meet design requirements.
  • Employment Proof: Link

Current Role

Data Scientist / Data Automation Engineer

2024 - Present

The New Shop, New Delhi

  • Built production Sales Intelligence System handling 120M+ monthly records.
  • Designed Python + PostgreSQL ETL pipelines orchestrated via Apache Airflow.
  • Implemented idempotent, fault-tolerant scheduled data workflows.
  • Developed KPI engine with automated growth and business rule logic.
  • Automated PDF reporting with Email & WhatsApp delivery (Playwright).
  • Created unified analytics dashboard for 120+ stakeholders.
  • Building RAG-based LLM chatbot for natural language data queries.
  • Applied EDA, hypothesis testing, and ML for forecasting & optimization.
  • Daily reporting tool : Link
  • Automatic smart Dashboard : Link
  • RAG Based LLM chatbot(WIP) : Link

Portfolio

  • All
  • Machine Learning
  • Neural Networks
  • Mixed

Dog Recognition CNN

Neural Networks Project

Penumonia Identification Model

Deep Learning

AI Chatbot

LLM, Langchain, PGVector, fastAPI

Customer Churn Modeling

Machine Learning Project

Covid-19 Data Analysis & Modeling

Analysis & ML

NLP based Web scrapper

NLP & Web scraping

Malaria Detection Algorithm

Neural Networks Model

Fraudulent Transaction Detection

Machine Learning & Analysis

Military Intelligence Analysis

Data Analysis/Machine Learning

IPO Analysis (Basic)

Data Analysis & ML

Sales Report App

Automatic Sale Report Generator

Sale analysis Algorithm

Sales breakdown & Analysis

Services

Business analysis, Database Modeling, Building business solutions using machine learning & AI. Understanding business problem and finding solutions. Multi-domain data processing.

Data Analysis

Gathering insights from data, understanding patterns.

Presentation

Presentating insights from data. Clear explanation of problem statements and solutions

Focusing on time constraint

Ability to deliver on tight deadline.

Predictive Modeling

Building & training predictive model for data driven decisions.

Visualization

Visualizing Complex data into intuitive and understandible graphs.

Data Governance

Understanding How data is processed, how it is protected and how it is used. Implemeting key security measures to protect data.

Blogs

Selected articles published on Medium

Medium Blog 1

From Chai Breaks to Code Crashes

A realistic look into the daily life of an Indian Data Scientist — challenges, failures, and learning.

Medium Blog 2

Automated Sales Intelligence system

Fully Automated Sales Intelligence System (API + ETL + Reports + WhatsApp + Email)

Medium Blog 2

The Ancient Algorithmic Blueprint

Ancient Algorithmic Blueprint: How an Ancient Indian Scholar Invented Computational Thinking 2,400 Years Before Computers

Contact

Location:

New Delhi, India

Call:

+918448098620