Project Details

• Data Integration & Cleaning: Imported placement data from 2012 to 2025 using Power Query; cleaned, transformed, and standardized data to ensure consistency and accuracy across all records.
• Dashboard Development: Built an interactive Power BI dashboard highlighting key metrics such as total placements, branch-wise placement distribution, and annual placement trends.
• Advanced Analytics: Implemented DAX measures to calculate placement rates, average salary packages, and identify top recruiting companies for data-driven insights.
• Visualization & Insights: Enabled dynamic visualizations for stakeholders to explore student placement success, industry demand, and branch performance, supporting strategic planning for the college.

Live Interactive Dashboard

Project Details

• Designed and managed a MySQL database with 12 tables and 1.9M+ records to perform financial and supply chain analytics for AtliQ Hardwares.
• Created stored procedures and functions to generate reports on top customers, product performance, market trends, and sales forecast accuracy.
• Built views for gross and net sales, and analyzed cost structures including freight, manufacturing, and pre/post-invoice deductions.
• Optimized complex queries using joins, subqueries, indexing, and window functions to improve report efficiency and support data-driven decisions.

Project Details

• Designed and implemented end-to-end ETL processes using Power Query and MySQL to extract, transform, and load data from multiple business functions.
• Created five dynamic dashboards in Power BI for Finance, Sales, Marketing, Supply Chain, and Executive views to offer a 360° view of organizational performance.
• Developed complex DAX measures to monitor key KPIs like revenue, ROI, inventory levels, and customer satisfaction in real-time.
• Analyzed regional trends and supply chain forecasts, uncovering a 36% sales growth in LATAM, which supported strategic business planning and decision-making.

Live Interactive Dashboard

Project Details

• Conducted in-depth sales and financial data analysis for AtliQ Hardware (2019–2021) using Advanced Excel, Power Query, and Power Pivot.
• Identified trends in sales growth, product performance, and profitability to support data-driven decisions.
• Developed interactive dashboards and reports such as Customer Net Sales, Market vs Management Performance, and P&L by Fiscal Month/Year.
• Streamlined ETL processes for efficient data transformation and enabled dynamic reporting using VLOOKUP and DAX functions.

Project Details

• Cleaned and preprocessed Diwali sales data by removing duplicates and handling missing values using Pandas and NumPy.
• Conducted exploratory data analysis to uncover insights on customer demographics, sales performance, and top-selling categories.
• Created visualizations including bar charts, histograms, scatter plots, and correlation heatmaps using Matplotlib and Seaborn.
• Identified sales trends and key customer segments, helping businesses optimize marketing strategies and improve targeting.

Project Details

• Developed a Face Recognition Tool for CCTV surveillance using Python and OpenCV to identify individuals in real-time from live camera feeds.
• Designed a data collection pipeline that captures and stores 200 face images per person, enabling robust model training and recognition accuracy.
• Performed image preprocessing, including grayscale conversion, resizing, and normalization; used Haar Cascade for detection and LBPH algorithm for recognition.
• Logged recognition events with timestamps and enabled continuous scanning from CCTV/webcam, offering a low-cost and scalable security solution.