JOSEPH KATSNELSON

Brooklyn, NY *****

phone: 917-***-**** adwi4a@r.postjobfree.com

Linkedin.com/in/linkedin.com/in/joseph-katsnelson-11466b4

SUMMARY

Expert in SQL Server Database Development, Analysis, Optimization & Development implementation.

Developed advanced apps with a proven record of successfully delivering high-quality outcomes

More than 15 yr experience in Data Analysis, Data Processing, Transformation and Loading (ETL).

Top knowledge and experience in Transact SQL, SSIS, SSRS, SSAS, OLTP, OLAP.

EXPERIENCE

HendersonHarbor, NY, NY Client: SOLIX, Inc. Parsippany, NJ 08/2021- PRESENT

Senior Developer

Environment: SQL Server 2016/2019, VS 2019, SQL, SSIS, ETL, C#, VB.net, SSRS, Azure DevOps, Redshift

Developed, analyzed, implemented and supported the large financial applications for Solix, Inc.

Analyzed, modeled, and defined tables and the relationships between business data for the new databases.

Created Tables, Stored Procedures, Triggers, Views, Indexes, DB Constraints and optimized the performance.

Designed database Indexes and monitored Index usage statistics to apply improvements & unused index removal.

Performed Data mapping, data conversions, data migration, editing, transformation and data cleansing.

Optimized and tuned T-SQL scripts and Stored Procedures using SQL server Execution plans and SQL Profiler.

Analyzed existing SQL queries to increase efficiency, productivity and decrease CPU bottleneck.

Created the SSIS packages to transfer, convert and load data (ETL) into the SQL Server from different sources.

Developed and Re-design 150 SSIS packages from VS-2005 to VS-2019 and SQL-2005 to SQL -2019

Set up the build and release Azure DevOps pipeline and enabled delivery SSIS packages to the SSISDB.

Developed a fully automated SQL application to Archive Data for the entire pool of the company databases.

The Archive process manage & defines the FK relations and the parent - grandchild sequence for the retrieval.

The automated Archive SQL application accepts the different assignments with the various productivity.

During business hour Archive app can be given task to run with a low pressure on the online systems.

During Off business hour Archive app can be programmed to archive 1 billion records per 10 hours.

Archive app auto creates and modifies the archive tables in real time according to the current table conditions.

Archive process provides the completed auto functionality, stability and scalability for the company business.

Direct Database conversion from SQL Server 2005 to SQL Server 2019.

Created Data Integration SSIS packages for the import and the export of the large Excel and the Flat data files.

Performed data analysis and identified data quality issues and proposed the solutions.

Wrote the process specifications and the Project technical documentation.

InfoPeople, Corp, NY, NY Client: NYC HRA/Dept of Social Services, NY 02/2019- 07/2021

Senior Developer

Environment: SQL Server 2016/2017, VS 2017, SQL, ETL, C#, VB.net, SSIS, SSRS, Informix, Agile dev

Developed and implemented the Placement Assessment Client Tracking (PACT) system for NYC HRA/DSS.

Modeled and Designed a new SQL server PACT database, designed DB constrains, Indexes and SPs.

Responsible for design and implementation of the Data Migration from the Informix Server to SQL Server.

Performed data analysis and developed the SSIS Process to transfer 200 tables of the legacy data to SQL database.

Defined field mappings and data transformation rules. Identified data quality issues and proposed solutions.

Developed the various SSIS packages to transfer and convert the Informix data into the SQL Server tables.

Created Stored Procedures, Triggers, Views, Indexes, DB Constraints and optimized the performance.

Performed Data mapping, data conversions, data migration, editing, transformation and data cleansing.

Created SSIS packages for the import and export of the large number Excel and the Flat data files.

Developed SSRS analytical and statistical reports to identify and track business issues.

Experis NY, NY Client: Ernst & Young Co, NEW YORK, NY 05/2018-01/2019

Senior Developer

Environment: SQL Server 2016/2017, TSQL, ETL, SSIS, SSRS, SSAS, C#, Change Data Tracking, Jira, Excel

Developed and analyzed the Financial Reporting Data Warehouse for the Ernst and Young Company.

Developed the fully automated multi-functional SSIS packages system to load data to the Reporting Warehouse.

The Reporting data application utilized the Change Tracking Microsoft functionality that has immediate data availability and the low overhead.

Worked in all phases of the Project Lifecycle from the research and translating business requirements into detail technical specifications to the implementing new projects into the production.

Created SSIS File Watcher that process any dropped file in the specified location then validates and archives the file. After file validation the SSIS File Watcher executes SSIS packages to load data into the database tables.

Western Union, NEW YORK, NY 11/2014-04/2018

Senior Developer

Environment: SQL Server 2008/2012/2014, Transact SQL, ETL, SSIS, SSRS, C#, DBA, VB.NET, Excel

Analyzed and developed a Financial application for the Western Union payment processing.

Worked in all phases of the Project Lifecycle from the business specifications to the production installation.

Developed the SSIS distribution solutions to update 400 client databases on multiple SQL servers in real time.

Created SSIS packages for the imports of Routing data, Debit Bin data and Zip data. Each of the processes used the SSIS packages to update data in 350 databases on the twelve MS SQL servers in Real time.

Developed the Network traffic data collection system using the SSIS and C# script application.

Developed the various Analytical and Statistical SSRS business reports.

KFORCE, Inc., NY, NY Client: NYC Department HRA, NEW YORK, NY 12/2011-10/2014

Senior Developer

Environment: SQL Server 2005/ 2008, Transact SQL, ETL, VB.net, C#, DBA, SSIS, SSRS, Oracle11, Excel.

Developed Public Transportation Reimbursement App (PTAR) & Daily Tracking System (DTS) for NYC HRA.

Developed new unified system instead of multiple disconnected applications.

Created Stored Procedures, Triggers, Views, Indexes and optimized the performance.

Developed WeCare System in heterogeneous technology environment for multi-site delivery.

Through the linked servers pulled Oracle data to SQL Server databases.

Synchronized Oracle and SQL Server data using Open query command and Oracle packages.

MWH Global NY, NY Client: NYC Department of Environmental Protection 7/2007-11/2011

Senior Developer

Environment: SQL Server 2005/ 2008, Transact SQL, ETL, SSIS, SSAS, SSRS, MDX, OLAP, VB.net, Crystal Reports, Access, WebSphere Portal, DBA, ER/Studio, Excel.

Developed multi-dimensional Data Warehouse for NYC DEP.

Created Data Upload SSIS System to load the various data files to SQL databases.

Developed multichannel SSIS packages with a speed balancing element for all DB Constrains.

All SSIS packages were completely automated and executed on the schedule basis.

Developed Stored Procedures, Triggers, Views, Indexes and optimized the performance.

Designed Budget Data Warehouse using Dimensional modeling, OLAP, SSAS, SSIS, SSRS.

EDUCATION:

BS in Engineering, State College of Mechanical Engineering, Moscow, Russia.

Contact this candidate