Afriza Harahap

At PT Bumi Indah Saranamedis, I turn department requirements into specifications, enhancements and ERP modules for warehouse, procurement, finance, HR/payroll and operations. I administer the in-house systems and support IT for the group's manufacturing company.

I designed data synchronization across branch ERP databases, a staged SQL Server database and a PostgreSQL web database, sending financial data to the management dashboard every 10 minutes. I also write SQL for reporting, reconciliation and data integrity, and resolved structural data issues affecting financial closing accuracy and management reporting.

I cut work-order processing time from 3 hours to under 1 minute and procurement document transmission from 10 minutes to 30 seconds. I also designed and built an HR and payroll module covering payroll calculation, PPh 21, BPJS and leave approvals, integrated with accounting.

As a concurrent Systems Architect & Technical Advisor at Regulated Services Company, I mapped 18+ business domains and their rules before development began, and designed operational workflows for field users. I build the platform with Next.js, NestJS, PostgreSQL and Prisma; I'm available for part-time and project-based B2B contract engagements, working remotely from Jakarta.