Midnight Customs | Bolton ON
September 2024 – April 2025
About the Work:
As the BI Data Analyst, I built a scalable relational database in MySQL to streamline customer, vendor, and technician operations. I integrated department workflows and used advanced SQL queries to analyze technician productivity and optimize service distribution. Using Power BI, I developed dashboards that revealed revenue trends by service type, helping identify high-profit areas and reduce inefficiencies. These insights enabled smarter business planning and boosted operational efficiency by approximately 25% in just a few months.
Built a normalized relational database for clinic operations using MySQL and SQL Server. Designed an ERD, created schema, inserted data, and wrote optimized SQL queries to manage patients, staff, and appointments.
Analyzed customer purchasing patterns using Excel. Performed data cleaning, used Pivot Tables and advanced formulas, and built an interactive dashboard to visualize trends and insights./
Analyzed global survey data on compensation, satisfaction, and tool usage among data professionals. Cleaned data using Power Bl Query Editor and built interactive dashboards with bar charts, pie charts, and gauge visuals.
Cleaned and transformed datasets with Pandas, scraped web data using BeautifulSoup. and visualized insights with Matplotlib and Seaborn. Projects include EDA, automation scripts, and a customer behavior analysis.
Designed an interactive Tableau dashboard to visualize global video game sales by region, genre, platform, and publisher. Focused on clean Ul, interactivity, and storytelling through visuals rather than deep statistical modeling.
Will create a full cloud-based data solution using Azure Data Factory (data ingestion & cleaning), Azure SQL (storage), Azure ML Studio (optional modeling), and Azure Web App (dashboard hosting). Focused on cloud workflows, automation, and real-time insights.}
Comming Soon...