Juan Pablo Serrano
Juan Pablo Serrano

Senior Accounting Analyst | FP&A and Data Analytics Professional

Actively looking · Member since 4 Aug 2026
Message
Location
Mendoza, Argentina
Desired salary
Unspecified
Work preference
Remote Only / Full Time, Freelance
Experience level
Senior

About

Professional summary

I am a finance and accounting professional with more than three years of progressive experience at a US-based company, specializing in FP&A support, treasury operations, financial reporting, reconciliations, and month-end close processes.

I build multi-scenario financial models, support budgeting and rolling forecasts, and analyze actual-versus-budget variances to help leadership make informed decisions. I am experienced in cash flow monitoring, treasury reconciliation, and improving financial reporting accuracy across operating units.

I combine accounting expertise with data analytics and automation capabilities. I use Python, SQL, Power BI, Excel VBA, and PostgreSQL to automate recurring processes, develop reporting solutions, and turn financial data into actionable insights.

I have worked cross-functionally with AP, AR, Billing, Risk, and senior accounting leadership. My work has included developing executive-ready dashboards, resolving operational inquiries, and improving the efficiency and reliability of close-cycle reporting.

I also have freelance e-commerce development experience, including building PostgreSQL databases, ETL pipelines, inventory controls, and Mercado Libre API integrations. I am bilingual in English and Spanish and am eligible for remote or hybrid opportunities.

Skills

23 capabilities

Tech stack & tools

Working toolkit

Data Stores

Languages & Frameworks

Libraries

Experience

Career history

E-Commerce Solutions Developer AlpessanitSA

Designed a relational PostgreSQL database supporting business pricing logic, inbound and outbound inventory tracking, minimum-level alerts, and product listing configuration.

Built an ETL pipeline for multi-brand catalog processing and integrated the Mercado Libre API to automate listings, inventory synchronization, sales notifications, and SKU-level profitability analysis including commissions, tax withholdings, and channel operating costs.

Senior Accounting Analyst Vensure Employer Solutions

Maintained multi-scenario Excel financial models for monthly close, cash flow reporting, and FP&A planning support across operating units. Reported directly to the Vice President of Accounting.

Built Power BI dashboards and SQL-driven variance reports comparing actuals with budgets, producing executive-ready commentary for senior leadership. Developed VBA and Python automation tools for reconciliation and reporting workflows across AP, AR, Billing, and Risk.

Treasury Staff Accountant Vensure Employer Solutions

Supported quarterly budgeting and rolling forecast activities for treasury operations.

Performed treasury reconciliations, identified variances, escalated root causes to management, and created SQL and Excel reporting to improve month-end close and reconciliation processes.

Treasury Accounting Associate Vensure Employer Solutions

Supported corporate clients by tracking and resolving payroll and treasury inquiries through case-management processes.

Monitored cash flow using Sage Intacct and used ClientSpace CRM to manage client cases and operational follow-up.

Education

Learning history

Universidad Nacional de Cuyo

Bachelor's Degree, Business Administration

Bachelor's Degree in Business Administration.

This professional hasn’t added portfolio projects yet.

This professional hasn’t listed any services yet.

People also viewed

All talent ›
Jobs Talent Salaries
Menu