GLEN S. NEWCOMB
[Send email using form at bottom]
6197 Linneal Beach Dr.
Apopka FL, 32703
 [Send email to request phone number] 68-9224


Senior Database Lead / Administrator 
 Relational Database and Data Warehousing Emphasis

SOFTWARE EXPERIENCE

Operating Systems: Windows 2003, 2000, 98, 95, 3.1, NT 4.0, 3.5, Solaris 2.4,
2.5, 2.6, UNIX (UTS, System V, BSD, SCO, USL), Sun OS , HPUX, VAX/VMS,OS/2, DOS,
Linux

Databases: Microsoft SQL Server 6.5, 7.0,2000, 2005 & 64bit , Oracle (ver. 7.0,
7.3, 8.1, 9i, 10g), MySQL,
Informix 4GL/SQL/ESQL/3.3/ONLINE(ver. 2.1, 4.1, 5.0, 7.10, 7.12, 7.22), Ingres,
Plexus, DataJunction, Microsoft Access (ver2.0, 98, 2000, 2003), Fox Pro for
Windows
 
Data Modeling Tools: Erwin, ER Studio, MetaBase, Clear Data, SilverRun

Languages: Visual Basic (5.0, 6.0, .NET), ASP, SQL, COM, DCOM. ADO, MTS, PLSQL,
HTML PHP, Crystal Reports, K shell, Bourne shell, "C”, C++, XML, Cold Fusion,
JDBC, Java, VBA

DB Utilities: CAST, OLAP, Analysis Services, DTS, SSRS, SSIS, SSAS, Lumigent,
Embarcadero, Data Junction, Oracle 9i Streams, Red Gate, Quest, Spotlight,
Coefficient, Protegrity, Golden Gate, SAS, Business Objects

Utilities & Packages: Dynamics, Microsoft Project, Peregrine, HP Service Center,
Legato Backup, Office 2000 & 97, Lotus Notes, Lotus 123, Corel Draw, Freelance,
WordPerfect, Word, ATTMAIL, Exchange, Data Architect, S-Designer, Exchange



HARDWARE EXPERIENCE
HP, HP Itanium, IBM, Compaq and Dell, Sun Sparc 2, 10, 20, 2000, Enterprise,
Cray SS6000, NCR 3550, 3450, AT&T 3B/600, 3B/1000, Unisys, Amdahl, DEC/VAX, NCR, 
Kodak Jukebox, Kodak PCD Writer,   Most related types of Data Communications
Equipment:  3Comm, Cisco, Lucent Technologies, Bay Networks, IBM SAN


EXPERIENCE SUMMARY
Mr. Newcomb has 19 years of experience in the data processing industry. He has
worked primarily as a consultant in the management, analysis, design,
administration and implementa¬tion of Relational Databases with an Emphasis on
Data Warehousing, Data Mining and OLTP. In addition, he has worked in all phases
of pro¬ject life cycle development, with diversified experience ranging from
analyzing business problems and procedures to project management, obtaining user
requirements, generating database and system standards for performance and
scalability.
Mr. Newcomb has an extensive background in writing software for the
classification, in¬dexing, storage and retrieval of data/documents. He has worked
in the Retail, Manufactur¬ing, Transportation, Credit, Image Processing,
Professional Sports, Hotel and the Telecommunications industries. Mr. Newcomb is
a diligent worker and an excellent team player.





Career highlights include the following:
09/02/2003 – Present	Enterprise Experts, Maitland, Florida
			Senior DBA / Developer
Medex
Medex Pharmaceuticals engaged Mr Newcomb to lead the effort to mine data from 6
disparate databases into a single reporting data warehouse. Data was collected
and manipulated via SSIS and populated into a single data warehouse where SQL
Server reporting services were incorporated to produce enterprise level reports
for Billing, Inventory and Prescription tracking. Additionally Mr Newcomb
redesigned the Medex Disaster Recovery Plan so as to allow for 24/7 operations in
the case of natural disaster. Technologies Used: SQL Server 2005,  TSQL, SSIS,
SSAS, SSRS, Enterprise Data Sync, .Net2.0

Zero Chaos
While contracted with Zero Chaos Mr Newcomb developed specialized reporting that
pull data from a Great Planes Dynamics SQL Server into Microsoft Access and
Microsoft Excel. Data was gathered via SQL Server stored procedure and deliver to
Access for further analysis and to Excel for financial reporting. The main goal
for the project was to help reconcile over 200 Million in receivables. This High
viability project was completed on time and under budget.. Technologies Used: SQL
Server 2000, 2005,  TSQL, Access 2003 and Excel VBA

Davita Labs
Mr Newcomb, was engaged with Davita Labs to complete a conversion of a Act
database to SQL Server 2005. Mr Newcomb created all data transformations using
stored procedures and DTS. All reports were written by Mr Newcomb using Stored
Procedures and Excel. Technologies Used: SQL Server 2000, SSRS, SSIS, SSAS, Act,
Crystal Reports

Loews Hotels
For Loews Hotels International Mr Newcomb was tasked with identifying all SQL
Server systems and implementing a standard set of maintenance and security
standards. Additionally Mr. Newcomb was responsible for upgrading all SQL Server
instances to the current Service Packs. Mr Newcomb has planned, tested and
executed all SQL Server 2000 to 2005 conversions of all candidate SQL 2000
environments. Loews continues to engage and plan conversions with Mr Newcomb.
Technologies Used: SQL Server 2000 & 2005

Orlando Regional Health System
Mr Newcomb was contracted by ORHS to support the development of a 24/7
environment to support all main hospital operations. Using C# Mr Newcomb
developed an automated system that would populate the failover system and provide
a switch to the failover environment in case their Clustered Production
environment was to fail. Additionally Mr Newcomb was tasked with the Performance
review and enhancement of ORHS Custom Reporting Services. The custom reports were
analyzed using SQL Profiler to find missing joins, incorrect use of indexes and
poorly written Stored Procedures. All performance improvements were tested,
measured and implemented by Mr Newcomb. Technologies Used: SQL Server 2000 &
2005, C#.Net.. Golden Gate

LSQ Systems Inc.
This client was experiencing poor performance on their production server that
was running transactional replication. Mr Newcomb recommended and implemented the
solution of separating their Distribution database on a separate server and
separating all reporting functions to a separate environment as well. While
helping LSQ Systems, Mr Newcomb also implemented changes that would distribute
their MDF and LDF files across several Drive Controllers easing the IO
bottlenecks that were being experienced system wide. Additionally Mr Newcomb was
responsible for planning, testing and executing LSQ’s SQL 2000 to SQL 2005 3Tera
Byte Databases. The conversion included all Tables, Jobs, Stored Procedures and
Replication. Technologies Used: SQL Server 2005 SSRS, SSIS, SSAS

Integrasys
For a Major Financial Software Company Mr. Newcomb was engaged to perform
performance analysis on several databases that were experiencing poor performance
in queries and reports. Mr. Newcomb Performed SQL Profile traces and identified
several areas where indexing and data archive were necessary. Additionally Mr.
Newcomb created the Standard, Naming and coding conventions for all database
objects.  Mr Newcomb also developed the Database Upgrade, Install and Conversion
packages using C# and XML to allow Integrasys to distribute packaged (exe)
database changes to their Credit Union Customers. Technologies Used: SQL Server
2000, 2005, C#.Net, Red Gate, Embarcadero, Coefficient
 

UD Testing
For a Major Drug Testing firm Mr., Newcomb was responsible for the creation off
all stored procedures that were used for Data validation sample FPIA and GCMS
testing. Additionally Mr. Newcomb worked with the .Net development staff to
ensure that all Application and Web code utilized SQL Server correctly. Upon
completion of the Database design, and programming Mr. Newcomb and Enterprise
Experts have been engaged to perform 24/7 Database Monitoring and ongoing
Performance Tuning.
Technologies Used: SQL Server 2000, Power Builder

Starwood Resorts
Mr. Newcomb has also been engaged by a major Timeshare corporation to perform 30
database moves from a single server environment to a multi server Clustered
environment. The interesting part of the project was that the client was not
keeping the same server name for the new server. Mr. Newcomb was responsible for
converting all DTS scripts as well as all TSQL Stored Procedure that had hard
coded machine references. This project was completed on time and under budget.
Technologies Used: SQL Server 2000, Embarcadero

03/01/2003 – 09/01/2003  Walt Disney World Information Technology
			Celebration, Florida
			Senior Database Consultant / Data Warehouse Specialist
While on contract with Walt Disney World Mr. Newcomb has had the opportunity to
participate in 3 challenging Projects.
The Corporate Data Encryption project was the result of the California Law that
requires corporations to encrypt sensitive personal data that are housed in
Corporate SQL Server. Mr. Newcomb was responsible for the identifying standards
and products used to protect corporate relational databases. Impact on existing
systems, performance and manageability were meticulously analyzed and
recommendations were documented and implemented corporate wide.  Peregrine was
used to locate and identify systems that were not on the implementation list and
corrections were made upon identification.
Mr. Newcomb was again called on to lead the Key Indicators System data analysis,
data modeling, design and implementation. This projects goals where to tie all
Disney Network Monitoring and Intrusion detection systems together into a single
Data Warehouse.  The Key Indicator system required extensive DTS scripts along
with TSQL stored procedures to mine the data from disparate systems. Once data
was mined the data was loaded in to dimensional cubes. The Key Indicator System
was completed on time and under budget.
For the SQL Standardization Project Mr. Newcomb established standardized
procedures to be used for existing and new database configuration. The Standards
that Mr. Newcomb developed where for Clustered and Non Clustered environments
corporate wide.
In addition to the main project work Mr. Newcomb and a team of 3 other DBA’s
supported all for Walt Disney World’s 400 SQL Server databases residing on 90+
servers.  Some of the technologies used were: Windows 2003, SQL 2000 ENT, SQL
64bit, ERWIN, Analysis Services, OLAP,  Red Gate, Erwin, Microsoft Cluster
Admin.



07/01/2000 – 03/01/2003 GoCo-Op
			Maitland, Florida
			Director Database Administration & Operations
			Lead Database Architect / Administrator
GoCo-op is the premier provider of totally integrated and 100% Web-based
e-procurement solutions that provide measurable cost savings by automating the
entire procurement process -- reducing real administrative and operating expenses
while increasing purchasing power and efficiencies. Mr. Newcomb and his team are
responsible for 100+ SQL Server development, test, UAT, training and production
databases. All SQL Server databases have been converted from 6.5 and 7.0 to SQL
2000. Responsibilities include but are not limited to Database Table & Index
Creation, Data Replication, Full Text Indexing, Disaster Recovery, Stored
Procedure creation and maintenance, Triggers and Views. Mr. Newcomb is also
responsible for data loading from the vendors that GOCO-Op receives production
information from. Mr. Newcomb created the DTS interfaces to vendors SQL Server
2000 and Oracle 9i systems, in which 12,000,000 records were loaded daily.  Data
from smaller vendors comes in various formats such as Excel, Access, Lotus, XML
and ASCII. Having the ability to collect this volume of data allowed Mr. Newcomb
to create and maintain a Centralized Data Warehouse. Creation of OLAP cubes and
DTS Scripts we Mr. Newcomb’s responsibility. Data collected was used to track
purchasing trends and Supply Chain Delivery.  Some of the technologies used are
SQL Server 6.5, 7.0 and 2000, TSQL, DTS, OLAP, XML, Embarcadero Suite, Erwin,
Mercado Search Engine, Access 2000, VBA, Windows 2000 Advanced Server, ASP, VB6
and HTML, Data Junction, SilverRun, Microsoft Project. Review of all new software
and 3rd party tools were also Mr. Newcomb’s responsibility.