Jonathan Aguilar Email & Phone Number

Seattle, Wa, Us

• Developed and implemented a consolidated Weekly Business Review process, streamlining three separate reports into a single end-to-end view for the CA team, saving time and providing leadership with actionable insights through cross-functional collaboration.• Spearheaded the overhaul of global ship revenue cost reporting, streamlining a 2-week manual process into a 1-day automated system, significantly improving efficiency and accuracy.

Seattle, Wa, Us

• Conducted in-depth analysis of product lifecycles for Amazon’s $44B Consumer Electronics stores, delivering actionable insights that optimized inventory management and pricing strategies for profit-maximization.• Developed a comprehensive dashboard using data visualization tools to track key performance indicators, including Average Inventory Levels, Average Selling Price, and Price Sensitivities at various product lifecycle stages. • Designed and implemented SQL queries to extract and analyze crucial lifecycle data, improving the accuracy and efficiency of tracking product lifecycles and supporting data-driven decision-making.

Burlingame, Ca, Us

• Created AR dashboard to visualize data, providing executive leadership with the ability to track receivables and set and achieve goals, including AR collection’s Q1 goal, bringing in $30M+ in final month of quarter. • Conducted and facilitated regular AR update meetings with customer relations teams, consisting of over 30 employees, to ensure alignment on collection strategies and identify areas for improvement.• Established a streamlined process for generating and maintaining daily, weekly, monthly, and yearly Cash Position reports provided to senior leadership for better tracking of current cash position and cash burn trends.

Clermont-Ferrand, Auvergne-Rhône-Alpes, Fr

• Forecast and manage all cash functions, including a $16 billion Mexican Peso credit line, cash flow, banking relationships, and reporting.• Ensure sufficient funds are available to meet ongoing operational and capital requirements. • Develop and improve upon the accuracy of the rolling daily and 3-month cash forecast. • Monitor interest payments on credit line and ensure the validity of lender calculations.• Collaborate with AP, AR, Legal, and Accounting to continuously update financial forecast models and maintain proper liquidity for Michelin entities. • Manage relationships with banking partners at HSBC, Citi, Citi Banamex, Santander, and Bank of America to ensure all bank accounts are up to date and efficient with innovative banking products. • GCE bank implementation project. Worked with Citi Banamex directly in Mexico to implement the GCE product replacement for the ZBA bank structure for automatic cash pooling between bank accounts and reduce overall bank fees charged. • Negotiated credit line limit between Michelin Mexico and Citi Banamex to a new increased limit of $316 million MXN.• Helped review liquidity and long-term forecasts to restructure debt for Michelin Mexico. Replaced the current $6 billion MXN loan for an equity injection of $3 billion MXN and a credit line increase with internal bank. • Key User for Treasury Management Systems Quantum and FIS-Trax. First point of contact between users of the systems and the in-house IT department. Worked on 2 system wide upgrades. • Worked with Bank of America and Prime Revenue to open a virtual bank account to facilitate Supply Chain Finance with suppliers. Collaborated with Accounts Payable and Legal to open the new virtual bank account and begin uploading suppliers into the system which allows them to negotiate payment terms directly with Prime Revenue without impacting Michelin.

Greenville, Sc, Us

As a Financial Account Analyst at ScanSource, I am responsible for managing a portfolio of customers' accounts in Central America and the Caribbean. I maintain positive relationships with my customers as well as with ScanSource internal departments to keep past due balances at a low percentage and acceptable level. I communicate with customers to resolve past due invoice disputes and research customer’s assertions related to claims and deductions for timely resolution.I analyze financial statements and public information of customers in order to determine a trade credit limit that assumes an appropriate level of risk while at the same time maximized each customer’s purchasing power. When customer’s do not meet underwriting minimums alternative financial solutions are reviewed such as Leasing, ESCROWs, and various types of Guarantees.Promoted from Account Analyst to Financial Account Analyst, a position with higher underwriting and approval authority.

Greenville, Sc, Us

As an Intern at ScanSource, I was responsible for updating the financial reviews for over 100 different companies. I gathered and recorded data from different sources including credit reports, financial statements, and internal account records into a “Scoring Model” report and analyzed the creditworthiness of those companies in order to recommend a trade credit limit with ScanSource. I analyzed past due accounts receivable balances and communicated with customers in order to resolve past due invoices. In working through these reconciliation issues I gained extensive knowledge in the navigation of SAP ERP. I managed credit card refund requests by following the company standard credit card refund process of pulling and documenting transaction records from SAP ERP. The Internship Group Presentation program allowed me to learn about collaborating with coworkers as well as how to work through issues as a group. My group of four interns saw a currently utilized business system called “CRM” (Customer Relationship Management) and brainstormed a creative plan for further utilization of that business system in order to assist sales representatives and tech support in better communicating with each other. My group was given the opportunity to present our plan in front of the ScanSource Executives, Vice Presidents, and Managers.

Atlanta, Ga, Us

Weekend Executive Mba Candidate

Bachelor Of Business Administration - Bba, Business Administration