John Ryan Dolorito

Financial Data & Loan Operations Analyst with experience across AU/US mortgage lending and private credit, supporting both broker-driven loan processing and fund-level loan operations. I specialize in end-to-end loan lifecycle management—from income verification, serviceability assessment, and compliance checks to structuring, validating, and reconciling complex loan data within financial systems. My experience spans PAYG and self-employed analysis, HEM/living expense assessment, and submission of residential, personal, construction, and SMSF loans, ensuring fast, clean, and compliant loan packages for broker and lender review. In addition, I support private credit operations using Carta, where I work with multi-million dollar loan portfolios. My role involves structuring loan data (tranches, disbursements, interest schedules), performing detailed reconciliation of principal, accruals, and PIK calculations, and resolving discrepancies to maintain data integrity for fund-level reporting and investor outputs. I bring hands-on expertise across LMG MyCRM, Mercury, ApplyOnline (AOL), Simpology, Totality, and lender-direct platforms, combined with advanced Excel workflows, SQL for data querying, and Power BI for data visualization and reporting. I leverage AI-assisted automation (ChatGPT, Notion, OneDrive) to streamline processes, reduce errors, and improve turnaround times. My background in operations and technical support enables me to manage high-volume pipelines while maintaining precision, compliance, and system accuracy. I’m particularly focused on applying data-driven insights to improve loan processing efficiency, enhance reporting accuracy, and support scalable financial operations. I’m passionate about combining financial operations, data analytics, and process optimization to support global teams in non-voice, back-office environments where accuracy, speed, and structured data directly impact business performance.-SQL (Data Querying & Extraction) -Power BI (Dashboards & Reporting) -Financial Data Reconciliation-Variance and Credit Analysis-Data Visualization & Insights -Data Cleaning & Transformation -Advanced Microsoft Excel (Validation, Structuring, Automation) - Data Integrity & Quality Assurance -Financial Data Analysis & Loan Operations -PAYG & Self-Employed Income Assessment -Serviceability, HEM & Credit Review -Private Credit (Tranches, PIK, Accruals, Reconciliation) -Loan Lifecycle Management (AU & US Lending)