Microsoft Office Apps
Christian Medina
FTA Analyst
Puebla
Summary
International Trade professional with a proven track record, seeking to maximize the workflow efficiency by developing taylor made solutions that contribute to reduce complexity and streamline business processes.
Currently looking for a company that gives leeway to develop and implement innovative ideas to improve team performance and efficiency of processes.
Overview
4
4
years of professional experience
6
6
years of post-secondary education
1
1
Language
Work History
Free Trade Agreement Analyst
FORVIA Faurecia
Puebla
01.2023 - Current
- Implemented a VBA application to fully automate the USMCA Origin Analysis process which decreased the time spent to approximately 50%.
- Implemented an Excel dashboard to measure FTA KPIs.
- Analyze and interpret Free Trade Agreements and Rules of Origin
- Manage
- Ensure timely submission of FTA documents for border crossing operations.
AP US/CA Customs Coordinator - FORVIA In House
META & CAE Agencial Aduanal
Puebla
02.2022 - 01.2023
- Developed a web application, in conjunction with software developers, to automate the auditing and reviewing of customs brokerage invoices.
- Implemented a process that streamlined the reconciliation of customs brokerage invoices which contributed to reducing 80% of overdue invoice debt in one year
- Implemented an Excel dashboard to measure invoice payment processing KPIs.
AP US/CA Customs Analyst - FORVIA In House
META & CAE Agencia Aduanal
Puebla
04.2021 - 01.2022
- Reconciliation of Customs Brokers' Statement of Account
- Received customs brokerage invoices, audited, reviewed and routed for approval to the Accounts Payable department.
- Managed high-volume (approximately 1500 monthly) invoice auditing efficiently, maintaining a consistent record of timely payments.
- Maintained a good communication channel between the Accounts Payable department and the Customs Brokers.
Education
Bachelor's in International Trade - International Trade
Benemérita Universidad Autónoma De Puebla
Puebla 08.2014 - 10.2020
Skills
Process enhancement
Process-oriented
Analytical thinking
Attention to detail
Team collaboration
Decision-making
Continuous improvement
Software
Visual Basic for Applications (VBA Excel Macros)
Microsoft Excel
Power BI
Power Automate
SAP ERP
Timeline
Free Trade Agreement Analyst
FORVIA Faurecia
01.2023 - Current
AP US/CA Customs Coordinator - FORVIA In House
META & CAE Agencial Aduanal
02.2022 - 01.2023
AP US/CA Customs Analyst - FORVIA In House
META & CAE Agencia Aduanal
04.2021 - 01.2022
Bachelor's in International Trade - International Trade
Benemérita Universidad Autónoma De Puebla
08.2014 - 10.2020