Gunal K

Gunal K

Data Analytics Consultant

I turn raw business data into decisions that make money. Specialized in payment analytics, churn prediction, and marketing attribution — for fintech, SaaS, and D2C brands globally.

Fintech Analytics D2C Intelligence SaaS Metrics

About Me

Independent data consultant working with businesses across fintech, SaaS & D2C

Gunal K

I help businesses stop bleeding money through data.

Most companies collect data but can't answer basic questions: Which marketing channel actually works? Why are customers leaving? Where is revenue leaking?

I specialize in finding these answers through:

Revenue Analytics: Payment failure tracking, pricing optimization, leak detection
Customer Intelligence: Churn prediction, segmentation, LTV modeling
Performance Optimization: Marketing attribution, ROI analysis, budget allocation

Projects & verified work:
Analyzed 3.5M+ payment transactions — surfaced ₹4.84M in recoverable revenue
Built XGBoost churn model at 90.3% accuracy (AUC 0.978) on 1,700+ student records
Designed multi-touch attribution framework showing 2.3x projected ROAS uplift

Technical Expertise

Currently Exploring

Areas I'm actively researching and experimenting with

📊

Causal Inference in Analytics

Moving beyond correlation — studying DoWhy and CausalML to answer "did this campaign actually cause the uplift, or was it coincidence?" Applying it to attribution modeling.

Active Updated this week

dbt + SQL for Analytics Engineering

Learning dbt (data build tool) to write modular, version-controlled SQL pipelines. Goal: build analytics stacks that don't break when the data changes upstream.

Active Updated this week
🤖

AI-Augmented Reporting

Experimenting with using LLM APIs to auto-generate plain-English summaries from dashboard data. Testing if non-technical stakeholders can get insights without opening a BI tool.

Exploring Updated 2 weeks ago
🎯

Cohort & Retention Modeling

Deep-diving into retention curve analysis and cohort LTV modeling. Building frameworks to tell SaaS founders exactly which user segments are worth acquiring vs. optimizing.

Learning Updated 1 week ago

Business Solutions

Specialized consulting for data-driven growth

Featured Work

Independent data projects — real datasets, real methodology, real output

Fintech

Payment Intelligence System

End-to-end analysis of 3.5M payment transactions — identified 9.98% failure rate, ₹4.84M revenue at risk, and 5 actionable fixes with SQL + Python + Power BI.

Power BI SQL Python
View Full Case Study →
SaaS

Churn Prediction Engine

Built ML model achieving 90.3% accuracy, enabling early intervention on 280+ at-risk accounts monthly.

Python Scikit-learn Tableau
View Full Case Study →
D2C

Marketing Attribution Framework

Multi-touch attribution model across 2,847 customer journeys — revealed Instagram was undervalued by 3.75x under last-click. Budget reallocation projected 2.3x ROAS improvement.

Power BI Google Analytics API SQL
View Full Case Study →
Live AI Product — Try It Free

Meet DataSpeak
Your data, explained
in plain English.

Upload any CSV and get instant business intelligence — anomaly detection, revenue risk identification, and prioritised recommendations. No signup. No setup. No analyst required. Powered by Groq + Llama 3.3 with real statistical analysis under the hood.

116K+
Transactions analysed
₹4.84M
Revenue risk found
30s
Average analysis time
  • Auto-profiles your dataset — rows, columns, types, missing data
  • Detects statistical anomalies automatically using Z-score method
  • Identifies revenue risks and operational gaps
  • Delivers prioritised recommendations with timelines
  • Works on payment, sales, churn, marketing — any CSV
  • Download full report as .txt file
dataspeak.streamlit.app
⚡ AHI Light
DataSpeak
Your data, explained in plain English
📂
payment_transactions.csv — 12.7MB ✓
116,571 rows · 15 columns · Ready
9.8%
Failure Rate
₹4.84M
Revenue at Risk
11,634
Failed Transactions
₹414.93
Avg Transaction
🔴 Revenue Risk
UPI payments failing at 10.3% vs 8.5% for cards — ₹1.3M annual loss
⚠️ Operational
RAZORPAY_PG1 failure rate 10.9% vs 8.2% — ₹540K recoverable
📈 Pattern
Peak-hour failures 11.4% vs 9.3% off-peak — infrastructure bottleneck
Groq API Llama 3.3-70B Streamlit Python Pandas

🎮 Try My Models Live

Don't just read about my work - interact with it. These models run in your browser.

📉 Churn Risk Predictor

Predict if a student will churn based on behavior

💳 Payment Success Predictor

Will this payment succeed?

📊 Marketing ROAS Optimizer

Optimize your channel budget allocation

Professional Experience

Internship, certifications & independent project work

Independent Data Analytics Projects

Self-Directed Portfolio Work | 2024 – Present

  • Payment failure analysis on 3.5M transaction dataset — SQL, Python, Power BI full stack
  • XGBoost churn prediction model (90.3% accuracy, AUC 0.978) on edtech platform data
  • Multi-touch attribution framework across 2,847 customer journeys
  • Built interactive ML demos (churn predictor, payment success model) running live in browser

AI-Powered Data Analysis Intern

RIT × Excelerate Remote Internship | Oct 2025

  • Recognized as Star Performer across cohort for analytics deliverables
  • Applied ML and visualization to real edtech business problems
  • Built churn prediction system — model and full Python analysis pipeline

Analytics Training Programs

Google (Coursera) · Infosys Springboard · IBM SkillsBuild

  • Completed Google Advanced Data Analytics 8-course certificate (Aug 2025)
  • Data science, Python, regression modeling, machine learning fundamentals
  • Applied coursework projects in BI dashboard development and predictive modeling

Professional Certifications

Validated expertise in data analytics and AI

Google Advanced Data Analytics Certificate
Professional Certificate

Google Advanced Data Analytics

Google & Coursera

Completed 8-course professional certificate covering foundations of data science, Python programming, statistical analysis, regression modeling, machine learning fundamentals, and advanced analytics capstone.

Completed: August 2025 Verify →
RIT Star Performer Certificate
Star Performer

AI-Powered Data Analysis Internship

Rochester Institute of Technology × Excelerate

Recognized as Star Performer for outstanding achievement in AI-powered data analysis remote internship. Applied advanced analytics, machine learning, and visualization techniques to real-world business problems.

Completed: October 2025 Request Verification →

Insights

Data analyses and business perspectives

Why Payment Success Rates Drop on Mondays

Analysis of UPI transaction data showing 3% lower success on Monday mornings. Hypothesis: Weekend system maintenance + Monday traffic spike.

Read analysis →

The CAC Paradox: Why Higher Spend Doesn't Mean Better Customers

Analyzed 5 D2C brands. Found inverse relationship between CAC and LTV in 3/5 cases. Premium customers often come from organic, not ads.

Read analysis →

Churn Happens on Day 3, Not Day 30

Most SaaS churn prediction models look at 30-day behavior. But engagement data shows the decision happens by Day 3.

Read analysis →
Process

How I Work

Simple process. Fast delivery. No surprises.

01
Discovery

30-min free call

You explain the problem. I tell you exactly what I'd look at and whether I can help. No pitch. No commitment.

Free · No commitment
02
Scoping

Clear proposal in 48hrs

Exact scope, deliverables, timeline, cost. Everything in writing before any work starts. No vague retainers.

48hr turnaround
03
Execution

3–7 day delivery

SQL, Python, Power BI — whatever the problem needs. You get progress updates. Not silence for a week then a surprise.

SQL · Python · Power BI
04
Handoff

Dashboard + action list

Not a 47-slide deck. You get a dashboard, 3–5 clear actions, one walkthrough call, and 7 days of follow-up support.

7-day follow-up included
3–7
Day delivery
100%
Remote
24hr
Response time
IST+
Timezone flexible
Book Free Discovery Call →

Resume

Full credentials, projects, and experience — view inline or download

Gunal K — Data Analyst · Business Intelligence & KPI Reporting

Last updated June 2026 · Bengaluru, India · Available immediately

GUNAL K
Data Analyst · Business Intelligence & KPI Reporting
Bengaluru, India +91 7418096065 gunalkrish8@gmail.com LinkedIn GitHub Portfolio
Profile

Data Analyst skilled in SQL, Python, Power BI, Excel, KPI reporting, and business intelligence. Experienced in analysing 3.5M+ transaction records, building automated reporting solutions, and delivering insights that drive operational and strategic decisions. Proficient in data governance, ETL processes, and statistical anomaly detection. Built DataSpeak — a live AI-powered analytics platform that automates dataset profiling, anomaly detection, and KPI report generation from raw data.

Core Capabilities
Data Analysis & Reporting
  • KPI Monitoring & Performance Reporting
  • Business Intelligence Dashboards
  • Data Collection, Cleaning & Validation
  • Actionable Insights Generation
  • Recurring & Ad-Hoc Stakeholder Reports
  • Trend Identification & Optimisation
  • Cross-Functional Stakeholder Collaboration
Technical
  • SQL (CTEs, Window Functions, Subqueries)
  • Python (Pandas, NumPy, Scikit-learn, XGBoost)
  • Power BI (DAX, Power Query, Data Modelling)
  • Excel (Pivot Tables, XLOOKUP, Power Query)
  • ETL Pipelines & Data Governance
  • Statistical Anomaly Detection (Z-Score, IQR)
  • GCP BigQuery · Git & GitHub · Streamlit
Key Analytical Projects
Payment Channel Performance & Revenue Leakage Analysis — SQL · Python · Power BI Case Study ↗
  • Analysed 3.5M+ transaction records across payment channels, gateways, and time windows — identified ₹4.84M in recoverable revenue through systematic failure analysis.
  • Applied data governance and validation practices through SQL segmentation and cross-dimensional checks to resolve data discrepancies.
  • Built Power BI dashboard monitoring KPIs — surfaced peak-hour failure spikes (15.59% vs 6% off-peak) and UPI underperformance (11.63% vs 7.79% for cards).
Customer Churn Prediction & Retention Analysis — Python · XGBoost · Scikit-learn Case Study ↗
  • Built XGBoost churn prediction system on 1,701 student records — 90.3% accuracy, AUC 0.978, 22pp improvement over 68% baseline.
  • Identified Day 3 engagement decline as the critical intervention KPI — an invisible retention signal translated into operational recommendations for non-technical stakeholders.
Marketing Attribution & Business Intelligence Analysis — Python · SQL · Pandas Case Study ↗
  • Compared 4 attribution models across 2,847 customer journeys — found Instagram driving 65% of first-touch conversions but chronically underfunded due to last-click bias.
  • Recommended channel reallocation strategy projected to improve ROAS by 2.3× — presented to stakeholders using summary reports and visual dashboards.
DataSpeak — AI-Powered Analytics & KPI Reporting Platform — Python · Streamlit · Groq API · Llama 3.3 Live Tool ↗
  • Built and deployed a public AI analytics platform — upload any CSV, receive board-level KPI insights in 30 seconds. All profiling runs locally via Pandas/NumPy; only aggregated statistics reach the LLM API.
  • Tested on 116,571 transaction records: auto-detected 9.8% failure rate, ₹4.84M revenue at risk, and peak-hour KPI concentration.
Professional Experience
AI-Powered Data Analysis Intern · Excelerate
Sep 2025 – Oct 2025 | Remote
  • Recognised as Star Performer — built churn prediction workflows in Python and Power BI, delivering production-ready KPI dashboards for non-technical stakeholders.
  • Documented 10+ data pipelines and validation procedures, ensuring cross-team data consistency and governance standards.
Data Science Intern · SmartED Innovations
Jul 2025 – Aug 2025 | Remote
  • Built ETL pipelines and Power BI dashboards supporting KPI visibility and operational reporting across monthly cycles.
  • Collaborated with business stakeholders to translate reporting requirements into analytical outputs for management teams.
AI / ML Intern · IBM SkillsBuild
Jun 2025 – Jul 2025 | Remote
  • Developed regression models achieving 87% accuracy through feature engineering, hyperparameter tuning, and structured evaluation.
  • Documented full ML workflow with clear audit trail — communicated findings to programme stakeholders aligned with data governance standards.
Education
Bachelor of Engineering 2022 – 2026  |  CGPA: 7.5
Sri Sairam Institute of Technology — Chennai, India
Certifications
Additional Information
  • Google Advanced Data Analytics Specialization — 7-course program covering SQL, Python, R, Tableau, and the full data analysis lifecycle.
  • Self-initiated 4 independent end-to-end projects on real datasets (3.5M+ and 116K+ records), each shipped as a live case study or deployed tool.
  • Comfortable managing independent analytical workflows in remote environments — disciplined delivery with consistent quality and clear stakeholder communication.
  • Based in Bengaluru — available immediately.

 Prefer the PDF version?

Let's Work Together

Open for remote freelance & consulting work globally

Fast execution. No lengthy processes. 3-7 day delivery.

Available for freelance projects, remote contracts, and consulting engagements. Fast turnaround. Timezone-flexible.