Engineer Medical

NIKOLAS AIVAZOV

202-***-**** **********@*****.***

SUMMARY

Experience in project leadership, analysis, design, implementation and maintenance of

the medical, industrial, financial, engineering and scientific applications; database

design and modeling for data warehouse and related ETL, familiarity with Data

Warehouse concept; application design and development; extensive knowledge in

all aspects of systems lifecycle application Development; data modeling using

variety of ERD tool.

TECHNICAL SUMMARY

Software SQL, PL/SQL, SQL*Plus, Oracle Portal 9iAS, Oracle Utilities (Export,

Import, SQL*Loader), Visual Studio .NET 2010/2005/2003, ASP.NET, C#,

Visual Basic, JSP, KALIDO DIW 8.5, Business Objects IX, Cold Fusion,

JavaScript, JAVA, WebLogic, iPlanet, Oracle Developer/2000 (Forms

6i/5.0, Reports 3.0/2.5), Enterprise Manager, C, C++, VBScript, ASP,

PASCAL, Perl, Visual FoxPro, FORTRAN.

DOS, Windows, UNIX, JCL, OS/MVS.

Hardware IBM PC, IBM mainframe, DEC VAX compatible

Database ORACLE 11g/10g/9i/8/7.x, MS SQL Server, Sybase, MS Access, FoxPro.

PROFESSIONAL EXPERIENCE

INTELSAT, Washington, DC 2012 - 2014

Senior Data warehouse Engineer

Intelsat data warehouse supports business intelligence for the largest satellite

communication company in the world. Due to complexity of transformation

algorithms Intelsat uses oracle PL/SQL to implement ETL processes and KALIDO

dynamic information warehouse tool for internal data warehouse structures and BO

as a front end.

As a senior data warehouse engineer developed complicated PL/SQL processes,

designed database schemas, performed oracle 11g upgrade.

Technical lead on ECM C#.NET project (Enterprise Contact Management).

• Add Distribution List functionality to application. Optimized views and stored

procedures.

• Created ETL procedures for Data Warehouse.

• Optimized data exchange and synchronization with SalesForce.com database.

Database lead/DBA on ARM C#.NET project (Earth Antenna Registration Tool).

• Optimization of PL/SQL procedures, functions and database triggers.

• Performed production support for the application.

NIH, Bethesda, MD 2011 - 2012

Senior Information Engineer (contractor)

Technical lead on R-BET and MTDMT C#.NET project. R-BET is NIH Research

Condition and Disease Categorization budget estimating and financial reporting

tool. Mechanism Table Data Management Tool (MTDMT) – NIH budget data

reporting and data management tool.

• Streamlined and tuned budgeting related ETL to be more efficient for ORACLE

and SQL Server databases. Optimized views and stored procedures.

Nikolas Aivazov PAGE 2

• Performed production support for applications.

• Proposed and implemented report changes and use of Business Objects to

improve performance, maintainability and data representation quality.

• Modification and optimization of data warehouse data model.

• Optimization of PL/SQL procedures, functions and database triggers.

Department Of State/Office of Medical Services, Washington, DC 2002 - 2011

Senior Information Engineer (contractor)

Technical lead on Dashboard ASP.NET project designed to allow Department Of State

employees to track progress of medical clearance process via intranet.

• Application design and development.

• Database design and development.

• ETL design and development.

• Application security mechanism design and implementation.

• Integration with Active Directory.

Technical lead on eMED v.2 VB.NET project.

Designed to track patient information, schedule doctor’s appointments, input and view

lab tests results and issue medical clearances to Dept of State employees, who are

being assigned to service at different consular posts around the world.

• Application design and development.

Design, development and implementation security system for the application.

•

Application auditing system design.

•

Design and development of eMED v.2 application System Administration module.

•

Planned database migration to Oracle 10g.

•

Application performance analysis and tuning.

•

Implementation of Redemption package for Microsoft Outlook 2003.

•

Created number of Oracle database views for Crystal Reports.

•

Business and functional requirements analysis.

•

Prototype design and development.

•

Team lead on Acquisition Request Tool (ART) project. It served personnel of Office of

Medical Services to request medical, IT, office supplies, as well as to approve purchase

requests, track orders and manage allocated funds.

Business requirements analysis

•

• System architecture (Oracle Forms 6i, JSP and Oracle Portal integration)

Database stored packages, procedures, functions creation

•

Application security design and implementation

•

Post Capability Database (PCD) is Department Of State internal site, serving as a

source of information for post medical capabilities in foreign countries. It’s being used

by Department Of State employees, stationed abroad, to evaluate and update local

medical providers, medevac routes information, etc.

Database stored packages, procedures, functions creation

•

Database performance analysis and tuning

•

EDUCATION

M.S. in Civil Engineering, Technical University, Tbilisi, Georgia

B.S. in Computer Science, Technical University, Tbilisi, Georgia

NOTES

U.S. citizen. Public trust clearance: 2002-2011 (in DOS)

Languages: English, Russian - native, Georgian – native, French - limited

Contact this candidate