Data Manager
Resume:
Title:Data Warehouse Administrator
********@******.**.***
Document
Source below
NAME: Arthur GibsonIII
ADDRESS: **** ******** ** ***** ****
CITY: Austin
STATE/PROVINCE: TX
ZIP/POSTAL CODE: 78735
COUNTRY: USA
EMAIL: ********@******.**.***
PHONE: 512-***-****
CANDIDATE ID: 110407
CITIZENSHIP: US
Citizen
EDUCATION: Master Degree
EXPERIENCE: 4
WILL RELOCATE: Open
RELOCATION INFO:
JOB WANTED: Any
RATE NEEDED: $85000 $89999
HOMEPAGE:
COMMENTS:
HOTSKILLS:
ESUME
Arthur W. Gibson, III
5805 REPUBLIC OF TEXAS, AUSTIN, TX 78735
********@******.**.***
AREAS OF EXPERTISE
Oracle Data Modeling, Oracle Forms Design, Oracle 8i, Database Design, SQL
Tuning, SQL Server 7.0, SQL Server 2000, VB 6.0, VBA, Crystal Reports, MS
Project, MS FrontPage, MS Visio, Visual basic MS Access 2000, Clintrial 3.3 and
4.1, SQL, PLSQL, SQL*Plus, VAX/VMS systems, Unix, Windows NT, Windows 2000,
Microsoft Word, Excel, PowerPoint, Medical Terminology, HTML Programming, SAS,
SPSS
EXPERIENCE
TEXAS HEALTH QUALITY ALLIANCE, AUSTIN, TEXAS
Data Warehouse Administrator
Aug 2000
Present
My current responsibilities include planning, administering and support of the
THQA/TDH Data Warehouse database integrity, database performance, database
maintenance, organization, performance, and security. Create data models,
perform imports/exports, monitor database for potential problems, and create
end user views and extracts. Assist data management personnel and clients to
maximize the use of the Data Warehouse. Be an active member of the Request
Review Committee that analyzes and assesses all data and projects associated
with the Data Warehouse as to its feasibility. Identify issues and/or
conflicts with data or processes that may affect THQAs ability to meet
deadlines or deliverables. Work with the designated project team to facilitate
the resolution of issues. Support clients through the entire process (i.e.
data request delivery, scope, assessment, design, programming, testing,
validation and delivery). Perform continuous quality improvement (CQI) on all
data, files, and processes. Participate as a team member in the design and
analysis of THQA projects. Primary job functions include but or not limited to
the following:
Import, standardize and normalize data from sources such as HCFA, UB92,
NSF and ASCII data files
Develop Database schematics, modeling and data dictionaries
Construct Physical Data Models
Provide day to day support for database implementations in test and
development environments
Perform backup and recovery on databases
Manage database users and security
Replicate and create functional views
Scheduling of routine maintenance
Formulate and monitor policies, procedures and standards surrounding
use of the Data Warehouse
PPD DEVELOPMENT, INC
., AUSTIN, TEXAS
Manager
Clinical Data Management
May 2000
July 2000
Responsibilities as a Manager included Oversight and compilation of timelines
and budgetary needs for Clinical Trials. As a Manager I supervised 8
employees. I also continued to manage two of my own current Clinical Trials.
As a manager I was charged with the task of helping to coordinate a new On-
Line Query system using Seagate Crystal Reports. I still maintained my
responsibilities as the Database Administrator and managed day-to-day usage of
the clinical databases.
PPD DEVELOPMENT, INC
., AUSTIN, TEXAS
Senior Clinical Data Analyst
July 1998
May 2000
Currently my responsibilities include giving Training to the Clinical
Programmers on the use of Clintrial 3.3.3 database management system and how it
interfaces with Oracle and SAS. I am also responsible for training all new
hires within the data management (DM) department on day-to-day use of Clintrial
3.3.3 and how it relates to their responsibilities and roles in data
management. The training class also focuses on basic SQL retrievals from the
database. I am also involved with the Clintrial Administration group within DM
to provide technical support to the department and quality control of database
documentation and structure of the database before the database is approved and
put into production. I am responsible for all of the DBA activities involving
the Clinitrial database and Oracle tables (Clinitrial Database Administrator).
As the DBA I am responsible for executing database loc
ks/freezes and unlocks for Clinitrial databases upon receipt of appropriate
signed approvals. This role is also responsible for the set up of Client-
Specific Data Dictionaries, Test Data protocols and the release of databases
and data entry screens for production upon receipt of appropriate
documentation. Other responsibilities of this position include:
Assigning Oracle table spaces to be utilized by the Clinical Data
Protocols
Creating new user accounts
Creating project/protocol specific user groups for Data Managers,
Programmers, and Clinical Operations Staff
Perform Metadata and Data imports and exports
Ad Hoc SQL Reports and Retrievals
SQL updates and deletions to restricted tables
ILEX ONCOLOGY, INC
., SAN ANTONIO, TEXAS
Senior Clinical Data Analyst
May 1998
- July 1998
Responsibilities included assisting in building, testing and maintaining Oracle
databases (Entry Screens), ERD modeling, using PL/SQL to create stored
procedure and triggers, reviewing and researching new technology, training
Monitors in the use of On-Line-Query System; meeting and discussing data
management processes and procedures with potential sponsors; training CDAs in
the use of Clintrial 4.1 databases; reviewing Data Management SOPs. Also
created basic SQL reports for clients.
ILEX ONCOLOGY, INC
., SAN ANTONIO, TEXAS
Clinical Data Analyst
April 1997
- April 1998
Responsibilities included building, testing and maintaining databases;
developing and implementing an overall data management query plan; creating and
reviewing edit check answers for appropriateness through the use of On-Line-
Query; reviewing data prior to data entry; clarifying illegible entries to data
operator; reviewing documentation for studies; verifying that all necessary
documents are present and have required checks and signatures; performing QC
review of 100f the data to verify that data was entered and corrected
accurately; performing basic coding of study medications and adverse events;
providing test data for specifications to test data entry screens and to test
the edit check programming; designing case report forms, data entry screens
and database tables; ensuring that data on case report forms is accurately
reflected in the study database; writing the specifications for data
verification; creating test data for validation programs; training and
supervising data entry and associate clinical data analyst personnel; training
CRAs in the use of Edit Checks and the On-Line-Query system.
PPD DEVELOPMENT, INC
., AUSTIN, TEXAS
Clinical Research Associate
June 1995
- April 1997
Responsibilities included reviewing Case Report Forms for clinical trial data
accuracy and completeness: auditing data for data entry purposes; designing
patient tracking and lab data screens; querying data for consistency and
accuracy according to protocol specifications; resolving queries for data that
is illegible, incomplete or missing; reporting medical findings with various
team members/associates; generating reports listing adverse events, concomitant
medications, medical history, etc.; coding AEs and Concomitant medications
utilizing WhoArt and WhoDrug Dictionaries; reviewing study data to ensure
scientific an clinical validity and completeness; ensuring that study data is
meaningful and analyzable; designing Case Report Forms; resolving data
discrepancies and providing feedback on how they can be avoided; establishing
guidelines and specifications for data review in specific projects.
EDUCATION
Southwest Texas State University
Bachelor of Science
in Health Care Administration
May 1995
Southwest Texas State University
Master of Science
in Health Research (Health Professions)
May 2000
.
PROFESSIONAL DEVELOPMENT
Society For Clinical Data Management
Drug Information Association (DIA)
PROFESSIONAL PRESENTATIONS
Presented Paper at Society for Clinical Data Management Fall Conference
Standards Manag
Contact this candidate