HARSH PANDEY

Data Analyst specializing in SQL, Python, and Excel, skilled in transforming raw data into actionable insights through effective analysis and visualization. Proficient in data cleaning, exploratory analysis, and dashboard creation using Power BI and Python libraries. Demonstrates strong problem-solving abilities and adaptability, dedicated to improving data-driven decision-making in fast-paced environments.

Member, Sports Club — KNIT, Sultanpur

• Actively participated in multiple tournaments, including cricket, chess, and carrom, demonstrating teamwork, discipline, and competitive spirit

Media head, photography, and fine arts club — KNIT Sultanpur

• Mentored and guided over 250 students in photography and media management
• Managed the Council’s social media platforms and successfully increased event visibility and engagement
• Designed and executed strategic media campaigns that contributed to the overall success of 'Anubhuti '24' cultural fest

Portfolio website|HTML, CSS, responsive design

• Developed a personal portfolio website to showcase technical skills, academic projects, and extracurricular achievements
• Implemented responsive UI/UX design to ensure accessibility across devices.

Automatic boom barrier with smart street lights|Arduino, IoT, automation

• Engineered an IoT-based prototype integrating smart street lighting and automated boom barrier control using Arduino, servo motor, and sensors
• Optimized design to support smart parking systems and highway toll automation, with potential for integration into AI-enabled payment systems

Sales data analysis dashboard (Excel and Power BI)

• Cleaned and transformed raw sales data using Excel and Power Query
• Built an interactive dashboard to track KPIs, such as revenue trends, top products, and regional sales

Student performance analysis (Python, Pandas, Matplotlib)

• Collected and processed student marks data for trend identification
• Visualized performance metrics with charts and statistical summaries

• Media Head, Photography and Fine Arts Club - KNIT Sultanpur, Guided 250+ students about Photography and Media Handling., Successfully increased event visibility and engagement through strategic media campaigns contributing to the overall success of the event 'ANUBHUTI' 24.
• Member, Sports Club - KNIT Sultanpur, Participated in various Tournaments: Cricket, Chess, Carrom.