Olena Chesnakova

Cell: 650-***-****

San Jose, CA, Email: acgdp8@r.postjobfree.com

***** ****://www.linkedin.com/pub/olena-chesnakova

/79/23a/242

Objective

Database Developer

Summary

Experienced (10+ years) SQL\T-SQL\PL/SQL Developer. Extensive

participation in all stages of software development life cycle (banking,

industrial, and billing information systems.) Strong working experience

with ETL and testing data from different data sources. Extensive experience

in development PL/SQL and T-SQL program units, creation reports (Crystal

Reports, Excel) and optimization of their performance. Experience with ETL

tools (SSIS, MS SQL Import/Export wizards, DTS Designer, Oracle Data Pump,

ERWIN). Over 5 years Visual Basic programming experience.

Technical Skills

Oracle, MS SQL Server, Visual Basic, Delphi, SQL, PL/SQL, Transact

SQL, Crystal Reports, VBA, Excel, Access, Power Point, TOAD,

SQL*Plus, QlikView

Experience

Contract (over HCL, Web XL Systems, Inc.) for Seagate Technology, USA, CA

Excel VBA Developer

07/2014 - 9/2014

. Developed a program Excel VBA as a part of Supply Chain Transformation

Project. The program allows users to perform a group-level input of a

data for uploading to Oracle database with executing all required

calculation steps.

Delta Star Inc., USA, CA

Excel VBA Developer

2011 -2014

. Developed an application that allows to input, calculate and analyze

short circuit condition of transformers at different connection using

Finite Element Analysis as background (MS Excel VBA)

National Bank of Ukraine, Office Zaporozhye, Ukraine

Sr. Software Developer

2007-2010

. Developed and supported banking information system: Processing

Orders for Issuance of Cash (Oracle 9i, Delphi (6\7), and Crystal

Report)

. Developed PL/SQL (Oracle 9i) program units

. Developed Transact SQL program units

. Played a successful role of DBA for SQL Server 2000

. Supported tasks which were developed on Paradox DB

. Developed inner tasks using MS Access

Oasis - 2000, JSC - Zaporozhye, Ukraine

Sr. Software Developer

2003-2007

. Experience in full project lifecycle of planning, developing and

deploying the Billing System Software for National

Telecommunications Corporation - Ukrtelecom (Ukraine)

. Projection, design, implementation, and deployment of the database

(MS SQL Server) for the Billing System

. Extraction, transformation and loading of data from Informix,

Oracle, and non-SQL DB sources to the target database

. Using ERwin, DTS Designer, Oracle Data Pump utilities and creating

TSQL procedures (for loading and testing data afterwards) while

working through the process

. Developed database applications for the project (Visual Basic,

Crystal Report). Testing, deploying, and supporting the system

. SQL Server 2000 DBA

"ZTR", JSC - Zaporozhye, Ukraine

Software Developer

1998-2003

. Experience in designing, implementing, and maintaining database of

industrial information systems for Oracle 8i

. Over 4 years Oracle 8i DBA

Education and Training

Zaporozhzhya National Technical University, Zaporozhye, Ukraine

1997

Computer Software Development - Master's Degree in Computer Software

Development

Soft -Rating, Kiev, Ukraine

2000

Oracle 8 DBA, Developing database applications using Oracle Developer -

Certificate

Networking Technologies Education, Dnepropetrovsk, Ukraine

2000

MS SQL Server 2000, Transact SQL - Certificate of Achievement

Foothill College, CA, USA

2012

Oracle SQL (F052B), Computer CSI I: Java (F027A), Computer CSI II: Java

(F027B), Computer SCI III: DATA STRUC & ALG (F027C), Oracle Database

Administration 1 (F052E), Oracle: Programming with PL/SQL (F052J),

Introduction to LINUX & UNIX (F068A)

Stanford Online2013

Introduction to Databases

Contact this candidate