Searchable Resume

 

Phone:

Leave name & number.

Dr. Michael Bisconti

All Technologies Expert

http://btechy.com/ or

http://biscontitechnologies.com

Email:

 


 

 

Some
Career Highlights

Some Repeat Clients

40 years in IT

American Academy of Pediatrics

35 years in
Databases

Aon Corporation

22 years in SQL
Server

Kraft Foods

32 years in
Oracle

National Safety
Council

OBJECTIVES

( 1 ) MICROSOFT SQL SERVER Relational Database
Management System
(Expert-level:  all aspects and all versions,
including 2005 and 2008):  Seek hands on work; will take on management
roles as well.  ( 2 ) ORACLE, SYBASE, INFORMIX, MySQL, DB2
(INCLUDING UDB), DP2, INFORMATICA, AND OTHER
Relational Database
Management Systems
(Essentials-level:  select aspects and all
versions).  Seek hands on work; will take on management roles as well.

EXECUTIVE
SUMMARY

·        Download Dr. Bisconti’s Cybortel
DBA AI
, the world’s first DBA Artificial
Intelligence.

·        See http://biscontitechnologies.com for a practical demonstration of
technical expertise
.

·        Expert in Relational Database Management
Systems
(database
sizes:  up to 10 terabytes):  Microsoft SQL Server for over 22
years (all versions, including 2005, 2008, and 2008 R2)
, Oracle, Sybase,
Informix, MySQL, DB2 (including UDB), and other RDBMs.  Recent
responsibility for over 1,000 SQL Server databases (total database size: 10+
Terabytes) and for over 200 ORACLE databases (total database size: 5+
Terabytes).

·        Enterprise Application Areas: (business analysis, etc. in the areas
of) Business Intelligence, CRM (Customer Relationship Management), Enterprise
Resource Planning, Financials, Human Resources, Supplier Relationship
Management, and Supply Chain Management

·        Enterprise Application Software: (business analysis, etc. using)
BusinessObjects, J. D. Edwards, Oracle Financials, PeopleSoft, Platinum, SAP,
and Walker Financials.

·        Environments & Languages:  Microsoft operating systems,
Active Directory, Unix/Linux operating systems, Microsoft Visual Studio/other languages,
and .NET environment

·        Personnel Interactionmore than 25 years managing and
interacting with end users
in PC, client/server, minicomputer, and
mainframe environments as team leader, project manager, and department head.

 

 

CONTINUE EXECUTIVE SUMMARY

 

·        Experienced in several industries:  grade/high school/college teacher,
computer-based testing, communications, distribution, education, financial,
food, insurance, manufacturing, marketing, medical, real estate, sales, safety,
software, steel industry, television, web-hosting.

·        Inventor of “Footprint Technology”:  Footprint technology allows you to
check any number of performance/diagnostic metrics at a single glance using
graphical spectroscopy.  Metrics are converted into benchmark/daily
spectra and compared.  See “DEVRY” below.

·        Technology Website at http://biscontitechnologies.com.

·        President of IADBA (a DBA organization) at http://lfnexus.com/iadba.com/.

·        President of HIPAFI (a HIPAA organization) at http://hipafi.com.

·        A technical assessment session (you present your needs, I present my
relevant qualifications, and we assess whether I can meet your needs) is highly
recommended.

·        President of WebPsyops, Inc. (web design and development) at http://lfnexus.com/webpsyops.com/.

·        Some jobs/contracts listed below were
coterminous.

·        Student (not anywhere near fluent) of
several languages, including Hindi, Urdu, French, Spanish, German, Russian,
Korean, and Chinese.

 

PROFESSIONAL EXPERIENCE

2002 – 2012

BISCONTI
TECHNOLOGIES – Chicago, IL

1-YEAR PROJECT

SQL
Server
DBA/Production
Support Specialist/Developer

2/11 – 9/12

 

 

 

 

Conducted
2005/2008 SQL Server migrations.  Created/administered 2008/2008 R2
/backends.

 

CHESAPEAKE ENERGY
– Oklahoma City, OK

6-MONTH PROJECT

SQL
Server/Oracle
DBA/Production
Support Specialist/Developer

5/10 – 1/11

 

 

 

 

DBA/Developer/Architect
in the natural gas/oil industry primarily for developing and upgrading reports
(SSRS) in SQL Server 2008, 2008 R2 and Oracle 10g.  Team Foundation Server
used.

 

BISCONTI
TECHNOLOGIES – Schaumburg, IL

9-MONTH PROJECT

SQL
Server/Oracle
DBA/Production
Support Specialist/Developer

7/09 – 5/10

 

 

 

 

Set up SQL Server
2008 & 2008 R2/Oracle 10g/Redgate backup, log shipping, database mirroring,
and replication as team leader of group of five database personnel.  Work
included use of Business Intelligence tools (SSRS, SSIS, and SSAS (MDX).
Team Foundation Server used.

 

BISCONTI
TECHNOLOGIES – Chicago, IL

SYSTEM MAINTENANCE

SQL
Server
DBA/Production
Support Specialist/Developer

1/09 – 6/09

 

 

 

 

SQL Server/Oracle
10g system maintenance/monitoring/development, which included use of BI tools
(SSRS, SSIS, SSAS [MDX]).  Team leader of seven.  Team Foundation
Server employed.

SONUS
NETWORKS – Westford, MA

EMERGENCY CONTRACT

SQL
Server Reporting Services & Visual Studio

11/08 – 12/08

 

 

 

 

Developed
reports (SSRS) and the reporting environment/interface, which included
Sharepoint in a hands-on role and both as team leader of a group of three
report experts and as project manager for an interdept. group of fifteen, which
consisted of a mix of report experts and end users.  Business Intelligence
tools, including SSRS, SSIS, and SSAS (MDX).  Team Foundation Server.

 

WISCONSIN
HEART HOSPITAL

Wauwatosa, WI

EMERGENCY CONTRACT

SQL
Server Reporting Services & Visual Studio

8/08 – 11/08

 

 

 

 

Developed SSRS
reports involving SQL queries and XML.  Programmed the Eclipsys reporting
environment/interface in a hands-on role and as team leader of a group of
three.  Work included the use of Business Intelligence tools (SSIS and
SSAS [MDX]).  Team Foundation Server.

 

BISCONTI
TECHNOLOGIES – New York, NY

MULTIYEAR PROJECT

SQL
Server
DBA/Production
Support Specialist/Developer

Hospital Management

12/06 – 11/08

 

 

 

 

Migrated 10
instances of SQL Server 2000 to 64-bit SQL Server 2005, involving conversion of
SQL Server 2000 DTS packages into SQL Server 2005 SSIS format.  523 DTS
packages were migrated.  100 reports were prepared using SQL Server
Reporting Services and Visual Studio 2003 and 2005.  XML query development
and AJAX.  100 databases were inspected for:  HIPAA compliance in
terms of providing correctness of health insurance information and ease of
accessibility to both health insurance and general medical information.  My
role involved 75% hands-on implementation and 25% activities of project
manager.  Use of Business Intelligence tools was involved, including SSIS
and SSAS (MDX).  Team Foundation Server employed.

 

IMS HEALTH –
Philadelphia, PA

6-MONTH PROJECT

SQL
Server
Systems
Analyst & DBA/Production Support Specialist

12/07 – 5/08

 

Analyzed
entire SQL Server installation consisting of about 200 “SQL Server” servers for
the purposes of training newly hired SQL Server DBAs in the management of these
systems.  Critical areas included Data Flow, Data Protection, Data
Warehousing (10 Enterprise Data Warehouses and 3 Financial Data Marts),
Database Administration/Production Support, Database Development, Database
Server Administration/Production Support (“SQL Server” Server
Administration/Production Support), Database Server Development (“SQL Server”
Server Development), Security, and System Administration/Production Support
(Universal Processes).  My role involved both hands-on implementation and
the activities of project manager.  Team Foundation Server employed.

 

CELTIC LIFE
INSURANCE COMPANY – Chicago, IL

8-MONTH PROJECT

SQL
Server
DBA/Production
Support Specialist/Developer/Instructor

8/07 – 3/08

 

 

 

 

Upgraded (migrated)
SQL Server 2000 databases to SQL Server 2005 in Vmware (virtualized)
environment, assured high availability, established standards and wrote lengthy
documentation in

CONTINUE CELTIC LIFE INSURANCE COMPANY – Chicago, IL

 

every
area of Database Administration/Production Support for their Database
Administration/Production Support Department, and instructed their DBAs in each
of these areas.  Business Intelligence requirements were met using SSIS
and SSAS (MDX).    Team Foundation Server employed.

 

SARA LEE,
INC. – Downers Grove, IL

8-MONTH PROJECT

SQL
Server
DBA/Production
Support Specialist/Developer – Consultant

10/06 – 5/08

 

 

 

 

·        Using Visio Pro with forward/reverse-engineering,
modeled and designed Sara Lee’s new “Annual Operating Plan” application
databases for a Windows 2003 and mixed 32-bit/64-bit

SQL Server 2005 environment.  Built and tested the actual
databases.  The SQL Server 2005 64-bit technology was critical to SSIS and
SSAS (MDX) performance enhancement.

·        Configured Oracle/flat file integration
with the AOP database using SSIS (SQL Server Integration Services) and created
reports using SSRS (SQL Server Reporting Services).

·        Project manager over a team of ten
personnel.

·        Team Foundation Server employed.

 

BISCONTI
TECHNOLOGIES – Washington, DC

MULTIYEAR PROJECT

SQL
Server
DBA/Production
Support Specialist/Developer

United States Congress

4/06 – 10/06

 

 

 

 

 

Roles included
that of team leader and project manager.  Responsible for:

 

·
Alerts

·
Analysis Services (OLAP
Services)

·
Backup/Recovery, Batch
processing

·
BCP/ETL/Export/Import

·
Best Practices (Microsoft
Best Practices Analyzer)

·
Capacity planning

·
Clustering (2-&-3-node)
and redundancy design

·
Constraints

·
Daily maintenance,
including DBCC (Database Consistency Checking)

·
Database maintenance plans

·
Functions

 

DEVRY
UNIVERSITY – Oakbrook Terrace, IL

8-MONTH PROJECT

Systems-Level
SQL Server
DBA/Production
Support Specialist/Developer – Consultant

9/05 – 4/06

 

·        This position required system
administrator, DBA/production support specialist, and developer skills.

·        Its focus was the upgrading, development,
and administration of the SQL Server-supported PowerFAIDS financial services
software that DeVry uses to disburse, monitor, and plan its

student financial aid services.  This included multiple
upgrades to the SQL Server backend of

the PowerFAIDS application as part of regular upgrades to the
PowerFAIDS application.

·        Handled all responsibilities relating to
Sarbanes-Oxley compliance, including auditor interviews and the development of
a custom, audit information database application.

·        Significant work was done in SSIS (SQL
Server Integration Services [“DTS”]).

 

CONTINUE DEVRY UNIVERSITY – Oakbrook Terrace, IL

 

·        Developed the “CYBORTEL SQL Server
Management Console” at CYBORTEL, Inc. and, then, customized and licensed the
management console for use at DeVry University.  The Console contained
access portals to SQL Server Enterprise Manager, Query Analyzer, and

Profiler, access portals to the Microsoft Baseline Security
Analyzer, the Microsoft SQL Server Best Practices Analyzer, and SQL Server
Books Online, primary and secondary custom SQL DBA directory access portals, a
variety of CYBORTEL, Inc. proprietary

technologies, including DBCC CheckDB GT Test, DBCC CheckDB Summary
Report, Daily Performance Footprint, Performance Benchmark, Performance
Snapshot Report, Capacity

Planning, Data File Size Daily Snapshot, Daily Diagnostic
Footprint, Diagnostic Benchmark, and Server-Level Diagnostics, and access
portals for the Benchmarks Library, Star Team, and

the DBA Electronic Scratch Pad.

·        Updated the SQL Server testing
environment.  This included the duplication of multiple databases, along
with their respective security accounts and logins.

·        Team leader for two groups – three
personnel and five personnel, respectively.

·        Project manager for team of twenty-five
during seasons of interdepartmental work.

 

BISCONTI
TECHNOLOGIES – Los Angeles, CA

MULTIYEAR PROJECT

SQL
Server, Oracle, MySQL
DBA/Production Support Specialist/Developer

Motion Picture Association

12/04 – 6/08

 

 

 

 

 

Responsible for:

 

·
DCL/DDL/DML

·
Devices, databases and logs

– design, creation, and updating

·
Disaster Recovery

·
Documentation – policies
and procedures

·
DTS (Data Transformation
Services)

·
Hardware/RAID

·
Indexing

·
Index statistics updating

·
SQL Server Reporting
Services

·
Management of a MySQL
database serving as the backend for an on-line application

 

A. M. CASTLE
& CO. – Franklin Park, IL

1-YEAR PROJECT

Oracle DBA/Production Support Specialist/System
Architect & DBA/Production Support Specialist/System Architect Instructor
&
MS SQL
Server
DBA/Production
Support Specialist/System Architect & DBA/Production Support
Specialist/System Architect Instructor – Consultant

12/04 – 12/05

 

 

 

 

·        Upgraded their Oracle architecture from
Oracle 8 to Oracle 8i, providing extensive, new functionality.

·        Optimized their Oracle NT Server
production databases, emphasizing Oracle defragmentation/reorganization
procedures.

 

BISCONTI
TECHNOLOGIES – Seattle, WA

MULTIYEAR PROJECT

SQL
Server
DBA/Production
Support Specialist/Developer & Oracle DBA/Production Support Specialist/Developer
& MySQL DBA/Production Support
Specialist/Developer

8/04 – 12/04

Microsoft Subsidiary

 

 

 

 

Responsible for:

 

CONTINUE BISCONTI TECHNOLOGIES – Seattle, WA

 

 

·
Install/Configure/Support/Upgrade

·
Business Analysis

·
Logical/Physical/Data
Modeling/Design (Schema)

·
Load balancing

·
Monitoring, including DBCC
(Database Consistency Checking)

·
Migrations

·
NT 4.0, Windows 2000 &
2003

·
OLAP (Data Warehouses [Data
Marts] Star/Snwfl)

·
OLTP

·
Performance Tuning and
Optimization

·
Query/Stored Procedure
Optimization

 

GALLAGHER
BASSETT SERVICES, INC. – Itasca, IL

6-MONTH PROJECT

SQL
Server
DBA/Production
Support Specialist/Developer &
SQL Server DBA/Production Support
Specialist/Developer Instructor Consultant

3/04 – 8/04

 

 

 

 

Provided
installation of new technologies (CYBORTEL technologies) and instruction in these
new technologies.  These included:

·
Microsoft Best Practices
Analyzer

·
Microsoft Baseline Security
Analyzer

CYBORTEL Data Performance Monitor  (Click here for
slide show.)

·
CYBORTEL Advanced Analysis
Services

·
CYBORTEL Integrated Data
Control System

·        The CYBORTEL Data Performance Monitor
included all of the functionality of Windows NT Performance Monitor (Windows
2000 Performance Monitor, Windows XP Performance Monitor) and added additional,
extensive, database-specific functionality.

·        The CYBORTEL Integrated Data Control
System included all of the functionality of the Microsoft Best Practices
Analyzer, the Microsoft Baseline Security Analyzer, and the CYBORTEL Data
Performance Monitor.

·        Integrated legacy systems using
Informatica.

·        Team leader of group of three – one DBA
and two developers.

 

BISCONTI TECHNOLOGIES
– Miami, FL

MULTIYEAR PROJECT

SQL
Server
DBA/Production
Support Specialist/Developer &
Oracle DBA/Production Support
Specialist/Developer &
MySQL DBA/Production Support Specialist/Developer

10/03 – 2/04

 

State of Florida

 

 

 

 

 

Provided database
administration/production support/development/training and web
development.  Role involved project management.  Responsible for:

 

·
Replication

·
Security (Microsoft
Baseline Security Analyzer)

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

·
RDBMS end of web-based
systems, including ecommerce solutions

·
RDBMS vendor relations

·
SQL (T-SQL, PL/SQL, etc.)

 

AON CORPORATION
– Chicago, IL

1-YEAR PROJECT

MS SQL
Server
DBA/Production
Support Specialist/Developer – Consultant

10/03 – 10/04

 

 

 

 

Role involved
project management.  Responsible for:

 

·
Alerts

·
Backups

CONTINUE AON CORPORATION – Chicago, IL

 

·
Database Maintenance Plans

·
DBCC (Database Consistency
Checking)

·
Deadlocks

·
Disaster Recovery

·
Index Optimization/Index
Tuning Wizard

·
Index Rebuild

·
Locks

·
Maintenance Plan History

·
Monitoring SQL Server
Blocking

·
Nightly Batch File
Validation Process

·
Performance Tuning and
Optimization

·
Query Utilization
Optimization

·
Scheduling

·
Shrinkfile

 

BISCONTI
TECHNOLOGIES – Dallas, TX

MULTIYEAR PROJECT

SQL
Server
DBA/Production
Support Specialist/Developer &
Oracle DBA/Production Support Specialist/Developer
&
MySQL DBA/Production Support
Specialist/Developer

4/03 – 10/03

 

Exxon Mobil Corporation

 

 

 

 

 

Provided
instruction in SQL Server, Oracle, Sybase, and Informix.  Role involved
project management.  Responsible for:

 

·
Scheduling

·
SSIS (SQL Server Integration
Services [“DTS”])

·
Integration of SQL
Server/Oracle instances using Informatica.

·
Stored procedures
(Procedures)

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

·
Log Shipping

·
Triggers

·
Troubleshooting

·
Views

 

PROMISSOR,
INC. – Evanston, IL

11-MONTH PROJECT

SQL
Server
DBA/Production
Support Specialist/Developer/System Architect/System Administrator Consultant

6/02 – 4/03

 

 

 

 

Managed other IT
professionals as a DBA/System Administrator.  Guided the work of 10
application developers.  Supervised 3 managers.  These 3 managers
supervised 50 employees.  Managed multiple staffs, ranging in size from 1
to 10.  These staffs comprised the Database Administration/Production
Support and System Administration/Production Support departments.

 

·        Project manager for group of fifty
personnel.

·        Team leader of ten groups, ranging from
three to twenty people.

·        Designed and implemented Performance
Management Systems.  These systems tracked performance of memory,
permanent storage (including SAN and EMC Symmetrix), central processing, and
network components.

·        Built PMTA (the Performance Metrics
Tracking Application), deriving metrics from tables in SQL Server 2000 and
Oracle databases, populated by stored procedures in these databases.  The
performance of web servers, OLTP Database servers, and DSS servers was
monitored and tuned.

·        Integrated SQL Server, Oracle, Sybase, and
DB2 data sources using Informatica.

·        Built auto-generating, graph
software.  This software has the ability to present the same data in
multiple, graph formats.

·        Designed and implemented QAI (quasi-artificial-intelligence)
software applications. These applications are used principally for making
projections in the areas of capacity planning and

 

CONTINUE PROMISSOR, INC. – Evanston, IL

 

·        resource planning and involved the
development of innovative projection and forecast methodologies.

·        Designed and implemented new disaster
recovery plans.  This involved setting up three remote hosting
locations.  These locations were handled through WorldCom Digex.

·        Adhered to ISO certification standards in
all endeavors.

Designed and implemented three Veritas solutions, including
backup, clustering, and disaster recovery.  Implemented custom failover
clustering solution.

·        Taught classes in database
administration/production support, system administration/production support,
and system architecture. These classes included SQL Server 2000 Windows 2000
Clustering and BMC Patrol Operations.  PowerPoint

·        presentations were prepared by me that
could be used by individuals to learn on their own and by other instructors.

·        Instituted SourceSafe version control
system.  This entailed setting up specialized directory structures.

·        Built Operational Data Stores, Data
Warehouses, and Data Marts (stock market, accounting, marketing, sales,
performance tuning, etc.).  Developed star, snowflake, and crystal
schemas.

·        Installed Analysis Services on SQL Server
2000 Clusters on Windows 2000 Datacenter Servers.

·        Designed and implemented application
deployment processes.  This included the insertion of deployment tables in
scores of databases.

·        Developed System Utilization
methodologies.  This incorporated system optimization and system
saturation processes.

·        Obtained Cost Saver Application analyses via
Cray computer at the University of Texas.

·        Improved production server performance
through memory reallocation.  The stored procedure cache was increased by
a factor of eight.

·        Designed and implemented 100 DTS packages.

·        Performance tuned 2,000 stored procedures.

·        Designed and implemented new system
architecture.  One objective of the new architecture was to improve
performance by a factor of 10.

·        Utilized MDAC, Microsoft Data Access
Components.

·        Set up maintenance plans for the OLTP and
DSS servers running SQL Server 2000, including backups, rebuilding of indexes,
and other maintenance tasks.

·        Reviewed and optimized database
configuration options.

·        Implemented logical/physical database
models/designs.

·        Developed schemas in Visio and ERWin for
databases and data warehouses (incl. data marts).

·        Utilized Microsoft Project to manage a
score of team projects.

 

 

 

 

 

EARLIER PROFESSIONAL EXPERIENCE

 

Earlier
professional experience will be found in a resume appendix at http://biscontitechnologies.com/appendix.htm.
Here is a partial list of the companies referenced there, many of which were fortune
500 companies and for which I worked either on a contractual or permanent
basis.  The experience gained over the years at these and other companies
has established me as an Industry Leader in Database (1)
Administration/Production Support, (2) Development, and (3) Architecture

and, in particular, as a master DBA/Production Support
Specialist/Developer/Architect in MICROSOFT SQL SERVER and a select
master DBA/Production Support Specialist/Developer/Architect in all other Relational
Database Management Systems (note “OBJECTIVES” section above).

 

·
A. M. Castle & Co.

Franklin Park, IL

·
Computax, Inc.

Chicago, IL

·
National Safety Council

Itasca, IL

·
Am. Acad. Pediatrics

Elk Grove, IL

·
Daimler Chrysler Corp.

Belvidere, IL

·
Océ

Chicago, IL

·
Amoco Corporation

Chicago, IL

·
General Electric Company

Naperville, IL

·
Rand McNally

Skokie, IL

·
Aon Corporation

Chicago, IL

·
Kraft Foods

Northfield, IL

·
U.S. Office Products

Des Plaines, IL

·
Chicago Board of Trade

Chicago, IL

·
MCI WorldCom, Inc.

Chicago, IL

·
U.S. Robotics

Morton Grove, IL

 

EDUCATION

·
B.R.E., Education,
Midwestern Baptist College

·
N.D.,
Psychiatry, Providence Christian Seminary

·
M.S.,
Computer Science, MicroTech Institute†

·
Ph.D.,
Applied Computer Science, MicroTech Institute†

·
Ph.M.D.,
Pneumiatric Psychiatry, Pneumiatric Psychiatry Institute†

 

 

 

 

 

 

 

 

 

†To establish
this degree’s meritability of “full faith and credit” contact your educational
authority.  Every educational entity does not require recognition from
CHEA (Council for Higher Education Accreditation) and/or the USDE (United
States Department of Education).  If you cannot find information through
your educational authority and/or if you need additional information on
recognition of educational entities, you can contact me at
mbisconti@aol.com.  Any information obtained through internet search
engines is not necessarily reliable because internet search engines may cache
web pages out of context and may not provide signifying graphics.