GLEN S. NEWCOMB
[Send email using form at bottom]
6197 Linneal Beach Dr.
Apopka FL, 32703
[Send email to request phone number] 68-9224
[Send email to request phone number] 23-2235
Senior Database Lead / Administrator / Mod
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 & 64bit , Oracle (ver. 7.0, 7.3,
8.1, 9i), My SQL,
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), 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:OLAP, Analysis Services, DTS, Lumigent, Embarcadero, Data Junction,
Oracle 9i Streams, Red Gate, Spotlight, Coefficient, Protegrity
Utilities & Packages: Microsoft Project, Legato Backup, Office 2000 & 97, Lotus
Notes, Lotus 123, Corel Draw, Freelance, WordPerfect, Word, ATTMAIL, Exchange,
Data Architect, S-Designer, Exchange
Security, Network & Communications: EFS, Black Ice, Tripwire, IIS, Novell 4.1,
5.0, IntranetWare, BorderManager, GroupWise, NT 4.0, TCP/IP, PC/TCP, NFS/RFS,
3Comm, SNMP, AFT, Exelan, Starlan, ProComm, Terrinova, EM4410, PC Interface,
SoftCall, C-TERM, PC Anywhere, Kermit, Token Ring, Visifax, Carbon Copy
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, IBM Compatible P.C.'s Most related types of
Data Communications Equipment: 3Comm, Cisco, Lucent Technologies, Bay Networks,
IBM SAN
EXPERIENCE SUMMARY
Mr. Newcomb has 17 years of experience in the data processing industry. He has
worked primarily as a consultant in the management, analysis, design,
administration and implementation of Relational Databases with an Emphasis on
Data Warehousing, Data Mining and OLTP. In addition, he has worked in all phases
of project 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, indexing, storage and retrieval of data/documents. He has worked
in the Retail, Manufacturing, Transportation, Credit, Image Processing,
Professional Sports, Hotel and the Telecommunications industries. Mr. Newcomb is
a diligent worker and an excellent team player.
GLEN S. NEWCOMB
Page 2
Career highlights include the following:
09/02/2003 – Present Enterprise Experts
Maitland, Florida
Senior DBA / Principle Consultant
With Enterprise Experts Mr. Newcomb has had the opportunity to work on several
interesting projects that require expert DBA services. For a major drug testing
company Mr. Newcomb and Enterprise Experts were engaged to perform database
development for their new testing production. Mr. Newcomb designed the database
that was clustered and utilized Data Replication to Laboratories requesting the
test. Mr Newcomb was responsible for the creation off all stored procedures that
were used for Data validation sample FPIA and GCMS testing. 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.
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.
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.
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.
04/01/2000 – 06/30/2000 ENGINEERING SOFTWARE SERVICES
Altamonte Springs, Florida
Corporate Benefits Incorporated (Client)
Senior Database Administrator
While on contract with CBI Mr. Newcomb was responsible for the creation,
production installation and maintenance of SQL Server databases. CBI is a 401k
Benefit management firm that has recently been acquired by a national firm. CBI
had requested that Mr. Newcomb create a Sql Server Data Warehouse that would
serve the e-commerce benefit site that it was constructing. Mr. Newcomb created
all structures, stored procedures, user roles and triggers. Some of the
technologies used were: Oracle 7.3, 8i, SQL Server 7.0(Stored Procedure
programming as well as DTS), Pervasive SQL, Windows NT, ASP and HTML
09/01/97 – 04/01/2000 RDV Sports, …. Orlando Magic, Orlando Solar Bears, Orlando
Miracle, RDV Sportsplex
Maitland, Florida
Database Manager, R&D Manager,
Assistant Director of MIS
Originally hired as Database Manager. Duties included all database
administration functions for 20 Sql Server, Act and Access databases. Data
Analysis and Modeling and Database Architurle was completed using ERWIN. The
Sponsorship sales databases tracked initial orders, inventory and shared
information with marketing, finance and broadcast departments. Oracle Advanced
replication was used to accommodate the Kronos time and attendance databases for
all RDV teams. In 1998 was promoted to Research and Development Manager where
duties included all DBA functions, Visual Basic and Web programming as well as
identification, Review and implementation of all IT software. Promoted to
Assistant Director of Information Technologies, reporting to Director of Finance.
Duties included all R&D functions as well as daily functions of the IT
department including management of eight employees and two consultants, budgets,
planning and evaluations.
Implemented new technologies including: Corporate Intranet, Document Imaging,
Club Management, Automated Time and Attendance, Automated sales and marketing
systems as well as custom software for Professional teams such as the Orlando
Magic and Orlando \solar Bears. Used technologies such as SQL Server 6.4,
7.0,,Act Access, VB5 & VB6, Crystal Reports, ODBC, Solaris, Win 95 & 98, Novell,
Sybase and Microsoft Front Page.
01/13/97 – 09/01/97 American Automobile Association. National Office
Heathrow, Florida
Senior Database Administrator / Analyst Architect
Having been assigned to AAA to provide Senior Database Administration support
for 162 development, test and production databases nationwide. Some of Mr.
Newcomb responsibilities include:
• Configuration/Setup of Informix Enterprise data replication.
• Database performance tuning and monitoring. ( Sql Server 6.5 and 7.0 )
• Database space management.
• Oracle Database Administration
• Establishment of Corporate database standards.
• New Installations Troubleshooting.
• Backup Procedures and Monitoring.
• Database planning in relation to Physical and Logical data architecture.
• Acting Liaison between Users, Programmers and Management.
• Create and Maintain Datafeeds from and to various departments.
Some of the technologies used at AAA are: Solaris 2.4, 2.5, HP UX, CRAY, , SQL
Server, Oracle 7.0 & 7.3, Informix (5.0, 7.10, 7.12, 7.14, 7.22) 4gl esqlc, SNMP,
NT, UNIX Shell, Cayanne. Data Architect, Silverrun, Metaworks, Reflections, PC
Anywhere, Visual Basic, SQL Anywhere ,Novell.
02/01/95 - 01/10/97 AT&T/Lucent Technologies CFO Subledger Group,
Maitland, Florida
Client Server, Senior Programmer / Analyst Architect
Assigned to AT&T to provide ORACLE 7.x Database Administration and Client
Server support for the GBCS Accounts Receivable Subledger Interface. AT&T
Corporate Finance Organization requested the development of Business Unit
Subledger to retain detailed transactions supporting General Ledger sheet
accounts. Mr. Newcomb has designed and programmed the data feeds and balance
reconciliation packages responsible for populating the Subledger System. Feeds
are received via AFT and SWS from 7 sites Nationwide, totaling over 14 million
records per day. Mr. Newcomb also is responsible for all Database Administration
including planning, performance tuning, backups, and upgrades. All Client Server
applications were designed and most coded by Mr. Newcomb using the Visual Basic
and PCTCP. Mr. Newcomb also provided user Training for all software designed.
Some of the technologies used where, ORACLE 7.2, 7.3 (PLSQL, SQLDBA, ORACLE
Forms, Pro C, SQLPLUS, SQL Report Writer, Developer 2000) Fox Pro, K shell,
Visual Basic 3.0 & 4.0 , Visual C++, PCTCP, AFT, SWS, Access 2.0, Excel, Word,
ProComm)
04/01/94 - 02/01/95 Cincinnati Bell Information Systems Inc..
Maitland, Florida
Project leader, Image and Database Systems
Integration and Installation
Assigned as Sub-Project Leader of Systems Integration and Installation of Bank
Imaging Software (Image Banc II) and eventually moved to Project Leader. Duty
includes system integration with existing applications and Relational Databases.
Maintaining project schedules, quality assurance and client relations are
required. Designing TCP/IP network configurations and data migration applications
are also included in Mr. Newcomb’s duties. Mr. Newcomb is responsible for
coordinating and managing eight installations and training personnel. Some of the
technologies used are, INFORMIX SQL/4GL/ONLINE, X-Windows, C, TCP/IP,Visual
Basic, Visual C++, Bourne Shell, Microsoft Windows, and Lotus Notes.
06/12/91 - 03/31/94 AT&T IMS Software Development.. Maitland/Lake Mary Florida
INFORMIX Database Administrator/Engineer
The majority of Mr. Newcomb's contract was spent on the ARTS/COSMOS Project.
ARTS / COSMOS is the AT&T / IMS Provisioning system responsible for tracking over
1 million equipment and circuit orders. In addition to provisioning system order
entry and order completion tracking ARTS / COSMOS maintains all expenditure data
as well as existing IMS existing installed equipment. While participating in ARTS
/ COSMOS Mr. Newcomb performed numerous duties including DBA, Lead Analyst,
Designer and Programmer. Under Mr. Newcomb’s responsibility are the Client
Liaison, Customized menu system, Print system, Process Monitoring module, MVS to
UNIX data conversion and database feed, Numerous complex Screens and reports as
well as all DBA duties. Some of the technologies used where, Informix
SQL/4GL/ESQL/C/ONLINE, K shell, Borne Shell, C, Curses, UTS, UNIX V.
In addition to the COSMOS project, Mr. Newcomb co-developed and designed the
AT&T Universal Studios ET Visitor and Reservation System. This system is
responsible for tracking visitor reservations, lodging, meals, billing, and all
other conference and visit needs.
Also while on contract with AT&T SDO, Mr. Newcomb had the opportunity to work on
the AT&T PAL System. PAL Is the AT&T Corporate Patent and Licensing service used
to generate over 80 million dollars in licensing revenues per year. In addition
to patent and license tracking AT&T corporate managers and attorneys use the
system for future prosecution of patent infringement cases.
08/01/90 - 05/01/91 J.C. Penney Credit Corp. , Orlando Florida
INFORMIX Database Administrator/Engineer
Mr. Newcomb was assigned as Senior Database Administrator/Engineer for the NAVI
project. Navi is the New Accounts Video Imaging system for J.C. Penny Credit
Corp. Mr. Newcomb maintained an Informix SQL/4GL database running under SunOS on
a Sun 4/490. Informix Turbo and Plexus Image handling software were also in use.
Mr Newcomb maintained all System related software while reviewing and
implementing enhancements to the System software as well as system related
procedures. Mr. Newcomb was responsible for coding all customized reports and
queries to ensure database integrity. Also while on contract Mr Newcomb
identified and conducted training to Penney's personnel for eventual turnover of
all system duties at contract completion.
On completion of the contract, Penney's application processing grew from 4,000
per day to 21,000 applications processed per day.
|
