Francisco Calderón
Lima
Summary
Analytical professional with technical knowledge and critical thinking skills to thrive in data-driven environments. Tackles challenges with positivity and drive to overcome. Works great alone or with others and consistently exceeds expectations.
Overview
10
10
years of professional experience
3
3
Languages
Work History
Business Intelligence Leader
INTERNATIONAL MEDIA GROUP
05.2023 - Current
- I implemented automated Commercial, Financial, Operational and Quality reports using Power BI.
- I implemented a Business Intelligence Sharepoint where all the dashboards links are located. This helps different areas to find all the information in only one place.
- I successfully led the Salesforce implementation process, ensuring a smooth and efficient transition to this new CRM platform.
- I successfully integrated HubSpot with Salesforce making a smooth leads flow.
Analytical Lead
ATLANTIC CITY
07.2021 - 05.2023
- I implemented the Turbo Tournament which had a ROI of 7.40 after applying A//B testing. Also, the average CIS and the number of bets increased.
- I implemented the logic of the Sportsbook Bonus for Sports Betting.
- I Implemented the Mystery Chest promotion to recover passive customers and register them in the Online Casino.
- I developed a Power BI dashboard to control the Promotional Expenses.
- I developed a sensitivity model to have personalized promotions for each guest and the promotional budget was optimized by 20%.
CommEx Analyst, Hispanic Cluster
ALCON
06.2020 - 07.2021
- I implemented DDD and PM reports in Tableau for Mexico, Chile, Argentina and Colombia.
- I implemented the segmentation model in Surgical (Sx) and Vision Care (VC) in Andean Cluster, also I helped to implement the segmentation model in Mexico (Sx and VC) and Argentina (Sx and VC).
- I leveraged global analytics by promoting Einstein Analytics and Tableau usage.
- I supported the Automation Manager in the Mexico VC incentives calculation by standardizing the DDD report.
- I collaborated with franchise leaders and marketing to support the following product launches: Vivity and iLux.
Business Intelligence Coordinator Peru & Ecuador
ALCON
09.2018 - 05.2020
- As a regional project, I implemented the Mexico's DDD, PM (PMM + PMCH) and Prescriptions reports in Tableau.
- I homologated the DDD, PM and Sell Out reports of Peru and Ecuador with the Andean Cluster template.
- I launched the Physician Prescriptions report where a physician's segmentation was used. Then, I trained the Peruvian and Ecuadorian reps so they could use this report to optimize their calls.
- I implemented sales reports in Tableau and trained the commercial area in the correct use of this tool.
- I implemented a Business Intelligence Sharepoint for PEEC where the DDD, PM, Prescriptions, Imports reports and Tableau links are located. This helped the commercial area to find all the information in only one place.
- I implemented imports reports of contact lenses, intraocular lenses and viscoelastics in Tableau and trained the commercial area in the correct use of this tool.
Business Intelligence Analyst
JOHNSON & JONHSON
02.2017 - 09.2018
- I implemented a new template to calculate the incentives, this reduced the calculation time from 2 hours to only 15 minutes.
- I improved the Rebates process, now lasts only 2 hours and the ratio of compliance of the provision vs the actual expense is 90%.
- I implemented a new budget control template for the third sales force that allowed me to find S/ 92,184 that were used in Trade Marketing strategies.
- I implemented two sales status reports: 'DOI Report for Peru channels' and 'DOI Report for Peru brands'.
- I participated in the implementation of sales reports in Tableau and trained the commercial area in the correct use of this tool.
Business Development Analyst
TEVA PERU
07.2014 - 02.2017
- I coordinated the supply of CROVAST (rosuvastatin), EFICAERO (fluticasone/ salmeterol), ELEGYA (pregabalin), LIPIBEC (atorvastatin) and PROLIDE (escitalopram oxalate) for their launch in the Peruvian market.
- I updated the pipeline of the products that will be launched in the next five years.
- I elaborated the methodology for the selection of new products.
- I analyzed the Peruvian pharmaceutical market to find new launch opportunities that complement the Teva Peru portfolio.
- I managed the Teva Peru Rx portfolio, analyzing the product life cycle, profit, market share and other variables. And I kept updated the Master Product List.
- I elaborated and presented business cases for new products, considering a profit higher than 80%.
- I provided updated information to the Business Units about the status of the products launched during the year, thus, they could make action plans in case of delay.
Junior Consultant
TSnet S.A.
Lima, Peru
02.2014 - 07.2014
- I developed user guides for the modules General Ledger, Fixed Assets, Accounts Payables, Inventory, Purchasing, Human Resources and Budget.
- I conducted tests of reports in Oracle E-Business Suite R12 and Discoverer 11g in order to know if they worked properly.
Education
Digital Marketing Analyst, Marketing Basics & Media, Facebook Ads Manager, Google Analytics & Ads, Business Case -
Universidad de 'Ciencias y Artes de América Latina - UCAL'
08.2022
Master of Science - Marketing
ESIC Business & Marketing School
Spain12-2021
Master of Science in Marketing -
Esan Graduate School of Business
12.2021
Semi-Distance Program: Leadership in the Digital Era, Management of virtual teams, Leading agile organizations, Digital communication, Coaching in the digital era -
Universidad de Ingeniería & Tecnología - UTEC
05.2019
Diploma course in Business Intelligence, Business information analysis with Power BI for Excel, Interactive business information analysis with Power BI, Big Data -
Cibertec (Lima - Peru)
03.2019
Certified Marketing Analytics Professional, Visual Analytics, Machine Learning, Big Data applied to Marketing -
BS Grupo (Lima - Peru)
12.2017
Master of Science in Statistics, Computational Statistics, Data Mining, Linear Models, Risk Analysis, Time Series -
Pontifical Catholic University of Peru
12.2015
Graduate Industrial Engineer, Planning and control of operations, Industrial Finance, Marketing -
Pontifical Catholic University of Peru
12.2013
Skills
- Data Analytics
- CRM management
- Data-driven decision making
- Reports and Dashboard creation
- KPI management
- Market and campaign analysis
- Digital marketing
- Marketing automation
- Market research
- Teamwork and Collaboration
- Adaptability
- Problem-Solving
Languages
Spanish
First Language
English
Proficient (C2)
C2
French
Intermediate (B1)
B1
Software
Microsoft SQL Server
Salesforce
HubSpot
Tableau
PowerBI
Microsoft Excel
Power Apps
Power Automate
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Business Intelligence Leader
INTERNATIONAL MEDIA GROUP
05.2023 - Current
Analytical Lead
ATLANTIC CITY
07.2021 - 05.2023
CommEx Analyst, Hispanic Cluster
ALCON
06.2020 - 07.2021
Business Intelligence Coordinator Peru & Ecuador
ALCON
09.2018 - 05.2020
Business Intelligence Analyst
JOHNSON & JONHSON
02.2017 - 09.2018
Business Development Analyst
TEVA PERU
07.2014 - 02.2017
Junior Consultant
TSnet S.A.
02.2014 - 07.2014
Digital Marketing Analyst, Marketing Basics & Media, Facebook Ads Manager, Google Analytics & Ads, Business Case -
Universidad de 'Ciencias y Artes de América Latina - UCAL'
Master of Science - Marketing
ESIC Business & Marketing School
Master of Science in Marketing -
Esan Graduate School of Business
Semi-Distance Program: Leadership in the Digital Era, Management of virtual teams, Leading agile organizations, Digital communication, Coaching in the digital era -
Universidad de Ingeniería & Tecnología - UTEC
Diploma course in Business Intelligence, Business information analysis with Power BI for Excel, Interactive business information analysis with Power BI, Big Data -
Cibertec (Lima - Peru)
Certified Marketing Analytics Professional, Visual Analytics, Machine Learning, Big Data applied to Marketing -
BS Grupo (Lima - Peru)
Master of Science in Statistics, Computational Statistics, Data Mining, Linear Models, Risk Analysis, Time Series -
Pontifical Catholic University of Peru
Graduate Industrial Engineer, Planning and control of operations, Industrial Finance, Marketing -
Pontifical Catholic University of Peru
Similar Profiles
Nick LucianoNick Luciano
VP Sales and Marketing at AMC Media Group/Mashup MediaVP Sales and Marketing at AMC Media Group/Mashup Media
Sahil VermaSahil Verma
Associate Director at PHD Media - Omnicom Media GroupAssociate Director at PHD Media - Omnicom Media Group
Violetta YemelyanovaVioletta Yemelyanova
Head of Corporate Sales at Open Media Group (Digital Media)Head of Corporate Sales at Open Media Group (Digital Media)