← Back to list
Middle
Registration: 22.12.2025

Giovanni Chandra

Specialization: Oracle Developer / Business Process Analyst
— Experienced Oracle Developer and Business Process Analyst with more than 8 years of hands-on experience in Oracle Forms, Oracle Reports, PL/SQL, ERP IFS, and HRIS application. — Skilled in analyzing business needs, developing custom applications, optimizing reports, and supporting ERP and HR systems. — Proven track record in automating complex business processes and collaborating effectively across departments.
— Experienced Oracle Developer and Business Process Analyst with more than 8 years of hands-on experience in Oracle Forms, Oracle Reports, PL/SQL, ERP IFS, and HRIS application. — Skilled in analyzing business needs, developing custom applications, optimizing reports, and supporting ERP and HR systems. — Proven track record in automating complex business processes and collaborating effectively across departments.

Skills

Oracle Forms & Reports
PL/SQL
SQL
Oracle
PostgreSQL
MySQL
ERP IFS
HRIS System
JasperReports
Business Process Analysis
Database Migration
Manual Testing
Debugging & Troubleshooting

Work experience

Oracle Developer / Manual Tester
since 04.2022 - Till the present day |Tata Consultancy Services
Oracle, Oracle Forms & Reports, Manual Testing, Debugging & Troubleshooting
Project 1 (Allianz - Oracle Developer). ● Enhanced and Maintained OPUS (Insurance system) using Oracle Forms & Reports. ● Developed customized insurance products and adjusted system workflows to align with business requirements from Business Analysts. ● Collaborated closely with business users and technical teams to gather, refine, and implement system enhancements. Project 2 (Manulife Indonesia - Manual Tester). ● Designed detailed Test Case, Test Scenarios, and Test Scripts based on Business Requirements Documents (BRD). ● Conducted End to End Testing, Including Positive and Negative Test Scenarios for Insurance Systems. ● Identified, documented, and reported bugs and inconsistencies through structured defect management tools. ● Worked closely with developers and business teams to verify fixes and ensure requirements traceability. ● Participated in SIT, UAT, Regression phases, ensuring system readiness for production deployment.
Oracle Developer / ERP Analyst
12.2015 - 04.2022 |Ateja Tritunggal
ERP IFS, Oracle Forms & Reports, MySQL, PostgreSQL, JasperReports
● Developed and maintained application using Oracle Forms & Reports. ● Managed ERP IFS Modules (Manufacturing, Distribution, Finance) for process improvements. ● Conducted system analysis, created functional specs and implemented database triggers. ● Led HRIS (Orange) system migration from MySQL to PostgreSQL and maintained server operation (backup, patching, restore, testing). ● Designed payroll reports using JasperReports, covering full payroll cycle from recruitment to tax calculation. ● Major Achievement: Built a sales annual report application that reduced processing time from 3 days to 10 minutes by streamlining reporting templates across all marketing division.

Educational background

Informatics Engineering
2011 - 2015
Universitas Komputer Indonesia

Languages

EnglishUpper Intermediate