VLADIMIR BELORUSETS

*** **** ******, *** *********, CA 94121

Tel.: 415-***-**** (cell), 415-***-**** (home)

E-mail: acpztx@r.postjobfree.com

POSITION Senior Database Developer

SUMMARY

A hands-on database developer/architect with solid experience in innovative application development

and enterprise integration.

Expert in relational and dimensional database modeling and implementation, database application

development, data warehousing, business intelligence, ETL processing, systems integration, replication

techniques, development of software through all stages of product life cycle.

Technical Leadership in enforcing database best practices, design and security standards across

multiple teams inside the department, onshore and offshore.

Excellent communication skills, comfortable interacting with technical and non-technical audiences.

TECHNICAL EXPERTISE

Languages:

Oracle PL/SQL, Transact-SQL, SQL, XML (XSL, XSD, FO, XQuery), HTML, C#, VB.NET, VBA, Visual

C/C++, UNIX Shell Scripting.

Database Servers:

Oracle, MS SQL Server, Sybase SQL, MySQL, MongoDB

Software:

Oracle Streams AQ, Oracle Coherence, Oracle Change Notification, Oracle XML, Oracle Golden

Gate, SQL*Loader, MS SSIS, MS SSAS, MS SQL Replication, Cognos BI, Informatica ETL, Arcana

Scheduler.

Tools:

Oracle Enterprise Manager, Oracle SQL*Plus, Sybase SQL Advantage, PL/SQL Developer, Toad for

Data Analysts and Oracle, Embarcadero Rapid SQL and DB Artisan, SQL Server Management

Studio, MS Visual Studio, MS Business Intelligence Developer Studio, SQL Server Data Tools, SQL

Server Profiler, Database Engine Tuning Adviser, Erwin, Visio, Eclipse.

Version Control Systems:

CVS, Clear Case, TFS.

Operating Systems:

MS Windows, Mac OS, various Linux/UNIX distributions.

PROFESSIONAL EXPERIENCE

Bank of America Merrill Lynch, San Francisco, CA

Sr. Database Developer/Architect 06/2004 – 02/2015

Lead database developer/architect on Bank of America Sales and Research Technology products.

• Was responsible for requirement analysis, design of original logical and physical models,

support and evolution of existing data models, products research and evaluation, implementation,

testing, deployment into production and maintenance of multiple database solutions.

• Worked with the end users to ensure application compliance with business rules, help

achieve higher productivity and to lower support costs.

• Worked with onshore and offshore team leads to defined logical and physical models for each

application, coded data access layers, designed application security and versioning solution.

• Designed, implemented and maintained several MS SQL server and Oracle database

systems: database tables, views, T-SQL and PL/SQL stored procedures and functions, triggers,

PL/SQL packages, indexes, sequences, etc.

• Executed SQL Server and Oracle performance tuning and optimization, resolving deadlock

issues, etc., by setting database parameters, using optimizer hints, analyzing execution plans,

distribution statistics and trace results analysis.

• Executed day to day operational support for ad-hoc reports, non-standard back end updates

and investigations of production data issues.

• Participated in design of Client Master Data system: single source of Client data used across

multiple Bank of America systems and applications.

• Designed and executed multiple database upgrades from MS SQL Server 2000 - 2005, 2005

- 2008 and Oracle 9i - 10G, 10G - 11G databases.

Designed Oracle Coherence layer and supported database objects for data caching.

•

• Designed and developed all the prerequisites and supporting objects necessary to allow

moving database from single instance based to a globally distributed solution using Oracle

Golden Gate replication and Oracle Coherence.

• Was responsible for architecture and development of Data Exchange Services providing real-

time data synchronization between SQL Server and Oracle databases by using .NET C#

Windows Services, SQL Server transactional push replication, PL/SQL triggers, T-SQL stored

procedures and PL/SQL packages.

• Designed and developed ETL solutions by using SSIS packages, T-SQL stored procedures,

PL/SQL packages, SQL*Loader, batch files, Autosys scheduler and Oracle Jobs for data

movement between source and target databases within the Sales and Research universe.

• Designed complex database solutions for the new application platform, migrated data and

business logic from MS SQL server into Oracle database.

• Implemented asynchronous integration between major business systems using Oracle

Advanced Queuing and Oracle notification services.

• Developed and designed Web services to allow using custom aggregate functions in

Research Analyst MS Excel models. Developed MS SSIS ETL solutions to extract, transform and

load data from Research Data Warehouse and Research Database into SSAS Cubes. Created

MDX queries to return cube’s data to be consumed by web services executed from within Excel

add-in.

• Designed and developed ETL process to extract, transform and load data from BofA legacy

system into the common Bank of America/Merrill Lynch post-merger system.

• Led the design and implementation of Research data warehouse. Worked with the business

analysts and business users to shape requirements and define data warehouse structure (star

schema, data sources, ETL processes, data marts, and analytics). Evaluated and selected ETL

and BI software. Implemented data source integration based on Informatica ETL to process large

daily data volumes efficiently from a variety of sources. Designed and configured Cognos BI

integration processes and workflows.

Projects:

• Events Management is a mission critical Client facing enterprise application for multiple lines

of businesses to plan, manage and track global Conferences / Investor Events, supporting the

following line of business: Research, Equities, Debt, Prime Brokerage, Global Treasury Services,

Global Commercial and Corporate Banking.

• Roadshow is an application used by corporate access, research and sales to create and edit

roadshows for their clients, schedule meetings, manage travel logistics, and other aspects of the

conferencing system.

• GEMS/GMLC Integration Project involved merging legacy Bank of America and Merrill

Lynch Conference Scheduling websites.

• Survey Feedback System is an application designed to obtain post conference feedback

from conference Investor attendees.

• Catalyst is a conversion and distribution engine, Bank of America’s next generation research

publication platform which reliably and efficiently disseminates research publications to a

multitude of internal and external destinations while assuring compliance with various SEC rules

and regulations.

• IQ Aggregates project: an MS Excel add-in for Research users providing custom aggregate

functions.

Bank of America/Merrill Lynch merger Legal Day 1 and 2 Integration.

•

Research data warehouse: compilation of research data from a variety of sources.

•

Sr. Software Developer 07/2001 – 06/2004

• Designed and maintained custom ETL system to interface with internal and external data

vendors, such as Bloomberg, Factset, FirstCall, Thomson Reuters, etc.

Developed Research Authoring Tool with MS Word, Excel and VBA.

•

Designed Outlook forms for Research Document workflow and approvals.

•

• Designed and developed a process for converting Research documents in industry standard

RIXML format into Formatting Objects (FO) protocol for later transformation into vendor requested

formats. Used XSL and Antenna Formatter.

Designed and developed Research Oracle database schema and supporting objects.

•

NEXTERA, San Francisco, CA 01/2000 – 07/2001

Application Consultant

• Participated in managing, writing and configuring database schema according business

analysis and conceptual design.

• Created tables, views, stored procedures, defined constrains required to underpin a security

earnings database.

• Participated in the development of Analyst Client Desktop using MS Word, VBA and MSDE as

cache database. System is designed to provide users with a variety of tools for viewing historical

data, entering prognosis into the database and creating ER Documents.

• Enhanced the Feed/Flow application written in Visual C++6 that resolves streaming data

loads for Market Data vendors.

• Developed with Visual Basic 6.0 Administrative Utilities application for managing company’s

coverage, analysts and security identification information.

• Maintained a workflow and document management system in Documentum DocBase and

Sybase databases.

• Developed and enhanced DocBasic procedures with calls to Documentum API and Sybase

stored procedures to address changing business needs and new requirements.

Created triggers to ensure integrity in de-normalized schemas for optimizing data reporting.

•

• Developed reports with Microsoft Access using pass-through queries and linked tables to

Sybase via ODBC.

Projects:

• Equity Research Management System (ERMS) for Bank of America Securities, London

Branch, for Oracle 8i and MSDE database platforms.

• Maintenance and customization development of ERMS for Morgan Stanley Dean Witter, for

Sybase SQL Server 11 and Documentum DocBase database platforms.

ATN CORP., S. San Francisco, CA 03/1999 – 01/2000

Software Developer

TRAINING

2000 Documentum Technical Fundamentals

2008 Cognos Framework Manager

EDUCATION

Moscow State University of Transportation (MIIT), Moscow, Russia

MS in Electrical Engineering

Contact this candidate