SANGRAM.
SQL reporting · Data cleanup · Linux automation

Clear answers from your data. Servers that just keep running.

Hi, I'm Sangram Jamdade. I write SQL reports, organize and analyze data, and build practical Linux shell automation for small businesses and solo founders.

Services

What I can help with

Practical, clearly scoped support for data reporting and everyday Linux tasks.

SQL queries & reports

Joins, aggregations, filters and business-focused reports that turn tables into useful answers.

Data cleanup

Help identify duplicates, inconsistent formats and missing values so datasets are easier to work with.

Linux setup & automation

Basic Linux tasks, Bash scripts, scheduled jobs and routine folder backup automation.

GitHub portfolio

Projects I've built

These are hands-on practice projects. Open the repositories to review the code, documentation and implementation details.

Practice project · SQL / SQLite

Sales Report: SQL Practice Project

A small online-shop dataset used to answer business questions about regional revenue, monthly performance and best-selling products.

  • Built a synthetic SQLite database with 4 tables: customers, products, orders and order items.
  • Analyzed 200 sample customers and 1,500 orders dated January–October 2026.
  • Created reports for revenue by region, monthly revenue with month-over-month change, and top 5 products by revenue.
  • Used multi-table JOINs, GROUP BY, CTEs, COUNT DISTINCT and the LAG() window function.
SQLiteSQLJOINCTEWindow functions
Dataset is synthetic; no real customer data is used.
Practice project · Linux / Bash

Linux Backup Script

A Bash script that creates dated compressed backups of a selected folder, removes older archives and records activity in a log.

  • Accepts source and destination folders, with an optional retention period.
  • Creates timestamped .tar.gz archives.
  • Removes backup archives older than the configured number of days (7 by default).
  • Writes timestamped activity to backup.log and checks for a valid source directory.
  • Includes a cron scheduling example for a nightly run.
LinuxBashtarfindcronLogging
Demonstration project tested on sample folders; review README for usage.
-- Example: revenue by region
SELECT c.region,
       COUNT(DISTINCT o.id) AS orders,
       ROUND(SUM(oi.quantity * p.price), 2) AS revenue
FROM orders o
JOIN customers c ON c.id = o.customer_id
JOIN order_items oi ON oi.order_id = o.id
JOIN products p ON p.id = oi.product_id
GROUP BY c.region
ORDER BY revenue DESC;
Simple process

How I work

1. Scope

Understand the task

Share the question, dataset or Linux task. I'll clarify the expected output and scope.

2. Build

Work through the solution

I'll prepare the query, report or script and check it against the agreed requirements.

3. Hand off

Explain the result

Receive the deliverable with practical notes so you can understand and reuse it.

Let's talk about your task

Send a SQL question, data-cleanup requirement or Linux automation task. I'll help clarify the scope and expected deliverable.

sangramjamdade01@gmail.com ↗