Database Developer

HOWARD BAIZER

***** ***** ****. *** *******, CA *0066

310-***-**** (Cell/Message) 310-***-**** (Home) *******@*****.***

. Extensive database development experience, including Oracle development

using SQL and PL/SQL, and MySQL development using SQL and PHP.

. Strengths as a developer: strong communication skills, clear, well-

documented, easy-to-maintain code, and the ability to mentor others.

. Experience in a wide range of industries, including Entertainment,

Manufacturing, Banking, Insurance, Government and Transportation.

RELATED EXPERIENCE

ORACLE, MySQL and NOMAD2 relational database management systems.

SQL, SQL/PLUS, PL/SQL and SQL*Loader experience.

DB2 database system using QMF, SPUFI, and NOMAD2 interfaces.

MS/DOS, Windows, Macintosh O/S and other microcomputer experience.

VM/CMS, MVS/TSO, MS/DOS and UNIX operating systems.

PHP, EXEC2, REXX, JCL, CLIST and UNIX Shell scripting languages.

PROFESSIONAL EXPERIENCE:

6/14 - 08/14 INDEPENDENT CONSULTANT, MYSQL DATABASE DEVELOPER

6/14 - 08/14 FastPay, Beverly Hills, California

Fast Pay is a specialty finance company servicing the digital media

industry.

Developed MySQL stored procedures for generating MySQL stored procedures to

perform CRUD operations using dynamic SQL and stored procedures for unit

testing those stored procedures. Code generators greatly reduce coding

errors, facilitate future global code changes and significantly reduce

development time of database enhancements.

8/03 - 1/14 ORACLE PROGRAMMER, Employee Position

Hypermedia Systems, Inc., Los Angeles CA

Hypermedia Systems specializes in Video Chat, Rich Media and eCommerce

systems utilizing cutting-edge technologies and advanced development

techniques.

As Senior Oracle Programmer within the corporate DBA team, wrote packages,

stored procedures, functions and complicated nested queries using SQL and

PL/SQL. Tuned new and existing using TOAD and EXPLAIN PLAN to identify

queries that needed tuning and modified SQL accordingly. Developed PHP

scripts to convert data from Oracle to MySQL databases. Converted legacy

PL/SQL code to PHP to read from MySQL databases.

Worked on Risk Management report initiatives to identify potential credit

card fraud by evaluating global purchasing transactions. Consolidated

transactional information into data warehouse summary tables to identify

high-risk sales patterns. Participated in the redesign of database to

support high volume transactions on the eCommerce website. Evaluated

current ER diagram using ERwin and improved performance of the database by

redesigning tables, reducing storage requirements by eliminating unused

artifacts. Redesigned application transactions to reduce the likelihood of

deadlocks. Prepared data flow diagrams of legacy system. Created

SQL*Loader control files to load data from other repositories. Converted

Perl code to Oracle PL/SQL stored procedures to safeguard the security of

business logic. Developed CRON jobs to automate reports and assure timely

dissemination of information. Stored ad-hoc reports in OpenReports tool

to improve accessibility for end users. Modified shell scripts as needed.

Interfaced with users from other departments to determine reporting needs.

Wrote ad-hoc reports. Created summary tables to increase efficiency of

reports. Developed charts using XML/SWF Charts and AnyChart software tools.

Investigated new technologies for lower costs and greater ease of use.

Prepared documentation for new tools and processes. Assisted DBAs by

developing "SQL GENERATING SQL" scripts to create automated processes and

reduce the time spent writing SQL code.

3/99 - 5/03 INDEPENDENT CONSULTANT, ORACLE PL/SQL DEVELOPER, Various

CONTRACT assignments.

12/00 - 5/03 Twentieth Century Fox, Century City, California

Developed PL/SQL stored procedures to gather data to be formatted and

distributed in Crystal Reports. Wrote SQL scripts and Oracle stored

procedures to extract, transform and load (ETL) data for migration from

legacy accounting system to web-based system. Created SQL*Loader control

files to import data. Identified indexes to improve database performance.

Prepared QA reports.

9/00 - 11/00 eCompanies.com (Madison Project), Santa Monica, California

Created SQL and PL/SQL code for web access analysis reporting software.

Produced Data Mining reports for the study of user demographics. Assisted

in testing of web application.

5/00 - 8/00 Opus 360, Manhattan Beach, California

Enhanced Generic Interface Toolkit for exporting data to third party

software. Modified PL/SQL stored procedures to improve performance and

ease of maintenance. Prepared design document. Worked with other team

members to create and enforce coding standards.

2/00 - 4/00 eParties.com, Santa Monica, California

Produced Data Mining reports for the study of user demographics. Prepared

web access analysis reports using Webtrends software. Created

administrative interface using Oracle Forms 5.0. Identified indexes to

improve database performance. Assisted in testing of web application.

11/99 - 1/00 Los Angeles County Sheriff's Department, Norwalk,

California

Developed application for reconciling documents with incidents in online

system. Created interface and report using Oracle Forms 4.5 and Reports

2.5. Produced report to identify incomplete events before loading into

Data Mart.

8/99 - 10/99 eToys.com, Santa Monica, California

Created batch process to maintain list of subscribers to email newsletter.

Developed Korn shell script to drive processing. Performed updates on an

ad-hoc basis. Built PL/SQL package to uniquely identify customers from

order data. Assisted other programmers with PL/SQL coding.

5/99 - 9/99 Sony Pictures, Culver City, California

Participated in the conversion of theatrical accounting system from legacy

mainframe to Oracle client /server. Prepared SQL*Loader control files to

import data. Developed PL/SQL code to consolidate and condition Oracle

data. Created SQL*Plus balancing reports to validate results.

3/99 - 5/99 OSI Consulting, Agoura, California

Created requirements document for order entry system. Trained developers

in the use of Oracle 8 database. Assisted programmers in development of

custom reports.

9/98 - 2/99 SENIOR PROGRAMMER ANALYST, Employee Position

RAND Corporation, Santa Monica, California

Maintained internal web application to access Oracle Financials Project

Accounting system.

3/97 - 9/98 PRINCIPAL CONSULTANT, Employee Position

Oracle Corporation, Santa Monica, California

Created scripts for the migration of data from customer's legacy systems to

relational database applications. Modified financial application packages

to provide custom solutions. Tested, analyzed, and revised system code

for maximum reliability and efficiency. Generated reports using ORACLE

REPORTS 2.5. Supported programming staff in the development of SQL and

PL/SQL code. Developed and taught internal training classes. Prepared

technical documentation.

11/96 - 3/97 ORACLE SYSTEMS PROGRAMMER, Employee Position

Capital Management Sciences, Los Angeles, California

Developed and maintained PL/SQL code to support bond analysis software.

Created and modified scripts to control batch processes. Provided ad-hoc

reports to end users using SQL/PLUS, ORACLE BROWSER and other tools.

3/95 - 8/96 STAFF INSTRUCTOR, Employee Position

Oracle Corporation, Los Angeles, California

Trained external customers, ORACLE employees, and other ORACLE instructors

in SQL, SQL/PLUS, PL/SQL, ORACLE FORMS 4.5 and ORACLE BROWSER. Prepared

presentation materials.

4/91 - 3/95 SENIOR BUSINESS ANALYST, Employee Position

American President Lines, Oakland, California

Supported end users and programmers in application development and database

design in MVS/TSO, MS/DOS and UNIX environments. Provided technical

support for DB2, Teradata, IDMS and ORACLE interfaces. Isolated and

reported software bugs to vendor. Tracked progress to ensure problem

resolution. Organized on-site training classes. Created presentation

materials using Microsoft PowerPoint. Served as member of functional

Quality team. Published internal newsletter.

EDUCATION AND TRAINING

University of California, Berkeley B.A. Psychology, June 1980

University of California Extension Pascal Programming

Advanced C Programming

Computer Skills Corporation UNIX Basics

Applied Relational Design Extended Relational Analysis

(Logical Data Modeling)

Automated Concepts Incorporated (ACI) Introductory COBOL

Contact this candidate