OLGA PODDUBNAYA ( po-DUB-naia )

(718)-680-9024 home

olga@ynp.net <mailto:olga@ynp.net>

www.ynp.net

POSITION WANTED:

System designer/architect, database modeler/designer/lead developer.

SKILLS:

Strong analytical skills in project architecture and database and application design with extensive technical experience.

Solid background in brokerage backoffice operations, especially settlement activities.

Advanced knowledge of relational design and deep understanding of physical implementation specifics on various RDBMS platforms.

Knowledge of OO design and extensive usage of OOD tecniques.

Strong documentation skills and excellent communication skills.

OPERATING SYSTEMS:

UNIX platforms , System V (SCO UNIX) and UNIXWare - 9 years exp,, Sun Solaris 8 - 2 years, Windows NT, Windows 2000 Advanced - 4 years.

DBMS:

ORACLE up to 8i - 11 years exp, SQL Server 2000, SQL Server 7 - 3 year exp.

DB design and development environment products/tools:

ERWIN, Visio Enterprise;

Oracle Enterprise Manager Oracle8i, Designer6i, Designer2000, SQL*Plus, Oracle Migration Workbench, tuning tools (tkprof); PL/SQL, SQLJ, PRO*C, Oracle utilities: SQL*Loader, imp/exp, ORACLE*Reports.

SQL Server Enterprise, Profiler, DTS services, SQL Agent, t-sql;

WEB applications development environment:

JDeveloper 3.0, JBuilder, ATG Dynamo DPS/DCS, JAVA (some exp.), JHTML.

UNIX environment:

UNIX shells (sh,csh,ksh), make, SCCS, RCS, C (10 years exp).

Windows development environment:

Visual Studion.NET, С#, ADO.NET

INDUSTRIES:

Experience with Back Office and Service Bureau systems in US brokerage
industry.

EDUCATION:
1982-1984
Institute of National Economy, Kiev, Ukraine.Department of Data Processing.
1984-1987
Institute of Economics and Engineering, Kharkov, Ukraine. B.S. Computer
Science and Data Processing.
1987-1989
M.S. Computer Science and Data Processing. Honor Diploma.

EXPERIENCE:

October 2001 - Present: Sonic Trading LLC, New York.

Project leader for Trades Clearance and Settlement Project.

- Analized business requirements and performed research for self-clearing implementation. Deliverable:

business specifications.

- Defined system architecture and development cycle methodology, choosed software design tools,

development platform.

- Created data models to support settlement cycle that is capable to absorb future extension to complete

backoffice operations: Security Master, Stock Records, Settlement Items ( Trades, Security Lending

transactions, etc.), Account Master. Used Visio Enterprise, SQL Server Enterprise.

- Implemented database prototype, performed data mining from various resources and created scripts to

populate database prototype.

- Coded stored procedures that support business functions, maintanance tasks and simulation tools.

- Translated business requirements to object oriented middle-tier and presentation design that flexibly

supports business functionality. Delivered software design specs in UML static and sequential diagrams

and free form description to team developers. Used Visio Enterprise, Visual Studio.NET

- Created prototype testing plans, audited code to prevent diversion from the class specifications.

- Conducted performance monitoring and optimization and stress testing.

- Created prototype for GUI applications that support settlement clerk functions. Used Visual Studio.NET,

C#, ADO.NET.

Prototype implements trades registration, enriching, confirmation, netting, stock records updates ( including real-time customer position), CNS break processing, receive/deliver exceptions settlement (DTC), NSCC reconciliation and covers equities settlement.

July 2000 - May 2001: Scholastic Corporation, System Internet Group, New York.

Senior DB developer, DB architect/designer.

Working with and refining business requirements, building project architecture and providing technical guidance on ORACLE products and features, security and access architecture, data modeling, DB logical and physical design and implementation, MS SQL -> ORACLE migration, reverse engineering, performance tuning, RDBMS guidance for web developers.

ORACLE 8i, MS SQL 6.5, Sun Solaris 8, Windows NT, ATG Dynamo 5 DPS/DCS, PL/SQL,ORACLE Migration Workbench, ORACLE*Loader, Designer 6i, ERWIN, import/export, ksh,JHTML

Projects:

- Mass Migration project. Responsible for migration of schema and data from legacy MS SQL databases to

ORACLE 8i, logical and physical (layout/storage) design and schema maintenance. Migration was

accomplished with ORACLE Migration Workbench.Performed migration of schemata, reverse engineering

with Designer6i and Erwin, redesign/consolidation, migration of stored procedures, created scripts of data

conversion/cleaning, transaferred data, conducted perfomance optimization (indexing, storage optimization),

teamed with application developers (Java,ATG Dynamo platform) on all database related

issues, supplied documentation on new database schema and stored procedures.

- Teacher Store (e-commerce) project. Responsible for back-end ORACLE 8i data modeling, design and development of on-line Registration and Authorization schema and functions, functional roles and access privileges, data mapping and migration of data from the legacy MS SQL and IT mainframe sources. Schema was designed to fit ATG Dynamo 5 Personalization Server and Commerce Server restrictions and functionality.

- Data pipe project. Responsible for architecture design and development of ORACLE side interface of data synchronization between Website ORACLE DB and corporate DB delivered by MQ Series.

1992 - July 2000: The Davidsohn Group, New York.
Project leader - since 1995. Senior programmer - since 1994.

Most projects subject area was Back Office brokerage house functions,

clearance and settlement: DTC and out-of-DTC, foreign, physical clearance, etc.

Was working with business requirements, business and data modeling, tools evaluation, DB logical and physical design, back-end and front-end implementation, performance tuning.

ORACLE 8.0, 7x, 6x, UNIX System V, UNIX Ware 7, Sun Solaris 7, PRO*C, PL/SQL, JDeveloper, ORACLE *Loader, import/export, tkprof, Designer2000, shell scripting,tcp/ip
Last projects:

- ORACLE 8 migration of the Powercage/Powerbank clearance
system for the new client.
Responsible for back-end design and migration, benchmark testing and performance optimization for transaction level increase.

- ORACLE 8/JAVA migration. Responsible for the re-architecting, redesign of the back-end using ORACLE 8 advantages, evaluation of the front-end development tools like JDeveloper or JBuilder, prototyping front-end.

- Trade Management System. Responsible for a front-end prototyping in JDeveloper 3.0 and ORACLE 8 PL/SQL business logic implementation for commission calculation.

- Maintenance: new requirements from clients, small ongoing projects like out-of-DTC handling, extending of availability for bank loans,etc. Responsible for a design and outlining tasks for junior programmers.

Previous projects: I participated as a senior designer/architect and developer during a full life cycle of each project from initial design, data modeling and prototyping to the maintenance of the working product.

I designed DB schema and business logic implementation ( tables, views, indexes, triggers, packages, stored procedures, etc.), cooperated with DBA on physical design and performance issues, interacted with business analysts and end-users on detail design issues, wrote code for back-end and front-end applications with other programmers and supervised junior programmers:

- Y2K internal and DTC testing for PowerCage/PowerBank systems: 1999

- Back Office clearance system for Cantor Fitzgerald, CA; WorldCo, NY;
Morgan Stanley, NY; Merill Lynch,NY: 1995 - 2000
Was involved in full project life cycle: redesigned system and database;
developed applications, stored procedures, packages, triggers, reports,
batch jobs; resolved production environment problems.

- Trust Company clearance system for Nomura Trust, NY: 1997 - 2000.
Was in charge of design including database and applications, developed
triggers, packages, reports.

- "New York Window" - physical securities clearance system for National
Security Clearance Corporation (NSCC), NY: 1994 - 1996.
Was involved in full project life cycle, applications development, stored
procedures, reports, tuning, and maintenance.
Was personally responsible for:
Security Master, Stock Record, Customer Positions and SOD/EOD Reports.

- AutoCage and AutoBank systems for Nomura Securities International, NY:
1992 - 1994.
Was involved in full project life cycle as application developer. Was
personally responsible for Pledge and Tokyo trading clearance systems.

1987-1992: Institute of Computer-Aided Management and Manufacturing (ICAMM), Kharkov, Ukraine.
Senior programmer/analyst.
Projects:

- Local management information system for USSR Astronauts Training Center in Zviozdny, Moscow: 1989-1991.
Responsibilities: Full project life cycle.
Was responsible for Accounting subsystem, Visitors Pass subsystem, and project coordination.
Administered ORACLE 5 and SCO XENIX for local sites, provided training.
Software: ORACLE version 5, SQL*Forms 2.3, SQL*Reports, SQL*Plus, SCO XENIX,
TCP/IP, sh/csh scripts, C, MS DOS.

- ICAMM local distributed database management system. 1987-1989.
Software: ORACLE versions 4 and 5, C, SQL*Plus, old ORACLE reports and forms generators.
1987 (Programmer):
Member of ICAMM distributed database system development group, was
involved in researches and comparative analysis of distributed RDBMSs.
Pascal and C under UNIX for prototyping of optimization algorithms.