Summary
Overview
Work History
Education
Skills
Timeline
BusinessAnalyst
Alexander Wiley

Alexander Wiley

San Antonio,TX

Summary

Dynamic Accounts Receivable Specialist with proven expertise at Accenture Federal Services in invoicing and billing reconciliation. Demonstrated problem-solving skills and attention to detail, successfully resolving discrepancies and improving cash flow. Proficient in Costpoint and Excel, I streamlined processes, enhancing efficiency and accuracy in financial reporting.

Overview

8
8
years of professional experience

Work History

Accounts Receivable Specialist

Take2 IT Consulting LLC
05.2024 - Current
  • Own full-cycle A/R for a multi-million-dollar government-services and commercial portfolio, generating and e-mailing 100% of invoices and cash receipts each week in Deltek Costpoint and Quickbooks.
  • Proficient in client portals for invoicing and A/R recon - Taulia, Coupa, SAP Ariba, IPP US Treasury, WAWF, DFAS, Tungsten, Bill.Com, Fieldglass, Beeline, Workday, Ledios - SLATE
  • Reconcile the A/R sub-ledger and all bank, credit-card, and LOC accounts monthly, keeping accounts audit-ready and cutting unreconciled items by ≈35%.
  • Monitor aging daily, drive collections calls/emails, and negotiate payment plans; reduced 60-day-plus past-due balance from 18% to 9% of total A/R in six months.
  • Prepare weekly cash-flow forecasts for leadership, highlighting risk accounts and expected receipts to improve cash-on-hand planning.
  • Create detailed expense and deposit reports; improve data accuracy by standardizing Excel templates and automating lookups & pivot-table dashboards.
  • Strengthen internal controls—introduced dual-verification deposit process and invoice-to-PO cross-check—shortening month-end close by two days.
  • Liaise with project managers and external auditors; compile support, present findings, and resolve variance issues ahead of tight closing deadlines.
  • Lead ad-hoc root-cause analyses for complex billing discrepancies, saving ≈$25k in potential write-offs YTD.

Senior Accounts Receivable Analyst

Accenture Federal Services
06.2023 - 05.2024
  • Managed a 15–25 MM federal-contract portfolio across 200+ Costpoint projects; posted 100 invoices per month and maintained
  • Supervised and mentored 10 A/R analysts, setting KPIs, reviewing reconciliations, and ensuring compliant billing under FAR/DFARS guidelines.
  • Drove root-cause analysis on billing variances, collaborating with project controllers and client CFO teams; cleared $4.2 MM in aged unbilled within one quarter.
  • Built Cognos reports and Excel dashboards (VLOOKUP, Power Query, pivot tables) to track unbilled, funding burn-rate, and cash-application status.
  • Served as primary liaison to Defense-sector clients—resolved funding mods, contract mods, and delivery-order issues, securing timely incremental funding.
  • Posted all customer cash and performed complex payment applications, reducing unapplied cash from $600k to <$50k.
  • Provided weekly aging, risk, and cash-forecast updates to senior management; input drove collection strategies and quarterly revenue projections.
  • Designed and delivered onboarding curriculum for new analysts and acted as Defense portfolio trainer, raising team invoice-first-pass accuracy to 98%.
  • Implemented process automation (Excel macros, Costpoint batch routines) that cut manual invoice prep time by 40% and eliminated several redundant checks.
  • Partnered with auditors to supply reconciliations and supporting schedules.

Accounts Receivable Analyst

Accenture Federal Services
03.2017 - 06.2023
  • Maintained high-volume Costpoint and Excel databases, leveraging advanced formulas, VLOOKUPs, and pivot tables to cleanse, analyze, and retrieve project billing data quickly and accurately.
  • Verified invoices, contracts, and supporting documents in Word and Adobe PDF, ensuring 100 % compliance with contract terms and FAR/DFARS guidelines before release.
  • Prepared and posted customer invoices in Costpoint based on complex contract structures (T&M, cost-plus, fixed-fee, millstone), minimizing billing errors and rework.
  • Performed end-to-end account research and reconciliations—identifying variances, tracing root causes, and clearing discrepancies to keep A/R sub-ledger audit-ready.
  • Produced weekly aging, DSO, and past-due summaries for management; flagged high-risk accounts and recommended collection strategies that improved cash realization.
  • Partnered with finance leadership on revenue and cash-flow forecasts by providing real-time unbilled, funded-value, and collection metrics.
  • Reconciled project setup, funding, and billing data across Costpoint and client portals, ensuring accuracy and adherence to contractual and federal policy requirements.
  • Coordinated with client project teams, program managers, and government contracting officers to resolve variances, secure incremental funding, and expedite payments.
  • Served as primary liaison on assigned federal projects —communicated status updates, documentation needs, and funding requirements to both internal stakeholders and external agencies.

Education

High School Diploma -

Robert D. Edgren High School
Misawa Air Force Base, Japan
06-2007

Skills

  • Salesforce, Deltek Costpoint, COGNOS, Bullhorn experience
  • Microsoft Excel Proficiency
  • Attention to Detail
  • Invoicing/ Billing
  • Unbilled Receivables Analysis
  • Problem Solving / Root Cause Analysis
  • Database Management
  • Billing Reconciliation
  • General Ledger Analysis
  • Accounts Receivable Collections

Timeline

Accounts Receivable Specialist

Take2 IT Consulting LLC
05.2024 - Current

Senior Accounts Receivable Analyst

Accenture Federal Services
06.2023 - 05.2024

Accounts Receivable Analyst

Accenture Federal Services
03.2017 - 06.2023

High School Diploma -

Robert D. Edgren High School

Similar Profiles

CREATE PROFILE