Business Systems Analyst / Data Architect
Resume:
Richard M. Swett
*** ********* ***** *****: 865-***-**** Cell
Maryville, Tennessee 37801 E-Mail: ****@*********.***
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 - ****@*********.***. I look forward to hearing from you.
Regards,
Richard M. Swett
326 Bridgeway Drive Phone: 865-***-**** Cell
Maryville, Tennessee 37801 E-Mail: ****@*********.***
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: ****@*********.***
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