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

IT Developer

Brakeparts Inc.

  • Project development in Visual Studio 2019.
  • Project development in Plesk Websites/Domains.
  • Design of recovery and backup tasks in Acronis.
  • SSL/TLS certificate management.
  • Application design for massive data loading to Oracle and SAP.
  • Supply chain management application design and work in progress control.
  • Development of dynamic modules with metrics for different departments.
  • Design of ZPL and XML modules and tags.
  • Planning tasks and meeting objectives in 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

  • Project development in VBA.
  • Development of databases and schemas.
  • Design of forms to capture production, quality and materials.
  • Design of dynamic dashboards in real time.
  • Module design for the preparation of kits (materials).
  • Module design for calculating the general effectiveness of the equipment.
  • Design of macros for uploading information to SAP.
  • ZPL label design.
    • 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

    Experience analyzing business improvement.

    • Microsoft Office 365.
    • Microsoft Excel Advanced.
    • Visual Basic .NET (VB.NET).
    • Microsoft SQL Server.
    • Database administration.
    • Plesk websites/domains.
    • JavaScript Ajax Request and JSON Response.
    • PHP Web Developments.
    • Visual Basic for Applications (VBA).
    • Business Intelligence (BI).
    • Data analysis.
    • Forecasts.
    • Zebra label printers.
    • Dymo label printers.
    • SAP and ORACLE ERP.
    • Inventory management.
    • Acronis backup.
    • Service now.
    • Troubleshooting.
    • Problem resolution.
    • POSITIVE Psychology.
    Certifications

    Microsoft Office Excel 2016: basic data analysis, manipulation and presentation.

    SQL Master for Data Science (SQL: Data Reporting and Analysis, Advanced SQL for Data Scientists, Advanced SQL for Query Tuning and Performance Optimization).

    Data analysis expressions (DAX).

    Web development, Create efficient code using JavaScript functions.

    Business Intelligence, Power Query Query Editor.

    Business Intelligence, Data Analysis Expressions (DAX).

    Operations Management, Information Flows in a 2.0 supply chain.

    Contact

    Jorge Armando Freire Gutierrez

    (656) XXX-XXXX

    correo@jorge-armando-freire-gutierrez.info