Oracle Project
Resume:
Title:Data Warehouse Architect
*******@******.***.***.***
Document
Source below
NAME: IAN ABRAMSON
ADDRESS:
CITY: Rochester
STATE/PROVINCE: NY
ZIP/POSTAL CODE: 14624
COUNTRY: USA
EMAIL: *******@******.***.***.***
PHONE: 416-***-****
CANDIDATE ID: N/A
CITIZENSHIP: US
Citizen
EDUCATION: Not Entered
EXPERIENCE: Not Entered
WILL RELOCATE: Not Entered
RELOCATION INFO: Not Entered
JOB WANTED: Not Entered
HOMEPAGE:
COMMENTS:
HOTSKILLS:
ESUME
IAN ABRAMSON
60 Cocksfield Ave.
Toronto, ON
M3H 3S6
I am a Senior Consultant with over eleven years of experience in
information systems. I specialise in Data Warehousing, ORACLE system
development, database
administration (DBA), and RDBMS and Data Warehouse system design and
modelling, for a variety of platforms, from mini- to microcomputers. I
have extensive experience
developing applications using tools such as Oracle's Developer/2000
and PowerBuilder. I have presented papers at Oracle User conferences,
as well as, developed and
taught several courses for developers and end-users. I have
co-authored three books Oracle8 Tuning, Oracle8 Data Warehousing and
SQLServer 7 Data Warehousing for
McGraw-Hill Publishing. I also am experienced in providing technical
product support.
I have extensive experience in the entire system development life
cycle, including business analysis, requirements definition, data
analysis, prototyping, system design and
development, database administration, and relational database design.
Employment History:
Ian Abramson Systems Inc.
Rogers Cable Systems
March 1997 - April 1997
Data Warehouse Architect
December 1997 - Present
Rogers Cable Systems required Hexagon to design and implement a data
warehouse solution. We are developing this data warehouse to meet the
requirements identified by the Marketing department. My
responsibilities include:
Collecting user requirements;
Designing the data warehouse (logical and physical models);
Training personnel on the development of the data warehouse;
Documenting all processes and data transformations;
Managing the development team and development DBA group;
Implementation of the data warehouse;
Development of loading, transformation and aggregation routines;
Establishing and implement DBA procedures for the development team;
and
Training personnel on design and deployment of data warehouses.
The system has been implemented on an Oracle7 database and is
currently being upgraded to Oracle8. The system is running on an IBM
RS/6000
AIX platform.
Hexagon Computer Systems Inc
. January 1997 - December 1997
Professional Assignments for Hexagon Computer Systems Inc
.:
Director, Data Warehousing and Database Technology
As the director of Data Warehousing, I was mandated to manage this
business segment for the Toronto office of Hexagon. This business
segment
was a new one for Hexagon, and required that I develop the Data
Warehousing methodology for the corporation. It was my mandate to
perform the
following tasks:
Develop data warehouse methodology for Hexagon
Deliver internal training on the subject of data warehousing
manage all data warehousing projects
provide technical expertise to Hexagon consultants
perform technical support to Hexagon sales department
develop and implement new Hexagon initiatives, including Remote
Database Support
provide consulting services within my business segment
Ministry of Natural Resources
May 1997 - June 1998Project Leader
Ian led the project team for the creation of the Aircraft Information
Management System (ACIMS). He was responsible for facilitating design
JADs,
and for providing Oracle expertise to the project. He managed the
development process, and communications with MNR personnel, to ensure
the
timely delivery of the system. He served as the Database Administrator
to the project and aided in the design of the database and
application.
provide team leadership
assisting developers with Oracle expertise
developed implementation plan
provided DBA support to the project team
assisting in data loading routines
The environment is Oracle7 and PowerBuilder5.
Dictaphone
February 1997 - April 1997Data Warehouse Architect
It was out mandate to create a data warehouse and reporting system to
allow the client to report on information collected by a dictation
system
provided to the Worker's Compensation Board. Hexagon was required to
design, implement, and tune the data warehouse, so that it was
optimised to
the end user's requirements. My responsibilities included:
installing and configuring Oracle RDBMS and client software
design and implement the database design
implement automation for the preparation of reports
create interface to dictation system data feed.
The system is an ORACLE 7 database, connecting to Cognos' Impromptu
and PowerPlay. The server was a Windows NT platform.
Ian Abramson Systems Inc
. January 1994 - January 1997
Professional Assignments for
Ian Abramson Systems Inc
.:
PWGSC
August 1996 - January 1997
Database Administrator
The Utilities Management directorate of PWSGC, mandated me to provide
remote DBA services for their organisation. The system provides
information on energy consumption and production at power plants
managed by PWGSC. My responsibilities include:
installing and configuring Oracle RDBMS
performing Oracle Database Administration tasks
assisting the application developers in implementing housing system.
The system is an ORACLE 7 database. The database was run on a SCO/UNIX
platform.
Department of National Defence
May 1996 - September 1996Database Administrator/Application Administrator
The Canadian Forces Housing Agency is developing a system to maintain
Forces housing financial information. The system utilises Oracle
Financials
as its financial repository, along with a product that will maintain
the housing information My responsibilities included:
installing and configuring Oracle RDBMS and Oracle Financials
performing Oracle Database Administration tasks for three database
instances
performing Oracle Financials application administration
developed a Work Order Control System
assisting the application developers in implementing housing system.
The system will be written using Oracle Financials 10.6 and an ORACLE
7.1 database. The Work Order System was written using Oracle Forms 4.5
and Oracle Reports 2.5. An Oracle 7.3 database has been configured to
provide Web related services. The server is a Sun Sparc running
Solaris 2.5.
Oracle Press/McGraw-Hill Publishing
September 1996 - PresentAuthor
Technical Editor
I have co-author for three books Oracle8 Tuning, Oracle8 Data
Warehousing and SQLServer7 Data Warehousing for McGraw-Hill
Publishing.
Previously as the Technical Editor, I was responsible for editing the
technical content of the book, "Oracle Data Warehousing", written
Michael
Abbey and Michael Corey. I was responsible for:
verifying the technical accuracy of the book,
providing input into areas that required additional technical
clarification.
The book has been completed and is now available in bookstores.
Department of National Defence
February 1996 - August 1996Database Architect
As the Database Architect, I was required to create a data model of a
number of DND systems. I was to provide conceptual and physical models
for
an Oracle implementation. My responsibilities included:
optimising data models for various existing systems, and proposing the
data model for future systems,
recommending ways to improve data collection and information sharing,
generating physical schema's for implementation,
documenting the data models using Oracle's Designer/2000 and ER/Win
The system was documented in ER/Win and Oracle Designer/2000, running
under Windows with a SCO/UNIX repository.
MPR Teltech
December 1995 - May 1996Senior System Analyst
As a
Senior System Analyst, I was contracted to develop an application
that interfaces an Oracle database and telephone ATM switches, and
extract
and report on call patterns. This application provided information to
a decision support system. The data warehouse utilised Oracle 7, used
to
optimise data access. My responsibilities include:
creating applications that analyse data extracted from the ATM, and
correlate the data for use by the end-user, many of these reports
are written with Oracle Reports,
administer the Oracle database, and provide tuning expertise,
design database and user interface for additional system functionality
implement new system functionality, utilising Oracle Forms 4.5
The system was written using Oracle Forms 4.5, Oracle Report 2.5, on
IBM OS/2 and OS/2 Warp platforms.
Human Resource Directorate
June 1995 - December 1995
Senior System Analyst/Database Administrator
As a Senior System Analyst and Database Administrator, I was
contracted to EDS Canada who is developing the Income Security Program
Redesign. The system is a major client/server system that is being
implemented using Oracle and PowerBuilder technologies. The database
is a
completely distributed database residing on up to ten servers
throughout Canada. My responsibilities included:
performing Oracle Database Administration of the development
environment. The development databases were distributed over a
number of servers.
developing Oracle stored procedures for system data layer
developing Database Administration tools in PowerBuilder for the
project
The system was written using PowerBuilder 4 utilising and ORACLE 7.1
database. The client machines will be PC's running Windows 3.1 and the
server will be an HP 9000 running ORACLE 7. LBMS is the CASE tool for
the project.
Public Works and Government Services
May 1995 - June 1995
Senior System Analyst
As a Senior System Analyst, I was responsible for developing modules
that would be used by numerous other PowerBuilder applications. The
facility
was developed using PowerBuilder 3 and utilised dynamic data exchange
(DDE). My responsibilities included
developing PowerBuilder functions
integrating functions via DDE to other PowerBuilder applications
The system was written using PowerBuilder 3.0 and HP/UX servers
Public Works and Government Services Canada
November 1994 - April 1995
Senior System Analyst/Database Administrator
As a
Senior System Analyst, I was part of a team mandated to develop a
Client/Server Energy Management System for P.W. & G.S.C. I was
responsible for developing the prototype, designing the Oracle
Database, and then developing the production system. My
responsibilities include:
designing the ORACLE 7 production database
developing modules for the production system in PowerBuilder 3.0
Administering the ORACLE 7 database.
The system will be written using PowerBuilder 3.0 utilising and ORACLE
7 database. The client machines will be PC's running Windows 3.1 and
the
server will be a UNIX machine running ORACLE 7.
Office of the Auditor General
January 1994 - October 1994
Senior System Analyst
As a
Senior System Analyst, I was part of an eight person team
mandated to maintain the Financial Management System used by the
Auditor
General. I was responsible for creating an interface between the
Auditor General's Financial System and the Public Works and Government
Service
of Canada financial system. Other work involved system maintenance and
new module development of systems to be used internally at the Auditor
General. My responsibilities include:
create detailed specifications for the Receiver General Interface
develop and test the interface
develop and maintain SQLForms modules for the Financial Management
System.
The interface was written on an HP/UX system using and ORACLE 7
database, SQLForms 3, and SQR as the reporting tool.
SK Sheet Metal
May 1994 - October 1994Senior Analyst/Programmer
I was mandated by a sheet metal manufacturing company to convert a
current application written using ORACLE 5 and SQLFORMS 2.3 to
PowerBuilder 3.0 using a WATCOM database. I was responsible for
converting all existing functionality as well as incorporating new
features.
developing conversion plan.
designing new GUI and WATCOM database
creating the WATCOM database
developing PowerBuilder screens
The system was written for PC, running Windows 3.1.
Oracle Canada
May 1994 - continuingTrainer
I have been contracted on a part-time basis to provide training for
Oracle Canada customers as part of their services provided to ORACLE
users
and developers.
Provide user and developer training.
Synerlogic Inc
.
Ottawa, Ontario November 1987 - December 1993
Professional Assignments at Synerlogic:
Communications Canada
April 1993
- December 1993Team Leader
In an effort improve performance and reliability, a project (SMS
Migration Project) was been initiated to convert the current system,
running on a
mainframe using System 2000 (S2K), to an ORACLE 7 client/server
environment using SCO/UNIX. The phase that we are responsible for is
the
migration. As the Team Leader of this project, my responsibilities
included:
organising and scheduling this phase of the project
assuming a quality assurance role for the development effort
developing modules for a prototype in SQLForms 3.0
defining the migration database in using ORACLE 7.
The migration phase of the project involved a team of eleven people
over a ten-month period.
Mercury Communications
September 1992 - March 1993
London, England
Project Leader
As the Project Leader, I was responsible for managing a team of six
people who were enhancing and supporting a system that supported the
provision of telecommunication services. As the Project Leader, my
responsibilities included:
preparing and analysing future requirements
providing technical assistance and quality assurance for all released
modules
providing database administration for the development and production
environments
verifying that all work was delivered on schedule
developing utilities to aid during the maintenance phase of the
project.
The system was written using ORACLE version 6, SQLFORMS 2.3, RPT, and
PROFORTRAN. The project management tool was Microsoft
Project. The production system was based on a VMS Cluster. Other work
was performed on IBM and Apple hardware.
Labour Canada
May 1992 - July 1992Business Analyst
As the Business Analyst, I was mandated to document the business case
of the Labour Affairs Officers (LAO) as part of a project to automate
the
responsibilities of the LAOs. My responsibilities included:
reviewing and evaluating the User Requirements Document
interviewing all people involved
producing a Business Case Analysis Document
The analysis was recorded in Excelerator and was on schedule and
accepted.
Health and Welfare Canada
Team Leader
January 1990 - March 1992
Senior Programmer/Analyst
February 1989 - June 1989
Programmer/Analyst
November 1987- August 1988
In roles as a Team Leader, Senior Programmer/Analyst or as a
Programmer/Analyst, I designed, developed, and implemented a number of
systems
for Health and Welfare Canada.
The systems developed and designed included:
a system that tracked food samples through the testing process and
related code tables
a migration system to take data from an HP 9000 to an ORACLE database
enhancements to a medical establishments tracking system
My responsibilities at Health and Welfare included:
designing and implementing all systems (including database and system
design)
documenting analysis and revising the system design
supervising and undertaking the development of modules for the system
using SQLFORMS and SQLREPORT
providing technical ORACLE support to the development team
providing training for system users.
The systems were developed for DG minicomputers running ORACLE version
5.1 and SQLFORMS 2.3.
Energy, Mines, and Resources October 1989 - December 1989
Senior Programmer/Analyst
I was involved in the development of a system to support the Canadian
Exploration Incentives program. My responsibilities included:
supervising programmers on the project
developing the more complex modules in the system
The system was developed in the VAX/VMS environment using ORACLE
version 5.1 and SQLFORMS.
Department of National Defence
June 1989 - September 1989Programmer/Analyst
As a Programmer/Analyst, I worked on a system to track hardware and
software licenses owned by the department. I was responsible for:
designing the detailed specifications
coding, testing, and documenting all system modules.
The system was developed on a MicroVAX II using ORACLE version 5.1.
Department of National Defence
October 1988 - January 1989Senior Programmer/Analyst
I assisted in the development of a system to track aircraft
maintenance. I was the Senior Programmer on the project. The system
was developed on a
MicroVAX II using ORACLE version 5.
Elisabeth-Bruyere Health Centre
August 1988 - September 1988Analyst
I was part of a project team that analysed and designed a system for
two outpatient clinics within the facility. My
Computertime Network Corp
. April 1986 - November 1987
Montreal, Quebec
At Computertime I was a technical support specialist. During that time
I supported a statistical analysis tool called RS/1, RS/Explore, and
RS/Discover. Later I was moved to the ORACLE technical support team.
Courses Taught Courses Attended
Introduction to ORACLE (Oracle 5 and 6) ORACLE 7: New Features
Introduction to SQLForms (V.2.3 and 3.0) Implementing Distributed
Systems with ORACLE7
Advanced Oracle SQLForms 3.0
ORACLE for End-Users PLSQL
Database Administration ORACLE Version 6 ORACLE Database
Administration (Version 7)
Data Warehousing and Dimensional Data Modelling CARE Project
Management
Introduction to C programming
PowerBuilder Comprehensive Workshop
Education:
Concordia University
1983-1986 Bachelor of Applied Mathematics
Minor in Computer Science
Publications:
Oracle8I Beginners Guide - By Abbey, Corey and Abramson (Oracle Press:
1999)
Oracle8 Tuning - By Corey, Abbey, Dechichio and Abramson (Oracle
Press: 1997)
Oracle8 Data Warehousing - By Corey, Abbey, Abramson and Taub (Oracle
Press: 1998)
SQLServer 7 Data Warehousing - By Corey, Abbey, Abramson, Barnes and
Taub
(Database Professional Series: 1998)
Professional Presentations and Associations:
1995.East Coast Oracle Conference
Speaker (Stored Procedures and Database Triggers)
1996 Oracle Open World - International Oracle User Group Conference
Speaker (Referential Integrity)
Conference Committee - Developer/2000 Track Manager
1997 International Oracle User Conference - Dallas, Texas
Speaker (PL/SQL)
Speaker (Oracle and Impromptu/PowerPlay)
Track Manager (Application Development Tools)
1997.Oracle Open World - Los Angeles, California
International Oracle User Group on-site representative
Focus Area Manager (Application Development)
Speaker (PL/SQL)
1997.Toronto Oracle User Group
Director of Memberships
1998 International Oracle User Conference - Orlando, Florida
Speaker (Parallelism)
Track Manager (Application Development Tools)
1997.Oracle Open World - San Francisco, California
Focus Area Manager (Application Development)
Speaker (Building the Data Warehouse Team)
1999 International Oracle User Conference - Denver, Colorado
Track Manager (Data Warehousing)
Speaker (Data Warehouse Design)
1997.International Oracle Users Group - Americas (IOUG-A)
Elected to the Board of Directors - Director of Educational
Programming (2 year term)
Technical Expertise
Hardware/Operating Systems
Digital VAX/VMS
Data General MVS/AOS
IBM-PC/MS-DOS
SCO/Unix
HP/UX
Macintosh
DOS
IBM RS/6000 AIX
Windows NT
Development Tools
PowerBuilder 3.0 and 4
SQLFORMS
SQLPlus
SQLReport
SQLNet
SQR
Oracle Developer/2000
Languages
BASIC
PLSQL
Fortran
C
SQL
CASE Tools
Excelerator
CASEDictionary
EasyCASE
LBMS
ER/Win ERX
Project Management Tools
Microsoft Project
Project Workbench
Database Management Systems
ORACLE 5,6, 7, 8 and 8i
WATCOM
Sybase
Red Brick
SQLServer 7
Database Tools
Oracle Enterprise Manager
Data Warehouse Tools
Ardent Data Stage
Methodologies
Gane and Sarson
CASEMethod
Software and Utilities
Windows 95/98
Lotus 1-2-3
Excel for Windows
WordPerfect Suite
Microsoft Office
r
Contact this candidate