VARDAN AROUSTAMIAN
20938 Elenda Dr.
Cupertino, CA 95014, USA
Phone: (408) 253-6514 home
(408) 910-1639 cell
E-mail: vaar@earthlink.net
vardan_a@hotmail.com
SUMMARY: * Nineteen years of extensive experience in the design and
development of software systems and applications. Strong
analytical, programming, design, integration and database
administration skills
* Strong knowledge of different database management systems
in UNIX and MS Windows environments
* 5 years of experience as an Informix DBA,
Informix Certified System Administrator
* 2+ years of experience in Data Warehouse/Data Mart
development area; knowledge of different ETL tools
* Strong knowledge of C in UNIX, MS Windows and MS-DOS environments
HARDWARE: HP 9000 Series, Sun Ultra Enterprise, IBM PC and compatibles,
Nairi-4 (PDP-11 compatible)
SOFTWARE: UNIX (HP-UX, Sun Solaris, SCO; shell, sed, awk, perl),
MS Windows 2000/NT/95, MS-DOS, C, C++, SQL,
MS-SQL Server 2000/7, DTS, MS-OLAP, Oracle, SQL*Plus,
Informatica, DataStage, ActaWorks, Brio, ProClarity,
Informix Dynamic Server 7.x, Informix-OnLine 5.x, Informix-SE,
Informix-NewEra, Informix-4GL, DB/2,
Clipper, FoxBase, Paradox & Object PAL, Btrieve,
Assembly (Intel 80x86 and IBM 360), PostScript
EXPERIENCE:
InfoGain Corporation www.infogain.com
Cupertino, CA, 08/00 - present
Dallas, TX, 06/99 - 07/00
Position: Data Warehouse Developer/DBA
- at Hewlett Packard from InfoGain
- at Cirrus Logic from InfoGain
Hewlett Packard www.hp.com
Cupertino, CA, 07/00 - 07/02
Position: Data Warehouse Developer/DBA
- Warranty Management System for Computing Systems Division
* Development of Informatica mappings
* Oracle DBA
Informatica PowerCenter 5.1, Oracle 8i, HP-UX 11
- Warranty Reporting Data Mart for Home Products Division
(maintenance and enhancement)
* MS-SQL Server databases maintenance
* Development of DataStage jobs
DataStage 3.1, MS-SQL Server 7, MS OLAP, ProClarity
In all projects
* Performance monitoring and tuning
* Capacity planning, database reorganization
* Troubleshooting
* Scripting (shell, awk, sed)
Cirrus Logic Inc. www.cirrus.com
Austin, TX, 09/99 - 03/00
Position: Informix DBA
- DataWarehouse maintenance
* Informix databases maintenance
* ActaWorks maintenance
- Maintenance of Informix databases for SAP R/3
Informix 7.3x, Sun
- Maintenance of Informix databases for Documentum
Informix 7.2x, HP-UX
In all projects
* Performance monitoring and tuning
* Capacity planning, database reorganization
* Troubleshooting
* Scripting (shell, awk, sed)
The Chase Manhattan Bank www.chase.com
New York, NY, 06/98 - 05/99
Position: Informix DBA
- Existing database and application analysis and
improvement/maintenance recommendations
* Security and Year 2000 issues
* Performance and resource usage monitoring
Towers Perrin www.towers.com
Philadelphia, PA, 08/97 - 05/98
Position: Informix DBA
- Maintenance of OnLine DS 7.2x (HP-UX, SunOS) in production,
staging, testing and development environments (8 servers;
primarily responsible for PeopleSoft HR databases)
which includes:
* System performance monitoring
* Troubleshooting
* Performance tuning
* Scripting (shell, perl)
- developed scripts for statistics information saving and
scripts to extract particular parameters from saved files
- Development team assistance
* SQL analysis and optimization
Intercomservice/Sterling Group www.sterling.ru
Informix Value-Added Systems Integrator
Moscow, Russia, 04/95 - 06/97
Position: Senior Software Engineer
- Database Administrator (Informix OnLine Dynamic Server 7.x,
HP-UX)
* installation, configuration, archive/backup/restore,
replication, troubleshooting
- Provided Informix products technical support and consulting
- Developed experimental programs for testing facilities of
NewEra 2.x; programs on Informix-4GL with CGI
Inversion Specialised banking software developer for CredoBank
Moscow, Russia, 01/95 - 03/95
Position: Software Developer
- Developed applications for converting Bank System data from the
old version (implemented on Clipper) to the new version
(implemented on Borland C++ and Btrieve)
* Developed application for analysing and transforming the data
from the old version to text files with special structure;
Clipper 5.01, MS-DOS
* Developed application for inserting data from text files with
special structure to Btrieve tables of the new version;
Borland C++, MS-DOS, Btrieve, Novell NetWare
Tuapsenefteproduct
Tuapse, Russia, 03/94 - 10/94
Position: Software Developer
- Developed oil sales calculation system;
Microsoft C/C++ 7.0, MS-DOS, Btrieve, Novell NetWare;
* Developed functions for forming requests to Btrieve;
* Developed functions for row selection conditions forming
(translation of user queries, designed in screen forms,
to Btrieve requests);
* Developed functions for printer control and report printing
Yerevan Computer Science Research Institute
Yerevan, Armenia, 11/83 - 03/94
Position: Senior Software Engineer 1990 - 1994
Position: Software Developer 1983 - 1990
- Designed and developed personnel registration and badge
printing system;
IBM PC/AT with VIGA+ card, connected digital video camera
and colour video printer, Windows, Paradox, ObjectPAL,
Borland C++ for interface libraries with colour video
printer and VIGA+
- Developed universal installation program for software
systems for IntSoft Ltd. (Yerevan, Armenia);
IBM PC/AT, MS-DOS, Borland C++ with PCX graphics library
- Created PostScript Level 1 interpreter (with reduced command
set) for Nareg Ltd. (Sydney, Australia);
* Designed general architecture;
* Designed and developed scanner and some groups of operators.
PC version: IBM PC/AT, MS-DOS, Turbo C;
Nareg computer (Motorola 68030, VME bus), UNIX V, AT&T C
- Armenian screen/keyboard driver;
IBM PC/AT, MS-DOS, Turbo Assembler
- Designed and developed a Database for Armenian Red Cross
warehouse;
IBM PC/AT, MS-DOS, Clipper 5.0
- Designed and developed a Database for Armenian Red Cross
patient registration;
IBM PC/AT, MS-DOS, FoxBase+ 2.10
- Designed and implemented a complete Database management system
supporting nested relations;
Nairi-4 (PDP-11 compatible), UNIX, C;
* Designed general system architecture and database structures
* Designed external and internal representation of the nested
relations
* Designed data storing structures, data space pagination;
page structure and page links; records storing method on
pages
* Designed QBE modification for nested relations
* Designed syntactical and semantic analysers of data
manipulation language
* Designed internal representation of queries
* Designed and developed selection part of queries
* Designed and developed some service shell scripts
EDUCATION:
MS, Applied Mathematics, Yerevan State University
Yerevan, Armenia, 1983
TRAINING:
* Veritas Cluster Server, Veritas, Woodbridge, NJ 5/00
* Informix Enterprise Replication, Informix, San Francisco, CA 10/97
* Supporting OS/2 DB/2, IBM, Moscow, Russia 12/95
REFERENCES:
Available upon request
Well, check Informix-FAQ -- Credits Page at
http://www.smooth1.demon.co.uk/ifaqcred.htm
or search comp.databases.informix Usenet group
