<aside> 📁 Resume
</aside>
<aside> <img src="https://prod-files-secure.s3.us-west-2.amazonaws.com/50053ce8-ce1b-40c1-a26c-fc13bead46ee/d560817c-b8a4-4c76-bac8-80d9755a896f/25231.png" alt="https://prod-files-secure.s3.us-west-2.amazonaws.com/50053ce8-ce1b-40c1-a26c-fc13bead46ee/d560817c-b8a4-4c76-bac8-80d9755a896f/25231.png" width="40px" /> GitHub
</aside>
<aside> <img src="https://prod-files-secure.s3.us-west-2.amazonaws.com/50053ce8-ce1b-40c1-a26c-fc13bead46ee/05a22a3b-a207-43fe-95f9-5a8554b446eb/linkedin-icon-1024x1024-net2o24e.png" alt="https://prod-files-secure.s3.us-west-2.amazonaws.com/50053ce8-ce1b-40c1-a26c-fc13bead46ee/05a22a3b-a207-43fe-95f9-5a8554b446eb/linkedin-icon-1024x1024-net2o24e.png" width="40px" /> LinkedIn
</aside>
About Me: Hi there! I’m Shiv Kumar Rana, skilled in Advanced Excel, SQL, and Power BI. I’m a dedicated data enthusiast with a robust foundation in data science and analytics. My journey in this field began with a genuine passion for solving complex problems and transforming data into actionable insights. Combining my roles as a data analyst intern with a solid academic background in mathematics, I’m committed to leveraging data to drive impactful outcomes. Educational Background: I hold a Bachelor of Technology in Mechanical Engineering from Vinoba Bhave University and now I am exploring my journey in data analytics and Business analytics. My education includes advanced training in Python, SQL, and Power BI, Advanced excel equipping me with the technical expertise needed for in-depth data analysis and visualization.
**Professional Experience:**
**MULTITECH AUTO PVT LTD**
while working in PPC I have to forecast demand and make planning production accordingly.
Making weekly meeting presentation report of the production and analyzing and visualizing plan vs actual production quantity and overall profit with the plant head and managers and make the planning accordingly.
data management for different activity of projects.
reduces machine cycle time and increase the production rate by 20%.
Authored comprehensive documentation outlining SOPs, hardware specifications, and strategies to streamline manual workload by 10%.
**SL AP PVT LTD**
Strategized and analyzed the Inhouse and outsource product trends for over 800 diverse products and successfully reduced the cost of the product by cost cutting method and increased the profitability of the company by 10% through targeted initiatives and data insights.
Analyzing production trends optimized rejection rates and reduced production cost contributing to increased company profit by 20% from current profit.
Conducted in-depth inventory analysis, utilizing advanced Excel techniques, which resulted in a notable 12% revenue growth by optimizing stock levels and minimizing overstock of the company.
Successfully managed product development projects for KIA and HYUNDAI, ensuring timely delivery and adherence to quality standards.