Sql Server Project

James E. Huffman

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

Bella Vista, AR 72714

Phone: 479-***-****

*************@*******.***

December 2004 to July 15, 2010

PRGX Global, Inc. Bentonville, AR:

Senior Software Developer

Develop VB6, Access 2003 and VB.Net (2003, 2005 and 2008 versions) programs

accessing multi-terabyte (70 Terabytes) Sql Server 2008 databases to enable

and assist auditors in analyzing and writing claims.

. Develop programs to automatically scan multiple FTP sites and download

new files.

. Client email viewing applications

. Database and server management utilities

. Claim creation and Claim Management (internal and external claims)

applications

. Report creation using Crystal Reports, Access and Sql Server Reporting

Services

September 2003 to December 2004

PRG/Schultz, Inc. Bentonville, AR:

Consultant

. Develop VB 6 and Access 2000/2003 auditing applications.

. Develop VB 6 COM objects to provide Business Intelligence (BI) rules.

. Develop VB 6 COM objects to produce Access reports.

April 2002 to February 2003

Humana Inc., Emphesys Claims IT Louisville, KY:

Consultant

Manage maintenance and enhancement activities for Emphesys website.

Technical lead on mission critical intranet project that provides interface

for departments to create and change data that replaces hardcoded values in

mainframe programs with values stored in DB2. This project required using

IBM's MQSeries and CICS programs to transport data in XML format between

mainframe DB2 databases and web server interfaces. Presentation of data was

accomplished using ASP (VBScript, JavaScript and HTML) and XSL templates

and transforms.

Design and implement team / work tracking databases with MS Access.

Design and implement MS Excel workbooks, Visio diagrams and MS Access

databases as repositories and design aids for DB2 table and query designs.

Utilize MS Project for project tracking purposes.

Demonstrations and training aids were created with MS PowerPoint.

December 2001 to March 2002

Raytheon Travel Air Wichita, KS:

Consultant

Modify VB 6.0 executables to utilize Oracle 8i backend

Design Access database for Raytheon Aircraft Charter & Management

Create Access 97 graphical user interface

April 2001 to December 2001

State of Wyoming, Department of Employment, IT, N-Tier Development Section

Casper, WY:

Consultant

Design, code and implement VB 6.0 GUI, COM and MTS components to retrieve

Mainframe and Visual FoxPro data files and update SQL Server 7 and 2000

databases.

Design, code and implement ASP 2.0 (VBScript, JavaScript and HTML) pages,

VB 6.0 DLLs and ActiveReports 2.0 reports for displaying on the departments

website (Staff Viewing only).

December 2000 to March 2001

Raytheon Travel Air Wichita, KS:

Consultant

. Design, model and implement Visual Basic 6.0 project that calculates and

displays ownership, contract and flight data. The program assists RTA in

managing fractional ownership and analyzing aircraft usage.

. The project uses a VB 6.0 GUI application and two VB 6.0 DLLs (COM

objects) in the user, data and business services (tiers).

. Mentor staff members with suggestions and training in GUI design

following the Microsoft Windows Style Guide, data acquisition with ADO

and methods for deploying Access databases.

August 2000 to

December 2000

Jackson National Life Ins. Lansing, MI:

Consultant

Design, model and implement data migration from Oracle and Paradox

databases to DB2 web-enabled database. Participate in all phases of

development.

June 2000 to

July 2000

Sterling Commerce Inc. Columbus, OH:

Consultant

Perform maintenance and enhancements to an existing Visual Basic 6.0

application. Successfully completed project six weeks earlier than

scheduled.

October 1998 to June 2000

Humana Inc. Louisville, KY:

Consultant

14. Provide technical direction, research, graphical user interface design

training (Microsoft Windows Style Guide) and leadership mentoring for

Humana's Information Systems HHACP and HB teams.

Produce white papers for staff and clients.

Analyze requirements, design, code, implement, test and document

enhancements for HumanaHealth Advanced Care Partners and HumanaBeginnings

with Access 97, VBA, ODBC and Visual Basic 6.

Provide troubleshooting and support for HumanaHealth Advanced Care Partners

and Humana Beginnings programs with Access 97.

Design, document and implement ActiveX and class based data structures

and design elements using OOP methods and ADO with Visual Basic 6.

Design, document and implement ODBC/ADO and Visual Basic 6 GUI container

for dynamic reporting using Crystal Reports.

DBA for HumanaBeginnings Test and QA SQL Server 7.0 databases.

Design, develop, implement, install and tune SQL Server 7.0 and MSDE

databases. Create indexes, stored procedures, views and triggers.

May 1997 to October 1998

Federal Express. Memphis, TN:

Consultant

Analyze business requirements and create business processes to audit,

maintain and track development of baseline software for FedEx's LEC&C

Division Tandem Computer environment.

Project lead, lead programmer, DBA, GUI and "best practices" trainer and

mentor for FTE team members in the Application Migration Services Year 2000

Software Configuration Management Team.

Design, code, document, test and lead the implementation of Access 95 and

Access 97 databases, VB4 and VB5 applications using ADO and ODBC for data

access and Crystal Reports for reporting.

Participate in the establishment of SCM processes for attaining CMM Level

2.

. Create pilot project for a team intranet with Visual Studio 97 and

Interdev to produce ASP (VBScript and HTML) and HTML intranet web pages.

Provide technical direction, design and participation in upgrading an

Access 2.0 call center application to VB5 and Access 97 using class modules

and DAO.

December 1996 to May 1997

Cardinal America Consultants, Inc. Dallas TX:

Senior Consultant

27. Develop and analyze requirements, design, code and test Client/Server

applications using Visual Basic 4.0 "front ends" (GUI) according to

Microsoft Windows Style Guide and Access 95 and 97 (7.0 & 8.0) databases

using DAO and ODBC with Crystal Reports.

Provide technical leadership, trouble shooting, training and support for NT

and Novell LAN & WAN installation and security, virus eradication and

packaged software support and training.

January 1991 to December 1996

Consultant:

Design and develop custom applications and databases for various business,

nonprofit organizations and individuals in the Northwest Arkansas area.

Using Visual Basic, ODBC, Access, Visual FoxPro, Delphi 1.0. Crystal

Reports, Clipper 5.0 to 5.2, dBase III & IV, C/C++, Pascal.

Provide technical assistance, direction and training for clients in

selection, procurement and installation of network hardware and software

(Token-Ring, NT and Novell), as well as, off the shelf and custom software

including installation/administration of MS SQL Server 4.X.

Teaching Experience

Northwest Technical School, Springdale, AR.

Instructor's Assistant

Assisted instructor in teaching BASIC language and beginning programming.

Summer 1992

North Arkansas Community College, Rogers, AR.

Instructor's Assistant

Assisted instructor in teaching Word Perfect, dBase IV, and Lotus 123.

Summer 1992

Rogers and Bentonville AR school systems

Substitute Teacher

Teach a variety of subject areas including all math and computer science

classes.

1990. - 1993

Education

B.S.B.A. University of Arkansas, College of Business Administration

Major: CISQA (Computer Information Systems and Quantitative Analysis)

MCSD (Microsoft Certified Solution Developer) in VB6 - June 2003

Database and RDBMS: Access 1.0-2007, Paradox, Visual FoxPro, Xbase, MS

SQLServer 4-2008, Sybase SQLServer, Sybase SQL Anywhere 5, Inprise

InterBase, Oracle 8 and DB2/2 and DB2/6000 - Universal Database ver 7.1.

Platforms, Databases, Languages and Productivity Packages

Programming Environments: Visual Basic 3-6, ODBC, VBScript, Visual

Studio.Net 2005 & 2008, C#, VB.Net, ASP, XML, XSLT, JavaScript, MTS,

Delphi, Clipper 5.2E, COBOL (MicroFocus Workbench), Turbo Pascal 6.0, Turbo

Assembler, Turbo C & Borland C++, SQL 92, Transact-SQL, PL/SQL, VBA, Think

C, Think Pascal, AS/400 CL, RPG/400.

Operating Systems: OS/400, DOS,OS/2, Windows 3.0 through Windows 98,

Macintosh 6.X & 7.X, Windows NT Workstation and NT Server 4.0, Windows

2000, Windows XP Professional, Windows 7, Novell 3.0 through Novell 4.10.

Data Modeling, Project Management, Report Writers and Productivity: MS

Project 4-2000, Visio 4-2007, S-Designor DataArchitect, MS Excel, MS Word,

MS Outlook, Lotus Notes, Crystal Reports, ReportSmith, ERWin,

ForestAndTrees, Data Junction, Sql Server Reporting Services, and

ActiveReports.

Contact this candidate