Professional Experience

Resume

Reporting & Automation Analyst

Reporting & Automation Analyst

Justin L. Ferrara

Excel/VBA • SQL-Style Logic • Data Validation • Process Improvement

Professional Summary

Reporting and automation professional with 9+ years at T-Mobile, including 6+ years building Excel/VBA reporting workflows, validating billing and account data, documenting repeatable processes, and supporting government, enterprise, and strategic account reporting. Experienced in turning complex operational data into accurate, repeatable, stakeholder-ready deliverables.

  • 9+Years at T-Mobile
  • 150+Recurring report packages
  • 600K+Lines in a monthly portfolio
  • 30M+Monthly data points

Professional Experience

Analyst, Customer Reporting

T-Mobile USA Inc. • Bellingham, WA

Feb 2019 – Sep 2025

  • Converted a distributed 5–7 person, week-long New York City government billing-report cycle into a solo-managed VBA and browser-assisted workflow producing 150+ recurring Excel and PDF report packages.
  • Built monthly Excel/VBA reporting for a telecom portfolio exceeding 600,000 lines of service and 30M+ data points, using arrays, dictionaries, header detection, and staged files.
  • Developed Excel/VBA and ADODB reporting frameworks using Access SQL-style queries against folder-based CSV and XLSX sources to generate formatted, customer-ready outputs.
  • Built recurring monthly and quarterly reporting workflows that consolidated 30+ source files across local folders, CSV inputs, and approved enterprise exports from Snowflake and Teradata.
  • Created billing validation and payment reconciliation reports aligning account, subscriber, balance, payment, and bill-total data for approval and exception research.
  • Built VBA tools to identify restricted data, aggregate service-level details to account totals, and support process changes that kept sensitive data out of standard outputs.
  • Managed report and template-change requests, clarified requirements, updated Excel/VBA templates and documentation, and adjusted recurring workflows for business, enterprise, and government accounts.

Messaging Specialist & Customer Service Representative

T-Mobile USA Inc. • Bellingham, WA

Jan 2016 – Feb 2019

  • Managed multiple concurrent customer conversations while researching complex billing, device, service, and policy issues across multiple systems, balancing speed, accuracy, documentation, empathy, and privacy.
  • Developed and maintained WordSmith, a browser-based internal support tool used by 80+ messaging users across two sites to improve access to reusable content and support resources.
  • Created focused WordSmith versions for iPhone and Samsung launch events, with tailored content and simpler distribution.
  • Earned nationwide top-performer recognition across multiple months for service results.

94A Land Combat Electronic Missile Systems Repairer

United States Army • Germany, Iraq & U.S. duty locations

Feb 2008 – Oct 2013

  • Used technical manuals, schematics, wiring diagrams, test equipment, and structured troubleshooting to isolate faults and complete corrective actions.
  • Maintained accurate work orders, repair records, parts documentation, equipment status updates, and sensitive maintenance information.
  • Managed controlled equipment, tools, vehicles, and inventory batches exceeding 1,000 items and valued above $1M.
  • Served overseas in Europe and deployed in support of Operation Iraqi Freedom.