Post Job Free

Resume

Sign in

Business Systems Analyst / Data Architect

Location:
Maryville, TN
Posted:
April 25, 2013

Contact this candidate

Resume:

Richard M. Swett

*** ********* ***** *****: 865-***-**** Cell

Maryville, Tennessee 37801 E-Mail: abs0ri@r.postjobfree.com

Web site: http://www.rickswett.com

ATTN: Human Resource or Hiring Manager

Could you use an experienced Information Systems professional for a position in IT

management as a Business Systems Analyst/Data Architect who would bring to your

company a broad range of skills, including:

Designing architecture, selecting technologies and directing hardware and software

installation

Ensuring that networks are available, backed-up, accessed by authorized users, and

remain un-compromised

Participation in design/planning meetings to define business and technical

requirements

Writing, debugging and documenting source code in multiple languages, and

supervising others doing this.

Ensuring that data assets are supported by an architecture covering database

design, data integration and data transformation services

Performing software testing and developing reports

Managing client expectations and project closure

I am a U.S. Citizen, and as such I am authorized to work in this country for any employer. I

would welcome the opportunity to further discuss any position with you. If you like what you

see on my resume, pick up the phone and call me at 865-***-****, or send me an e-

mail - abs0ri@r.postjobfree.com. I look forward to hearing from you.

Regards,

Richard M. Swett

326 Bridgeway Drive Phone: 865-***-**** Cell

Maryville, Tennessee 37801 E-Mail: abs0ri@r.postjobfree.com

Web site: http://www.rickswett.com

Experience

3/2008 – 3/2012 Geomap Company Plano, Texas

Business Systems Analyst /Data Architect

• Developed and supported data assets with an architecture covering database design, data integration and

data transformation services.

• Developed a process for finding and correcting (or removing) corrupt or inaccurate records from third

party data.

• Reverse engineering and data extraction from legacy systems (also known as ETL - extract-transform-

load).

11/2006 - 4/2007 Marquis Software Solutions, Inc. Plano, Texas

Programmer Analyst

• Feature addition and maintenance on a legacy system written in a development environment that had

reached end-of-life cycle.

10/2006 - 11/2006 Aces Wired, Inc. Plano, Texas

Contract Database Analyst

• Designed logical and physical data models and performed database application development using stored

procedures and triggers.

• Developed base-line and ad-hoc reports as required.

8/2003 - 4/2006 Sims & Sims, CPAs Dallas, Texas

Information Systems Manager

• Designed architecture, selected technologies and directed installation of a multiplatform environment

(Windows / Linux)

• Created policy on how sensitive data is defined and where it resides.

• Ensured that networks were available, backed-up, accessed by authorized users, and remained un-

compromised.

• Handled Encryption, firewalls, Intrusion Detection Systems, Virtual Private Networks (VPNs), and

Penetration Testing.

• Developed, implemented, and maintained Internet/intranet applications, including database integration

and server scripting.

10/1997 - 10/2001 Integrated Office Systems Corporation Dallas, Texas

Business Systems Analyst

• Facilitated design sessions and gathered business and technical requirements.

• Defined project scope, budget, and schedule.

• Determined project deliverables, key milestones, and key progress tracking metrics.

• Wrote, debugged and documented source code in multiple languages, and supervised others doing this.

• Defined database physical structure and functional capabilities, developed and maintained data

dictionaries, and documented schema.

• Performed gap analysis on legacy systems.

• Managed customer expectations and project closure.

Page 1 of 2 Feb 21, 2013

8/1996 - 5/1997 First American Real Estate Information Services Dallas, Texas

Contract Programmer Analyst

• Participated in design / planning meetings to define business and technical requirements.

• Developed application and reusable components using design patterns and object oriented design

principles.

• Participated in code and design reviews.

• Performed software testing using specified procedures and tools.

2/1995 - 5/1996 CompuCom Systems, Inc. Dallas, Texas

Contract Programmer Analyst

• Assisted managers in defining reporting needs; Developed base-line and ad-hoc reports as required.

• Worked with EDI ANSI X12 data and EDI data mapping to create EDI transaction sets from PC databases.

5/1994 - 11/1994 ECOM USA, Inc. Dallas, Texas

IT Operations Manager

• Evaluated, installed, and supported PC hardware and software.

• Provided end-user training and support.

3/1993 - 5/1994 Examination Management Services, Inc. Dallas, Texas

Lead Programmer/Analyst

• Managed programming staff during design, programming, and test.

• Responsible for task assignment.

• Duties included instructing, directing, and checking the work of other programming personnel.

Education

The University of Texas - Austin, Texas

Bachelor of Science

Certification

Microsoft Certified Professional - MCP# 1826560

Qualifying Examination:

70-029 - Implementing a Database Design on Microsoft® SQL Server™ 7.0

Target Job

Desired Job Type: Employee

Desired Status: Full-Time or Contract (W2)

Site Location: Metropolitan Knoxville, Tennessee area

Career Level: Senior Level (25+ years I.T. experience)

Willing To Relocate Generally speaking, no, unless exceptional circumstances are involved.

Willing To Travel Yes

Work Status U.S. Citizen - I am authorized to work in this country for any employer.

Page 2 of 2 Feb 21, 2013

Richard Swett

326 Bridgeway Drive Phone: 865-***-**** (cell)

Maryville, Tennessee 37801 E-Mail: abs0ri@r.postjobfree.com

Web site: http://www.rickswett.com

Summary of Hardware and Software Experience

Hardware Databases

# months Last used # months Last used

IBM PC MS SQL Server

25 yrs. Today 48 Nov. 2006

IBM AS/400 Access

11 May 1994 114 June 2011

IBM 3060 Mainframe SQL Anywhere

5 April 1991 10 May 1996

PDP 11 Oracle

8 July 1990 40 June 2011

DEC VAX (Cluster System) DBase Direct (AS/400)

8 July 1990 3 Oct. 1992

MySQL 64 June 2011

Networking # months Last used

Microsoft Server NT4-2003 78 April 2007 Programming # months Last used

Novell Netware Perl

14 Nov. 1994 2 June 2011

Linux (Samba) Java (Netbeans IDE)

12 April 2006 2 April 2011

Visual Basic v.6 (inc VBA) 63 June 2010

Internet Delphi

# months Last used 32 Apr. 1999

Microsoft IIS Clipper

24 Sept. 2001 27 May 1994

Apache Web Server FoxPro DOS

54 June 2011 16 May 1994

JRun (Java server) DBase III Plus

3 Sept. 2001 13 Nov. 1994

ASP Visual FoxPro

9 Sept. 2001 14 April 2007

PHP Borland C++

30 April 2006 3 Nov. 1994

Dreamweaver 40 June 2011

Quanta Plus Project Management

24 June 2011 # months Last used

Microsoft Project 48 Oct. 2001

Operating Systems Visio

# months Last used 48 Oct. 2001

Windows 2000/xp ERWin DBF

78 Aug. 2007 3 May 1994

Windows 9x (95, 98, ME) 63 Oct. 2001

Windows 3.11 Reporting

16 May 1996 # months Last used

MS-DOS Crystal Reports

34 May 1996 18 Nov. 2000

DEC VMS R&R Report Writer

8 July 1990 19 May 1996

Linux (SuSE, Red Hat) ReportSmith

40 June 2011 2 Aug. 1995

Groupware Other

# months Last used # months Last used

MS Exchange Server Sterling-Direct Connect

14 April 2006 7 May 1997

eGroupware UI Programmer

6 Jan 2005 3 May 1994

Lotus Notes IBM PC Support (AS/400)

7 Nov. 1994 3 Oct. 1992

tech ni cal (tĕk nĭ kăl) adj. mo bil i ty (mō bĭl ĭ tē) n. 1. That characteristic

or trait of an individual in a technical field to migrate from one programming language,

platform, or methodology to another rapidly and seamlessly. 2. The ability to dissect

and understand a technical tool. 3. Having the ability to apply new technology tools

rapidly in developing solutions due to mastery of foundational development concepts.

Page 1 of 1 Feb 21, 2013



Contact this candidate