
Juan Manuel V.
Business automation and data solutions with Python, Excel, Power BI, AI
Skills

Bekijk mijn diensten


Portfolio
Werkervaring
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.
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.