TECHNICAL SKILLS:

Competencies: T - SQL (Stored Procedures, Functions, Indexes, Triggers, Extended SP, Tables, Views), SQL performance optimization, SQL Server ETL (SSIS), Shell scripting, Perl, VBScript, VBA and Excel formulas, SFTP automation between UNIX and Windows, PowerShell. Working knowledge of OOP concepts, C# and Java, XML and JSON

Tools: Visual Studio, SQL Server Management Studio (SSMS, BIDS), Rapid SQL 8, PuTTY, ActivePerl

Architecture: Transactional Database (OLTP), Data Warehouse Architecture (OLAP)

ETL Methods: SSIS, BCP, BULK INSERT, Linked Server

Automation: Autosys, Control-M, Windows Scheduler, SQL Server Agent

Source Control: TortoiseSVN with Subversion, IBM Rational ClearTeam, Microsoft TFS

SDLC Proficiency: Waterfall, Agile and RAD workflows

Miscellaneous: MS Office (Word, Access, Excel, Visio, Project), HP Quality Center, HP Database & Middleware Automation (DMA), Lotus Notes, SharePoint, Jira

Secondary Roles: Level 3 support, crisis recovery lead, global release coordinator, SQL Server upgrade coordinator

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer (Consultant), Jersey City, NJ

Responsibilities:

• On a daily basis, translated business specifications into respective SQL DDL and DML objects (Tables, Views, Stored Procedures, and Functions)
• Developed enhancements to twenty seven reconciliation projects. Worked closely with a Business Analyst to fine tune requirements
• Interpreted and updated complex Stored Procedures
• Analyzed slow performing queries using the execution plan and made adjustments to improve data retrieval speed
• Conducted data analysis using Excel formulas.
• Created release scripts. Wrote support and reference documentation
• Regularly prioritized my goals to meet deliverables
• Modulated my communication based my audience using either layman’s terms or technical verbiage
• Conformed code to company standards and regularly passed compulsory code review with minor changes
• System scope: Daily importation of several million records from over 350+ sources resulting in reconciliation reports of 90+ upstream systems. Feeds ranging in size from several kilobytes to 10+ GB. Database comprised of 2300+ Tables, 2050+ Stored Procedures. Total database size approximately 8 TB.

Database Infrastructure

Confidential

Responsibilities:

• Responsible for the creation of all database objects including Stored Procedures, Tables and Functions.
• Translated verbal requests from management into technical requirements
• Created and implemented Autosys jobs

Environment: Windows 7, SQL Server 2014, BCP, T-SQL, Autosys development, ETL Configuration, SSMS, TFS version control, QA with HP Quality Center, Excel, VBA, Waterfall methodology, SQL Server Agent, Visual Studio 2013, Jira, HP Database & Middleware Automation (DMA)

Confidential

SQL Developer (Consultant), Jersey City, NJ

Responsibilities:

• Responsible for the creation of all database objects including stored procedures, tables and functions.
• Worked with the Business Analyst to finalize the technical specification
• Implemented stored procedure to conduct several validation algorithms against uploaded data. Logged errors, to be reported to the user
• Upon passing validation, benchmark prices were merged into a variety of dated historical tables
• Interpreted existing stored procedures and extended their logic
• Created indexes to improve performance
• Utilized sp executesql with dynamic SQL to minimize SQL injection vulnerabilities
• Stored procedure incorporated query results from a variety of other databases
• Responsible for the creation of all database objects
• Stored procedures utilized extended stored procedure (xp cmdshell) to move the source feeds throughout the process. From the drop location, to processing and then to the archive folders
• Wrote store procedures to import intraday feeds and generate a report by calling the bcp utility
• Store procedure distributed the CSV report as an attachment using sp send dbmail
• Standardized code to meet company standards ensuring proper error handling and logging
• Utilized dynamic code to improve management of release code over 1,500 lines long

Environment: Windows 7, SQL Server 2012, BCP, T-SQL, ETL, SSMS, IBM ClearCase version control, QA with HP Quality Center, Excel, Waterfall, SQL Server Agent, Visual Studio

Confidential

SQL Developer/Technical Trainer, New York City, NY

Responsibilities:

• Responsible for migrating the core trade tables from an obscure database platform to SQL Server 2008
• Designed and created database objects (stored procedures, tables, views, indexes, deployment scripts…)
• Transferred gigabytes of data from legacy system to SQL 2008. Created SSIS packages to import thousands of data extracts
• Created indexes, fine-tuned SQL and utilized other techniques to enhance performance
• Preprocessed and validated feeds with a Perl script on Windows and KSH scripts on UNIX
• Wrote shell scripts on UNIX to augment and enhance feeds. Accomplished this by incorporating BCP, DDL and DML on Sybase. This done using Rapid SQL 8
• Conducted analysis and wrote technical documentation
• Implemented trigger based audit capability to capture manual adjustment to trades
• Developed under RAD and Agile workflows
• Regularly used TortoiseSVN as my source control client
• Configured Tectia SFTP Server to accept feeds from global trading systems
• Regularly coordinated global releases between London, India and Brazil
• Exposed to Qlikview development
• Developed VBScript application to validate and translate Excel spreadsheets into SQL. It also translated results from SQL into SQL code
• Learned obscure CAS query and scripting language and translated them into SQL
• Regularly delivered ETL jobs on the fly to meet Business deadlines
• Created support infrastructure; wrote the 90+ page support manual. Initiated standardized work flows and trained the off-shore support team.
• Became platform Subject Matter Expert (SME) and operated in a level 3 capacity analyzing trade and system anomalies.
• Completed the project on schedule, which was attempted by others and left open for the past six years
• Proactively took the lead role on several late nights to prevent and/or resolve major system interruptions
• Used IBM RTC, Jira and other internal applications to report project progress and initiate production releases
• On a daily basis, involved in all aspects of the Software Development Life Cycle (SDLC), usually under aggressive timelines. Over 30 releases a year
• Modified a custom C# application to include new functionality

Environment: Windows 7, Solaris, Windows Server 2003 and 2008 R2, SQL Server 2008 R2, Oracle 11g, T-SQL DML and DDL, ETL using SSIS, Data Warehouse, Sybase, Subversion, Tectia SSH, Jira, IBM Ration Jazz, Lotus Notes, Qlikview, Agile, Waterfall, C#, VBScript, Perl, shell scripting, Excel, Documentation, ERD, BIDS

Database Developer

Confidential, New York City, NY

Responsibilities:

• On a daily basis, translated business logic, Excel VBA and Access into respective SQL DDL and DML objects (Tables, Views, Stored Procedures and Triggers). Then conducted QA, created release scripts and deployed code
• Responsible for daily importation of eleven feeds and several feeds monthly into SQL Server. These duties were conducted autonomously without any inquiry or direction from management
• Imported financial data was automatically validated, combined, and aggregated into reporting data
• Analyzed and reorganized several complex stored procedures spanning over a thousand lines to reduce complexity and improve performance
• Proactively identified data consistency and performance issues. Proposed several solutions including the pros and cons for manager’s direction
• Entire database records totaled forty million rows. Reporting tables were four tables each totaling four million rows spanning 383 columns. Database included 96 tables, 35 stored procedures, 39 views, and several triggers
• Initiated the development of auditing capabilities to track system changes
• Responsible for the vision and direction of future development. Produced project ERD and Visio diagrams to make proposals to management and out of state resources
• Analyzed, optimized, and fine-tuned the ETL process:
• Proactively initiated development of utilities to validate feeds
• Created Windows form application in C# to generate T-SQL code for the 383 reporting columns
• Diagnosed SQL performance issues by reviewing the execution plan. Then making changes such as updating statistics, incorporating new indexes, using temp tables, CTE and breaking joins into smaller components
• Implemented the ability to run the load processes remotely
• Streamlined existing system. Consolidated six load processes into one. Instead of running major calculations four times to create reports, I reduced this to one.
• Improved daily load process (Interactivity, remote execution, environment variables, performance increase, standardization, different run modes, logging)
• Discovered an Excel process wasn’t running for over a year. Diagnosed and fixed the VBA and VBS to create a dependably produced report.
• Created a stored procedure to easily write and easily generate comparison reports with over 600 columns
• Incorporated internal and external data sources such as Bloomberg currency feeds, transactions, positions, issue and issuer
• Used Excel to generate daily user acceptance test reports
• Reduced load and maintenance time by streamlining five load processes. Identified similarities and combined them into one job resulting in a run time improvement from 1.5 hours to ten minute
• Quickly translated verbal business requirements into code on a regular business
• Proactively created ERD documentation showing detailed analysis of the data flow of columns from source feeds to reporting. This resulted in fixing numerous discrepancies and orphaned data, ensuring a reliable data.
• Initiated the creation of emergency documentation and procedures in case of server issues
• Worked solo and autonomously in the New York trading room. Reported directly to the VP of Investment Analytics and initiated database changes without any formal documentation.
• Developed a C# application to analyze stored procedures to help create documentation of the hundreds of column mappings

Environment: Windows XP, Windows Server 2003, SQL Server 2008 R2, T-SQL DML and DDL, VBA, VBS, ETL, Excel, ERD with Visio, SSMS, C#, data analysis

Confidential

Database Analyst (Consultant), Garden City, NY

Responsibilities:

• Produced daily Excel comparison reports by building an automated SQL process
• On the first day, I found a major discrepancy with their client reporting data that had existed for several years. Was not involved in the resolution, but gave clear details to management.
• Analyzed and constructed SQL queries to create a dynamic reporting platform
• Pivoted SQL data to replicate old functionality

Environment: Windows XP, SQL 2008 Server, Excel, SQL unpivot, SSMS

Confidential

Database Developer (Consultant), Bronx, NY

Responsibilities:

• Created backend of e-commerce shopping cart and inventory system using SQL DDL and DML.
• Converted their Excel accounting system to SQL Server. Translated Excel formulas into many stored procedures and relevant tables.
• Worked closely with management and the front-end developer to understand their needs and in corporate them into the final project.

Environment: Windows 7, SQL DDL and DML

Confidential

Sr. Database Developer, New York, NY

Responsibilities:

• Created and modified tables, stored procedures, indexes, and select statements with complex joins, unions and aggregates on a daily basis
• System processed 15 feeds daily and aggregated them using 50+ calculations to produce a final dataset for financial analysis and reporting
• Designed database schema in SQL Management Studio.
• Custom Excel reports, SSRS, Spotfire and a Cognos cube were used for reporting to the CFO’s accounting department.
• Created 20+ automated ETL jobs. SQL Server 2005 SSIS packages were employed to transport data between (ETL) Sybase, Oracle and SQL Server.
• Diagnosed inefficient processes using SQL Profiler to monitor the Database Engine and implemented indexes and rewrote SQL code to improve performance
• Application originally based on a manual Excel driven process which took 1 week to process 1 day of data. The new system accomplished this operation daily in 2 hours. It involved translating Excel formulas into stored procedures
• Met regularly with the business sponsors and the Business Analyst to understand their requirements and translated them into technical process documentation.
• Able to work with or without business/technical specifications
• Frequently wrote complex analytical queries on very large data sets on a regular basis using SQL Management Studio
• Worked solo and also as part of a group
• Managed 10 servers (3 SQL servers, 3 IIS, 2 Job and 2 Crisis and Recovery servers)
• Frequently produced custom reports with Excel for Finance department review of metrics, and client performance
• Personally QA’d projects to ensure quality results and reliability
• Lead the conversion from SQL 2000 to SQL 2005. The project encompasses 150+ tables housing over 50 million records, and 50+ Stored Procedures and over 30 views
• Responsible for weekly SQL Server and application releases. I did 40+ releases yearly
• Reduced development time and produced cost savings by eliminating redundancy by introducing cross-applications and database standards, shared code and knowledge at regular team meetings
• Worked with Cognos development personnel to produce 15 canned balance and revenue reports
• Constructed code base and schema from scratch
• Created several dynamically generated Excel reports containing client information and coverage
• Developed functioning beta version in one week by myself

Environment: Windows XP, SQL Server 2000, SQL Server 2005, VBScript, T-SQL DML and DDL, SSIS, DTS, Data Warehouse, ETL, Sybase, Oracle, SSMS, SSRS, Visual Studio eGavin.com Feb. 2002 - Nov. 2003