TIM V. DINH

714-***-****

TECHNICAL SKILLS SUMMARY

SQL Server 2000, SQL Server 2005, SQL 2008_R2, SQL 2012, SQL 2014, SSAS, SSRS, SSIS, ETL, SharePoint 2010, Crystal Reports, MS Access, MS Office, Visual Basic, Outlook, Window Servers, MS Cluster. Dynamic CRM 2013, C#, Java scripts.BI intelligent

EXPERIENCE

HMS, Las Vegas. NV June 29- 2015 to Present

.

Creation of user databases, creation of maintenance plans and jobs,

user creation, database log space monitoring and maintenance

24x7 support and high availability options and replication

configuring log shipping and the operational requirements

Archive and Transaction Log Backups, Databases Backups & Recovery

Mirroring, Performance, Scripting Languages, Database refreshes and restores

Job Scheduling, Database Security, permissions, Working with SQL Server always on

Also working with SSIS packages and SSRS Report

Data transfer and ETL using SSIS, Import and export data

Using Flat files, Excel files, Access files with SQL server databases

Create automation SSIS package, use data conversion, split data

Merge data, Error out data, use Script, record counts, files count

Fix length or delimiter files, Header or no Header files, many kind of format files

Create Transaction SQL statements and stored procedures, create variables

Create table, View, Script component, Data source and destination

Create test plans, testing results taking corrective action as necessary

Test and debug SSIS packages. Work with business users

Research new technologies and techniques, correct data and performance issues

Responsible for all data systems, re-indexes, tuning, clean tables fragment

Create client monthly report and yearly report, Dashboard,

Take technical leadership for SSIS packages and migrating SSIS packages

AMT(American Medical Technology), Irvine. CA (contract) April=21=2012 to May 26=2015

Database administrations experience. OLPT, Replication

Maintenance of the databases to include upgrades, T-SQL

Release of database changes as submitted by the development team

Managing multiple RDBMS and multiple database system platforms,

Managing the internal and external database security

Working in a team that delivers a high availability service.

Data transfer and ETL using SSIS, create Schedulers

Creating reports using SSRS and Crystal Reports

Develop SSIS packages using BI Development Studio

Create Transaction SQL statements and stored procedures

Create test plans, testing results taking corrective action as necessary

Test and debug SSIS packages. Work with business users

Research new technologies and techniques, correct data and performance issues

Perform data administration tasks, backups and restore and tuning tasks

Create store procedure, Working with CRM 2013,

F2B Application for tablet use Java scripts code.

Responsible for all data systems, re-indexes, tuning, clean tables fragment

Re-built tables, trouble shoot error, debug, engineer research

Take technical leadership for various projects as assigned

Meritus Payment Solutions, IRVINE, CA (contract) Nov. 2008 to Dec. 21 - 2012

Responsible for performing web development (70%) and DBA (30%) functions for the design, development, and implementation of financial web applications.

Responsibilities included:

MS Dynamics CRM, web site, designer dashboard, created new users, data views,

Business Requirements Documents, implementation of systems and processes.

Data transfer and ETL using SSIS and SSAS, T-SQL

Creating reports using SSRS and Crystal Reports

Developed Web Services and performed deployments

Create Transaction SQL statements and stored procedures

Analysis, design, and development of sequence diagrams and classes

Wrote code for data access, business and service components.

Write unit test scenarios and conduct unit testing

Establishing user permissions and monitoring the database for performance

O’Neil Data Systems Inc., Los Angeles, CA April 2005 to Aug 2008

Responsible for web development and data management of data driven publishing and online print services applications

Microsoft Dynamics CRM customization in .NET environment and data extraction for reporting

CRM reports, designer applications, created new users, view data

Created tables, DTS packages, and triggers, T-SQL

Used DTS to transfer data between database servers.

Performed query optimization, data extraction/ETL using SSIS

Created reports using SSRS and Crystal Reports

Establishing user permissions and monitoring the database

Create Transaction SQL Statements and store procedure

Developed Web Services, Performed Deployments

Toyota Headquarters Torrance, CA (contract for IBM) April 2004 to Feb 2005

Responsible for development of web based application for Toyota dealers, using SQL Server 2000. Other responsibilities included:

Creating tables, packages and triggers

Query optimization

Creating views for Crystal Reports use

Establishing user permissions and monitoring the database

Performing backup and recovery as well as query tuning

Monitoring Transaction SQL Statements

Bolsa Medical Center Garden Grove, CA (contract) Nov. 2003 to Feb 2004

Programming Lead responsible for converting 53 tables and .5 GB MS ACCESS database to SQL Server. T-SQL, Used Erwin to design database structure, create view, create stored triggers, and tuning. Created scheduled tasks and performed DTS. Used Crystal report 9 to create doctor billing and VB.NET to develop application for use in the doctor’s offices. Also responsible for Backup and Recovery Disaster.

Metlife Investor, Newport Beach, CA March 2001 – July 2003

Lead Developer (70%) and DBA (30%) responsible for converting MS ACCESS data to SQL Server for the Newport Beach office. Also used Visual Basic to convert flat files from an IBM Mainframe to SQL Server, T-SQL, for the Los Angeles office. This included designing the database structure, creating views, creating stored procedures and triggers, tuning, creating scheduled tasks, DTS, fail over cluster, upgrading SQL 7 to 2000, capacity planning, disaster recovery, backup/restore, profiler, performance monitoring, and VB/ASP programming. Other responsibilities included installing cluster service, configuring AWE memory, configuration of the SCSI Device, configuring the Node1, Node2, dish sharing, Sans, writing transactions, building Crystal Reports vs. 8, handling daily production issues, setting up user permissions, creating Visio diagrams, ER modeling, data flow diagrams, optimization and performance tuning. Also designed Data Warehouse, using storing cubes in a MOLAP structure and creating storing partitions. Created DTS, Support .NET and VB application.

American Benefit Mortgage Aliso Viejo, CA May 1999 to March 2001

Designed data structrure for mortgage application stored in SQL Server 7, which required strong mathematical skills. Converted MS ACCESS mailing database to SQL Server 7 to utilize in their marketing campaigns. Other responsibilities included, creating tables, working on SQL physical and logical data, performing optimization tuning, creating stored procedures, creating views for Brio reports, creating login and user permissions, monitoring the database, backup/recovery and transact (T-SQL). Used DTS to transfer data between Database Server to another database server.

Mintaka Technology Group Los Angeles, CA (Contract) March 1998 to April 1999

Instrumental in the development of a $20 million small business accounting software package. Mainly focused on designing the database structure in a SQL Server 7 environment. Invovled in working on physical and logical data, data modeling, backup, DTS Tuning and creating Stored Procedures using Parameters, Triggers, Use Profiler, Copy Data, Restore, and Create View for report. Built class module in VB 6, coder and testing. Used Silver Run to design data structure.

Medi-syn Buena Park, CA (Contract) Feb 1997 to Jan 1998

Worked hand-in-hand with the CEO to convert doctor billing software from MS ACCESS 97 to SQL Server and Crystal Reports. Responsibilities included creating a database, restoring a database, backup, data design, creating tables, Index, Schemas, Trace, Primary Key, Constraint Relationship, Tables-to-Tables, creating Stored Procedures, use of Parameters, and setting up User Role. Also worked with SQL Server 6.5 to create a Trigger, Insert, Update and delete functions. Other functions included:

Enforcing Business Rules with Triggers

Viewing a Stored Procedure

Recompiling Procedures

Modifying and renaming a Stored Procedure

Programming Stored Procedures

Creating a Stored procedure that uses parameters

Use of the database Consistency Checker

Backup and Restore, Logins, Security in SQL Server, Permissions

DATA Transfer ring & Scripting Object

Monitoring the Server

System Procedure & Function & Transaction SQL Statements

Performing installation upgrade from a previous version of SQL Server and tuning

Extensive use of mathematical formulas

International Rectifier EL SEGUNDO, CA (Contract) Jan 1996 – Feb 1997

Working in a 500 + GB environment, one of four responsible for migrating several MS ACCESS 97 databases over to Oracle, which was the new backend being employed on this company’s web site. Also modified and fine-tuned various MS ACCESS reports, then converted them into (PDF) format in preparation for a new printing of one of their standard internal catalogues. Also used MS ACCESS’s reporting features to retrieve data now located in Oracle database.

Xerox Corp EL SEGUNDO, CA. (Contract) Nov 1993 to DEC 1995

One of six DBAs primarily handling DBA Backup issues. Other responsibilities included creating a database in MS ACCESS, data design, creating tables, Index, Schemas, Primary Key, Constraint Relationship, Table-to-table, data analysis, customer technical support, creating a Stored procedure that uses parameter, setting up user permissions, DATA Transfer ring & Scripting Object, Function & Transactions, creating MS ACSESS reports, entering coder access application and combining code, controls, and messages. Environment consisted of Windows 3.11, Windows 95, Visual Basic, SQL Server 6.5, Remote Access, Rumba and Remediation.

EDUCATION

PROFESSIONAL TECHNICAL SCHOOL (C.L.C), Anaheim, CA, 1993

Rancho Santiago College, Santa Ana, CA 1984

Contact this candidate