Lucas P. Esquerdo Email & Phone Number

Sao Paulo, Brazil

Working closely with the management and strategic teams providing commercial insights and analytics support;• Financial KPIs Management;• Development of multiple commercial reports (Sell Out, Margin, Profitability, Stock);• Development of dashboards in PowerBI

Sao Paulo, Brazil

Working in BI, Sales and Marketing areas as a dedicated developer at Baxter International;Projects:• Development of commercial performance dashboard in Tableau to support the decision-making to multiple levels, from sales rep. up to relevant directors. ETL Proccess – Data Modelling and upload from excel spreadsheets and ERP, normalization and visualization of data (OLAP);• Development of Excel solution to support customer benchmarking used by sales rep in decision-marking and… Show more Working in BI, Sales and Marketing areas as a dedicated developer at Baxter International;Projects:• Development of commercial performance dashboard in Tableau to support the decision-making to multiple levels, from sales rep. up to relevant directors. ETL Proccess – Data Modelling and upload from excel spreadsheets and ERP, normalization and visualization of data (OLAP);• Development of Excel solution to support customer benchmarking used by sales rep in decision-marking and commercial proposals to potential customers; • Development of SharePoint solution to automate the internal proccess of New Products Requesting, using Nintex Workflow, Microsoft PowerApps and Flow. After the initial pilot, the solution was adapted and replicated to two additional business areas;• Development of Excel solution to segment customers and generate price readjustment letters to different strategic groups. Show less

Sao Paulo, Brazil

• Identification of improvement opportunities alongside business areas; • Project Portfolio Management;• Dissemination and incentive of homologated tools (WebEx, MS Planner, MS OneDrive) through trainings sessions;• Digital Techonology Projects Management – Support Requirement Gathering, Bidding, Development, Tests/Homologation and Implementation; Projects: • Development of commercial dashboard, treating data from Excel and development of data visualization through… Show more • Identification of improvement opportunities alongside business areas; • Project Portfolio Management;• Dissemination and incentive of homologated tools (WebEx, MS Planner, MS OneDrive) through trainings sessions;• Digital Techonology Projects Management – Support Requirement Gathering, Bidding, Development, Tests/Homologation and Implementation; Projects: • Development of commercial dashboard, treating data from Excel and development of data visualization through QlikView/QlikSense; • Development and Implementation of SharePoint solution to LATAM cluster countries (Brazil, Colombia and Mexico) in order to automate and unify processes related to medical events request, using Microsoft PowerApps and Flow; • Implementation of digital solution used in town halls and congresses providing a better visualization of schedules and interaction between speakers and atendees;• Development of App Prototype used to monitor the home infusion treatment for patients with rare diseases (MPS II) and project management;• Management of inovation project focused on creating digital VR content to be used by child patients during dialysis treatments, providing entertainement for children and support to health professionals; Show less

Sao Paulo, Brazil

• Project Management Support – running update meetings, supporting requirement gathering, performing tests and implementation;• SharePoints and Local Intranet Administration;• Support IT’s SLA KPIs Administration; • Support to IT Financial Management area – creating POs, participating in the new suppliers contracting process and monitoring it alongisde the Procurement area. Project: Development of SharePoint to automate the process of invoice receival process used by… Show more • Project Management Support – running update meetings, supporting requirement gathering, performing tests and implementation;• SharePoints and Local Intranet Administration;• Support IT’s SLA KPIs Administration; • Support to IT Financial Management area – creating POs, participating in the new suppliers contracting process and monitoring it alongisde the Procurement area. Project: Development of SharePoint to automate the process of invoice receival process used by the Fiscal area, using SharePoint Designer and Microsoft InfoPath. The project implementation achieved the Financial Management’s Target and resulted in a saving of approximately 9.000 print copies/month. Show less

Sao Paulo, Brazil

Dublin, Irlanda

Sao Paulo, Brazil