Phillip's Blog

From Manual Execution to Intelligent ETL Process Orchestration

From Manual Execution to Intelligent ETL Process Orchestration

How to design an orchestration layer to coordinate data processes, validate dependencies, and improve operational traceability. The Problem: Processes That Relied Too Heavily on Human Intervention In organizations that process large volumes of operational and statistical data, ETL (Extract, Transform, Load) workflows can become a bottleneck. The challenge is not

When a Critical Problem Wasn't in the Code, but in the Configuration

When a Critical Problem Wasn't in the Code, but in the Configuration

When a Critical Problem Wasn't in the Code, but in the Configuration I recently returned from a well-deserved vacation from my role as an IT Analyst. Upon coming back to work, I found a situation that had been generating significant concern: a critical process within the organization was experiencing inconsistencies.

How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

In enterprise environments with large data volumes, SQL queries can go from executing in seconds to taking minutes—or even hours—especially when they involve multiple tables, joins, and functions on indexed columns. In this post, I want to share a real-world experience optimizing an Oracle query that originally took

From chaos to relief: How we solved a critical problem in the telemetered meter disconnection and reconnection system

From chaos to relief: How we solved a critical problem in the telemetered meter disconnection and reconnection system

For weeks, our system responsible for remote cut, reconnection, and meter readings was failing consistently. Commands we sent were stuck in timeouts—and this wasn’t a mere technical hiccup: * Customers who had already paid remained disconnected. * An entire department had to submit commands manually. * Service orders (SOs) were being

Improving Data Integrity and Efficiency in Geospatial Applications

Improving Data Integrity and Efficiency in Geospatial Applications

Recently, while working as an IT analyst, I’ve received constant complaints about a widely used tool by many departments within the company. This tool allows printing maps with georeferenced and alphanumeric customer information, making it easier to locate them and perform support tasks. However, it has been failing lately,

Optimizing Transformations in Pentaho: Case Study

Optimizing Transformations in Pentaho: Case Study

In my current role as an IT Analyst, I was tasked with verifying and correcting an automatic transformation in Pentaho. Pentaho is a suite of business intelligence (BI) tools that enables companies to collect, integrate, visualize, and analyze data from various sources to make informed decisions. It offers a range

How to Create a Shortcut for an Application in Ubuntu

How to Create a Shortcut for an Application in Ubuntu

Sometimes, when you are new to Ubuntu and need to manually download applications and run them from an executable file, you may wonder how to create a shortcut similar to those in Windows. Here, I will explain how to do it step by step. 1. Copy the application folder First,

Development of a Web Application for Consulting Geographic Information and Printing Maps: A Case Study

Development of a Web Application for Consulting Geographic Information and Printing Maps: A Case Study

Within the framework of my company's Annual Operating Plan, I was assigned the task of developing an innovative web application to consult geographic information of clients and generate interactive maps. This project is crucial to improve efficiency in geographic data management and optimize the relationship with our clients. In this

My university experience

My university experience

This will be a blog different from the others, in which I will immerse you in the great journey of my process to become a computer engineer. The beginning In the middle of 2007 I began my journey at the university, everything was going smoothly, I took all my subjects

Automate your tasks with Cron and Crontab

Automate your tasks with Cron and Crontab

"In the digital age, efficiency and automation are essential to keep workflows agile and streamlined. Often, we find ourselves with tasks that need to be executed on a regular basis, whether it's backing up data, cleaning systems or generate reports. Instead of relying on manual intervention, which can be error-prone

How to recover an application in production.

How to recover an application in production.

What to do when production goes down: Two weeks ago in my new job one of the applications that the company uses to serve a large part of its internal customers stopped working, this is an application that uses GIS services to represent, consult and print georeferential information corresponding to

My first assignments at my new Tech job

My first assignments at my new Tech job

Recently in the previous post he had indicated how you must act in an interview for a job related to technology, it is my pleasure to inform you that I am already working as an information technology analyst and part of the new things I have learned in this new

How to act in a job interview

How to act in a job interview

I recently made the decision to check out a more technology related job position at the company I work for. When I attended said test, the first thing I noticed was that one of the members of said department was programming in JavaScript 😁 which I already started to like. As

Understanding ReactJS Lifecycle

Understanding ReactJS Lifecycle

ReactJS, a popular front-end library, is known for its efficient rendering of user interfaces. One of the key features of ReactJS is its lifecycle methods. The lifecycle methods provide a way for developers to manage components and their behavior throughout their lifecycle. In this article, we will dive deep into

Avoid debts

It sounds trivial and above all cliché to say this "Avoid debts". But in our current society in which consumerism boasts a lot, it is possible that we fall into the trap of accumulating debts by making decisions based on fleeting emotions that we later regret after making them. One

The workflow with Git

The workflow with Git

Git is a control version system created by the creator of the Linux Kernel (Linux Tolvard), it allows to users working within a copy of a local repository, make changes and then sync them with a remote central repository. Also it offers features as branching and merging, what give to

The patience when you are learning new technologies.

The patience when you are learning new technologies.

In this days when I started my blog it arrived me the bad news that the Ghost's funcionalities will be free for limited time. They gave me a grace time but, afther that my blog and all its content will be wiped. To resolve this I set out myself to

The best way to grown up in Web Development
Edit article

The best way to grown up in Web Development Edit article

It is very common after finish several intensive course as well as bootcamp believe ourselves ready to begin our laboral carrier as a web developer, sometimes it is possible but the most times we found with the merciless reality we barely that we have the basics knowledge to achieve. By

The importance to have presence in the web

The importance to have presence in the web

When you start into the interesting world of the web development, it comes the greatest question. Now I have all the knowledge necessary (such as soft and hard skills), I have taken some interview and successfully built technical project and even so I have not bee hired. What do I

The focus in your life

The focus in your life

It is very importante to know that in your live you will get whetter positive or negative results based whether you look up your energies (this ones can be mental, physicals and/or psychological). Among the advantages can offer to have an focus in your life are: * Find meaning what

Difference Between Hashing and Salting

Difference Between Hashing and Salting

When we are learning about good practices when storing sensitive information in our databases, the question arises of how I can store my passwords securely. For this, in computer security and in many of its areas (Web development, Big Data, machine learning, etc.) we talk about #hashing and #salting. hash

About Me

Hello, my name is Phillip, I am a web developer currently working as a geospatial or georeferential database analyst in one of the electricity distribution companies in my country. I am passionate about learning new technologies focused on web development that allow me to be at the forefront of the