Turning complex operational data into clarity, structure, and actionable insights.
Data Analyst specializing in field operations, reporting, data cleaning, and workflow coordination. Bridging the gap between messy real-world datasets and high-impact strategy.
Workflow Speedup
Via Sheets automation
SELECT COUNT(id), status FROM goonj_ops GROUP BY status;
01. About Me
Bridging Operational Complexity with Structured Analytics
Rohit Kumar
Data Analyst @ Goonj
Systems-oriented operations and data professional with hands-on experience in field operations, workflow coordination, reporting, and operational data structuring at Goonj. Experienced in monitoring field-level information, maintaining operational tracking systems, and supporting decision-making through organized reporting and analytics.
Continuously building technical skills in data analysis, Python, Linux, cybersecurity fundamentals, OSINT basics, and AI-assisted workflows.
Core Philosophies & Additional Interests
02. Live Analytics Dashboard
Real-Time Data Pipeline Monitoring & Operational Control Panels
Interactive Data-Cleaning Pipeline
A visualization of raw field survey inputs (containing typical duplicates, inconsistent formats, and missing coordinates) being restructured into standard analytical formats.
| Site ID | Date | Packs | Status |
|---|---|---|---|
| G-N042 | 24-05-'26 | NULL | Incomplete |
| G-N042 | 2026/05/24 | 450 | Incomplete |
| G-S109 | 24-05-2026 | 1,200 | Delivered |
| g-s109 | 24-May | 1200 | Delivered |
| Site ID | Clean Date | Packs (Int) | Status (Cat) |
|---|---|---|---|
| Run Cleaner to de-duplicate and structure. | |||
Field Logistics Distribution & Speed
Tracks material distribution cycles, transit routing optimization, and coordinate dispatch times across active centers, facilitating data-driven logistics decisions.
Database Core Benchmarking
Review active relational mapping logs. Rohit structures backend indexing to keep field operational retrieval times under 50ms, facilitating prompt automated CSV and Sheets outputs.
CREATE INDEX idx_site_status
ON field_operational_logs (site_id, status);
EXPLAIN ANALYZE
SELECT site_id, COUNT(*)
FROM field_operational_logs
WHERE status = 'pending'
GROUP BY site_id;03. Skills & Analytical Tools
A Matrix of Technologies and Operational Methodologies
Data & Analytics
Operations
Technical
AI & Productivity
04. Interactive Shell Console
Direct CLI access to Rohit Kumar's local profiles and analytical databases
Welcome to Rohit Kumar's Analytical Operations Shell (v2.4-stable).
System time: May 24, 2026. Secure connection authorized.
Type help to view all available commands, or click quick triggers below.
05. Experience Timeline
Rohit's Career Milestones & Operational Roles at Goonj
Data Analyst
Goonj • Operational Analytics
- Analyzing and structuring field-level operational data for reporting and execution support.
- Managing operational tracking systems and maintaining reporting accuracy.
- Supporting workflow coordination and decision-making through organized data handling.
Sanjha Operations Support
Goonj • Backend Operations & Field-Data
- Supported backend operations and regional field-data coordination.
- Improved communication and operational reporting across teams.
- Maintained structured documentation and tracking systems.
Urban Relation Coordinator
Goonj • Campaign Operations
- Managed volunteer coordination and campaign operations.
- Handled reporting, tracking, and community engagement activities.
Fellow
Goonj • Grassroots & Rural Community
- Worked on grassroots initiatives and rural community engagement.
- Conducted field visits and documentation activities in Rajasthan and Chhattisgarh.
06. Analytical Projects
Real-World Case Studies & Custom Tools Built for Data Structuring
Kolabo AI Media Kit Generator
An AI-powered media kit generation platform helping creators and professionals structure information and generate sleek, design-forward media kits instantly.
Automated Field Report Pipe
A highly modular script system that parses, validates, and reports logistical inventory details from remote Goonj field operations into single databases.
Ops Inventory Analysis Core
Advanced composite SQL indexing and Python analytical algorithms that isolate operations constraints, speed up queries 30x, and forecast flows.
07. Certifications & Credentials
Verified professional expertise in databases, security, and analysis
Pre Security Certificate
TryHackMeCompleted foundational cybersecurity concepts including networking basics, operating systems, security fundamentals, and threat awareness.
Verified CredentialThe Legend of Python
CodédexCompleted Python fundamentals and programming exercises focused on logic building and problem-solving.
Verified Credential08. Let's Connect
Establish a Secure Connection
Operational Intel Desk
Have an analytical challenge, a workflow optimization requirement, or interested in database systems coordinate? Secure your connection below.
Need a high-quality copy of Rohit Kumar's analytical background for off-line review? Download his curriculum vitae instantly.
Download Professional CV