Anna Trepanier

Provided mobile notary and apostille facilitation services across Michigan, completing notarizations (acknowledgments, jurats, oaths/affirmations, and certified copies) and supporting apostille document preparation. Managed client documentation workflows using Office 365 and Trello.

Developed and ran SAP BOM, spend, and delivery performance reporting to support Purchasing, Plant Operations, and Supplier Compliance decision-making. Built and monitored KPI frameworks and exception/variance reports, using Incorta and SQL to accelerate ad-hoc analytics and improve data integrity through Power BI dashboards and automated reporting.

Develop and run SAP BOM, spend, and delivery performance reports to support purchasing, plant operations, and supplier compliance. Built KPI frameworks and Incorta/SQL datasets for SAP operational analytics, then delivered Power BI dashboards and automated reporting workflows to improve data integrity and operational visibility.

Built 25 Power BI dashboards to monitor KPIs in real time, improving decision-making accuracy for senior management and cross-functional teams. Validated ETL data extraction and used Power BI, Qlik Sense, and advanced querying to deliver actionable insights through dashboards, reports, and alerts.

Designed and developed end-to-end Power BI solutions, including DAX measures, data models, and reusable reporting templates. Migrated reporting from Qlik Sense to Power BI and leveraged Snowflake for dimensional modeling and query optimization to improve KPI data accuracy and reduce manual reporting effort.

Led the transformation of the Mopar supplier chargeback process from a manual spreadsheet workflow into a cloud-based enterprise system. Owned roadmap and governance for the platform, defined Agile requirements, built system workflow/data/validation logic, and delivered analytics and change-management to reduce processing time, improve data accuracy, and increase supplier accountability.

Managed supply chain databases and reporting for backorders, KPIs, and escalations using advanced Excel functions and monthly reporting. Developed an Access database to track missing parts shipments, saving over $200K and increasing customer satisfaction by 10%, and streamlined government contract fulfillment to reduce lead time by 10 days.

Developed and maintained supply chain KPI databases using Excel, Access, and SQL-based logic to track backorders, escalations, and operational performance. Built an Access database for missing-parts shipment tracking, reducing losses by over $200K and improving customer satisfaction by 10%, and streamlined government contract order fulfillment to reduce lead time by 10 days.

Designed and developed an Access database to centralize claims data and apply quantitative analytics to improve patient quality-of-care reporting, generating over $100K in savings. Analyzed claims to identify cost trends and improve provider ratings by 12% while defining assessment metrics and outcome measures.

Generated 11 standard and custom Excel/Tableau reports to provide insights into business performance and support ad-hoc reporting needs. Implemented BI solutions to track and optimize vendor training programs, improving operational efficiency by 10% and creating Tableau dashboards for carrier KPI monitoring.

Provided administrative support to a senior partner and technical consultants, including reviewing RFQ responses to facilitate bid opening sessions. Built an Access database to manage vendor information, streamlined 15 policy/procedure training documents in Word and PowerPoint, and reviewed CAD drawings for accuracy and compliance.

Earned a Bachelor of Arts in Management & Human Relations from Trevecca Nazarene University.