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.
Field Data
Receiving information from reports, spreadsheets, forms, and operational records gathered from different activities and stakeholders.
Data Cleaning
Standardizing formats, removing inconsistencies, resolving duplicates, and preparing information for analysis.
Structured Reporting
Organizing information into clear reporting systems, dashboards, and accessible documentation structures.
Analysis
Identifying patterns, trends, gaps, and opportunities by examining structured data and operational workflows.
Decision Support
Transforming findings into actionable insights that help teams make informed decisions and improve execution.
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
Analytical Focus Areas
Transforming unstructured information into organized reports requires clean pipelines and solid processes.
Data Cleaning & Validation
Standardizing formats, correcting inconsistencies, and preparing datasets for analytical pipelines.
Workflow Optimization
Structuring processes to eliminate repetitive tasks and improve information flow across teams.
Reporting Automation
Developing spreadsheet templates and scripts to automate calculations and present key summaries.
How I Think
A structured, 4-step methodology for turning unstructured information into clear insights
Information Auditing
I begin by assessing raw datasets and document structures to identify formatting discrepancies, duplicate records, and missing inputs.
Standardization
Next, I clean and organize the information. By applying formulas and formatting standards, I resolve anomalies and unify inconsistent entries.
Process Analysis
I examine workflows and structured data to locate bottlenecks, processing delays, and opportunities for automation.
Insight Delivery
Finally, I organize the findings into clean, visual summaries and reports. This equips teams with the clear information needed to support key decisions.
Skills & Analytical Tools
A Matrix of Technologies and Operational Methodologies
Data & Analytics
Operations
Technical
AI & Productivity
Analytical Thinking Workspace
An interactive showcase of my structural approach to data cleaning, analysis, and decision support
Data Cleaning
Transforming inconsistent information into structured and usable datasets.
Thinking Framework
- 1. Audit schema structure and identify missing fields.
- 2. Standardize date-time strings and text casing.
- 3. Remove duplication and isolate format outliers.
| Raw Value | Transformation | Clean Output |
|---|---|---|
| 24/May/26 | ISO Date Norm | 2026-05-24 |
| User #12 (DUP) | De-duplication | User #12 (Unique) |
| NULL | Value Imputation | 0 (Default) |
Pattern Discovery
Identifying trends, anomalies, and recurring operational patterns.
Thinking Framework
- 1. Plot historical averages to establish baselines.
- 2. Isolate spikes and periods of significant variance.
- 3. Cross-reference outliers with external events.
Process Analysis
Understanding workflows and identifying opportunities for improvement.
Thinking Framework
- 1. Map the end-to-end journey of information.
- 2. Identify processing queues and hand-off delays.
- 3. Propose automation for manual steps.
Reporting Logic
Organizing information into clear and actionable summaries.
Thinking Framework
- 1. Aggregate raw records into logical groupings.
- 2. Hide granular noise to emphasize key summaries.
- 3. Highlight status indicators (Completed, In Progress).
Decision Support
Turning structured information into insights that support better decisions.
Thinking Framework
- 1. Synthesize findings into options.
- 2. Contrast benefits, risks, and resource inputs.
- 3. Deliver clear, direct recommendations.
Option A: Base Process
Stable, but requires high manual overhead and coordination.
Option B: Script Assisted
Automates repetitive steps. Lowers duration by 85%. (Recommended)
Experience Timeline
Rohit's Career Milestones & Professional History
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.
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 Reporting Pipeline
A highly modular script system that parses, validates, and consolidates report logs from various operational sources into structured spreadsheets.
SQL Performance & Analytics
Advanced indexing techniques and data processing scripts designed to accelerate database retrieval times and optimize information query workflows.
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 CredentialLet's Connect
Establish a direct channel for inquiry and operations collaboration
Operational Database & Systems Desk
Have an analytical challenge, a workflow optimization requirement, or interested in database coordination? Reach out via the channels below.
Need a high-quality copy of Rohit Kumar's analytical background for off-line review? Download his curriculum vitae instantly.
Download Professional CV