KATHLEEN SMITH
Garner, NC **529
919-***-**** *******@***.***
PROFILE
Served as a Programmer/Database Analyst with 15+ years of experience in
project and data analysis and management, and full development life cycle
including business requirements, system specification, prototyping,
database design, implementation, testing, and installation. Expansive
background in product, quality assurance and documentation management.
Proficiency includes World Wide Web application development, client/server
development and relational database management systems. Varied software
knowledge and experience, including:
Microsoft Access/VBA/VB (15+ yrs) v2, v97, v2000, v2003, v2007, v2010 (in
training)
ASP, VB Script (4 yrs)
Started QA group, QA Manager, automated and manual testing, use cases
(15+ yrs combined)
Iron Speed Designer (3 yrs), ASP.NET, VB.NET, OOP (junior level)
Database Applications (10+ yrs, most using SQL, Oracle data)
Microsoft Word, Excel (15+ yrs macros,VBA)
Microsoft VISIO, ProjectManager, Powerpoint (5 yrs, as needed)
Dot Net Nuke (DNN) (1 yr)
SQL Red-Gate Tools (1 yr)
Oracle (currently taking Oracle class)
Programmer/Data Analyst (15+ yrs)
Business Analyst (15+ yrs), requirement gathering for various businesses,
IBM, NIEHS/Westat, Glaxo
Relational Database Management (15+ yrs), Legal, Biological, Business
Product Manager for a $10M product (1 yr), authored Asset Management
Competitive Analysis
Documentation Manager (1 yr), Technical Writer (12 yrs)
NSCU Dept of Zoology Technician (1+ yr) designed, wired and programmed
system for data
collection of NSF grant for "Bioenergetics of Fishes"
SUMMARY OF QUALIFICATIONS
. Proven ability to manage and develop internal and external software
applications.
. Unique experience as an IT provider including; design and implementation
of lab oriented hardware and software, support for Epidemiology database
applications supporting collection of biological and environmental
samples and pharmaceutical database applications and support of business
needs.
. Co-designed, developed and maintained several web-based relational
database management systems for data collection and reporting.
. Developed database systems using a wide variety of products operating in
the Microsoft Windows, VM, MVS, World Wide Web and client server
environments.
. Experienced in business requirements, project management, documentation,
web development, database design, software testing and software support
and marketing.
. Excellent organizational skills and problem solving ability.
PROFESSIONAL EXPERIENCE AND ACCOMPLISHMENTS
WESTAT, INC, Durham, NC 2002 - 2010
Program Analyst
. Co-Designed DART- Data Request Access Tool, which was a pilot internal
application specifically developed to assist the Data Coordinator and
improved efficiencies between 75-80%. This product managed all data and
data requests made by NIEHS for the Sister Breast Cancer Study by NIEHS.
Provided prototype for web based application in VB.NET and SQL Server
2005, utilizing the RAD product Iron Speed Designer.
Kathleen Smith Page Two
. Designed, developed and provided support for SEAD - The Study of Estrogen
Activity and Development study by NIEHS the SEAD project focused on
infant-based study to determine evidence and response of soy estrogen
exposure. This ASP/ SQL database web application project tracked three
recruitment sites and collected all data required by the study protocols
including screening outcomes, specimens and measurements, and generated
multiple reports on enrollment completion. Used extracted data from BSI-
II (Biological Specimen Inventory System to report database
discrepancies.
. Designed and developed KOMET lab software (for NIEHS: Molecular and
Genetic Epidemiology Group that managed protocol database and data
assimilation from various formats. This Microsoft Access database
application defined report formatting and prepared generated data to be
used by another external application.
. Co-designed, developed or maintained other NIEHS database applications
for studies including: Sister Breast Cancer Study, Uterine Fibroid Study,
Norway Cleft Study, Agricultural Health Study, Genetic Susceptibility and
the Environment in Cancer, Carolina Lupus Study.
DIALOG, Cary, NC 2000 - 2001
Programmer
. Completed timely data processing tasks associated with monthly processing
cycles. Created, maintained and extracted data to automate report
generation utilizing Excel macros.
. Developed and redesigned several reporting applications, maintained data
in several Remedy applications, provided documentation and support for
various systems.
IBM, RTP, NC 1995 -2000
Programmer/Analyst
. Designed, developed and implemented The Attachrate/Demand Planning
Analysis Database, which was utilized worldwide and provided forecasting
in price/cost/systems volume changes.
. Designed, developed and implemented The Report Generator, which was a
Microsoft Access application automating a five-day process to completion
in under two hour, improving efficiency over 90%.
. Designed, developed and implemented PROMPT (an
inventory/planning/reporting database), which was a Microsoft Access
application automating inventory system analysis.
Additional work experience prior to 1995 available upon request.
EDUCATION/AWARD
Wake Technical College - currently enrolled in Intro to Oracle class
Bachelor of Science - Physics (Engineering Electronics) with
Math/Computer Science concentrations, Appalachian State University,
Boone, NC
Department of Physics and Astronomy Merit Award
MEMBERSHIP/CERTIFICATION
Project Management Institute (PMI)
Studying for PMP certification.
VOLUNTEER WORK
Assisted with library database maintenance for Shepherds Theological
Seminary, Cary, NC
Volunteering for various ministries at Colonial Baptist Church, Cary,
NC