Sql Server Developer

Mark Katuszonek

Lebanon, PA ***** • 717-***-**** • ***********@*******.*** • linkedin URL

Microsoft SQL/ETL Developer

Highly experienced SQL Developer, lead for ETL/SSIS requirements previously supporting an international organization of 10,000 end users, who rolled out modern applications seamlessly integrating them into client Excel and web based ASP.Net applications. Well versed in data analytics, process automation, back-end performance tuning and monitoring capable of quickly turning customer reporting requirements into workable solutions. Known for maintaining composure and professionalism during challenging circumstances, being easy to work with in collaborative efforts or individually where warranted.

ADVANCED TECHNICAL SKILLS

Database Servers: Microsoft Sequel Server 2000, 2008, 2012, 2016

Database Tools: SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS)

Database Coding: Transact SQL

SQL Server Performance Tuning: Optimizing Indexes and Application Performance

Web Based Tools: Microsoft Visual Studio 2012, 2017, Code Charge

Client Based Tools: Excel (Macro Enabled VB)

Web Design: Bootstrap, HTML, CSS, AJAX, JS, ASPX, JavaScript, jQuery, XML, VB.Net

File Transfer: File Transfer Protocol (FTP), Secure FTP (SFTP), Secure Copy Protocol (SCP)

EXPERIENCE

Commonwealth of PA, Lebanon, PA February 2024 – April 2024

SQL Developer

Hired as a short-term contractor with the Lot 1 group of the Commonwealth of PA. Work was being done to prepare the system for upcoming Primary election in PA. Performed Q/A on enhancements to the application, working to improve response time where needed. Also reviewed backend code for large stored procedures impacted by occasional deadlock. Designed and developed an automated task that monitor and reports on long running SQL jobs. Worked assigned issues and met twice daily for scrum calls with the team. Attended periodic off-hours code releases.

Verizon, Lebanon, PA January 2004 – December 2022

Manager MS-SQL Development, (Verizon – Global Sales)

Built and maintained applications for the worldwide sales/service organization of 13,000 supporting the global needs of a much larger organization.

Handled the design and maintenance of multiple Extraction, Transforming and Loading (ETL) processes using SSIS. This allowed for automation of several recurring reporting requirements.

Led the project to upgrade all internal DTS packages to SSIS as we migrated to newer SQL platforms.

Designed, developed and documented the processes to bring in data from disparate sources including Oracle, flat files, CSV files, and Excel workbooks. In some cases, designed new processes in order to build a seamless automated process that staged and cleansed the data before import to the MSSQL-DB.

Requested, procured, installed, maintained and upgraded all servers owned by the organization. Installed and maintained all applications on those servers.

Periodically worked with client representatives to gather requirements and document client needs.

Performed Q/A on new data feeds as well as redesigned data feeds and handled client concerns as they arose.

Mark Katuszonek ***********@*****.*** Page Two

Provided support to peers responsible for the Oracle BI reporting needs.

Led a development team that merged multiple internal web sites into a central site while implementing bootstrap 5 on the new site. This change modernized the web site and enhanced the mobile experience for the end users.

Automated several internal processes for the sales organization into order to more efficiently accommodate critical tasks for the end users.

Responsible for all web-based and database reporting application requirements gathering, development, implementation and maintenance in support of the largest enterprise clients. This included internal performance dashboards, scorecards and activity trackers.

Rolled out automation of many internal, manually intensive reporting processes, building backend data retrieval from diverse internal systems.

EDUCATION

Associate of Arts, Business

University of Maryland, Overseas Division

PROFESSIONAL DEVELOPMENT TRAINING

Over 100 classes in area of:

SQL Server 2016 Bootstrap 3, 4, 5 Web (HTML, CCS) JavaScript Excel (coding) SQL Server 2012

Transact SQL Visual Studio .NET 4.0 Framework SQL Server 2008 Microsoft Server 2008

jQuery Active Directory Procedures and Functions VB/VBA Dynamic T-SQL

Microsoft Exchange Integration Services Microsoft IIS FTP/SFTP

PROFESSIONAL DEVELOPMENT CERTIFICATIONS

Microsoft Certified Systems Engineer (MCSE)

Microsoft Certified Systems Administrator (MCSA)

Microsoft Certified Database Administrator (MCDBA)

Cisco Certified Network Associate (CCNA)

ADDITIONAL INFORMATION

Patent: US 5982752 A, US 6467055 B1. Method And Apparatus For Detecting Multiplexing Standard Mismatches In Communication Networks

Contact this candidate