Title:CTO / Senior Partner
********@***.***
Document
Source below
NAME: P. Coakley, Richard
ADDRESS: *** ***** ******
ADDRESS2:
CITY: Austin
STATE: TX
ZIP: 78734-5008
CANDIDATE ID: 2327792
US CITIZENSHIP: US
Citizen
EDUCATION:
EXPERIENCE: 15
WILL RELOCATE: No - TX
JOB WANTED: Any
RATE NEEDED:
TELEPHONE: 512-***-****
EMAIL: ********@***.***
HOMEPAGE:
HOTTEST SKILLS: Systems Engineer,Systems,SQL Server,Data Warehouse
REVISION: 19-JAN-02
YOE: 15
Certifications:
Microsoft Certified Database Administrator (MCDBA)
Microsoft Certified Systems Engineer (MCSE)
Microsoft Certified Professional + Site Builder
Microsoft Certified Trainer (MCT)
Summary of Qualifications:
26 Years total experience (1976 - Present) in Systems and Applications Design,
Implementation, and Support.
17 Years Hands-on experience (1985 - Present) as a Systems Engineer responsible for the
Design, Implementation, and Support of heterogeneous networks. The systems supported
include Microsoft Windows NT (3.1, 3.5, 4.0 and Windows 2000), Novell Netware (2.x, 3.x,
and 4.x), and some Unix (UnixWare, SCO, AIX).
5 Years experience (1995 -1999) as a Microsoft Certified Trainer teaching Microsoft SQL
Server (versions 6.0, 6.5, 7.0). Courses taught included SQL Administration (6.0, 6.5,
7.0), SQL Development (6.0, 6.5, 7.0), and Performance Tuning and Optimization.
4 Years Hands-on experience (1999 - Present) as a full life cycle Microsoft Certified
DBA responsible for Database Schema Design, Data Imports and Exports (using SQL
Replication and DTS), Performance Tuning, and establishment/monitoring of scheduled tasks
(Data Imports, Backups, Integrity Checks, Index rebuilds, etc.) primarily in Data
Warehousing environments using SQL 7 and SQL 2000.
Education:
Associates Degree
- Business Computer Programming - 3.58GPA 1983 - 1985
Military Trained Systems Troubleshooter - Avionics Mechanic USAF
Data Warehouse Solution Design and Implementation As part of a three-person team that
developed a Data Warehouse as a SAP Reporting solution my responsibilities include:
Developing/Implementing a migration strategy for legacy (Pre-SAP) accounting data,
working with the staff SAP Analyst to determine tables to be replicated, using SQL
Replication to export data from the SAP Server to the Data Warehouse,
developing/scheduling/monitoring of Data Import processes for SAP data that cannot be
Replicated, developing additional database objects (Stored Procedures, Views, Indexes,
Control Structures) to accommodate Data Warehouse access, and providing technical support
for the other members of the Data Warehouse development team on SQL issues.
Database Administration As the SicolaMartin DBA I maintain all the SQL Servers,
specifically, the Development and Production SAP SQL Servers (SQL 7) as well as the
Development and Production SQL Servers for the Data Warehouse (SQL 2000 and SQL 7). In
this role my responsibilities include:
Developing/scheduling/monitoring of Database Maintenance tasks, Data Imports/Exports,
implementing SQL Security, and performance tuning of database/Data Warehouse structures.
Systems Engineering As an as-needed addition to the existing IT Department my
responsibilities include:
Assuming the Role of IT Manager (Technical) when necessary, the installation,
configuration, and support of the SQL and Web Servers for the Data Warehouse, and
providing technical support to the other members of the IT Department.
Applied Information Sciences
03/00
to 12/00
Austin, TX
Senior Data Architect
Data Warehouse Solution Design and Implementation As the Technical Lead on all SQL
issues for AIS-Austin I coordinated and participated in the development of Microsoft SQL
and Analysis Services N -Tier Web Enabled applications for AIS clients. My
responsibilities included:
Collaborating on architectural design, providing direction for Business Object and Web
Interface development teams, providing technical support for development teams on SQL/OLAP
issues, database schema design and implementation, developing Stored Procedures for Fact
Table builds/Data Warehouse access, and developing MDX Statements for accessing OLAP
Cubes.
Database Administration As the staff SQL DBA I was responsible for all AIS SQL Servers
(SQL 7 and SQL 2000). My responsibilities included:
Providing support to AIS internal and external clients on SQL Server issues (including on-
site support calls to clients), developing/scheduling/monitoring of Database Maintenance
tasks, Data Imports/Exports, implementing SQL Security, and performance tuning of
database/Data Warehouse structures.
Systems Engineering As the Lead Systems Engineer for AIS-Austin I supported the AIS
internal network and provided Pre/Post Sales technical support. My responsibilities
included:
Maintaining the Microsoft/AIS Windows DNA Lab on site, Installing/Configuring/Supporting
all Microsoft SQL and NT Web Servers for the Austin location of AIS (including client
Servers for projects when required), and providing hardware configuration specifications
to bid response teams.
The Leasing Group
11/99
to 03/00
Austin, TX
Contract
DBA
Database Administration As the staff SQL DBA I was responsible for all Leasing Group
SQL Servers (SQL 7). My responsibilities included:
Developing Stored Procedures, developing/scheduling/monitoring of Database Maintenance
tasks, Data Imports/Exports, implementing SQL Security, performance tuning, and providing
technical support for developer staff on SQL issues.
Systems Engineering I assisted the IT Department in a Systems Engineering capacity.
Tasks performed include:
Installed/Configured/Supported Microsoft SQL 7.0 and NT Web Servers, and performed NT4 to
Windows 2000 upgrades on Development and Production Servers.
Dell Computer Corporation
05/99
to 10/99
Austin, TX
Contract
Developer/DBA
Web Application Development Brought in to develop a system to capture information
missing in the Dell Data Warehouse, I designed, developed, and implemented an N -Tier
Intranet Web Application to track Sales Representative Organizational Structure. My
responsibilities included:
Requirements gathering, database design/implementation, Business Object
design/development, and web page (HTML and ASP) design/development.
Database Administration While developing the Web Application I functioned as a SQL
Resource for several Dell Employees. In this role, tasks performed include:
Provided technical support for Dell Staff on SQL/OLAP issues, performance tuning,
implemented Security for existing servers/applications, migrated databases from 6.5 to
7.0, and assisted in the development of an Analysis Services cube of >650GB of Worldwide
Sales data
Systems Engineering Here I also functioned in a Systems Engineering capacity. Tasks
performed include:
Installed/Configured/Supported Microsoft SQL 7.0 and NT Web Servers, and performed new
server installs.
Advanced Instruction
09/95
to 05/99
Austin, TX
President/Instructor
Technical Instruction - Taught Microsoft
Systems Engineer and Developer Courses
Primary courses covered Windows NT (3.5, 4.0), SQL Server (6.0, 6.5, 7.0), Systems
Management Server (1.0, 1.1, 1.2), Internet Information Server (1.0, 2.0, 3.0, 4.0), Proxy
Server (1.0, 2.0), and Visual InterDev 6.
VanStar Corporation
08/94
to 09/95
Houston, TX
Project Engineer
Pre/Post-Sales Technical Support As a national resource for VanStar it was my job to
design systems to be sold to clients as well as support existing ones. My responsibilities
included:
Network design, assisting the Sales Rep in presenting the proposed solution, coordinating
and participating in the installation of Novell and NT Networks, and providing on-site
support for network issues.
Unisys Corporation
11/92
to 08/94
Houston, TX
Senior Systems Engineer
Pre-Sales Technical Support As the technical resource for three sales representatives
covering the states of Texas and Oklahoma it was my job to design systems to be sold to
Unisys clients. My responsibilities included:
Network design, generation of CAD drawing of network, development of Bill of Materials
and Scope of Work Documents, and assisting the Sales Rep in presenting the proposed
solution