SUMMARY:

• Senior Database / Data Warehouse Architect, Developer, Programmer and Systems Analyst, experienced in a full software life cycle development. Well versed in programming techniques, languages and database technologies.

TECHNICAL SKILLS:

Database Technologies: SQL Server, SSMS, Data Warehouse design and maintenance, database performance tuning, cloud computing - based Snowflake data warehouse, DML, DDL, T-SQL, ETL, SSIS, BCP, data modeling, SQL Profiler, SSRS, MS Visual Studio, proprietary statistical tools, Red Gate SQL

Languages: SQL, EXCEL/VBA, VB.NET, VB / Windows / PowerShell Scripts

Job Automation: Tidal Job Management System, Active Batch Job Scheduler, SQL Server Job Agent

Project control: Agile (scrum framework), JIRA, Jenkins, GIT hub, ServiceNow

Source control: GIT, TFS, Visual Source Safe

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior Database Developer and Architect

Responsibilities:

• for the US headquarters of the leading Japanese bank develops, monitors, manages, and optimizes mission critical daily financial data load, verification and reporting, utilizing SQL Server / SnowFlake cloud computing-based database development technologies, SSIS data load and the full integration into Tidal job scheduling system lead ETL and SQL queries developer for the migration from SQL server to cloud based Snowflake environment developed relevant PowerShell scripts as an ETL designer and developer built SSIS based complex data load processes from/to various homogenous and heterogenous data environments with sophisticated transformations (aggregate, merge, script functions), as well as bulk load processes (BCP) for very large data sets, including index rebuild advice and guidance to the other team members and to the other teams about all aspects of data querying, optimization, verification, transformation, load and business impact designed, developed, implemented and monitored daily reconciliation process between SQL Server data warehouse and cloud computing-based Snowflake data warehouse as a data warehouse architect designed and built risk management data warehouse, including strategic, conceptual and activity data modeling by defining entity types, attributes, relationships, integrity rules, and the definitions of all data warehouse objects created automated tool for fast load of semi-structured data into SQL Server, utilizing SQL Server procedures/functions, SSIS, BCP, VB scripts and Excel/VBA

Confidential

Senior Data Manager and Architect - SQL Server

Responsibilities:

• managed, controlled and maintained daily and intraday financial data load from various sources (including unstructured data) into SQL Server environment as an ETL designer and developer heavily utilized SSIS and BCP for sophisticated data load processes created tool for filtering bad data based on standard deviation and other data characteristics created fully automated tool to seamlessly move data between all environments, with abilities to do conditional and / or partial updates as a database architect redesigned and streamlined the whole database system, including all types of data modeling (redefined several entity types, attributes, relationships and integrity rules) created tool for rebuilding primary and foreign keys and indexes developed new and enhanced existing risk management methodologies, models, integrated services, tools and reports (VaR matrices, P&L and exposure shocks, credit risk, market risk, liquidity risk, delta adjusted equity portfolio exposure), utilizing complex SQL queries and all types of database objects created “Mobile Database Access” tool utilizing MS Outlook macros, SQL queries and VB / Windows scripts as a database architect optimized processing of very large data sets (size of database 2 TB, some tables accumulating up to 90 million records daily) utilizing data modeling developed the lossless compression algorithm (versioning) for large SQL tables.

Confidential

Senior SQL / Oracle Developer

Responsibilities:

• upgraded the existing trade settlement model and added new functionalities to allow seamless trade flow from initial trade capture through settlement process to final entry and processing by the accounting system and to monitor the whole process created and optimized the process of extracting the data from Oracle DWH via RapidSQL and SQL Server Openquery developed Job Status Dashboard (in SQL Server Reporting Services - SSRS) to control immediate status and history of all SSIS jobs and schedules (package name, schedule info, start time, end time, job status, messages) all business related activities packed into SQL Server Integration Services (SSIS) packages and scheduled SQL Server jobs.

Confidential

SQL Server Database/Data Warehouse Programmer and Systems Analyst

Responsibilities:

• supported database / data warehouse systems and applications, and enhances existing risk management methodologies built multi-asset, multidimensional risk/variance/covariance data warehouse in SQL Server environment converted original Excel/VBA, and MS Access GUI to complex, interactive SQL Server Reporting Services (SSRS) interface system enhanced access to Oracle accounting engine via link server from SQL Server and Openquery statements for personally developed risk models created specialized SQL Server functions:
• Black-Scholes pricing
• Black-Scholes delta cumulative normal distribution draw from normal distribution curve.

Confidential

SQL Server Database Programmer and Systems Analyst

Responsibilities:

• developed and supported database applications, risk management methodologies, quantitative trading strategies, option pricing models and portfolio analytics introduced portfolio statistics (index decomposition, IRR, ROE, P&L distribution) technical leader of SQL Server 2000 to SQL Server 2005 migration including conversion of existing SQL Server 2000 DTS to SQL Server 2005 SSIS packages ptimized existing procedures, views, and user-defined functions for SQL Server 2005 execution plans applied proprietary ETL techniques to convert flat files, MS Access data structures, and SQL Server 2000 data structures to SQL Server 2005.