VANSHIKA KANTHWAL

Data Analyst
Liverpool, GB.

About

Highly accomplished Data Analyst with 2+ years of experience, specializing in transforming complex data into actionable insights that enhance strategic decision-making and operational efficiency. Recognized as MVP for consistently delivering 100% on-time, high-quality analytics, including an 88% improvement in AI assistant accuracy. Proven ability to rapidly deliver measurable business value through automated dashboards and SQL-driven insights, significantly reducing reporting time and empowering leadership.

Work

Renan Partners
|

Data Analyst Intern

United Kingdom of Great Britain and Northern Ireland

Summary

Driving data-driven decision-making and enhancing AI assistant capabilities for enterprise clients at Renan Partners.

Highlights

Enhanced AI assistant accuracy by 69% (from 52% to 88%) through strategic alignment of SQL generation logic with business rules, significantly improving enterprise client experience.

Developed and deployed real-time dashboards for tracking critical transactions, payments, and revenue trends, reducing reporting time by 40% and accelerating business decision-making.

Expanded AI assistant coverage by defining over 220 business-critical questions, leading to increased user adoption and satisfaction.

Achieved 100% on-time reporting with zero data quality issues, earning recognition as Most Valuable Player (MVP) for exceptional performance and ownership.

Mentored 4 junior data analysts, providing SQL/code reviews and developing streamlined onboarding documentation to ensure team consistency and accelerate skill development.

Facilitated critical communication between technical teams and business stakeholders, translating data insights into strategic recommendations that influenced key KPI realignments and client strategies.

Pyro Holdings
|

Software Trainee

Chandigarh, Punjab, India

Summary

Automated data integration and improved backend reliability as a Software Trainee at Pyro Holdings.

Highlights

Automated API data integration pipelines using Python, resulting in a 30% reduction in manual reporting effort and increased operational efficiency.

Developed modular backend scripts that significantly enhanced error handling and improved data flow reliability across multiple services.

Conducted comprehensive code reviews and implemented clean scripting practices, reducing defect rates during testing by 15%.

Education

University of Liverpool
Liverpool, Merseyside, United Kingdom of Great Britain and Northern Ireland

M.Sc.

Data Science and AI

Courses

Data Mining

Big Data

SQL

Machine Learning

Deep Learning

Chandigarh University
Chandigarh, Punjab, India

B.Sc.

Economics

Courses

Statistical Analysis (R, SPSS)

Econometrics

Forecasting

Languages

English

Certificates

ESG Certification

Issued By

Bloomberg

Data Analysis with Python

Issued By

IBM

Python for Data Science

Issued By

IBM

Financial Institutions & Markets

Issued By

NPTEL

Skills

Programming & Tools

Python, SQL, R, SPSS, Excel, Tableau, Power BI.

Data Science & Machine Learning

Regression, Classification, Time Series Forecasting, Clustering, ML Model Optimization, Data Mining, Big Data, Deep Learning, API Integration, Backend Development, Computer Vision.

Visualization & Analytics

BI Dashboards, KPI Reporting, Trend Analysis, Real-time Dashboards, Data Quality Management.

Process & Soft Skills

Stakeholder Management, Mentoring, Problem-Solving, Cross-Team Collaboration, Code Review, Strategic Planning, Client Experience Enhancement, Product Strategy.

Projects

Computer Vision for Accessibility

Summary

Evaluated recognition models to aid visually impaired users, recommending improvements.

2D Crystal Lattice Visualization App

Summary

Developed a Python tool for real-time scientific data manipulation, enhancing usability for non-technical researchers.

Market Trend Analysis (RCS Preferences)

Summary

Analyzed user data to recommend feature rollouts, informing product strategy decisions.

Financial Forecasting (Time Series)

Summary

Developed Python models to predict investment risks and returns, enhancing portfolio ROI simulations.

Clustering Analysis for Pattern Recognition

Summary

Benchmarked 4 clustering algorithms (K-Mode, DBSCAN, Hierarchical, Spectral) to improve cluster accuracy on complex datasets.