Summary of Qualifications:

• An information architecture career devoted to using database design and development tools to build database solutions for customers in the Automated Storage, Aviation, Cable Television, Computer Manufacturing, Electrical Utility, Managed Medical Care, Mortgage, Oil Gas, Systems Integration, and Telecommunications Industries. From a business perspective, this career has focused on the following functional areas: Accounts Payable, Accounts Receivable, Fixed Assets, General Ledger, Human Resources, Inventory, Manufacturing, Order Entry, Purchasing, Triage, Disease Management, Utilization Management, and Training.
• From a technical perspective, these database solutions have included customizations to: On-Line Transaction Processing Systems, Oracle Applications, Siebel, Peoplesoft, Data Warehouses, Web Interfaces/Portal, LDAP, Commerce Systems.

EXPERIENCE

Confidential

Senior Data Architect/Solutions Consultant

• Analyzed, designed, and delivered data solutions for KPCO health plan and care delivery systems.
• Successfully migrated and modernized multiple database legacy applications.
• Provided solutions for multiple MDM master data management and enterprise integration projects,
• Responsible for modeling, governance of regional data solutions.
• Responsible for Colorado enterprise logical and physical data models.

Confidential

Data Architect

• Responsible for enterprise logical and physical models
• Responsible for data governance standards and guidelines.
• Data Architect for Corporate Express Service Oriented Architecture SOA Enterprise Commerce System.

Confidential

Senior Data Architect

• Responsible for conceptual, logical, and physical data models.
• Data architect for enterprise sales OLTP on-line transaction processing project. During this assignment significant database performance improvements were realized.
• Data administrator for meta-data repository, Oracle Designer.
• Siebel DBA responsible for upgrade of Siebel from 6.0 to 7.8 and from Oracle 8i to 9i.
• Database performance of Siebel system. Performance improvements of an order of magnitude or more achieved.
• Rearchitected and simplified a highly non-normalized legacy database yielding performance improvements.

Confidential

Senior Data Architect

• Developed, conceptual, logical, and physical data models.
• Reverse engineered and redesigned several database applications from Sybase and SQL Anywhere to an Oracle 10G environment.
• Installed Oracle Internet Development Suite and reverse engineered applications into the repository.
• Conducted several facilitated modeling sessions and authored recommendations/justifications for enterprise level modeling efforts and governance.

Confidential

Senior Data Architect

• Envisioned, developed and implemented enterprise conceptual and logical data models.
• Developed and implemented enterprise-level information modeling processes, standards, and instances.
• Matured enterprise-level modeling from independent application projects to enterprise-level data resource sharing.
• Developed and cultivated efforts towards a meta-data repository that allowed sharing of common objects across the enterprise. Additional benefits from these efforts brought forth a common vocabulary across technical projects and business groups.
• Facilitated data modeling sessions involving participants from a diverse range of business units and experience.
• Transformed logical models into physical database schema designs.
• Delivered several efficient and effective production databases.

Confidential

Database Lead / Designer

• Extended and enhanced the previous schema designs through detailed logical models and generated detailed schema diagrams.
• Generated all DDL from the design repository.
• Wrote shell scripts which implemented the base data definition language as well as addressed other issues such as migrating objects to new schemas and properly generating synonyms and granting privileges across new schemas.
• Rearchitected the above schemas by creating more specific schemas which addressed multiple releases an MR-EDI requirement as well as conforming to industry standards.
• Designed and assigned additional database work for the project team. Typically these items covered data conversion programs, specialized PL/SQL packages, or custom SQL reports.
• Introduced thorough tuning methodologies by implementing segregated table spaces, ensuring all previously existing tables had primary keys, and all tables had appropriate foreign key indexes. The team also tuned many of the database software objects and views as well.
• Ensured that the application successfully migrated into production and assisted in any production/performance problems which arose.

Information Architect / Consultant

Confidential

• Data architect responsible for delivering a database solution used to enhance Oracle's Training Application for a major telecommunications company. Customization included normalized logical model, construction of constraints, tables, views, indexes, sequences, synonyms, and packages that interacted with Oracle's standard 10.6 application.
• Facilitated enterprise-level data architecture. Deliverables associated with this project included a conceptual data model as well as many logical and physical models.
• Data administrator responsible for several upgrades to Oracle's Designer/2000 repository, authoring logical and physical standards, as well as ensuring released objects conformed to enterprise standards.
• Developed a logical model and physical schema for a web-based custom training application. Deliverables included a normalized logical model, construction of constraints, tables, views, indexes, sequences, and synonyms.

Confidential

Senior Programmer / Database Designer

• Team member for enterprise's implementation of Oracle Applications.
• Generated logical and physical schemas utilizing Oracle Designer/Developer 2000.
• Developed intranet application accessing Oracle Order Entry application.
• Prototyping/Proof of concept projects exploiting World Wide Web technologies such as Java Applets, Java Scripts, Perl CGIs, and basic HTML pages.
• Authored Exabyte's Oracle Standards as well as migration procedures to client/server environment.

Confidential

Data Architect / Oracle CASE Administrator / Database Administrator

• Developed several enterprise-wide logical data models using Oracle Designer 2000.
• Implemented manufacturing database schema using Oracle Designer 2000.
• Authored methodology for transforming logical data models into physical database schemas.
• Constructed and implemented an Oracle database monitoring system via stored PLSQL procedures and SQL scripts.
• Designed and implemented a database registry for intranet World Wide Web pages.

Confidential

Programmer Analyst / Project Lead

• Supported and enhanced the following Oracle Financials Modules: Oracle Assets, Oracle Financials System Administration, Oracle General Ledger, Oracle Inventory, and Oracle Payables.
• Developed and implemented several SQL Forms 3.0 applications as well as several SQL ReportWriter SQL Plus Reports which fulfilled business needs not provided within Oracle Financials.
• Led the effort which migrated the production and development environments from HP/UX Version 8, Oracle RDBMS 6.36, and Oracle Financials 9.36 to: HP/UX Version 9, Oracle RDBMS 6.37, and Oracle Financials 9.4.2.

Confidential

Senior Application Systems Programmer

• Analyzed, designed, and implemented a data warehouse and corporate financial reporting system using the Oracle RDBMS CASE Tool Set.
• Analyzed, designed, and implemented a corporate special expense accounting system using the Oracle RDBMS CASE Tool Set.
• Co-authored the Oracle Data Modeling Standards for Texaco.
• Analyzed, designed, and implemented the following applications via Oracle's CASE Tool set: raw material inventory system, expense tracking system, and a capital investment modeling system.

Confidential

Senior Programmer / Database Designer

• Team member for enterprise's implementation of Oracle Applications.
• Generated logical model and physical schema utilizing Oracle Designer/Developer 2000.
• Developed intranet application accessing Oracle Order Entry application.
• Prototyping/Proof of concept projects exploiting World Wide Web technologies such as Java Applets, Java Scripts, Perl CGIs, and basic HTML pages.
• Authored Exabyte's Oracle Standards as well as migration procedures to client/server environment.

Confidential

Data Architect / Oracle CASE Administrator / Database Administrator

• Developed several enterprise-wide logical data models using Oracle Designer 2000.
• Implemented manufacturing database schema using Oracle Designer 2000.
• Authored methodology for transforming logical data models into physical database schemas.
• Constructed and implemented an Oracle database monitoring system via stored PLSQL procedures and SQL scripts.
• Designed and implemented a database registry for intranet World Wide Web pages.

Confidential

Programmer Analyst / Project Lead

• Supported and enhanced the following Oracle Financials Modules: Oracle Assets, Oracle Financials System Administration, Oracle General Ledger, Oracle Inventory, and Oracle Payables.
• Developed and implemented several SQL Forms 3.0 applications as well as several SQL ReportWriter SQL Plus Reports which fulfilled business needs not provided within Oracle Financials.
• Led the effort which migrated the production and development environments from HP/UX Version 8, Oracle RDBMS 6.36, and Oracle Financials 9.36 to: HP/UX Version 9, Oracle RDBMS 6.37, and Oracle Financials 9.4.2.

Confidential

Senior Application Systems Programmer

• Analyzed, designed, and implemented a data warehouse and corporate financial reporting system using the Oracle RDBMS CASE Tool Set.
• Analyzed, designed, and implemented a corporate special expense accounting system using the Oracle RDBMS CASE Tool Set.
• Co-authored the Oracle Data Modeling Standards for Texaco.
• Analyzed, designed, and implemented the following applications via Oracle's CASE Tool set: raw material inventory system, expense tracking system, and a capital investment modeling system.