Mumbai, India · Open to opportunities

Sonu Yadav

Process Automation Executive & Full-Stack Developer

I build the systems that replace spreadsheets. Order-to-payment pipelines, accounts receivable and collection platforms, and multi-level approval workflows — shipped to production and used daily by operations, accounts and external vendors.

Portrait of Sonu Yadav

About

Turning undocumented processes into a system of record

I am a Process Automation Executive at Crystal Logistic Cool Chain Ltd., where I replace manual, spreadsheet-driven processes with web applications that hold up under daily use. My work sits where operations, accounts and sales meet: I sit with the people doing the job, learn the process as it actually runs, and then build the system that becomes the single source of truth for it.

That usually means the unglamorous parts done properly — role-based access enforced on the route and not just hidden in a menu, approval chains with hold, reject and resubmit loops, audit trails, reconciliation between systems that disagree, and reporting a manager can act on. I care most about the moment a number on a dashboard can be trusted.

Before this I worked as a data analyst, and that lens has stayed with me: I would rather measure a process than guess at it.

Selected work

Two systems running in production

Both are live at my current employer. Each has a public demo built on fictional data, so you can click through the real interface without touching a real record.

More

Other projects

Internal tools, data analysis and things built to learn something. Several have screenshot walkthroughs.

Client Portal WebApp

Secure client-specific login with order details, document access, order progress tracking, installation guides, support ticket submission and feedback forms.

  • Apps Script
  • JavaScript

MES System

Manufacturing Execution System module with a dashboard, production tracking and a quality-control module for monitoring key manufacturing processes.

  • Web
  • Dashboard

Result Analysis, June 2024

Interactive visualisations of university results highlighting trends, averages and key performance indicators to support academic decision-making.

  • Python
  • Data analysis

Sales Analysis Dashboard

Built on the AdventureWorks database — sales performance, product trends and customer demographics in one analytical view.

  • Power BI
  • SQL

Facebook Ad Campaign Analysis

Ad performance, audience engagement and ROI: reach, impressions, conversions and budget allocation analysed to find where spend was working.

  • Python
  • Pandas

Email Approval System

Cross-department approval system built around how each department actually works, with automatic reminder emails to whoever is holding up an approval.

  • Apps Script
  • Workflow

Resume Bank

Apps Script web application showing how many résumés sit against each open position and where every candidate stands — transparency the hiring process did not have.

  • Apps Script
  • Reporting

Website Access Blocker

Chrome extension that blocks distracting sites, with customisable rules and stats — built to make focus time measurable rather than aspirational.

  • Chrome Extension
  • JavaScript

Amazon Clone

React build of the core Amazon flows — product browsing, user authentication and a shopping cart.

  • React
  • Firebase

Face Detection

Haar Cascade model detecting faces in images and video streams, as an introduction to applied computer vision.

  • Python
  • OpenCV

Motion Detection

OpenCV pipeline that tracks movement in a live video feed by detecting frame-to-frame change — a small surveillance and monitoring experiment.

  • Python
  • OpenCV

Toolkit

Skills

Highlighted items are what I work in day to day; the rest I have shipped with and can pick back up. No percentage bars — they never meant anything.

Languages

  • JavaScript (ES6+)
  • SQL
  • HTML5
  • CSS3
  • Python
  • Java
  • PHP

Frontend

  • React 19
  • Next.js 14
  • Vue.js
  • React Router
  • CSS Modules
  • Vite

Backend & APIs

  • Node.js
  • Express.js
  • REST API design
  • NextAuth
  • OAuth 2.0
  • .NET

Databases

  • MongoDB
  • PostgreSQL
  • MySQL
  • SQL Server
  • Azure SQL

Google Workspace

  • Apps Script
  • Sheets API
  • Drive API
  • Google Sites
  • Docs API
  • SMTP mailers

Analytics & reporting

  • Advanced Excel
  • Looker Studio
  • Power BI
  • Tableau
  • Pandas
  • NumPy

Cloud & tooling

  • Vercel
  • Git
  • GitHub
  • AWS
  • Docker

How I build

  • Role-based access control
  • Approval workflows
  • Automated notifications
  • Audit trails
  • Data reconciliation

Career

Experience

  1. Process Automation Executive

    Crystal Logistic Cool Chain Ltd. · Mumbai

    — Present

    • Built and shipped the accounts and collection team's system of record, covering receivables across six order types, ageing and outstanding pivots, follow-up logging, payment recording, dispute resolution and management MIS.
    • Architected a company-wide order-to-payment platform, replacing a chain of Google Forms and Apps Script tools with one stage-gated pipeline and two digitised multi-level approval chains.
    • Engineered JavaScript-based sales order workflow automation, cutting processing time by 40%.
    • Developed an Inventory Management System with automated tracking and reporting, cutting manual errors by 75%.
    • Built a Sales Dashboard summarising daily, weekly and monthly call status for monthly reporting, cutting pending task backlogs by 60%.
    • Delivered a Vue.js indent application with digital approval signatures, a cross-departmental Accounts FMS, Looker Studio dashboards for pending SOP work, and an internal hub linking every department dashboard.
    • Next.js
    • React
    • Node.js
    • MongoDB
    • Vue.js
    • Apps Script
    • Looker Studio
  2. Data Analyst Intern

    Excelerate · Remote

    • Analysed market trends and Facebook advertising performance with Python and Excel, and optimised campaigns from that data to improve return on investment and conversion rates.
    • Delivered data-backed recommendations to stakeholders and led project execution with an emphasis on data-driven decision-making.
    • Python
    • Excel
    • Campaign analytics
  3. Summer Analytics Intern

    C&A, IIT Guwahati · Remote

    • Analysed car specification, retail sales and trading-card datasets to identify trends, using Python and Excel for cleaning, statistical analysis and visualisation.
    • Produced reports and presentations communicating findings and recommendations to the team.
    • Python
    • Statistics
    • Visualisation

Education

  • B.Sc. Information TechnologyD. G. Ruparel College, Mumbai University
    CGPA 7.9
  • Higher Secondary CertificateVIVA College
    55.69%
  • Secondary School CertificateU. S. Ostwal English Academy
    79.60%

Contact

Let's talk

Open to full-time roles and freelance work in process automation, full-stack development and MIS. I reply to everything.