Act as the only one data professional for the company's core project team .Responsibilities:Cooperate with more than 20 developers & QAs in the project team and provide database related consulting services in the daily work.Popularize SQL coding standards to the project team.SQL code review - including stored procedures and ad-hoc/hotfix scriptsOptimise stored procedures & embed SQL scripts to make sure the OLTP system works well.Take the repsonsibility to develop those difficult hotfix SQL scripts which normal software engineers cannot handle, the goal is to make sure the OLTP system works in good status - no blocking during the hotfix/patch and all changes could be easily rollbacked.Take the repsonsibility to develop and maintain stored procedures for those high priority reports & dashboards within the OLTP system.Take the repsonsibility to review and develop database schema changes on OLTP system to make sure all changes meet the strandard, no blocking during the operation and rollback-able.Design and develop lightweight data loading solutions within OLTP system to meet specific reporting requirements on the website.

1.Qlikview dashboard development.2.Use Microsoft BI stack to implement legacy reports automation projects.3.Continued to maintain data assets under SQL Server platform for more than half year.

1.Develop and maintain data assets under SQL Server platform, including data issue fixing.2.Develop reports by using Microsoft BI stack.3.Develop new web pages for department report portal by using ASP.NET.

1.Develop and maintain DTS packages under SQL Server platform.2.Develop Sales reports which are based on web page.3.Develop and maintain report portal (ASP.NET).4.Build MIS System iteratively according to customer’s new request.(ASP.NET, SQL SERVER 2005 and JQuery)5.Maintaining the existing MIS System.