VAISHNAVI LONKAR

Data Analyst

https://www.opentalent.in/vaishnavi-lonkar

Data Analyst with less than a year in Python & SQL

Key Strengths

Proficient in Power BI for dashboard development and data visualization, demonstrated by the 'Executive Business Performance & Revenue Leakage Dashboard' project.
Strong SQL skills, including advanced queries (CTEs, Window Functions, Subqueries), as shown in the 'Customer Behaviour Analysis' project.
Experience with Python for data analysis, machine learning (Linear Regression, KNN), and data preprocessing.
Ability to conduct end-to-end data solutions, from raw data cleanup to generating actionable business insights.
Solid understanding of data cleaning, preprocessing, and exploratory data analysis (EDA).

Cultural & Operational Fit

Cultural Fit Analysis

The candidate's project diversity, covering revenue analytics, customer behavior, and predictive modeling, indicates a broad interest in data analysis applications. The 'Tata Group Data Analytics Job Simulation' suggests an interest in real-world business challenges and a willingness to engage with industry-relevant scenarios, including AI-powered analytics and ethical AI principles. This breadth of exposure and continuous learning aligns well with a dynamic, data-driven team culture. However, the lack of professional experience makes it difficult to fully assess cultural fit in a corporate environment.

Soft Skills & Operational Fit

The candidate demonstrates a proactive approach to learning and skill development through various certifications and personal projects. Their project descriptions indicate an ability to translate data into business insights, which is crucial for an operational data analyst role. The focus on measurable outcomes in projects suggests a results-oriented mindset. However, without direct work experience, the ability to collaborate in a team or handle workplace stress cannot be fully assessed.

AI is analyzing your overall score…

Identifying your key strengths…

Evaluating your skill match against the job requirements…

Assessing your cultural and operational fit

About

BSc IT graduate (A+) with hands-on experience building end-to-end data solutions from raw data cleanup to executive-level Power BI dashboards. Skilled in Python, SQL, and Machine Learning, with proven ability to uncover business insights from datasets of 40K+ records. Built 4 independently developed projects covering revenue analytics, customer segmentation, predictive modelling, and healthcare ML each with measurable outcomes. Seeking a Data Analyst role where I can apply SQL and Power BI to solve real business problems and grow within a data-driven team.

Top Skills

PythonSQLPower BIMachine LearningHTML

Education

B.K. Birla College, Kalyan

Bachelor of Science in Information Technology (BSc IT) · Information Technology

N/A – June 30, 2026

B.K. Birla College, Kalyan

Higher Secondary Certificate (HSC)

N/A – May 31, 2023

Shri M.D. Dedhia English High School

Secondary School Certificate (SSC)

N/A – May 31, 2021

Projects

Executive Business Performance & Revenue Leakage Dashboard

January 1, 2026 – June 1, 2026

Designed a multi-page Power BI dashboard tracking $1M total revenue, $274K total profit, and 4.36% MoM growth across 4 regions and 3 product categories. Built a Revenue Leakage Detection module identifying $4.25K estimated leakage and $63,744 refund loss; pinpointed root causes including damaged goods, customer dissatisfaction, and late delivery.

Customer Behaviour Analysis

January 1, 2026 – June 1, 2026

Engineered 10 advanced SQL queries (CTES, Window Functions, Subqueries) to segment 3,900+ customers into loyalty tiers and rank top-performing products, surfacing insights on subscription impact and discount behaviour. Revealed that subscribed customers outspend non-subscribers in average spend and total revenue; findings actionable for retention and upsell strategy. Delivered a Power BI dashboard tracking revenue by gender, age group, and category for data-driven business decisions.

View Project

USA House Price Prediction using Linear Regression

January 1, 2026 – June 1, 2026

Analyzed and visualized 5,000 US housing records to identify key price-driving features such as square footage, number of bedrooms, and location. Built a Multiple Linear Regression model achieving 92% accuracy, validated using R² score and residual diagnostics; reduced MAE to $1,00,132. Automated end-to-end preprocessing pipeline - missing values, outlier treatment, feature scaling - reducing manual effort by 60% and improving model stability.

View Project

Predicting Heart Disease Using KNN

January 1, 2026 – June 1, 2026

Developed a KNN model to predict heart disease likelihood from patient health data; performed EDA to understand feature relationships and distributions. Preprocessed data (missing values, feature scaling, categorical encoding) and evaluated performance using accuracy score, confusion matrix, and cross-validation.

View Project

Certifications

Tata Group Data Analytics Job Simulation

Forage

June 10, 2026 – Present

Introduction to MS Excel

Simplilearn

June 1, 2026 – Present

Python for Data Science

IBM Cognitive Class

June 1, 2026 – Present

Data Analysis & AI: From Data to Intelligent Decisions 2026

Udemy

June 1, 2026 – Present

Key Strengths

Proficient in Power BI for dashboard development and data visualization, demonstrated by the 'Executive Business Performance & Revenue Leakage Dashboard' project.
Strong SQL skills, including advanced queries (CTEs, Window Functions, Subqueries), as shown in the 'Customer Behaviour Analysis' project.
Experience with Python for data analysis, machine learning (Linear Regression, KNN), and data preprocessing.
Ability to conduct end-to-end data solutions, from raw data cleanup to generating actionable business insights.
Solid understanding of data cleaning, preprocessing, and exploratory data analysis (EDA).

Cultural & Operational Fit

Cultural Fit Analysis

Soft Skills & Operational Fit