Jorge Freire

I am a IT Developer with a Master degree in SQL for data science, specializing information flow.

About

I am a 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.

As a certified Microsoft Office 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

Sr Developer

T-O-S Online

  • Founder and Head of Custom Web Solutions Development
  • Development and implementation of websites and domain management.
  • Administration of SSL/TLS certificates to ensure application security.
  • Management of web and email servers.
  • Database administration in Microsoft SQL Server.
  • Design and implementation of backup and recovery strategies with Acronis.
    • Jan 2023 - Present

    IT Developer

    Brakeparts Inc.

  • 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 modules and labels.
  • Task planning and achievement of objectives across different sites.
    • May 2020 - Present

    IT Site Support

    FM Motorparts

  • 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.
    • Mar 2017 - May 2020

    IT Developer

    Federal Mogul

  • 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
    • Feb 2015 - Mar 2017
    Education

    Universidad Tecmilenio

    Ingeniero en Computación Administrativa (ICA)

    Cd. Juarez, Chih. Mexico

    2017 - 2019

    ERA Instituto de Especialidades en Sistemas S. C.

    Técnico Programador en Sistemas Empresariales

    Cd. Juarez, Chih. Mexico

    2004 - 2007
    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

      • -Administration and Support
    • 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 Management
    • Data analysis and visualization
    • Raw material demand modeling and forecasting
    • Query optimization and database tuning

      • -Security and Cybersecurity
    • Information security and data protection
    • Access controls and application security
    • SSL/TLS certificate management

      • -Soft Skills and Management
    • Problem-solving and decision-making
    • Positive psychology applied to the workplace
    Certifications
  • Advanced PHP
  • Practical Cybersecurity: Networks and Web
  • Advanced SQL for Data Science: Time Series
  • Advanced SQL for Data Scientists
  • Advanced SQL for Query Tuning and Performance Optimization
  • Essential DevOps
  • Master SQL for Data Science
  • SQL: Data Reporting and Analysis
  • Microsoft Office Excel 2016: Core Data Analysis, Manipulation, and Presentation
  • Business Intelligence: Power Query Editor
  • Business Intelligence: Data Analysis Expressions (DAX)
  • Business Intelligence: Scalar Functions in Power BI DAX
  • Business Intelligence: Time Intelligence Functions in Power BI DAX
  • Big Data: Data Analytics 2.0
  • Information Security: Personal Data Protection
  • Information Security: Information Security and Cybersecurity
  • Information Security: Security Controls – Access and Applications
  • Web Development: Handling Arrays and Objects in JavaScript
  • Web Development: Writing Efficient Code Using JavaScript Functions
  • Web Development: Implementing Validations and Calculations on the Frontend
  • Operations Management: Information Flows in a Supply Chain 2.0
  • Software Development: Data Definition Language (DDL) with SQL
    • Contact

    Jorge Armando Freire Gutierrez

    (656) XXX-XXXX

    correo@jorge-armando-freire-gutierrez.info