Need someone to automate your spreadsheets, build real-time dashboards, or manage your accounts receivable? You're in the right place.
I'm a Credit Control professional with 5+ years of experience in Accounts Receivable, collections, reconciliation, and financial operations — currently working at a Fortune 500 company managing multi-currency AR portfolios across 78+ global clients worth $8.7M+ in receivables.
What makes me different? I don't just do the work — I build tools that eliminate manual work. I combine finance expertise with technical skills to create automated solutions that save teams hours every week.
Here's what I can do for you:
Excel VBA Automation — Custom macros, automated reports, dynamic dashboards, conditional formatting, data cleanup, and one-click tools that replace hours of manual spreadsheet work.
Web Dashboard Development — Interactive, real-time dashboards built with HTML, JavaScript, and Firebase. Multi-user collaboration, cloud sync, and one-click Excel export.
AI & Copilot Automation — Leveraging Microsoft Copilot and AI tools to automate reporting, data analysis, and repetitive workflows.
Accounts Receivable & Credit Control — Aging analysis, collections follow-up, payment reconciliation, SAP cash application, dispute resolution, and AR portfolio management.
Data Reporting & Visualization — Clean, professional reports with charts, pivot tables, and visual dashboards.
Tools: SAP, Excel (Advanced + VBA), Python, HTML/CSS/JavaScript, Firebase, GitHub Pages, Microsoft 365, SharePoint, Power Automate, Microsoft Copilot
See my live work:
Portfolio:
Available for part-time gig work (evenings & weekends PH time). Ready to start immediately.
Experience: 2 - 5 years
5+ years in AR management across Publicis Groupe, Genpact, and Security Bank. Handle multi-currency reconciliation, aging analysis, collections follow-up, dispute resolution, and payment allocation. Built a live AR dashboard tracking $8.7M+ receivables across 100+ clients.
Experience: 10+ years
Advanced Excel user with strong VBA/Macro skills: build custom macros for automated reporting, data cleanup, conditional formatting, dashboard generation, and one-click tools. Proficient in pivot tables, VLOOKUP/XLOOKUP, INDEX-MATCH, Power Query, and dynamic dashboards. Created VBA-powered AR dashboards with mass update features, auto color-coding by aging bucket, and automated export functions for 78+ global clients.
Experience: 5 - 10 years
5+ years of collections experience across banking (Security Bank) and shared services (Publicis Groupe, Genpact). Handle structured follow-ups, escalation, dispute resolution, and payment negotiations for multi-currency AR portfolios. Skilled in reducing DSO and improving cash flow through proactive outreach.
Experience: Less than 6 months
Use Python for data automation, report generation, and AR workflow scripting. Combined with Excel VBA and web tools to create end-to-end automation pipelines for accounts receivable processes.
Experience: 5 - 10 years
Customer Service: 5+ years of professional client communication — collections calls, payment follow-ups, dispute resolution, and email correspondence with global clients across US, UK, UAE, and APAC regions.
Experience: 2 - 5 years
Hands-on SAP experience in cash application, payment categorization, offsetting, check refunds, account linking, and customer master updates. Used SAP daily for AR reconciliation and reporting at Genpact Philippines.
Experience: 5 - 10 years
5+ years analyzing AR data across 100+ global clients worth $8.7M+ in receivables. I build automated dashboards, aging reports, and real-time tracking tools using Excel (pivot tables, VLOOKUP, advanced formulas), VBA macros, Python, and web-based dashboards (HTML/JS/Firebase). Experienced in identifying collection risks, payment trends, and portfolio performance through data-driven insights.
Experience: 5 - 10 years
5+ years handling financial records, payment reconciliation, cash application, aging reports, and multi-currency accounts. Experienced in tracking receivables, processing refunds, managing overpayments, and generating monthly financial reports across global client portfolios.
Experience: 10+ years
Build interactive charts, dashboards, and visual reports that turn raw data into actionable insights. Create real-time web-based dashboards with aging bucket color-coding, trend analysis, and portfolio performance views using HTML/JS and Excel.
Experience: 2 - 5 years
Fast and accurate data processing across large AR datasets — invoices, payment records, reconciliation files, and client portfolios. I go beyond basic data entry by building automation tools (Excel VBA, Python) that eliminate repetitive manual input.
Experience: 2 - 5 years
Build and manage cloud databases using Firebase for real-time data sync. Design data structures for AR tracking systems, manage large datasets with 78+ client records, and create automated data pipelines from Excel to web dashboards.
Experience: 10+ years
Daily power user of the Microsoft 365 ecosystem: Outlook, Excel, Teams, SharePoint, Power Automate, and Microsoft Copilot. Leverage AI automation features to streamline AR workflows, reporting, and team collaboration.
Experience: 5 - 10 years
Use SharePoint daily for document management, team collaboration, and file sharing. Experienced in navigating SharePoint libraries, managing AR documents, and integrating with Microsoft 365 tools for workflow automation.
Experience: Less than 6 months
Build interactive web-based dashboards using HTML, CSS, JavaScript, and Firebase for real-time cloud sync. Developed and published a live AR Issue Detail Dashboard on GitHub Pages with multi-user editing, Excel upload/export, and conditional formatting. Portfolio: https://ruceljhoncaballero-star.github.io/My-Portfolio/
“I have found someone who is smart, has a great work ethic and is easy to work with.”
Sara Brumfield
SEE MORE REAL RESULTS“My life has gotten so much better. It changed my life, and I know it can change yours”
- Lukas Rohler
Onlinejobs.ph "ID Proof" indicates if "they are who they say they are".
It DOES NOT indicate skill level.
ID Proof scores are 0 - 99 with 99 being the best. It is calculated based on dozens of data points.
It's intended to help employers know who they're talking to is real, and not a fake identity.