QUALIFICATIONS

• Excellent verbal and written communication skills
• Strong analytical, reasoning and organizational skills
• Strong problem-solving skills
• Experience in eBusiness, finance, insurances, retails, utilities, airlines, banking, supply chains, and telecommunications industries
• Extensive experience in Object-Oriented software methodologies, full software development life cycle, and UML notation
• Solid C , C/C , BizTalk Server 2006, Visual C , Java, J2EE, Visual Basic, ASP. Net, XSLT, HTML, DHTML, JQuery, JavaScript, XML, VBScript, SQL Server, Oracle DBMS

HARDWARE

IBM PC Compatibles

SOFTWARE

VS2010/2012/2013, TFS, SVN, Git, Microsoft Project, Excel, Microsoft Outlook, IIS, EasyCase, System Architect, Microsoft Management Console, Microsoft Transaction Server, Microsoft IE, Micromedia Dreamweaver, Microsoft Query, SSDS, Microsoft SQL Integration Services, Reporting Services, TOAD, SQL Plus, SQL Navigator, Oracle SQL Enterprise Manager, DB2 Control Center, DB2 Command Center, WISE 9.0, Microsoft XML Parser, Apache XML Parser, DOM, SAX, SOAP

DATABASE

SQL Server 6.5/7.0/2000/2010/2012, ORACLE 8.0/9.2, MS-Access97/2000/2002/2003, IBM DB2

LANGUAGES

C/C , C , VC , COM, DCOM, COM , MFC, ATL, ODBC, JDBC, ADO, DAO, RDO, ASP, HTML, DHTML, XML, XSLT, SQL, Transact-SQL, PL/SQL, VB, Java, JavaScript, JQuery, Nant, and Perl

OPERATING SYSTEMS

Windows 95/98/NT/XP/2000/Windows7, Unix, Linux

DATA COMMUNICATION

TCP/IP, FTP, WWW, SMNP, HTTP

METHODOLOGY

OOA, OOD, UML, Data modeling, Data warehouse, OODB, Structured analysis and design, CMM, Scrum

EXPERIENCE

Confidential

Independent Contractor

Architected and designed the following projects using C , VB.Net, SQL Server 2005/2008, XML/XSLT, SSIS packages, third party tools of Aspose, DexExpress, Component One.

Bloomberg security download project:

• Design and created SQL Server 2008 database model to store security information.
• Created business objects to get data from Bloomberg server daily, weekly, quarterly, and annually and populate database tables.
• Created data access layer to retrieve and store security data into database.
• Generate Xml or flat files for securities for backup purpose.

Merrilynch security download project:

• Design and created SQL Server 2008 database model, database tables and stored procedures.
• Created business objects to download data from Merrilynch web site daily and populate database tables.
• Generate flat files and created SSIS packages to load data into database.

One Pager project:

• Design and created SQL Server 2008 database model, database tables and stored procedures.
• Created business objects to get data from Bloomberg, Merrilynch, Whitebox, and other sources.
• Create UI forms to generate reports for securities with graphics.

Bond and stock mover project:

• Design and created SQL Server 2008 database model, database tables and stored procedures.
• Created business objects to get data from Bloomberg, Merrillynch to generate report for 50 top bond and stock losers and display them on UI.

Excel and flat file loader project:

• Create a class library to load excel file and populate them into database tables.
• Write various loaders such as bond, stock, Hongkong, Singapore, Tradar, daily position.

Security mapping project:

• Create a class library to map different security to Whitebox.
• Write stored procedures and views to get data from different databases

Markit Project:

• Created business objects to get Markit data from web site and save it into database tables.
• Created data access layer to store data in the backend.
• Created a console application and schedule to run it daily.

Confidential

Independent Contractor Honeywell

Global Asset Registry project: Architected and designed the whole project.

• Created business object to get data from backend and populate UI forms.
• Created data access layer to extract data from database.
• Created UI web forms to display different equipment information and maintenance routines in 13 different languages for the field technician to do their jobs.
• Relevant technologies include MS SQL Server 2005, Visual Studio 2005, and dot net 3.0. The application's UI layer uses menu, tree view, and grid view controls to navigate and display data on the web forms. Uses DTS packages, stored procedures to transfer data between different databases.

Confidential

Independent Contractor

• Designed and created business objects
• Created data modeling and designed database for the Fruit Rollups using ERWin and SQL Server 2005
• Created data layer using NHibernate 1.2.0
• Created Profanity which checks profane words Web service using Microsoft Windows Communication Foundation and .net framework 3.0
• Created xml schema for design and template. Create xslt style sheet to translate xml design and template into preview Xml file. Created drawing library to display rollup design on Asp pages using Windows GDI and windows API
• Created UI using Asp.net 2.0 Membership, Profile, and Role providers.
• Created Admin pages to update, cancel, refund orders using Windows Workflow Foundation
• Created financial reconciliation component to connect to PayPal web site to get daily order transaction activity and the actual payment and send transaction data to Sap accounting database

Confidential

Independent Contractor

• Created data modeling using Visio Architect and generated database script to create database in SQL server 2005. Created triggers to audit every customer record when it is inserted, updated or deleted. Created all stored procedures to insert, update and reports for the system.
• Wrote backend classes for web service, web UI and Xerox batch file third party vendor to receive enrollment applications VB.Net .
• Created Web service to receive enrollment data and insert it into database.
• Wrote console applications to send batch files to different systems such as COSMOS, JD, OXFORD, NICE, MSM, PERADIGM VB.Net for the enrollment and schedule them in AutoSys.
• Wrote code to use Topaz Systems API to enable applet or signature pad for enrollee's signature.
• Wrote Xslt to translate Xerox xml file into UHC enrollment xml file.
• Created msi files to deploy all of the applications.
• Related technologies include Visual Studio 2005, SQL Server 2005, Oracle 10g, Asp.Net 2005,Visual Source Safe, VB.Net, and C .