Viko Wijaya

1. Optimized Queue Management in Sync Stock V2

• Increased queue processing speed by 45% by categorizing tasks based on store type, preventing queue congestion
• Reduced setup time by 60% through streamlined environment configuration.
• Employed NodeJS & TypeScript, MongoDB, RabbitMQ, and Docker for tech stacks

2. Streamlined Tokopedia Sync Stock and Logging

• Attained 30% reduction in sync time by refining Tokopedia integration code
• Implemented a focused sync approach, synchronizing only selected product variations, enhancing accuracy and efficiency
• Restructured the logging system for improved traceability, converting consolidated data into individual entries

3. Maintained Audit Trail with PostgreSQL and HStore

• Ensured data integrity by leveraging PostgreSQL's audit trail feature with HStore
• Adapted and enriched the database log, guaranteeing accurate historical records

4. Implemented & Managed Archiving Feature for Performance Enhancement

• Leveraged PL/PGSQL in PostgreSQL to introduce archiving feature, significantly boosting app responsiveness for high-data-volume clients
• Realized a remarkable 60% improvement in performance

5. Database Tables with Partitioning

• Doubled query speed for tables with substantial data by implementing partition tables in PostgreSQL

6. Root Cause Analysis and Remediation for Overselling Issues

• Identified and rectified overselling instances, addressing seller-side discrepancies, marketplace API anomalies, and app-related bugs

7. Customer Service Issue Resolution with JIRA

• Demonstrated in swiftly resolving daily customer service issues using JIRA

1. Develop an Agriculture Investment App:

• Developed a cutting-edge agriculture investment platform from concept to execution.
• Implemented Kotlin for Android.

2. Develop Web with Laravel:

• Utilized Laravel for the web.

3. Streamlined Backend Operations with Go:

• Using Go for backend, and improved system efficiency.

4. Enhanced Data Management with PostgreSQL:

• Implemented PostgreSQL as the database solution, ensuring robust data storage and retrieval.

1. Pioneered API Development for Android FinTech App "Toko Pandai":

• Successfully integrated Bank Mandiri API, enabling seamless transactions between Unilever retailers and distributors through the app.
• Facilitated direct payments and transfers.

2. Introduced PPOB Feature Set:

• Implemented diverse services including Electricity Token, BPJS Kesehatan, PDAM, and Cable TV & Internet payments within the app.

3. Managed Diverse FMCG Portfolios:

• Oversaw a range of Fast Moving Consumer Goods from industry leaders like Unilever, Godrej, Walls, and Lakme.

4. Optimized CSV Import Capability:

• Engineered an enhanced CSV import module capable of handling up to 50 million rows of invoice data using SQL Dump.