Vivek Ranjan

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.