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

Financial statement analysis

Data analytics

Industry research

Transfer pricing methodologies

Problem-solving

Time management

Multitasking Abilities

Excellent communication

Team building

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