IRINA MOROZ

~ DEVELOPMENT ORACLE DATABASE ADMINISTRATOR ~

~ PL/SQL DEVELOPER ~ ETL DEVELOPER ~

Highly experienced Oracle and SQL Server development database

administrator, dimensional & relational modeling. Skilled in data

conversion, database performance tuning and SQL tuning analysis,

troubleshooting, building analytical concepts of the financial and

information software systems. Knowledgeable of the software development

life cycle including: developing design documents, managing the

installation process, design, data migration, modeling of database objects.

Other skills include design/development of data warehouse. Experience

encompasses the entire spectrum of writing Oracle Forms 4.5,5.0,6i, SQL

Reports and Oracle Reports 6i, PL/SQL packages, Informatica mapping and

workflows, as well as the administration and maintenance of SQL

databases(with ASP interfaces) in Web and client-server environments.

Ability to rapidly learn new technology.

Technical Skills

.

Databases: Oracle 7.2/7.3/ 8i / 9i / 10g, SQL Server,MS Access,

Informix 10,

SQL Server 2000/2005

Operating Systems: UNIX, Windows NT/2000,Linux

Programming Languages: PL/SQL, SQL, T-SQL, Developer/2000(FORMS 4.5, 5.0, 6i,

REPORTS 6i)

Database Tools: Toad, SQL * PLUS

ETL Tools: SQL Loader, Erwin, INFORMATICA 7.1.4., webMethod 6.01

Version Control Tools: Visual Source Safe, Serena Version Manager

Skills Summary

Database Programming ? Data Warehouse Development ? Oracle and SQL Server

Database Administration

Performance Tuning ? Database Design ? Database Analysis

Professional Work Experience

SRA International, Inc. Fairfax, VA

2000 to 2013

? Pension Benefit Guaranty Corporation (PBGC) Project

Oracle Development DBA

2007 - 2013

Lead database development team for web-based application development

to allow pension administrators to manage customer pension accounts on-

line. Used Oracle database as a back end and .NET and Java web

services. Project ended.

Administration:

. Developed standards and guidelines to guide the use and acquisition of

software and to protect vulnerable information.

. Performed tuning enhancements to optimize their performance, creating

data archive data model to improve database performance, indexing and

re-indexing.

. Specified users and user access levels for each segment of databases.

. Approved, scheduled, planned, and supervised the installation and

testing of new products and improvements to computer systems such as

the installation of new databases.

. Upgraded Oracle 10g/11g.

Design:

. Wrote and coded logical and physical database descriptions and specify

identifiers of database to management system and direct others in

coding descriptions.

. Created logical and physical database model using ERWIN 7.4

. Modified existing databases, schemas.

Development:

. Coordinated database development and determine project scope and

limitations.

. Developed and tuned up PL/SQL packages, procedures, functions, object

types to perform database activities.

. Developed, tested, debugged and executed SQL installation scripts and

database documentation.

. Tuned SQL queries.

. Reloaded data into new databases. Migrated data and data objects from

one Oracle schema to another.

. Prepared deployment and data migration scripts to move database

objects and data to another database schema /database objects

. Developed ad hoc queries, SQL reports as required for customers and

developers.

. Tested programs and databases, correct errors and make necessary

modifications.

. Store, parse and generate XML Using Standard SQL/XML Functions.

. Set direction and trained a junior developer.

Analysis:

. Acted as First line analyst of production problems relating to the

database.

. Reviewed project requests describing database user needs to estimate

time and cost required to accomplish project.

. Trained users, and answer questions.

? Administrative Office of the US Courts

Senior ETL Developer

2006 to 2007

Developed ETL procedures for the NewSTATS to store, validate federal

judiciary collection data to the data warehouse for reporting of the

Administrative Offices of the US Courts. Project ended.

. Evaluated functional and system specifications and determine best

technical approach to implement changes.

. Designed ETL processes and develop source to target data mappings.

. Production support of Data Warehouse. Production implementation,

including all required documentation.

. Developed code changes using PL/SQL.

? US Agency for International Development / US Department of State

ETL Developer

2003 to 2006

Developed "dashboard" to support USAID executive decisions.

Implemented as a data warehouse composed of Oracle, SQL Server

databases to store and process source data and a Business Object web

application to display the summarized data.

. Designed the data model, star schemas, report layout, developed

extract, transform using Informatica (7.1.4.).

. Developed prototypes of webMethods to tie cross functional data

together.

. Designed, maintain and implemented data export batch process. Created

procedures, functions.

? Internal Revenue Service

2001 to 2003

SQL Server Development Database Administrator

Provided Database Administration support to develop, size, tune,

migrate to production, and maintain SQL Server 2000 Integrated

Planning and Budgeting System database. System was developed using

SQL Server as back-end and ASP, Crystal Report 9.0 as the front-end.

. Designed the database model. Installed, configured, troubleshot

problems. Provided system backup.

. Created and maintained database views, procedures, functions, triggers

and packages.

. Exported, imported databases.

?U.S. Food and Drug Administration

Oracle Applications Developer

2000 to 2001

Supported software services including software development, design and

maintenance of the Regulatory Management System Biologics Licensing

Application (RMS-BLA) system to accommodate specific requirements of

the Food and Drug Administration. The system was implemented using

Oracle database as a back end and Developer/2000 as a front end in a

client-server architecture environment.

. Designed, built, upgraded Oracle Forms 4.5, 5.0, 6i.

. Developed and tuned up PL/SQL packages, procedures, functions.

Education

Institute of Electronics M.S. Electronic Engineering

Moscow, Russia

Business and Management School Master of Business

Administration Moscow, Russia

Oracle Database 11g R2 New & Advanced Features for Developers (ONLC 2013)

Irina Moroz Pg 2 571-***-****

Leesburg, VA

571-***-**** . accbx0@r.postjobfree.com

http://www.linkedin.com/irinamoroz

Contact this candidate