Summary
Overview
Work History
Education
Skills
Software
Interests
Timeline
Generic

JUAN SEBASTIÁN INSIGNARES

Finance And International Relations Professional
Bogotá

Summary

Strategic and results-driven finance professional with extensive experience in consulting, analytics, and transfer pricing across diverse industries. Proven track record of delivering data-driven insights and innovative solutions that drive operational efficiency, optimize compliance, and enhance profitability.

Overview

5
5
years of professional experience
2
2
Languages

Work History

Transfer Pricing Associate

Ernst & Young
01.2023 - Current

A senior associate specializing in complex cross-border transactions, intercompany agreements, and dispute resolution, with a proven ability to enhance tax efficiency and mitigate transfer pricing (TP) risks. Key contributions include:

  • Preparing and reviewing financial valuations for intercompany acquisitions.
  • Restructuring financial operations and derivatives to comply with the Arm’s Length principle.
  • Assessing company credit ratings using third-party tools when explicit ratings are unavailable.
  • Pricing financial transactions, including loans, currency contracts (spot & forward), and commodity hedges.
  • Ensuring TP compliance through the preparation of local and global documentation, benchmarks, functional and risk profiles, financial analyses, Master files, and Country-by-Country reports.
  • Providing TP advisory and planning services by designing complex intercompany transactions, creating segmentation manuals for multinational groups, and delivering training presentations for MNE teams.
  • Managing TP controversies by preparing documentation for tax authorities, reviewing contentious responses, and monitoring disputes.
  • Overseeing administrative tasks, including coordinating regional teams, conducting status reviews, managing team assignments, and providing training to junior consultants.
  • Leading a team of tree consultants, delivering onboarding and training in transfer pricing responsibilities.

Product Analyst

Tangelo
05.2022 - 03.2023
  • Conducted comprehensive market research for better understanding of industry trends and competitor offerings.
  • Facilitated communication between technical and non-technical stakeholders, ensuring clear understanding of project requirements and expectations..
  • Increased customer satisfaction with thorough quality assurance testing, addressing and resolving issues promptly.
  • Collaborated with internal team members and customer representatives to clarify relationship of business and project goals and obtain enhanced perspective of development process.

Transfer Pricing Consultant

Ernst & Young
01.2020 - 05.2022

Results-Driven TP Consultant adept at leveraging specialized software to conduct thorough analyses and produce high-quality documentation. Proven ability to navigate complex transfer pricing regulations.

  • Handle TP compliance and validate the status of TP documentation.
  • Review and prepare benchmarks, and financial analysis (theoretical, segmented, etc.)
  • Prepare interview guides to facilitate the understanding the profile of functions, assets, risks of multinational enterprise groups, the organizations of regional teams in the process of preparing TP documentation.
  • Prepare Master file, Country by Country, and permanent establishment reports. • Prepare interview guides to facilitate the apprehension of the flow of goods and/or services related to TP.
  • Facilitate meetings with clients to understand intercompany (TP) business processes.
  • Review of controversial responses prepared by local Teams in cases between the tax authority and multinational groups.

Financial Analyst

Vigía Servicio Especial
01.2021 - 05.2021
  • Improved financial forecast accuracy by implementing new, dynamic modeling tool.
  • Supported strategic decision-making with in-depth market trend analysis.
  • Streamlined financial reporting processes, significantly reducing time required for monthly close.
  • Conducted detailed financial analysis to identify and evaluate changes in operations, trends and potential areas of improvement.

Education

Finance And International Relations

Universidad Externado De Colombia
Bogota
05.2001 -

High School Diploma -

Liceo De Cervantes Norte
Bogota
05.2001 -

Skills

Microsoft Excel proficiency

Software

Thomson Reuters

Jira Software

Bloomberg

Moodys Credit Rating

Capital IQ

Office Tools

Interests

Running

Movies

Gym

Music

Timeline

Transfer Pricing Associate

Ernst & Young
01.2023 - Current

Product Analyst

Tangelo
05.2022 - 03.2023

Financial Analyst

Vigía Servicio Especial
01.2021 - 05.2021

Transfer Pricing Consultant

Ernst & Young
01.2020 - 05.2022

Finance And International Relations

Universidad Externado De Colombia
05.2001 -

High School Diploma -

Liceo De Cervantes Norte
05.2001 -
JUAN SEBASTIÁN INSIGNARESFinance And International Relations Professional