Business Process Analyst Intern
Houston, Texas, United States
• Implemented live API connections in Power BI to monitor historical prices of 9 key production metals, transformed data through Power Query, and analyzed price patterns and fluctuations to enable data-driven purchasing decisions based on macroeconomic trends• Remodeled Inventory dashboard by migrating data sources from Excel to SAP HANA databases, remapping relationships between 17 tables with constructed unique keys, and validating data with SQL, successfully eliminating reliance on external inputs and ensuring easy access to leadership• Collaborated with Fabrication department to upgrade estimating tool by replicating 50 Excel files with enhanced multipliers, populating data into SQL, and leveraging various components to calculate new factors, increasing accuracy in time and cost estimates for each project to better inform stakeholders