Gilberto Hernandez

Delivered four automated Power BI dashboards covering credit risk management, U.S. federal credit risk, order release tracking, and analyst assignment, reaching over 99% data automation. Redesigned cash forecasting and aged accounts receivable dashboards by transitioning data infrastructure from Excel to SQL and implementing Python automated loading pipelines, maintaining 95 to 98% forecast accura

Architected Power BI KPI dashboards for credit and collections that were adopted by the Finance Automation team. Engineered an automated data pipeline of 10 Power Automate flows that loaded scheduled Business Objects exports into SharePoint, eliminating manual file transfers.

Engineered dozens of self-service Business Objects queries and over 10 Power BI reports covering credit, collections, and accounts receivable. Led the migration of credit and collections reporting to a consolidated Finance platform using agile sprint delivery.

Engineered aged accounts receivable and cash flow forecasting models from scratch using Business Objects, Excel, and R, achieving 95% forecast accuracy with zero software investment. Validated risk reserve sufficiency for customers holding over $5M in accounts receivable by applying Monte Carlo bankruptcy simulations.

Engineered over a dozen custom Business Objects reports covering credit risk management, collector performance, past-due accounts receivable, and customer payment trends. Assumed leadership of a new reporting team by designing a workload tracking system and rebalancing task distribution across analysts.

Redesigned Excel dashboards with automated data flows, dynamic filtering, graphs, and auto-reconciliation tabs, cutting dashboard production time by 75%. Delivered SAP, GetPaid, and Business Objects training across the Americas, Europe, and Asia, including launching collections operations training in Guadalajara.

Migrated Latin America's order release function from Mexico to Costa Rica by structuring portfolio agent assignments and deploying flexible quarter-end scheduling. Sustained collection performance above the 75% current transactions target on a transferred Mexico direct portfolio.

Reduced monthly U.S. Public Service Commission complaints by 97%, from 30 to one per month, by handpicking a specialized retention team. Built the company's first agent performance measurement system by defining key metrics, structuring extractions from call center queue software, and designing Excel dashboards at zero additional cost.

Launched the company's inaugural inbound sales function by building two coverage shifts of 40 agents.

Supervised customer service shift operations for a U.S. telecommunications provider. Maximized call center performance by implementing Erlang C scheduling in Excel, exceeding a 90% service target.

Tripled sales within six months by rebuilding a leaner field sales team and redirecting resources toward corporate accounts. Realigned the inbound sales center to capture individual and small business sales.

Architected the credit and collections function by authoring the inaugural policies and procedures manual, whose core policies remained in place for the company's entire lifespan until acquisition. Engineered a custom Microsoft Access database to track current and past-due accounts receivable and generate collection performance reports.

Bachelor's Degree in Marketing from Universidad Veritas.