• Installation, Service Packs and Configuration of Microsoft SQL Server 2012 R2 and SQL Server 2014• Upgrade and Migrate of SQL Server databases from SQL Server 2008/2012 R2 to SQL Server 2014and maintenance Run-book• Collect and analyze data, develop and supply optional time, cost and logistics network/solutions• Create marketing trending report by using Tableau, SQL Server Report Service (SSRS) and SQLServer Data Tool (SSDT)• Perform data partitioning for efficient management of database tables and indexes• Build analytical model based on shipment data to determine the better decision of transportation• Provide client customer service, order processing, documentation, and sales support• Troubleshooting of complicated logistics issues, resolving them in a cost effective manner.• Conduct cross-functional projects and determine priority and potential conflict of multiple projects andto deliver in a timely manner• Perform data partitioning for efficient management of database tables and indexes• Obtain, track, and analyze orders to ensure customer satisfaction• Perform project management tasks including milestone tracking and daily follow-ups with team members and customers

• Created an automated script in Java to aggregate financial data for stock portfolio • Developed routing data collections application to improve stock price movement prediction efficiency • Increased effectiveness of financial data analysis by implementing algorithms and optimizing data updates with MySQL

• Digitalized existing customer related datasets with Excel and R then archive it into a SQL server• Built predictive model on top of the digitalized customer datasets with R and several in-house R libraries• Provided a better strategy on target selection based on the predictive model for the sales team