Summary
Overview
Work History
Education
Skills
References
Timeline
Generic
Carolina Calderón

Carolina Calderón

Business Intelligence| Sales Force Effectiveness| Business Analyst| CRM| VEEVA| SISPRO| FP&A
Bogotá,DC

Summary

BI leader with more than 15 years of experience in the pharmaceutical sector. Experience in coordinating business intelligence projects for the NOLA and Mexico regions, generating insights for the optimization of commercial management and market access; experience in implementation and administration of CRMs to ensure the sales force's effectiveness in its processes and interaction with its customers. Management of tools such as IQVIA, Close Up, Veeva, Sales Forces, SISPRO Cubes (Sismed, Mipres, Rips), Excel, Power BI and SAP. Some of the skills are the ability to analyze, results-oriented, effective communication, and teamwork. Passionate about the use of data to generate value and solutions that contribute to the development and growth of the company.

Overview

15
15
years of professional experience
9
9
years of post-secondary education
3
3
Languages

Work History

Associate Manager Business Intelligence

Knight Therapeutics
09.2019 - 03.2024
  • Analyzing customer and market data to identify trends, preferences, and behavior patterns.
  • Manage and maintain Veeva CRM databases, ensuring data accuracy and integrity.
  • Collaborate with cross-functional teams to define key performance metrics and KPIs for sales initiatives.
  • Collaborate with sales teams to provide training, support, and guidance on CRM usage and best practices.
  • Extraction and transformation of data from SISPRO Cubes for analysis and internal reports, as well as the monthly SISMED price report to the Ministry of Health

Achievements:

  • Automated reporting across the dashboard for optimal visualization of results and market behavior.
  • Implemented the segmentation and targeting project by potential and adoption of the medical panel
  • Generate standardized reports and dashboards to track key performance indicators (KPIs) and measure the effectiveness of sales initiatives for Mexico, Colombia, Peru y Ecuador.

Commercial Analyst

Knight Therapeutics
03.2019 - 09.2019
  • Analyze sales data and trends to identify opportunities for revenue growth and improvement in sales processes.
  • Develop and maintain sales dashboards and reports to track performance against targets and goals.
  • Improved demand forecast for multiple distribution channels based on previous sales and consumption.

Achievements:

  • Participated in sales and operations meetings to assess performance and forecast and formulate necessary corrective actions, decrease back order by 90%.
  • Generated daily reports of sales performance

Controlling Analyst

Sanofi Colombia
02.2015 - 01.2018
  • Responsible for closing for sales, headcount, P&L, data quality in systems with adequate controls in place.
  • Ensure business reports are created on-time and with accuracy, in compliance with the reporting calendar issued by Corporate;
  • Operate as the interface between local finance team and Global BA&C team in the communication of detailed guidelines, key milestones and the launch of budget and forecasting cycle for local finance and business teams
  • Coordinate with Business managers the cost forecast: run of scenarios based on Global guidelines and ambitions, prepare the reviews with regional finance teams, ensure consistency of information and data, identify risks and opportunities
  • Product Master Database Administration.
  • Provide ad-hoc analysis, leveraging finance network and available information.

Achievements:

  • Automation of reports achieving optimization of times in generating them and meeting deadlines.

Marketing Assistant

Sanofi Colombia
05.2014 - 02.2015
  • Analyzed sales data to forecast future demand trends accurately, aiding in efficient inventory planning decisions.
  • Facilitated promotional events to increase product visibility and attract potential customers.
  • Worked closely with shift manager to solve problems and handle customer concerns.
  • Collaborated with cross-functional teams to ensure smooth execution of marketing campaigns and initiatives.
  • Maintained strong vendor relations to effectively handle challenging events demands.
  • Coordinated with coworkers to help customers, achieving efficient operations and high customer satisfaction.

Marketing Analyst

Grupo Unipharm S.A
03.2013 - 05.2014
  • Analyzed third-party data and investigated new growth opportunities.
  • Initiated market research studies and analyzed findings.
  • Implemented data cleansing processes to maintain high-quality records within databases.
  • Distribution and control of medical samples and promotional material

Achievements:

  • Structured and developed the market intelligence area.


Market Analyst

Laboratorios Synthesis
08.2009 - 02.2013
  • Analyzed data to uncover insights and identify key opportunities to inform strategic decisions.
  • Supported sales team by providing actionable intelligence on target markets and potential clients.
  • Used various market research tools to gather, analyze and interpret data.
  • Tracked key performance indicators to measure success of campaigns.
  • Participated in team projects, demonstrating an ability to work collaboratively and effectively.

Achievements:

  • Assisted in the design of user-friendly front-end interfaces for database management systems.

Education

Master en Business Intelligence - Data Management

OBS Business School
Barcelona, España
05.2022 - 07.2023

Diplomado en Estrategias de Marketing y Canales Digitales -

Pontificia Universidad Javeriana
Bogotá, Colombia
02.2019 - 04.2019

Curso de inmersión en inglés - Idiomas

EC, Toronto
Toronto, Canadá
04.2018 - 09.2018

Especialización en Gerencia de Mercadeo -

Universidad Jorge Tadeo Lozano
Bogotá, Colombia
02.2013 - 04.2014

Administración de Empresas - Business Administration

Universidad Cooperativa De Colombia
Bogotá, Colombia
02.2007 - 05.2013

Skills

  • Excellent Communication

  • MS Office

  • Time Management

  • Problem-solving aptitude

  • Sales Reporting

  • Teamwork and Collaboration

  • Adaptability and flexibility to handle changing priorities

  • Compliance understanding

  • Analytical Skills

  • Customer Relationship Management (CRM)

  • Team Collaboration

References

  • Yudislay Escarpeta Guevara, Promotional Manager, Biosidus, 301 527 14 68
  • Johana Rodriguez Jauregui, Product Specialist, Knight T., 315 356 16 18

Timeline

Master en Business Intelligence - Data Management

OBS Business School
05.2022 - 07.2023

Associate Manager Business Intelligence

Knight Therapeutics
09.2019 - 03.2024

Commercial Analyst

Knight Therapeutics
03.2019 - 09.2019

Diplomado en Estrategias de Marketing y Canales Digitales -

Pontificia Universidad Javeriana
02.2019 - 04.2019

Curso de inmersión en inglés - Idiomas

EC, Toronto
04.2018 - 09.2018

Controlling Analyst

Sanofi Colombia
02.2015 - 01.2018

Marketing Assistant

Sanofi Colombia
05.2014 - 02.2015

Marketing Analyst

Grupo Unipharm S.A
03.2013 - 05.2014

Especialización en Gerencia de Mercadeo -

Universidad Jorge Tadeo Lozano
02.2013 - 04.2014

Market Analyst

Laboratorios Synthesis
08.2009 - 02.2013

Administración de Empresas - Business Administration

Universidad Cooperativa De Colombia
02.2007 - 05.2013
Carolina CalderónBusiness Intelligence| Sales Force Effectiveness| Business Analyst| CRM| VEEVA| SISPRO| FP&A