Tony Liu Email & Phone Number

Los Angeles, Ca, Us

SQL Database DBA, architect, design & development

Working in Business Reporting Group, my responsibility includes:• Create all kind of reports for marketing, sales, customer service department by using MS reporting service, crystal report.• Write ad hoc query & Stored Procedure for populating the reports.

Work in IT department of Prospect Medical Group, my responsibility includes:• Work on the INTRANET application, which are used for internal management and reporting purpose for patient or provider information. • Work with DB ARCHITECTURE in the design phase of the system, define DB objects, such TABLE, RELATIONSHIP, CONSTRAIN, RULE, help creating standard for T-SQL coding (Stored Procedure, User Define Function, Trigger)• Work with the application development team, creating stored procedures, user-defined functions, triggers, table, views, Index and performing performance tuning on all kind of query, stored procedure.• Create all kind of reports for internal usage by using MS report service (2000 & 2005).

Portellus Inc is a software company providing service for Loan \ Mortgage \ Insurance industry, my responsibility includes:• Involve in the design and development of two major products - Loan Origination System (LOS) and Broker Portal (BP)• Work with the application development team, creating stored procedures, user-defined functions, triggers, table, views, Index and performing performance tuning on all kind of query, stored procedure, managing databases on Production, QA and Development servers,• Perform general database administration, including database backups / recovery / migration, security management (authentication, user roles, database roles, login accounts, permissions, SQL application security, SQL enterprise security, permissions on tables / views / stored procedures)• Configure, monitor and maintain Replication between Loan, LoanReport and LoanArvhive databases• Prepare SQL script for the purpose of Product release or Database migration