Mariam

Data Intern

Seven Up Bottling Company

Jul 2026 - Present • 2 mos

1. Integrated production line metrics into a structured Data Model using Power Pivot, managing relationships across high-volume daily packaging data, container classifications (RGB vs. PET), and operational KPIs. 2. Developed dynamic DAX measures to calculate weighted packaging yields across core components—including crown yield, preform scrap rate, closures, shrink film, stretch wrap, and label application efficiency. 3. Built period-over-period and week-over-week (WoW) variance metrics in DAX, establishing robust handling of filter context to track throughput fluctuations and operational trends across production periods. 4. Designed custom conditional calculations to dynamically handle variable data patterns (e.g., zero-breakage PET lines vs. active RGB breakage metrics), maintaining visual data integrity without breaking visual reports. 5. Designed executive-facing visual dashboards featuring dual-axis charts and heatmaps to pinpoint material loss, scrap anomalies, and overall line performance across packaging formats.

Data Intern

Sona Agro Allied company

Feb 2026 - Jun 2026 • 4 mos

1. Gathered, cleaned, and analyzed production and sales data using Excel and SQL, supporting accurate monthly reporting. 2. Designed and maintained Power BI dashboards to track key performance metrics including revenue, customer growth, and unit price trends. 3. Documented business processes and identified optimization opportunities, contributing to improved data accuracy and efficiency. 4. Maintaining inventory accuracy — performing cycle counts, stock adjustments, and reconciling physical stock with ERP records for raw materials, work-in-progress (WIP), and finished biscuit products. 5. Collaborated with cross-functional teams (Production, Quality, and Accounts) to translate operational needs into clear requirements.