Portfolio - Vignesh Srinivasan | Codebasics

Powered by
Codebasics DA Bootcamp

Vignesh Srinivasan

Data Analyst

EMAIL

[email protected]

PHONE

+91 8072521237

Download CV

About Me

• Hi, I’m Vignesh Srinivasan, an aspiring Data Analyst with a passion for turning data into insights. I’m skilled in Excel, Power BI, SQL, and Python, which I’ve used to work on several business projects featured in my portfolio.
• Although my current role is as a Process Associate at First American India Pvt. Ltd., I’ve discovered my true strength lies in data analysis. I enjoy digging into data to find trends, solve problems, and make informed decisions.
•I’m excited to take my next step into a full-time Data Analyst role and apply what I’ve learned to make a real impact.

1

Excel Project

1

PowerBI Project

1

SQL Project

Key Skills

Excel

Power BI

Python

MYSQL

My Projects

My Experience

Senior Process Associate

First American (India) · Full-time

• Review and validate documents to ensure error-free data entry.
• Collaborate with U.S. teams for smooth and timely transactions.
• Perform quality checks to maintain compliance with industry standards.
• Manage multiple orders and meet tight turnaround deadlines.
Salem, Tamil Nadu, India · Rem• Handled key mortgage documents including Notes, Mortgages, Loan Estimates, Closing Disclosures, and Service Provider Information, ensuring accuracy and compliance with industry regulations.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Google Data Analytics Professional Certificate

Google Data Analytics Professional Certificate

Let's Work Together!

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

EMAIL

[email protected]

Call Me

+91 8072521237

LinkedIn

https://www.linkedin.com/in/vigneshsrinivasaan/

GitHub

https://github.com/Vignesh-Srinivasan-27

PowerBI Project

AtliQ Hardware - Business Insights 360

Domain/Function: Retail & E-commerce

AtliQ Hardware used Power BI to analyze data and make informed decisions. The project covered finance, sales, marketing, and supply chain, empowering management with actionable insights.

View Project
Engagement

View Project
on GitHUB

AtliQ Hardware - Business Insights 360

Comprehensive dashboard across finance, sales, marketing, supply chain, and support, delivering real-time insights for smart decisions.

AtliQ Hardware - Business Insights 360

Dynamic data model with 10+ interconnected tables, powering seamless analysis and actionable insights.

Project Details

AtliQ successfully used Power BI to analyze data and make informed decisions. The project covered finance, sales, marketing, and supply chain, providing actionable insights for management. Key features included data modeling, visualization, quality assurance, automation, and collaboration. This empowered AtliQ to make data-driven decisions and sustain its market position.

Live Interactive Dashboard

SQL Project

Netflix Content Analysis using SQL

Domain/Function: Entertainment

Explored 8k+ Netflix titles with PostgreSQL to uncover trends in movies and TV shows. Solved 15 business problems using advanced SQL (CTEs, window functions, string & date operations) and delivered insights on genres, audience preferences, top actors/directors, and regional content distribution.

View Project
Engagement

View Project
on GitHUB

View Project
on SQL Project

Netflix Content Analysis using SQL

This pie chart shows that Movies make up 70% of Netflix content, with TV Shows comprising the other 30%.

Netflix Content Analysis using SQL

This bar chart shows the USA has the most content on Netflix, followed by India, the UK, Canada, and Japan.

Project Details

This project analyzes a Netflix dataset of 8,000+ movies and TV shows to extract actionable business insights. Using PostgreSQL, I executed advanced SQL queries to solve 15 real-world problems, covering content distribution, ratings trends, audience behavior, and regional patterns. Key insights include identifying the share of movies vs. TV shows, most common ratings, top contributing countries, and release year trends (with focus on India). Talent and genre analysis highlighted leading actors, directors, and popular categories. Techniques applied include CTEs, window functions, string/date operations, and unnesting multi-valued fields. The project also categorized content based on keywords like “violence” or “kill” to assess thematic trends. Overall, it showcases SQL expertise in data cleaning, querying, and delivering insights to support data-driven content strategy.

Excel Project

Sales and Finance Analytics for AtliQ Hardwares

Domain/Function: Sales & Finance

Created advanced Excel reports, including 'Customer Net Sales Performance' and 'Market Performance vs. Target,' to assess financial health and market standing. These reports enabled the sales team to analyze customer trends, track targets, and make data-driven decisions effectively.

View Project
Engagement

View Project
on GitHUB

Sales and Finance Analytics for AtliQ Hardwares

Customer Performance Report shows yearly net sales per customer, offering insights to evaluate contributions and refine sales strategies.

Sales and Finance Analytics for AtliQ Hardwares

Market Performance vs. Target Report helps stakeholders assess multi-year country performance and compare it against set targets for insights.

Project Details

In this project, I created a detailed sales report using Excel Pivot Tables, Power Query, and Conditional Formatting. The report helps businesses determine optimal customer discounts, streamline negotiations, and identify market expansion opportunities. By analyzing sales data, it provides actionable insights to enhance strategies, improve customer satisfaction, and boost revenue.

𝗞𝗲𝘆 𝗦𝗸𝗶𝗹𝗹𝘀 𝗔𝗰𝗾𝘂𝗶𝗿𝗲𝗱:

• Advanced use of Pivot Tables for dynamic analysis
• Data transformation and automation with Power Query
• Basic DAX for calculations
• Conditional Formatting to highlight trends
• Report beautification for visual appeal
• Understanding sales domain metrics

𝗜𝗺𝗽𝗮𝗰𝘁:
This project equips businesses to monitor and optimize sales activities, uncover growth opportunities, and stay competitive through data-driven decisions.