Sql Server Data
Resume:
TIM V. DINH
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