WCS Home Qualifications Detail About WCS Consulting Benefits Services Engagements Links IT Resources Portland Site Map

EXPERIENCE DETAIL - DANIEL A. WRIGHT Wright Consulting Services, Inc. 1956 SE 25th Avenue - Portland OR 97214-4909 (503) 233-9799 - dwright at wriconsult dot com Wright Consulting Services, Inc. employs the expertise of Daniel A. Wright to develop and implement information services for Pacific Northwest clients. As detailed below, he has 14 years of experience as an information systems consultant, including 9 years using Oracle® products, and specializes in Oracle PL/SQL and Oracle Developer (Forms and Reports). TECHNICAL EXPERTISE Oracle Developer: Oracle Forms 5.0, Reports 3.0 (Motif/HP-UX, Windows). Oracle7, Oracle8 and 8i Databases: PL/SQL versions 1.1 through 8.1. Oracle Designer (CASE): 2.0, 6.0 and 6i. Return to Top of Page EXPERIENCE Click here for a less detailed version of this page. Wright Consulting Services, Inc., Portland/Seattle (1994-present) Participated in a design and development team on a project to redesign a data warehouse for a high-tech manufacturer. Analyzed and designed replacement tables using Oracle Designer 6i; analyzed, designed, developed and tested data loading processes using Oracle PL/SQL and Quest SQL Navigator in an Oracle 8i database running on DEC Alpha UNIX. Created, performance-tuned, and implemented a set of PL/SQL packages and stored procedures used to load and transform external data into a data warehouse. These interfaces process between 500,000 and 1 million records per day, from both external data files and remote databases, and were developed using PL/SQL 8.0 and implemented on an Oracle database running under HP UNIX. The transformed data is used to support a wide variety of management, financial, and operational reporting needs for a large telecommunications company. Converted a consulting firm's work-in-process and client billing system from Oracle character mode tools to Oracle Developer Forms 5.0 in a client-server Microsoft Windows environment. Also designed and developed Oracle Forms applications allowing management-level employees to monitor and manage client, engagement, backlog, and pipeline data. Developed applications to manage a telecommunications company's telephone cards. Software was created to provide querying, transactional, and reporting functions for customer support, product management, finance, and external user groups. Applications were developed using Oracle Forms (Oracle Developer) under Microsoft Windows. Led a project to convert more than 120 reports in a large application to the graphical Oracle Reports tool (Oracle Developer) from character-mode Oracle SQL*ReportWriter 1.1. Developed standards and procedures, converted many of the reports, and redesigned reports to take advantage of graphical features available in the new environment. Designed and developed a system for producing, scanning, processing, and statistically reporting student evaluation surveys for employer-provided training at a major manufacturer. This system, implemented using an Oracle database and Oracle tools and running on IBM mainframe and HP Unix minicomputer platforms, facilitates the ongoing evaluation of instruction provided to more than 60,000 employees, and is integrated into the company's larger Training Management System. Designed and developed an administrative information system for a northwest non-profit organization. Identified and assessed requirements, converted the existing database to a relational model using Microsoft Access, constructed an application to maintain donor and customer data, and designed query and report templates that enabled the client to develop reporting capabilities without outside assistance. Integrated several standalone information systems related to employee training into an existing centralized Training Management System. These integration projects included major enhancements to the functionality of the central system and allowed the company to realize considerable savings by eliminating the standalone systems. Return to Top of Page ECG Management Consultants, Inc., Seattle (1990-1994) Conducted a criminal history baseline audit and needs assessment for a northwestern state law enforcement agency. Interviewed personnel and reviewed records and operations at local agencies; and assessed the completeness, accuracy, and timeliness of criminal history reporting. Worked as technical quality assurance auditor of a systems development project for a western state's motor vehicle agency. Performed periodic status and schedule reporting, assessed ongoing user involvement, and monitored all design, construction, testing, and implementation activities. Made repeated warnings in reports of schedule lag and potential technical problems, some of which remained unresolved at the time of system implementation. Performance problems, system failures, and subsequent cost overruns caused a major public relations crisis for the client, a situation which may have been averted had earlier warnings been heeded. Redesigned a midwestern state's central criminal history information system. Modeled processes using KnowledgeWare Workbench, developed coding standards, and designed system screens, reports, and batch processes. Designed interfaces for the electronic transfer of arrest and court disposition data from local criminal justice agencies to a statewide criminal history repository. Converted a consulting firm's work-in-process and client billing system to an Oracle client-server database in a local area network environment. Designed database, converted data, developed coding standards, and constructed the system's screens, batch processes, and external interfaces. Constructed and developed coding standards for a water quality permit management system for a state-level environmental agency, using an Oracle system solution operating in a client-server mode in a local area network environment. Assisted a major medical school with the design, development, and implementation of administrative applications to support the school's faculty, student, and research funding information needs. Developed technical systems documentation for a major labor trust organization. This project included the detailed review of 13 major application areas in diverse computing environments supporting 11 user departments. The resulting documentation was used as the basis for the design of an integrated replacement system to be developed using relational database technology in a LAN-based Microsoft Windows computing environment. Primary consultant on an engagement to assist the community colleges of a western state with baseline design and implementation planning for a statewide data collection system. The purpose of this system is to collect a wide variety of student, faculty, and institution-specific data to support the colleges' diverse federal, state, and accreditation-related reporting requirements. Return to Top of Page Control Data Professional Services (now Ceridian Corp.), Bloomington, MN (1988-1990) (Contract employee through Western Technical Services) Provided systems consulting services to a large manufacturer, taking ownership of numerous systems projects for their entire life cycle, including analysis, design, development, and maintenance phases. Designed and developed a class registration system currently used by the Human Resources Development, Sales Training, and Technical Development departments of a Fortune 100 company to schedule classes, register students, bill classes, and track student histories. System features included windowed forms-based data entry in a minicomputer environment and interfaces to corporate mainframe databases. Created numerous Oracle SQL*ReportWriter reports for monitoring quality and waste in the production of blank video tape. Designed and developed several Clipper/dBase systems, including a system for tracking corporate press releases, and a system used by a large corporation's Toxicology Services department to search the company's product database and retrieve MSDS sheets in emergency situations. Developed sytems using CompuServe System 1032 for quality control monitoring in the manufacture of die-casting molds, and for tracking shipments of granules used in composite roofing shingles. Return to Top of Page Department of Internships and Cooperative Education, Augsburg College, Minneapolis, MN (1988) Maintained department's dBase databases, developing and enhancing database applications for tracking employers, students, and placements. Assisted other employees in the use of Macintosh and DOS-based computers. Return to Top of Page Interactive Computer Technology, Lake Elmo, MN (1985-1988) Designed and developed sales tracking, invoicing, and accounting applications for a small software company. Return to Top of Page EDUCATION Bachelor of Arts (Computer Science), Magna cum Laude, Augsburg College, Minneapolis, MN. Return to Top of Page Return to Qualifications Page WCS: Home | Qualifications | About WCS Consulting: Benefits | Services | Engagements Links: IT Resources | Portland | Site Map

Designed, created, maintained, and © Wright Consulting Services, Inc., 1996-2003. Last updated 3/23/2003.
Domain name and virtual server hosting services provided by Global Hosting Internet Services.