Developer Sql Server Oracle Java Service .Net

Ken Xie

**** ****** *****

Tel: 281-***-****

Missouri City, TX 77459

Email: ******@*****.***

Career Objective

.Net, Database Developer Position.

Summary

. Ten years of successful IT experience in software design, development

and support.

. Extensive experience in Objected Oriented Analysis, Design and

Programming.

. Experienced in .NET, C#, ASP.NET, VB.NET, ADO.NET, Visual Studio.NET,

Web Service, SOA, WCF, Silverlight, AJAX, UML, XML. Design pattern.

. Experienced in Core Java, J2EE, Java Servlet, Struts, JavaBean, JSP,

JSTL, Custom Tag, JDBC, EJB, Patterns, Eclipse and Websphere.

. Strong in Database design and development. Experience mainly in SQL

Server and Oracle. SQL Server in T-SQL, Stored Procedures, SQL Server

Reporting Services(SSRS). Oracle in PL/SQL, Oracle Report, SQL, Stored

Procedures, and Database performance tune.

. Experienced in Perl/CGI, Classic ASP, Crystal Report, JavaScript,

Visual Basic, COM/DCOM, and UNIX.

. Highly motivated, fast learner and good team player.

Computer Skills

Language: C#, Java, Perl, Visual Basic, C/C++, Fortran, Basic, and

Assembly.

Database: SQL Server, T-SQL, SQL Server Reporting Service(SSRS), SQL

Server Integration

Service, Oracle Developer(PL/SQL, Oracle Report, SQL

Plus, Stored Procedure), Oracle

DBA, MS Access, SQL, ODBC, UML, Rational Rose, Pro*C.

Internet: .NET Framework, Classic ASP, C#.NET, Visual Basic.Net,

ADO.NET, J2EE, Servlet, JSP,

JavaBean, Struts, EJB, JavaMail, Hibernate, Eclipse,

Tomcat, WSAD, ASP, COM/DCOM,

Perl/CGI, Crystal Report, JavaScript, VBScript, Visual

InterDev, Visual Studio.NET,

HTML/DHTML, CSS, Cold Fusion, TCP/IP, PHP, IIS and

Apache Web Server, N-tier Client-

Server Architecture, XML, XSLT, Web Service, SOAP, PVCS.

OS: UNIX, Linux, MS Windows2000/XP/Vista/7/NT, DOS.

Educations

Master of Science in Computer Science University of Houston-Clear Lake,

Texas

Master of Business Administration Huron University, South Dakota

Bachelor of Science in Engineering Xi'an Petroleum Institute,

China

Certificate

Microsoft Certified Professional (ASP.NET C#/VB)

Sun Certified Web Component Developer(J2EE1.4)

Sun Certified Java Programmer

PeopleSoft PeopleTools, PeopleSoft Human Resources.

Professional Experience

Senior .Net/SQL Server Developer AECSoft Inc., Houston, TX. Jan.2010 -

Present

In developing a web project for a Supplier Management System.

. Communication with clients for business logic and design requirement.

Business analysis and design.

. Developing web pages using ASP.Net, C# under Visual Studio 2008.

Skills used including SOA, WCF, Silverlight, Web Service, Ajax, XML,

LINQ, Visual SourceSafe. Pattern used including Facade, Business

Object, ADO, MVC.

. Developing SQL stored procedure for ASP pages and reports using SQL

Server 2005/2008.

. Developing SQL report using SQL Server Reporting Service(SSRS).

. Database design, data mapping, data load and database performance

tune. SSIS tool.

Senior Software Developer(.Net, SQL Server, Java) Imagitek Inc. League

City, TX, Nov.2006 - Dec.2009

. Business logic analysis with customer for design and enhancement

requirement.

. Developing web-based applications. Integrated new design, enhancement

and customizing existing ASP.NET page. Technologies used are C#,

ASP.NET, ADO.NET, XML, Web Service, AJAX, JavaScript and Visual Studio

2005.

. Developed stored procedure in MS SQL Server 2005. Developed SQL

Server Reporting Service(SSRS). Database performance tune.

. Developed and modified Oracle database. PL/SQL stored procedure.

Developed new and updated existing Crystal Report.

. Troubleshooting, maintenance, and modification of existing software.

Bug fix for java documentum project using core Java, JSP, XML, Tomcat,

Eclipse and CVS. Familiar with EMC content management system.

. Creating and documenting software test process.

. Technical lead in software project development.

Senior Software Developer Ford Motor Company Dearborn, MI

April.2000 - Oct.2006

. 360 Project(ASP.NET, VB.NET, SQL)

Re-write this employee feedback system from Perl/CGI system to MS

.NET technology.

. Developed function and technical specification for screens.

. Developed class diagrams, sequence diagrams based on UML.

. Developed screen using ASP.NET, VB.NET, ADO.NET with Visual Studio.

. Developed SQL Server stored procedure using SQL Server 2000, T-SQL.

. Single Order Edit Project (Java, Oracle):

Developed a

Car Order System for Ford Motor company. This is an on-line car order

system and will be used through many departments within Ford. It is a

key project at Ford and will significantly reduce the waiting time for

new car order. The technologies it used are Core Java, J2EE, Struts, JSP,

JSTL, EJB, Web Service, Oracle Report, with IBM Websphere and Rational

XDE for Java as development tool and PVCS as version control.

. Analysis and designing with UML diagrams using Rational XDE for Java.

. Developed java filter chain program for project session control and

user authorization.

. Developed Facade and Business Service program for business logic

through core java technology.

. Implemented DAO pattern with JDBC, DataSource, Caching, JNDI,

Singleton, and using JTA as transaction control.

. Designed and implemented a Java Message Driven Bean for asynchronous

job process through JMS.

. Created WSDL file and generated Web Service from WSAD for data

transfer and notification.

. Developed test plan and unit test using Junit.

. Implemented java pattern like MVC, Filter, Front Controller, View

Helper, Facade, Business Service, Business Object, DAO, Sigleton, JTA,

Service Locator, etc.

. Developed user screens through JSP, JSTL, Struts, Java Bean and

Javascript.

. Developed Excel report through JSP page development.

. Developed Stored Procedure Specification with complex SQL. Database

and SQL Performance tune.

. Developed oracle reports with Oracle 10g Developer Suite for PDF

report.

. Java/Oracle Application Support(Java, Oracle, Perl, UNIX)

Support four web applications for Human Resource Department of Ford

Motor Company.

. Three applications use Java/J2EE/WSAD. All applications use Oracle 9i

as backend and PVCS for version control.

. Duties included business logic analysis with customer, new development

and enhancement, build and deploy, trouble-shooting and fix, database

model and improvement, data load and fix.

. Developed jsp page using Servlet, JSP, Struts with core Java and DAO

as backend.

. Developed java batch program for send email through UNIX.

. Unit and Integration testing.

. Maintained Ant build scripts which to pull source out of PVCS,

compile, and jar.

. Built, packaged, deployed EAR into an UNIX/WAS application server.

. One application using Perl/CGI. Some Perl/CGI script with UNIX. UNIX

shell script.

. Developed Oracle Report, Oracle Stored Procedure with PL/SQL.

. RTOM 1.5 Project (ASP, VB, COM/DCOM, Crystal Report):

Enhancement for RTOM I using same technology with RTOM II.

. Developed and modified ASP page using ASP, COM/DCOM, Visual Basic,

JavaScript and Visual Interdev.

. Developed and modified crystal report using Crystal Report 8.5 and

COM/DCOM.

. RTOM II Project (Crystal Report, ASP, VB, COM/DCOM):

Developed a sales and dealer management web site for Ford Motor company.

. Developed and modified ASP page using ASP, COM/DCOM, Visual Basic,

JavaScript and Visual Interdev.

. Developed and modified crystal report using Crystal Report 8.5 and

COM/DCOM.

. QIP Project (Perl-CGI, Oracle, UNIX):

Developed a leadership training management site for Ford Motor Company.

This is a new application.

. Worked with customer and manger in analysis of customer needs and

function specification.

. Developed web design to develop user interface.

. Oralce Database design, modification, data load, and SQL queries.

Using SQL Loader, TOAD, PL/SQL.

. Developed web page using Perl/CGI, client side Javascript and html.

. Unit test and bug fix.

. ECD project (Perl-CGI, Oracle, UNIX):

Developed a globe personnel management web site for Ford Motor Company.

. Developed Perl-CGI pages using Perl, JavaScript, HTML, Homesite under

UNIX.

. Developed Oracle Reports using Oracle Developer.

. Database design, modification and data load.

. Auto email notification system with cron job control and UNIX shell

script.

Software Developer (SQL Server, ASP, Visual Basic) Telescan Inc.

Houston, TX Nov.1999 - Mar, 2000

Developed a web-based Financial Stock Market project with Visual Basic

front end and SQL Server database to replace the obsolete host program

which using Forth language. Working in a team environment, requiring

minimal supervision. The project includes:

. Designed a financial analysis dcipher database for SQL Server.

. Wrote Perl scripts to validate text file format and transfer different

text files format for SQL Server 7.0 input.

. Wrote stored procedures and trigger in MS SQL Server 7.0 to execute

financial analyst logic. Using DTS and BCP to transfer text and excel

files to SQL Server7.0. Using Replication of SQL Server7.0 to synchronize

databases between servers.

. Developed a web-based financial interface for financial analysts using

HTML, ASP, JavaScript, Vbscript and SQL Server 7.0 store procedures under

Visual Interdev environment.

. Developed a financial analyst interface using Visual Basic-Database

connection.

. Some SQL Server 7.0 administration work.

Web Developer/Administrator(Perl, Oracle, UNIX) CoreMetrics, Inc. Austin,

TX June.99 - Nov.99

. Designed a visitor tracking system database for e-commence company.

. Developed a JavaScript plug-in program to collect visitor information in

e-commence sites.

. Developed a Perl-CGI program to accept on-site plug-in information and

transfer it to text files. Developed a C-CGI program to do similar

function using C and Pro*C.

. Developed a cookie-handler system to identify visitor under different

browser for the visitor-tracking system using Perl-CGI, JavaScript,

Oraperl.

. Developed visitor-tracking web site using HTML, ASP, Vbscript,

JavaScript, CSS and Oracle 8 PL/SQL under Windows NT environment.

. Developed UNIX shell script, cron control, and some UNIX administration

work.

. Installed Oracle 8 in UNIX system (Solair7), transfer text files to

Oracle 8 using Oracle 8 SQL loader. Some Oracle 8 DBA works in UNIX.

. Apache, Zeus and IIS Web server administration.

. Set up hardware and Ethernet network. Download, install and configure

software, and other tasks for this very start-up company.

Web/Oracle Programmer (ASP, Oracle) Shiptrax, Inc., Houston, TX Jan..

1999 - June, 1999

. Developed a shipment information tracking web site which access Oracle8.0

database using ASP, HTML, VBScript, JavaScript under MS Visual InterDev.

. Developed about 20 crystal report using Crystal Report, Active X and ASP.

. Developed an auto-email notification system using Oracle PL/SQL.

. Some administration work concerning Oracle8 Server, Windows NT and MS

IIS.

Mechanical Engineer YanShan Petrochemical Company, Beijing, China July

1984-Dec. 1994

. Using AutoCAD, designed of many petrochemical machinery projects,

including several international projects which mainly concerned pressure

vessel.

. As the representative of Emtrol Company (USA), successfully completed

several big remodeling projects in petrochemical machinery around China.

. Using Fortran developed some software concerning stress calculation and

pressure vessel design.

. Translate documents from English to Chinese and vice versa.

Contact this candidate