Francisco Castelo Email and Phone Number

- Being at the service of brilliant individuals;- Guide powerful ideas to take shape;- Helping data to speak up with over 300 KPI's from the entire Source-to-Pay scope;- Giving the spotlight for the best ideas to shine;- Assisting in advanced analytics, Financial, Data Quality, Automation and Digitalization topics;- Assisting the Top Management in decisions with data oriented conclusions;- Leading a new standard for automation, data quality and process improvement;- Building outstanding visuals in PowerBI / Tableau as a front-end supported by intuitive data models in the back-end;- Taking care of other Team-Leader role-specific tasks.

- Responsible for the delivery of internal Data Quality reports to the Management;- Created an Autonomous email sender robot working under dynamic criterias (Attended RPA);- Developed VBA interface for SAP BI, allowing for automatic data extractions (Attended RPA);- Developed Excel automation with VBA eliminating highly manual steps of internal processes (Attended RPA);- Developed control checks with VBA allowing to identify, under defined criterias, values outside of normal parameters (Attended RPA);- Ensured all developments have been documented and in line with BNP Paribas standards for robotic developments, as well as in sync with GS2S - Operational Permanent Control team;- Participated in 3 task forces to address the challenges of COVID-19;- Developed fresh KPI's to better understand the business and its improvements;- Implementation of process improvements and report respective efficiency gains (RPA driven improvements);- Dashboards created in Tableau, Excel and PowerPoint.

Main achievements in process improvement (automation RDA or Attended RPA):- Area robot - 1.415 minutes/month saved- Accruals - 340 minutes/month saved- Accounts&Payable - 200 minutes/month saved- VA05&reporting scripting (close open sales order) - 525 minutes/month savedFinancial Controller & reporting for Brazil;- Interactive Dashboard creation in Excel and Tableau;- Brazil variable billing;- RDA Process automation with VBA coding for SAP scripting, Excel and Outlook interface;- P&L update, analysis and sanity checks- Accounting corrections in SAP- Payables, receivables, accruals and related accounting topics;- Accruals and monthly/yearly end accounting activities;- Data quality;

Financial Controller for the United States and Brazil regions;- P&L update, analysis and sanity checks- Accounting corrections in SAP- Payables, receivables, accruals and related accounting topics;- Accruals and monthly/yearly end accounting activities;- Process automation with VBA coding for SAP scripting, Excel and Outlook interface;- Maintenance reports and analysis including PO reports working as a quality gate;- WBS creation and controlling;- Data quality;- Forecasts/budgets uploads and corrections in SAP.

Allocated to the Refriango Business, a Beverages leading company in the Angola Market, mainly competing with Coca-Cola and Fanta.Main responsabilities were;- Creation, update and safekeeping the operations department Excel databases and files;- Weekly planning of the filling cans production lines;- Creation of the weekly Refriango cans production and follow-up with our local supplier;- Creation of a monthly report to be presented by my Director to the Executive Comission board;- Assisted the purchasing department with creation and update of databases;- Assisted the purchasing department with raw materials price analysis;- Assisted the International markets with creation of databases in order to present strong and solid data to the Executive Comission board;- Creation and update of KPI's analysis for the Operations department;- Analysis of the Forecast accuracy and BIAS, looking into deviations between the management control department forecast and the real sales. Interpretation of the results.

Invited to develop my MSc. Thesis on the Portuguese Seaport Sector.