Products and Projects

Senior Oracle Developer of the Union's transactional Central Organized Database System (CODS).

CODS is an Oracle 9i database with daily and weekly data feeds from three data vendors: McGraw-Hill Construction (Dodge), Construction Market Data (CMD) & Industrial Information Resource (IIR). The user uses a web browser to search the database for projects (jobs) throughout North America and territories.

My task was Extract, Transform and Load (ETL) data from disparate data sources of various data formats and to develop tables accordingly; in a 3NF schema. That is, to design data parsers for these data streams into the CODS system; develop contextual & keyword search algorithms; and to aid in system efficiency via compiler hints, assorted indices and partition balancing. I assisted in designing the table architecture using Oracle Designer 6i+. Oracle Reports was used for Data Summaries.

This is an n-tiered system so I also worked with IBM WebSphere middle-ware & the Java front-end (JDBC services). End-User interface was Microsoft Internet Explorer vs 5.5+. I was also the senior designer & developer-in-charge of the back-end UBC Security System that determines the Users' roles via menus, which required the use of XML data vectors (and XML Data Types) and Reference Cursors with the front end.

Environment: Massively Redundant Systems with load balancers, comprised of both open & secured (SSL) web access. Legacy and Current data were stored on disparate databases accessed through a CONNX data system. Unix (Sun Solaris) OS (shell scripting), Oracle 9.2i (Release 2) environment (Discoverer, Designer 6i+ & JDeveloper). Software Development: Concurrent Version System (CVS), Oracle SCM, PL/SQL, Java {Struts & Ant} & XML.

Engineering member of the FWO Facility Information Team to support the development and maintenance of Facility Management Information components. Designed & development of Oracle Forms 6i & (Oracle/Brio) Reports running against Oracle databases via 9.2iAS (Release 2); and assist in database design using Oracle Discoverer, Designer.

Assisted in the emergency repair of the Computerized Maintenance Management System (CMMS); specifically, overhaul reports whilst the server is moved from a WinNT to Unix (Sun Solaris) platform.

Assist the Integrated Business Information Delivery System (IBIDS) in developing their intranet-reporting scheme. A month later transferred to the more-critical web-based Business Applications Modernization (BAM) project, a parallel project within Bechtel.

Developed the Management Analysis & Reporting System's Ledger Report to the critical Plan Cost Report that covers Bechtel Nevada's Direct & Indirect Costs & Revenues; and Variances, shared by both the U.S. Department of Energy & Bechtel's IBIDS. Such position required skills in the 3-tiers of Oracle 9iAS: front-end browser, middle (business logic) tier & the Database 8i back-end tier. All fully documented for technical & functional professionals w/in Bechtel.

Language & Tools: Oracle Discoverer, Developer, Oracle 9iAS, Oracle Forms 6i; PL/SQL {Local & Stored Procedures}; TOAD.

Working Environment: Oracle 8.1.7, Oracle Reports v6+, App v11i, Unix (middle & back-end tiers); & Wintels (front-end).

Translate COBOL legacy code into Oracle Version 8+ Client/Server. Created indexed Oracle DB files & constraints. Developed transactional insurance processing software (Geronimo™) for the health insurance industry using Wintel, Novell Server, and Oracle Developer 2000. Created forms and reports using Oracle Developer 2000 (Forms 6.0, Reports 6.0) and triggers and packages using PL/SQL.

Language & Tools: Oracle Discoverer, Developer, 8iAS; PL/SQL {Local & Stored Procedures; & Libraries};

Working Environment: Wintel front-end, WinNT Server; Oracle Forms & Reports.

Consultant/Editor on the Evaluation of Telecommuting in Japan.

The e-Japan strategy of the Japanese government aims to increase telecommuting to 20% of the total work force by 2010.

Dr. Tsubota, Yukimasa
Obirin University
3758 Tokiwa-machi, Machida-shi
Tokyo 194-0294, Japan
Phone:+81(0)42-797-8563
Fax:+81(0)42-797-8563
e-mail: tsubota@obirin.ac.jp

We're currently developing "eWorld", a global map-information program using Quartz, OS X's core-image within a SQL-compliant relational database, OS X's core-data technology. Each map belongs to a 'data set' that contains Rich Text Format data that can be loaded into their respective PDF documents.

The default data format is SQLite compliant.

Maps and map contents will be searchable using Apple's Spotlight™ technology.

Each project comes with a set of 'miniture programs' called "widgets". These widgets can be stored in memory and are easily accessible with the press of a button. A widget is comprised of a XHTML document with associated CSS and Javascript. A few have links to Objective-C stored routines to access the power of OS X.

R.R. Donnelly
Front-End/Open-Source Chief GUI Developer of their proprietary mainframe-centric publishing system.

This web-based PowerStream project is comprised of a suite of software programs that facilitate a rapid, modularized approach for working with projects across print streams, processing platforms, and production equipment.

I've produced (W3C compliant) software technologies (platform agnostic) that produce rule-based XML control files to be parsed by perl-script drivers for C++ routines that control printing machinery.

I chose an OOP Module-View-Controller (MVC) design: the ‘models’, written in JavaScript 1.7 (which also uses YAHOO GUI ‘YUI” libraries ); the ‘view’, via Cascading Style Sheets (CSS); and the ‘controller’, via PHP accessing MySQL running upon an Ubuntu Linux server. I chose XAJAX/Web 2.0 (Open-Source PHP libraries of AJAX) as the binder between the front and back-end tiers.

The data vector (data that is passed between tiers) is XML, stored in a relational database, MySQL. DOM/Xpath was initially used to parse the XML. This was later replaced with JavaScript’s simpler E4X (ECMAScript for XML ) extension.

Subsequent projects include RRD’s mailsort, and RRD’s Compliance Depts’ W-2 and 1099 projects; and a pilot Ruby-On-Rails project.