• Extracted, transformed, loaded (ETL) complex datasets from Excel and SAP BW within Power BI to enable performance visibility and facilitate decision-making for VPs, controller, regional sales managers, and product managers within a manufacturing company.• Streamlined multiple queries, visualizations, and KPI trackers (YOY sales, discounting, costs, and gross margin %) into one dashboard within Power BI Service to allow performance visibility by region, rep, year, pareto, hierarchy, product class, and SKU.• Administered row-level security to restrict access to sensitive information and implemented incremental refresh SQL storage procedures to secure and improve data source load times.• Built predictive and forecasting model to track inflation and estimate prices for finished materials by integrating SAP, purchasing, supply chain, and finance data. • Collaborated with cross-functional teams and communicated a compelling data story to senior leadership. • Established new cost tracking and management reporting system through Smartsheet and Power Automate, achieving $400,000 in savings FYTD and reducing procedure time by two weeks.• Created API connection to Power Automate using JSON to facilitate data transfers from Teams to Smartsheet.• Uncovered products with misaligned margins that led to a 10% increase in profits.• Created Excel tools for multiple company-wide increases by analyzing historic gross margins, current pricing, and forecasted cost.• Developed and optimized SQL server queries to retrieve inter-company sales data quickly from Standard Data Layer (STL).• Pulled and organized Salesforce data within Smartsheet using Data Shuttle to provide insights across production and orders.