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...livery. Were providing the customer data sets or reports for analytics. They understand, study, forecast, improve and optimized their resources for better result with the data analytics were providing.

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.