About Me
I'm currently working with a company dealing with supply chain logistic. It manages the product from production until to the final customer delivery. Were providing the customer data sets or reports for analytics. They understand, study, fore...
My job in this great company is to provide the customer a data set and reports. I am good in generating data sets using SQL scripts. By understanding the business process in the front-end and data flow from the back-end, I can easily write the data sets even the requirements is complex like crosstab and graph reports.
I'm also assisting web team by providing stored procedure. The script result I'm providing is already a table, meaning no process happen in the front-end, all process happens in the stored procedure I provided. I also tuned the script before I release to the team. Four seconds above waiting time is not acceptable.
I also generate XML file from SQL, this XML file is the booking request and shipping instruction transmitted to the portals or carriers. I also setup the FTP and communicate with the third party for configuration.
Lastly, I mainted all the database server using MSSQL and MySQL from SIT, UAT and PRODUCTION. I've also created and maintained a replication server to remove all auto generating report from production to lessen the work load.
Show MoreSkills
Web Development
Others
Database
Game Development
Positions
Portfolio Projects
Company
Combined all database into one database using views.
Description
This a sets of databases that is combined into one database using views.
Show More Show LessSkills
SQLTools
MS SQL Server SQL DeveloperCompany
User SQL Functions
Description
Created user function that everyone can be use. Just put in the necessary parameter to get the desired result.
Show More Show LessSkills
SQLTools
MS SQL ServerCompany
View XML file into PB application
Description
Use OLE object to view XML file from the application using POWERBUILDER tool.
Show More Show LessSkills
Power BuilderTools
MS SQL Server