Vice President Resume New York, NY - Hire IT People

SUMMARY

Detail - driven Database Developer, Optimizer, Modeler wif 25 years of experience. Utilize relational set based approval and extensive technical and analytical skills to resolve complex business problems, improve database structure, functionality and performance. Algorithmic Leader having strong quantitative skills. Success wif design and optimization, methodologies and patterns for performing numeric and statistical calculations wifin database.
Recognized corporate expert in SQL stored procedure / query optimization. Experience in Data modeling, Dimensional Warehouse modeling, and Fixed Income Mathematics, Regression Analysis, and Statistical Modeling.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Vice President

Responsibilities:

Found and formulated intuitive level criteria for identifying problematic SQLs wif high chances for successful optimization. Approach was applied to sets of long running SQLs from monitoring system to get sub-set of queries for detailed investigation. Percentage of significantly improved SQLs in said sub-set was extremely high.
GLOSS - Real-time, multi-currency transaction processing engine (Equities, Bonds, FX). Re-designed core polling mechanism increasing throughput of dis major bottleneck function in magnitude, and by ~30% for entire system, developed generic reporting system for custom reports wif low impact to real-time performance.
Infrastructure Monitoring - Capturing and recording of over 200 Sybase environment metrics every 10 min for 115 database servers, persisted for 6 months for environment analysis.
Designed and implemented incremental approach for extracting current snapshot out of warehouse wif slowly changing dimensions. While high cost for standard approach (all aggregates calculated from scratch) didn’t allow frequent refresh, cost for incremental approach decreases wif frequency of refresh and allow using more fresh data.
Broker Dealer Client Management Service - Developed data processes to convert monolithic 10+ hr, 300+ client portfolio batch processes into highly scalable parallel load requiring ~ 60 min.
FX Trading application - Converted numerous stored procedures and data structures of old Sybase application to enable commodity metals business to be real-time competitive (millisecond response) and scalable (70,000 trades / day) wif minimum retooling and investment.
Mortgage customer data warehouse - Designed new ETL algorithms and data workflow to reduce nightly load of 600,000 customer files from 9+ hours to less than 2 hours.
Different Risk databases running on Oracle Exadata - Analyzed and optimized multiple legacy SQL wif typical improvements in magnitudes.
Anti-Money Laundering system - Improved SQL analytical jobs developed by third-party vendor Mantas. Optimization method is based on stable relationship between quantitative parameters.
Designed and implemented high performance SQL stored procedures (SYBASE, ORACLE, EXADATA).

Confidential, New York, NY

Consultant

Responsibilities:

Designed and implemented numerical methods for yield and performance calculations of fixed income portfolio directly in SQL. Performed business analysis, design, and implementation of sample tests for accrual and performance modules of GLOSS trading system.
Designed and implemented high performance Transact - SQL store procedures (SYBASE).

Confidential, Oakland, NJ

Software Engineer

Responsibilities:

Designed and implemented system for self-consistent calculations identifying shape of wafer’s surface wif teh following real time optimization of grinning operations (PC, C, C++).

TECHNICAL SKILLS

HARDWARE: SUN, HP, Windows

SOFTWARE: SQL, Transact-SQL, PL/SQL, SYBASE ASE, SYBASE IQ, ORACLE, EXADATA, VERTICA, MS SQL Server

We provide IT Staff Augmentation Services!

Vice President Resume

New York, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship