Fabrizio Nencini

• Optimizing performance of data processing. • Development of SQL scripts, data cleansing/ modifications of procedures/ views. • Development and deployment of Visual Studio SSAS model (Tabular). • Design and deployment of the CI / CD chain. • Development of PowerBI real-time reporting. • Processing and Integration of files in Agile mode. • Source code management via Bitbucket / Git. . • Complete backup, restore, maintenance of databases indexing with Ola Hallengren scripts.

Design from January 2020 of a website for a company in the energy sector. Administration of web hosting. The realization of the back-end logic. Migration and website backup. Cross-Browser-Testing. Cross-Device-Testing. Content changes. Frontend & Backend testing. Cyber Security Solutions. Technical environment : Oracle, Informatica Powercenter, SQL, SQL Server Wordpress, htlm, css, javascript, Adobe Suite (Photoshop, Illustrator, Indesign) Dreamweaver

• Technical support on HPSM incidents. • Writing the documentation of the steps for testing and deploying scenarios for users. • Development of SQL scripts / modifications of procedures / views / settings. • Contribution to the formalization of test plans, execution of unit tests and a first level of integration tests. • Optimizing performance of data processing. • Administration and resolution of problems related to the calculations of financial instruments in scenarios.

• Technical and functional analysis, definition of needs, feasibility study. • Developments around various necessary ETL and Oracle components. ETL & Reporting to automate the AEI process for Basel II regulatory reporting. Development of new Informatica PowerCenter mapping. • Writing technical specifications and other functional deliverables. Technical environment : Oracle, Sql, PL/SQL, Xml, Unix, Informatica PowerCenter, bash shell

• Changes to shell scripts to automate a series of operations. • Implementation of data transformation tools, automation of transformation processes and instrumentation of these processes. • Management of standard Big Data applications, offering continuous monitoring tailored to specific business and development needs. • Provide technical support on the data lake, in particular by analyzing and resolving incidents or problems, by implementing changes and by monitoring the performance / clusters.

• Define and understand the needs and constraints of the introduction of the customer's geodata system with managers and future users. • Technical and functional analysis, definition of needs. • Support of the client in the management of its IT GIS projects. • Coordination with business, software editors, IT department, users test-teams. • Plausibility and Feasibility analysis using SQL queries to compare two sets of data. • Development of a GIS-based decision support tool.

• Production monitoring (research / investigations, SQL analysis and modification of Informatica PowerCenter mappings). • Development of new Informatica PowerCenter mapping • Creation of an ETL solution to update a data warehouse with Oracle and Informatica PowerCenter. • Creation of reports on SAP Crystal Report. • Modeling of a data warehouse. Management of the Control M Job scheduling & workload automation. Technical env : HPSM, Oracle, Sql PL/SQL, Xml, Unix, Informatica, Crystal Report

Databases, Webdesign, interaction design

Bibu, Abschlussrechung, Statistik, Mathematik