Resume: Oracle, XML, C++, Java, Perl, UML

Looking for a position that would either be a 100% Telecommute (with one or two visits a month), or that is local to the Twin Cities area of Minnesota and would allow work off-site at least two days a week. Resume below:

Ewan Grantham
3260 140th Ave. NW
Andover, MN 55304
egainc_at_hotmail.com

Technologies
Programming Languages:

C, C++ (Visual, Borland, UNIX), Cobol, COM/DCOM, DCL, Oracle Developer
(1.x, 2.x, 6.x), Fortran, FrontPage 2000, HTML, IconAuthor, Java, J++,
JavaScript, Lotus Notes/Domino, Oracle OCI, Oracle Pro*C++, Perl, PowerBuilder, Smalltalk, TOPLink (Smalltalk), TOPLink for Java, VBScript, VRML, XML

Databases:
Oracle (6 .x, 7.x, and 8.x (including 8i)/ DBA, Developer, System Architect), DB2 (DBA and Developer), Informix (DBA and Developer), Sybase (DBA and Developer), SQL Server, Access (2, 95, and 97/DBA and Developer), Progress (6 and 7/ DBA and Developer)

Operating Systems:
UNIX (System Administrator, Developer) – (HP/UX, Solaris, Linux, AIX), OS/2 (1 and 2), MacOS (6 and 7), DOS, MVS, Windows (3.1, 95, 98, ME), Windows NT (4/Network Administrator and Developer), Windows NT Terminal Server, Windows 2000

Packages:
Oracle Financials (AP, AR, INV, GL, PO, Project Accounting) 10.4 – 11i, S-Designor, Designer/2000 (1.x, 2.x, 6.x), MS Project, Clarify 5 and 6
(ClearSales, ClearSupport, ClearLogistics, ClearContracts), Platinum
Toolkit, Rational Rose (including 2000), Visio (including 2000)

Publication Summary

· Contributing author to several books on Windows and Programming in Windows.

· Contributing author to books on Electronic Publishing, Access, and MS Office.

· Articles for Windows 95 Journal, other magazines.

· Interviewed for articles in Oracle Magazine and InformationWeek on DB Development and Multi-instance tuning and maintenance.

Experience

            January 1992 -- Present: Ewan Grantham & Associates, Inc., Andover, MN.

Current projects are:

A Major Window Manufacturer’s conversion effort from an OpenVMS platform and VT 220 terminals for accessing Oracle HR 10.7 and in-house Oracle programs to a Windows 2000 Terminal Server platform using Windows CE devices to access Oracle HR 11i and in-house Oracle programs. Technologies I’ve worked with for this project include Oracle 8i, Visual C++ (6), DCL, Java, Perl, JavaScript, VBScript, Oracle Applications 11i, Oracle Designer 6i, Oracle Developer 6i, Windows 2000 Server, Windows 2000 Advanced Server, and Windows CE.

Design and implementation of a commercial website (www.a1161.com). Site designed and produced using Microsoft FrontPage 2000 as well as customized CGI scripts. Technologies I’ve worked with on this project include IIS, Windows NT 4 Server, FrontPage 2000, and Perl.

Other projects (in order) included:

An internationally distributed system to be deployed by a major government entity for the collection and maintenance of medical data. This involved designing the overall system architecture, creating work plans and reporting progress against them, selecting and specifying development and design tools, and working as the technical lead to implement this system. Was also involved in coding two proof-of-concept prototypes (one using Oracle OCI, the other using Pro*C++) to pull data from an Oracle database to be parsed into XML. It is then distributed through a COM/DCOM publish-and-subscribe event-driven interface to other databases (Oracle, DB2, SQL Server) that then read the XML and prepare the correct messages to place the data into those databases. Additional work has included interfacing this system with legacy systems for purposes of data analysis as well as for transactional consistency. Technologies I worked with included Oracle 8 (8.0.5) and 8i (8.1.5/8.1.6), Java (Oracle’s Java Toolkit for XML mainly), Oracle Designer, DB2, SQL Server, Visual C++ (5 and 6), COM/DCOM, Rational Rose (including 2000)/UML, IIS, VRML (for data visualization), Windows NT 4 Workstation, Windows 98, Windows NT 4 Server, Windows NT Terminal Server, Windows 2000 Professional and XML.

A package-enabled reengineering of a major RBOC. This involved designing the overall system architecture, installing and configuring packages, and working as the technical lead to implement changes and enhancements to the package. The system serves 850 users in 14 states using Windows NT Terminal server and other thin clients through the Web to access a system of Oracle Financials and Clarify modules working together through the use of CrossWorlds middleware. Technologies I worked with included Oracle 7 (7.3.3 and 7.3.4) and Oracle 8 (8.0.5) running on several Sun Solaris 2.6 systems, Clarify 5 and 6
(ClearSales, ClearSupport, ClearLogistics, ClearContracts), Java and
JavaBeans, Rational Rose, Oracle Financials 10.7 using SmartClient and NCA (AR, INV, GL, AP, PO), Windows NT 4 Workstation, Windows NT 4 Server, Windows NT Terminal Server.

The reengineering of several existing systems to support improved throughput, design and implementation of a corporate data warehouse. Additionally responsible for project management of the teams involved in these efforts, mentoring of DBAs and Developers, and presentations of plans and produced systems to upper management. Technologies used include Oracle 7 (7.3.2 and 7.3.3), Oracle 8 (8.03 and 8.04), AIX, Windows NT, Windows 95, Designer 2000 (1.3.2 and 2.1), Developer 2000
(1.x and 2.x), TOPLink for Java, Visual J++, and Microsoft Project.

Designing and implementing parallel server/three-tier architecture system for a division of a major health insurance company. Involved database design and implementation in a mixed Oracle 7.3/8.04 environment, working with the programming team to determine necessary changes to enhance throughput and responsiveness, mentoring other DBAs on new technologies and approaches, and architectural planning for expansion of the system. Technologies used include Oracle 7 (7.3.2 and 7.3.3), Oracle 8 (including 8.04), Sun Solaris, Enterprise Manager (1.3 and 1.4), Windows NT, MacOS (7.5.x and 7.6.x), Designer/2000 (1.3.2), Developer/2000, Magna, Java, CGI/Perl, Encina and MS Project.

Designing and implementing several systems to create a single point-of- entry system for accounting and workflow at a major manufacturer of pumps and sprayers located in Minneapolis. Included creating work plans and presentations for implementation as well as coding and DBA work. Was responsible for documenting and presenting proposed changes and additions to the underlying technical architecture to upper management. Technologies used include Oracle Financials (AP, AR, GL) (10.5, 10.7), Oracle 7 (7.1 – 7.3.2), AIX, Designer 2000 (1.3.2), Developer 2000, and MS Project.

Designing the technical architecture for an RBOC’s ISP service. This included the design of databases, as well as front-ends to access those databases, and programs and interfaces necessary for the business. Was responsible for documenting and presenting proposed changes and additions to upper management. Also involved with implementation
(coding and DBA work) of the pilot of this architecture. Technologies
used include Lotus Notes/Domino, HTML, CGI/Perl, Java, Codewarrior Gold 11, Visual C++ (4 and 5), Visual J++, Oracle 7, Designer 2000, PowerPoint, MS Word (7 and 8) and MS Project. Front-end platforms are PCs, Macs, and Sun Workstations (Sun OS and Solaris) talking to an application server. The application servers (Solaris and NT running Netscape Servers and Lotus Notes/Domino) then broker requests for functionality, and data requests are then passed to the centralized customer database (Oracle 7) or the billing database (Sybase 11).

Project management and DBA/Design work for an application that allows a major telecommunications company to tie their various systems together for a single workflow system. Technologies used included Sybase (10 and 11), PowerBuilder (4 and 5), S-Designor, Cobol, Windows (3.11 and 95), HTML, CGI/Perl, Java, Sybase and Intersolv ODBC drivers, Novell 3.12 and 4.x, Clarify (ClearSupport, ClearLogistics), and Microsoft Access
(2, 95, and 97). Front-ends are PC's talking to MVS-based and UNIXbased
 systems.

The design and implementation of a corporate Intranet for a Major Health Insurance company to allow data about patients, doctors, and clinics to be shared and updated throughout the corporate offices, and between remote clinics. Technologies used included ORACLE 7, DB2, Cobol, Platinum, UNIX (HPUX), Oracle Financials (AP, AR, GL, Project Accounting), Designer 2000, Developer 2000, Windows NT, MacOS 7.5.x, HTML and HLP templates for MS Word 6 and 7, Java, CGI/Perl, Smalltalk
(VSE), Visual C++, some VRML, Oracle and Intersolv ODBC drivers.
Platforms for the front-ends were Macintosh and Windows-based PCs talking to MVS-based and UNIX-based systems.

Design and implementation of a complete Loan Processing system for a major financial institution located in San Antonio, Texas. This system also had to integrate with legacy systems for the insurance products and other banking products the client offers. Technologies used included Oracle 7, DB2, Cobol, Fortran, UNIX (AIX), Designer 2000, Developer 2000, MS Visual C++, Windows NT, OS/2, MacOS 7.5.x, HTML and HLP templates for MS Word 6 and 7, JAVA, IconAuthor for CBT on system, some VRML, Oracle and Intersolv ODBC drivers, Smalltalk VSE 3.0 and 3.1.x, PARTS, WindowBuilder, and TOPLink. Platforms for the front-ends were Macintosh, OS/2 and Windows-based PCs talking to MVS-based and UNIX-based systems.

Designing and implementing front-end interfaces to a Major Health Insurance company's Data Warehouses, integrating enabling technologies to support a distributed environment, and creating on-line documentation for the Warehouses and supporting systems. Technologies used included Oracle 7, Oracle Financials (AP, AR, GL), DB2, UNIX
(HP/UX and Solaris), MS Access 95, PowerBuilder, Andyne SQL, MS FoxPro,
MS Visual C++, Novell NetWare, Windows NT, HTML and HLP templates for MS Word 6, IconAuthor for CBT on system, Oracle and Intersolv ODBC drivers, and SQL*Net 2. Platforms for the front-ends were Macintosh and Windows-based PCs talking to MVS-based and UNIX-based systems.

Creating online documentation for a Major Defense contractor based in Minnesota to handle their Legal Information needs using Multimedia Viewer 2.

Coding to create interfaces for Windows and OS/2 clients talking to UNIX-based (primarily HP/UX) ORACLE systems. Interfaces supported both LAN-based and dial-in connections. Programming was done using MS Visual C++, PowerBuilder, MS Access 2 (Windows) and Borland C++ for OS/2
(OS/2).

Leading a project developing and implementing a client-server based data warehouse for a major insurance company in Wisconsin. This system uses a multi-processor UNIX Database server fronted by departmental RS/6000 boxes and serving PC-based clients. RDBMS is Oracle 7 while the client-programming tool is a Smalltalk (ParcPlace) product. Responsibilities included designing the infrastructure (LAN and WAN capabilities), system design, and front-end integration. Developing and presenting seminars in Client-Server design and implementation, C and C++ languages, PowerBuilder (2 and 3), the UNIX operating system, and Oracle and Sybase Databases.

Leading a project designing Client-Server applications for a major Measurement and Controls corporation in Mpls using Progress and Sybase in both a UNIX environment and in a Novell LAN environment, PCs running Windows NT, Windows 3.1 and/or DOS, and Novell 3.11 and included overall architecture design and direction. In addition, was responsible for writing several applications in MS Access and Borland C++ under Windows to support custom needs, and training of staff in C++.

Design and programming work for a major Food Preparation Corporation in Mpls. using Oracle on UNIX (HP-UX), OS/2, PowerBuilder, Novell 2.2 and 3.11, and DOS-based platforms in a Client-Server model. Other work included programming in C for the OS/2 environment to create front-ends to current applications, and some C++ programming in DOS and Windows for specialized user front-ends and integration of systems.

Design work for a University in Michigan's Business Education Department, and design and programming work for a Pharmaceutical Company in New Hampshire. Hardware platforms include HP 9000 827 and 847 UNIX boxes, DG/AViiON's, SUN SPARCstation, IBM Model 95's, and several 386 and 486 clone systems. Software on both systems was Oracle and Oracle Financials (AP, AR, GL, and FA) with a PowerBuilder front end.

Other Work Experience

            February 1990 -- January 1992: Senior Application Engineer. Shared Resource Management, Mpls., MN.

            April 1989 -- January 1990: Project Manager. Centec Advanced Technologies, Jackson, MS.

            April 1988 -- April 1989: System Administrator. Mississippi Department of Corrections, Jackson, MS.

            July 1985 -- July 1986 (Atlanta, GA.):

            July 1986 -- April 1988 (Jackson, MS.): Consultant/Analyst. Creative Computer Technologies.

            July 1984 -- July 1985: Systems Assistant. National Car Rental System, Inc., Minneapolis, MN.

Education

January 1983 - May 1984, January 1987 - December 1987: Mississippi College, Clinton, MS. Major: Computer Science. Minor: Mass Communications Degree: Bachelor of Science in Computer Science (with Distinction), December, 1987.

September 1980 - May 1982: University of Denver, Denver, CO. Major: Mass Communications, Minor: Computer Science.

Selected Interviews, Publications, and Presentations

Interviews:

Tooling Up - "ORACLE Magazine", July/August 1998

Manage Globally, Act Locally - "ORACLE Magazine", March/April 1998

Publications:

ActiveX/Visual J++ Overview, PowerBuilder and Java Journal, February 1997

Contributing Author - SAMS Publishing's Microsoft Office 95 Unleashed. Softcover, Jan. 1996.

Contributing Author - SAMS Publishing's Access 95 Unleashed. Softcover, Dec. 1995

Contributing Author - SAMS Publishing’s Electronic Publishing Unleashed. Softcover, Nov. 1995.

Contributing Author - SAMS Publishing’s Windows 95 Unleashed. Softcover, Sept. 1995

Contributing Author - QUE Publishing’s Killer Windows 95, Sept. 1995

New Multimedia Applets - Article in Windows 95 Journal, Sept. 1995

Contributing Author - SAMS Publishing’s Windows 95 Programming Unleashed. Softcover, August 1995

Multimedia Columnist, Windows 95 Journal, September 1995 issue to September 1996 issue.

Design Considerations for Client-Server Projects, Building Blocks of Client-Server Design - Articles for "From the Summit", Coopers & Lybrand customer newsletter, October 1993 and January 1994

Presentations:

June 1999 – “Implementing COM/DCOM in a Heterogeneous Environment” SwRI
(San Antonio, Texas)

June 1997 - "Introduction to UNIX and Oracle", Class developed and presented for Graco

September 1994 - "Introductory C++", Class developed and presented for FORTIS Insurance

March 1994 - "Using UNIX and Programming in C-Shell", Class developed and presented for WAUSAU Insurance

August 1993 - "Designing Client-Server Systems", Class developed and presented for Coopers & Lybrand

July 1993 - "Introduction to UNIX", "Introduction to ORACLE", Classes developed and presented for Coopers & Lybrand

January 1993 -- "Client-Server: Common Problems & Solutions". Speech given to the Progress User's Group

October 1992 -- "Three Levels of Client-Server". Speech given to the Association of System Management

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 20 2000 - 15:48:33 CST