Maintenance and development of the company report (PowerBI – MySQL)Production of reports and on demand extractionsDevelopment (VBA, MySQL, Python – Flask) and integration of a new ERP to substitute SAP used for:• Managing consumables and raw materials inventory• Manage purchase orders• Store information of incoming raw material batches• Certificate the quality of finished products batchesProject management of the integration of an in-house developed MES aimed… Show more Maintenance and development of the company report (PowerBI – MySQL)Production of reports and on demand extractionsDevelopment (VBA, MySQL, Python – Flask) and integration of a new ERP to substitute SAP used for:• Managing consumables and raw materials inventory• Manage purchase orders• Store information of incoming raw material batches• Certificate the quality of finished products batchesProject management of the integration of an in-house developed MES aimed at tracking and labeling half-processed productsProject management of the integration of a third-party MESDeveloped a Data Warehouse system from scratch using MySQL, with a custom job scheduling system for ETL processes and email delivery, leveraging Python and Windows Scheduler. Show less

Design and development of the VBA application and the underlying data model used by the department to carry out operational tasks pertaining Chargeback Defense and Fraud DetectionTaking care of the data integration flows and development of ETL pipelines from data sourcing to data delivery in destination tables for analytics or application usage. Design and development of jobs aimed at automating manual activities or provide support to users in operational tasksDesign, development… Show more Design and development of the VBA application and the underlying data model used by the department to carry out operational tasks pertaining Chargeback Defense and Fraud DetectionTaking care of the data integration flows and development of ETL pipelines from data sourcing to data delivery in destination tables for analytics or application usage. Design and development of jobs aimed at automating manual activities or provide support to users in operational tasksDesign, development and maintenance of the in-house built job-scheduling application (used to schedule and orchestrate jobs) deployed in the team’s virtual machine based on CentOS Design, development and maintenance of a simple machine learning algorithm used to detect potential fraudulent transactions to be manually checked by agentsDesign and development of a dashboard used to monitor users activity and flows integrity Data modeling on mySQL for reports with smaller datasets and the in-house built applications and creation of data marts in Vertica for big data analyticsDevelopment and maintenance of real time alerts to monitor Fraud Prevention / Payment Operation performances Show less

As part of the Business Accounting Control department (in charge passive reconciliation, cost allocation, suppliers’ payment, debt collection, invoicing flows towards customers) my tasks were:• Structuring tables and queries (MySQL) for the management of extraordinary events (i.e. airlines going bankrupt, frauds) aimed at analysis of the economic effects, producing reports, and supporting other departments impacted by the event• Through VBA and mySQL, implementing partially automated… Show more As part of the Business Accounting Control department (in charge passive reconciliation, cost allocation, suppliers’ payment, debt collection, invoicing flows towards customers) my tasks were:• Structuring tables and queries (MySQL) for the management of extraordinary events (i.e. airlines going bankrupt, frauds) aimed at analysis of the economic effects, producing reports, and supporting other departments impacted by the event• Through VBA and mySQL, implementing partially automated process aimed at aiding users carrying out manual activities that, due to their nature, could not be completely automated.• Making sure the debt collection team is complying with its deadlines, keep track of the recovered sums, deliver monthly or on demand reports and get in touch with the banks to forcefully recover outstanding debts. Show less