Sr. DBA
Resume:
Trung Duong
Coon Rapids, MN 55448
Email *********@*****.***
Summary:
A Sr. Programmer, MS SQL DBA, Database Architect, Analysts, and project lead background. Over 14 years of practical IT experience specializing in application architect/development using Microsoft and Oracle products and tools.
Technical Skills:
Development Technologies VB, ASP, SQL, MDX, XML, HTML, DHTML,C, C++, Visual C++, VBA, VB Script, Shell Scripting , Data Modeling, Data Warehouse, J Script
Development Products Microsoft SQL Server 6 to Microsoft SQL Server 2005, Microsoft Visual Studio .NET, MS.Access, Informix-4GL, Crystal Report 11, Business Object, ERWIN, VS.NET, Oracle10g, PL/SQL, APPLIX, DBArtisan and Embarcadero DB suite.
Skills Years Note
Visual Basic 10 Started with first Release to version .net 2005
MS SQL Programming 10 Version 6.0 to 2005
MS SQL DBA 6 Version 6 to 2005
MS SQL Reporting Server 2
Database Modeling +7 Logical and Physical
MS DTS/SSIS 5 Version 7.0 to 2005
ASP 2 B to B site and Intranet Reports
XML 0.5 Used with VB and SQL
HTML & DHTML +7 Now I usually use front page GUI to create it
Crystal Report 7 Version 3.0 to Version 9.0
MS Access +9 VBA
Visual C++ 2 I still stay current with the latest IDE
Informix 4GL 1 Programming / Analyst/DBA
Unix Shell Script +4
TSQL 11 Microsoft Transact SQL
OLAP 2 Microsoft Data warehouse Data Mart (Star Schema)
ERWIN 6 Data Modeling tool
Project Management 4 Full Life Cycle Development
Extra Quick App 4 Screen scrape program from Attachmate
FarPoint 1 List Pro,TabPro, Spread activeX
Visual Source Safe 5 Mostly for Visual Basic + Visual C++ Code
MS Office 8
MS Project 6 Project Management and Scoping
VB.NET & ASP.NET 4
Visual Studio .NET 4
ORACLE 10g 3
APPLIX .5 Latest version
Performance Center and DB Artisan 2 DBA
SQL Express 3 DBA
VB.NET Build IT .5 Source Save Manager
SQL Report Server 2
Excel 9 VBA
Experience:
AGA Medical. Sr. DBA/Programmer/Developer Nov2007-Current
MS SQL Server cluster system design/development/DBA and also Oracle DBA
Created MS SQL server 2005 Cluster system and migrate MS SQL server 2005 and 2000 database and DTS/SSIS to the cluster environment. DBA Oracle server 10g. Manage and monitor MS SQL Server and Oracle via Embarcadero Performance Center and DB Artisan. Installed and maintain Oracle Agile system. Install, maintain, and develop BI reports. VB.net/ASP.net programming of SQL server hardware/software inventory application for IS/IT use. Create new and manage legacy reporting services. Create extensive ETL to migrate data multi database type to JD Edward. Also utilized SSIS VB scripting to automate ETL data from data vendor in Canada into Clindex application database (Sybase). Created scripts for a more robust and comprehensive Sybase backup process for compliance with FDA.
Medtronic Inc. Sr. DBA/Programmer/Developer Aug 2006-Nov2007
MS SQL Server cluster system design/development/DBA and also Oracle DBA
Created MS SQL server 2005 Cluster system and migrate MS SQL server 2005 and 2000 database and DTS to the cluster environment. DBA Oracle server 8,9,10. Created extensive VB.net and ASP.net application to help manage and process large number of databases.
Data Recognition Corporation, Inc. Sr. DBA/Programmer/Developer July 2006-Aug 2006
BI, Data Migration, and SQL reporting services programming
Used MS SQL server 2005 database and Integration Service to move data from flat files to the reporting database. Created report using reporting service. Designed a star schema data warehouse to house these data in the reporting database.
Smiths Medical MD, Inc. Sr. DBA/Programmer/Developer June 2005-June 2006
Astro Medical Pump Database Design/Application Programming
Designed, created and DBA MS SQL database for redistribution with MSDE Server and for SQL Server 2000 database for centrally connected system for use in Medical pump programming and log recording. Also used VB.NET to create middleware objects for other programmers to access the database that included stored procedures and Crystal Report objects.
Install application programming was also part of my work at Smith Medical. The installing packages include the installation of MSDE server instance and setting up of the database via setup application.
Boston Scientific Corporation Sr. DBA/Programmer/Developer (YORK) Jan 2004-June 2005
TAXUS Database DBA and Application Review/Redesign
Created database Monitor/Maintenance/Documentation/Backup/Security/Archive support routine using tools such as DBArtisan, ERWIN and Model Mart, VB.NET, in SQL 2000 enterprise cluster environment. I participated in architecting, designing and creating TAXUS archiving and reporting system that are “21 CFR Part 11 Electronic Records; Electronic Signatures” compliance. I also participated in designing new Multi tiers VB.NET application and new TAXUS databases that are “21 CFR Part 11” compliance. I also made suggestions on database design and data collection scheme for use in the APEX project. Created countless quality and production reports that are 21 CFR Part 11 compliant using ASP.NET, VB.NET and Access. The creation of reports also included designing and writing validation processes and most of the time performed the validation. I also worked with the quality group to generate and file most of project and change request documents for “21 CFR Part 11” compliance.
Health Partners Sr. Programmer/Developer/DBA (SIGNATURE) Nov 2003-Jan 2004
RX (McKesson Pharmacy 2000) Report System
Designed and implemented a reporting database by mining time sensitive related Pharmacy service measure data from MS SQL2000 database using complex stored procedures and DTS packages. I used Erwin to design the reporting database to hold the reporting data. The DTS packages and all the stored procedures are scheduled to run nightly using MS SQL Scheduler. I also temporarily acted as a DBA for this MS SQL 2000 server and McKesson Pharmacy 2000 MS SQL 2000 server for the duration of the development of the report database. The DBA duties included setup permission, backup, create database and monitor for performances.
Designed and implemented a reporting application front end using VB.NET and Crystal 8.5 to serve the data to administrative users.
Kraft Food Sr. Programmer/Developer/DBA (RCG) Oct 2003-Nov2003
Sale Data Migration
Design and implement a reporting database by mining time sensitive related sale projection data from DB2 and MS Access database using complex stored procedures and DTS packages. I used Erwin to design the reporting database to hold the reporting data. Also I converted complex mainframe SAS and Natural application that processes again this set of data into MS Stored Procedures and VB.NET data object. The DTS packages and all the stored procedures are then schedule to run nightly using MS SQL Scheduler. I also act as a secondary DBA for this MS SQL Database. The DBA duties included setup permission, backup, and monitor for performances.
Designed and implemented a reporting application front end using VB.NET and Crystal 8 to serve the data to administrative users.
Design and build a reporting Excel application for sale force to submit their sale. The data then also link and extract to MS Access for review and finally the data are migrated to MS SQL Server Database.
Target Corp. Sr. Programmer/Developer/DBA (CDI) Feb 2003-Oct 2003
EMac Reporting Application
Designed and implemented a reporting database by mining time sensitive related data from an Emac (CRM type of application) MS SQL database using complex stored procedures and DTS packages. This reporting database falls just short of a data mart type reporting. Where data is viewed in a summarized multi-dimension manor. The challenge of building this database is the poor initial data collection from the CRM application. I used crystal reports 8.5 and stored procedures to create a report against this reporting database. I also utilized Erwin 3.5.2 to modify current data design to meet the report need. I finished working on a VB.Net front-end application to manage all the crystal reports for a hand full of upper managements. There is the possibility that this VB.NET application will be convert to ASP.NET and deploy as an intranet application. The ultimate result of this reporting application is to measure the performance of difference levels of operation down to individual user.
Common Sign Application
Re-designed & Re-formatted Sign Template by data manipulation DB2 and Access database using via Access dSign application.
Also Currently, I am creating a dashboard to report on summarized data that are extracted from DB2 database and download into Access database. Using Access database ODBC link and platinum query tool, Using those tool, I am able to identify the best way to mine the data from the sign/pricing tables for monthly summary report. I created an Access reports front-end application for local users that have experiences in using Access. The local Access application is used for extracting and verification of report data. I also created the secure VB.NET dashboard front-end to manage crystal report 8.5 reports accessing Access data for deployment externally from the group.
QSI. Sr. Programmer/Developer/DBA (LED) Jan 2003-Feb 2003
Skill Search Application
Created and changed an application using MS Access 2000 to assist headhunters to store their professional information and for searching and matching these professionals to the project request. These data were migrated from other access database and excel. The migrated data were clean and parsed before apply to the production database. The applications are written using Access VBA. There are approximately 10 forms and a hand full of reports in this application. The Access database resides on the server and Access VBA application are installed on the local PC. The application is currently being use by 15 users.
Valspar. Sr. Programmer/Developer/DBA (CDI) March 2002-Jan 2003
Helpdesk Registration System
Designed and implemented a helpdesk registration system. Used Oracle 8i database and Oracle 9i J Developer to create an intranet site for the Valspar helpdesk via Apache/Tom Cat application server. The application contains many java server pages that include a number of Java Beans business objects authored by me. This application can be accessed all around the world by Valspar Employees. This application allows factory employees to log in and register errors to ask for help from the main office in Minneapolis. Most of the logged questions range from complex chemical formulas to basic issues with the PC. The collected Helpdesk data are processed and inserted into the Applix’s Helpdesk database that resides on the Oracle8i server. I also used Erwin to reverse engineer the Oracle8 database and modify the database to accommodate new data the application collected.
Service Agreement Management System
Consulted, designed and implemented Service Agreement Management System (SAMS). Using Erwin for doing logical and physical designing of SAMS database on Oracle9i. Employed Oracle9i as main database engine to server SAMS data. Utilize Applix Development Studio to create front-end application and Crystal report like reports. Using extensive experiences in data migration and transformation skills, I also did data migration planning and development to move data from AS400 to Oracle using Oracle loader and PL/SQL. Developed a VB.NET service application to help Applix application send crystal reports to the fax server.
Imation. Sr. Programmer/Developer/DBA (LED) July 2001-March 2002
Production Test Lab Automation
Consulted, designed and implemented lab equipment automation for tape testing. Used Visual Basic 6.0, MS Access 97, Erwin, ADO, and Omnic software to create a streamline user interface that interacts with highly sensitive spectrum analyzer. This application was able to setup, test, records, and calculates the spectrum from the spectrum analyzer and save the result in MS Access database. This program is being distributed to Imation Quality Test Labs at it’s manufacturing sites in Camarillo, California. My involvement included research in Imation production testing lab method, data modeling using ERwin, UI design, coding, and deployment of the application
US BANK CORP. Sr. Programmer/Developer/DBA (LED) March 1998-October 2001
Merchant Loan Application Authorization Automation
Architect, implemented, and administered a MS SQL 7.0/2000 database. This was an enterprise level, high performance, mission-critical, almost real time online decision system in merchant sale loan application processing for US Bank Corp. Utilizing Visual Basic 6.0, ADO, MS SQL Stored Procedure and Trigger (TSQL) as the programming language, MS SQL 2000 as database, Crystal Report 7.0, ERWIN DB modeling program, and other third party software (Fair ISSAC, Far Points Products) to create the merchant sale program. The data were migrated (ETL) from old Excel spread sheets, Access database, Btrieve database, Paradox database, and mainframe using MS DTS, BCP, and old fashion VB programming. This program is able to collect applications and credit bureau information on line and makes decisions to approve or decline merchant loan applications at almost real time using the US BANK Corp. business logic. This program also generated reports using Crystal Report 7.0 for managers and also government’s agencies. My involvement for this project included research in US Bank business rules, relational database modeling using Erwin, coding, and deployment of the application.
Credit Card Application Authorization and Booking
Involved in streamlining Credit Card Booking system. Using Visual Basic 6.0, ADO, MS SQL 7.0/2000 & Stored Procedures (TSQL) as programming language, MS SQL 7.0 as database, Crystal Report 7.0, Extra Quick APP by Attachmate Screen Scrape, ERwin DB modeling program, and other third party software. The database was logically designed and physically created by using ERWIN tools. The data was converted clean (ETL) from Excel, Access, MS SQL, Btrieve, and mainframe using MS DTS, BCP, and VB programming. The new system has the ability to operate independently on multiple machines and reduce processing time per application by 80%. The result was increases in sale and productivity. Using VB 6.0 and Crystal reports 7.0, reports were generated for production managers and also special formatted report for the federal government.
Credit Risk Data Warehouse and Intranet net web reporting.
Involved in consulting, designing, programming, and implementing Credit Risk data warehouses for Credit Card, Home Loan, and Line of Credit. Using MS SQL 7.0 and 2000, MS Data Transformation Services (DTS), Stored Procedures (TSQL), ERWIN DB modeling program, and Visual Basic 6.0 & ADO program to (ETL) migrate, clean, mine, and transform the raw data from mainframe, Excel, Access, MS SQL, SAS, and Btriev. Used MS SQL 2000 Microsoft Analysis Server OLAP tool to create molap, rolap and holap cubes to distributed data to analysts. Also used ASP, MDX query, and XML to access olap cubes for displaying standard reports to executive via Intranet.
Initially, I also performed as the primary SQL 7.0/2000 DBA for three Dual Processors, Raid5 systems until US Bank decided to hire a permanent DBA to reduce my workload. After that I performed as a Secondary SQL 7.0/2000 DBA. The DBA work included install, setup, tuning, backup, and maintenance of MS SQL database. My other work included interviewing users to learn business process, create dataflow diagram, data mapping, design relational database, size out the data volume, recommend hardware/software purchase, installed database software, create database security, create DTS program to clean / migrate the data, create olap cubes, and generate reports using Excel pivot tables and reporting Dashboard.
Credit Risk Data Warehouse Data Dictionary Application.
Architect, designed, and implemented a data dictionary program for the data warehouse. Using MS SQL 7.0/2000 server store procedure (TSQL), MS DTS, Visual Basic 6.0, ADO, Erwin, and some of FarPoint activeX objects. I was able to create a program that resides on the NT terminal server where all users can access without actual distribution. Created training materials for users to use the data Dictionary and also train users to connect and query data from the data warehouse and OLAP Cubes using Access, Enterprise Manager, Excel 2000, and SAS.
*** Most ETL work included merger data from First Bank and US Bank into a single entity for data warehouse/ data repository.
Heritage. Sr. Programmer/Developer/DBA (LED) November 1998-March 1999
B to B online stage design and booking web application
Architect, designed and implemented a B-to-B web site and database for online booking and management of advertising platform for trade shows. Using IIS, HTML, FrontPage, ASP, ADO, MS Stored Procedure (TSQL), MS SQL 7.0, ERWIN DB modeling program, and Visual Café Java to create an interactive web site to meet Heritage’s needs. The actual work included programming all aspects of ASP and visual café, database design with Erwin, MS SQL DBA and Data Transformation, and Setup and install IIS web server.
Northern States Power Company. Sr. Programmer/Developer/DBA (LED) April 1998-November 1998
Pipeline Emergency Reporting System.
Consulted and created a reporting system for oil and natural gas delivery and maintenance service group. Used Visual Basic 5.0, RDO, MSSQL 7.0, DB2, MTS server, ActiveX/Com, and Crystal Report to generate report on demand by service managers. The reports are created by extracting data from DB2, MSSQL 7.0 and merge them into one report using stored procedures and Visual Basic data processing methods.
Mobile interactive pipelines emergency repair application.
Consulted, designed and implemented a demo program intended to work with Fujitsu mobile touch screen tablet for the gas maintenance responding crew. The system is connected to central database via wireless radio network. Used Visual Basic 5.0, RDO as a programming language, MS SQL 6.5 for database, and MTS server I was able to deliver online access to data included drawing of detail pipeline map. Users were able to update and insert new information and also provide summarized reports while at the service site.
CEI.(LED) April 1998-July1998
Migration of MAC telemarketing program to Intel base system.
Consulted and converted all MAC. Telemarketing software to Intel based computer. Used Visual Basic 5.0, RDO and MS Stored Procedure as programming software and MSSQL 6.5 as database server and Trigger services, I was able to converted and also consolidated all the MAC telemarketing software to work on Intel based computer. I also added intelligent to this system to dial on demand and locate best of leads depending on time and day. Another major added feature included online order entry system. The actual work includes using Erwin to reverse engineer and redesign their old database to SQL 6.5. I also work as their MS SQL DBA on the Production system. Using VB 6.0 and C++ I was able to help them migrate some of the data from great plain software database to MS SQL database.
FIRST BANK. (LED) May 1997-April 1998
Corp. Credit Card Production Report Migration
Consulted in database design, setup DBA, and migration of data to the client server MS SQL 6.5 and 7.0. Used Visual basic 4.0 and 5.0, ADO, RDO and Crystal report, MS stored procedures to replace all of the report and loan applications programs created in Access, excel, lotus notes, Btreive, and mainframe. I was the primary DBA for the system during development and the first 6 months of production.
Business Credit Card Production Booking and Reporting
Consulted in general reporting automation system. Utilized Visual Basic 4.0/5.0 and Crystal Report 5.0/6.0 to create reports that interface with different SQL type databases system. The system is used by upper management and is distributed through out the county.
Consulted in Business Credit Card data collection/processing and reporting application system. I utilized Visual Basic 4.0, MS SQL 6.5, Stored Procedures, Extra Quick app Attachmate Screen Scrape, Rumba, and many other third parties software to create a system to process Small Business Credit Card.
Business Loan Application Booking
Consulted and implemented an automation loan application booking software. Utilized Visual Basic 4.0 and third party screen capturing tool (Extra Quick app Attachmate Screen Scrape, Rumba) to create a system that saved 70% of the loan and credit underwriting work for First Bank.
The actual work performed at First Bank included the redesign of a database using Erwin to reverse engineer and then forward engineer the redesign to MS SQL server. All front-end and back-end code was redesigned to take advantage of MS SQL server and MS development tools. I was the primary DBA for the system during development and the first 6 months of production.
DAYTON HUDSON CORP. (LED) November 1996-May 1997
Construction Reporting Application
Consulted in a property development reporting application system for Target stores to track designs and equipment that go into each store. I utilized Visual Basic 3.0, DBLib, and Crystal Report to create a reporting application for the designing manager’s team. Also created programs to transform and migrate data from AS400 system into MS SQL 6.0 database using MS BCP and SQL stored procedure (TSQL).
CEI (LED) October 1996-November 1996
Predictive Dialing Application
Consulted in computer telephony application system. Utilizing Visual C++, DBLib, and Dialogic API, Stored Procedure (TSQL) to create a multithread telephonic system for the use by the telemarketer. The telephonic system is program to accesses MS SQL 6.0 database for contact data via RDO. I also designed & created the database using Erwin and also DBA the MS SQL database system.
CY DeCOSSE Incorporated (Benkovich & Associates) March 1996-October 1996
Data Audit
Consulted in database auditing. Utilizing Informix 4GL to analyze data, generate and optimize complex reports on continuance ordering system. Built a new and improved system to handle daily data processing and also create special program to deal with the rogue data found in the auditing process. Also assisted to managed CY DeCOSSE IT department and maintained the Informix database. The result of the contracted duration is CY DeCOSSE experienced increased sales, recovered +50% continuance sales, and un-pay revenue. Also consulted and facilitated the migration of Informix system to third party data management group.
Blue Cross & Blue Shield / RX Gold (Benkovich & Associates) November 1995-March 1996
SAS Deployments Application
Consulted and implemented in client server interface with SAS program on UNIX servers. Utilizing Humming Bird X window Exceed Basic to create GUI front end to control communication between UNIX and PC. The application includes the ability to RAS into the UNIX. The connection automation is used for seamless activation of SAS applications from the UNIX. This system is use by Blue Cross & Blue Shield though out the country. This is the first attempt by Blue Cross of online B-to-B drug insurance processing. Also assisted in logical and physical design the Oracle database to help actuary personnel quickly assess insurance risk. I also create extensive automated reports using Oracle PL/SQL for BCBS analyst group.
Benkovich & Associates (Benkovich & Associates) August 1995-November 1995
Web base real estate information service.
Created a demo Internet site to serve real estate information. Utilized Window NT server as the base system, SQL server 6.0 as data base engine, NETSCAPE as the HTTP server to implement the web site. Utilize HTML, C++ for CGI, and JAVA version 1 to create interactive GUI on the net. The Internet site was intended to replace the PowerBuilder 4.0 front-end application.
Best Buy Company (Benkovich & Associates) August 1994-August 1995
Data Replication System
Consulted on client server software development using three tiers architecture. Utilized Visual C++, DBLib to access MS SQL 6.0 and Oracle database for hourly data replication of the latest price and promotions. Utilized Visual Basic 3.0 to create GUI front end for the employee’s information access system. Also created and maintained data replication over T1 connection. Utilized C++ thread capability to replicate data from the mainframe and Unix system to multiple MS SQL server 6.0 sites at the same time. This program controls the data flow to all answer centers in every one of the Best Buy Company super stores.
Education:
B.S., University of Minnesota, Minneapolis, Minnesota (Double major)
Major - Electrical Engineer & Computer Science June 1989 -Aug,1994
Oracle school.
.
Contact this candidate