ANNA TREPANIER
Dryden,Michigan
Summary
Business Intelligence Analyst Analytics professional with a proven history of accomplishment. Resourceful decision-maker and critical thinker with strong problem-solving and organizational skills. Ability to smoothly manage complex and conflicting needs in a dynamic environment. Excel at taking others’ perspectives while maintaining the broader picture to reach a successful conclusion. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
20
20
years of professional experience
Work History
Stellantis
01.2012 - Current
Supplier Quality Process, Methods & Warranty Process Specialist
06.2023 - Current
- Identify and collect business requirements from multiple stakeholders to create/modify data visualization tools, i.e., Qlik Sense and Power BI applications
- Organize and maintain Team sites with FAQs, work instructions and process documentation
- Work with ICT staff to take the current North America business systems global by defining business case and creating Business Requirements Documents (BRD)
- Identified aging quality non-conformance tickets which allowed the company to collect $2.5M in cost savings.
Supplier Processes & Systems Program Manager
Mopar
01.2017 - 05.2017
- Of Mopar Supplier Chargeback system that provides an average $11M per year in cost recovery for the company
- Authored business requirements document, facilitated multiple design thinking workshops for end users to identify use cases and develop business requirements, and implemented feature suggestions from several departments and senior staff, resulting in an increase of product adoption by 15%
- Authored training materials and led training sessions with both internal and external stakeholders
- Developed 11 Qlik Sense applications including a Vehicle Off Road (VOR) dashboard that is used globally.
Data Analyst/ International Order Manager
01.2012 - 01.2017
- Developed and maintained International supply chain databases to analyze and manage International backorders, track key performance indicators (KPIs) and manage escalations to other teams which led to increased productivity and a 10% reduction in International backorders
- Identified system issues and developed an Access database to track missing parts shipments to the International freight forwarder resulting in a savings of over $200k in lost service parts and a 10% increase in International customer satisfaction
- Managed yearly government contract order fulfillment.
Data Analyst
Greater Macomb PHO
01.2011 - 01.2012
- Designed and developed an Access database to house claims data from multiple sources using quantitative methodology to better understand patient quality of care being delivered resulting in a savings of over $100k by bringing data analysis in-house
- Collaborated with Physician Healthcare Organization management to assist in the evaluation of medical management programs, including developing program assessment metrics, outcomes, research and reporting provider services
- Performed healthcare data extraction and transformation across multiple payers
- Extracted and analyzed claims to identify cost trends which improved provider ratings 12% from the previous year.
Data Analyst
United Parcel Service
Project Coordinator
Plante & Moran
Data Analyst
FOCUS Healthcare
Education
Bachelor of Arts - Management & Human Relations
Trevecca Nazarene University
Nashville, TN2002
Skills
- ETL development
- Data Quality Management
- SQL Programming
- Data Warehousing
- Requirements Gathering
- Business intelligence tools
- BI Strategy Development
- Task Prioritization
- Programming Languages: SQL, HTML5, Python
- Process Improvement
- Databases: Snowflake, MS Access
- Requirements Gathering and Analysis
- Testing and debugging
- Agile development methodologies
- Multitasking
- Excellent Communication
- Attention to Detail
- Problem-solving aptitude
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Supplier Quality Process, Methods & Warranty Process Specialist
06.2023 - Current
Supplier Processes & Systems Program Manager
Mopar
01.2017 - 05.2017
Stellantis
01.2012 - Current
Data Analyst/ International Order Manager
01.2012 - 01.2017
Data Analyst
Greater Macomb PHO
01.2011 - 01.2012
Data Analyst
United Parcel Service
Project Coordinator
Plante & Moran
Data Analyst
FOCUS Healthcare
Bachelor of Arts - Management & Human Relations
Trevecca Nazarene University
Similar Profiles
Yolanda PaigeYolanda Paige
Purchasing Intern at StellantisPurchasing Intern at Stellantis
Richard Jacobs IIRichard Jacobs II
Auto Worker at StellantisAuto Worker at Stellantis
Alexandr St. LouisAlexandr St. Louis
Security Guard at StellantisSecurity Guard at Stellantis
Brent GrzadzinskiBrent Grzadzinski
Picker/Packer at StellantisPicker/Packer at Stellantis
Hunter HughesHunter Hughes
Dishwasher at White Horse InnDishwasher at White Horse Inn