Database Administrator
Multibank
(Banks and financial services, 1000-5000 employees)
Keywords
Portfolio
Skills
Programming Languages: (advanced): Python, SQL Server, C#, MongoDB, Visual Basic 6.0, Visual Basic.NET, Access, Informix, Visual Foxpro, Foxpro, SAP Crystal Report, VBA, Twain, MV Editor, MV Report, CMD files. (Intermediate): HTML, XML, ASP.NET, MySQL, JSON, Java Script, CSS3, Oracle, Java. (familiar): Bootstrap, REDIS, RabbitMQ, PHP.
Frameworks and Tools: (advanced): ADO.NET, Pandas, Pyodbc, Sys, GitHub, Windows, CyberArk, Twain, WordPress, WooCommerce, Acronis True Image, Microsoft Visio, XAMPP, Word, Excel, PowerPoint, Publisher, MS-DOS, Teamviewer. LINUX /Ubuntu, Antivirus NOD32. (Intermediate): RESTful API, Entity Framework (EF) Core, Jira, Scrum, Kanban, Service Now, FootPrints, Numara Track-It (Itil Methodology), MS Project, Windows Server, Frontpage 2003, Active Directory, WMS Systems, SQL Developer. (familiar): VMWare, WAMPServer, MV Soul
Languages: English, Advanced; Italian, Fluent; Spanish, Native.
Frameworks and Tools: (advanced): ADO.NET, Pandas, Pyodbc, Sys, GitHub, Windows, CyberArk, Twain, WordPress, WooCommerce, Acronis True Image, Microsoft Visio, XAMPP, Word, Excel, PowerPoint, Publisher, MS-DOS, Teamviewer. LINUX /Ubuntu, Antivirus NOD32. (Intermediate): RESTful API, Entity Framework (EF) Core, Jira, Scrum, Kanban, Service Now, FootPrints, Numara Track-It (Itil Methodology), MS Project, Windows Server, Frontpage 2003, Active Directory, WMS Systems, SQL Developer. (familiar): VMWare, WAMPServer, MV Soul
Languages: English, Advanced; Italian, Fluent; Spanish, Native.
Project history
08/2022
-
05/2023
• Contributed with the IT project department to reduce lead times by 65% by migrating, backing up, restoring databases, installing and configuring server and client instances, creating users and assigning their roles and permissions, developing and executing scripts and jobs, analyzing sensitive data and validating best practices to upgrade the Infoanalisis, Virtual university, BAN08, AMS, Tekins, Atoms, Siebel, Masterdata and InfosWeb (payroll) applications.
• Improved banking services by 10% by resolving 50+ database tickets.
• Developed a new database to automatically migrate data from server inventory spreadsheets, reducing search times by 80% and improving inventory logistics.
Tech stack: SQL Server, Oracle, Visual Studio, SSIS, Excel, Access, VBA, Command Prompt, Windows, Outlook, Teams, Jira
• Improved banking services by 10% by resolving 50+ database tickets.
• Developed a new database to automatically migrate data from server inventory spreadsheets, reducing search times by 80% and improving inventory logistics.
Tech stack: SQL Server, Oracle, Visual Studio, SSIS, Excel, Access, VBA, Command Prompt, Windows, Outlook, Teams, Jira
04/2022
-
07/2022
Data Analyst
Philips
(Pharmaceuticals and medical technology, >10.000 employees)
● Achieved code and logic complexity reduction by 75% by analyzing, debugging legacy code and developing a new optimized application to read monthly 4 spreadsheet files to extract, analyze, manipulate, process sales and forecast data from Brazil, Hispanic, Latam and Mexico regions.
● Reduced reporting time by 99% by developing a new cloud database to store processed information by automatically generating the LV_FSA_Output, LV_FSA, LV_InventoryFC y QxP views linked to reports.
Tech stack: Python with Pandas, Pyodbc, Sys, SQL Server, Azure, Excel, VBA, Command Prompt, Windows, Outlook, Teams
● Reduced reporting time by 99% by developing a new cloud database to store processed information by automatically generating the LV_FSA_Output, LV_FSA, LV_InventoryFC y QxP views linked to reports.
Tech stack: Python with Pandas, Pyodbc, Sys, SQL Server, Azure, Excel, VBA, Command Prompt, Windows, Outlook, Teams
02/2021
-
09/2021
Database Administrator
BAC Credomatic
(Banks and financial services, 1000-5000 employees)
● Improved banking services by 20% by Installing or Migrating 5+ Databases instances.
● Improved 300+ databases performance by 30% (based on objective statistics) by shrinking them, reducing their response time by creating or optimizing indexes.
● Increased 50+ databases stability by 30% by the creation and improvement of dozens of SQL jobs.
● Participated in 100+ patches implementations by developing and executing scripts, thus upgrading banking systems by 30%.
Tech stack: SQL Server, Access, Command Prompt, Windows, CyberArk, Services Now
● Improved 300+ databases performance by 30% (based on objective statistics) by shrinking them, reducing their response time by creating or optimizing indexes.
● Increased 50+ databases stability by 30% by the creation and improvement of dozens of SQL jobs.
● Participated in 100+ patches implementations by developing and executing scripts, thus upgrading banking systems by 30%.
Tech stack: SQL Server, Access, Command Prompt, Windows, CyberArk, Services Now
Certifications
Local Availability
Only available for remote work
