Prateek Kumar

Data Analyst with experience in inventory analytics, dashboard development, reporting, and process automation. Skilled in SQL, Power BI, Excel, and Python, with hands-on experience in data cleaning, KPI reporting, data visualization, and business process automation. Strong at turning operational data into clear reports and actionable insights.

Inventory Manager at Ingen Technology (2025-09 – Present)

• Manage daily inventory operations for electronic components, sensors, and IoT devices using ERP-based tracking.
• Improved stock accuracy and reduced dispatch delays through automated monitoring of incoming and outgoing materials.
• Built a SQL-based reporting system for weekly and monthly inventory analytics, supporting faster management decisions.
• Optimized warehouse processes through FIFO implementation and space-utilization strategies, cutting storage costs.

Data Management Intern at GDK Solutions (2025-05 – 2025-09)

• Built custom dashboards and automation solutions using Power BI, SQL, and Google Sheets for business operations.
• Developed automated workflows with Google Apps Script, cutting manual data entry time.
• Created a web-based application integrated with Gemini AI to enhance data-processing capabilities.

Data Analytics Mentor Intern at SMPS Innovation (2024-11 – 2025-04)

• Trained [50]+ engineering students in Excel, SQL, Power BI, and data visualization techniques.
• Designed hands-on projects focused on data cleaning, analysis, and dashboard creation.
• Mentored students on analytical tools and guided them through practical, portfolio-ready assignments.

BCA in Data Science – Chandigarh University (Online) (2026-01)

Diploma in Electronics Engineering – Government Polytechnic (2020 – 2023)