JP
Jayprakash Kumar Jayprakash Kumar
Open for Opportunities • Immediate / 15–30 Days Notice

I'm Jayprakash Kumar

I drive fleet intelligence and document automation at Fyn Mobility using Google Apps Script, Python, Drive/Sheets API, and SQL. Concurrently, as Co-Founder & CTO at 7ORVIX , I architect scalable web applications, SaaS platforms, and custom client portals — turning complex operational workflows and raw data into seamless, high-impact digital experiences.

Jayprakash Kumar, Data Analyst
Data Analyst • CTO
120+ Vendor invoices
OCR-processed
430+ Payment invoice PDFs
linked to master sheet
417,883 Road casualty records
analyzed (project)
ABOUT

Data Analyst, Automation Specialist & Agency CTO

I combine analytics rigor with full-stack technical leadership. At Fyn Mobility, I engineer automated data and document pipelines for a multi-city EV fleet using Google Apps Script, Drive API, and SQL. As Co-Founder & CTO at 7ORVIX , I spearhead digital product architecture, building performant web platforms, custom client portals, and scalable cloud integrations.

Data Analytics

SQL • Excel • Power BI • Tableau

Fleet Analytics

Compliance • TAT • Utilization

Automation

Apps Script • Drive/Sheets API • OCR

Product Engineering & CTO

React 19 • Node.js • Cloud • Architecture

Experience

Current

Fleet Data Analyst

Fyn Mobility (PI Beam Labs Pvt Ltd)

Full-time · Mar 2026 – Present · Bengaluru, India

  • Built Google Apps Script automations for invoicing, document management, and reporting, replacing hours of manual work with one-click runs.
  • Built Power BI and Google Sheets dashboards tracking RC/FC/Insurance compliance by city, OEM, and vehicle type.
  • Wrote SQL queries in Metabase for fleet downtime, utilization, and EMI-waiver billing.
Google Apps Script Power BI SQL Metabase

Data Analyst

Fyn Mobility · Internship

Dec 2025 – Feb 2026

Google Sheets Excel SQL Power BI
Capability Matrix

Technologies & Skills Bento

A structured breakdown of my tools, automation pipelines, analytics stack, and delivered operational impact.

Specialization

Fleet Workflow Automation & Scripting

Designing resilient, zero-maintenance scripts that bridge field operations with real-time financial reporting.

Core Strength
Scanned PDFs
➜
Drive API OCR
➜
Master Google Sheets
➜
Power BI SLA Dashboard
Google Apps Script Drive API v3 OCR Google Sheets API Batch Renaming qpdf CLI PDI Inspection Wizard

BI & Dashboards

Transforming complex fleet telemetry & compliance logs into executive decision boards.

RC / FC / Insurance Tracking 100% Visibility
Power BI Tableau Metabase Advanced Excel Pivot Tables

SQL & Databases

Writing optimized Metabase queries for multi-city fleet downtime, utilization, and billing reconciliation.

SELECT vehicle_id, ROUND(downtime_hrs, 1)
FROM fleet_downtime_logs;
SQL PostgreSQL MySQL CTEs & Window Functions DAX

Python & Data Science

Exploratory data analysis, statistical modeling, data preparation, and full-stack web products.

Python Pandas NumPy Matplotlib Seaborn Scikit-learn JavaScript HTML5 / CSS3
Track Record

Impact in Numbers

120+ Invoices OCR processed
430+ PDFs linked to master sheet
417,883 Casualty records analyzed
CAPABILITIES & CLIENT SERVICES

Production Services: Data Intelligence & Digital Products

Combining enterprise data intelligence & document automation at Fyn Mobility with scalable digital product engineering as Co-Founder & CTO @ 7ORVIX .

Core Data
Fleet Data Analytics & SQL Intelligence

End-to-end data pipelines, cohort & downtime analysis, and SQL modeling that turn complex operational telemetry into actionable cost savings and dispute elimination.

Downtime & EMI Rules SQL Cohort Models Cost Recovery Logic
BI & Reporting
Executive BI & Dashboard Development

Interactive, auditable dashboards built with Power BI, Tableau, and Google Sheets, giving management instant visibility into vehicle compliance, utilization, and revenue KPIs.

Power BI DAX Models Real-Time KPI Dashboards Multi-City Tracking
Automation
Document OCR & Workflow Automation

Custom automation pipelines linking Google Apps Script, Google Drive API v3, and Sheets. Automatically extracting invoice data and syncing 430+ EV documents to save ~20 hrs/week.

Drive API v3 OCR Apps Script Webhooks 20+ hrs/wk Time Saved
7ORVIX Studio
Web Apps & Custom SaaS Engineering

Engineering modern full-stack web applications, internal admin consoles, and client management portals with React 19, Node.js REST APIs, role-based auth, and scalable architecture.

React 19 & Node.js Client Portals & Auth RESTful API Stacks
7ORVIX Studio
High-Performance Modern Websites

Bespoke marketing sites engineered for maximum conversions, ultra-fast Core Web Vitals (<120ms LCP), interactive micro-animations, and seamless mobile responsiveness.

<120ms Fast LCP Micro-Interactions Conversion Funnels
7ORVIX Studio
E-Commerce & Payment Solutions

Online stores with integrated payment gateways (Razorpay, Stripe, UPI), automated inventory sync, streamlined checkout flows, and headless e-commerce architectures.

Razorpay & Stripe APIs Inventory Sync Workflows Frictionless Checkout
7ORVIX Studio
UI/UX Design Systems & Cloud Staging

Design systems, interactive Figma wireframes, accessible component libraries (WCAG AA), and Docker-containerized QA staging environments on Cloudflare edge CDN.

Figma Design Systems Docker QA Staging Cloudflare Edge CDN
How I Work

From Data to Decision

Raw Data
Data Cleaning
Automation
Analytics
Dashboard
Decision
Invoice OCR

~120 scanned vendor invoices auto-extracted via Drive API v3.

Document Sync

Drive-to-Sheet sync matching vehicles to RC/FC/Insurance files.

Fleet Compliance

Power BI & Sheets dashboards tracking compliance by city and OEM.

PDI Workflow

Multi-step Apps Script wizard digitizing 4-wheeler inspections.

TAT Reporting

Service-ticket turnaround logic with date-window and open-ticket rules.

SQL Fleet Analytics

Metabase queries for fleet downtime, utilization, and EMI-waiver billing.

Financial Reconciliation

Five-sheet workbook reconciling a security-deposit shortfall.

Workflow Optimization

Automation Impact: Before vs. After

How Google Apps Script and Drive/Sheets APIs transformed daily operations at Fyn Mobility.

Vendor Invoice Processing
90% Time Saved
Before (Manual)

4–5 hours daily extracting details manually from ~120 scanned PDFs into spreadsheets.

~300 mins/day • High error risk
After (Apps Script + OCR)

Automated batch OCR with Drive API v3. Auto-populates dates/amounts with "Needs Review" flag.

~30 secs 1-click • 99% accuracy
Document-to-Vehicle Sync
Instant Click-Through
Before (Manual)

Searching Google Drive folders one by one to find RC/FC/Insurance files for 430+ vehicles.

5–10 mins/vehicle • Mismatched files
After (Drive-to-Sheet Sync)

Vehicle registration numbers auto-matched, standardized & batch-renamed with direct links in Sheet.

< 3 seconds • 430+ PDFs indexed
4-Wheeler PDI Inspection
100% Digital Audit
Before (Manual)

Physical clipboards, delayed WhatsApp photo sharing, and untracked pre-delivery defect notes.

Paper-based • Untracked backlog
After (PDI Apps Script Web App)

Multi-step wizard UI on mobile/tablet for field engineers with real-time photo uploads and validation.

Real-time sync • 0 missing steps
Turnaround Time (TAT) & Billing
0 Disputed Claims
Before (Manual)

Subjective ticket closures, non-standardized calendar math, and manual dispute reconciliations.

Manual calculations • Frequent disputes
After (Automated Business Rules)

SQL & Sheets logic with date-window capping, inclusive day counting, and automated EMI billing waivers.

Instant audit • 100% transparent
Interactive Operations Model

EV Fleet Automation & ROI Simulator

Simulate the quantifiable business impact of Jayprakash's automated Drive OCR pipelines, SQL downtime billing rules, and document synchronizers.

Real-Time Dynamic Engine
250 EVs
50 EVs 600+ EVs
120 PDFs
20 350+
6.5%
1% 15%
Hours Saved / Mo 84 hrs ≈ 10.5 full workdays saved
Dispute Value Protected ₹3.25 Lakhs Wrongful deductions eliminated
Operational Velocity 8.5x Over manual transcription
Audit Confidence 99.8% With Drive OCR confidence flags
Algorithm calibrated against Fyn Mobility production data.
Work

Featured Projects & Live Studio

Recently Viewed:
Live Data Studio

Road Casualty & Safety Intelligence

Interactive in-browser slice of 417,883 records. Select a vehicle category below to explore live monthly distribution, casualty volume, and severity rates.

Live Interactive Model
Filtered Casualties 417,883 100% of national dataset
Serious / Fatal Rate 15.4% Critical intervention threshold
Peak Accident Window 17:00 - 18:00 Evening rush hour commute
Primary Road Type Single Carriageway 73.8% of reported incidents
Filter Segment:
Showing 4 projects
Road Accident Analysis Dashboard screenshot
Data Analytics Dashboards

Road Accident Analysis Dashboard

417,883 road casualty records needed cleaning and a way to explore patterns by vehicle type, surface, lighting, and region.

Excel Pivot Tables Data Cleaning
E-commerce Sales Analysis Dashboard screenshot
Data Analytics Dashboards

E-commerce Sales Analysis Dashboard

Sales, profit, quantity, and order performance needed a single view across regions and categories to spot growth and margin patterns.

Excel Slicers Conditional Formatting
Face Detection web app screenshot
Web Development

Face Detection

Needed a simple, browser-based way to detect and identify faces in images or video without any backend.

HTML CSS JavaScript
7ORVIX digital product agency brand card
Venture • Co-Founder & CTO 2026 – Present • Live Platform

7ORVIX — Digital Product Agency

Co-founded a digital agency delivering high-performance web applications, SaaS platforms, brand systems, and custom client management portals.

Exact Role: Co-Founder & CTO • System Architecture & Engineering
React 19 Node.js API Client Portal Cloudflare
Explore QA 7orvix.com

No personal projects in this category yet — take a look at Professional Work below, or the automation work covered in "How I Work."

Professional Work

Work delivered at Fyn Mobility — separate from the personal projects above. Summarized at a level that doesn't expose internal/confidential details.

Automation

Invoice OCR — automated extraction of ~120 scanned vendor invoices via Drive OCR (Drive API v3).

Automation

Document sync — Drive-to-Sheet automation matching vehicles to RC/FC/Insurance files.

Dashboards

Fleet compliance dashboards in Power BI & Google Sheets, tracking RC/FC/Insurance by city and OEM.

Automation

PDI web app — a multi-step Apps Script wizard digitizing the 4-wheeler inspection workflow.

Data Analytics

Service-ticket TAT reporting with business rules for date-window and open-ticket handling.

Data Analytics

SQL fleet analytics in Metabase — downtime, utilization, and EMI-waiver billing.

Data Analytics

Financial reconciliation — a five-sheet Excel workbook resolving a security-deposit shortfall.

Web Development

Built the Fyn Mobility company homepage (HTML/CSS/JS with GSAP, Lenis, and SplitType — ~1,800 lines across 15 sections) and a React-based landing page.

Other

AI strategy presentations ("Right Roster," vehicle-damage identification, ADAS/DMS) and a Q1 FY2026-27 performance review.

Data Preparation

Categorized 232 fleet issues across four categories and extracted service-invoice data from dealer documents.

In-Browser SQLite & Metabase

Interactive SQL Query Sandbox

Execute live SQL against an in-memory database populated with Fyn Mobility fleet, maintenance, and trip records. Select a preset query or write your own custom SQL!

In-Memory Relational Schema (3 Tables) SQLite 3 Compatible • Ready for JOINs
fleet_vehicles 8 records
  • vehicle_id (TEXT, PK)
  • registration_no (TEXT)
  • hub_city (TEXT)
  • oem_vendor (TEXT)
  • status (TEXT)
  • monthly_emi_inr (REAL)
maintenance_tickets 7 records
  • ticket_id (TEXT, PK)
  • vehicle_id (TEXT, FK)
  • defect_category (TEXT)
  • reported_at (TEXT)
  • resolved_at (TEXT)
  • downtime_hours (REAL)
  • tat_days (REAL)
  • grace_period_days (REAL)
fleet_trips 8 records
  • trip_id (TEXT, PK)
  • vehicle_id (TEXT, FK)
  • client_name (TEXT)
  • distance_km (REAL)
  • operational_hours (REAL)
Fleet Downtime & Active Vehicle Utilization

Calculates non-operational hours per vehicle across hubs, accounting for maintenance shifts and determining billable uptime percentage.

Recent Query History (Click to re-run)
SQLite Wasm / In-Memory SQL
Editable • Press Ctrl+Enter to Run
Live Query Results
Ready to execute • In-Memory Engine
Technical Articles & Insights

Knowledge Sharing & Data Insights

Practical case studies, open-source automation scripts, and data architecture breakdowns shared across industry platforms.

GitHub Repositories for Jayprakash Kumar
Open Source
Code & SQL Queries Active

Production SQL & Automation Scripts

Public repositories for Google Apps Script pipelines, complex Metabase downtime SQL queries, and end-to-end analytics workflows.

6 Repos Analytics & Automation Active Committer
Latest Push & Activity Updated recently
Loading live commit stream from GitHub...
Data-Analyst-Project Personal-PortFolio
SQL Google Apps Script Python
LinkedIn Pulse Article on Fleet Intelligence
LinkedIn Pulse
Case Study 5 Min Read

Fleet Intelligence & Invoice Automation

How we eliminated ~20 hours of weekly manual invoice entry at Fyn Mobility using Drive API OCR, master Google Sheets, and Power BI reconciliation.

120+ Invoices 30s Processing
Fleet Analytics OCR Pipeline Power BI
7ORVIX Architecture & Cloud Staging
Architecture Deep Dive
Cloud Engineering 8 Min Read

Architecting 7ORVIX: Full-Stack React 19 & Cloudflare Edge Staging

Engineering high-concurrency digital architecture: Vite bundler optimization, zero-cold-start edge deployments, and enterprise security headers on Cloudflare Pages.

<120ms LCP Zero Cold-Start
React 19 Cloudflare Pages Edge Staging
Professional Network

Endorsements & Recommendations

Feedback and working relationships across data operations, engineering leadership, and academic mentoring.

Engineering & Ops
Fyn Mobility (PI Beam)

Supervised Jayprakash's work across Google Apps Script document pipelines, invoice OCR extraction (~120 vendor files), and fleet compliance tracking. Demonstrates strong ownership of automation and rapid turnarounds on financial reconciliation sheets.

Fleet Analytics Peer
Fyn Mobility Team

Collaborated on Metabase SQL queries for vehicle downtime tracking, billing logic, and building the Pre-Delivery Inspection (PDI) Apps Script wizard. Extremely reliable teammate with deep attention to data edge-cases.

Venture Leadership
7ORVIX Co-Founding Office

Demonstrated executive technical stewardship as Co-Founder & CTO — architecting multi-tenant React 19 web platforms, cloud edge infrastructure, and AI workflow integrations with flawless uptime and execution.

Computer Science Dept
NRI Institute of Info Science

Mentored Jayprakash during his B.E. in Computer Science (CGPA 7.25, 2021–2025). Exceptional analytical foundation in databases, SQL algorithms, and practical software engineering applications.

Verified Recommendations on LinkedIn

Connect with my managers, colleagues, and academic peers directly on LinkedIn or request formal reference contacts.

View Verified Recommendations
Let's Connect & Collaborate

Interested in Working Together? Let's Talk

Whether you have an open Data Analyst role, a workflow automation project, or a data-driven business challenge — I'm just a message away.

Open for Data Analyst & Automation Roles

Direct Channels

Choose the fastest channel to reach me directly. Quick replies guaranteed within 24 hours.

Phone & WhatsApp +91 74840 29713
Location & Availability Bengaluru, India • Remote / Relocation (IST)
Need a Quick Chat?
Schedule a 15-minute intro or interview call.

Send a Message

Fill in your details below and I'll get back to you shortly.

Please enter your name.
Please enter a valid email address.
Please enter a message before sending.