MS Office
Juan Pablo Cano
Professional In Finance
Summary
An EAFIT University graduate with bachelor’s degree in finance.
Highly motivated and goal-driven Financial Analyst skilled in collecting, monitoring, and analyzing data to assess financial status.
Experienced in qualitative and quantitative analysis, Financial Analysis, forecasting, and passionate about investments. With a strong interest in further exploring foreign exchange markets and financial ratios. Proven track record of successfully conducting financial valuations and evaluations using spreadsheets, accounting and financial management software, as well as finance tools such as Excel, Power BI, Tableau, and others. Proficient in developing scenarios and strategies for financial projects, with a demonstrated ability to make prompt and well-calculated decisions. I enjoy staying updated on the most recent trends and advancements in the field of economics.
Overview
3
3
years of professional experience
5
5
years of post-secondary education
1
1
Certification
2
2
Languages
Work History
Export Coordinator & Financial Analyst
Sumitrade
Envigado
07.2022 - 06.2023
- Produced comprehensive financial reports and summaries for senior management, highlighting the status of accounts integral to the company's working capital.
- Engaged in active negotiation and continuous monitoring of exchange rates with banking partners to secure optimal rates in alignment with prior analyses.
- Managed inventory control procedures using the CPP method to ensure efficient inventory management, optimizing resource allocation.
- Supervised cash distribution operations, ensuring that funds were allocated in accordance with established protocols and requirements.
- Supplier Relations and Management
- Developed projections for export settlements and assessed the profitability of each, incorporating royalties and direct sales costs to enhance financial planning accuracy.
- Designed simulation models for senior management, enabling accurate predictions of export profitability, factoring in royalties and other direct sales costs, thereby improving financial planning precision.
- Monitored daily fluctuations in platinum, gold, and USD/COP prices, generating insightful reports detailing price movements across various contextual scenarios.
- Conducted meticulous bank reconciliations in collaboration with the accounting department, ensuring accuracy and compliance.
- Conducted meticulous bank reconciliations in collaboration with the accounting department, ensuring accuracy and compliance.
PayGo Specialist
Solvo Global S.A.S
Medellín
11.2020 - 06.2022
- Followed all company policies and procedures to deliver quality work.
- Listened and responded to customer requests and forwarded necessary information to superiors.
- Constructed reports for various clients of the company (data entry) based on each client's payment to their employees during a specific work period, taking into account hours worked and the assigned rate for each employee as per client criteria.
- Reconciled invoices submitted by clients to ensure they align with the totals from the aforementioned reports.
- Identified and analyzed any discrepancies, determining whether there were differences or not.
- Prepared manual invoices for clients to pay any unreported amounts or receive any excess amounts reported.
- During this role, I also managed databases and utilized various Excel tools to streamline and enhance these processes on a daily basis.
Finance Trainee
Cryogas S.A
Medellín
08.2018 - 02.2019
- Sales Reporting Oversight
- Effectively managed sales database, overseeing data entry, maintenance, and quality control to ensure integrity and reliability of critical sales information
- Inventory Level Monitoring
- Analyzed financial data and presented meaningful insights to senior management.
- Submitted monthly DANE survey to notify sales and production levels
- Monitored expenditure distribution
- Developed sale’s close model by product, explaining the most important variations
- Monitored and analyzed the most representative clients for the company by sales concept
- Simplified and dynamized profit and financial control reports by development of a financial analysis model trough dynamic tables by client and product
Education
Bachelor Degree - Finance
EAFIT University
Medellín, Colombia 01.2014 - 06.2019
Skills
MS Office
undefinedSoftware
Trading View
Power Pivot
Power BI
Power Query
SIIGO
Tableau
Certification
Macros associated to Excel
Timeline
Export Coordinator & Financial Analyst
Sumitrade
07.2022 - 06.2023
PayGo Specialist
Solvo Global S.A.S
11.2020 - 06.2022
Macros associated to Excel
10-2019
Finance Trainee
Cryogas S.A
08.2018 - 02.2019
Bachelor Degree - Finance
EAFIT University
01.2014 - 06.2019
Similar Profiles
Shubham KargetiShubham Kargeti
Export Coordinator & Export Sales at Mesbor Private LimitedExport Coordinator & Export Sales at Mesbor Private Limited
Andrea RawlsAndrea Rawls
Program Coordinator/Financial Analyst at AmentumProgram Coordinator/Financial Analyst at Amentum
Robin BumphreyRobin Bumphrey
Financial Analyst Coordinator at MercyHealthFinancial Analyst Coordinator at MercyHealth