Home

Consulting Services

Resume

DIPLOMAS:
MHA, Healthcare Admin/Business, Duke University, Durham, NC (1988)
BA, Language, Northern Michigan University, Marquette, MI (1975)

CERTIFICATIONS:
Microsoft Certified DBA for MS SQL Server
Oracle Certified DBA for 8i/9i
Sun Solaris Certified System Administrator 8.0

TECHNOLOGY EXPOSURE:
December 2004 – Present
SAIC Inc. Corporate Headquarters, San Diego CA
Job Title: Lead Corporate Database Security Architect for MS SQL Server & Sarbanes-Oxley (SOX) IT Advisor (Employee: July 2005)
- Build, test and deploy a comprehensive process of database security assessments and audits suitable for a Fortune 500 company to fully comply with Sarbanes-Oxley audit requirements. Test and deploy security assessment and audit tools in support of SQL Server and Oracle.  Lead project deployment of NGS Squirrel, AppRadar, IPLocks, SQL Compare, SQL Data Compare, AppDetective and DB Audit security tools. Work in conjunction with vendors to provide operational feedback and feature enhancements. Develop custom scripts to enable direct output reporting from each security tool.
- Meticulously define the scope of assessment and audit tools and develop T-SQL custom scripts, stored procedures, triggers and security related jobs to augment limitations of security tools. Design and implement a comprehensive plan for evaluating SQL Server security risk exposure complete with a published set of security assessment metrics linked to Sarbanes-Oxley audit control items.
- Assemble, interpret and test best security practices for SQL Server and Oracle. Make recommendations for deployment or exceptions reporting.
- Design and deploy a data mart of historical security metrics required for performance trend analysis and to identify opportunities for improvement using a star-schema dimensional database design. Enable linked servers and custom code ETL scripts required to migrate selected security assessment and audit data to a central repository.

June 2004 – November 2004
Hewlett-Packard Co., Rancho Bernardo CA
Job Title: Database Developer (Contract)
- Research and recommend 10x scalability issues for H-P Instant Share program. H-P Platform of 1.2 terabyte of data on Four-Server WIN2003 Active/Active MS Cluster service.
- Develop custom DTS packages to integrate diverse data sources. Transform data from normative relational model to a ROLAP dimension storage mode. Extend business value of data by building OLAP Cubes, aggregating and filtering data.
- Relied on real-time notification and analysis of database events and centralize the security management of Microsoft SQL Server servers and databases using standardized scripting supported by MS and SANS best practices. Aggregates and correlates performance statistics and security issues across all managed database nodes.
- Develop both physical and logical changes in database infrastructure required to improve access and performance. Use ERWin modeling tool to redesign database schema to make greater use of table and database partitions.
- Recommend and code the transfer of dynamic SQL into stored procedures and improve metadata documentation.
- Design and establish database testing environment and replicate production demand within the test platform. Design, test and implement replication, log shipping, performance tuning, backups, data security and database consistency checks.
- Fully install and deploy multi-server platform for SQL Server Reporting Services. Use Visual Studio.Net Report Designer and use of tables, matrices and/or charts in static and dynamic web-based reports. Enable both reporting of live source and cached data.
- Design and create delete-free environment through the dynamic SQL build of horizontal partitioned views. Modify data flow to enable truncate v. deletes.

January 2004 - May 2004
Broadcom Inc, Irvine CA
Job Title: Data Warehouse Developer (Contract)
- Migrated physical data warehouse to new server. Warehouse platform for 1.0 terabyte of data on 5-Servers using WIN2000. Applied bcp, DTS, scripts and custom T-SQL stored procedures to move and verify integrity of complete data warehouse platform.
- Translated extract, transform and load (ETL) actions coded in stored procedures into metadata elements of business rules, data origin and other data intelligence aspects. Developed innovative approach to populate and update metadata and extended properties from within stored procedures.
- Use T-SQL stored procedures to ETL financial and human resource data from PeopleSoft system into comprehensive data warehouse.
- Support for data warehouse life cycle management, capacity planning, performance tuning, dimension and relational schema configuration, database installations/backup/restore.
- Designed logical data models, defined major subject areas and their respective relationships. Implemented the physical model based on performance, method of storage and data granularity factors.
- Support for issues addressing data warehouse reporting, analysis, scalability, extensibility, reusability and security.

October 2003 - December 2003
Oracle DBA/Sun Solaris Administration; Training and Certification
University of San Diego; Accounting Department
8 Credit hours; Oracle Project Accounting and Oracle Purchase Requisitions

December 1998 - September 2003
BeXcom Research (subsidiary of BeXcom Inc.), San Diego, CA
Job Title: Database & Data Warehouse Administrator/Developer
- Primary and third level support (remote) for seven regional hubs with 15 SQL instances holding .8 terabyte of data on two-server based WIN2000 Active/Passive MS Cluster service.
- 50% production, backup, maintenance and 50% T-SQL development, stored procedures, DTS, bcp, ETL and data modeling.
- Deployed end-to-end data warehouse platform for largest Business-to-Business (B2B) in Asian Pacific. Advisor to executive staff from six corporate offices: Singapore, Beijing, Taipei, Tokyo, Bangkok and San Diego. Integrated data from 6 remote ecommerce hubs to central warehouse using advance ETL procedures.
- Justified and leveraged data warehouse project with research into three business areas; (1) Several basic reports required several hours to process; (2) Data quality problems were revealed in legacy decision support systems; (3) Staff confirmed an abundance of data but limited knowledge to support planning.
- Delivered warehouse project deliverables consistently ahead of schedule by partnering with priority end-users to generate prototype data systems.
- Administered end-to-end analysis server: create databases, specify data sources, build and process cubes, create and process data-mining models, specify storage options, manage security, browse data sources, research and test third-party applications. Assemble DTS packages using GUI (Analysis Manager) and VB Project.
- Designed and built custom end-user interfaces for both Internet and intranet environments using Visual Basic, ActiveX Data Objects (ADO), Office XP Web Components, MS Data Access Pages, and MS Data Analyzer; thus enabled information workers to focus on business processes.
- Demonstrated ability to coordinate with other technical teams to design the data warehouse technical architecture.
- Firm understanding and knowledge of ETL tools, data mining tools, and meta data management. Evaluate up-to-date hardware, software, and information; and to select the appropriate technology.

October 1995 - November 1998
San Diego Navy Medical Center, San Diego, CA
Job Title: Senior Technology Officer for Medical Operations
- Lead hospital wide migration to decision support Trendstar-HBO/C.
- Develop/maintain mission critical medical databases; customer relations, provider credentials, institution certification.
- Engineer collection, archive and publish of 130GB prescription db.
- Evaluate DB system infrastructure and establish baseline performance.
- Analyze bandwidth requirements; various tools and propose solutions.
- Research and built relational db models for managed care operations.
- Manage IT support/LAN/WAN of 175 workstations and 10 legacy servers.
- Maintain, de-fragment and tune database indexes as user needs change.
- Develop stored procedures/scripts; create/retrieve objects, reports
- Developed practices to monitor security, access/authentication.
- Strong team oriented focus, enthusiastic contributor to innovative.