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
18
18
years of professional experience
2
2
Certificate
Work History
Cslt-Payments
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
- Responsible for the editing and formatting of all contracts, including Request for Proposals, Letter of Intents, AIA Contracts, Purchase Orders and Change Orders.
- Assisted in the preparation of business plans, executive summaries and offering memorandums.
- Was responsible for the preparation and consolidation of project budgets, financial analysis including income and revenue projections.
- Prepared project and financial presentations in coordination with an international project team
- Prepared project schedules in MS Project and Primavera P6.
- Assisted in the management and daily upkeep of the projects' contract administration software.
- Responsible for developing the project's procedural manual and updating as needed.
- Responsible for the installation, maintenance, and troubleshooting of the office software and hardware.
Education
Bachelor of Applied Science - Information Technology
Broward College
Davie, Florida05.2023
Associate of Arts - Business Administration
Keiser University
Fort Lauderdale, Florida05.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%.
- Led data clean-up operations for reconciliation purposes, reducing data inaccuracies by 10%.
- Identified and resolved system errors that were causing delays in settlements and product delivery, leading to a significant increase in customer satisfaction and company revenue.
Certification
- CompTIA Network+ ce
- CompTIA Project+
Languages
English
Native or Bilingual
Spanish
Native or Bilingual
Interests
Crafting and DIY Projects
Video Game Design
Virtual Reality
Augmented Reality (AR) Development
Coding and Programming
Baking and experimenting with recipes
Animal Care
Creating digital artwork using software like Photoshop
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Cslt-Payments
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
CHARLES BEDRANCHARLES BEDRAN
System Engineer at Verizon CommunicationsSystem Engineer at Verizon Communications
LATRISHA GRAYLATRISHA GRAY
VEC Client Executive VCG at Verizon CommunicationsVEC Client Executive VCG at Verizon Communications
Keita KellyKeita Kelly
Associate Director- Training Delivery at Verizon CommunicationsAssociate Director- Training Delivery at Verizon Communications
Keaton GrantKeaton Grant
Bilingual Technical Support Representative at AT&T MobilityBilingual Technical Support Representative at AT&T Mobility
Shawna FernandezShawna Fernandez
Assistant Property Manager at Willow Bridge Property CompanyAssistant Property Manager at Willow Bridge Property Company