# Vijay K G

Vijay K G is a remote worker on Himalayas, Data & Event Operations Volunteer at Bharatiya Samskriti Utsav 07, based in India.

Source: https://himalayas.app/@vijaykg

```text
Aspiring data analyst using SQL and Power BI to turn sales and booking data into actionable insights.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 70k+ INR |
| Job categories | Data Analyst |
| Skills | Data Analysis, SQL, Power BI, Data Cleaning, KPI Analysis, Exploratory Data Analysis, Data Warehouse, Reporting, SQL Server, PostgreSQL, DAX, Power Query, Data Modeling, Excel, Pivot Tables, Dashboard Development, T SQL |
| LinkedIn | https://linkedin.com/in/vijaykg01 |
| GitHub | https://github.com/vijaykg01 |

## About

```text
Through four end-to-end analytics projects, I’ve cleaned and analyzed data, reported KPIs, and created interactive dashboards. My work includes a SQL Server star-schema data warehouse built from CRM and ERP files.

For my SQL Data Warehouse & Analytics project, I analyzed more than 120,000 records to examine KPIs, year-over-year growth, product performance, and customer segments. The analysis found that bikes drove 96.46% of sales.

I also designed a five-page Power BI dashboard for Ola ride bookings, with views for revenue, cancellations, and ratings. It reported a 62.09% booking success rate and compared vehicle types, payment methods, and cancellation reasons.

My other projects include sales trend analysis using PostgreSQL and Excel, and Bengaluru house price analysis using Python. As a Data & Event Operations Volunteer at Bharatiya Samskriti Utsav 07, I validated registration data for 500+ attendees and prepared reports.
```

## Experience

### Data & Event Operations Volunteer

Bharatiya Samskriti Utsav 07. Jan 2025 - Feb 2025

```text
Validated registration data for 500+ attendees in Excel, keeping records accurate. Built standardized Excel templates, reducing manual reconciliation, and flagged data discrepancies in real time.
```

Skills: Excel, Data-Validation, Data-Cleaning, Reporting

## Education

### Sharnbasva University

Bachelor of Business Administration, Business Administration. Grade: 8.56/10

```text
Pursuing a Bachelor of Business Administration with a CGPA of 8.56/10.
```

### Forage

Deloitte Data Analytics Job Simulation, Data Analytics

```text
Completed the Deloitte Data Analytics Job Simulation.
```

### upGrad

Advanced SQL: Programming Constructs & Stored Functions, SQL

```text
Completed the Advanced SQL: Programming Constructs & Stored Functions certification.
```

### SkillCourse

Microsoft Excel, Python and Power BI, Data Analysis Tools

```text
Completed certifications in Microsoft Excel, Python, and Power BI.
```

## Tech stack

- NumPy
- Pandas
- PostgreSQL
- Python
- SQLAlchemy
- SQL
- Seaborn
- Matplotlib
- Power BI
- Power Query

To contact Vijay, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Chaitali Godse](https://himalayas.app/@chaitaligodse): SQL Developer, Quantox Technologies Pvt Ltd
- [vineet gupta](https://himalayas.app/@vineetgupta1): Data Analyst, Self Employed
- [NiTiN User](https://himalayas.app/@nitinuser4): Data Analyst Intern, Self Employed
- [Shagun Sharma](https://himalayas.app/@shagunsharma4): Data Analytics Project Lead, Personal Portfolio Projects
- [Aditya Saini](https://himalayas.app/@adityasaini2): Data Analyst, Self Employed
- [Tarush Nandan](https://himalayas.app/@tarushnandan): Data Analyst, Self Employed
- [Kamireddy Karthik User](https://himalayas.app/@kamireddykarthikuser): Data Analyst, Self Employed
- [Ayush Sahu](https://himalayas.app/@ayushsahu2): Campus Hero, GirlScript Foundation
- [Aditya Chaudhary](https://himalayas.app/@adityachaudhary2): AI ML Virtual Intern, EduSkills Foundation
- [Deeshanshi Sahu](https://himalayas.app/@deeshanshisahu): Treasurer, Sankalp College Fest
