Roshika Gnan

Create your portfolio with ProoV
ProoV
DE Verified work portfolio

ProoV Portfolio

Roshika Gnan

Not decided · Self-taught

View the ProoV leaderboard

Projects

Certified

Self-directed project

Business & Sponsorships — The FC Barcelona Case

Data Science · October 2026

84/ 100

A ProoV case study · educational project, not employment

Built an end-to-end commercial sponsorship analysis for FC Barcelona: quantified the revenue mix, selected a target fan segment using engagement and value data, assembled a €3M asset package, and evaluated campaign performance against KPIs. The final recommendation was grounded in the numbers, with a clear caveat and make-good plan to manage delivery risk.

Graded against

  • Business reasoning & decision quality35%
  • Correct use of data25%
  • Frameworks applied20%
  • Communication & structure20%

Passed · pass mark 55/100

What stood out6
  • Correctly found and fixed all 3 planted errors in the AI-written draft
  • Chose Asia-Pacific for ElectraX using the highest engagement rate (80.2%) and a documented segment size of 10
  • Built a full €3M sponsorship package and tied the final recommendation to the 40pp KPI shortfall and make-good plan
  • Leakage-Free Commercial Segmentation
  • Value-Based Sponsorship Packaging
  • KPI Gap Diagnosis
The work I submitted20 tasks

12 tasks · 11.0k characters · Python · 8 written answers · 680 words

  • Revenue MixPython · 1.3k characters
  • Revenue Mix Compute469 characters
  • Fan SegmentationPython · 1.0k characters
  • Package Builder604 characters
  • Negotiation Simulator954 characters
  • Inbox Responses1.9k characters
  • KPI ScorecardPython · 710 characters
  • Mid Season Performance Summary1.1k characters
  • Intern Draft Review160 characters
  • Coach Usage167 characters
  • Final Recommendation2.1k characters
  • Defence Questions574 characters
  • Revenue Mix101 words
  • Revenue Mix Compute33 words
  • Fan Segmentation53 words
  • Package Builder41 words
  • Negotiation Simulator93 words
  • Inbox Responses183 words
  • KPI Scorecard50 words
  • Mid Season Performance Summary126 words

Summarised on purpose — the submitted code and writing stay private so this page cannot be reused as an answer key. The full submission sits behind the verified certificate.

Verified certificateTamper-proof · issued by ProoV
Certified

Self-directed project

Business Analytics Sprint

Data Science · July 2026

78/ 100

A ProoV case study · educational project, not employment

Built a clear end-to-end profit-paradox analysis: framed the margin collapse with a hypothesis sheet and KPI driver map, audited the data for issues, and translated the findings into a concise executive narrative. The work connects the profit decline to raw-material inflation, logistics inefficiency, and discounting, then prioritises actions by impact and governance risk.

Graded against

  • Problem Framing & Hypotheses10%
  • Data Analysis & SQL30%
  • Root-Cause & Forecasting25%
  • Dashboard & Visualization15%
  • Executive Communication & Strategy20%

Passed · pass mark 60/100

What stood out6
  • Identified the core paradox with concrete numbers: revenue up 17% while operating profit fell 55%, and tracked the margin collapse from 13.4% to 5.2%.
  • Built a complete KPI driver map with all 8 placements correct, showing strong understanding of price, cost, and volume levers.
  • Produced a coherent Pareto-style root-cause ranking that prioritised raw-material inflation, then logistics inefficiency, then discounting.
  • Communicated the business story clearly in the stakeholder Q&A and executive summary, explicitly tying growth in Asia to margin erosion and recommending ROI-aware actions.
  • Structured Hypothesis Framing
  • KPI Driver Mapping
The work I submitted20 tasks

12 tasks · 8.4k characters · 8 written answers · 406 words

  • Hypothesis Sheet1.3k characters
  • KPI Driver Map174 characters
  • Data Audit100 characters
  • Week1 Update1.2k characters
  • Sql Category Profit296 characters
  • Sql Region Join376 characters
  • Root Causes158 characters
  • Forecast280 characters
  • Recommendations1.0k characters
  • Stakeholder Qa964 characters
  • Executive Summary1.1k characters
  • Bosch Real Case Study1.5k characters
  • Hypothesis Sheet160 words
  • KPI Driver Map1 word
  • Data Audit4 words
  • Week1 Update164 words
  • Sql Category Profit26 words
  • Sql Region Join40 words
  • Root Causes5 words
  • Forecast6 words

Summarised on purpose — the submitted code and writing stay private so this page cannot be reused as an answer key. The full submission sits behind the verified certificate.

Verified certificateTamper-proof · issued by ProoV
2Projects completed
2Verified certificates
81Average score
Create your portfolio with ProoV
Roshika Gnan — Portfolio | ProoV