Sql Server Data

Evan Axelrad

Sr. Database Developer / Analyst

**** ********** ***.

Far Rockaway, NY, 11691

713-***-**** (c)

***********@*****.***

Summary

Senior database developer, analyst, and architect with expertise in SQL Server 2008 R2 / 2012 with some experience in C# and .Net platform. Diverse business experience in equities, derivatives, fixed income, ETFs, asset and mortgage-backed securities, portfolio management, FIX notation and order processing. A motivated and process-driven team player who is detail oriented, with strong analytical and creative problem solving skills.

Technological Qualifications

Highly proficient MS SQL Server 2000-2008 developer skills including database design and data modeling, SQL data partitioning methodology and, implementation, query optimization, creation/optimization of traditional db objects including stored procedures, user-defined functions, views and table functions (a.k.a. parameterized views), SQL metadata tables (sys.objects, sys.tables, etc.), ad-hoc queries, triggers, CLR functions & CLE queries, SQL Server Integration Services (SSIS) & SQL Server Reporting Services (SSRS), Bulk Loading and Bulk Copy Program (BCP)

Experience with SQL Server objects ( tables, view, stored procedures, functions, triggers, etc)

Experience with SQL Server performance tuning ( indexing, SP optimization )

SQL Reporting (SSRS)

SQL Integration Services (SSIS)

Experience in Database Design

Data Warehousing ( SSRS / ETL )

Highly proficient using PowerShell script language

Experienced using:

SQL 2005/2008R2/2012: Business Development Studio, Surface Configuration. Database Engine Tuning Advisor, SSIS, Profiler, Agent, SSRS

MS Visual Studio 2008 / 2010

MS Visual Source Safe

Worked extensively with Bloomberg Terminals and extracting data using BBG-licensed products such as BBG data license / API, Excel Plug-In, and FTP.

Expert in data migration

C# WinForms (Win Forms) using well-accepted object-oriented programming ( OOP )

Core C# Understanding Including OOP principles

Proficient using C# for general use (database loading/transformations, ETL, bulk-load, and business-rule implementation)

Experience with LINQ/Lamba expressions

Product Knowledge

Equity / Equity Options

Futures / Future Options

Gov’t, Corp, Muni Bonds / RMBS

ETFs/HedgeFunds

Currency / Credit Default / FX Swaps

RMBS / ABS / MBS

Currency / Credit Default / FX Swaps

Work Experience

Senior DB Engineer

Dept Of Education NY, NY

May ’15 -

IIT Group MS SQL Server developer role largely responsible for providing operational database services to the organization. Development of backend workflows such as stored procedures and SSIS packages, to achieve business driven goals. Working with stakeholders and other development teams to understand business rules, their impact and needs and to develop integrated workflows to achieve those goals.

Use SSIS packages to develop complex workflows and solve departmental ETL needs

Monitor performance of internal and external-facing web sites, as well as software under construction

Test and develop production jobs

Design and implement SQL server objects ( stored procedures, functions, views, CLR ) to meet project demands

Working with development teams to ensure SQL best practices are maintained

Business needs include maintenance/development of student-related database that assign service providers to students in need of PT, OT, Speech.

Senior IT / DB Developer

ETF Securities NY, NY

Sep ‘13 – Dec ‘14

New York IT Group Responsible for design, development, and deployment of SQL server database for pricing and hedging engine related to commodity ETFs; responsible for front-end UI Development using C# / Win Forms for data extract / presentation of same.

SSIS to load daily price files from vendors, including complete error and status reporting modules

Create / maintain SQL Server database objects (stored procedures, functions, tables, views, etc) in version 2008/R2 to support win/OS hedging tool.

Create / maintain SSRS reports for hedging product.

SQL Server (T-SQL) dB development for OMS, pricing, and hedging engine

Projects completed using iterative SDLC development cycle

Create reports for Margins, Products, NAV, etc. (SSRS)

Create / maintain C#.Net/WinForms application for hedging product, including some aspects of an OMS.

C# - Use of LINQ/lamba expressions

C# - OOP design patterns such as Singleton, Factory of Servicer patterns.

Sr. DB Developer

VanEck Global, NY, NY

Jun ’09 – Jul ’13

IT Data Group Responsible for design, development, and deployment of SQL server database containing financial data at the security and portfolio level, relating to funds (ETFs) created by VanEck to track indices; where funds and portfolios contain equity, fixed income, swap, and derivative products of both domestic and foreign securities; responsible for ETL operations on bank data for portfolio-wide reconciliation. Wide use of SSIS and SSRS.

Projects completed using iterative SDLC development cycle

Create reports ( SSRS ) for data loads, data integrity, etc.

Mine Data Warehouse for financial reports (P&L, portfolio analysis / composition )

Load Data Warehouse via SSIS.

Create and maintain DB objects to provide interfaces between the company website and back-end databases. Objects provided data for the website, breaking down the portfolio data by industry sector, country of origin/risk; weighting by sector, currency.

Deployed 75+ SSIS packages that extract, transform, and load portfolio data from data vendors into client system. Data arrived from vendor is various methods including FTP, sFTP, and email attachments.

Database design work to assist in migrating data from legacy Sybase database to SQL Server platform.

Worked with various data feed formats from major banks/custodians such as State Street, Bank of NY (BoNY), SS&C / EVARE Managed Data Collection Service, Merrill Lynch (fixed income)

Developed desk-top (Win Forms) application to monitor SQL Server jobs for completion success and various statistical data points. Report finding to stake-holders via Email.

VBA add-in for excel to process Bloomberg Data and store in the dB.

Develop C# desk-top applications to enhance and load data coming from data vendors and Bloomberg Terminal where SSIS was insufficient. The main purpose of this application was to provide a GUI where business users and developers could schedule data loads and receive updates on same.

AVP / SR DB Developer/Analyst

Merrill Lynch, NYC

Jan ’07 – Apr ‘09

Whole Loans Technology Group

Responsible for design, development, deployment, and maintenance of:

170GB (600 million row) DB of residential loan servicer data for Wilshire Credit Corporation.

250GB (~1 billion row) DB of performance data for residential loans (RMBS), asset (ABS) and mortgage-backed securities (MBS).

Data Provider was Loan Performance

Designed, coded, and implemented:

C# application to unzip, bulk and data-load data from 19 vendor-provided CSV flat files into a SQL Server 2005 database across 2 servers (dev and prod) on daily, weekly, and monthly bases

C# application to FTP data from vendor web site, unzip, bulk and data-load records from CSV flat files into SQL Server 2005 database daily. Application designed to restart anywhere in the load process, retrying FTP download, unzip, or data-load if previous failure caused file to be skipped.

SQL Server Integration Services (SSIS) to load data from CSV and fixed length files (ragged-right) using components from SSIS including Lookup, ForEach, Execute SQL, Script Component/Task, Email, FTP, OLE DB Command (update) and OLE DB Input/Output. Use SQL Server 2005 file partitioning; Use SQL Server 2000 horizontal partitioning and row auditing.

Environment: Windows NT Server 2003; SQL Server 2000 – 2005.

Senior Data Developer

Reuters, NYC

Feb ‘98 - Dec ‘06

Diverse Markets Development Team

Responsible for design, development, and implementation of database to store financial order routing information in SQL Server 2000. Project included buy/sell side orders, Indications of Interest (IOIs) and Advertised Trades (ATs). The project required handling multiple tasks on an aggressive deadline, requiring parallel sub-projects to meet internal and external client needs.

Performed logical and physical database design. Final design supported 1 million+ transactions/day.

Designed horizontal partitioning to accommodate removal of data after 90 days. Developed strategy for log shipping the data to an off-line db so that data older than 90 days would be available as needed. Coded stored procedures, triggers, including use of SQL-XML, OpenXML. Designed tables, indexes, and back-up strategies. Created DTS packages and one-off applications to assist with data transfer.

Developed, coded, and implemented a DB code-management system in VB Script which allowed for all DBcode (tables, stored procedures, etc) and pre-populated data (via XML and XSL) to be stored in CVS. Any change in code or XML file would result in full and incremental build SQL scripts being generated. These SQL scripts would be wrapped around DOS batch files to generate the build on either developer machines, test boxes or production boxes.

Environment: Windows NT Server 2003; SQL Server 2000 with Replication

Data Infrastructure Team

Designed, developed, implemented, and tested seven back-end database applications using Ab Initio, an Extract-Transform-Load (ETL) tool, for an Oracle 8.1 database.

Supervised and worked closely with consultants to establish coding standards and output formats.

Application extracted data from strategic Numeric Data Architecture (NDA), an abstract data model including a fixed income database, loaded it into temporary staging tables, and formatted the data as per client specifications. Output were flat-file, comma-separated files to be pushed onto a FTP server from which a daemon process would push the file to the client web-site.

Responsible for client communication to ensure data quality and modify application as needed. Documented input and output specifications to ensure the client requirements were met and up-to-date. Application code was deployed, invoked, and maintained in Unix. The code-versioning software was also written in Unix, using source-code-control-system (SCCS). Utilized Unix-scripted SCCS and re-wrote to tailor it to the needs of the project. Relied on Unix and PERL scripting.

Environment: Sun Solaris, Unix with Korn-shell, Oracle 8i with Replication

Education

Bachelor of Science in Computer Science, Texas A&M University

Contact this candidate