Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Andrés Botello

Cash Application Specialist || Cash App || Collections || Python || Power BI
Guadalajara

Summary

Results-oriented Accountant Specialist with a proven track record of managing complex financial operations and driving process improvements. Extensive experience in cash application, collections, reconciliation, and credit risk management across diverse global markets. Demonstrated strong analytical skills, attention to detail, and a commitment to delivering exceptional customer service. Proficient in accounting software (ORACLE NetSuite) (SAP) (M3) (FSM ), financial analysis tools, Python, Advanced Excel, Macros and Power BI.

Overview

8
8
years of professional experience
4
4
years of post-secondary education
3
3
Certifications
2
2
Languages

Work History

Cash Application Specialist

Koch Industries
Zapopan Jal
07.2023 - Current
  • Manage daily cash receipts and customer account applications, ensuring adherence to SLAs
  • Investigate and resolve complex unapplied cash payments
  • Reconcile received vs
  • Applied cash to ensure accuracy and compliance with US GAAP
  • Handle payment variances through ERP system management, including overpayments and chargebacks
  • Implement standardized ERP documentation for unapplied and unassigned payments
  • Design and maintain efficient issue tracking and resolution systems
  • Coordinate month-end close procedures with stakeholders
  • Collaborate with in-market teams for reconciliation
  • Support internal and external audit requirements
  • Developed a macro that significantly improved process efficiency
  • Designed and deployed several dashboards in Power BI, improving reporting accuracy and reducing time spent on manual tasks
  • Enhanced payment tracking systems to provide better visibility and reduce processing times
  • Optimized account reconciliation and discrepancy resolution procedures
  • Created comprehensive SOPs to ensure consistency and facilitate knowledge transfer
  • Led a successful transition of operations from India to Mexico
  • Continuously updated process documentation to reflect best practices
  • Implemented improvements in the cash application process, including enhancing payment tracking, streamlining account reconciliation, and improving discrepancy resolution protocols
  • Took full ownership and optimized the cash application process
  • Ensured alignment with US GAAP principles across all financial operations

OTC Specialist

Wipro
12.2022 - 07.2023
  • Oversee cash application processes for multiple entities across Mexico, Colombia, Ecuador, Peru, and Argentina
  • Perform accurate tax calculations and resolve exchange rate discrepancies
  • Ensure transactions adhere to stringent quality standards and contractual SLAs
  • Provide high-level support and resolution for client inquiries, focusing on customer retention and satisfaction
  • Conduct in-depth analysis of call logs to identify trends and prevent recurring issues
  • Maintain meticulous records of all client interactions and financial transactions
  • Contribute to process improvement initiatives to drive efficiency and enhance service quality

Collections Analyst

Flex
01.2021 - 12.2022
  • Manage past due invoices and conduct financial reconciliations
  • Develop cash flow forecasts and resolve outstanding invoices
  • Implement fraud prevention measures and validate financial information
  • Analyze customer credit limits based on credit scores and financial data
  • Investigate and resolve potential credit fraud independently
  • Negotiate down payments to facilitate purchases exceeding credit limits
  • Resolve payment disputes on delinquent accounts
  • Identify non-payment trends and collaborate with internal partners for resolution
  • Manage dispute resolution processes to ensure satisfactory outcomes
  • Analyze at-risk customers and recommend strategies to prevent delinquencies
  • Conduct thorough financial analyses and provide data-driven recommendations
  • Negotiate effectively with customers and internal teams
  • Identify and mitigate potential financial risks
  • Develop and implement strategic solutions for complex financial issues
  • Maintain positive client relationships while ensuring timely payments

Sr. Accounting Analyst

Panduit
07.2019 - 01.2021
  • Spearheaded senior-level accounting functions, overseeing complex administrative, bookkeeping, and clerical duties to ensure optimal financial performance
  • Processed daily transactions across multiple customer segments and payment types with high accuracy and compliance
  • Resolved complex transactional issues with vendors, customers, and cross-functional departments, ensuring smooth financial operations
  • Conducted comprehensive evaluations of existing processes and implemented innovative solutions to enhance efficiency and productivity
  • Cultivated strong professional relationships across various teams, fostering collaboration and the sharing of best practices
  • Optimized workflow processes to ensure maximum efficiency and effectiveness, contributing to organizational success

Accounting Analyst

Panduit
04.2017 - 07.2019
  • Supports an accounting or transactional process (A/R)
  • This includes preparation, review, and reconciliation of various transactions and/or financial reports in accordance with accounting policies and management direction
  • Responsible for timely completion of required training applicable to the position and regular and effective application of such training in the performance of the position
  • Continually evaluates existing processes and recommends suggestions for improvement that will facilitate business objectives
  • Resolves transactional problems and concerns as they are identified
  • Analyzes financial data and prepares technical reports and forecasts including general and subsidiary ledgers and supporting schedules, current and past financial performance, cash receipts, and disbursements, and capital expenditures and depreciation, among others
  • Improves organizational Business Acumen by consulting, educating, and empowering others, both within and outside of the business, through the application of Financial Best Practices, standardized Work Instructions and process improvements

Education

Bachelor of Business Administration - BBA - Business Administration and Management, General

Universidad Siglo XXI
Guadalajara Jal
01.2017 - 12.2020

Skills

Microsoft Excel proficiency

Cash management

US GAAP

Accounts receivable

Banking experience

Month-end closing

Collections Processing

ERP systems

Teamwork and collaboration

Customer service

Reporting skills

Adaptability and flexibility

Certification

Crash Course on Python

Timeline

Cash Application Specialist

Koch Industries
07.2023 - Current

OTC Specialist

Wipro
12.2022 - 07.2023

Collections Analyst

Flex
01.2021 - 12.2022

Sr. Accounting Analyst

Panduit
07.2019 - 01.2021

Accounting Analyst

Panduit
04.2017 - 07.2019

Bachelor of Business Administration - BBA - Business Administration and Management, General

Universidad Siglo XXI
01.2017 - 12.2020
Crash Course on Python
Foundations in HTML, CSS and JavaScript
Front-End Development with React
Andrés BotelloCash Application Specialist || Cash App || Collections || Python || Power BI