Ivan Abreu Coelho Email & Phone Number

Lisbon, Pt

Lisbon, Portugal

• Market Analysis combining development of data models with creation and evaluation of KPIs, in diverse therapeutic areas and brands, searching to help the business with impactful recommendations and strategic decision-making;• Bridging IT and business needs, translating business requirements into technical solutions, aligning IT processes with business goals;• Proficient in sales forecasting, setting sales objectives, and design sales incentives;• Analysis and validation for Budget and Last Estimates (Sales Projection) for sales volume and revenue values, working closely with Finance department;• Development and analysis of Patient Models to support Budget and Last Estimates;• Lead market research projects, translating findings into actionable insights;• Implementation of a suite of advanced analytics dashboards with Tableau platform, which enabled the business to gain insights into sales trends, sales vs target, competitors, among others;

Oeiras, Lisbon, Portugal

• Key user for the CRM platform (Veeva), with proper Field Force Restructurings, Module Improvements, UATs and responsible as the Business Solutions Lead for the region (13 countries);• Project Management of diverse market research and patient modeling projects, using IQVIA or HMR data sources, which one in particular was for a European unique Patient Pathway tool that included the join of two very large databases and the development of a Tableau Dashboard to provide insights and understanding of pharma healthcare across all stages of a patient path for Oncology;• Development of Objectives KPIs, Incentives Models and Forecasting for the sales team;• Development of Customer Segmentation Models according with business needs;• Actively working with the BU Leads and Head of Sales and Marketing towards easily translation of the complex initiatives into action plans and sequence priority;• Multichannel Marketing Projects including Remote Meetings initiatives, National Linked In, National Campaigns, Owned Healthcare Portal, Webinars, among others;• Member and key role of the Global CDMS Project towards the creation of an owned Data Warehouse and BI tool in Qlikview;• Cross-functional functions involving all the departments from Senior Management to Field Sales Reps;

Oeiras, Lisbon, Portugal

• Integration of annual Commercial Policy design and guidelines into analytical models to calculate bonuses and rappels for eligible accounts;• Data Integration: Combining sales data (Sell In, Sell Out) with performance metrics (Net Sales / Gross to Net / Gross Margin) to create a comprehensive view of customer sales performance;• Data Analysis: Analyzing the integrated data to identify trends, patterns, and areas for improvement;• Configuration and Customization: Key User for the CRM tool (Veeva), coordinating Field Force Restructuring, Business Validation, UATs, Deployments and User Training;• Work extracting, transforming, and analyzing large datasets in Excel;• Implementation of Customer Segmentation Models according with business needs;• Development of advanced analytics and reports with Excel and Spotfire;• Actively working with the BU Leads towards easily translation of the complex initiatives into action plans and sequence priority;• Leadership for the launch and management of the Multichannel Marketing tool (Marketing Cloud Salesforce Solution) working closely with the Marketing Manager.

Lisboa E Região, Portugal

Project: Business Intelligence at TAP• Gathering and understanding the business needs and requirements from the Finance Department;• Bridging IT and business needs, translating business requirements into technical solutions, aligning IT processes with business goals;• Build of analytical models to enrich digital Profit and Loss Statement of the company, including diverse financial and economical KPIs, indicators and ratios;• Development of advanced and complex algorithm to prorate costs according with business rules;• Software developments and algorithms in SQL, Integration Services and Analysis Services;• Actively working with the BU Finance Lead towards an easily translation of the complex initiatives into action plans and priority sequence;• Developments implemented according with Agile methodologies.

Lisboa E Região, Portugal

Project: Business Intelligence at Cimpor - Cimentos de Portugal• Gathering and understanding the business needs and requirements from the users (Department of Finance and Department of Engineering);• Bridging IT and business needs, translating business requirements into technical solutions, aligning IT processes with business goals;• Build of analytical models and software developments in SQL;• Responsibility to produce diverse Dashboards in Qlikview, within a Benchmark KPIs perspective for the different countries where the client was operating (13 countries);• Actively working with the BU Leads towards an easily translation of the complex initiatives into action plans and priority sequence;

Porto Salvo

• Played a key role in the international ECMS (Enterprise Customer Management System) project, a CRM tool built on the Siebel 7.7 platform.• Provided support for the Marketing and Sales areas as the manager of ECMS.• Led tool development and implementation, participated in UATs (User Acceptance Testing) for new features or optimizations, and validated these features.• Produced activity data reports in coordination with Business Units.• Developed and deployed several realignments of structures, territories, segmentations, and products to ensure alignment between business needs and application features, enhancing sales force effectiveness.

Post-Graduate Course, Information Management And Business Intelligence

This course was awarded for the 6th time as the best master course in the world, in Business Intelligence and Strategy, by Eduniversal.

Bachelor Of Applied Science - Basc, Information Management

Study Programme: Business Management and Accounting Economic Analysis Microeconomics Macroeconomics Data Mining Computing Systems Analysis.

Education record