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.
OCR-processed
linked to master sheet
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
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.
Data Analyst
Fyn Mobility · Internship
Dec 2025 – Feb 2026
Education
Certifications
- Oracle Analytics Cloud Certification
- Power BI for Data Analysis
- Advanced Excel for Data Analysis
- Data Analytics using Excel
Technologies & Skills Bento
A structured breakdown of my tools, automation pipelines, analytics stack, and delivered operational impact.
Fleet Workflow Automation & Scripting
Designing resilient, zero-maintenance scripts that bridge field operations with real-time financial reporting.
BI & Dashboards
Transforming complex fleet telemetry & compliance logs into executive decision boards.
SQL & Databases
Writing optimized Metabase queries for multi-city fleet downtime, utilization, and billing reconciliation.
FROM fleet_downtime_logs;
Python & Data Science
Exploratory data analysis, statistical modeling, data preparation, and full-stack web products.
Impact in Numbers
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 .
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.
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.
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.
E-Commerce & Payment Solutions
Online stores with integrated payment gateways (Razorpay, Stripe, UPI), automated inventory sync, streamlined checkout flows, and headless e-commerce architectures.
How I Work
From Data to 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.
Automation Impact: Before vs. After
How Google Apps Script and Drive/Sheets APIs transformed daily operations at Fyn Mobility.
Vendor Invoice Processing
90% Time Saved4–5 hours daily extracting details manually from ~120 scanned PDFs into spreadsheets.
~300 mins/day • High error riskAutomated batch OCR with Drive API v3. Auto-populates dates/amounts with "Needs Review" flag.
~30 secs 1-click • 99% accuracyDocument-to-Vehicle Sync
Instant Click-ThroughSearching Google Drive folders one by one to find RC/FC/Insurance files for 430+ vehicles.
5–10 mins/vehicle • Mismatched filesVehicle registration numbers auto-matched, standardized & batch-renamed with direct links in Sheet.
< 3 seconds • 430+ PDFs indexed4-Wheeler PDI Inspection
100% Digital AuditPhysical clipboards, delayed WhatsApp photo sharing, and untracked pre-delivery defect notes.
Paper-based • Untracked backlogMulti-step wizard UI on mobile/tablet for field engineers with real-time photo uploads and validation.
Real-time sync • 0 missing stepsTurnaround Time (TAT) & Billing
0 Disputed ClaimsSubjective ticket closures, non-standardized calendar math, and manual dispute reconciliations.
Manual calculations • Frequent disputesSQL & Sheets logic with date-window capping, inclusive day counting, and automated EMI billing waivers.
Instant audit • 100% transparentEV Fleet Automation & ROI Simulator
Simulate the quantifiable business impact of Jayprakash's automated Drive OCR pipelines, SQL downtime billing rules, and document synchronizers.
Work
Featured Projects & Live 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.
Road Accident Analysis Dashboard
417,883 road casualty records needed cleaning and a way to explore patterns by vehicle type, surface, lighting, and region.
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.
Face Detection
Needed a simple, browser-based way to detect and identify faces in images or video without any backend.
7ORVIX — Digital Product Agency
Co-founded a digital agency delivering high-performance web applications, SaaS platforms, brand systems, and custom client management portals.
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.
Invoice OCR — automated extraction of ~120 scanned vendor invoices via Drive OCR (Drive API v3).
Document sync — Drive-to-Sheet automation matching vehicles to RC/FC/Insurance files.
Fleet compliance dashboards in Power BI & Google Sheets, tracking RC/FC/Insurance by city and OEM.
PDI web app — a multi-step Apps Script wizard digitizing the 4-wheeler inspection workflow.
Service-ticket TAT reporting with business rules for date-window and open-ticket handling.
SQL fleet analytics in Metabase — downtime, utilization, and EMI-waiver billing.
Financial reconciliation — a five-sheet Excel workbook resolving a security-deposit shortfall.
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.
AI strategy presentations ("Right Roster," vehicle-damage identification, ADAS/DMS) and a Q1 FY2026-27 performance review.
Categorized 232 fleet issues across four categories and extracted service-invoice data from dealer documents.
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!
- vehicle_id (TEXT, PK)
- registration_no (TEXT)
- hub_city (TEXT)
- oem_vendor (TEXT)
- status (TEXT)
- monthly_emi_inr (REAL)
- 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)
- 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.
Live Query Results
Ready to execute • In-Memory EngineKnowledge Sharing & Data Insights
Practical case studies, open-source automation scripts, and data architecture breakdowns shared across industry platforms.
Production SQL & Automation Scripts
Public repositories for Google Apps Script pipelines, complex Metabase downtime SQL queries, and end-to-end analytics workflows.
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.
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.
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 TeamCollaborated 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 OfficeDemonstrated 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 ScienceMentored 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 RecommendationsInterested 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.
Direct Channels
Choose the fastest channel to reach me directly. Quick replies guaranteed within 24 hours.
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.