Freelancer profile translated to English.

Description

Experienced SQL Developer with proven experience in designing efficient database table structures and optimizing complex SQL queries. Specialist in the development of triggers, stored procedures, functions, and views to improve database functionality and performance. Proficient in maintaining data quality and integrity through meticulous management and optimization. Passionate about delivering scalable and high-performance database solutions that support business operations and decision-making processes.

Industry field of expertise

Languages

Spanish
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Lugo (up to 50km)

Excel Automotriz
T-SQL Developer
AUTOMOBILE
August 2016 - August 2024 (8 years)
San Salvador, El Salvador
• I participated in the data migration and improvement of legacy T-SQL code from a SQL Server 2005 database to SQL Server 2015.

• I documented complex processes to facilitate understanding for the team and rewrote them to improve performance and scalability.

• I developed advanced SQL queries and ETL for the creation of dashboards and reports for monitoring and compliance with strategic KPIs.

• I implemented electronic invoicing in the Parts and Workshop areas for the countries of Guatemala, Panama, and El Salvador.

• I developed new functionalities through the creation of new code or understanding and adaptation of existing code.

• I followed up and resolved incidents, especially complex incidents regarding data inconsistencies that were reviewed in conjunction with the accounting team and internal audit.

• I participated in the adoption and use of the Scrum methodology in the company
Transact-SQL SQL Server Integration Services (SSIS) Scrum Gestión de incidencias SSAS
Ministerio de Economía de El Salvador
Full Stack Developer
PUBLIC SECTOR
January 2015 - December 2015 (11 months)
San Salvador, El Salvador
• I executed the project for the web development of the Commercial Negotiation Management System (SIGENEC)

• I collected and analyzed the system requirements

• I developed the solution under an MVC architecture using C# and T-SQL programming

• I integrated and used the Telerik third-party library

• I performed testing and debugging and implemented the solution
C# Desarrollo web JavaScript Transact-SQL SQL Server Reporting Services (SSRS)
Aproco S.A
Full Stack Developer
REAL ESTATE
June 2014 - December 2014 (7 months)
San Salvador, El Salvador
• I executed the project for the web development of the Condominium and Residential Administration System (APROCSI)

• I collected and analyzed the project requirements

• I designed and programmed the solution under an MVC architecture using PHP (CodeIgniter) and programming of stored procedures, functions, views, and triggers in MySQL.

• I performed testing and debugging and provided follow-up and resolution of reported incidents
PHP Desarrollo web MySQL Bootstrap JavaScript