I'm Jayprakash Kumar
Data Analyst | Fleet Analytics & Automation
I'm a Fleet Data Analyst at Fyn Mobility, automating fleet data and document workflows with Google Apps Script and the Drive/Sheets API, alongside SQL, Excel, and Power BI for analytics and reporting. Experienced in data cleaning, dashboard development, compliance tracking, and financial reconciliation — turning repetitive processes into reliable, one-click systems and clear, decision-ready insights.
OCR-processed
linked to master sheet
analyzed (project)
categorized
ABOUT
Data Analyst | Fleet Analytics & Automation
I'm a Data Analyst at Fyn Mobility with hands-on experience automating data and document workflows for a multi-city EV fleet. I build Google Apps Script and Drive/Sheets API automations that remove manual effort, alongside SQL, Excel, and Power BI for analytics and reporting — with a focus on data cleaning, dashboard development, compliance tracking, and financial reconciliation.
Data Analytics
SQL • Excel • Power BI • Tableau
Fleet Analytics
Compliance • TAT • Utilization
Automation
Apps Script • Drive/Sheets API • OCR
Web / Data Products
HTML • CSS • JavaScript • React
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
Skills
Technologies & Tools I Use
Analytics & BI
- Power BI
- Tableau
- Metabase
- Advanced Excel
- Google Sheets
Programming
- SQL
- Python
- DAX
- JavaScript
- HTML5
- CSS3
Databases
- PostgreSQL
- MySQL
Python Libraries
- Pandas
- NumPy
- Matplotlib
- Seaborn
- Scikit-learn
Automation
- Google Apps Script
- Google Drive/Sheets API
- OCR / Drive API v3
- qpdf
Core Concepts
- ETL
- EDA
- Data Cleaning & Transformation
- Statistical Analysis
- Data Visualization
- Dashboard Reporting
Services
Services That I Provide
Data Analytics
Data collection, cleaning, and preparation with SQL, Python, and Excel to turn raw datasets into actionable insights.
Dashboard Development
Building dashboards and reports in Power BI, Tableau, and Google Sheets for compliance, utilization, and performance tracking.
Workflow Automation
Automating repetitive reporting and document workflows with Google Apps Script and the Drive/Sheets API.
Web Development
Responsive, user-friendly pages using HTML, CSS, JavaScript, and Bootstrap, with a focus on accessibility and cross-browser compatibility.
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.
Work
Personal Projects
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 small agency with friends, building websites, SaaS products and brand identities for startups and small businesses.
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.
Blog
My Blog on Social Media
GitHub
Browse the source behind my analytics projects, dashboards, and automation scripts.
