Sql Server Information Technology

AI CHEE TEH

*******@*****.*** 949-***-**** Irvine, CA

CAREER OVERVIEW

Experienced and versatile information technology specialist. Broad knowledge of systems, servers, hardware, software, networking, virtualization, file distribution and database. Extensive experience in database and web application development. Solution providers for all IT projects. Possessing strong troubleshooting, planning, problem resolution skills and the ability to work independently.

TECHNOLOGY PROFILE

Systems: Windows (XP, Vista, 7, 8, 10), Linux Server (Redhat, Ubuntu), Windows Server (2000/2003R2/2008R2/2012R2)

Servers: MS SQL Server (7/2000/2008R2/2012/2014), IIS Web Servers, File/DFS Servers

Network: LAN, WAN, MPLS, VPN, TCP/IP, HTTP/HTTPS

Hardware: Desktops, servers, firewall, routers (SonicWall/m0n0wall) and switches

Technology: Microsoft SSRS/SSIS/DTS, SQL Management Studio, SQL Server Data Tools, Microsoft Visual Studio, SugarCRM, SalesForce, Goldmine, SharePoint, Kentico, FogBugz, Pardot, Tableau, Microsoft Office Suits and Office 365

Language: SQL (Stored Procedure/Trigger), ASP.NET (C#/VB), PHP, Java Script, PowerShell, batch

WORK EXPERIENCE

VTI INSTRUMENTS CORPORATION (2000 – 2017), Irvine, CA

Division of Ametek, a $4B global manufacturer of electronical instruments, VTI is a $30M worldwide manufacturer of precision modular instruments and systems for electronical signal distribution, acquisition, and monitoring, used in the world’s most demanding test applications.

ACCOMPLISHMENT

- Leading and managing many successful development, implementation, deployments and migration projects for different functional departments using the SDLC methodology

- Design, develop and tuning the databases for custom built web application

- Maintain the backend databases for business-critical systems

- Perform data extraction and migration to conform to the business unit integration plan

- Launch reporting servers and create custom scheduled reports based on the need of all functional departments, which are essential to strategic planning

- Replace all outdated VB programs with custom web applications written in C# (such as RMA and production workflow application) for portability

- Integrate multiple system (CRM, CMS, quoting system, marketing automation tool) databases to achieve the goals of processes automation and manual work reduction

- Create t the new functionalities in CRM to facilitate the sales process as well as align with the defined sales philosophy

- Establish, implement and support the company IT LAN and WAN infrastructure (between sites - Irvine, CA, Valley View, OH and Bangalore, India) as well as design the IT Disaster Recovery Plan to ensure business continuity

- Ensure that all server hardware, operating systems, software and procedures aligned with organizational standards and strategic business plan

- Create and maintain the backup recovery jobs for various file, database and Hyper-V servers

- Work with financial controller on yearly IT budget

- Manage part-time IT supports and outside consultants to achieve goals and objectives

EDUCATION AND TRAINING

CALIFORNIA STATE UNIVERSITY, LONG BEACH

Bachelor of Science

Major: Management Information Systems

Minor: Computer Science

OCP (Oracle Certified Professional)

Passed 1Z0-001/INTRODUCTION TO ORACLE: SQL and PL/SQL – January 2000

Passed 1Z0-010/DEVELOP PL/SQL PROGRAM UNITS – February 2000

Microsoft Certified Technology Specialist

Passed Microsoft Exchange 2007: Configuration certification – May 2009

Microsoft Certificated of Achievement Courses

Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services (QuickStart, 2013)

Microsoft SQL Server 2008 Business Intelligence Bootcamp (QuickStart, 2013)

Contact this candidate