Sql Server Developer

Soong (Sam) K. Ahn

*** ********** *** ******, *****

***** ****: 817/368-6342

OBJECTIVE Programmer Analyst position with stable company. Available for

immediate hire.

Full time position preferred, but will consider contract.

Looking to move to MS C# platform.

Qualifications

FoxPro/XBase -21 years Visual FoxPro -15 yrs (v 5.0, 6.0,

8.0,9.0)

MS Access - 1.2 year SQL2000/VFP

Relational Database Design Sequel Query Language

.NET/c#/Visual FoxPro/SQL Server - Programmer

ASP.NET c#

WCF Services .NET/c#

Desktop application .NET/c#; winforms/ dataset

. Forms, PRG, Reports, Menus, Toolbars

. GUI/PRG/Report

. OOPS architecture

. Database Container/Store Procedure/Relational Database

. Connection to backend client server (SQL Server/Oracle) and use pass-

through technique to access and process data.

. Experience with credit bureau HTTPS POST request such as Experian Net

Connect, Trans Union TUNA and CSC Equifax.

PROFESIONAL

EXPERIENCES

Jan 2009 Humana/LifeSynch Irving, TX

Present Title: Visual FoxPro/c# Programmer Analyst

. Keep up maintenance and enhance Dimension software written in VFP09

. Keep up maintenance of Provider lookup search system written in c#.

. Document and update software specifications.

. Map data fields during clinical rewrite.

. Create ASP.NET WCF services to transfer data across platforms.

. Maintain Desktop application using .NET c#\Winforms and Datasets.

. Write SQL Server Store Procedure and T-SQL applications

. Use SQL Server to analyze data issues and bugs.

. Write SQL scripts to modify table structures and required by software

requirements.

Aug 2006 R S CLARK & Associate Collection Service. Dallas, Texas

Jan. 2009 Title: Visual FoxPro Programmer (On Contract)

. Enhance the Collection and Down load system, using VFP9.0

. PL/SQL Developing on Oracle 10g.

. API calls to acquire credit reports from credit bureaus (Trans Union,

Experian, CSC Equifax) web sites using web service and HTTP POST.

. Add new feature such as zip code address locator and EDI files

generator

. Data field mapping to DBF and SQL 2000 Client Server

. Parse out returning files from HTTP POST response to create human

readable report. Experian, Trans Union and Equifax.

Feb 2006 Countrywide Mortgage Inc. Plano, Texas

Aug 2006 Title: Visual FoxPro Programmer (On Contract)

. Maintain and Enhance EDGE, the Mortgage Funding System.

Sept 2004 ACS Securities Inc. Dallas, Texas

Feb 2006 Title: Visual FoxPro Programmer

. Maintain and Enhance the Fund Distributions System using MS Visual

FoxPro

. Create and merge PDF documents using CutPdfFileMerger and VFP 8.0

. Data scrub for in house test area

June 2004 System Source Inc. / R S CLARK & Associate Dallas

- (On contract)

Sept. 2004 Assigned to R S CLARK & Associate - Visual

FoxPro 8.0

. Enhance the Collection and Down load system, using Visual FoxPro8.0

. Add new feature such as zip code address locator and EDI files

generator

. Convert data from XLS/CSV/Comma delimited file to DBF tables from new

client CD.

Feb 2001 Vartec Telecommunication., Dallas, Texas

Oct 2003 Title: Application Developer/Analyst - Visual

FoxPro/Sql Server/Oracle.

. Developed and maintained the Customer Order Processing System used by

over 1500 users

. MS SQL Server Stored procedure and Oracle PL/SQL programming

. Developed many support applications such as INP switch application,

SRO Serviceability List generator and Order Balance Application

. Used SQL2000 as the backend for all the application.

. Team lead for COPS (Customer Order Processing System) system.

. Upload data to SQL2000 Client Server for data ware house

. Help migrate data from SQL Server 6.5 to Oracle 9i.

. Maintained the critical ticket application written in MS Access

Oct 1999- Information Plus, Irving, Texas

Dec 2001 Title: Application Developer

. Convert Delphi Application to MS Visual FoxPro 6.0

. Maintain and convert the Cleaning scheduler.

. Maintain the Conveyor robot.

Feb 1995 Vartec Telecommunication., Dallas, Texas

Oct 1999 Title: Application Developer/Analyst - Visual

FoxPro/Sql Server/Oracle.

MS Access programmer.

. Maintained the Customer Order Processing System

. Developed many support applications such as Trouble Ticket system,

. Used MS SQL6.2 as the backend for all the application.

. DOS FoxPro 1.0 to Visual FoxPro 5.0

EDUCATION UNIVERSITY OF TEXAS AT DALLAS, Richardson, Texas

Concentration: Management Information Systems

Date Of Graduation: May 1990

Texas A&M UNIVERSITY, College Station, Texas

Date Of Graduation: May 1987

Contact this candidate