Andreas Widjaya

- Handle Project migration database to up version sql server

- Developing High availibity Disaster Recovery to every single database sql server critical or non critical

- Daily improvement performance database

- Handle Deployment integrating application for another division

- Handle problem case daily about sql server

• Manage and develop team member
• Address partner pain point and propose optional solution
• Maintain partner integration due to system changes or API update
• Collaborate with other department for improvement
• Always seek for discomfort area in order to grow and to improve
• Propose new solution to Product Team regarding potential issue from partner perspective
• Designing and implementing RPA for internal data request process with Microsoft Flow
• Creating a company location-based dashboard using data geospatial in Tableau
• Creating and maintaining ETL for business dashboard using hive, spark, SQL and Tableau
• Managing risk data warehouse
• Implement data analytics to optimize spark resource usage

• Critical situation remote and onsite support resource management
• Trusted business advisor to Premier Support Customers (Banking, Oil and Gas Industry) providing valuable guidance around operations and optimization of their IT infrastructure and system.
• Engage with the customer and internal team, maintaining positive perception yet the focused line of communications.
• Managing customer expectations during difficult, unexpected situations.
• Managing the execution agreed plan to achieve service delivery excellence.
• Setup For databases around 20 databases and make each database has a high availability and disaster recovery solutions
• Migration database and implement performance like indexes and tuning performance
• Project: Bank Central Indonesia (bank Indonesia)
• Project: Bank Central Asia (BCA)

• Maintaining datawarehouse production and DRC
• Logshipping datawarehouse production and DRC
• Providing high availability and disaster recovery solution such as backup and restore, replication, log shipping, availability groups, failover clustering
• Database tuning and optimization by managing index, transaction log, table space, and data archiving
• Troubleshooting database issues and deliver enhancements to maintain database integrity.
• Daily report to client about health check system server database
• Daily report to client and project manager about table size on database.
• Project on Commonwealth Bank Indonesia

• Manage batching on core Production system.
• Database administrator SQL server.
• Managing Performance, Managing sizing, Managing Security and permission, Backup and Restore and Deployment
• Database Administrator DB2.
• Managing Performance, Managing sizing, Managing Security and Permission, Backup and Restore and Deployment.
• Administrator BACKUP system (Symantec Netbackup)
• Managing backup daily, weekly and monthly backup
• Administrator AIX OS
• Managing new user and security, performance and Managing sizing file system
• Provide report daily to CIO and AVP about batching performance, Batch job and Timing jobs.
• Make Automation job for batching system from manual. On Ibm aix system.
• Increase timing for batching process and decrease for human errors.

• Developed and design CRM sytem on Salesforce application.
• Developed codes and programing the solution designed.
• Develop CRM for customer (berca hadyaperkasa) to easy manage sales.

• Administrator core system
• Daily job batch system
• Implementation and installation OS linux in every branch
• Installation network in every new branch
• Develop system simple for HR (Human Resources.