Hi, I'm
Suraj Singh

MIS Executive | Data Analyst | Expert in Data Visualization & Automation

Transforming raw data into actionable insights using Power BI, SQL, Excel VBA, and Python.

95%
Advance Excel
90%
Power BI
80%
Python & SQL
Contact Me

Featured Solutions

Custom ERPs, CRMs, and Business Tools at a fraction of the cost

💪

GymSarthi

Complete Gym Management System with membership tracking, renewals, and automated reminders.

Membership Management Auto Renewals SMS Alerts
📊

MunshiJi

Small Business ERP for distributors with GST billing, stock management, and client tracking.

GST Billing Inventory Client CRM
🛒

Rationkart

Inventory and order management system for retail businesses with real-time stock tracking.

Order Management Stock Tracking Analytics

Portfolio & Case Studies

Real problems. Real solutions. Real results.

📊

Case Study

GymSarthi

❌ The Problem

Gym owners were struggling with manual membership tracking, missing renewal dates, and losing revenue due to expired memberships. Engagement with members was low due to lack of automated communication.

✅ The Solution

Built a complete gym management system with automated renewal reminders via SMS/WhatsApp, member tracking, and payment collection features. The system auto-calculates expiration dates and sends alerts.

🔍 Detailed Analysis

The client needed a cost-effective solution that didn't require expensive hardware or monthly subscriptions. We leveraged Google Ecosystem to build a robust backend.

Key Features:
  • Automated Dashboard: Real-time view of active, expired, and upcoming renewals.
  • WhatsApp Integration: Auto-sends "Welcome", "Payment Received", and "Renewal Reminder" messages.
  • QR Code Attendance: Members scan QR to mark attendance, data saved to Sheets.
  • Expense Tracker: Built-in module to track gym expenses and calculate monthly profit.
Technical Stack:
Google Sheets (Database) Google Apps Script (Backend) HTML5/Tailwind (Frontend) WhatsApp API

📈 Business Impact

  • 20% Revenue Increase: Recovered lost revenue from unnoticed expirations in the first month.
  • 70% Admin Time Saved: Receptionists no longer spend hours checking registers.
  • Improved Member Retention: Timely reminders and birthday wishes improved customer loyalty.
📊

Case Study

MunshiJi ERP

MunshiJi

ERP

❌ The Problem

Distributors were managing GST billing, inventory, and client data across multiple spreadsheets, leading to errors and inefficiency. Stock mismatch was a frequent issue.

✅ The Solution

Developed a unified Small Business ERP with GST-compliant billing, real-time stock management, and integrated client CRM. It synchronizes inventory across all sales channels.

🔍 Detailed Analysis

The goal was to create a "Munshi" (accountant) that lives in the cloud. We built a custom interface on top of Google Sheets to allow easy data entry while maintaining complex formulas in the background.

Key Features:
  • One-Click GST Invoice: Generates professional PDF invoices and emails them to clients.
  • Inventory Sync: Automatically deducts stock upon sale and flags low-stock items.
  • Client Ledger: Tracks payments, outstanding dues, and payment history per client.
  • Route Planning: Optimizes delivery routes based on daily orders.
Technical Stack:
Google Apps Script Google Sheets PDF Generation Email Automation

📈 Business Impact

  • 100% GST Compliance: Automated tax calculations eliminated manual errors.
  • 60% Faster Billing: Invoice generation time reduced from 5 mins to 30 seconds.
  • Zero Stock Discrepancies: Live inventory tracking prevented overselling.
🛒

Case Study

Rationkart Platform

Rationkart

SaaS

❌ The Problem

Retail businesses lacked real-time visibility into inventory levels and order status, causing stockouts and customer dissatisfaction. Manual order taking via phone/paper was error-prone.

✅ The Solution

Created an inventory and order management system with live stock tracking, automated reorder alerts, and analytics dashboard. Integrated a mobile-friendly order interface for field agents.

🔍 Detailed Analysis

We transformed a traditional brick-and-mortar operation into a digitally managed supply chain. The focus was on "Order-to-Delivery" speed and accuracy.

Key Features:
  • Field Agent App: Agents can place orders on behalf of retailers directly from their phones.
  • Live Warehouse View: Admin dashboard showing current stock levels across multiple godowns.
  • Smart Procurement: System suggests what to buy based on sales velocity and lead time.
  • Delivery Tracking: Status updates for "Packed", "Dispatched", and "Delivered".
Technical Stack:
Google Apps Script Google Sheets Analytics Notifications

📈 Business Impact

  • 85% Reduction in Stockouts: Predictive ordering ensured popular items were always in stock.
  • Real-time Inventory Visibility: Eliminated the need for daily manual stock counting.
  • Automated Order Processing: Reduced order fulfillment time by 40%.
📄

Case Study

KarmSarthi HR Suite

KarmSarthi

HR Automation

❌ The Problem

HR teams spent hours manually creating salary slips and reports from raw spreadsheet data every month. This manual process was prone to calculation errors and delayed salary disbursements.

✅ The Solution

Built an automated salary reporting and PDF generator that converts Google Sheets data into professional salary slips instantly. It also handles bulk emailing of slips to employees.

🔍 Detailed Analysis

The client needed a system that could handle complex payroll logic (PF, ESI, Deductions) without investing in expensive HRMS software. We used Google Sheets as the database and Apps Script as the logic engine.

Key Features:
  • Dynamic Salary Structure: Supports various salary components and formulas.
  • Bulk PDF Generation: Generates 100+ salary slips in under 2 minutes.
  • Secure Distribution: Emails password-protected PDFs to employees automatically.
  • Compliance Reports: Auto-generates monthly PF and ESI return data.
Technical Stack:
Google Apps Script PDF Generation Email Automation Templates

📈 Business Impact

  • 90% Time Savings: Monthly payroll process reduced from 3 days to 30 minutes.
  • Professional Branding: Employees receive standardized, branded salary slips.
  • Zero Errors: Automated calculations eliminated manual data entry mistakes.
💼

Case Study

BillSarthi Web App

BillSarthi

Vendor Bills Management Web App powered by SarthiAI

Business Tool

❌ The Problem

Small business owners were managing vendor bills in scattered spreadsheets, manually tracking due dates, outstanding payables, and vendor-wise spending. Often, bills were lost or paid late.

✅ The Solution

Built BillSarthi, a Google Sheets–powered vendor bills management system with structured vendor ledgers, payment status tracking, and integrated SarthiAI inside the web app to answer payables and vendor queries in natural language.

🔍 Detailed Analysis

We wanted to democratize AI for small businesses. BillSarthi combines a robust ledger system with an AI chat interface that "talks" to your spreadsheet.

Key Features:
  • AI Query Engine: Ask "How much do I owe Vendor X?" and get an instant answer.
  • Smart Ledger: Automatically categorizes expenses and tracks payment history.
  • Payment Reminders: Sends alerts for upcoming due dates to avoid late fees.
  • Expense Analysis: Visual charts showing spending patterns over time.
Technical Stack:
Google Apps Script Google Sheets OpenAI API Web App

📈 Business Impact

  • Improved Cash Flow: Better visibility into payables helped in fund planning.
  • Stronger Vendor Relations: On-time payments and transparent ledgers built trust.
  • Instant Insights: Business owners got answers in seconds instead of digging through files.
📦

Case Study

StockSarthi Inventory

StockSarthi

Inventory Tool

❌ The Problem

SMEs had no simple way to track stock levels, purchases, and sales in one place. Complex inventory software was too expensive and difficult to learn for small teams.

✅ The Solution

Designed StockSarthi as a lightweight inventory tracking layer on top of Google Sheets with item-wise stock, movement history, and automated reorder alerts sent to Telegram.

🔍 Detailed Analysis

The client needed a "forever free" solution that could scale with their business. We utilized the power of Google Sheets queries and Apps Script triggers.

Key Features:
  • Live Dashboard: Visual indicators for Low Stock and Out of Stock items.
  • Telegram Alerts: Instant notifications when stock drops below threshold.
  • Barcode Scanning: Mobile-friendly interface to scan and update stock.
  • Profit/Loss Report: Auto-calculated daily profit based on FIFO method.
Technical Stack:
Google Apps Script Google Sheets Telegram Bot API Web App

📈 Business Impact

  • 100% Stock Visibility: Eliminated guesswork in procurement.
  • Reduced Wastage: FIFO tracking prevented expiry of perishable goods.
  • Zero Learning Curve: Staff started using it within 10 minutes.

My Skills

Technical expertise and proficiency

Advance Excel 95%
Power BI 90%
Python 80%
SQL 80%
Data Analysis 80%
Data Visualization 80%

Additional Technologies

HTML CSS JavaScript React Node.js Excel VBA Pandas Numpy Matplotlib Seaborn

Education & Certifications

Education

Bachelor of Commerce

Delhi University

2018 - 2021

Graduated with B.com but I have Strong Interest in Data and Data Scientist.

Certifications

Advanced Excel

Govt. Recognized Institute

2017

Completed intensive program covering Advance Excel.

Python for Data Analyst

Certification

2024

Expertise in Data Cleaning, Data Analysis, and Data Visualization.

Power BI for Data Analyst

Certification

2024

Expertise in ETL, Data Analysis, and Data Visualization.

Data Analytics

Certification

2024

Data Analyst in use Excel, SQL, and Python.

Client Testimonials

What my clients say about working with me

RS

Rajesh Sharma

Gym Owner, Mumbai

"GymSarthi has completely transformed how I manage my gym. No more missed renewals, and my members love the automated reminders. Suraj understood exactly what I needed!"

AK

Amit Kumar

Distributor, Delhi

"MunshiJi made GST billing so simple! I was spending hours on paperwork, now everything is automated. Best investment for my business. Highly recommended!"

PM

Priya Mehta

HR Manager, Pune

"KarmSarthi saved us 90% of our payroll processing time. Professional salary slips generated in seconds. Suraj's expertise in automation is exceptional!"

VG

Vikram Gupta

Retail Store Owner, Bangalore

"Rationkart helped us eliminate stockouts completely. Real-time inventory tracking is a game-changer. Worth every rupee!"

SK

Sandeep Kapoor

Small Business Owner, Jaipur

"Suraj doesn't just code, he understands business. His solutions are practical, affordable, and actually work. A true professional!"

About Me

MIS Executive & Data Analyst

Suraj Singh - Data Analyst

Hi, I'm Suraj Singh

I graduated with a Bachelor of Commerce from Delhi University (2018-2021), but my passion lies in Data Science and Analytics.

I am an MIS Executive and Data Analyst with expertise in transforming complex data into clear, actionable insights. My core strengths include Data Cleaning, Data Analysis, ETL processes, and Data Visualization.

I specialize in using tools like Advanced Excel, Power BI, SQL, and Python. I am proficient in Python modules such as Pandas, NumPy, Matplotlib, and Seaborn to analyze trends and visualize data effectively.

Whether it's automating reports with Excel VBA or building interactive dashboards in Power BI, I focus on delivering accuracy and efficiency in data reporting.

Data Analyst
SQL Expert
Python Developer
Advanced Excel

Let's Connect

Ready to automate your business with Google Apps Script and AI? Let's discuss your project.

Get in Touch

Location

Noida Sec-115, Utter Pradesh

Follow Me

Send a Message