Srinith Samala — Data Analyst Portfolio

About Me

Who I Am

Education Projects Skills Certifications Download Resume

I am Srinith Samala, a third-year B.Sc. Data Science student at KES Shroff College, Mumbai, building my analytics career through hands-on project work and continuous learning. I work across the full analytics stack writing SQL with CTEs and window functions, building Power BI dashboards with DAX, and using Python for data wrangling and NLP. My projects are self-initiated and built on real datasets, not toy examples, covering telecom churn, e-commerce revenue volatility, marketing mix attribution, and food delivery operations. I have completed virtual programmes with Deloitte, British Airways, and Tata Group to get exposure to how analytics works inside large organisations. I am actively looking for my first full-time data analyst role where I can bring this foundation and grow fast.

Mission

Hover to reveal

Mission

To land my first data analyst role and deliver real business impact through rigorous, insight-driven analysis from day one.

Vision

Hover to reveal

Vision

To grow into a senior data analyst and eventually a data scientist who shapes strategy through analytics at scale.

Education

Academic Foundation

Bachelor of Science in Data Science

KES' Shroff College, Mumbai, India

Jan 2024 - Jul 2027 Full-time

Key Highlights

Relevant coursework: Statistical Analysis, Machine Learning, Data Structures, Database Management, and Data Mining
Building a strong theoretical foundation in both mathematical and computational aspects of data science
Actively applying classroom learning to live project work in SQL, Python, and Power BI

Projects

What I've Built

Self-initiated analytics projects on real datasets — not toy examples.

01

Telecom Churn & Revenue Risk Analysis

Independent Analytics Project2026

SQLMySQLPower BIDAXCTEsWindow Functions

View on GitHub

A full-funnel SQL and Power BI analysis of telecom customer contracts to quantify churn-driven revenue risk. Identified that month-to-month customers concentrate ~47% of total revenue at risk. A contract migration strategy was modelled and recommended.

1

Identified the primary driver of churn-driven revenue risk through contract-type segmentation in SQL

2

Quantified ~47% of total revenue concentrated in high-risk month-to-month customer segments

3

Estimated protection of ~£200K annual revenue under a conservative contract migration scenario

4

Built an executive Power BI dashboard translating SQL findings into strategic recommendations

02

Marketing Mix & Attribution Analysis

Independent Analytics Project2026

SQLPower BIDAXAttribution ModellingBudget Simulation

View on GitHub

A marketing analytics project comparing last-touch vs. linear attribution models to expose channel overvaluation and bias. A what-if budget simulation was built to model revenue impact of reallocation decisions, revealing the scalability limits of high-ROI channels.

1

Identified attribution bias showing overvaluation of closing channels under last-touch models

2

Designed a what-if budget simulation that exposed ~21% revenue loss risk from ROI-only reallocation

3

Demonstrated high-ROI channel scalability ceiling and recommended a hybrid reallocation strategy

4

Delivered strategic recommendations bridging marketing efficiency and revenue stability

03

E-commerce Retention & Revenue Analysis

Independent Analytics Project2025

SQLPostgreSQLPower BICTEsWindow FunctionsCohort Analysis

View on GitHub

A large-scale SQL analysis of 541K+ e-commerce transactions to diagnose revenue volatility, customer churn, and product-level retention patterns. Revealed structural instability in the revenue base driven by high churn and top-customer concentration.

1

Analysed 541,000+ transactions using advanced SQL (CTEs, window functions) for cohort and retention diagnosis

2

Identified 51% customer churn rate as the core driver of monthly revenue swings between £400K–£1.1M

3

Pinpointed top 10% customer revenue concentration as a key structural risk factor

4

Produced actionable retention and diversification recommendations grounded in transaction-level evidence

04

Food Delivery Operations & Revenue Analysis

Independent Analytics Project2025

SQLMySQLJOINsWindow FunctionsCASE WHENPower BIDAX

View on GitHub

A multi-table SQL analysis of a food delivery platform covering customers, restaurants, orders, and item-level data. Answered 10 structured business questions across three difficulty tiers — from basic aggregations to advanced window-function-based rankings — paired with an interactive Power BI dashboard.

1

Segmented customers into Premium, Gold, and Regular tiers using CASE WHEN spend classification

2

Ranked top 3 restaurants per city by revenue using RANK() OVER window functions

3

Identified high-frequency customers (5+ orders) to surface loyalty and repeat-purchase patterns

4

Built a Power BI dashboard with KPIs for Total Revenue, Orders, Customers, and AOV with city/restaurant slicers

Skills

My Toolkit

The languages, tools, methods, and soft skills I use to turn data into business decisions.

Data & Query Languages

SQL (MySQL, PostgreSQL)Proficient

Python (Pandas, NumPy)Familiar

DAX (Power BI)Familiar

Analytics & Methods

Churn & Retention AnalysisProficient

Cohort AnalysisProficient

Revenue & Segmentation AnalysisFamiliar

Marketing Attribution ModellingFamiliar

Tools & Platforms

Power BIProficient

ExcelProficient

Git / GitHubFamiliar

Python Libraries & NLP

Pandas & NumPyFamiliar

BeautifulSoup (Web Scraping)Learning

NLTK (Sentiment Analysis)Learning

Data Visualisation & Storytelling

Dashboard DesignProficient

Executive ReportingFamiliar

Data StorytellingFamiliar

Soft Skills

Analytical ThinkingProficient

Business CommunicationFamiliar

Problem StructuringProficient

Key: Proficient — use independently on projects Familiar — working knowledge, building depth Learning — actively studying

Certifications

Credentials

Industry-recognised certifications validating my technical and analytical expertise.

Google / Coursera

Google Data Analytics Professional

April 2026 Verify Certificate

AWS / Coursera

AWS Cloud Technical Essentials

February 2026 Verify Certificate

Achievements

Achievements & Recognition

Building a track record of applied analytics impact — one project, one insight, one decision at a time.

0

Certifications

0

Projects

0

Virtual Internships

Professional2025

Deloitte Australia Data Analytics Virtual Internship

Deloitte / Forage

Data Analytics virtual internship; built Power BI dashboards simulating real client engagement.

Professional2025

British Airways Data Science Virtual Internship

British Airways / Forage

Data Science virtual internship; built NLP sentiment pipeline using Python.

Professional2025

Tata Group Data Visualisation Virtual Internship

Tata Group / Forage

Data Visualisation virtual internship; designed executive-ready strategic visuals.

Academic2026

Google Data Analytics Professional Certification

Google / Coursera

Earned Google's industry-recognised data analytics certification validating end-to-end analytics proficiency.

Academic2026

AWS Cloud Technical Essentials Certification

Amazon Web Services / Coursera

Completed AWS foundational cloud certification, extending technical versatility into cloud-native environments.

Contact

Let's Build Something Insightful Together

Let's Talk

I'm actively looking for my first data analyst role. Whether you have an opportunity, a question, or just want to connect — I'd love to hear from you.

Emailsrinithsamala574@gmail.com

Phone+91-9347709720

LocationMumbai, Maharashtra, India

LinkedInlinkedin.com/in/srinith-samala

GitHubgithub.com/srinith-samala

ResumeDownload PDF