Relational Databases and Normalization

Two-dimensional data is the most commonly used form of information representation by humans. In 1970, Edgar F. Codd first introduced how to efficiently use two-dimensional data to represent transactions, laying the foundation for modern databases. The core of this theory is: normalization. Let’s demonstrate how database normalization helps us build a better two-dimensional data model through an example. 1 Scenario We have a system that tracks students registering for courses at a technical institute....

September 9, 2024

Weekly Summary Framework for Resume Submissions

I will share this in two parts: How – The strategies for a weekly summary of resume submissions; Example. 1 How - Strategies goals : Who know you match job require 1.1 Principle put 80% of your effort into your main category 15% into the secondary ones and the last 5% on everything else. 1.2 Check List Are there enough sources to access information ? Is the time spent on each area reasonable ?...

September 7, 2024

Customize Your Resume According to the Job Description

In the current Resume Manager application, the module I use the most on a daily basis is the job application module, with its core feature being the tracking of resume submissions. Moving forward, I want to enhance the ability to match resumes with job requirements. This will involve the following steps: Analysis of the recruitment process and the needs of each stage Resume Match evaluation Process adjustment 1 Analysis of the recruitment process and the needs of each stage Stage Goal Evaluation Criteria Resume Screening Initial screening to find candidates that meet basic job requirements Core skills Years of experience Education requirements Career objectives and cultural fit Initial/Phone Interview Further assess communication skills, motivation, and cultural fit Communication skills Career motivation Problem-solving ability Cultural fit Technical Assessment Evaluate candidates’ technical proficiency and problem-solving skills Technical skills Problem-solving ability Project experience and technical expertise Behavioral/Deep Interview Assess leadership, teamwork, and deeper cultural fit Leadership Teamwork Cultural fit Handling challenges Final Interview/Decision Ensure long-term potential within the company and alignment of compensation expectations Overall competence Role expectations and company growth alignment Salary negotiation and benefits expectations 2 Resume Match evaluation the three most important aspects of a resume are :...

September 5, 2024

Create an Industrial Automation Solutions Website

I want to consolidate my experience and knowledge in the field of automation, and I’ve decided to do this by creating a website. I also hope it can serve as a starting point for offering consulting services. Since this website is content-focused, I chose to build it using Docusaurus and deployed it on Cloudflare. I spent an hour setting up the template and configuring automated deployment. You can now access it by clicking here....

September 4, 2024

A Method for Quickly Mastering the USNR Scanning System

I have never used the USNR Scanning system before. This article outlines my plan for quickly mastering the system and developing the capability for ongoing maintenance and improvement. 1 Goals & Metrics The goal can be divided into two stages : Proficiency : Become familiar with the USNR system as an assistant, understand the manual, learn the operating procedures, and handle common issues. Control : Understand the wood processing steps, and master the role of the USNR system at each step Tasks for Proficiency :...

September 2, 2024

How to Prepare for Data Jobs

Preparing for data jobs means writing a good resume and passing the job interview. I want to take immediate action, so I’ve set the following principles: Time allocation principle: Focus on securing interview opportunities before receiving any interviews; once an interview is secured, focus on interview preparation. Take action first, then reflect and improve as you go. Therefore, we start with the resume, which includes two important factors: A well-formatted resume....

August 28, 2024

Data Jobs in 2024

1 About Data Jobs Data Jobs(like data engineer, data analysis) is still a viable career in the next 5 years, but the job will look very different than it does today. AI tools will automate many of the routine tasks : querying data cleaning data simple exploratory analysis This will free up data analysts to focus on more creative and complex tasks, such as : interpreting results recommending actions for the business As AI tools become more sophisticated, data analysts who have a deep understanding of a particular domain will be able to create more value for their organizations....

August 27, 2024

Creating a Continuous Improvement System

When we want to accomplish something or achieve a goal, sometimes we succeed, and sometimes we face challenges. Can we find a method that makes it easier to succeed? My answer is PDCA(plan–do–check–adjust). Just do it, let it fail if necessary, and then find a new way to fix it. What is a system The goal of all science, is to substitute visible complexity for invisible simplicity. John Baptiste Perrin a system contains 5 part :...

August 20, 2024

Application Integration : it's all about the adapter

Integration development is not a standardized term, so there isn’t a dedicated page for it on Wikipedia. In this article, it defines application integration as the process of enabling individual applications to communicate with each other. For me, integration means adapter. Let me explain it. Basic skills Fundamental skills : Protocols : HTTP, XML, messaging protocols, web services, and web sockets are some of the most common protocols used in application integration....

August 13, 2024

Six Actionable Steps for Finding a Job

Let me introduce six actionable steps for finding a job. 1. get your head right You have to believe that you’re going to get a job. Your job is to control what you can control and to shrink the time between now and when you land a job. 2. just do it if you’re serious about getting a new job, don’t wait to get started. The alternative is wasting years of your life at lower pay with less status....

August 12, 2024