Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Work Availability
Timeline
BusinessAnalyst
Tania Useda-Castro

Tania Useda-Castro

Pompano Beach,FL

Summary

Experienced in data analysis with a knack for problem-solving and a proactive approach to challenges. Known for adaptability, creativity, and a results-oriented mindset. Committed to making meaningful contributions and advancing organizational goals.

Overview

19
19
years of professional experience
2
2
Certificate

Work History

Consultant-Operations

Verizon Communications
11.2021 - Current
  • Manage daily credit card reconciliations for 10 company brands and divisions, overseeing over $5 billion in annual credit card transactions, ensuring 100% data accuracy and timely financial closes.
  • Generate and present critical month-end close reports for accounting and tax teams, providing actionable insights into credit card revenue, fees, and sales taxes, facilitating accurate financial reporting and tax compliance.
  • Define and enhance internal processes through strategic data mining, database optimizations, and advanced SQL queries, improving data integrity and operational efficiency.
  • Develop comprehensive tools, interactive dashboards, and analytical reports leveraging data-driven insights to senior leadership, optimizing operational processes and influencing strategic decisions across multiple brands.
  • Automate critical data validation, reconciliation, and reporting processes using SQL and VBA, enhancing data accuracy by 99% and improving reporting efficiency by 50%.
  • Authored and maintain robust SQL scripts for daily credit card reconciliations and comprehensive exception handling (e.g., incomplete transactions, settlement issues, cancellations, returns, refunds), reducing manual intervention and ensuring transactional integrity.
  • Identify and proactively resolve critical reconciliation issues stemming from data download and system failures, maintaining high data integrity and preventing financial discrepancies.
  • Develop, document, and publish standardized operational procedures for credit card reconciliation, exception handling, and reporting, ensuring best practices, fostering team consistency, and maintaining regulatory compliance.
  • Analyze, validate, and report on $63 million in annual credit card fees, identifying cost-saving opportunities and ensuring financial accuracy, which directly contribute to enhanced cost management strategies.
  • Collaborate effectively with product owners, technical teams, and key stakeholders to develop essential business tools, streamlining workflows and improving data accessibility.

Analyst-Payments, Order Management & Invoicing

TracFone Wireless, Inc
04.2011 - 11.2021
  • Led daily reconciliation of over $5 billion in annual credit card transactions across 12 company brands.
  • Engineered and deployed automated solutions for data validation, reconciliation, and reporting, driving significant improvements in operational efficiency and data integrity.
  • Designed and optimized SQL scripts for complex credit card reconciliations and detailed exception management, including incomplete transactions and payment discrepancies.
  • Developed comprehensive dashboards and analytical tools that provided senior leadership with actionable insights to optimize operational processes and strategic decisions.
  • Proactively identified and resolved critical data download and system-related reconciliation issues, safeguarding financial data.
  • Authored and published detailed operational procedures and documentation for all credit card reconciliation and reporting activities.
  • Developed and maintained robust documentation for monthly tax reporting processes, enhancing consistency and facilitating training.

Real Estate Project Assistant

CSD Group, Inc.
03.2007 - 09.2010
  • Manage daily credit card reconciliations for 10 company brands and divisions, overseeing over $5 billion in annual credit card transactions, ensuring 100% data accuracy and timely financial closes.
  • Generate and present critical month-end close reports for accounting and tax teams, providing actionable insights into credit card revenue, fees, and sales taxes, facilitating accurate financial reporting and tax compliance.
  • Define and enhance internal processes through strategic data mining, database optimizations, and advanced SQL queries, improving data integrity and operational efficiency.
  • Develop comprehensive tools, interactive dashboards, and analytical reports leveraging data-driven insights to senior leadership, optimizing operational processes and influencing strategic decisions across multiple brands.
  • Automate critical data validation, reconciliation, and reporting processes using SQL and VBA, enhancing data accuracy by 99% and improving reporting efficiency by 50%.
  • Authored and maintain robust SQL scripts for daily credit card reconciliations and comprehensive exception handling (e.g., incomplete transactions, settlement issues, cancellations, returns, refunds), reducing manual intervention and ensuring transactional integrity.
  • Identify and proactively resolve critical reconciliation issues stemming from data download and system failures, maintaining high data integrity and preventing financial discrepancies.
  • Develop, document, and publish standardized operational procedures for credit card reconciliation, exception handling, and reporting, ensuring best practices, fostering team consistency, and maintaining regulatory compliance.
  • Analyze, validate, and report on $63 million in annual credit card fees, identifying cost-saving opportunities and ensuring financial accuracy, which directly contribute to enhanced cost management strategies.
  • Collaborate effectively with product owners, technical teams, and key stakeholders to develop essential business tools, streamlining workflows and improving data accessibility.

Education

Bachelor of Applied Science - Information Technology

Broward College
Davie, Florida
05.2023

Associate of Arts - Business Administration

Keiser University
Fort Lauderdale, Florida
05.2006

Skills

  • SQL data analysis
  • VBA automation
  • Advanced MS Excel proficiency
  • Experienced in Python programming
  • Experience with Oracle Financials
  • Tableau data visualization
  • Experienced with Thoughtspot analytics
  • C programming
  • C# programming
  • Java programming
  • Database management with MS Access
  • Experienced with Visual Studio IDE
  • Unity game design
  • Proficient in MS Office
  • Proficient in MS Visio
  • Proficient in MS Project
  • Graphic design skills using Photoshop
  • Proficient in Adobe Acrobat

Accomplishments

  • Collaborated with team of three in the development of the automation of the reconciliation process for sales and settlements of approximately $400 million a month.
  • Automated monthly audits using SQL and VBA macros, reducing report generation time by 50%.

Certification

  • CompTIA Network+ ce
  • CompTIA Project+

Languages

English
Native or Bilingual
Spanish
Native or Bilingual

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Consultant-Operations

Verizon Communications
11.2021 - Current

Analyst-Payments, Order Management & Invoicing

TracFone Wireless, Inc
04.2011 - 11.2021

Real Estate Project Assistant

CSD Group, Inc.
03.2007 - 09.2010

Associate of Arts - Business Administration

Keiser University

Bachelor of Applied Science - Information Technology

Broward College

Similar Profiles

CREATE PROFILE