j
joanmanuelvare

Juan Manuel V.

@joanmanuelvare

Business automation and data solutions with Python, Excel, Power BI, AI

Argentina
Spanish, English
About me
I spent 10+ years in credit, collections and finance operations at multinational companies. Now I build the tools those teams need: Python and Excel VBA automations, Power BI dashboards, internal web apps and AI-assisted workflows. Because I've worked in these processes myself, I understand your business rules (due dates, credit limits, reconciliations), not just the code. Send me a sample file (anonymized is fine) and I'll tell you what can be automated and what it will take.... Read more

Skills

j
joanmanuelvare
Juan Manuel V.
Offline • 
Average response time: 1 hour

See my services

Data Dashboards
I will build a power bi accounts receivable dashboard with aging, dso and cash kpis
Automations & Agents
I will match customer bank payments to open invoices using python and excel

Portfolio

Work experience

Independent

Business Automation & AI Solutions Developer

Independent

May 2024 - Present • 2 yrs 6 mos

Design and build automation, management and AI solutions for financial and operational processes: - CUBO: multi-tenant credit & collections platform with an AI agent on Telegram, in validation with 10 companies. - A daily credit-risk monitoring system with LLMs and automated alerts, used by a cooperative's credit department. - AscenSort: an equipment-failure analysis app in use at an elevator & escalator maintenance company. - A bank reconciliation engine in Python that auto-reconciled 97.2% of the credited amount on a test statement. Stack: Python, SQL, Power BI, Excel VBA, APIs, LLMs, Vercel, Railway.

Saputo_Inc

Senior Credit & Collections Analyst

Saputo Inc

Jul 2018 - May 2024 • 5 yrs 10 mos

Managed the top four national retail chain accounts, negotiating payment terms and resolving complex commercial and billing disputes. - Built a risk-segmentation model in Excel and Power BI that the team used to prioritize collections; in the following six months, 60+ day past-due debt fell by 20% (team result). - Redesigned and automated management reporting in SAP and Power BI (DAX), cutting the monthly close from 5 to 2 days.