Benedict G. Scott

Experience Summary

Client: Major Publishing Firm

• Architect data warehouse for three legacy systems
• Work with users to develop business rules
• Develop logical repository design using PowerDesigner DataArchitect
• Interface with programmers to resolve data collection issues
• Design and develop PL/SQL data pump to transfer and transform legacy data

Client: International Publishing Firm

• Work with users to develop business rules
• Serve as liason between different client interest groups
• Facilitate exchange of information among different organizational entities
• Interface with programmers to resolve data collection issues

Client: International Chemical Firm

• Participate in team design of a new information technology consulting data warehouse
• Develop logical DW design using Oracle Designer-2000
• Interface with programmers to resolve data collection issues
• Assist with data collection and loading

Client: International Artist Representative

• Analyze information flows required to manage artist royalty flows
• Use Oracle Designer to capture the design and generate the initial prototypes

Client: International Chemical Firm

• Design new information technology data repository
• Develop logical design using Oracle Designer-2000
• Interface with DBA to resolve design and processing issues
• Assist with data collection and loading
• Maintain client contact and report project progress

Client: Cloth Manufacturer

• Design of a new Oracle version 7 data repository
• Install Oracle version 7 on HP UNIX box
• Train new DBA

Client: International Management Consulting Firm

• Participate in team design of a new information technology consulting data warehouse
• Develop logical DB design using S-Designor Pro
• Migrate logical DB design to physical DB design for Oracle version 7
• Interface with programmers to resolve data collection issues
• Assist with data collection and loading

Client: International Hardware and Software Vendor

• Develop graphical user interface for library information retrieval system using proprietary RDBMS and drawing tool
• Interface with RDBMS team and recommend enhancements

Client: National Service Organization

• Review tentative DB design for implementation of membership/sales system in Oracle version 6
• Develop prototype using Oracle CASE dictionary and designer
• Plan formal Oracle training for staff and provide day-to-day training and support
• Design and develop leadership team tracking system in Oracle version 6
• Design and develop project tracking system in Oracle version 6
• Provide technical support for trouble shooting Oracle financials

Client: Home Health Care Provider

• Review existing data flow documentaton
• Test and recommend software for documenting data flows
• Analyze disaster recovery policies and procedures and recommend improvements

Client: International Telecom Vendor

• Design supply management DB for implementation in Oracle version 6
• Use Oracle CASE dictionary to capture the design and generate the initial prototypes
• Serve as Oracle advocate to client department and interface with other departments
• Coordinate DB design team activities
• Assist with data collection

Client: Mining and Metal Manufacturing Company

• Review existing timeclock information gathering system
• Write report recommending how to upgrade the old system

Client: International Hardware and Software Vendor

• Participate in team design of a new inventory tracking and marketing system
• Participate in JAD and follow-on analysis to determine user information needs
• Develop logical DB design using ERwin
• Migrate logical DB design to physical DB design for Oracle version 7
• Interface with programmers to resolve performance issues

Client: Insurance Underwriter

• Develop disposable prototype quotation system in Rbase and produce initial documentation
• Develop production quotation system in C
• Document production system by extending the prototype documentation

Client: Regional Construction Material Supplier

• Design and develop C-exits for Oracle version 5 implementation of on-line point-of-loading truck ticketing system
• Develop several reports using Oracle Reportwriter

Client: Healthcare Benefits Company

• Analyze tax system requirements
• Manage client contact
• Design system specifying: file structures, field definitions, reports, formulas, directory structures
• Develop prototype system and demonstrate to client
• Enhance prototype to develop production system

Employer: Telecommunication Vendor

• Supported sales efforts and regional management using database methods.
• Analyzed business problems and recommended solutions.

Employer: University

• Taught classes in Analysis, COBOL, BASIC, CICS
• Counseled students
• Researched uses of personal computers in small business
• Supported research activities of faculty

Employer: Manufacturer

• Establish database strategy, policy, standards, and procedures to prepare for migration to InfoCenter
• Manage the Database Administration organization and the Data Administration function
• Direct the database analysis function in a CICS and DL/1 with DMS environment

Client: Regional Bank

• Lead project teams in preparation of systems analysis packages and feasibility studies
• Reviewed test plans
• Requested modification and enhancement of systems
• Prepared DFDs and process specifications
• Prepared the data dictionaries for systems
• Consulted to several subordinate organizations in San Francisco and Los Angeles

Employer: Health Insurance Provider

• Supervise independent Database Administration group charged with designing and implementing HMO system database
• Teach data normalization techniques to other Database Administrators to prepare them for both relational methods and interactive processing
• Support the implementation of large IMS health care package and model large IMS databases to determine space and performance parameters