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 →

🎮 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 — Commercial & Data Analyst

Last updated May 2026 · Chennai, India · Available immediately

GUNAL K
Commercial & Data Analyst
Chennai, India +91 7418096065 gunalkrish8@gmail.com LinkedIn GitHub Portfolio
Profile

Analytical data professional with experience building decision-support analysis across payments, customer behaviour, and marketing performance. Analysed 3.5M+ transaction records to identify ₹4.84M in recoverable revenue through systematic failure analysis and operational cross-validation. Skilled in SQL, Python, Power BI, Tableau, and Excel (Pivot Tables, Large Dataset Management) with focus on structured research workflows, data verification, and concise business communication. Strong interest in Gulf market dynamics, commercial strategy, and regional investment trends.

Core Capabilities
Commercial & Analytical
  • Commercial Research & Market Intelligence
  • Revenue Leakage & Risk Identification
  • Decision-Support Reporting
  • Trend & Sequence Analysis
  • Data Verification & Cross-Referencing
  • Regulatory & Market Monitoring
  • Stakeholder Communication
Technical
  • SQL (CTEs, Window Functions, Subqueries)
  • Python (Pandas, NumPy, Scikit-learn, XGBoost)
  • Power BI (DAX, Power Query, Data Modelling)
  • Tableau, Excel (Pivot Tables, Large Datasets)
  • ETL Pipelines & Data Cleaning
  • Classification & Predictive Modelling
  • Git & GitHub
Key Analytical Projects
Payment Intelligence & Revenue Leakage Analysis — SQL · Python · Power BI Case Study ↗
  • Analysed 3.5M+ transaction records across payment methods, gateways, and time windows to identify operational inefficiencies and revenue leakage patterns.
  • Performed structured root-cause analysis using SQL segmentation and cross-validation to verify inconsistencies across reporting dimensions.
  • Identified peak-hour payment failure spikes of 15.59% vs 6% off-peak, indicating infrastructure bottlenecks.
  • Discovered UPI transaction failure rates significantly exceeded card payments (11.63% vs 7.79%).
  • Produced Power BI dashboard summarising operational hotspots, gateway comparisons, and commercial impact — identified approximately ₹4.84M in potentially recoverable revenue.
Student Churn Prediction & Retention Analysis — Python · XGBoost · Scikit-learn Case Study ↗
  • Built early-warning churn prediction system using behavioural engagement indicators from 1,701 student activity records.
  • Engineered 15+ behavioural features and evaluated multiple classification models using structured cross-validation.
  • XGBoost model achieved 90.3% accuracy and AUC 0.978, improving significantly over 68% baseline.
  • Identified Day 3 engagement decline as critical intervention point for retention teams.
  • Translated technical findings into operational recommendations understandable to non-technical stakeholders.
Marketing Attribution & Commercial Channel Analysis — Python · SQL · Pandas Case Study ↗
  • Analysed 2,847 customer journeys across digital channels to evaluate attribution distortion in budget allocation.
  • Compared Last-Click, First-Click, Linear, and U-Shaped attribution frameworks to assess commercial interpretation differences.
  • Identified Instagram as materially undervalued despite contributing to 65% of first-touch interactions.
  • Recommended structured reallocation strategy projected to improve ROAS by 2.3×.
Professional Experience
AI-Powered Data Analysis Intern · Excelerate
Sep 2025 – Oct 2025 | Remote
  • Recognised as high-performing contributor for analytical delivery quality and structured reporting.
  • Built predictive churn analysis workflows using Python and Power BI; applied feature engineering and model validation.
  • Maintained organised documentation and clear written updates within remote asynchronous working environment.
  • Presented analytical outputs in concise business-oriented language for non-technical stakeholders.
Data Science Intern · SmartED Innovations
Jul 2025 – Aug 2025 | Remote
  • Built ETL pipelines and performed structured exploratory data analysis using Python and SQL.
  • Developed Power BI dashboards supporting operational performance visibility and reporting clarity.
  • Collaborated with stakeholders to gather reporting requirements and organise analytical outputs.
AI/ML Intern · IBM SkillsBuild
Jun 2025 – Jul 2025 | Remote
  • Developed regression models achieving 87% predictive accuracy through feature importance analysis and tuning.
  • Performed data cleaning, preprocessing, validation, and structured model evaluation.
  • Documented workflows clearly and communicated analytical findings to programme stakeholders.
Education
Bachelor of Engineering (Mechanical Engineering) 2022 – 2026  |  CGPA: 7.5
Sri Sairam Institute of Technology — Chennai, India
Certifications
Additional Information
  • Strong interest in Gulf commercial dynamics, sovereign capital movements, regional market behaviour, and long-term investment strategy.
  • Comfortable working in remote international environments requiring disciplined written communication and self-managed execution.
  • Detail-oriented approach to analytical verification, documentation, and structured research workflows.
  • Focused on producing concise analysis that supports commercial decisions rather than expansive reporting.

 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.