Theresa Moore
PO Box 82. | Darby, PA 19023 | H: [Send email to request phone number] 24-4740 | C: 484-784-7320 | [Send email
using form at bottom]
DATABASE ADMINISTRATOR
Database administrator (DBA) with over 20 years IT experience with variety of
database management systems (DBMS). Delivered project development through
production support for IBM DB2 v8 on z/OS, Oracle 9i, 10g and Sybase 12.5 on Sun
Solaris/ Unix 9, SQL Server 2005 on NT.
Areas of expertise include:
Technical Leadership
Project Management
Problem Solving
Decision Maker
Policy and Procedures
Mentoring
Physical Database Design
Client Focus
Collaborating
TECHNICAL SKILLS
Hardware: IBM System z990, IBM System z10, Sun Solaris-Unix, HP-Unix
Databases and Software:
DB2
BMC Alter for DB2, BMC Catalog Manager for DB2, BMC Change Manager for DB2, BMC
Check Plus for DB2, BMC Copy Plus for DB2, BMC Dasd Manager Plus for DB2, BMC
LoadPlus for DB2, BMC Reorg Plus for DB2, BMC Unload Plus for DB2, CA Endevor, CA
Librarian, DB! Explain
Oracle
BMC SQL-BackTrackฎ for Oracle, Oracle Enterprise Manager Grid Control, Oracle
Migration Workbench
SQL Server
SQL Server Enterprise Manager
Sybase
BMC SQL-BackTrack for Sybase, Sybase Central
Other
BMC Control-M, BMC PATROL, BMC SQL-Programmer Expert CA ERWin Data Modeling, HP
ServiceCenter, IBM InfoSphere Metadata Workbench, IBM InfoSphere DataStage, IBM
Tivoli software, Serena PVCS Version Manager, Serena TeamTrack
Tools
Microsoft Office 2003, Microsoft Project, Microsoft Visio
PROFESSIONAL EXPERIENCE
Amethyst Acquisitions Development Holdings, LLC, Darby, PA
Principal Owner
2007 Present
The company was founded to negotiate and acquire deeply discounted real estate,
develop to add substantial value, refinance and manage or sell at a profit.
Amethyst relies heavily on critical data to compete and thrive in its respective
markets.
Key projects:
Gathers and interprets business requirements and analyzes relevant data for
business strategy decision making.
Researches, analyzes, negotiates and acquires hardware and software with
vendor management activities.
Oversees, monitors, and troubleshoots daily business operations.
The Vanguard Group, Malvern, PA
Database Administrator
1997 2007
Vanguard is one of the world's largest investment management companies and the
world's highest-value provider of investment products and services. Approximately
$1.24 trillion in U.S. mutual funds (as of 8/31/2009).
Key projects:
Played a key role in the Sybase to Oracle migration efforts, wrote how-to
document Sybase to Oracle Migration Guidelines used by DBAs and Developers,
persuaded Oracle to present a seminar.
Project Manager for the evaluation and implementation of SQL Backtrack for
Oracle. Coordinated the efforts of several Oracle DBAs as they assessed if
product warranted for implementation.
Principal DBA resource in use and evaluation of ETL tools. Contributed Subject
Matter Expertise and project support to MetaStage and DataStage strategy efforts,
administered support to projects using these tools.
Mirrored databases for heterogeneous platforms from DB2 z/OS to Oracle,
resolved all technical issues, datatype mismatches, and generated physical model
and database.
Demonstrated mentoring skill in cross-training effort on a project requiring
DB2 and Oracle databases.
Assessed the capabilities and usefulness of several third party products
making recommendation for purchase. Worked with vendor installation and
training.
Supported all PeopleSoft environments including 60+ instances for
HR/TL/LMS/WFA/QML/STAT. Evaluated storage use and developed a project plan for a
PeopleSoft storage management clean-up.
Designed physical database models for several database management systems
including DB2, Oracle, and Sybase. Conducted physical database design reviews and
application code reviews.
Provided project support for Microsoft SQL Server databases, including
evaluation and implementation.
SmithKline Beecham Clinical Laboratories, Collegeville, PA
Lead DB2/Sybase Database Analyst
1990 1996
SmithKline Beecham Clinical Laboratories (SBCL) a national testing and service
network consists of regional laboratories, specialty testing operations and its
Genetics Testing Center, as well as a number of rapid-turnaround or "STAT"
laboratories, and patient service centers. SBCL had 1998 revenues of $1.6
billion.
Key projects:
Developed, documented and presented a proposal for DB2 Security Policies and
Procedures across all DB2 application environments creating roles and
responsibilities for database access by functional areas.
Key leadership role quickly developed technical skills in Sybase and HP-Unix,
set policies and directions as a member of the re-engineering Test Services
Delivery process team for the new Automated Laboratory.
Collaborated with IT resources from the Laboratory and Business systems in a
Breakthrough Project Team to evaluate SQL Efficiencies. Presented and published
DB2 SQL DO's and DON'Ts Technical Manual and DB2 SQL DO's and DON'Ts Reference
Card.
Evaluated, recommended, and acquired several DB2 administrative and monitoring
third party tools, organized vendor training for all sector DBAs at SmithKline
Beecham. Coordinated the roll-out of DB! Explain product.
Led Database Physical Design and SQL Coding reviews to ensure efficient data
access with application development teams. Created DB2 and Sybase physical design
models using modeling software.
Chase Manhattan Bank USA, Wilmington, DE
Information Center Specialist / Sr. Programmer/Analyst
1987 1990
Key projects:
Designed and developed several credit card on-line and batch applications for
large FOCUS database systems.
Collaborated with management and vendors in a benchmark of 2 database
management systems, Cullinets IDMS and IBMs DB2, performed a Database Analyst
function. Test resulted in the development of a COBOL application for a large 9
million credit card account DB2 Time Series database system.
Participated in IBM DB2 Design Review for the Time Series database.
General Electric Consulting Services, Philadelphia, PA
Sr. Consultant / Sr. Programmer/Analyst
1985 1987
Key projects:
Opened markets, getting the company on Preferred Vendors List at Bell of PA
and other clients.
Designed, coded, and tested, development enhancements to various financial,
human resources (HRIS), and marketing applications for clients including Bell of
Pennsylvania, Fidelity Bank, Atlantic City Electric, and International Playtex.
Projects developed using IMS DB/DC, CICS, RAMIS, FOCUS and packages.
Allen-Bradley Corporation, Cleveland, OH
Programmer/Analyst
1983 1984
Key projects:
Key role in a new application development project, Bill of Materials (BOM),
for a new startup business area. Developed FOCUS database skills, in analysis and
design of online and batch processes. Contributed 75% of report generation and
40% of the online modules. Coordinated all documentation with a Technical Writer
gave presentation and demonstration to management and users.
Designed, developed and implemented new General Ledger system which interfaced
with other existing systems with FOCUS database technology.
Redesigned and redeveloped Standard Cost system using IBM IMS DB/DC for
installation and implementation in multiple plants.
Collaborated with users clarifying requirements including all phases of
application development in new and existing financial administrative application
systems.
Federal Reserve Bank, Cleveland, OH
Programmer II / Programmer
1981 1983
Key projects:
Designed, coded, tested, documented, implemented, and maintained on-line
teleprocess-OLTP and batch programs for a new quarterly bank reporting system.
Interfaced, presented and trained users. COBOL, PANVALET, TSO/ISPF, MVS/JES2/JCL,
IMS DB/DC, DLI, MFS, MACROs, MIDs, MODs, DIFs, DOFs.
EDUCATION
Drexel University, Philadelphia, PA
Bachelor of Science Management Information Systems
Anticipated completion June 2011
Delaware County Community College, Media, PA
New Choices / New Options Career Development Services
Fall 2009
Delaware County Community College, Media, PA
Associates Applied Science, Major in Data Processing GPA 3.75/4.0
ASSOCIATIONS
TPNG, Philly Tech, HIMSS, HITSP, CCHIT
|
