Summary
Sixteen years of experience in the field of content analysis and conversion
on a variety of data sets both large and small for customers ranging from
Healthcare Information publishers (including the United States Pharmacopeia
and the PDR) to Semiconductor manufacturers (Intel, National
Semiconductor, Philips, and Texas Instruments) to NASA.
Profile
Have extensive experience in both print and electronic production of the
Physician's Desk Reference as well as other PDR-outgrowth publications (PDR
Family Guide series), the United States Pharmacopeia's (USP) Drug
Information for the Healthcare Professional, and Advice for the Patient, as
well as Thomson Reuters' TOMES combined hazmat and medical information
internet-based product. Also produced annual Flight Project Data Book
while at NASA HQ for delivery to Congressional Oversite Committees.
Skills Summary
Project Coordination Content conversion
Data Architecture Data Modeling
Data Analysis Data Cleansing
Data Standardization Quality Assurance and Testing
Technical Writing (User Documentation)
Professional Experience
Albert Decker Consulting, LLC Atlanta, GA: Feb 2007 to Present
Partner/Consultant
Partner in this family-owned consulting group offering business,
performance management and information technology services for small
businesses, work directly with clients in a data analysis and quality
management role. Perform customer facing and back office functions.
Analyzed and remediated existing Access database for Georgia based non-
profit to automate correspondence with their clientele and enhanced
functionality of software. Monotored and tracked functionality
improvements and compiled ad hoc reports for the CEO and Board of
Directors.
o Improved productivity for back office staff by 35% via automation of
correspondence.
o Established best practices going forward for future enhancements of
system.
For a Florida based Executive Benefits Consulting firm, developed and
implemented QA testing process and schedule to ensure output produced met
all applicable industry, regulatory, and accounting standards and client
requirements. Performed requirements analysis and designed enhanced web
site and reporting functionality.
o Reduced development testing time by 50%
o Improved client productivity by automating routine financial report
generation, decreasing client workload by 25%
@Tech Technical Staffing San Diego, CA: Nov 2006- Feb 2007
Database Analyst
Managed remediation and maintenance of proprietary audit analysis
application and supporting databases (Access 2003, SQL 2000) for a telecom
expence management consulting firm (contract client) Responsible for
project analysis, planning, tracking and reporting project status to
clients, execution and follow-up. Coordinated QA of application and
acceptance testing by end client. Generated performance metrics reports
for all phases of the project. Accountable for all project management,
development, documentation, training, and user support for client's
proprietary suite of internal audit applications
o Restored application to operation within 2 weeks of hire (following
six months of down time)
Thomson Reuters (formerly Thomson Healthcare) Englewood, CO: 1999-2005
Software Engineer (2000-2005)
Responsible for processing the bulk of a suite of 33 data sets that formed
an integrated internet platform product that provided timely, accurate,
critical medical/pharmaceutical reference and HAZMAT reference and
management information to first-line responders (EMTs, ER personnel, Toxic
Incident Response teams, etc.) Maintained processing applications and user
documentation of all processes and code modification history. Participated
in and contributed to all SDLC reviews. Provided tracking reports to
management of all phases of the project during a production cycle.
Estimated resources needed for each phase of cycle. Processed third-party
and in-house authored input (MS Word, Excel, XML, SGML, HTML, Access and
ASCII text) using BCP scripts, T-SQL queries and stored procedures and
custom ETL applications.
Generated output as HTML files; image files (tif, gif, jpeg, etc), and SQL
Server tables to power an integrated search engine. Created and
established maintenance schedules and generate reports Migrated data from
SQL 7.0/ NT 4.0 to SQL 2000/Windows 2003 environment. Created SQL queries,
scripts and stored procedures to manage database content, scrub and
sanitize anomalies from input data, and sanity check output. Designed DTS
packages to transfer data between production and staging environments
o Developed data scrubbing methodology
o Reduced data errors in the final output product by more than 50%
Data Analyst (1999-2000 --- Also with Thomson Reuters)
Following acquisition of USP Drug Information data sets from the United
States Pharmacopeia, participated in migration of product data from legacy
authoring and production environments at USP into current authoring,
production, and document management environments at Thomson Healthcare.
Modified existing styles sheets to reflect book-format change requests
Assisted in development and maintenance of Documentum content management
tool which sefved as the repository for the database and content. Created
folder structure for Documentum repository.
Developed and delivered on-site training to Editorial staff comprised of
Pharmacologists and other healthcare professionals Wrote Omnimark scripts
to extract data from document management system in support of Patient
Education leaflets project Configured content management system user
environments, permissions, workflows, and directory structures
o Migrated SGML-structured web based, stand alone CDROM and flat file
products
United States Pharmacopoeia (USP) Rockville, MD: 1997-1998
Data Analyst
Implemented key production components of an SGML-based publishing
environment in support of a decentralized document creation process and a
centralized content management system and document processing environment.
Performed document analysis, defined document structures, developed SGML
applications, performed data conversion (to various output formats
including HTML), tagged sample documents and parsed documents and DTDs to
ensure ISO standard compliance all to support a state-of-the-art SGML based
production systems geared to distribute information in a variety of media:
print, on-line, CD-ROM, and the Internet. Formulated and implemented plans
for incorporating new projects into the scope of existing work. Provided
technical support on an ad hoc basis. Assessed skills of USP staff involved
in SGML authoring and implementation, and provided guidance and training.
ATLIS Consulting Group Silver Spring, MD: 1994-1997
Data Analyst
Participated in project converting legacy documents for a major medical
publishing house from QuarkXPress into SGML via initial conversion into
HTML using an off-the-shelf conversion application, then up translating to
SGML. Worked closely with project manager to lead conversion team in
quickly and accurately translating the documents into SGML.
Implemented, and maintained modular, well-documented SGML DTDs and FOSIs
(Format Output Specification Instances - style sheets).
Created extensive application documentation in the form of Tag Libraries
(similar in content and functionality to data dictionaries) for numerous
SGML DTD suites written primarily for publications in the Healthcare,
Pharmaceutical, HAZMAT, and chemical industries.
ANSTEC, Inc. Washington, DC: 1990-1994
Project Analyst II
Administered Unsolicited Proposals Program for NASA Headquarters in
Washington, DC. Program reviewed 600+ proposals annually. Worked closely
with NASA research centers nationwide and with the Office of the General
Counsel and the GAO in support of Congressional investigations by
generating proposal tracking histories.
Created database for processing and tracking unsolicited proposals
throughout peer review process. Developed and implemented process for HQ
and NASA Research Centers nationwide.
Provided complete planning, logistical and operations support for the
Graduate Student Researchers Program (GSRP) and annual conference, and for
the Senior Standing Liaison Group (SSLG) biannual conference between senior
personnel from NASA Headquarters and their colleagues at the Japanese Space
Ministry (NASDA).
Produced the Flight Project Databook: an annual review of all projected
NASA projects up to ten years out provided by NASA to the United States
House of Representatives Congressional Subcommittee on Space and
Aeronautics.
EDUCATION CONTINUING EDUCATION
Pensacola Junior College (PJC) Data Analysis/Design:
Pensacola, Florida Object-Oriented Analysis & Design,
Computer Information Systems NETg
1988-1989 XML Development, Architag
Communications Arts1980-1982 Content Architecture and Design
Workshop, Architag
ErWin Data Modeling Suite
Data Markup Principles and
Technologies:
Style sheet Design Workshop I (for
screen views), ArborText
Style sheet Design Workshop II (for
print output), ArborText
Database Principles, Design,
Implementation, and Management:
Microsoft SQL Server 2000 Querying
with Transact-SQL, NETg
Microsoft SQL Server 2000 Designing
and Implementing Databases, NETg
Introduction to Oracle: SQL and
PL/SQL, Oracle, Inc.
Relational Databases Fundamentals
& Introduction to SQL, NETg
Content Management Systems
Design/Implementation:
Technical Fundamentals of
Documentum, Documentum, Inc
Customizing Client Applications,
Documentum, Inc
Docbase Design Principles,
Documentum, Inc
Additional
MS Excel, Access, Projects,
PowerPoint and Visual Studio .NET
HONORS
Alpha Beta Gamma International
Business Honor Society
(http://www.abg.org/)