05/11/2024 updated
100 % available
Python Certified Programmer, .NET Developer senior, SQL SERVER Programmer and DBA
Panama, Panama Degree in Higher University Technician in Computer Science,Systems Engineering,high school with emphasis in electronics
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.
Languages
EnglishFluentItalianNative speakerSpanishNative speaker
Project history
• 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
● 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
● 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
Portfolio
Main menu
A Visual Foxpro systems developed from scratch
A VFP9 update form
Updating simulation and performance of production
searching form
A form with assisted searching
Combobox design
selfcompleted combobox while writing
Toolbox design
Fully functional, form-independent toolbox that allows you to run more than one form at a time.
High design reports
Sophisticated screen and printer reports
Parameters design
Input parameters for reports