David Ricardo Consuegra Torres Email & Phone Number

Layton, Utah, United States

* Creating and updating features using programming languages for the front and back-end such as Perl, HTML, JS, JQuery, and SQL.* Performing DML and DDL for different databases such as MySQL, SQL Server, and DB2.* Migration of legacy functionalities to a web environment.

Arlington, Texas, Estados Unidos

* Developed full-stack application using the Front and Back-end technologies such as HTML, Bootstrap, JavaScript, Angular, Hibernate, and Spring ORM.* Used RDS service to manage SQL databases.* Designed, development, and implemented databases related with assigned projects. * Performed CRUD operations, using JDBC, DAO, Hibernate, JPA over Postgres Database.* Implemented Bootstrap and CSS to style to create user-friendly webpages.* Utilized DevOps methodology to work within team environments.Utilized Cloud services like Amazon EC2 and DigitalOcean to host web applications.* Implemented Unit-Testing through Junit and Mockito for Java applications.* Designed development, implementation, and improvement MySQL and Postgres Databases using appropriately all database's objects (tables, keys, indexes, views, triggers, stored procedures, functions) to support and develop enterprise projects basis on a previous requirements analysis.* Implemented custom AJAX to transfer JSON data between Web Service

Barranquilla, Colombia

PHP DEVELOPER* Full-Stack PHP Developer for various in-house organizational projects.* Automated process through out PHP’s scripts.* Improved Web-based applications adding new features.* Performed database design, development, implementation and administration activities.* Development ad hoc and scheduled reports to provides information to perform daily basis task.* Designed front-end using PHP, HTML, CSS, Bootstrap, JavaScript ,and JQuery to a improve user experience.DATABASE DEVELOPER* Designed database architecture for different organizational projects.* MySQL Database Sync installed in different servers.* MySQL to ORACLE database migration (migrate a MySql database to Oracle).* Performed database design, development, and implementation and administration activities.* Development of Data Flow Diagrams, Entity Relationship Diagrams and Data Structure Diagrams.* Development ad hoc and scheduled reports to provides information to perform daily basis task.* Write Complex SQL queries, store procedures, cursors, triggers, and functions.* Query optimization with respect to its performance and SQL written Syntax.* Automated process design, optimize, program and implementation of recurrent regular processes.* MySQL Database and PHP program integration.* Guarante availability of the linux server services hrough out the control of the variables which could affect the correct functioning of this.ADMINISTRATIVE TASKS* Followed up to the service level agreements of services providers.* Management and contract supervision of providers services such as documentary management, carriers, storage and transportation of documents.* Followed up to the key performance indicators of services providers.* Payment authorization for service providers through out verification and reconciliation of invoices.* Negotiate the agreements to modify the contracts of service providers.

Colombia

MySQL database server migration of PAL applicationAnalyze, review and modify database objects in order to improve the server’s performance.MySQL database new objects design, development, and implementation of the new functionalities for PAL application.MySQL Database administration tasks, including maintenance, backups, indexes optimize, and creation and assignment of furloughs for the new users’ access.Write queries to develop ad hoc and scheduled reports to provide information to different areas of the organization to perform daily basis tasks.Design, development, implementation, and automation of the stored procedures and triggers for the sales commission calculation process based on the accomplishment and evaluation of every internal business rule for each payment.Frontend and Backend design, development, and implementation of newly PAL's application functionalities.Nationwide application support for PAL application.

Colombia

MySQL - database architecture design for PAL application.MySQL database design, development, and implementation for PAL application.Write queries to develop ad hoc and scheduled reports to provide information to different areas of the organization to perform daily basis tasks.Write stored procedures, triggers, and functions in order to improve MySQL server performance and automate database processes. Automation of processes through the development and implementing SQL and PHP scripts on Windows OS server.Perform requirements analysis in order to define the architecture and design of the databases and PAL application functionalities.Frontend and Backend design, development, and implementation of PAL's application.Documentation for newly developed functionalities for PAL application.

Colombia

Database update.Write SQL queries, and development ad hoc reports.Provide technical support to users of Internet service Responsible for the administration of contact email services.Provide effective solutions to client requests.Supply clients with global information and process connection, billing and email.

Colombia

Database update.Provide technical support to users of Internet service Responsible for the administration of contact email services.Provide effective solutions to client requests.Supply clients with global information and process connection, and billing.

Ingeniero De Sistemas

Tecnologo, Ingenieria De Sistemas