Lan — System Analyst

WWW.UNIMALL.COM.TW, Taipei, Taiwan System Analyst, Management of Information System Division - MS SQL Server 2000/2005 Management - ERP services design and deployment - Microsoft server 2000/2003 administrator - Reporting services with DTS in SQL 2000 and SSIS in SQL 2005 - Oracle 8.17 Management - IIS5.0/IIS6.0 Administration - Network design and Management (Including load-balance and NAS) - WIN32 GUI based on VB.Net 2005 for management and security purpose. - ASP - Electronic Direct Mail distribution service - CRM system management Achievements - Systematic reporting service: Apply DTS and SSIS to design and generate marketing periodical statistic analysis report. - Microsoft Server 2003 and 2000 in HP DL580/380 G3/380G4 Server management and tweaking. - CRM Service SQL Server performance tuning and security improvement: Utilize SQL Sever Profiler to identify inefficiency queries and discover potential malicious user activities. - Web service network design and improvement. - Electronic-Invoice project for company tax report

12/2008 - 2/2009 PeachesUniforms, Dallas, Texas SQL Server Developer, Information Technology Team - MS SQL Server 2000/2005 administration and management - Programming in SQL Server ETL, DDL, DML, procedure, and trigger. - SQL Server 2005 Integration Service(SSIS) package - SQL Server 2005 Distribution Transportation Services(DTS) Package - SQL Server 2005 Reporting Service(SSRS) for OLAP reporting services - CGS BlueCherry 6.0 ERP System administration and management - Programming in VB.Net, VB Script and ASP. - MS Server 2003 ADUC, Site and Service administration and management - MS IIS 5.0 and IIS 6.0 management - MS Server 2008 administration and management - WebsitePipeline website configuration - EDI data exchange Achievements - Design and established data exchange mechanism to WebsitePipeline: SSIS and DTS packages in SQL Server 2003/2005 - Design and established data exchange mechanism to Customers: SSIS and DTS packages in SQL Server 2003/2005 - Systematic reporting service: Apply SSRS and SSIS to design and generate marketing periodical statistic analysis report - SQL Server 2000/2003 backup and disaster mechanism design and implementation - IIS 5.0/6.0 Web site and FTP site administration and management - MS Server 2003 ADUC, Site and Service administration and management - Help desk support to end users

TWN mCommerce & Technology Co., Taipei, Taiwan 1/2006 - 5/2007 Software Engineer, Software Development Team - RFID technology application in warehouse merchandise and personnel tracking - GIS system integration Achievements - RFID in field service: Leading 3 programmers in tracking valuable assets and personnel in the semiconductor construction site in Taiwan and China. Base on RF Code RFID product, Zegbee, VB, ASP.NET, and GIS system, deliver just-in-time information to ASP page, WIN32 Applications, and PDA devices. - RFID in mail tracking: Testing semi-active Activewave RFID for register mail for central post office in China

4/2001 - 12/2002 Fortune Transportation Group, Taipei, Taiwan Manager Assistant, Business Develop Team

Republic of China Military Police, Taipei, Taiwan 7/1999 - 4/2001 Corporal