| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Lebanon, PA Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLE linkedin URLMicrosoft SQL/ETL DeveloperHighly 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 SKILLSDatabase Servers: Microsoft Sequel Server 2000, 2008, 2012, 2016Database Tools: SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS)Database Coding: Transact SQLSQL Server Performance Tuning: Optimizing Indexes and Application PerformanceWeb Based Tools: Microsoft Visual Studio 2012, 2017, Code ChargeClient Based Tools: Excel (Macro Enabled VB)Web Design: Bootstrap, HTML, CSS, AJAX, JS, ASPX, JavaScript, jQuery, XML, VB.NetFile Transfer: File Transfer Protocol (FTP), Secure FTP (SFTP), Secure Copy Protocol (SCP)EXPERIENCECommonwealth of PA, Lebanon, PA February 2024 April 2024SQL DeveloperHired 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 2022Manager 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.Candidate's Name EMAIL AVAILABLE Page TwoProvided 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.EDUCATIONAssociate of Arts, BusinessUniversity of Maryland, Overseas DivisionPROFESSIONAL DEVELOPMENT TRAININGOver 100 classes in area of:SQL Server 2016 Bootstrap 3, 4, 5 Web (HTML, CCS) JavaScript Excel (coding) SQL Server 2012Transact SQL Visual Studio .NET 4.0 Framework SQL Server 2008 Microsoft Server 2008jQuery Active Directory Procedures and Functions VB/VBA Dynamic T-SQLMicrosoft Exchange Integration Services Microsoft IIS FTP/SFTPPROFESSIONAL DEVELOPMENT CERTIFICATIONSMicrosoft Certified Systems Engineer (MCSE)Microsoft Certified Systems Administrator (MCSA)Microsoft Certified Database Administrator (MCDBA)Cisco Certified Network Associate (CCNA)ADDITIONAL INFORMATIONPatent: US 5982752 A, US 6467055 B1. Method And Apparatus For Detecting Multiplexing Standard Mismatches In Communication Networks |
