rezha Nanda perkasa, database engineer

About

SQL Programmer | Database Developer | Data Engineer | Design List SharePointServer | Trigger List SharePoint Power Automate

Experience

PT. Sigma Cipta Caraka (Telkomsigma)

Oct 2023 – Present

Yogyakarta, Indonesia

DATABASE ENGINEER

I am database developer, in apps development in design, create db, SQL, creating views, triggers, functions and procedures. So far, I use are: MySQL, PostgreSQL, Ms List, Ms SharePoint, OracleDB, MongoDB. I participated in projects build as: 1.Tiketku ticketing apps for reporting problems/requests from users. This Tiketku apps is part of the Sygap apps. My job is as a db developer from design to db development and help the backend to apps performance. 2. SmartReport SmartReport is of modules of Sygap, which functions to display custom reports. My job as a SQL programmer is to create queries that display report data according to user requests. 3.Gamifikasi Is an apps to get employee activity points. There were 2 development times, first using Ms Power Automate with Ms SharePoint and second using Open Source with PostgreSQL. My job is as a db developer from design to db development and help the backend improve aps performance and create aggregation functions to obtain report data. appropriate and dynamic 4.Digipactum Is apps for legal division. Apps that helps to manage archives and create legal documents by AI. My task is to deploy the OracleDB to the server that it can be directly used or modified/emulated according to the needs of the development team. 5.Redevelopment Sygap Sygap is an apps for ticketing which has several complex functions, at the beginning of the redevelopment of Sygap it was made to have a microsite. Redevelopment include modules: problems, tasks, changes requests, mapping devices (servers, routers, etc) connected to the network via manual or autodiscovery. My job is modify and improve of the existing db and help the backend to improve apps performance. 6.Pertamina AIMS EDC Apps that functions to manage EDC assets sent by TELKOM to registered PERTAMINA gas station. My task is modify and improve of the existing db and help the backend to improve apps performance and create aggregation functions to obtain data reports. appropriate and dynamic.

PT. Sharing Vision Indonesia

Dec 2022 – Oct 2023

Jakarta, Indonesia

DATA ENGINEER

◍ BRIBRAIN GROWTH team at BRI Bank Joined from Dec 2022 - Sep 2023 I am in charge of providing data for data analysts and data scientists. I do big data processing, at most I do more than 3 million rows. I also do SQL query optimization to speed up the running script process. during my time with the Bribrain BRI Growth team, I worked on tables for several dashboards. Here's the table that works: - Table for Analysis of Brimo User Transfer Limit Increase - table for MAP analysis and cohort features in brimo (such as: PLN payment, credit, insurance, et al) - tables for MAP analysis for other products, such as stroberi_kasir and keceku_pari. - Table for AHA analysis of Brimo, Brimola, and Briapi user moments

PT Globalindo Intimates

Jan 2020 – Dec 2022

Klaten, Indonesia

DATABASE ENGINEER

• Design and create ERD databases for application development projects • Discussions with relevant stakeholders for application development • The last project of HRIS has been implemented 50% of all available functions, Here are the functions that have been implemented: - Inputing overtime form from supervisor/Admin department addressed to manager department and HR - Employee attendance - Calculations in the Finance department for BPJS Kesehatan and BPJS Ketenagakerjaan - Updating employees

Education

Duta Wacana Christian University

Aug 2012 – Feb 2019

Bachelor of Informatics, Informatics

rezha Nanda perkasa

database engineer

Skills

Languages