Huyen Pham Email and Phone Number

- Built business intelligence dashboard for internal team in the Supply Chain Department.+ Collected data from SAP, other systems and internal Excel files to store in SSMS, then utilized Visual Studio and SSAS to develop a tabular model. Subsequently, created Power BI dashboard encompassing: Gemstone Purchasing (Diamond Pricing Analysis and Gemstone Demand); Non-Jewelry Purchasing (Purchase Order Analysis, Vendor Management and Inventory Tracking); Guarantee Center (Inventory Tracking, Production Activity and KPIs) and Product Category Pricing Analysis.+ Used Google BigQuery and Looker Studio to build Replenisment dashboard that provided the inventory situation and respond ratio of each product group to make weekly goods transfer decisions.- Built Ticket System in Power Apps, integrated Power Automate to save data into server and send email notifications when a ticket is created, response tracking, alert about deadline and rating.

- Developed and managed BI reports for an agricultural production and export company.+ Designed data model by Visual Studio, deployed to SSAS and analyzed multiple data sources such as SAP, Warehouse Management System (WMS) ...+ Built PowerBI reports in Sales and Supply Chain to monitor daily activities and the Monthly Performance Review.+ Troubleshot data accuracy problems and managed user permission.- Developed reports for Manufacturing Management (DigiFactory) and Distribution Management System (DMS) Projects.+Created stored procedure and view by SSMS or Azure Data Studio.+ Used Stimulsoft to build reports about manufacturing management and quality management (FM project), sales and KPI (DMS project).- Built ERP User Performance Dashboard on OAC to review and optimize license cost.

- Planed merchandise coordination for a system of 44 stores, eCommerce and other sales campaigns.- Collaborated with internal team (Retail, Business Development, eCommerce, Warehouse) to collect goods demand and monitor coordination.- Builtg and managed the Master Data of all products (>12K SKU).- Analyzed Inventory and Sales using Power BI and Excel.