At GEM Aromatics Ltd., I analyzed experimental datasets to monitor performance, yield trends, and process efficiency. I used SQL and Excel to validate data and created Power BI dashboards tracking KPIs, translating the findings into recommendations for operational improvement.
As a Trainee – RnD at Primodia chemicals & Pharmacuticals, I analyzed yield, purity, and efficiency metrics using Excel pivot tables and Power BI dashboards. I also prepared weekly cost optimization reports that helped inform R&D decisions.
For my Personal & Company Budget Tracker + Financial Analysis project, I analyzed 216 transactions with Excel, PostgreSQL, Python, and Power BI. The analysis surfaced over-budget transactions and departmental overspend, and I presented findings through an interactive dashboard.
I also developed a Modern Data Warehouse and Retail Analytics Solution using SQL Server and a Bronze-Silver-Gold medallion architecture. Its ETL pipelines processed transactional records, while Power BI dashboards presented KPIs, sales trends, and regional performance.
