# Vivek Ranjan

Vivek Ranjan is a remote worker on Himalayas, Data & Stock Management Intern at Crystal Presentation Solutions Pvt. Ltd, based in India.

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

```text
Data analyst turning raw data into actionable business insights using Python, SQL, and Power BI.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India |
| Job categories | Data Analyst, Business Intelligence Analyst, Inventory Analyst, Customer Insights Analyst, Data Visualization Analyst, Data Analytics Specialist, Data Analyst |
| Skills | Excel, Python, Pandas, NumPy, SQLAlchemy, Matplotlib, XLOOKUP, Conditional Formatting, Pivot Tables, Sumifs, VBA, SQL, DQL, DDL, DML, CRUD Operations, MySQL, Window Functions, Conditional Aggregates, Power BI, DAX, Data Visualization, KPIs, Data Cleaning, Customer Segmentation, Inventory Analysis, Data Reconciliation, GitHub, Zepto |

## What I'm looking for

```text
I’m looking for an analytics role where I can own data cleaning, EDA, and KPI/BI dashboards using Python, SQL, and Power BI—working with real business data, improving data integrity, and turning insights into operational decisions.
```

## About

```text
I’m an analyst with hands-on experience in data analysis, data cleaning, exploratory data analysis (EDA), and business intelligence. I focus on transforming raw data into actionable insights that support business and operational decisions.

In my Data & Stock Management Executive Intern role at Crystal Presentation Solutions Pvt. Ltd, I analyzed 7,000+ inventory and operational records across 200+ SKUs using Excel. I implemented a new Excel reporting workflow using Pivot Tables and VBA, reducing processing time by 50%, while improving data accuracy by 30–35% and cutting manual reporting errors by 20%.

I’m strong in data integrity and validation: I performed reconciliation checks on 1,000+ stock entries, resolved 80+ stock mismatch cases, and reduced reporting gaps by 25%. I also standardized and cleaned 7,000+ rows to improve reliability between system and warehouse records.

Through personal projects, I’ve built end-to-end analytics pipelines that mirror real business needs—customer segmentation, KPI reporting, inventory health, and visualization. For example, I engineered pipelines with Python and SQL (CTEs, Window Functions, conditional aggregates) and delivered interactive Power BI dashboards using DAX measures to drive decisions around LTV, shipping efficiency, discount rates, and liquidity unlocks.
```

## Experience

### Data & Stock Management Intern

Crystal Presentation Solutions Pvt. Ltd. Jul 2025 - Sep 2025

```text
Analyzed 7,000+ inventory and operational records across 200+ SKUs in Excel to monitor stock inflow, outflow, and discrepancies. Built an Excel Pivot + VBA reporting workflow that cut processing time by 50% and improved data accuracy 30–35%, resolving 80+ stock mismatch cases and reducing reporting gaps by 25%.
```

Skills: Excel-Pivot-Tables, XLOOKUP, Sumifs, VBA, Data-Reconciliation, Inventory-Analysis

## Education

### University of Delhi

Bachelor of Arts, Economics and Office Management. 2024 - 2027

```text
Pursuing a Bachelor of Arts in Economics and Office Management at the University of Delhi (2024–2027).
```

### Central Board of Secondary Education

Senior Secondary (XII), Commerce

```text
Completed Senior Secondary (Class XII) in Commerce under the Central Board of Secondary Education in 2024.
```

## Tech stack

- GitHub
- NumPy
- Pandas
- MySQL
- Gmail
- Zepto
- SQLAlchemy
- Microsoft Excel
- Microsoft Power BI
- SQL

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

## People also viewed

- [Rishika Siroya](https://himalayas.app/@rishikasiroya): Junior Category Manager, Avenue Supermart (DMart)
- [Bitan Patra](https://himalayas.app/@bitanpatra): Data Analyst, Personal Projects
- [Sumit Kumar](https://himalayas.app/@sumitkumar24): Data Analyst Intern, Self Directed Projects
- [Nishikant Sah](https://himalayas.app/@nishikantsah1): Data Analyst, Flipkart
- [Ruturaj Jadhav](https://himalayas.app/@ruturajjadhav1): Data Analyst Intern, Speed Up Infotech
- [Kanimozhi K](https://himalayas.app/@kanimozhik): Data Analyst, Login 360
- [pushyami User](https://himalayas.app/@pushyamiuser): Data Analyst, Fresher
- [Priyaranjan Bhatt](https://himalayas.app/@priyaranjanbhatt): Data Science Intern, Main Flow
- [Narender Yadav](https://himalayas.app/@narenderyadav): Data Analyst, Self Employed
- [Abhi M](https://himalayas.app/@abhim1): Data Analyst Intern, Rows and Columns
