Michael Tuan

** ****** ***** ****

Arcadia, CA **006

Tel: 626-***-****

Email: ac5i86@r.postjobfree.com

OBJECTIVE To acquire a position in a company where I will be able to contribute and utilize my skills. Display my highest efficiency in an environment and obtain professional and personal growth.

TECHNICAL SKILLS

Operation System:

Microsoft Window 95, 98, XP, Vista, Window 7, 8, (NT 4.0, 2000, 2003, 2008, 2012), Mac OS X.

Application:

(Microsoft Outlook 2003, 2007), Active Directory, SQL 2000, (SQL 2005, 2008 SSIS, SSRS), (MS Office 2000, 2003, 2007, 2013), SharePoint 2007, 2013.

Networking:

TCP-IP, OSPF, IGRP, EIGRP, NAT, DNS, DHCP, FTP, WIN, IIS, (Cisco Firewall, Switch, Router, VPN Client, Site to Site VPN)

Language:

C++, .Net, HTML, SQL query, Java Script, HTML, R

Hardware:

Notebook, Workstation, Server, Printer, Monitor

Others:

Maintain, configure and operate disk array data storage, Project Management Professional (PMP), CISSP

CERTIFICATION

Cisco CCNA #CSCO10507584 April 2002

Microsoft MCSE-2003 #3593340 March 2007

MCITP Microsoft SQL 2005 Database Administrator #3593340 Feb-2009

Microsoft SQL Server 2005 - Implementation and Maintenance

Microsoft SQL Server 2005 - Designing a Database Server

Microsoft SQL Server 2005 – Optimizing and Maintaining a Database Solution

EDUCATION B.S. in Computer Information Systems 07/93 – 12/97

Columbia College, Missouri U.S.A.

EXPERIENCE

United Health Care Group Pasadena, California 11/17 – Current

Senior IT DT Data Analytic Analyst

Develop Ad-hoc T-SQL queries reports from different Database export to excel file or SSRS 2012

Recommendation of Data Modeling change

Troubleshoot data workflow and identify issues

NordStrom. San Bernardino, California 05/14 – 02/17

IT / Data Analyst

Maintained / Support HighJump WMS through SQL 2008

Work with Service Now ticketing system and SSRS to provide analytic KPI dashboard reports support leadership and management team

T-SQL programming query optimization experience

Follow all established processes and procedures to ensure the integrity of the data.

Troubleshoot WMS workflow and identify issues

Develop Ad-hoc T-SQL queries reports from different Database export to excel file or SSRS 2012

Provide insight and analysis into data and findings in support of analytical research

Measure and Analyze results from different database models and continuously Improve model efficiencies

.

Working in collaboration with sales, operation, shipping (warehouse) and other departments on variety analytic projects

Arena-Maxtronic, Inc. Azusa, California 08/11 – 04/14

IT / System / DBA Admin(Fiber RAID subsystem & NAS)

Install Window 2008. SharePoint 2007, 2013, MS SQL 2008 / 2012

Design and deploy helpdesk ticketing system with SharePoint 2007 / 2013 for customer service department with ITIL processes.

Modify and maintaining existing databases

SQL mirroring / replication setup, index / performance tune up

Examine and evaluate for various business departments across organization for writing, generating, analyzing reports with summaries, trending, recommended, improvements to business process.

Working with Visual Studio create SSRS, SharePoint, Info Path, reports.

Filter and “clean” data, review reports and performance indicators to locate and correct data problems.

Develop, Design with SSIS packages to perform the ETL process.

Using SSIS for data replications, reporting on SSRS 2008, SharePoint 2013.

Using SSIS to develop work flow for documentation data transformation process automation.

Using SSIS for stored procedure for data cleaning or standardizing data building.

Develop different data interfaces (ODBC, Flat File, ADODB, Excel, Access) with Microsoft Analysis Services cubes dataset with SSIS

Data modeling and data structure modfication to meet business requirements

Hewlett Packard Enterprise Services, Monrovia, California 02/10– 5-10

IT – System Administrator (Contractor)

Maintaining Active Directory, User account (renaming, disabling, deleting.)

Install Microsoft Server 2003 OS with Servers

Troubleshoot with printer issue

One West Bank (used to be IndyMac), Pasadena, California 03/09 – 07/09

IT – Security (Temp)

Configure Active Directory Site and OU structure

Assign user and group with administrative templates

Assign user permission on SQL 2000 & 2005 using query for SSIS, store procedure, triggers, report service, stored procedure

Genesis Security, LLC, Pasadena, California 05/07 – 12/08

IT Supervisor

Troubleshoot and maintain Server 2003 with DNS, DHCP, FTP, WIN, IIS & assign user, resources, permission

Troubleshoot and maintain SQL 2000 & 2005 & using query, SSIS, store procedure, triggers, report service, alert, stored procedure

Troubleshoot and maintain with asp.net company internal report site

Troubleshoot, maintain, backup, restore, archive for database, table, view, snap shoot

Create cluster index, non-cluster index on table for better query performance

Contribute to report design and automation using best practices to meet business needs

Collaborate within a team environment to examine the unique needs and concerns of a business or technology area to develop relevant and repeatable processes and procedures for preparing reports and departmental metrics.

Perform Data Analysis and Data Modeling to create Sources to Target mappings ETL process with SSIS.

Using SSIS to create SQL stored procedures to keep data integrity.

Using SSIS and create documentation of ETL processes with operation process flow diagrams.

Use SQL Server Agent to schedule execute SSIS packages.

Writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS)

SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects to SSRS 2005, Info Path, Web application, Excel, reports.

Tuan Tea Enterprise. Santa Monica, California 12/05 - 3/07

Infrastructure Support

Create, Backup, Restore Active Directory meet company’s requirement

Installing and Managing Active Directory Domains, Trees and Trust Relationships

Configure Active Directory Site and OU structure

Design and Planning Group Policy with administrative templates

Lanner Electronics, Inc. City of Industry, California 07/05 - 11/05

IT System Engineer (Network Security Hardware Platform)

Understand network security hardware/software and its market.

Assign Active Directory OU for each company department with external trust relationship to outside vendor

Link Active Directory GPO resources to company, site, domain, OU

Arena-Maxtronic, Inc. City of Industry, California 01/03 – 10/04

IT Support (RAID subsystem & NAS)

Technical support on RAID products

Maintain customer relationship

Lead product engineer to support customers

Part II Research, Inc. Los Angeles, California 09/98 – 12/02

Technical Support (USB & FireWire Enclosure)1

Searched potential customers

Monitored product development based on customer’s needs

Maintained customer satisfaction

Service professional computer knowledge and skill

Contact this candidate