Sql Server Maintenance

WEIPING EDWARD CHEN

E-mail: ******.******@*****.***

Home: 718-***-****

Cell: 917-***-****

SUMMARY

Over 10 years of experience in database administration, architecture and development

Superior SQL development and performance tuning skills

Strong data modeling and data architecture experience

Experienced in client-server and 3-tier application

Self-starter, able to work and learn independently

TECHNICAL SKILLS

MS SQL Server, SSIS, SSRS, SSAS, Powershell, Sybase, Oracle, T-SQL, PL/Sql, Shell Scripts, Perl, C/C++, Java, XML, HTML, CGI, ETL, Erwin; TOAD, Windows, Linux, Unix

EXPERIENCE

July 1998 – Present Triple Point Technology, Westport, CT

Senior Database Administrator/Senior Database Developer

Responsible for the development and implementation of software for this leading provider of Commodity Trading products. Programs extensively with SQL Server, Sybase, Oracle, as well as scripting tools such as Perl. Participate in implementing the COMMODITY XL™ that is an N-tiered, middleware independent commodity trading and risk management system featuring Java-based component architecture with XML and SOAP messaging over HTTP and JMS. Responsibilities include relational data modeling, middleware programming, writing triggers and stored procedures, performance tuning.

Installed Sql Server 2008, Sql Server 2012 servers. Performed Sql Server maintenance tasks, such as statistics collection, index maintenance and backup. Created and monitored Maintenance Automation Tasks.

Provided Database support for implementation, migration, testing and release of company’s software products. Wrote database DDL, DML scripts, stored procedures and triggers. Performed performance tuning.

Implemented the Market Risk Reporting System for Morgan Stanley. It is a data warehouse project that provides consolidated database, flexible data capturing and reporting for risk positions (Perl, Shell Scripts, T-SQL, ERwin, Unix and Sybase).

Developed the P/L Batch Process that computes trade prices and P/L for different trade types, which include Physical, Swap, Options, Future and Foreign Currency (MS SQL Server, Sybase, Triggers, Stored Procedures, ERwin).

Implemented the Auto-Invoice Batch Process that processes all outstanding settlements for the given selection criteria in counterpart sequence (MS SQL Server, Sybase, Stored Procedure).

Developed the Daily Refinery Margin Calculation Batch Process that calculates the actual refinery margin based on the crude that are being priced on the current day, their landed prices and the prices of the products that will be derived from the crude. The refinery margin is used in the Refinery Margin and Position Report System (MS SQL Server, Sybase, Triggers, Stored Procedures, Erwin).

January 1998 – June 1998 JP Morgan & Co., New York

Consultant

Participated in creating and supporting the Core Processing System that is a 3-tier distributed trading system and is composed of four major areas of functionality: Position and Transactions Data Service, Delivery Management, Corporate Actions and Reconciliation.

Enhanced and modified the Normalizer that is a multi-threaded application and contains the core business logic and functionality to transform legacy data into a common business event message (C++, Perl, SQL, Unix and Sybase).

February 1997 – December 1997 UNIF/X, New York

Database Developer/DBA

Completed various internal and client projects for this software development company.

For Cantor Fitzgerald: Participated in the development of a Bond Pricing System. Worked with analysts and evaluators to implement pricing rules. Wrote stored procedures and implemented logical and physical design for bond database. Developed an Intranet based Pricing Module that allowed users to retrieve data from database and view it through Web site (C, T-SQL, Perl, Unix, CGI, HTML and Sybase).

ContacTrace™ - Developed an Automated Job Processing System for this relational database product used for Financial and Financial Services Industry customer tracking. Developed a web based Search Engine on this database system (C++, T-SQL, Perl and Sybase).

Developed a Task Reporting System for distributed delivery of Project Task Reports. The system was designed to deliver reports to users automatically at scheduled time through Intranet. The system also had a Web-based interface, so user could run and view reports through a browser (Java, Perl, T-SQL, Sybase and Shell Script).

Developed a Web Calendar with which users can schedule meetings, appointments and conferences for individuals and groups over browser, view their schedules from browser and get e-mail notifications regarding to their schedules (HTML, CGI, Perl, T-SQL and Sybase).

EDUCATION

New York Institute of Technology

Master's Degree, Computer Science

Sichuan University, China

Bachelor's Degree, Engineering

Contact this candidate