Oracle developer / tester
Resume:
LEONID UZVALOK
Canton, MA **021
***@*******.***
Summary: Experienced DB developer, tester.
Multiple projects in mutual funds, retail, financial and
industrial applications.
Data Base: ORACLE 7i-9i/10g, SYBASE, SQL-Server,
Transactional and Data Warehouse model.
Languages: SQL, PL/SQL (packages/ stored procedures, functions/ triggers),
Transact-SQL, Unix Shell Scripts, Pro*C, C /C++, HTML, PHP.
Tools: SQL*PLUS, Designer/Developer /2000, Oracle Forms, Reports,
SQL*Loader, Data Pump, AutoSys, DBArtisan, TOAD, ClearCase
Macromedia: Dreamweaver 8, Flash MX, MS Enterprise Reporting
OS: UNIX, SunOS , Windows
Hardware: IBM RS/6000, SUN-Solaris, PC, mainframe IBM 360/370
Project Roles: Designer, Developer, Tester
Experience:
02/2003- Database Developer/Consultant
09/2009 Columbus Nova / Renova
New York, NY
Developed multiple projects for the company including:
Integrated company DB, design logical and physical data model.
- packages, stored procedures, views, triggers
- database logical and physical structures
- special attention was given to intensive performance tuning
- various queries for testing
Designed, developed and implemented Invoice processing application.
Implemented financial consolidation (MS Enterprise Reporting) for
financial holding company with more then 100 subsidiaries.
- Designed and implemented tools for data verification and cleansing
- Designed multiple reports.
Designed and developed as part of a team e-commerce Web site for
manufacturing subsidiary:
- HTML programming, Micromedia Dreamweaver 8, Flash MX development
- PHP /MySql development
Performed comprehensive unit testing of developed software.
All applications were developed utilizing Oracle 10g, PL/SQL, TOAD
MySql, HTML, Dreamweaver 8, Flash MX in SunOS, Windows environment.
08/2002- Database Developer/Consultant
12/2002 Investors Bank & Trust (IBT)
Boston, MA
As a team member of InvestSmart-Compliance project developed,
implemented and Integration /System tested Oracle based project for
Mutual Fund industry.
Developed:
- stored functions to be used in complex views for data retrieval
- packages, complex views, triggers
- database logical and physical structures
Performed intense performance tuning on both Oracle Server and
Application sides due to data located in complex DB structures
(some with multi million row tables).
Performed comprehensive unit testing of developed software.
Assisted QA group in creation of custom DB queries, procedures to verify
DB integrity and took part in Integration/System testing of finished project.
All applications were developed utilizing PL/SQL, TOAD in Oracle 9i
SunOS, Windows NT environment.
08/2000- Database Developer/Consultant
08/2002 Fidelity Investments (FMRCO)
Boston, MA
Developed, enhanced and implemented new :
- packages, stored procedures, triggers (with intense performance tuning)
- database logical and physical structures
- Unix shell scripts and batch processes
for the following Web and Client-Server applications:
- 'IPPS' - investment professional profiling system (Oracle)
- 'GTRAC' - global commission tracking system (Oracle)
- 'Commission Statistics' - reporting system for statistics information (Oracle)
- 'Pre-Clearance for Employee Trades' - trade compliance system (Sybase)
- 'PLATO' - restrictions for worldwide Fidelity funds and accounts (Sybase)
- 'Online Broker Voting System' -portfolio managers votes for brokers (Sybase)
with data located in complex DB structures (multi million rows tables).
Assisted QA group in creation of custom DB queries, procedures to verify
DB integrity. Performed comprehensive unit testing of developed software.
Developed maintenance procedures, documentation and provided 24/7
production support for above applications.
All applications were developed utilizing PL/SQL, SQL*Loader
Transact-SQL (Sybase Server 11.9/12) in Oracle 8i, SunOS, AutoSys,
Windows NT environment.
12/1997- Database Developer /Consultant
08/2000 Commonwealth Of Massachusetts (Department of Transitional Assistance)
Boston, MA
As member of Conversion team played one of the key roles in‘Legacy’System
to Client-Server conversion - ‘BEACON’ project with data structure allocated
in more then 350 tables (many tables with multi million rows).
Designed and implemented high complexity applications: ‘Child Care’,
‘Income’ (21 types of income/expense) and many others were modified.
Application ‘Employment Service Program’ was developed as daily batch job,
and production support was provided.
Performed comprehensive unit testing of developed software.
All applications involved intense PL/SQL tuning and were delivered in the
form of PL/SQL packages (wrapped in Unix scripts) utilizing Designer /2000,
PL/SQL V2.3, SQL*Loader and Unix Shell programming in Oracle 8.05 / 7.3,
AIX Version 4, Windows NT environment.
10/1997- Database Developer /Consultant
12/1997 Putnam Investments, Braintree, MA.
Designed and implemented project `Account Officer` for Reporting System
based on changes in Retail 401 (k) plans and implemented enhancements
for several PL/SQL modules, utilizing PL / SQL, Unix Shell programming
in Oracle 7.3, HP-Unix, Windows'95 environment.
09/1997- Database Developer /Consultant
10/1997 Hills Stores Company (headquarters), Canton, MA.
Designed and developed mapping specifications for interface between EDI-
GENTRAN system and Oracle DB for transmitting Purchase Orders, Ship
Notices, Sales and Inventory between Hills Stores Headquarters (155 depart-
ment stores Nation wide) and Vendors, utilizing PL/SQL, DB triggers, stored
procedures and EDI VICS standards in Oracle 7.3, HP-Unix, Windows'95
environment.
04/1994 - Systems Analyst
09/1997 Shaw’s Supermarkets, Inc (headquarters), E.Bridgewater, MA.
As member of ‘CFM’ (corporate file management) team played key role in
development and implementation of back and front end high complexity
software for corporate management of 120 supermarkets (~50,000 items per
store) located in 6 states in client-server environment based on Oracle DB
(distributed over several UNIX multi-processor stations).
Designed and implemented projects: Corporate-Store daily data exchange
for each store, based on corporate ORACLE DB (17 Mb per store, 2Gb total),
Compare & Save Offers (against Competitors prices).
Participated in entire development cycle of 2 new versions of multi-function
corporate system ‘CFM’ with data structure allocated in more then 200 tables.
Responsibilities: ERD design, development of DB triggers and stored
procedures, data processing utilizing SQL, SQL*PLUS, PL/SQL, C,
OCI, embedded SQL (Pro*C), GUI design and development in Forms 4.5
in client-server UNIX / Windows 3.1/95 environment, UNIX shell
programming.
Educaion:
1996 Oracle Developer /2000
Forms 4.5 (development)
ORACLE Education, Boston, USA
1995 Designer /2000
ORACLE Education, Boston, USA
1994 Oracle SQL*Forms (development)
ORACLE Education, Boston, USA
M.S. in Computer Science:
College: Moscow Electronic Engineering Institute, Moscow, Russia
Personal: Citizen.
Contact this candidate