Javier Medrano

Finance professional with over eight years of experience in Accounts Receivable and OTC processes, with a strong focus on cash applications, data analysis, reporting, and process automation. Experienced in using SAP and advanced Excel to support daily operations and optimize month-end close activities. Analytical, detail-oriented, and focused on process improvement and data accuracy.

Accounts Receivable Analyst – Cash Applications at Joyson Safety Systems (2020-01 – Present)

• Automate a month-end closing report using advanced Excel formulas and macros, reducing processing time from 13 hours to approximately 1.5–2 hours.
• Manage daily cash application activities for key automotive customers such as GM, Ford, BMW, Mercedes-Benz, and Tesla.
• Review bank statements and analyze unapplied cash and payment differences.
• Prepare cash application and reconciliation reports to support month-end close.
• Support factoring processes by reviewing credit limits and selecting eligible invoices.
• Post payments, clear debit and credit memos, perform invoice netting, and issue credit notes.
• Coordinate with billing, collections, and finance teams to resolve payment and invoicing issues.
• Use SAP FIORI, AS/400 (BPCS), customer portals, and banking platforms for daily operations.

OTC Financial Analyst at Johnson Controls (2019-01 – 2020-12)

• Analyzed accounts receivable aging and past-due balances to support collections.
• Managed service disconnections and customer account deactivations according to internal policies.
• Sent final demand letters to customers with overdue balances.
• Processed annual price increases, reductions, and pricing adjustments.
• Supported OTC controls and ensured accurate customer account status.

Accounts Receivable Specialist – Billing at Protrans de México (2017-01 – 2019-12)

• Managed billing activities for a portfolio of 23 customer accounts.
• Reviewed shipment information and validated carrier documentation.
• Prepared daily and weekly billing and revenue reports.
• Corrected billing issues through credit notes and rebilling.
• Ensured billing documentation was complete and accurate.

Accounts Payable Intern at Ficosa North America (2016-01 – 2017-12)

• Supported accounts payable activities, including invoice review and reconciliations.
• Assisted with data entry and document control.

Bachelor's Degree in Administration – Facultad de Contaduría Pública y Administración (UANL) (2013-01 – 2018-12)