Juan Carlos Solano Cruz
San Jose
Summary
Senior Invoice Reconciliation Analyst with strong expertise in data analysis, process automation, and financial reporting. Experienced in developing dashboards and analytical solutions using Power BI, Looker Studio, SQL, and Excel. Proven ability to improve operational efficiency, reconcile high-volume transactions, and support strategic decision-making in fast-paced multinational environments.
Overview
3
3
years of professional experience
4
4
years of post-secondary education
Work History
SENIOR INVOICE RECONCILIATION ANALYST
Publicis Groupe
San José
05.2022 - Current
- Managed all aspects of invoice reconciliation, focusing on process improvements and resolving discrepancies efficiently.
- Developed and automated detailed reports and workflows to enhance operational efficiency.
- Created Excel reports and dashboards to track and monitor campaigns using formulas such as VLOOKUP, XLOOKUP, and pivot tables.
- Experienced in Excel, with a strong focus on optimizing workflows through the use of Macros and Queries to automate tasks and streamline data analysis.
- Provided support to the investment team for comprehensive order tracking.
- Liaised with agency support services and vendors to resolve media billing issues effectively.
- Identified and reconciled discrepant invoices.
- Proficient in developing data visualizations and dashboards to support strategic decision-making using tools like Power BI and Google Looker Studio.
- Trained new hires, enhancing their onboarding experience and improving overall team performance.
- Demonstrated the ability to handle invoices efficiently, meet deadlines, and collaborate effectively within team environments.
- Strong vendor communication skills, facilitating effective collaboration and supporting vendor compliance processes.
- Proficient in Microsoft SharePoint, with experience in creating and managing SharePoint sites to enhance training programs and streamline operations tracking.
Fraud Verification Specialist
Sykes, Capital One Bank
01.2021 - 02.2022
- Investigated and resolved fraudulent activities impacting cardholders' accounts, including charges, payments, and financial transactions. Developed solutions to reconcile customer needs with company objectives.
- Provided exceptional customer service during high-stress situations via phone and email, ensuring maximum customer satisfaction.
- Maintained attention to detail in verifying the legitimacy of transactions, managing the process from claim receipt to resolution and closure, while following compliance guidelines.
- Prioritized tasks effectively in a fast-paced environment, demonstrating strong time management and organizational skills.
- Trained new hires in communication skills, handling difficult customers, and using call center software systems to assist clients and partners.
Education
BUSINESS ADMINISTRATION - Administración de Empresas
Universidad San Marcos
04.2022 - Current
POWER BI - undefined
UDEMY
01.2024
Google Looker Studio - undefined
UDEMY
01.2023
Google Data Analytics Professional Certificate - undefined
Coursera Google Career Certificates
01.2025
SQL Data Analytics with Tableau Data Visualisation - undefined
UDEMY
01.2025
Assess for Success: Marketing Analytics and Measurement - undefined
Coursera Google Career Certificates
01.2025
Skills
- Google Looker studio
- SQL
- Python
- Tableau
- Power BI
- Excel
- Pivot tables
- Macros
- Advanced formulas
- Power Point
- Word
- Share point
- Outlook
- Power automate
- Social Media Strategy
- Campaign Management
- Content Creation
- Customer Satisfaction Expertise
- Time Management
- IPS
- JIRA
- Box
- Google Payment Center
- Prisma
- MBOX
- Google Analytics
- Data interpretation
- SEO
- SEM
- Google Ads
- Content planning
- Optimization
Languages
English
Spanish
Timeline
SENIOR INVOICE RECONCILIATION ANALYST
Publicis Groupe
05.2022 - Current
BUSINESS ADMINISTRATION - Administración de Empresas
Universidad San Marcos
04.2022 - Current
Fraud Verification Specialist
Sykes, Capital One Bank
01.2021 - 02.2022
POWER BI - undefined
UDEMY
Google Looker Studio - undefined
UDEMY
Google Data Analytics Professional Certificate - undefined
Coursera Google Career Certificates
SQL Data Analytics with Tableau Data Visualisation - undefined
UDEMY
Assess for Success: Marketing Analytics and Measurement - undefined
Coursera Google Career Certificates