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.
• Highly proficient MS SQL Server 2000-2014 developer / administrator 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

• 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 /2014
• 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

PROFESSIONAL EXPERIENCE:

Senior DB Engineer

Confidential, NY

Responsibilities:

• 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.
• MS SQL installations
• Database Backups / Restores dB / Index performance

Senior IT / DB Developer

Confidential, NY, NY

Responsibilities:

• 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.
• Load DW via SSIS
• Generate Reports from DW via SSRS
• 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

Confidential, NY, NY

Responsibilities:

• Create reports ( SSRS ) for data loads, data integrity, etc.
• 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, Confidential (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

Confidential, NYC

Responsibilities:

• 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

Confidential, NYC

Responsibilities:

• 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.
• 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 ( Confidential ). Utilized Unix-scripted Confidential 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