Luccas Zulliane Marchetti Da Silva Email and Phone Number

- SQL Server Relational database management and architecture: normalized models aimed at storing fund/managed potfolio trading information, security registration and portfolio holdings. - Development of models designed for structured funds and fund perfomance reporting on a daily basis through procedures.- RESTful API devolpment through Flask/FastAPI.- Front-end: development of backoffice web tool aimed at security registration, portfolio trading and fund reporting through HTML5, CSS3 and JavaScript.- Docker: containerized solution for both front and back-end sides.- Airflow: pipeline-oriented routines aimed at providing investment fund report under specific schedule.- Azure: ETL data pipelines and data ingestion.

- Managed portfolio automated middle-office tool. Integration of in-house system with third party software for customer monitoring and reporting.- SQL Server relational database architecture aimed at registering customer attributes, daily trading and portfolio information.- Automated trading and registration of fixed income, funds and equity securities.- Automated customer monthly report, showing trading history, portfolio positions and performance.

- Fund cash and portfolio daily reporting. Integrated tool development through VBA + Python. API data fetching with automated reporting using HTML5+CSS.- Automated trading tool development for fixed income securities. SQL Server relational database architecturing aimed at storing fund and managed portfolio daily trading information.- Automated fund ranking tool using open market data. Monthly monitoring, comparing in-house products with similar funds from diverse managers. Python API data fetching and treatment, HTML5+CSS reporting.- Middle-office trading execution and trading conciliation. Fixed income, equitiy and derivatives.