Kapil Dev V

Product Manager

Bangalore Urban, Karnataka, India10 yrs experience
Most Likely To SwitchAI ML Practitioner

Key Highlights

  • Reduced reporting time from 18 hours to 30 minutes.
  • Eliminated ₹10–30 Cr/month transaction failures.
  • Designed high-performance fact tables processing 2M+ daily transactions.
Stackforce AI infers this person is a Fintech and E-commerce data analyst with strong automation and business intelligence skills.

Contact

Skills

Core Skills

Web & App DevelopmentAi Tools & AutomationP&l ForecastingBusiness IntelligenceAutomationData Engineering

Other Skills

Claude SkillsOpenAI CodexGMV & Revenue AnalyticsSQLPythonPower BIMicrosoft ExcelGoogle SheetsBusiness Intelligence ToolsProblem SolvingDatabase AnalysisLookerAthenaRedashBusiness Data Management

About

I help businesses make better decisions with data, automation, and practical software solutions. I currently work as a Senior Data & Finance Analyst at Paytm, where I handle P&L forecasting, revenue analytics, GMV planning, and business intelligence across multiple verticals and categories. Alongside my analytics work, I also build websites, web apps, internal dashboards, automation tools, and AI-powered workflows for businesses, founders, and small teams. Over the last 9+ years, I have worked across fintech, e-commerce, and operations analytics, building solutions that improve reporting speed, reduce manual work, and support better business decisions. Some of my key work includes: • Built GMV forecasting models to reduce transaction-failure exposure of ₹10–30 Cr/month • Created demand-planning models that helped reduce working-capital interest cost by ₹55L/month • Automated reporting workflows, reducing manual reporting time from 18 hours to around 30 minutes • Designed high-performance fact tables processing 2M+ daily transactions • Built reconciliation pipelines using Python and SQL for large bank and transaction datasets I also work on freelance projects involving: • Business websites • Portfolio websites • Restaurant, fitness, spa, and service-business websites • Wedding and special-occasion invitation websites • Internal dashboards and reporting tools • AI workflow automation using Claude, Codex, Antigravity, Ollama, and LLM tools My strength is combining business understanding with technical execution. I can understand the problem, analyze the numbers, design the workflow, and build the solution. Core areas: • P&L Forecasting • GMV & Revenue Analytics • SQL, Python, R, Excel, Google Sheets • Web & App Development • Business Intelligence Dashboards • AI Tools & Automation • LLM Workflows • Financial Modeling I am also the author of Shortcut Smarts: Mastering Excel and Google Sheets, a practical guide for people who want to work faster with spreadsheets. Open to freelance website, app, analytics, dashboard, and AI automation projects.

Experience

10 yrs
Total Experience
2 yrs 6 mos
Average Tenure
4 yrs 11 mos
Current Experience

Self-employed

Freelance Web & App Developer | AI Automation & Analytics Consultant

Apr 2026Present · 2 mos · Bangalore, India · Remote · Remote

  • I help businesses build websites, web apps, dashboards, and automation systems that reduce manual work and improve digital presence.
  • Services include:
  • Business websites for restaurants, gyms, spas, service providers, and local businesses
  • Portfolio and personal-brand websites
  • Wedding, birthday, baby-birth, and special-occasion invitation websites
  • Web apps and internal tools for business workflows
  • Dashboards for finance, sales, operations, and performance tracking
  • AI-assisted automation using Claude, Codex, Antigravity, Ollama, and LLM tools
  • SQL, Python, Excel, and Google Sheets automation
  • I focus on practical, fast, and affordable solutions for small businesses, founders, and teams that need professional digital tools without long agency timelines.
Claude SkillsOpenAI CodexWeb & App DevelopmentAI Tools & Automation

Paytm

Senior Data & Finance Analyst

Jul 2021Present · 4 yrs 11 mos · Bangalore Urban, Karnataka, India · Hybrid

  • Profitability & Forecasting
  • Designed a statistical GMV forecasting model (hourly mean + 2σ) achieving 95% coverage and 120% buffer accuracy for prepaid demand planning.
  • Eliminated ₹10–30 Cr/month transaction failures and reduced working-capital interest cost by ₹55 Lakhs/month.
  • Own revenue and bottom-line forecasting across 3 verticals and 17 business categories.
  • Data Engineering & Automation
  • Built high-performance fact tables processing ~2M transactions/day, reducing query failures and improving reporting runtimes across finance teams.
  • Automated daily P&L dashboards, cutting reporting time from 18 hours to 30 minutes.
  • Reconciliation & Recovery
  • Built Python (Pandas) pipelines to reconcile 20–30 bank CSV files (10L+ rows each) with transaction systems.
  • Recovered partner bank discounts by automating multi-file joins and audit workflows.
P&L ForecastingGMV & Revenue AnalyticsSQLPythonData EngineeringAutomation+1

Udaan.com

Data Analyst

Jul 2019May 2021 · 1 yr 10 mos · Harlur

  • Built seller performance and audit dashboards in Power BI, reducing return rates from 3% to 1%.
  • Automated compliance and deadline-tracking systems, improving 24-hour resolution from 56% to 95%.
  • Built internal claim-tracking tools covering 99% of cases and reducing leakage.
Power BISQLBusiness Intelligence

[24]7.ai

Management Information System Analyst

Apr 2016Jul 2019 · 3 yrs 3 mos · Bangalore Urban, Karnataka, India · On-site

  • Built productivity, CSAT/DSAT, and workforce optimization dashboards for operations and finance teams.
  • Automated utilization and performance reporting to support capacity planning.
Microsoft ExcelGoogle SheetsBusiness Intelligence

Education

Madurai Kamaraj University

Bachelor of Business Administration - BBA

Jan 2018Jan 2021

Mother India higher secondary school

8th to 12th — Biology science

Jan 2006Jan 2010

JKG International School

5th — 7th

Jan 2003Jan 2005

Stackforce found 100+ more professionals with Web & App Development & Ai Tools & Automation

Explore similar profiles based on matching skills and experience