View a PDF copy of Bert Scalzo's short resume (shown below)

 

View a PDF copy of Bert Scalzo's long resume (5 page monster)

 

 

Bert D. Scalzo

2917 Elmridge Drive

Flower Mound TX 75022

Home (972) 539 - 9628

Cell    (469) 693 – 3300

bert.scalzo@yahoo.com

 

Education

 

Masters Computer Science

1. The University of Dayton, 1992, Dayton Ohio
2. Thesis - Complex Relational Database Design

 

Bachelors Computer Science

1. The Ohio State University, 1985, Columbus Ohio
2. Focus - Relational Database Management Systems

 

Experience

 

Quest Software Inc., Database Expert, Mar 2000 - Present

• Design and implement features for multiple products:
• Toad for Oracle, SQL Server, DB2 and MySQL
• Benchmark Factory
• Toad Data Modeler (formerly CASE Studio)
• Reveal Net Knowledge Xpert for PL/SQL
• Reveal Net Knowledge Xpert for DB Admin
• SQL Navigator
• SQL Optimizer
• Quest Central for Oracle
• Admin for Solaris, HPUX, AIX, Linux, Tru64 and Windows database servers
• DBA for all development and QA test Oracle databases, versions 7.3 to 10.2
• Publish & present technical papers, magazine articles, web-casts and books
• Provide DBA services to customers – especially benchmarking and data warehousing
• Work with vendors & strategic partners to perform and publish benchmarking papers
• Design custom benchmarks for customers – some of which may get trademarked

 

Embarcadero Technologies Inc., Database Product Architect, Jul 99 – Mar 2000

• Design and oversee implementation of DBA and database developer oriented features for a wide range of database products, including the flagship product - DBArtisan
• Admin for Solaris, HPUX, AIX, Linux, Tru64 and Windows database servers
• DBA for all development and QA test Oracle databases, versions 7.3 to 9.2
• Publish & present technical papers
• Provide DBA contract services to customers

 

EDS, Data Warehousing DBA & Architect, Apr 97 – Jul 99

• Lead Architect and Database Administrator for multi-terabyte data warehouse for Southland Corp. 7-11 convenient stores’ Point of Sale and EDI Order information
• Responsibilities
• Logical and physical data modeling
• DDL generation and synchronization
• Database and application SQL tuning
• Database sizing, backup and recovery
• Write & review warehouse loading code
• Oracle TAR submission and resolution
• Oracle version testing and installation

 

The Associates, Database Design Architect, Aug 96 – Apr 97

• Data modeler for the “Commercial Strategic Systems Office” (CSSO), charged with transitioning the commercial division to model driven, client server application development for all ongoing OLTP projects and the data warehousing initiative
• Warehouse Design: Operational Data Store (ODS) with Star Schema data marts
• Responsibilities
• Oversee all data warehouse and client server projects
• Provide cross project modeling, planning and prioritization
• Develop and maintain the enterprise data and process models
• Translate project data models into normalized database designs
• Develop corporate wide client server development standards

 

Logic Works Inc, Principal Consultant/Instructor, Jan 96 - Jul 96

• Perform enterprise wide data modeling utilizing ERwin
• Conduct enterprise wide function modeling using BPwin
• Translate data models into normalized database designs
• Audit data models for modeling flaws and design issues
• Teach IDEF1X and IE data modeling using ERwin
• Instruct IDEF0 process modeling utilizing BPwin
• Review product development specifications related to Oracle
• Perform Oracle database administration (tuning, backup, recovery, etc.)

 

Orange Systems, Manager Database Development, Aug 95 - Jan 96

• Manage 10 Oracle Designer 2000 application developers
• Develop new ALCIE V accounting suite (GL, AP, AR, etc.)
• Administer MS Project work plans for entire development effort
• Oversee quality of project’s data models and database design
• Govern product’s software quality assurance testing procedures
• Tutor staff on good modeling and code generation techniques
• Provide technical support for prior ALCIE software versions
• Perform routine HR tasks (interviews, reviews, hiring, firing, etc.)
• Submit quarterly personnel, software and hardware budgets
• Orchestrate “VAR” conference to demo next generation software

 

Oracle Corporation, Principal Consultant/Instructor, Jul 93 - Jul 95

• Manage customer projects having 4-10 Oracle consultants
• Perform enterprise wide systems modeling using Designer 2000
• Translate data models into normalized database designs
• Audit data models for modeling flaws and design issues
• Generate client/server application code utilizing Designer 2000
• Augment Designer 200 generated Oracle Forms and Reports
• Perform PL/SQL and PRO-C coding, debugging and tuning
• Render database administration (tuning, backup, recovery, etc.)
• Teach all of Oracle Education’s courses: focus DBA and CASE
• Assist with Oracle Education’s curriculum development

 

Nationwide Mutual Insurance, Database Project Lead, Apr 92 - Jun 93

• Project lead for 7 member Oracle CASE and DBA SWAT team
• Co-lead for 26 insurance projects each having 6-10 developers
• Steer migration from mainframe to client server and Oracle
• Assist senior management's strategic migration planning
• Construct enterprise data and process models from projects
• Translate data models into normalized database designs
• Audit data models for modeling flaws and design issues
• Generate client/server applications utilizing Oracle CASE
• Augment Oracle CASE generated SQL Forms and Reports
• Perform PL/SQL and PRO-C coding, debugging and tuning

 

Battelle Memorial Institute, Lead Database Analyst, Oct 84 - Apr 92

 

Ohio State University, Teaching Assistant – Computer Sciences Dept., Jan 84 - Sep 84