Varun Kumar Prem Kumar Email & Phone Number

London, Gb

Coventry, England, United Kingdom

• Customer Segmentation: Consulted and collaborated in a pro-bono project with a food tech startup aimed at disrupting the salad space using automated vending processes. Led interpretation of the buying patterns of potential clients in the area to achieve ideal product pricing proposals.• Competitor Analyses: Lead the data analysis of competitors by geography, demographic and spending preferences to better understand the USPs of similar scale competitors in the food space.

Bengaluru, Karnataka, India

• BI Automation & Data Visualisation: Led the automation of reporting and dashboard creation using Tableau and Google Big Query, reducing manual efforts by 25 hours per person monthly through collaborative data pipeline management.• User Attribution Model: Spearheaded the design and implementation of an app-session level attribution model using Figma and SQL, collaborating with cross-functional stakeholders to conduct UAT and reduce attribution errors by 95%• LTV Analysis: Built a… Show more • BI Automation & Data Visualisation: Led the automation of reporting and dashboard creation using Tableau and Google Big Query, reducing manual efforts by 25 hours per person monthly through collaborative data pipeline management.• User Attribution Model: Spearheaded the design and implementation of an app-session level attribution model using Figma and SQL, collaborating with cross-functional stakeholders to conduct UAT and reduce attribution errors by 95%• LTV Analysis: Built a dynamic LTV model incorporating customer retention and repeat rate metrics, driving targeted channel spending strategies for growth and churn reduction, with results visualized via automated Tableau dashboards.• User Persona Profiling: Utilised Clevertap tracking data to segment users into personas based on 10+ attributes, improving user retention by 15% through the deployment of personalized nudges that enhanced specific user journeys.• Experiment Design & Analyses: Designed and executed A/B experiments with product teams, analyzing historic user behavior to optimize journeys, resulting in a 22% increase in focus category penetration and a 30% rise in Average Order Value.• Campaign and Channel Data Analysis: Conducted ad-hoc analyses of multi-channel campaigns via Appsflyer and communicated actionable insights to channel managers through Tableau dashboards, enhancing marketing decision-making. Show less

Bengaluru, Karnataka, India

• Internal Audit Analytics: Analysed supply chain expenses using SQL and Power BI, identifying inefficiencies in logistics processes for an e-commerce client, leading to enhanced audit processes through digital tool integration.• Fraud Analytics: Developed master datasets by quantifying historical fraudulent behaviors for a financial services client, streamlining fraud detection and accelerating reporting by 15% through Power BI dashboards.• Customer Experience Analytics: Implemented a… Show more • Internal Audit Analytics: Analysed supply chain expenses using SQL and Power BI, identifying inefficiencies in logistics processes for an e-commerce client, leading to enhanced audit processes through digital tool integration.• Fraud Analytics: Developed master datasets by quantifying historical fraudulent behaviors for a financial services client, streamlining fraud detection and accelerating reporting by 15% through Power BI dashboards.• Customer Experience Analytics: Implemented a sentiment analysis pipeline for customer complaints, identifying vendor-specific trends, resulting in a 13% month-over-month improvement in customer retention for a leading automobile manufacturer. Show less

Chennai, Tamil Nadu, India

Data Mining & Exploration: Implemented extensive data mining & exploration activities on data stored in excel dumps. Analysed & extracted useful patterns with emphasis on the recent past & achieved 70% of the targets.Data Visualization & Presentation: Liasoned with Indian Premier League (IPL) teams and internationalcricket boards to deliver in-game strategy dashboards and presentations.

Chennai, Tamil Nadu, India

Lead Generation: Contributed to business development through cold calling and email follow ups. Facilitated a 5% increase in the potential clientele for future projects.Customer Support: Supported & maintained relationships with clients to improve rapport and sustain client relationship. Analysed & communicated the queries to the development team to ensure quick problem resolution.Footfall Analysis: Collaborated with the SEO team and drafted blogs for the company’s website to increase… Show more Lead Generation: Contributed to business development through cold calling and email follow ups. Facilitated a 5% increase in the potential clientele for future projects.Customer Support: Supported & maintained relationships with clients to improve rapport and sustain client relationship. Analysed & communicated the queries to the development team to ensure quick problem resolution.Footfall Analysis: Collaborated with the SEO team and drafted blogs for the company’s website to increase the company’s visibility. Contacted interested users to inquire about potential service requirements. Show less

Master'S Degree, Business Analytics, Distinction (Predicted)

Bachelor Of Technology, Information Technology, 8.85

Activities and Societies: IEEE, SSN Coding Community Gold Medalist. Passed in First Class with Distinction University Rank : 20

High School, Maths, Physics, Chemistry, Computer Science