Sr Developer · T-O-S Online
Jan 2023 – Present · Remote
- Founder and lead for custom web solutions.
- Domain and SSL/TLS management.
- Web and email server administration.
- Microsoft SQL Server database administration.
- Backup and recovery with Acronis.
Jorge Freire
IT Developer with a Master in SQL for Data Science. Focused on information flows and enterprise systems.
About
Professional with over 10 years of experience in the development and implementation of business system solutions, whit a Master's degree in SQL for Data Science. My experience spans the creation of desktop applications integrated with ERP systems such as SAP, Oracle, and AS400, as well as interfaces for ZPL and XML coding for label printers. Development of dynamic web applications, configuring SMTP servers, and implementing and updating database management systems, particularly MSSQL Server.
My experience includes designing and optimizing dynamic SQL queries for various business areas, including analytics, master reporting planning, supply chain management, inventory control, forecasting, and key performance indicators (KPIs). I have also worked extensively with metrics such as availability and downtime, mean time between failures (MTBF), overall team effectiveness, full-time equivalent (FTE) analysis, and efficiency. Additionally, I specialize in data extraction, transformation, and loading (ETL) processes.
Certified Microsoft Office Excel Specialist, I possess advanced skills in data analysis, manipulation, and visualization using Excel and Power BI. Additionally, I am proficient in creating custom dashboards and interactive visualizations directly in web applications, enabling me to deliver actionable insights and drive data-informed decisions.
Experience
IT Developer · Brakeparts Inc.
May 2020 – Present
- Project development in Visual Studio 2019.
- Application design for bulk data loading into ERP systems such as Oracle, SAP, and AS400.
- Application design for supply chain management and work-in-progress control.
- Development of dynamic modules with metrics for various departments.
- Design of ZPL and XML labels and modules.
- Task planning and achievement of objectives across different sites.
IT Site Support · FM Motorparts
Mar 2017 – May 2020
- Hardware, setup and diagnostic support (desktop computers, laptops, multifunction printers, label printers, RF equipment, access points, vending machines, IP phones, projectors and televisions).
- Configuration and update of software between server and client (easy label, label view, access PRO, ZK access, tress, sua, and Invoice, office 365, office mfa, itrp, ad, share point).
- Implementation and support for warehouse management through radio frequency equipment.
- Daily incident control on ITRP 4me service management platform.
IT Developer · Federal Mogul
Feb 2015 – Mar 2017
- Development of VBA projects
- Database and schema development
- Design of forms for production, quality, and materials data entry
- Design of real-time dynamic dashboards
- Design of a module for kit preparation (materials)
- Design of a module for calculating overall equipment effectiveness (OEE)
- Development of macros for data upload to SAP
- Design of ZPL labels
Skills
-
-Technologies and Software Development
- Microsoft Office 365 and Advanced Excel
- Microsoft Visual Studio (VB.NET, VBA)
- Microsoft SQL Server (Administration and Development)
- JavaScript (AJAX, JSON, Validations)
- Advanced PHP
- Database development and optimization
- Business Intelligence (Power BI, DAX, Power Query)
- ERP System Integration (SAP, Oracle, AS400)
- Integration of RFID Equipment with ERP
- Website and domain management
- Backup and recovery (Acronis)
- IT troubleshooting and problem resolution
- Support and maintenance of Zebra, Dymo, and multifunction printers
- Interfaces between applications and printing devices
- Data analysis and visualization
- Raw material demand modeling and forecasting
- Query optimization and database tuning
- Information security and data protection
- Access controls and application security
- SSL/TLS certificate management
- Problem-solving and decision-making
- Positive psychology applied to the workplace
-Administration and Support
-Data Analysis and Management
-Security and Cybersecurity
-Soft Skills and Management
Education
Universidad Tecmilenio
Administrative Computer Engineering · Ciudad Juárez, Chihuahua, Mexico
2017 – 2019
ERA Instituto de Especialidades en Sistemas S. C.
Technical Programmer in Enterprise Systems · Ciudad Juárez, Chihuahua, Mexico
2004 – 2007