Juan P.
Mid-Level FP&A and Treasury Analyst
Open to offersNew to PlatformAbout
Juan P. is a committed finance and accounting professional with over three years of experience in the U.S., focusing on FP&A, treasury operations, and financial reporting. With a strong command of Python, SQL, Power BI, and Excel VBA, he excels at process automation, budget cycle support, and delivering actionable insights critical for decision-making. His bilingual proficiency in English and Spanish enhances his capability to work in cross-functional and remote environments. Currently, as an E-Commerce Solutions Developer at AlpessanitSA, he innovated a PostgreSQL database for business pricing and inventory control and integrated it with Mercado Libre's API for enhanced sales operations. At Vensure Employer Solutions, as a Senior Treasury & Reporting Analyst, he reports directly to the VP of Accounting, where he maintains financial models and develops automated reporting tools, enhancing reconciliation and reducing errors across departments. His educational background includes a Bachelor's in Business Administration from Universidad Nacional de Cuyo.
Experience
E-Commerce Solutions Developer
AlpessanitSA · 2026 — PresentCreated a relational PostgreSQL database to manage business pricing logic, track inventory (including inbound/outbound flows and minimum-level alerts), and configure product listings. Developed an ETL pipeline for the processing and loading of a multi-brand product catalog (including pricing, sales modalities, and business rules). Integrated with the Mercado Libre API to automate the listing engine, synchronize inventory, send sales notifications, and model SKU-level profitability by factoring in commissions, tax withholdings, and operating costs.Senior Treasury & Reporting Analyst
Vensure Employer Solutions · 2024 — PresentOversaw the maintenance of multi-scenario financial models in Excel that supported monthly closing and cash flow reporting across operating units, contributing to FP&A planning cycles. Developed Power BI dashboards and SQL-driven reports focused on variance analysis (comparing actuals to budget), presenting insights in executive-ready format for senior leadership. Created VBA and Python automation tools to streamline reconciliation and reporting tasks among departments (AP, AR, Billing, Risk), enhancing accuracy and reducing errors in the close cycle.Treasury Staff Accountant
Vensure Employer Solutions · 2023 — 2024Conducted quarterly budgeting and rolling forecasts. Managed treasury reconciliation, pinpointing variances and escalating root causes to management to enhance month-end close accuracy. Supported month-end close and reconciliation processes through SQL and Excel-based reporting for treasury operations.Treasury Accounting Associate
Vensure Employer Solutions · 2022 — 2023Provided corporate client support by tracking and resolving payroll and treasury inquiries. Managed cases in ClientSpace (CRM). Monitored cash flow utilizing Sage Intacct.
Skills & Expertise
Education
- Bachelor's Degree in Business AdministrationUniversidad Nacional de Cuyo · 2016 — 2022
- High School Diploma (focus on Business and Economics)IES Puzol · 2009 — 2011
Interested in this professional?
Sign in as an employer to save this profile or invite Juan P. to a job.
Sign in as an employer