•Programmed automated demand forecasting pipeline with PySpark for Produce sourcing team.•Created a multi-source Power BI dashboard that provided actionable category insights to upper management.•Developed dbt pipelines to extract and transform vast quantities of historical shipping data on an automated basis for team.•Manage a benefit tracking tool that reports over $100M in department profit to executive leadership.•Engineered a PySpark data stream that enabled analysts to efficiently analyze millions of rows of historical Point of Sale data.•Used Alteryx workflows to validate quarterly team savings goals, cutting processing time from several days to a few hours.•Built numerous ad-hoc Power BI dashboards that provide team with in-depth data visualization on their products.

• Translated provider claims data into reports for management using Power BI.•Transitioned existing Tableau reports to Power BI.•Automated reporting from Enterprise Data Warehouse via dbt pipeline.•Updated Medicaid and Medicare code sets in claims processing software via Python automation.•Acted as project manager for document processing and workflow software.

•Managed provider data in Enterprise Data Warehouse using SQL Server Management Studio.•Created comprehensive technical documentation for provider data loading process.•Automated provider license auditing process with Excel and Python, reducing timeline from 40 hours to 2 hours.•Established standardized process for auditing per diem employee workflows in collaboration with management.

•Presented Power BI dashboards on ROI of rental equipment to company ownership.•Managed and updated serialized equipment data and pricing in CRM software via SQL queries.•Advised department managers on profitability of potential equipment purchases via regression analysis.•Gathered revenue data from CRM software to provide leadership with info on most cost-efficient gear to purchase.

• Compiled data from CRM software in Power BI to visualize ROI of inventory purchases for company ownership.• Managed multiple successful installation projects for lighting controls and equipment.• Gathered requirements from clients for project proposals and installations.• Acted as subject matter expert for CRM software, entering and updating client data and rental order information.