Jie (Jay) Song
Tel: 816-309-2157, [Send email to request phone number] 68-9035
Jssong2000@hotmail.com
11935 S. Rene St. Olathe, KS 66062
Summary
.NET Developer with extensive experience in the analysis, design, architecture,
development, testing and implementation utilizing C#, VB.NET, ASP.NET, Visual
Source Safe, Tortoise SVN, SQL server and Oracle with XML, Java script, web
service, MSMQ and IBM MQ Series. Developing database, stored procedures, views
and triggers for Multi-Tier Web based applications used by web sites that
facilitated e-Commerce and Wireless application across the internet.
Technical Skills
1. Hands on experience in project life cycle includes Requirement gathering and
Analysis, Database design, Database development, Application development, Test,
Implementation and Support
2. Expertise in Desktop and Web-based applications using Visual Studio.net ,
Visual SourceSafe and Tortoise SVN.
3. Expertise in VB.net and C#.net
4. Expertise in ASP.NET and classic ASP
5. Expertise in SQL Server 2000/05 and Oracle 9i
Operating System: Win 95 / 98 / NT (Work Station) / 2000 / 2003 / XP, MS-DOS,
UNIX
Languages: C#, VB 6, VB.NET, Java, Java script, SQL, PL/SQL, T-SQL, PHP,
HTML, DHTML
Data warehouse Tools: SQL Server DTS
Database Connectivity: ADO.NET, MS Application Blocks, ADO, DAO, RDO, OLEDB,
ODBC
Databases: Oracle 9i, SQL Server 2000/2005, MS-Access
Tools/ Technologies: TOAD, MS Visual Studio.NET 1.1/2.0, MSMQ, IBM WebSphere MQ
Series 6.0, ASP, ASP.NET, COM, DOM, XML, XSLT, VB Script, Java Script, MS
Office, Text pad
Web Server: Internet Information Server 5 / 6
Version Control System: Microsoft Visual Source Safe 6.0, tortoise SVN
Professional Experience
Educational Resources, Inc March, 2008 - Present
Senior Programmer/Analyst
Job duties:
1. Responsible for leading the performance improvement in SQL server and Dot Net
applications using Profiler, Index Tuning, connection pooling, transaction
isolation and IIS management.
2. Responsible for leading the enhancement and trouble shooting for DTS packages
and Stored Procedures using T-SQL in SQL server 2000. Trouble shooting for all
database and web related issues for paper-pencil tests.
3. Responsible for leading the enhancement and trouble shooting for three
classic asp web applications and three VB.NET web and window applications USING
HTML, XML, AccPac API, Xjob, MS office COM components, SOAP, WSDL, Visual Source
Safe 6.0, Visual Studio 2005 and SQL server 2000 (Store Front Web Gateway,
utility, faculty, student, public and ERI). Those web applications manage up to
10,000+ online tests and reporting services per day. One primary web site is
ERIWORLD.COM. Create Windows Installer(MSI) project including primary output,
file system, registry, user interface and launch condition, etc.
4. Responsible for leading the transfer classic asp web pages to ASP.NET 2.0
with VB.net, HTML, XML, Javascript, Crystal Report, Visual Source Safe 6.0,
Visual Studio 2005 and SQL server 2000/2005.
Sprint Nextel July, 2007 - March, 2008
Applications Developer II
Job duties:
1. Responsible for leading the design and development of a 3-tier web service
interface using C#, ASP.net, Visual Source Safe 6.0, Visual Studio 2005, HTML,
XML, WSDL, SOAP, DOM and SQL Server 2000/2005. It will receive drive test info
from SNAPs using serializable classes. Create web service method and class
objects, write those information into SQL database to create project and drive
test tasks using Sqltransaction. Display information in asp.net web pages using
Gridview and Viewdetail. Send test result response to SNAPS by calling its web
service interface. Test the application using WSDL and testing program.
2. Responsible for leading the design and development of window and web
applications for 4G application using C#, ASP.net, HTML, Visual Studio 2005,
Visual Source Safe 6.0, SQL server 2005, IBM WebSphere MQ Series6.0, XML and
XSD. NRM will put XML messages to MQ series. Window application will connect to
MQ queue manager and get XML message from a queue. Read XML message and pass it
to engine application by calling its DLL. Engine will de-serialize XML message
and map data to serializable class objects generated from XSD. Write data into
SQL server 2005 using MS enterprise library DbTransaction. Display data on the
web application using GridView. Put response message to MQ Series. Use Ajax Timer
to schedule and run program. Create Windows Installer(MSI) project including
primary output, file system, registry and user interface, etc.
Lagarde, Inc Nov, 2006 June, 2007
Developer
Store Front E-Commerce platform maker has built more than 50,000 online stores.
Job duties:
1. Provided the analysis, design, development and customization of the
E-commerce platform Store Front, developing 3-tier E-commerce software Store
Front using VB.net, ASP.net, Visual Studio.net 2003, Java Script, HTML, XML,
Tortoise SVN, Web Services(WSDL, SOAP) and MS SQL server 2000. The software
includes business rules, data access, store front web (presentation layer),
system base and UI tools. The software's merchant tool section has all e-commerce
related functions, including management of customer, category, product, inventory
, payment , shipping, sales report, email, price group, online chat, etc. It also
supports add-on functions like RMS, sub store, CSR...
2. ASP.NET (presentation layer): Modify and create server controls, html
controls and user controls, etc. Display databind content for Datagrid and
repeater.
3. VB.net (System base, business rule and data access): Modify and create
classes in every layer of the software, including create new classes for new
tables created in SQL server. It covers the whole architecture of the software
including create tables and stored procedures using T-SQL, establish relation
between tables, create new code in Store Front Web, system base, business rule
and data access layer. Create SQL statement in vb files.
4. SQL server 2000:
Alter and create tables and store procedures using T-SQL in DBupdate.xml
file.
Create and restore database.
Transfer data between different data source (access, SQL server, excel...) to
SQL server using DTS, and then transfer data within SQL server using stored
procedure, T-SQL, cursor. Fetch data from source table and insert into new table.
Test application performance using Profiler.
Debug stored procedure and test database using Enterprise Manager.
5. Java Script: create new Java Script (array, 2-dimension array) to handle
functions interact with vb files.
6. IIS: create new virtual directory for new projects. Provide security
settings.
7. Webservice and windowservice: Create MSMQ. Create batch files to install,
stop and start web and window services. Create SOAP web methods. Test web
methods using WSDL and test program.
8. XML Object Model: use XmlDocument methods Load, LoadXML, Save. Use
XmlReader and XmlWriter. Read and write XmlSchema using XML Schema Object Model.
Use typed dataset.
9. Projects: Fidelity National Financial, Smoky Mountain Knife Works, Suture
Express, Half Price Book, Atlanta Cutlery, Glendale, Uniforms Manufacturing,
Chateau Animaux, Pasternack
10. Project leader in Smoky Mountain Knife:
Create 3 new tables (UPSPartner, ShippingRestriction, AlternateProducts) in
SQL server.
Create new classes in business rules and data access to access the added
tables from the presentation layer.
Create new table AlternateProducts in system bases dsProducts.xsd and xsx
files based on the Schema Object Model, establish new relationship with Products
table. Create new alternate products classes in vb files. Modify stored
procedure and CXMLSiteBuilder.vb to load new added table.
Using HttpReferrer to get referrer web site address. Check from new table
UPSPartner to see whether it is a UPS partner or not. If so, give the client a
discount by setting a UPSPartner price group in Merchant tools.
Check customer input of shipping information from table ShippingRestriction to
see whether it is shipping restricted or not. If so, display a message, delete
that product from shopping cart.
Add and display alternate products in product detail web page using repeater.
Add email function for abandoned cart. Check abandoned order using a timer.
Schedule an email to the client., display product information in the abandoned
cart., display latest products information.
Add news express function: Add News Content table in SQL server database. Add
classes in business rules and data access layers to make the table work. Create a
news template web page, when a news created, insert content to the News Content
table and make a new web page automatically according to the news id in the
database. In news release web page, get news id and title information from
database, provide links for different news.
Implementation Analyst April, 2006 Oct, 2006
GE Energy Oil & Gas
1. Window application implementation using C#, Oracle, TOAD, SQL server 2000,
Visual Studio 2003, Visual SourceSafe, ISAT, APDM pipeline relational database
model.
2. Job duties:
Developing the database tables, views & stored procedures using ODBC, Oracle
and SQL Server.
Developing business rules according to specification and APDM and ISAT
pipeline relational database model. APDM is designed for implementation as an
ESRI geodatabase which is an object-relational construct for storing and managing
geographic data as features within an industry-standard relational database
management system.
Implementation: Create session to get a local version of enterprise database
using PipeView Integrity, which offers a single data source for all team members
and GIS-based presentation of data and analysis results. Perform write backs to
test program developed. Load data using XML files like Dataloadwizard, Integrity
Data Management template.
Developing metadata files like license, permission files, etc.
Web Application Developer July 2003 Mar 2006
Elite Technology, Inc
Job duties:
1. Analysis, design and develop two 3-tier E-commerce application using asp.net,
C#.net, VB.net, Visual Studio 2003, MS VSS, HTML, Web Service(WSDL, SOAP), XML
and SQL Server 2000. Customer can login to the company website, browse products,
put them into shopping cart and pay credit card through Verisign
In presentation tier, create asp.net web forms(with various server controls)
to show our customers various products information which is exported from Great
Plains(excel files). Create user controls to display header and category
information. Validate user input information. Navigate between forms using
redirect and transfer methods.
In application tier, handle communication between customers and database
server. Store and retrieve data using ADO.net objects and Microsoft Application
Blocks. Use forms customer authentication within database. Store and retrieve
customer information using XML and dataset. Read product information from Excel
files and write to SQL server database. Read customer information from XML file.
Execute Stored procedures to retrieve product information. Store and delete
shopping card information in the database table. Send customer and credit card
information to Verisign using web service.
In data tier, create stored procedures to retrieve product information.
2. Developed a web site for Sun Marble, Inc. using PHP and MYSQL. Customer can
register on the website, browse products and send order or feedback information
to account manager's email box.
3. Accounting and inventory management using MS Great Plain
Software Engineer - Internship Sept 2001 Aug 2002
Intern in Xcom, Inc.
Job duties:
1. Developed a restaurant order system using VB6.0
2. Developed a testing program for a Telecomm Switch board using Java
3. Developed a website and customer information relational database using Asp3.0
and MySQL
Education
Master of Science in Information Technology May, 2003
Central Missouri State University, GPA 3.63
Bachelor in Computer Science July, 2000
University of Missouri Kansas City
Certification
Sun Certified Java Programmer Java 2 Platform Dec, 2002
Reference Available upon request
|
