Francisco Calderon

Experience

• 

  Vistony S.A.C

  Jan 2011 - Mar 2011

  Production Assistant

  I measured the time of the product elaboration processes, it allowed me to identify problems and introduce some improvements in order to care for the production parameters. I worked on the Implementation of the “5S” Program, in order to have an organized and much cleaner place to work.I supervised the ISO 9001 system operation. Through this activity I knew how a company with ISO 9001 works; furthermore, I learnt how to submit documentation under this system.Achievements:-After making an analysis of time in the production line, the filling process was automatized; therefore, the elaboration time was reduced by 30%. -After implementing the 5S program, the number of accidents was reduced by 40%. Show less

• 

  Merck Group

  Apr 2012 - Dec 2012

  Processes and Quality Trainee

  I collected information to build the processes, thus, I had to interview the heads of each processes and observe how they did their activities; moreover, I elaborated documents following a corporate format. I made flowcharts that allowed me to do better monitoring to all the operations in each procedure.I kept the order of the documentary system of The Quality Management System. I updated the versions of the procedures through the use of the intranet and a system of enterprise content management called "Alfresco".I participated in an internal audit in the areas of Marketing, Treasury, Credit and Collection Department, which allowed me to learn more about the procedures of these areas and the roles of an internal auditor.Achievements:-I updated and loaded all the procedures in the “Alfresco” system. -I designed a system in Excel, in order to identify which areas needed to be audited. -After conducting the internal audit, it was possible to close all observations and nonconformities. Show less

• 

  Banco Central de Reserva del Perú

  Jul 2013 - Dec 2013

  Trainee in Logistics

  Achievements:-I automated the record of customer satisfaction surveys, thus, the time invested in calculating the quality indicators decreased by 50%.-I managed to reduce the time of supply of the goods and services by 20% because I made a fast coordination with suppliers.Functions:I calculated process performance indicators,made surveys and wrote reports of customer satisfaction.I proposed improvements that allowed adequate control of the quality of the service.I participated in the ISO 9001:2008 audit to obtain the Recertification.I realized market researches to evaluate suppliers of goods that the bank requested. It allowed me to understand how the logistics area of a government institution works. Show less

• 

  TSnet S.A.

  Feb 2014 - Jul 2014

  Junior Consultant

  Achievements:-I elaborated and delivered all user manuals by the deadline.-I elaborated and delivered all the test cases of the modules by the deadline.Functions:Project Upgrade ERP Oracle E-Business Suite 11i to R12 - Banco de la NaciónI 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. Show less

• 

  Pontificia Universidad Católica del Perú

  Mar 2014 - Dec 2019

  Assistant Professor

  Assistant professor of Integral Quality Control course (March 2014 - July 2018, August - December 2019)Assistant professor of Integral Quality Control laboratory (March 2016 - December 2017)Assistant professor of Statistics for Engineers (March 2017 - December 2018)

• 

  Teva Pharmaceuticals

  Jul 2014 - Feb 2017

  Business Development Analyst

  Achievements:- I coordinated the supply of CROVAST (rosuvastatin), EFICAERO (fluticasone/ salmeterol), ELEGYA (pregabalin), LIPIBEC (atorvastatin), ARIALE (sertraline Hcl) 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.Functions:I analyzed the Peruvian pharmaceutical market to find new launch opportunities that complement the Teva Peru portfolio.I managed the Teva Peru Rx portfolio, analysing the product life cycle, profit, market share and other variables.I elaborated and presented business cases for new products, considering a profit higher than 80%. I kept updated the Master Product List, including cost information, sales and volumes.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. Show less

• 

  Johnson & Johnson

  Feb 2017 - Sept 2018

  Business Intelligence Analyst

  Achievements:- 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 implemented sales reports in Tableau and trained the commercial area in the correct use of this tool.- I participated in the CIW project in SAP, where I verified that the load flow of prices and discounts was carried out correctly.-I led the roll out and communication of the Safety Month in April 2018. Around 90% of the employees participated in the organized activities.Functions:I calculated the Rebate payment of the customers from the Traditional and Pharma Channel.I controlled the budget of the 3rd party salesforce (merchants and promoters) with the objective of optimize resources.I elaborated standardized reports of Sell Out, Sell In and DOI daily, monthly and quarterly.I participated in the S&OP meetings where I analyzed the sales reports and proposed adjustments to monthly sales targets.I was Tableau Desktop Key User, this tool allowed me to review the daily Sell Out and Sell In.I was SAP Key User for the Pricing, Discounts, Master of Products and Master of Customers Modules.I calculated the payment of incentives of the sales executives from the Traditional, Pharma and Modern channels. Show less

• 

  Alcon

  Sept 2018 - Jul 2021

  Achievements:- 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: Present the imports report so they can know how competitors are performing in the market.*iLux: Collaborated with the iLux rep when it was in the promotional portfolio Functions:-Proactively support FML and sales reps with training and engagement on core CommEx platforms (i.e. Salesforce.com, Pitcher, Marketing Cloud and Einstein Analytics) to COUNTRY/ CLUSTER to maximize impact of local commercial execution.- Elaborate the monthly DDD and PM reports for Peru, Ecuador, Colombia, Chile, Argentina and Mexico with the IQVIA data. Also, analyse the tendencies of the Alcon products by country, region, brick and relevant market.- Identify local data-intensive processes, prioritize them, and automate with CommEx technologies.- Manage Salesforce instance for the Andean Cluster (Peru, Ecuador and Colombia).- Calculate the Sell In and Sell Out targets for Vision Care and Surgical in the Andean Cluster.- Participate in field rides and participate in the local business review meetings. Show less Achievements:- 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. This helped to reduce the reports elaboration time from 3 hours to 1 hour.- I implemented a Business Intelligence Sharepoint for PEEC where the DDD, PM, Prescriptions, Imports reports and Tableau links are located. This helps 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. This helped to know which competitors had entered to the market.Functions:- I elaborated the monthly DDD and PM reports for Peru and Ecuador with the IMS data. Also, I analysed the tendencies of the Alcon products by country, region, brick and relevant market.- I elaborated the monthly Sell Out report for Peru and Ecuador. I analysed the achievement of the monthly and YTD targets, the variations of sales per month and YTD.- I elaborated and proposed the Market Share and Sell Out monthly targets for the Vision Care Business Unit.- I elaborated the monthly Physician Prescriptions report with the Close-Up data. Also, I categorized the physicians so the reps could know who they must visit to increase the prescriptions market share.- I elaborated the surgeries market report with information provided by the medical sales reps. Show less

  • Commex Analyst, Hispanic Cluster

    Jun 2020 - Jul 2021

  • Business Intelligence Coordinator Peru & Ecuador

    Sept 2018 - May 2020
• 

  Casino Atlantic City

  Jul 2021 - May 2023

  Analytical Lead

  Achievements:- 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 Sportbook 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%.Functions:- Analyze business variables such as CIS, COS, Recency, Latency, Frequency to implement new promotions for the Offline and Online Casino.- Define the application logic of Bonuses and Promotions for the Offline and Online Casino.- Coordinate with the Growth area the correct implementation of the Bonuses and Promotions in EBS - Elite Bonusing Suite (Bally Technologies), Alira and CRM Cloud.- Present the results of the bonuses, campaigns and promotions that are implemented in the Weekly Commercial Committees. Moreover, present recommendations for improvement based on the analyzes carried out. Show less

• 

  International Media Group

  May 2023 - Aug 2024

  Business Intelligence Lead

  Achievements:- I implemented automated Commercial, Financial, Operational and Quality reports using Power BI.- I implemented a Business Intelligence Sharepoint where all the reports 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.- I implemented flows in Power Automate to automate operational processes ofthe Intake Center that reduced request resolution time by 75%.Functions:- Execute the analysis, development, maintenance and support of BI Solutions.- Implement automated solutions of existing reports and processes integrating data from different sources, such as 8x8, Five9, Vicidial, Salesforce and HubSpot.- Develop Dashboards and database structures using Business Intelligence tools.- Train users on elaborated reports or dashboards.- Manage and develop KPI's with defined objectives focused on the business.- Generate improvements to existing reports and support the elaboration of reports required by different areas of IMG.- Manage and model databases.- Promote the data-driven culture in the organization to drive operations and strategies.- Develop API connections by creating endpoints and managing requests and responses, ensuring interoperability and optimizing the performance of communication between applications. Show less

• 

  Ditech Group

  May 2024 - now

  Senior Consultant

  Alexandria Project - Santander BankFunctions:- Project Management and Control. Including taking requirements of the needs of the bank's main stakeholders; as well as the assurance of the data model.- Create new data sets using data flows and recipes to have consolidated information. - Develop interactive Dashboards in Salesforce Analytics using SAQL, bindings and toggles.- Collaborate with functional analysts in interpreting and understanding business needs to develop solutions that optimize operational processes and increase efficiency. Show less