Amaris
JUNE 2017 - PRESENT
- Build the data change capture system. I used the built-in feature from MSSQL as CDC and mixed with a custom solution by using trigger. Depend on system requirement, dba will make the decision to using CDC or trigger to capture data change.
- Build the tool to reduce database backup file size before restoring the database in the development environment and developer's pc. I built the store procedure to swap 2 table name ( include all of table constraints ),
- Setup Extended Event in the server to tracking the history of execution store procedure.
- Build the tool to tracking index operational statistic then making the report regarding schema blocking in company's database.
- Enhance store procedure to improve performance in the ERP system.
Amaris
APR 2016 - APR 2017
- Develop Audience Management application
Role: Developer
Management the custom group audience in Amaris.
Design database model and develop an ASP.NET project use: ASP.NET MVC5, Entity Framework, Unit Of Work, Web Api, Store Procedure, Dynamic SQL.
- Develop Communication Management System
Role: Developer
Management all of internal communication in Amaris
Design database model and develop and ASP.NET project use: ASP.NET MVC5, Entity Framework, Web Api, Store Procedure.
- Work 50% in the database team as DB Modeler
K SYSTEM AND SOLUTIONS
FEB 2016 - MAR 2016
Customer: Hyosung Vietnam
Role: Project Manager and Business Analyst
Desc: The project calculate and forecast meal for Hyosung Vietnam
Reponsibilities: Design database, setup database server SQL Server, iis server, support developer enhance their store procedure, config agent jobs .
K SYSTEM AND SOLUTIONS
DEC 2015 - MAR 2016
Customer: K System and Solutions
Role: Project Manager and Business Analyst
Desc: The human resource management system for K System. Then the company sells that solution to another company.
Reponsibilities: Design database, setup database server SQL Server, iis server, support developer enhance their store procedure, config agent jobs, project manager, technical lead
K SYSTEM AND SOLUTIONS
Feb 2015 - MAY 2015
Customer: Hyosung Vietnam
Role: Project Manager and Business Analyst
Desc: Develop a detail of project plan to monitor and track process.
Reponsibilities: Design database, setup database server SQL Server, iis server, support developer enhance their store procedure, config agent jobs, project manager, technical lead
K SYSTEM AND SOLUTIONS
SEP 2013 - APR 2014
Customer: Pungkook Vietnam
Role: Developer
Desc: The human resource management system for Pungkook Vietnam
Reponsibilities: Convert a human resource management system from winform app to web app, improve performance, develop new feature, improve database ( they used Oracle ), develop across database system and transfer data between these database ( Oracle , sql server and sqlite). In that time, I finished a workshop Oracle Database Administration. Then i takeover that project and become team leader in K System and Solution.
K SYSTEM AND SOLUTIONS
MAY 2014 - AUG 2014
Customer: Pungkook Indonesia
Role: Team Leader
Desc: The human resource management system for Pungkook Indonesia
Reponsibilities: Deploy HRM system in indonesia. Custom the system to match with their company policies. Build the service transfers data from finger printer system to HRM system ( From SQL Server to Oracle).
K SYSTEM AND SOLUTIONS
MAY 2014 - AUG 2014
Customer: Pungkook Indonesia
Role: Team Leader
Desc: The human resource management system for Pungkook Indonesia
Reponsibilities: Deploy HRM system in indonesia. Custom the system to match with their company policies. Build the service transfers data from finger printer system to HRM system ( From SQL Server to Oracle).
K SYSTEM AND SOLUTIONS
FEB 2012 - MAR 2014
I worker in that company as developer. I made the android native application for Samsung Vina, the small ERP system for company's customer. In that time, all of project i worked with MSSQL server and ADO.NET. So i have to write store procedure, function, trigger in every project. Then i improve my skills in SQL Server too much. Almost of project is internal system and focus on business logic, so i have opportunity to work witk complex data, complex business logic. It was very good starting for me and improve myself to become a dba.