Objective: Position as Database Designer/Database Architect or Project Manager in W2, 1099 or temp-to-hire position.

Computer Skills:

Skill Experience When

Database Tools:
Access 11 Yrs current
Oracle 8 Yrs current
Development and Case Tools:
Oracle Designer 1 Yr 1 yr ago
TOAD 5 Yrs current
PL/SQL Developer 1 Yr 1 yr ago
Designer 2000 1 Yr 1 yr ago
Erwin 3 Yr current
Programming Languages:
Oracle SQL*Plus 8 Yrs current
SQL*Loader 5 Yrs current
PL/SQL 8 Yrs current
C, C++ 2 Yr current
Pro*C/C++ 1 Yr 1 yr ago
SQL 10 Yrs current
UNIX Shell Scripting 5 Yrs current
Visual Basic 4 Yrs current
Visual Basic for Appl. 10 Yrs current
Operating Systems:
UNIX 5 Yrs current
Windows 95/98 10 Yrs current
Windows NT 8 Yrs current

Database Skills:

Data Access 11 Yrs current
Data Modeling 11 Yrs current
Data Planning 11 Yrs current
Data Quality Assurance 11 Yrs current
Database Design/Architect 11 Yrs current
Database Replication 2 Yr current

Employment:
11/01 to present Bill Boudreaux, Inc, Dallas, TX Database Consultant
Worked as independent database consultant for various clients including PriceWaterhouseCoopers, Proctor and Gamble, Bank of Tokyo Mitsubishi and Deloitte Consulting, and in various locations including NYC and Dallas. Involved in the design (including modeling, architecture and security features) of various MS Access and Oracle Databases and user interfaces with Visual Basic and VBA. Wrote PL/SQL, Pro C/C++, UNIX, SQL*Loader scripts for ETL and data manipulation, including triggers and packages. Tutored others in Database design and PL/SQL and Visual Basic coding. Used “explain plan” and hints to optimize SQL statements. Used Erwin and Toad for database design/tuning. Designed tablespaces, tables, partitions, schemas, files, indexes (B-tree and Bitmap) and constraints to optimize data access and minimize disk contention. Utilized Oracle Materialized Views and automatic query rewrites to optimize queries. Worked with OFSA--part of the Oracle Financials suite (Oracle 11i) as well as warehouses and OLTP systems. Used links to access data in distributed databases.

10/00-11/01 Design Synergy, Cincinnati, OH Database Consultant
Worked as contractor on Oracle database. Designed data warehouse and wrote ETL script. Drew process-flow diagrams, entity-relationship diagrams and data-flow diagrams to model data requirements and determine best database architectures. Wrote requirements and test plans. Wrote scripts in UNIX and PL/SQL, including packages. Used “explain plan” command and hints in SQL statements to improve query efficiency. Designed indexes to achieve maximum speed with minimal space. Taught other users how best to write their queries to minimize processing time. Interfaced with clients. Created and altered tables, views, partitions and indexes. Used TOAD and PL/SQL Developer applications for writing and debugging procedures and for accessing data. Wrote triggers and used constraints to enforce data integrity.

4/00-10/00 Volt Technical Services, Wichita, KS Database Consultant
Worked as contractor for Boeing to redesign databases and automate and improve processes through the use of more efficient modules and better logical designs. Used MS Access modules and macros extensively. Modeled databases and employed entity-relationship diagrams and process flow diagrams to shorten batch processes by at least 40 hrs. per week. Wrote design specifications and documentation for databases and processes. Tutored others in database design, VBA coding, normalization of databases, configuration management, and object oriented design, as well as using these extensively in day-to-day activities. Participated in design of system to share information with suppliers over the web. Implemented systems to determine who was using various databases. Linked tables between databases and imported various tables through code. Wrote SQL statements in code and created tables and queries in code to make for more elegant and efficient processes. Used DAO recordsets to manipulate data within and between databases. Designed forms and reports in MS Access. Manipulated objects using their methods. Wrote application in MS Access to automatically call DOS program to ftp files from mainframe system into Windows directory, and then either linked to or imported them into the Access database. Used VBA code to manipulate files, e.g. copying, renaming, compacting. Designed new Oracle database using PL/SQL, Pro*C/C++.

5/99-4/00 Lockheed Martin, Aurora, CO Database Designer
Developed and maintained 1000+ table Oracle database in UNIX environment which was to reach a size in the terabyte range. Used Oracle Designer 2000, Oracle Reports, Oracle Graphics, SQL*Plus, PL/SQL, SQL Loader, Oracle Browser. Also used MS Access for developing self-contained applications as well as those for linking to Oracle databases. Wrote packages, procedures and triggers in PL/SQL, as well as writing extensively in VBA. Used cursors to manipulate data in tables. Designed entity-relationship and process flow diagrams. Wrote UNIX and SQL*Plus scripts to manipulate data in tables and between various systems. Wrote SQL select, insert, update and delete statements. Designed reports in Developer 2000’s report tool that used graphics from and passed parameters to the Oracle Graphics application, I also designed the graphs. Implemented integrity constraints and business rules within a table’s design, as well as through triggers. Used the Oracle Database Dictionary views to determine information on objects, schemas, users and privileges. Used knowledge of Oracle’s back-up and archiving capabilities to design schemas that would be easier to maintain and to recover. Used knowledge of physical database design to determine optimum file configuration. Wrote specifications for maintaining databases. Participated in design of configuration management plan for project.

2/94-5/99 Bill Boudreaux Consulting, Arvada, CO Database Consultant
Designed and improved MS-Access and Oracle databases. Programmed with VBA, macros and PL/SQL to automate processes. Used ODBC to link to Oracle and SQL Server databases and Excel files. Designed Entity-Relationship and process flow diagrams. Designed forms and reports. Wrote code to manipulate data using DAO recordsets. Wrote specifications and user’s manuals. Managed all phases of projects.

Education and Certifications:
* Oracle Certified Professional (OCP)
* 31 hrs in Math and Computer Science from Colorado School of Mines
* BSME., Texas A&M University, College Station, TX
* MBA., University of New Orleans, New Orleans, LA
* APICS Certification in Production and Inventory Management (CPIM)
* APICS Certification in Integrated Resources Management (CIRM)