Johan Andres Diaz Paipa

• Manage the end-to-end lifecycle of corporate loans (syndicated and bilateral), ensuring accurate pricing, fee processing, drawdowns, and disbursements through LoanIQ and C360.
• Analyze Credit Agreements to structure loans, interpret covenants, and validate financial conditions for corporate clients.
• Perform financial and risk analysis, evaluating cash flows, financial statements, derivatives, and hedging strategies to assess credit quality and investment feasibility.
• Develop automation solutions using Python, SQL, and Power Apps, reducing operational processing time by 30–40% and improving data integrity in corporate lending workflows.
• Standardize procedures with global teams in Canada to enhance workflow automation, control structures, and multi-platform consistency.
• Design parent-deal control structures to strengthen traceability and long-term performance monitoring of large corporate portfolios.

Key Achievements:

• Enhanced financial evaluation models used for loan structuring, improving the accuracy of investment and risk assessments.
• Led automation initiatives that significantly reduced manual errors and improved data accuracy for syndicated lending operations.
• Supported major loan transactions through detailed feasibility, return, and risk evaluations.

• Supported senior officers in high-value client transactions by analyzing P&L revenue performance and building forecasting models in Python using SQL data from Salesforce and Stripe.
• Conducted comprehensive financial analysis of monthly revenue datasets, preparing strategic proposals for clients across LATAM.
• Developed automated billing workflows (Python + SQL + SAP), reducing processing times and increasing financial data accuracy.
• Built a client classification automation for Mexico integrating Facturama, improving fiscal compliance, billing accuracy, and operational efficiency.
• Assessed blocked and past-due clients, estimating revenue risk exposure and supporting mitigation strategies.

Key Achievements:

• Increased forecast accuracy by correcting dataset structures, eliminating data errors, and standardizing pipelines.
• Reduced billing processing time through end-to-end automation and improved data quality across revenue operations.
• Improved fiscal classification accuracy and compliance for Mexico’s billing ecosystem.

• Conducted daily valuation of multi-instrument portfolios, delivering key inputs for investment decisions.
• Prepared monthly reports on portfolio performance, returns, and composition.
• Performed risk assessments, including sensitivity to economic shocks and optimization strategies for improving returns.
• Executed financial audits and supported issuer and counterparty risk ratings.
• Calculated VaR (Annex 2) and performed fund/portfolio evaluations to support risk monitoring.