![Juan Pablo Serrano](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/08/avatar_73939_1785880290.jpg) Juan Pablo Serrano # Senior Accounting Analyst | FP&A and Data Analytics Professional Actively looking · Member since 4 Aug 2026 [Message](https://jobicy.com/enter4715.php.md) ShareLocationMendoza, ArgentinaDesired salaryUnspecifiedWork preferenceRemote Only / Full Time, FreelanceExperience levelSenior * [Overview](#overview) * [Portfolio 0](#portfolio) * [Services 0](#services) ## About Professional summaryI 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[Accounting](https://jobicy.com/talent/accounting.md)[Asset Allocation](https://jobicy.com/talent/asset-allocation.md)[Budgeting](https://jobicy.com/talent/budgeting.md)[Cash Flow Management](https://jobicy.com/talent/cash-flow-management.md)[Data Analysis](https://jobicy.com/talent/data-analysis.md)[DAX](https://jobicy.com/talent/dax.md)[ETL](https://jobicy.com/talent/etl.md)[Financial Modeling](https://jobicy.com/talent/financial-modeling.md)[Financial Planning And Analysis](https://jobicy.com/talent/financial-planning-and-analysis.md)[Financial Reporting](https://jobicy.com/talent/financial-reporting.md)[Forecasting](https://jobicy.com/talent/forecasting.md)[Inventory Management](https://jobicy.com/talent/inventory-management.md)[Month End Close](https://jobicy.com/talent/month-end-close.md)[PostgreSQL](https://jobicy.com/talent/postgresql.md)[Power BI](https://jobicy.com/talent/power-bi.md)[Power Query](https://jobicy.com/talent/power-query.md)[Pricing Strategy](https://jobicy.com/talent/pricing-strategy.md)[Process Automation](https://jobicy.com/talent/process-automation.md)[Python](https://jobicy.com/talent/python.md)[Reconciliations](https://jobicy.com/talent/reconciliations.md)[Risk Management](https://jobicy.com/talent/risk-management.md)[Rolling Forecasts](https://jobicy.com/talent/rolling-forecasts.md)[SQL](https://jobicy.com/talent/sql.md) ## Tech stack & tools Working toolkit ### Data Stores [![Image](https://cdn.jsdelivr.net/gh/devicons/devicon@master/icons/postgresql/postgresql-original.svg) PostgreSQL](https://jobicy.com/talent?tool=postgresql.md) ### Languages & Frameworks [![Image](https://cdn.jsdelivr.net/gh/devicons/devicon@master/icons/python/python-original.svg) Python](https://jobicy.com/talent?tool=python.md) ### Libraries [![Image](https://cdn.jsdelivr.net/gh/devicons/devicon@master/icons/numpy/numpy-original.svg) NumPy](https://jobicy.com/talent?tool=numpy.md)[![Image](https://cdn.jsdelivr.net/gh/devicons/devicon@master/icons/pandas/pandas-original.svg) Pandas](https://jobicy.com/talent?tool=pandas.md) ## Experience Career history ### E-Commerce Solutions Developer · AlpessanitSA Mar 2026 – Jun 2026Designed 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 Apr 2024 – PresentMaintained 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 May 2023 – Apr 2024Supported 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 Aug 2022 – May 2023Supported 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 May 2016 – Dec 2023Bachelor'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 [![Eugene Gouws](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/08/avatar_57531_1785858229.jpg) Eugene Gouws Senior Accountant | Chartered Accountant (CA(SA)) | Financial Reporting Specialist](https://jobicy.com/u/id57531.md) [![Rodrigo Brito](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/08/avatar_73808_1785793449.jpg) Rodrigo Brito Senior Accounting and Accounts Receivable Specialist](https://jobicy.com/u/id73808.md) [![Anton Grin](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/05/avatar_61997_1779685441.jpg) Anton Grin Director of financial company, chief of financial department](https://jobicy.com/u/id61997.md) [![Luis Ayala](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/07/avatar_72861_1785179925.jpg) Luis Ayala Senior Operations Consultant | Management Control, Logistics, and Process Audit Specialist](https://jobicy.com/u/id72861.md) [![Cassandra Stevens](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/07/avatar_72824_1785171414.jpg) Cassandra Stevens Financial Services Operations Team Lead](https://jobicy.com/u/id72824.md) [![Walter Chedid](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/07/avatar_72806_1785167316.jpg) Walter Chedid Administrative and Accounting Manager](https://jobicy.com/u/id72806.md) [![Braian Ivan Luna](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/07/avatar_72675_1785118323.jpg) Braian Ivan Luna Tesorero interno](https://jobicy.com/u/id72675.md) [![Darrin Campbell](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/07/avatar_72656_1785111199.jpg) Darrin Campbell I am very decent and looking for partner](https://jobicy.com/u/id72656.md) [All talent ›](https://jobicy.com/talent.md)