Open to opportunities

Alejandro Cano Lopez

@alejandrocanolopez

Message

Financial and data analyst turning large datasets into compliant lease insights.

Colombia

Message

What I'm looking for

I’m looking for a role where I combine financial analysis with data analytics—building automated reports, reconciling systems confidently, and supporting compliance (IFRS/US GAAP) through clear dashboards and variance insights.

I’m a Financial and Data Analyst with B2 English proficiency, experienced in financial analysis, business planning, and reconciliation of local and international financial information.

I analyze large datasets with Python, integrate multiple data sources through key columns, create calculated variables, and extract actionable insights and trends. I also deliver financial reporting and visualization using Power BI, supporting decision-making across stakeholders.

In my current role as a Lease and finance analyst, I support the IFRS 16 to US GAAP transition, build consolidated lease accounting reports with SAP ERP, reconcile SAP FI with SAP FC consolidation outputs, and ensure compliance through variance analysis and journal entries. Previously, as an Accounts receivable jr analyst, I automated reconciliation processes, improved forecasting to reduce write-offs, and generated Excel strategic reports to monitor risk month by month.

Experience

Work history, roles, and key accomplishments

Current

Lease & Finance Analyst

Current

Holcim ABS

Mar 2023 - Present (3 years 1 month)

Analyzed fixed-asset capitalization, depreciation, and right-of-use lease accounts, producing variance reports in Power Query/Pivot tables to support decision-making and IFRS 16 compliance. Contributed to the transition from IFRS 16 to US GAAP by preparing lease accounting journal entries, consolidating lease accounting reports from SAP ERP, and reconciling SAP FI with SAP FC consolidation data.

Lease Accounting IFRS US GAAP SAP ERP Power Query Pivot Tables Journal Entries Fixed Asset Accounting Financial Reporting

Accounts Receivable Jr Analyst

UPS Supply Chain Solutions

Jun 2020 - Dec 2022 (2 years 6 months)

Optimized the accounts receivable reconciliation process by defining business requirements to automate manual steps and reduce human error. Managed AR forecasting to minimize write-offs by 40%, reconciled AR with client banking statements in Benner, and produced month-by-month Excel reports to identify unapplied payments and reduce closing inconsistencies.

Account Reconciliation Forecasting Cash Flow Management Benner Accounting

Finance Freelance Analyst

The Embroidery Warehouse

May 2019 - Dec 2019 (7 months)

Automated AR reconciliation by creating business-planning requirements to reduce accounting errors and improve monthly close accuracy. Managed AR, customer payments, and collections, minimizing bad debt by 40%, and performed bulk purchase order migration from X-cart to QuickBooks via Webgility.

Accounts Receivable Collections Quickbooks Data Mapping Webgility Migration Business Process Optimization

Finance Intern

Seguros Bolívar S.A.

Jul 2018 - Jan 2019 (6 months)

Analyzed customer financial statements for compliance policy eligibility and built financial models to support accurate assessments. Conducted financial planning, profitability indicator and indebtedness-level analysis, and evaluated whether commercial activity was generating profits for contract-taking customers.

Financial Statement Analysis Financial Modeling Financial Planning SME Financial Assessment Compliance Oriented Evaluation