Searchable Appendix


Resume Home

Resume Appendix Home

 

 

Dr. Michael J. Bisconti

Database Administrator, Developer, & System Architect

 

Quick Resume Appendix (15 pages)

Including SQL Server Skills Matrix, Oracle Skills Matrix, Sybase/Informix Skills Matrix, RDBMS/EAS History & General Technologies Matrix

THIS DOCUMENT IS ONLY VALID FOR THE YEARS COVERED (1972 – 2002)

 

PROFESSIONAL EXPERIENCE 1972 – 2002 CONTINUED

 

5/02 – 5/02        EXS, Inc.     Chicago, Illinois

                        //www.excelaladdin.com

            MS SQL Server DBA & System Architect

                        Consultant (Independent Contract)

 

Installed and configured proxy server and integrated their SQL Server servers.  Installed and configured SMTP Email Server, SMTP Email Client, and Inbox Email Extractor.  Configured the SMTP Email Client to generate Email Merge Documents.  Integrated these components with their SQL Server databases.

 

3/02 – 4/02         A. M. Castle & Co.     Franklin Park, IL  60131

                        MS SQL Server DBA/Oracle DBA/System Architect & DBA/System Architect

                        Instructor

                        Consultant (Consulting Firm 1099 Contract)

 

Instructed members of the Business Intelligence Team in SQL Server 7.0/2000 Database Administration and Data Warehouse Development on NT 4.0 and Windows 2000 and in Oracle 8/8i Database Administration on NT 4.0, Windows 2000 and UNIX (HP-UX).  Instructed the Network Group in backup/recovery procedures for SQL Server 7.0/2000 on NT 4.0 and Windows 2000 and for Oracle 8/8i on NT 4.0 and Windows 2000 and UNIX (HP-UX).

 

1/02 – 2/02         EXS, Inc.     Chicago, Illinois

                        //www.excelaladdin.com

                        MS SQL Server DBA & System Architect

                        Consultant (Independent Contract)

 

Called in to handle emergency disaster recovery and to redesign their backup/recovery system.

 

10/01 – 12/01    Daimler Chrysler Corporation     Belvidere, IL

                        Oracle DBA/MS SQL Server DBA

                        Consultant (Consulting Firm W2 Contract)

 

· Oracle DBA.  · MS SQL Server DBA.  · Replaced their old backup/recovery system with one that is more efficient and user-friendly.  · Installed and configured ArcServe on their Oracle 8.0.6 NT 4.0 Server using RAID 0 and RAID 5.  · Performance tuned Oracle databases and MS SQL Server databases.  · Replaced embedded SQL with stored procedures to improve performance.  · AS400 exposure.

 

7/01 – 9/01        Arlington Industries     Libertyville, IL

                        Oracle DBA/Architect Technical Advisor

                        Consultant (Consulting Firm)

 

· Oracle DBA/Architect.  · Oracle 8i running on Windows 2000. · Provided recommendations relative to their planned Progress/Oracle Database Expansion with particular emphasis on the Progress/Oracle Dataserver and the Progress-to-Oracle Database Conversion Utility.

 

6/01 – 7/01        U.S. Office Products/The Systems House     Des Plaines, IL

                        MS SQL Server DBA and NT 4.0/Windows 2000 System Architect

                        Consultant (Consulting Firm W2 Contract)

 

Developed custom Performance Tracking Architecture for the 75 servers making up the NT 4.0/Windows 2000 component of this installation.  The architecture was based upon an analysis of the types of servers.  The critical types of servers were Ecommerce Web Servers using IIS, and SQL Server servers.  Quality Assurance was also addressed as well as a score of other issues.  The Systems House is a model for computer installations throughout the world, incorporating Unidata, RS 6000 and NT 4.0/Windows 2000 servers, all supported by world-class, failsafe UPS systems.

 

12/00 – 5/01       EXS, Inc.     Chicago, Illinois

                        //www.excelaladdin.com

                        MS SQL Server DBA & System Architect

                        Consultant (Independent Contract)

 

Utilized Microsoft’s Web Solution Platform (formerly known as Windows DNA) to address projected performance needs.  Considered 2-tier, 2 ½-tier and n-tier (3-tier and complex 3-tier) architectures.  Developed the framework for conversion from a 2-tier to a 3-tier architecture.  The main component was NT’s Transactional Component Services, particularly Microsoft Transaction Server (MTS) and the Distributed Transaction Coordinator (DTC).  Internet Information Server (IIS) and Exchange Server were incorporated into the architectural plan as well as replication and Microsoft Cluster Server (MSCS).  Transactional connectivity to Oracle and DB2 databases, integration with Microsoft Message Queue Server (MSMQ), transactional mainframe connectivity via Microsoft SNA Server and the COM Transaction Integrator were addressed as well as COM/DCOM and IDE requirements.  Finally, database pointers were used to reference audio and graphics files.

 

8/00 – 11/00       American Academy of Pediatrics     Elk Grove, Illinois

                        MS SQL Server Production DBA & IT Department DBA Instructor

                        Consultant (Consulting Firm W2 Contract)

 

Specialized in Performance Tuning & Optimization for MS SQL Server 6.5 and 7.0 running on NT 4.0 implemented on Compaq Proliant servers using RAID 1 and RAID 5 in a production environment.  Achieved a Production Server Performance Gain of 266%.  The principal areas addressed were application optimization, checkpoint, CPU bottlenecks, deadlocks, disk bottlenecks, disk i/o parallelism, disk space, fillfactor, index create memory, index optimization, lazy writer, locks, log manager, max async i/o, max server memory, memory bottlenecks, min server memory, open objects, pad_index, paging, query optimization, read-ahead manager, recovery interval, user connections, worker threads and some items from the section -SQL Server Performance- for the Merchant Account Corporation below.  Utilized OLAP Services (renamed -Analysis Services- in SQL Server 2000).  Provided over 1,000 pages of documentation including statistical server data/graph volumes, implementation reports and instructional materials.  Also, assisted in a version migration from 6.5 to 7.0 as well as a hardware migration from a 2-processor to a 4-processor server.

 

5/00 – 8/00         Aon Corporation     Chicago, Illinois

                        MS SQL Server DBA, Oracle DBA & IT Department DBA Instructor

                        Consultant (Consulting Firm W2 Contract)

 

Addressed maintenance and performance needs (see previous projects) for MS SQL Server 6.5 and 7.0 and Oracle 8i servers running on NT 4.0 and Oracle 8i servers running on UNIX (SVR4/4.2), implemented on Compaq Proliant and Dell servers, using RAID 1 and RAID 5.  Developed plans for server disaster recovery, installation, upgrading and migration.  Performed server installations, upgrades from SQL Server 6.5 to 7.0, audits and disaster recovery simulations.  Guided clustering and redundancy design implementation.  Taught classes and provided documentation in SQL Server architecture, storage management, setup, configuration, SQL Agent, SQL Mail and performance tuning and optimization.  Also, assisted as Sybase and DB2 UDB DBA developing schemas and creating stored procedures.  Finally, exposure to AS400.

 

1/00 – 4/00         Merchant Account Corporation     Chicago, Illinois

                        EXS, Inc.     Chicago, Illinois

                        //www.excelaladdin.com

                        MS SQL Server DBA and Developer, Web Developer

                        Consultant (Independent Contract)

 

Designed and implemented a complete ECommerce Solution for a network of websites, utilizing SQL Server Administration and Development skills and Web Programming skills.  Considerable time was devoted to improving SQL Server Performance.  MS SQL Server 7.0 running on NT 4.0.  Also performed SQL Server maintenance tasks. See the section -Alphabetical list of tasks and troubleshooting events- for the Chicago Board of Trade below.

 

SQL Server Performance

 

Monitored CPU, Memory, I/O Subsystem and Network.  The following enhancements were implemented:

 

CPU

 

Priority Boost – This option was set to 1 because we were using dedicated SQL Server computers.  Max Worker Threads – This was set to a number greater than the number of user connections to avoid thread pooling (which results in user connection wait time).  SMP Concurrency – This option was set to -1 (use all processors) since we were using a dedicated, mutiprocessor server.

 

Other CPU Strategies – Moved services and applications to different servers.  Started to run services and applications at different times.  Stopped using server as a workstation.  Took SQL Server off of domain controller.  Switched to intelligent controllers for bus mastering and I/O.  Upgraded single CPUs to a higher class and clock speed.  Upgraded to multiple CPUs.

 

Memory

 

· Free memory in excess of 4 Megabytes was assigned to SQL Server. This number never fell below 4 Megabytes; therefore, Windows NT never issued a request for applications to reduce their working sets.  · The size of the Windows NT Paging file was increased.  · Unnecessary applications and services were removed.

· Unnecessary network protocols were removed.  · The amount of physical memory was increased by 2 GB.

 

I/O Subsystem

 

· Used the Max Async I/O and Max Lazywrite I/O options. Monitored Physical Disk: Avg. disk Queue Length counter. The value was consistently less than Max Async I/O.  The values for Max Async I/O and Max Lazywrite I/O were increased by 25%.  · Used the free buffers option. This was increased by 25% since the SQL Server: I/O – Single-page Writes counter was high.  · Implemented RAID 5.  · Switched to high-performance controllers.  · Removed unnecessary file-server roles from the server.  · Used hardware-based RAID.  · Used higher-performing hard disks.  · Switched to wider-bus motherboards and controllers.  · Placed tempdb on the fastest possible device.  · After optimizing the data cache, set tempdb to 200 Megabytes to meet demands made on system and since the cache hit ratio was consistently low and no other means could be taken to improve it such as rewriting queries or altering data structures. After increasing the physical memory, the amount of RAM available to the SQL Server was far above what it actually needed to operate effectively as indicated by a consistently high cache hit ratio and low physical I/O.

 

Network

 

· Stopped using the encryption feature of the multi-protocol net library since over-the-wire encryption was not needed.  · Used the packet size option to reduce the packet size.  Obtained faster response times.  · Made certain that Windows NT was set to Maximize throughput for Network applications.  · Recommended that 16-bit network cards (800 kps) be replaced with 32-bit cards (1200 kps).  · Suggested that network traffic to the server might be reduced through routing changes.  · Recommended that switched hubs be used to reduce overall bandwidth usage.  · Recommended installation of multiple network cards on the server, and that each card be configured to send to a different part of the network.

 

Other Strategies

 

User Connections – Monitored the number of connected users during normal usage sessions to determine this number.

Procedure cache – Decreased the percentage of free RAM to reserve for procedure headers and execution trees to 20% since RAM was considerable.

Open Databases – Set the maximum number of databases that can be open simultaneously to 50.

Open Objects – Set the maximum number of database objects that can be open simultaneously to 1000.

Locks – Set the number of available locks to 10,000 since SQL Server displayed messages that the number of available locks was exceeded and based on number of connected users.

Logwrite sleep – Increased to 200 since RAM was considerable.

 

Websites

 

The websites submit online transactions to SQL Server.  The submission pages submit customer information to SQL Server using the http -POST- function.  Some custom, HTML tags were created, including a tag for credit card transactions.

 

5/99-12/99         Chicago Board of Trade     Chicago, Illinois

                        MS SQL Server DBA

                        Consultant (Consulting Firm W2 Contract)

 

· MS SQL Server 6.5 and 7.0 running on NT 4.0.

· Peripheral work as Oracle and DB2 UDB DBA developing schemas, creating stored procedures, triggers, indexes, etc.

· Alphabetical list of tasks and troubleshooting events:  Architecture and Planning, Assist Application Developers in Applying RDBMS Technology, Backup Device Creation, Capacity Planning for Database Servers, Corrupt Application Database, Corrupt Master Database, Corrupt Table, Data Destruction or Loss, Database Backups, Database Changes, Database Creation, Database Data Only Transfer, Database Deletion (Drop), Database Disaster Recovery Planning Including Testing Scenarios and Documentation, Data Integrity, Database Maintenance Schedule, Database Object Missing (No Data), Database Object Updates, Database Recovery, Database Restore, Deadlocks (or Blocking), Development Database Planning, Data Transformation Services, Data Warehousing, Geographical Load Balancing, Logical and Physical

   Database Design, Nightly Batch Process, NT Server, Out of Disk Space, Event, Performance Monitor Alert Setup, Problem Tracking/Resolution Event Report, Production Database Planning, QA and Architecture Review, QA-ing a Server, Replication (Publishing, Subscribing, Distributing), Security Requirements, Service Pack/Maintenance Updates, SQL Server Alert and Task Creation, SQL Server Performance Issues, Task Scheduler Not Working, Test Database Planning, Transaction Log Dump with INIT, Transaction Log Dumping at 50% Full, Transaction Log Fails to Dump, Transaction Log Filled Due to Open Tran, Unkillable Process, Understanding of 24 x 7 Database Support, User Connections Exceed Threshold

· This project required the signing of a confidentiality agreement.  However, participation in the project is

   authenticated by several hundred pages of records and affidavits in the public domain.

 

1/99-4/99           General Electric Company     Naperville, Illinois Oracle DBA, MS SQL Server DBA

                        Consultant (Consulting Firm W2 Contract)

 

· Oracle DBA, Oracle Developer, MS SQL Server DBA, MS SQL Server Developer.  · Oracle 8 running on NT 4.0 and UNIX (SVR4.2).  · Microsoft SQL Server 6.5 and 7.0 running on NT 4.0.  · Administered, developed and consolidated Oracle databases.  · Administered and migrated Microsoft SQL Server databases to Oracle.  · Migrated Access databases to Microsoft SQL Server.  · Handled database design, tuning, backup, recovery, export, import, application tuning.  · Developed and administered the Oracle database back end of a web site which was integrated with a series of ongoing, national, television commercials.  · This project required the signing of a confidentiality agreement.  However, participation in the project is authenticated by several hundred pages of records and affidavits in the public domain.  Also, exposure to AS400.

 

11/98-12/98       MCI WorldCom, Inc.     Chicago, Illinois

                        Technical Assessment Expert in Oracle and MS SQL Server

                        Consultant (Consulting Firm W2 Contract)

 

· Oracle DBA, MS SQL Server DBA.  · Oracle 7 running on NT 4.0 and UNIX (AIX 4.3.2).  · Microsoft SQL Server 6.5 and 7.0 running on NT 4.0.  · Prepared a Technical Assessment of the Paradox/Oracle Database Conversion of the Teleconferencing System of MCI WorldCom.

 

5/98-10/98         Amoco Corporation     Chicago, Illinois Oracle DBA, MS SQL Server DBA

                        Consultant (Consulting Firm W2 Contract) · Developed the Customer Subsystem for Amoco’s Terminal Automation System.  · Oracle DBA, MS SQL

Server DBA, Visual C++ Developer.  · Oracle 7 running on NT 4.0, UNIX (AIX 4.1.5) and UNIX (SVR4).  · Microsoft SQL Server 6.5 running on NT 4.0.  · Administered and migrated MS SQL Server databases.  · DB2.

 

9/97-4/98           Kraft Foods     Northfield, Illinois MS SQL Server DBA

                        Consultant (Consulting Firm W2 Contract)

· MS SQL Server DBA, MS SQL Server Developer.  · Microsoft SQL Server 6.5 running on NT 4.0.

· Developed SQL procedures for a variety of reports.  · Developed the Reports segment of Kraft’s KAPS System.  · Developed reports in Crystal Reports 6.0.

1/97-8/97           Rockford Electronics     Rockford, Illinois MS SQL Server DBA, Oracle DBA

                        Consultant (W2 Contract)

· Developed systems for clients of a Rockford-based, computer-hardware, electronics company:

1.  Rockford Manufacturer:  Planned Maintenance System, Oracle DBA, Oracle 7 running on NT 4.0.

2.  Rockford Realtor:  Sales Tracking System, Oracle DBA, Oracle 7 running on NT 4.0, Visual Basic Developer.

3.  Rockford Retail Outlet:  Purchase Order System, Oracle DBA, Oracle 7 running on NT 4.0, MS SQL Server DBA, Microsoft SQL Server 6.5 running on NT 4.0, Administered and migrated MS SQL Server databases, Visual C++ Developer.

 

10/95-1/97         U.S. Robotics (3Com Corporation)     Morton Grove, Illinois Senior Systems Analyst

· Oracle DBA and MS SQL Server DBA.  · Oracle 7 running on NT 4.0 and UNIX (SVR4).  · Microsoft SQL Server 6.5 running on NT 4.0.  · Developed Technical Database in Oracle, and its Visual Basic front end.  · Developed Radio Frequency Data Collection (RFDC) Program in Visual C++ and integrated its    functionality with the Technical Database.  · Migrated MS SQL Server databases to Oracle.  · Developed Bar Code Maker Database in MS SQL Server, Dispatch Database, Material Requirements Planning Database and Purchase Order System Database in Oracle, and their Visual Basic front ends.  · Was a significant factor in obtaining ISO Certification for U.S. Robotics through the development of a Planned Maintenance System Database recognized as -Best of Industry- by the ISO Committee.

· Functioned as Project Manager for a Programming Group consisting of 20 programmers and technicians.  · Utilized database pointers to reference audio and graphics files.

 

8/87-10/95         MicroPlus Consultants     Chicago, Illinois

                        Systems Development Consultant · Created a Customer Database at Rand McNally for their Public Relations Department in Dbase IV. · Created a Product Database at Kraft Foods in Access, Excel and Visual Basic for their National Sales Department.  · Created a Membership Database in Paradox and Quattro Pro at the National Safety Council for their C&A Department.  · Developed an Automated Proposal Generation System in Access and Visual Basic for the National Safety Council.  · Developed a Quarterly Accountability MultiSpreadsheet Database in Access for invoice tracking at Océ.  · Served as acting Network Administrator at Peoples Choice Cable TV.  Programmed new workstations and performed hardware installation and configuration. Handled the LAN end of a LAN-to-WAN conversion.  · Handled daily responsibilities for batch processing of tax data under OS/VS1 and IDMS on an IBM 4341 mainframe, for Computax.  · Handled accounting responsibilities on a WANG minicomputer.

1/72 – 8/87         Graphics Systems, Inc.     Chicago, Illinois IT Department Manager / Systems Development Manager Served as department manager, project manager, team leader and lead programmer. Reorganized the IT Department to meet the new, competitive requirements of the microcomputer age.  Involved in matters relating to business development, practice management, project management, proposal development and operations management.  Hired new information technology professionals, assigned work and supervised and evaluated staff.  Ensured that the staff was appropriately trained and challenged and that career paths were provided.  Negotiated with consulting vendors, software vendors and hardware vendors.

 

EDUCATION · Postdoctoral Studies, Northwestern University · Postdoctoral Studies, Wright College · Ph.D. in Applied Computer Science, MicroTech Institute

· M.S. in Computer Science, MicroTech Institute

· Graduate Studies, Providence Christian Seminary

· B.E., Midwestern College

 

PUBLISHED WORKS

 

RDBMS Essentials for Microsoft SQL Server  © 1998, 2000

Microsoft SQL Server – Performance Tuning and Optimization  © 1999, 2000

RDBMS Essentials for Oracle  © 1997, 2000

Oracle – Performance Tuning and Optimization  © 1997, 2000

 

RDBMS CERTIFICATIONS

 

DBA Certifications                        · MTI Microsoft SQL Server 6.5 DBA

                                                     · MTI Microsoft SQL Server 7 DBA

                                                     · MTI Microsoft SQL Server 2000 DBA

                                                     · MTI Microsoft SQL Server 2003 DBA

                                                     · MTI Oracle 8i DBA

                                                     · MTI Oracle 9i DBA

                                                     · CBT Oracle 7

                                                     · CBT Oracle 8i

 

Operating System Certfications    · CBT Windows NT 4.0

                                                     · CBT UNIX

                                                     · CBT Windows 2000

 

Other RDBMS Certifications         · CBT Client-Server

                                                     · CBT Networking

                                                     · CBT SQL

                                                     · CBT T-SQL

                                                     · CBT SQLPlus

                                                     · CBT PL-SQL

 

OTHER CERTIFICATIONS

 

CBT Certifications in C, C++, Object-Oriented Programming, Operating System Assessment, Visual Basic 4.0, Visual Basic 5.0, Visual C++ & MFC Applications Development, Web Development

 

MAJOR HONORS AND AWARDS

 

· Ph.D., Summa Cum Laude

· ISO Best Of Industry

 

ADDITIONAL DOCUMENTATION

 

· 1-page Resume

· 2-page Resume

· 4-page Resume

· 1-skill Experience Files

· References

· Academic Credentials

 

SQL SERVER SKILLS MATRIX

 

Skill

SQL Server 6.5

SQL Server 7.0

SQL Server 2000

Analysis Services (OLAP Services)

——

Yes

Yes

Backup/Recovery

Yes

Yes

Yes

Batch processing

Yes

Yes

Yes

BCP/Export/Import

Yes

Yes

Yes

Capacity planning

Yes

Yes

Yes

Clustering and redundancy design

Yes

Yes

Yes

Daily maintenance

Yes

Yes

Yes

Database maintenance plans, scheduling, alerts

Yes

Yes

Yes

DCL/DDL/DML

Yes

Yes

Yes

Devices, databases and logs – design, creation, and updating

Yes

Yes

Yes

Disaster Recovery

Yes

Yes

Yes

Documentation – policies and procedures

Yes

Yes

Yes

DTS (Data Transformation Services)

Yes

Yes

Yes

Hardware/RAID

Yes

Yes

Yes

Indexing, index statistics updating and index optimization

Yes

Yes

Yes

Install/Configure/Upgrade

Yes

Yes

Yes

Load balancing

Yes

Yes

Yes

Logical design (schema)

Yes

Yes

Yes

Migration

Yes

Yes

Yes

Monitoring, including DBCC (Database Consistency Checking)

Yes

Yes

Yes

Network/OS

NT

NT, Win 2000

NT, Win 2000

OLAP (Data warehousing)

Yes

Yes

Yes

OLTP

Yes

Yes

Yes

Performance Tuning (Optimization)

Yes

Yes

Yes

Physical design

Yes

Yes

Yes

Query Optimization

Yes

Yes

Yes

Replication

Yes

Yes

Yes

Security (User) administration

Yes

Yes

Yes

SQL (T-SQL)

Yes

Yes

Yes

SQL Server end of architecture (2-tier, 2½-tier, 3-tier & other n-tier)

Yes

Yes

Yes

SQL Server end of ecommerce solutions

Yes

Yes

Yes

SQL Server vendor relations

Yes

Yes

Yes

Stored procedures, triggers, constraints, views

Yes

Yes

Yes

Tables, fields (columns), records (rows) – creation and updating

Yes

Yes

Yes

Troubleshooting

Yes

Yes

Yes

 

ORACLE SKILLS MATRIX

 

Skill

Versions 7.x

Versions 8.x

Versions 9.x

Backup/Recovery

Yes

Yes

Yes

Batch processing

Yes

Yes

Yes

Export/Import

Yes

Yes

Yes

Capacity planning

Yes

Yes

Yes

Clustering and redundancy design

Yes

Yes

Yes

Daily maintenance

Yes

Yes

Yes

Database maintenance plans, scheduling, alerts

Yes

Yes

Yes

DCL/DDL/DML

Yes

Yes

Yes

Devices, databases and tablespaces – design, creation, and updating

Yes

Yes

Yes

Disaster Recovery

Yes

Yes

Yes

Documentation – policies and procedures

Yes

Yes

Yes

Hardware/RAID

Yes

Yes

Yes

Indexing and index optimization

Yes

Yes

Yes

Install/Configure/Upgrade

Yes

Yes

Yes

Load balancing

Yes

Yes

Yes

Logical design (schema)

Yes

Yes

Yes

Migration

Yes

Yes

Yes

Monitoring

Yes

Yes

Yes

Network/OS

NT, Unix

NT, Unix

NT, Unix

OLAP (Data warehousing)

Yes

Yes

Yes

OLTP

Yes

Yes

Yes

Performance Tuning (Optimization)

Yes

Yes

Yes

Physical design

Yes

Yes

Yes

Query Optimization

Yes

Yes

Yes

Replication

Yes

Yes

Yes

Security (User) administration

Yes

Yes

Yes

SQL (PL/SQL)

Yes

Yes

Yes

Oracle end of architecture (2-tier, 2½-tier, 3-tier & other n-tier)

Yes

Yes

Yes

Oracle end of ecommerce solutions

Yes

Yes

Yes

Oracle vendor relations

Yes

Yes

Yes

Stored procedures, triggers, constraints, views

Yes

Yes

Yes

Tables, fields (columns), records (rows) – creation and updating

Yes

Yes

Yes

Troubleshooting

Yes

Yes

Yes

 

SYBASE/INFORMIX SKILLS MATRIX

 

Skill

Backup/Recovery

Batch processing

Export/Import

Capacity planning

Clustering and redundancy design

Daily maintenance

Database maintenance plans, scheduling, alerts

DCL/DDL/DML

Devices and databases – design, creation, and updating

Disaster Recovery

Documentation – policies and procedures

Hardware/RAID

Indexing and index optimization

Install/Configure/Upgrade

Load balancing

Logical design (schema)

Migration

Monitoring

Network/OS – NT, Windows 2000, Unix

OLAP (Data warehousing)

OLTP

Performance Tuning (Optimization)

Physical design

Query Optimization

Replication

Security (User) administration

SQL

Sybase/Informix end of architecture (2-tier, 2½-tier, 3-tier & other n-tier)

Sybase/Informix end of ecommerce solutions

Sybase/Informix vendor relations

Stored procedures, triggers, constraints, views

Tables, fields (columns), records (rows) – creation and updating

Troubleshooting

 

RDBMS/EAS HISTORY (MAJOR PROJECTS ONLY)

 

RDBMS/EAS History (Major Projects Only)

Utilization

Enterprise Application Software

Relational Database Management System

Company

Business Intelligence

Business Objects

Oracle

EXS, Inc.

Business Intelligence

Business Objects

SQL Server

EXS, Inc.

Business Intelligence

J. D. Edwards

Oracle

EXS, Inc.

Business Intelligence

J. D. Edwards

SQL Server

EXS, Inc.

Business Intelligence

Peoplesoft

SQL Server

EXS, Inc.

Business Intelligence

Business Objects

Oracle

Solutions, OCC

Business Intelligence

Business Objects

SQL Server

Solutions, OCC

Business Intelligence

J. D. Edwards

Oracle

Solutions, OCC

Business Intelligence

J. D. Edwards

SQL Server

Solutions, OCC

Business Intelligence

Peoplesoft

SQL Server

Solutions, OCC

Customer Relationship Management

Business Objects

Oracle

EXS, Inc.

Customer Relationship Management

Business Objects

SQL Server

EXS, Inc.

Customer Relationship Management

J. D. Edwards

Oracle

EXS, Inc.

Customer Relationship Management

J. D. Edwards

SQL Server

EXS, Inc.

Customer Relationship Management

Peoplesoft

SQL Server

EXS, Inc.

Customer Relationship Management

Business Objects

Oracle

Solutions, OCC

Customer Relationship Management

Business Objects

SQL Server

Solutions, OCC

Customer Relationship Management

J. D. Edwards

Oracle

Solutions, OCC

Customer Relationship Management

J. D. Edwards

SQL Server

Solutions, OCC

Customer Relationship Management

Peoplesoft

SQL Server

Solutions, OCC

Enterprise Resource Planning

Business Objects

Oracle

EXS, Inc.

Enterprise Resource Planning

Business Objects

SQL Server

EXS, Inc.

Enterprise Resource Planning

J. D. Edwards

Oracle

EXS, Inc.

Enterprise Resource Planning

J. D. Edwards

SQL Server

EXS, Inc.

Enterprise Resource Planning

Peoplesoft

SQL Server

EXS, Inc.

Enterprise Resource Planning

Business Objects

Oracle

Solutions, OCC

Enterprise Resource Planning

Business Objects

SQL Server

Solutions, OCC

Enterprise Resource Planning

J. D. Edwards

Oracle

Solutions, OCC

Enterprise Resource Planning

J. D. Edwards

SQL Server

Solutions, OCC

Enterprise Resource Planning

Peoplesoft

SQL Server

Solutions, OCC

Financials

Business Objects

Oracle

EXS, Inc.

Financials

Business Objects

SQL Server

EXS, Inc.

Financials

J. D. Edwards

Oracle

EXS, Inc.

Financials

J. D. Edwards

SQL Server

EXS, Inc.

Financials

Peoplesoft

SQL Server

EXS, Inc.

Financials

Business Objects

Oracle

Solutions, OCC

Financials

Business Objects

SQL Server

Solutions, OCC

Financials

J. D. Edwards

Oracle

Solutions, OCC

Financials

J. D. Edwards

SQL Server

Solutions, OCC

Financials

Peoplesoft

SQL Server

Solutions, OCC

Human Resources

Business Objects

Oracle

EXS, Inc.

Human Resources

Business Objects

SQL Server

EXS, Inc.

Human Resources

J. D. Edwards

Oracle

EXS, Inc.

Human Resources

J. D. Edwards

SQL Server

EXS, Inc.

Human Resources

Peoplesoft

SQL Server

EXS, Inc.

Human Resources

Business Objects

Oracle

Solutions, OCC

Human Resources

Business Objects

SQL Server

Solutions, OCC

Human Resources

J. D. Edwards

Oracle

Solutions, OCC

Human Resources

J. D. Edwards

SQL Server

Solutions, OCC

Human Resources

Peoplesoft

SQL Server

Solutions, OCC

Supplier Relationship Management

Business Objects

Oracle

EXS, Inc.

Supplier Relationship Management

Business Objects

SQL Server

EXS, Inc.

Supplier Relationship Management

J. D. Edwards

Oracle

EXS, Inc.

Supplier Relationship Management

J. D. Edwards

SQL Server

EXS, Inc.

Supplier Relationship Management

Peoplesoft

SQL Server

EXS, Inc.

Supplier Relationship Management

Business Objects

Oracle

Solutions, OCC

Supplier Relationship Management

Business Objects

SQL Server

Solutions, OCC

Supplier Relationship Management

J. D. Edwards

Oracle

Solutions, OCC

Supplier Relationship Management

J. D. Edwards

SQL Server

Solutions, OCC

Supplier Relationship Management

Peoplesoft

SQL Server

Solutions, OCC

Supply Chain Management

Business Objects

Oracle

EXS, Inc.

Supply Chain Management

Business Objects

SQL Server

EXS, Inc.

Supply Chain Management

J. D. Edwards

Oracle

EXS, Inc.

Supply Chain Management

J. D. Edwards

SQL Server

EXS, Inc.

Supply Chain Management

Peoplesoft

SQL Server

EXS, Inc.

Supply Chain Management

Business Objects

Oracle

Solutions, OCC

Supply Chain Management

Business Objects

SQL Server

Solutions, OCC

Supply Chain Management

J. D. Edwards

Oracle

Solutions, OCC

Supply Chain Management

J. D. Edwards

SQL Server

Solutions, OCC

Supply Chain Management

Peoplesoft

SQL Server

Solutions, OCC

 

GENERAL TECHNOLOGIES MATRIX

 

Expert in Database Technologies and Enterprise Applications Software Technologies.  Where essential, length of experience is provided in parentheses.

 

Development

 

Communications

Databases

Editors/Utilities

ActiveX

Banyan

Access

Clist

DOS Basic

CC:Mail

ADABAS

DEBUG

Borland C++

CICS

DB2 (5 yrs.)

DFU

C

EDI

DB2/2 (5 yrs.)

Dialog Manager

C#

Exchange Server

Dbase

EASYTRIEVE

C++

IDMS/DC

Foxpro

EASYTRIEVE +

Clipper

IMS/DC

IDMS

EXEC.

COBOL

LAN

IMS

IBM Utilities

Crystal Reports

Lotus Notes

Informix    (5 yrs.)

ICCF

Delphi

MS Mail

Ingress

Interest

Easel

Netware

Oracle 7.3    (15 yrs.)

ISPF

Enfin

Novell

Oracle 8.0    (15 yrs.)

Librarian

FOCUS

SNA Gateway

Oracle 8i    (15 yrs.)

PANVALET

Fortran

Token Ring

Oracle 9i    (10 yrs.)

Query/400

Foxpro

VSAM

Oracle 11i    (3 yrs.)

Report Manager

J2EE

WAN

Paradox

REXX

.Net

 

Progress

Roscoe

Natural

 

Quattro Pro

SDA

Powerbuilder

 

SQL Server 6.5     (15 yrs.)

SEU

SQL Windows

 

SQL Server 7.0     (15 yrs.)

SPF

Uniface

 

SQL Server 2000  (5 yrs.)

WYLBUR

Visual Age C++

 

Sybase     (5 yrs.)

XEDIT

Visual Basic

 

UDB (DB2) (3 yrs.)

Xpediter

Visual C++

 

 

 

 

 

 

 

 

 

 

 

 

Operating Systems

Case Tools

Structured Methodologies

 

Data Dictionaries

HP-UX     (2 yrs.)

ADW

James Martin

Data Manager

Linux     (2 yrs.)

AS/SET

Method – 1

DG Dictionary

MS-DOS

Bachman

SDM-70

HP System Dic.

OS/VS1

Designer 2000

SMM

IBM Data Dic.

OS/2

Developer 2000

Summit

IDMS Data Dic.

OS/400

ERWin     (10 yrs.)

Warner-Orr

IEW

OS/MVS-XA/ESA

IBM Tools/2

Yourdon

Oracle Design

PC-DOS

IEF

 

Predict

UNIX     (10 yrs.)

S-Designer

 

SDD

VAX/VMS

SYNON

 

UCC-10

Windows 3.1

Visio     (10 yrs.)

 

VAX CCD

Windows 95

 

 

 

Windows 98

 

 

 

Windows CE

 

 

 

Windows ME

 

 

 

Windows NT     (15 yrs.)

 

 

 

Windows 2000     (4 yrs.)

 

 

 

Windows XP     (2 yrs.)

 

 

 

 

———————————— Internet/Intranet ——————————–

Enterprise Applications Software

 

ARCHIE

JPEG

SPRY

BusinessObjects (5 yrs.)

Active Server Pages

JVM

VBScript

Cognos (2 yrs.)

C++

Lotus Domino

VIOLA

D & B     (5 yrs.)

CGI

LYNX

VisualInterDev

J. D. Edwards     (5 yrs.)

FrontPage

MIDAS

WAIS

LEI (Lotus Enterprise Integrator [2 yrs.])

FTP

MIME

Web Design

Oracle Financials  (5 yrs.)

GIF

MS Internet Explorer

XML

PeopleSoft     (5 yrs.)

HOT JAVA

Netscape Navigator

 

Platinum     (5 yrs.)

HTML

NNTP

 

SAP     (5 yrs.)

HTTP

PERL

 

WebMethods (5 yrs.)

IMAGE MAPPING

SMTP

 

Walker Financials (5 yrs.)

JAVA

ASP

 

 

JavaScript

 

 

 

 

 

 

 

 

 

 

 

 

Industry/Application Exp.

Project Roles

Project Phases

Project Deliverables

 

Accounting

Analyst

Strategy

Capacity Plan

Banking

DBA

Analysis

Data Flow Diag.

Distribution

Department Manager

Design

Entity Rel. Diag.

Financial

Designer

Documentation

Estimates

Healthcare

Lead Programmer

Construction

Feasibility Study

Human Resources

Programmer

Testing

Func. Decomp.

Logistics

Project Manager

Implementation

Functional Spec.

Manufacturing

Team Leader

User Acceptance

Pkg. Software Eval.

Retail

Team Member

Training

Problem Report

Sales/Marketing

Technical Support

Support

Project Plan

Transportation

 

Full SDLC Exp.

Req. Document

Utilities

 

 

Staff Eval.

 

 

 

Status Report

 

 

 

System Ref. Man.

 

 

 

System Test Plan

 

 

 

Technical Spec.

 

 

 

Unit Test Plan

 

 

 

User Ref. Man.