Chao Liu

*** ****** ***** ***** *****: ac7xo2@r.postjobfree.com

Suwannee, GA 30028 Tel: 678-***-****

Objective A challenging position as a database Developer

Summary Over 15-year software design, implementation.

Extensive experience in data warehouse and BI/database-oriented development.

Database skills: SSIS/DTS, SSRS, SSAS, MDX, database logical/physical design, DBA,

Replication/log shipping, query monitoring/tuning, Service Broker, ORACLE, DB2.

Programming skills: C#, ASP.NET, jQuery, AJAX, ADO.NET, XML, JavaScript

Experience

06/12~09/2018 Sr. Database Developer, Navigant Cymetrix Inc (San Diego, CA)

1.Data Warehouse and BI Solution Architecture and Development:

1.1Data warehouse architecture, design the EDW star schema, SSIS to load

the dimensions and facts, SSR reports,

1.2Performance tuning and Data aggregation to improve the performance of the OLTP SSRS reports

1.3SSIS packages to load the clients’ data into staging database, SSIS package to export the data into OLTP production.

1.4T-SQL development, stored procedures, functions, views, triggers

1.5Development of T-SQL change scripts for the database deployment

2.Database Activity Monitoring

21. System Monitoring: performance tuning, blocking process monitoring, notification

2.2Deployment of SSIS packages, create/monitor SQL jobs

2.3Indexing and statistics maintenance

2.4Data Migration and upgrade of old databases to SQL 2008 R2, 2012, and 2014.

2.5Query Optimization: execution plan, index, code review and rewrite

2.6De-PHI in database

03/11~05/12 Principal Software Engineer, Carefusion Corporation (San Diego, CA)

1.Data Warehouse Development for Infusion knowledge portal.

1.1SSIS to extract data from XML files into the SQL data warehouse; part of the ETL process with C# executables; Requirement gathering and implementation with T-SQL.

1.2DBA: query performance tuning/monitoring, indexing, statistics; install and configure SQL Server suites: SQL engine, SSIS/SSRS.

1.3TFS database development and deployment, database project Unit Testing.

1.4Powershell script for database management.

2.Database Project Unit Test Automation. Developed the automatic unit test for 3 databases projects.

2.1C# code to implement SSIS tasks testing.

2.2Implemented test case for unit test, and developed ordered test for the testing automation with T-SQL.

03/08~02/11 BI Developer/Database Architect in EBSCO Industries (Birmingham, AL)

1.BI Development for http://www.ebsconet.com: this ASP.NET/C# web application is for EBSCO’s publishers to manage the transactions. My responsibilities are:

a.SSIS to extract from mainframe DB2 into the SQL data warehouse; SSIS to load the data into publisher data mart; create SSAS cube; DUNDAS OLAP control to connect to the cube database; SSRS to generate the reports, and the ASP.NET ReportViewer to display the reports.

b.DBA: performance tuning/monitoring, database backup/restore, replication, service broker, indexing, statistics; install and configure SQL Server suites: SQL engine SSIS/SSRS/SSAS.

2.SSRS Report Management Application: developed the C# multi-threading application to manage the SSRS report for 196 publishers, SSRS web service and API.

3.BI Development for http://atoz.ebsco.com/Admin/Login.aspx: this ASP.NET/C# web application is for EBSCO’s customers to manage the transactions. My responsibilities are:

3.1Overlay Analysis: SSIS to extract the data from SQL database into data warehouse, SSAS the OLAP cube database; ADOMD.NET to connect to the cube, and MDX to query the cube data; C# to create web service, and jQuery to display the progress of the query, AJAX call the web services. Use Telerik’s RadControl to display the data.

3.2LinkSource Usage: partition the cube into yearly partition; this improved the processing and query performance significantly; designed the aggregations; SSAS cube tunning: attribute relationships, hierachies

4.BI Development various applications

4.1 ACD SSAS Cubes: transactional replication to load the data into a data mart, and create the SSAS cubes; EXCEL pivot-table for reporting.

4.2 Consolidated Usage Report: SSAS cube as the data source, SSRS/ProClarity for the reports

5.SSAS High Availability and high Performance Architecture and Implementation:

5.1Separate the cube processing server from the query server, use synchronization to load the processed data to the query server.

5.2Configure HP disk Array to RAID5; install and configure SQL Server suites: SQL engine, SSIS/SSRS/SSAS.

6.SSRS High Availability and high Performance Architecture and Implementation:

6.1Configure Microsoft NBL cluster to the report servers

6.2Configure SSRS scale-out deployment.

05/01~02/08 Sr. System Analyst in Unisource Worldwide (Atlanta, GA)

1.Life Cycle Implementation and Maintenance of Unify Applications: National account is a Unisource group that manages the transactions for nation-wide customers. It takes the EDI orders, processes them based on the optimized customer contracts, location, and products, and sends the orders to the field system for the fulfillment, it also generates the billing, reporting for the customers. My responsibilities in this project include: logical DBA for the Unify databases in SQL Server 2000/2005, ER diagrams, stored procedures, triggers; data warehousing; data transformation (DTS/SSIS) for ORACLE, text file, Access, Excel, Foxpro; SQL Reporting/SSRS and Crystal Reporting for the customer and internal reports; VB/VB.NET, ADO/ADO.NET for GUI; XML for the data transmissions via Web Method.

2.Implement the Credit Card Application:

This application is to establish and verify customer’s credit card information. My responsibilities include: Database design (SQL Service 2005), VB.NET/ADO.NET GUI, Web Service.

3.SSRS Development and Conversion of Crystal Reports:

Lifecycle implementation of the SSRS reports. My responsibilities include: authoring the reports, sub-reports, link-reports, deployment, use security and subscription management; report scheduling. The data sources are SQL Servers, ORACLE.

4.Development of E-commerce Web site: https://commerce.unisourcelink.com. This is a J2EE application. My responsibilities include: ORACLE database management, schema changes, data load. Java, Jscript, shell script and PL/SQL are the main implement tools.

01/00~04/01 Application Development Engineer in Ockham Technologies (Atlanta, GA)

1.Develop Web-based database applications for sales management: Quota

Quota is automation software for the sales manager to distribute the yearly quota based on the geographical location, region, experience, environments, and sales history. Intel, IBM, and WorldCom have used this application. I participated in the full-cycle development of the product: create the tables, ER diagrams, stored procedures, triggers in SQL Server; server-side programming with ASP; extensively apply ADO to manage the database transactions, invoke the stored procedures; create COM/DCOM objects with Visual Basic to encapsulate the business complexities; package these components in MTS; extensive Javascript, DHTM/HTM for client-side event controls, validations; create CSS to format the pages; QA and test the product; configure the application in IIS; set up the security, document and all the properties for the application in IIS; backup and restore the database and web pages. VB component to migrate the data from DB2, ORACLE.

2.Develop the application for Content Manager

This web application provides a tool to categorize, format, edit, and set the features for the sale management articles, tools in our web sites. My roles are: system requirement collection; schema design; create the tables, ER diagrams, stored procedures, triggers in SQL Server; server-side programming with ASP; ADO to manage the database transactions, invoke the stored procedures; create COM objects with Visual Basic; package these components in MTS; extensive Javascript, DHTM for client-side scripting; format the common-used data into XML files, and use DOM to retrieve information from them; create CSS; test the product; configure the application in IIS; set up the authentication security; backup and restore the database and web pages; data migration from other sources: Access, Excel; set up the FTP, SMTP servers, MS Series; configure the Visual SourceSafe.

3.Maintenance of www.salesmanagement.com/index.jsp and www.ockhamtech.com

My responsibilities are support and maintenance of the web sites: create or update the JSP pages; create Java Beans; JDBC connection to SQL Server database; JavaScript for the client-side scripting; XML to store the data; CSS to format the pages; set up the web sites in IIS; configure Jrun; set up FTP, SMTP servers.

4.Develop syndicated database system to track the article’s deployment.

This is an Access 2000 database system, and is a self-started project. Create the database, its tables, relationships, reports, forms, macros, queries, modules with VBA (events controls, data validations, date manipulation).

08/99~ 10/99 IT Advisor to CEISMC (Atlanta, GA)

Developed the web-based database application: www.glc.k12.ga.us. This site acts as the repository of the information on K12 education, and the user can query the database according to the query criteria, and display the results. My responsibilities were implementation of the database in SQL Server (table, stored procedure, ER diagram); create COM objects with VB; ASP for the server-side scripting; ADO for all the database transactions; JavaScript, DHTML for client-side scripting. Applying MT Series.

04/99~ 08/99 Web Developer in TransNexus, LLC (Atlanta, GA)

Developed the company Web site: www.transnexus.com to publish the VoIP leader’s news, papers, and all the information. This site was created with FrontPage, HTM, Forms. JavaScript, DHTML to script the clients’ action and validation.

10/98~03/99 Software Developer in NeXT Century Software (Atlanta, GA)

1.Visual Basic for Client/Server database application to Load Research.

This application provides a tool for the utilities load forecast. The back-end database is SQL server, and the interface is VB. Crystal report. ADO to manipulate all the database transactions. The COM/DCOM objects, user-defined ActiveX controls are extensively created and used in this project. All these component are managed through MTS. Data migration from ORACLE, DB2.

2.Visual Basic database application to Data Acquisition

This application is to migrate the data from different sources (Excel, text files, FoxPro, dBase) in to the central database. The database is Access 97. VB for the interface and Crystal reports, ADO for all the database connections and transactions.

3.Support the Ostrech System.

This is a Delphi system. My responsibility was to update some of the interface and related data operations. The database is ORACLE.

10/96~ 09/98 Graduate Assistant in Georgia Tech (Atlanta, GA)

1.Inspection Information System.

This system was implemented in UNIX with Pro*C, the database was ORACLE.

2.SQL Internal Implementation.

This system was to simulate the select and action (insert, delete, update) queries, optimization for the RDBMS. It was implemented in C,

3.Multithread programming.

This system was to implement the multithread technique with C on Unix.

4.Remote Access by TCP/IP, Socket. C on Unix.

07/92~ 09/96 Software Developer in Changchun Institute of Technology (P.R. China)

1.Mineral Resource Information Management System. Window, FoxBASE.

2.Urban-Environment Water resource Information System. C, Window.

3.Mineral resource prediction Expert System. C on Window.

Education

MS Computer Science, Southern Polytechnic State University (1999)

MS Earth Science, Georgia Institute of Technology (1999)

MS Applied Math, Changchun Institute of Technology (1992)

BE Applied Physics, Changchun Institute of Technology (1989)

Contact this candidate