Alessia Frapiccini

Single Supervisory Mechanism, DG Governance & Operations, Technology & Innovation Division, Core Systems Section. Main tasks:

• Writing stories, test cases, operations, defects in Jira and testing in IMAS ephemeral (temporary) or lower environments the correct functioning of the resulting delta configuration, of the new features implemented.
• Extending a robot which imports Supervisory Board decisions in IMAS, adapting the Python code to different task types, retrieving missing data, setting validation rules, analyzing the workflow of the supervisory documents.
• Conducting data analysis and data manipulation, mainly using SQL queries to retrieve, clean, and organize data for various business needs, to extract information and to help to authomatise internal processes and handling missing data.

Market Operations Analysis Division, Financial Markets and Collateral Section. Main tasks:

• Conducting analysis of assets used as collateral by Eurosystem counterparties in extensive databases, preparing charts and tables, maintaining Tableau dashboards, helping in schema migrations editing SQL queries and Python scripts.
• Testing IT softwares and new releases in Tadnet and Acceptance from the business side, manipulating specific files, submitting them trying to trigger in the system a particular response, taking note of the results in Jira.

Market Operations Analysis Division, Financial Markets and Collateral Section. Main tasks:

• Supporting operationally the Division through regular tasks; some were daily, for example monitoring some processes and promptly intervening if they fail, handling eventually major incidents, some were weekly, monthly, quarterly, annual, for example updating internal and external charts, taking care of ad-hoc requests.
• Helping in drafting analytical reports and presentations, conducting data analysis to update charts and tables, updating SQL queries and Python scripts, reviewing documents, writing ad-hoc comments and conducting meetings to update the team, for the Executive Board, the Governing Council, the Market Operations Committee.

Internship done during the Master's Degree, at the AGCM - Autorità Garante della Concorrenza e del Mercato. Main tasks:

• Contributing to the analysis of regulatory compliance issues, through data visualization tools and statistical analysis to support competition oversight, in particular with a focus on the 'Inability to Pay' project, an analysis on companies who declared not to be able to pay the sanctions imposed by the Authority, focusing on their balance-sheet.
• Participating in projects to improve market transparency and regulatory frameworks, developing project management skills, in particular with a focus on antitrust decisions on the television sector concentration, and writing a report.