When the Doctor’s Name Was a Mess: How I Built a SQL Pipeline to Fix Broken Reports

"I wanna ask something about this signature section in this print, why the doctor's title is behind the name, isn't it supposed to be in front?"

That simple question that made me questioning myself.

I work at government hospital as a system support, which mainly analyzing user request, publish a ticket, doing manual testing and deliver changes to user. For these past 2 years, i've been placed in a project for digitalizing medical check up system.

• manual mcu ada resumenya

• ada section tanda tangan dokter di akhir untuk melegalkan dokumen tersebut

• nama dokter diambil dari tarikan data pada database

• ternyata nama di tabel itu tidak rapi, ada gelar didepan di belakang

• kami semuau baru sadar, termasuk client

• akhirnya pipeline tarik data dr sql -> cleaning di power pivot -> handoff ke programmer -> bbuat tabel baru -> penyesuaian kodingan

nah itu inspired me for this project