Patrick
Wesley
With over 12 years of IT
experience including programming, software
development, HL7 interface development, team leader,
and IT manager, Patrick is a seasoned IT expert with a wide
range of experience and a proven track record
of solutions to customers.
Professional Resume
Experience:
6/2007 - Present
Business
Applications Manager
Floyd Medical Center
Rome,
GA
Lead team of six including a DBA, Web Developer, HL7
Interface Developer, and three Application Analysts. Lead
small to medium sized projects. Develop HL7 interfaces and
train others on development tools and standards. Assist is
database scripting / maintenance. Assist Application Analysts
in troubleshooting, etc. Perform employee evaluations and
other administrative / managerial tasks.
7/2006 -
6/2007
Senior Implementation Engineer
StatCom (A Jackson
Healthcare Company)
Alpharetta, GA
Developed HL7
interfaces using Oracle, PL/SQL, Stored procedures, HL7, etc;
developed reports using Business Objects 10, developed tools
using VB.Net, XML, text files, Oracle and SQL. Traveled onsite
to various customer sites for application and interface
installation / configuration / testing. Performed system
testing, XML document modification, system installations /
configuration and various other duties as
assigned.
11/2005 - 7/2006
Team Leader / Interface
Developer
McKesson (OSG) at Wellstar Health Systems
Marietta, GA
Manage team of 2 Unix administrators,
2 DBAs (Oracle and SQL Server), and 1 Cloverleaf Interface
Developer
Provide, manage and coordinate resource
allocation for projects requiring team member time and
technical resources
Maintain 24 / 7 coverage and support
for a wide array of projects (from simple to complex) in a
high-volume project environment
Identify dependencies and
constraints early in the planning phase in order to prevent
issues during the implementation phase of many projects
Develop and maintain HL7 interfaces using Cloverleaf
Integration Engine by Quovadx
Create translations, Tcl
scripts, fixed record length interfaces, thread
configurations, and mapping
Assist DBAs (Oracle and SQL
Server) with backup / recovery, scripting, SQL and
troubleshooting
Collaborate with superiors on personnel
issues, training requirements, political issues, and planning
08/2004 11/2005
Integration Developer
Floyd
Medical Center
Rome, GA
Developed HL 7 Interfaces
using Sybase e-Biz Impact (Interface Engine) for various
system interfaces, including the creation of Adaptive
Interface Modules, generation of Production Objects, and
Interface configuration
Monitored and provided problem
resolution on the Interface Engine
Developed Applications
using VB.Net, MS Access, SQL Server, Active X, JavaScript, ASP
and embedded SQL, which varied in nature including an
Application tracking system, data file manipulation
application, Interface Engine log file query tool, Web based
(ASP, JavaScript) directory search tool, Web based (ASP,
JavaScript) image library search tool, and MS Access to MS
Excel interface
Performed SQL Server database monitoring
and administration (backup / recover, tuning, monitoring, DTS,
T-SQL, Enterprise Manager, Stored Procedures)
Assisted
project managers in interface development planning and
documentation
Provided insight in Interface capabilities
and limitations and data migration strategies
Developed
documentation covering areas of expertise primarily including
e-Biz Impact (Interface Engine), various Interface
installations, and application development
Provided
development support / mentoring on HTML, ASP, SQL, MS Access,
Sybase e-Biz Impact, Oracle, SQL Server, and Unix
Acted as
a liaison service between vendors and the department of
Information Technology as well as between other departments
within the organization
Performed SQL Server database
monitoring and administration (backup / recover, tuning,
monitoring, DTS, T-SQL, Enterprise Manager, Stored
Procedures)
02/1997 05/2000
09/2000
08/2004
Senior Programmer / Analyst
Floyd College
Rome, GA
Provided support and development on Visual
Basic, Access, Oracle, Unix, HTML, CGI, PL/SQL, Java, JSP, and
SQL based applications, and application support on Windows 95,
98, NT, 2000, and XP operating systems
Performed systems
analysis and troubleshooting on Unix and Windows based
servers
Designed, coded, tested, and maintained a dynamic
processing and reporting system for Floyd Colleges employee
intranet using PL/SQL, Oracle, HTML and JavaScript
Wrote
numerous scripts, extractions, transformations, data loads,
and ad-hoc reports in SQL and PL/SQL to create, query and
modify both Oracle 7, 8i and 9i databases, including a
substantial number of data extracts used for statistical
analysis
Designed, coded, and tested several applications /
systems in SQL, PL/SQL, Visual Basic, Java, JSP, ASP, HTML,
JavaScript, and Microsoft Access, including an automated user
account creation and laptop inventory system
Maintained and
modified existing programs written in Pro*C, Pro*Cobol, C,
SQL, UNIX scripts, Visual Basic 5.0 and PL/SQL, while
designing and developing new reports and processes on Oracle
RDBMS, Oracle Forms, Reports 6i and Access
databases
Provided technical support, systems analysis, and
troubleshooting assistance to users on Banner version 5.0 (SCT
Corporation Application Software), a student information
system designed by SCT Corporation using Oracle
technologies
Worked on UNIX (AIX and HP-UX 10.20 and 11.0)
platforms, using various languages (SQL, PL/SQL, HTML, Pro*C
and C) and tools (SAM, SMIT, Cron, FTP and TFTP) to interface
with an Oracle 7 and 8i relational database
Programmed on
Windows NT 4.0 and 2000 platforms using Visual Basic 5.0 and
Microsoft Access.
Assisted Oracle Database Administrator by
maintaining user accounts, assisting in software upgrades,
maintaining security, and assisting with backup and
recovery
Assisted UNIX system administrator on a daily
basis on UNIX (HP-UX 10.20 and 11.0) operating systems,
including monitoring the system, maintaining user accounts,
and maintaining printers
10/02/95 02/08/97
Computer Programmer I
State University of West Georgia
Carrollton, GA
Converted Legacy system to SCT
Banner Student Information System (Used PL1 to extract data
and SQL Loader and SQL scripts to import data)
Maintained
and modified existing programs in Banner, while designing and
developing new application programs and reports written in
Pro*C, C with embedded SQL, UNIX scripts and SQL on an Oracle
7 database
Assisted in Oracle DBA responsibilities,
including user account creation, database maintenance and
security implementation
Worked with faculty and staff to
design proposed reports and / or diagnose and solve problems
with Banner student information system
Worked on a UNIX
(AIX) platform, using various languages (Pro*C, C and SQL) /
tools (Crons and FTP) to interface with Oracle and Microsoft
Access relational databases
05/2000 09/2000
Systems Analyst University Center Location
Collegis
Maitland, FL
Performed Systems Analysis and
troubleshooting on Banner student information system,
including modules General, Student, Financial Aid, and
Finance
Modified SCT Pro*C and Pro*Cobol programs to meet
functional user requests, using Oracle tables, SQL*Plus,
PL/SQL, Banner processes and Unix
scripting
Training:
10/95 Present
MIACO
Corporation
Athens, GA
Professional Training in
Oracle
Oracle Language Fundamentals (SQL)
Oracle
Advanced Query Techniques (SQL)
PL/SQL V2 for
Developers
Oracle Programmatic Interfaces (C with Embedded
SQL)
Basic Oracle Forms V4 Development
Advanced Oracle
Forms V4 Development
Oracle Client/Server
Installation
Oracle Web Developers Tool Kit
(PL/SQL)
Oracle Forms 6i
10/95 Present
OITS/ AA
Board of Regents
Athens, GA
Professional Training in
Banner (Enterprise Application System)
Banner Student,
Financial Aid, Accounts Receivable, General, and Georgia
Enhancements Modules
Banner Client / Server
Installation
Banner Web Installation (Oracle Application
Server 2.1, 1.1)
Education:
01/01 02/03
Shorter
College
Rome, GA
Major: Business
Management
Degree: Bachelors of Science in
Management
08/2003 05/2005
Kennesaw State
University
Kennesaw, GA
Major: Applied Computer
Science
Degree: Masters of Applied Computer
Science
Skills:
Languages
SQL, PL/SQL using
stored procedures and functions, C, Pro*C, Visual Basic,
Microsoft Access, VBA, HTML, ASP, VBScript, JavaScript, Perl /
CGI, Delphi, Java, JSP, and Pascal, Visual Basic .Net, and
Sybase Impact ODL.
Operating Systems
UNIX (HP-UX
11.0 and AIX), Microsoft Windows NT 4.0, 95, 98, 2000, XP,
MS-DOS and Linux.
Databases
Oracle 7, 8i, 9i,
Microsoft Access 97, 2000, XP, SQL Server 2000, and
Paradox.
Tools
UNIX HP-UX - System
Administration Manager (SAM), Cron (Scheduling), Oracle Web
Developers Tool Kit, Microsoft IIS 5.0, Microsoft Word, Excel,
Access, PowerPoint, Sybase e-Biz Impact (Interface Engine),
and WinFax.
College Coursework
Pascal I, Pascal
II, Advanced Visual Basic, RPG II, Assembly, Cobol, Software
Engineering (Java), Embedded Systems, Computing Systems,
Financial Accounting, Managerial Accounting, Statistics,
Advanced Computing Systems, A.I. and Robotics (Java), Advanced
Web Development (Dreamweaver, HTML, Fireworks, Flash etc),
Client Server Architecture (ASP .Net, Visual Basic .Net, .Net
Compact Framework, .Net Framework), Game Theory (Java, Visual
C++), Distributed Objects (Java Server Pages 2.0, with
embedded SQL, JavaBeans, etc.), Database Administration
(Oracle 9i, SQL).
Life Experience :
10/88 -
10/91
Served Three years in the U.S. Army /
Infantry
10th Mountain Division Ft. Drum, NY
Honorable
Discharge
Served in Egypt (Sinai Peninsula) during
Operation Desert Storm
Completed time in inactive reserve
(Cannot be recalled for active duty)