Julio Ramírez Email & Phone Number

San Antonio, Texas, United States

• I have played a role in the development of synchronization solutions for different systems through APIs. My work has been focused on utilizing technologies such as Laravel, MySql, and PostgreSQL.• My main responsibilities have included collaborating on data search, cleansing, and auditing for information migration between systems. This has involved working with complex datasets and ensuring data integrity and accuracy throughout the process.• Development of new APIs from scratch.• In addition to my technical skills, I have had the opportunity to work in a highly collaborative environment where communication in English has been essential. I have participated in meetings and discussions with the team, sharing ideas and seeking efficient solutions for the technical challenges we have encountered.

Quetzaltenango, Guatemala

Software Development Company.• Led a team for the design, development and implemented from scratch of a custom ERP System using .NET (C#), DevExpress Suite, MySQL integrated with 3rd party Systems using REST/SOAP APIs & DLLs allowing the client to have full control of their business operations.• Designed, developed and implemented from scratch custom Web ERP System using Laravel, jQuery, JavaScript, Vue, MySQL integrated with 3rd party Systems using REST/SOAP APIs that has been implemented in different types of industries and has helped customers to manage their companies and make strategic decisions based on systems’ data.• The agent’s workload was reduced by at least 20% in addition to offering control and ease of decision making for the client through the design, development and Implementation from scratch of a Parking Management System using Laravel, Livewire, MySQL integrated to third party systems.• Worked with various clients developing and maintaining websites including e-commerce, small & medium business, education among other industries using HTML/CSS/JS, Wordpress, Shopify as well as doing some integrations with Suite CRM and other custom systems, helping customers to reach their objectives: reinforce their brand, increase sales, connect with their existing customers and capture and convert new ones.• Tech Stack: C#, .NET | PHP, Laravel, Livewire, jQuery, JavaScript, Vue, MySQL, Wordpress, Shopify.

Miami/Fort Lauderdale Area / Guatemala

Software Development Company.• Part of Senior Developers Team that developed and implemented SugarCRM & SuiteCRM customizations and development of advanced reporting platforms for different clients and industries using PHP, JavaScript, MySQL as well system integration with VoIP and 3rd party platforms using REST/SOAP APIs allowing clients an orderly growth through better management of their information.• Implemented Query Optimization in MySQL database to get customer name using number from an incoming VoIP call within a database with more than 8 million records in 1 second.• Developed and implemented from scratch a Business Intelligence Portal using Laravel, JavaScript, MySQL, PostgreSQL that helped the client to obtain relevant information for decision making.• Developed websites for different types of customers using: HTML, CSS, JavaScript, Wordpress in order to improve their brand's position in the market.• Tech Stack: PHP, Laravel, jQuery, JavaScript, MySQL, PostgreSQL, Wordpress.

Miami/Fort Lauderdale Area

Cloud based communications company.• Participated in development and implementation of the in-house ERP based on SugarCRM to manage the entire sales process, post-sale, channel partners management, provisioning and inventory management of VoIP equipment, service installation management, built with PHP, Laravel, jQuery, JavaScript, MySQL and SQL Server. Integrated with VoIP service providers using REST/SOAP APIs with allowed owners and managers to have full control of their sales processes, equipment installation and inventory, commission payments as well as sales reports and business intelligence.• Led the Develop and implementation of the Billing and Rate Management System using Microsoft Tools (.NET and SQL Server) integrated with Great Plains, significantly reducing manual work in the accounting department, streamlining the billing and collection process, increasing cash flow.• Advise developers for the creation of database objects and the design of SQL queries for the implementation of a database object log and their standardization; this facilitates the work of maintaining the database and the use of it for new developers.• Tech Stack: PHP, Laravel, jQuery, JavaScript, C#, PL SQL, MySQL, SQL Server.

Guatemala

Multi-company Loyalty Program.• Developed Predictive Segmentation Data Mining Models for a Retail Customer with the IBM SPSS Modeler using CRISP-DM methodology, to create groups of customers with homogeneous characteristics and behaviors allowing marketing department to focus their more efficiently.• Successfully Developed a Basket Market Analysis (Association Data Mining Model) using IBM SPSS Modeler to understand shoppers’ behavior, identify what items are bought together with a validation up to 90% of accuracy in order to implement marketing strategies and decide how to place merchandise on shelves for maximizing profit.• Led the Standardization and optimization of advanced SQL Queries in Oracle database to reduce their creation time an improve the precision of data obtained for the generation of data mining models.• Tech Stack: SPSS Clementine (IBM SPSS Modeler), SPSS Tool, Oracle.

Guatemala / El Salvador / Honduras / Nicaragua

Multinational dedicated to the manufacture, sale and distribution of products by catalog.• Actively participated in the analysis, design, development and implementation of new features and maintenance of in-house ERP using Power Builder, Sybase and Oracle, reaching the specific requirements and objectives defined by the different departments of the company.• Advisor to technical support team, providing training on the proper use of tools and processes, with allowed us to improve service to users and reduce the number of support incidents.• Participated in the Implementation of the database automated synchronization between local branches and countries, which allowed the centralization and immediate availability of the information improving inventory management and optimizing the supply chain.• Tech Stack: Power Builder, C#, Sybase / Oracle.

Systems Engineering

10 English Courses, English Language And Literature, General, Advanced

Education record