Technical Lead - ETL Team Resume Wesley Chapel, FL - Hire IT People

SUMMARY:

Senior SQL Server Database Developer with a strong background as Database Developer in MS SQL server 2000/2005/2008 R2/2012/2014, as well as mainframe applications development.
Provided tech support and UAT support to customers at both national and international locations.
More than 12 years of MS SQL Server Database Development experience including Health Care and Medicare, e - commerce, Accounts Receivable, Inventory and telecommunications.
More than 8 years of technical team leadership experience in SQL Server and mainframe applications, reporting, requirements gathering, extensive use of T-SQL, SSIS/ETL, stored procedures, views, user-defined functions, indexing and query optimization.

TECHNICAL SKILLS:

SQL Server Database Development (2000, 2005, 2008 R2, 2012, 2014)
SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio (2003, 2005, 2008, 2010, 2012, 2013, 2015), TFS, Agile methodology.

PROFESSIONAL EXPERIENCE:

Confidential, Wesley Chapel, FL

Technical Lead - ETL Team

Responsibilities:

As the technical lead for the ETL team, I am responsible for automating the various processes and jobs we have, utilizing SSIS packages.
New jobs are also created to execute the SSIS packages on a preset schedule using SQL Server Agent.
In addition, I have converted existing jobs with multiple steps with numerous scripts, replacing them with Stored Procedures in place of the scripts.
As a senior Database Developer, I have created complex Stored Procedures, Views and Functions to facilitate the processing of our data in the most efficient manner.
I have also created the Dimension and Fact tables for a new DataMart to house the New Movers data.
As the team/technical lead, I had 5 people reporting to me.

Confidential, St. Petersburg, FL

Sr. MS SQL Server Database Developer

Responsibilities:

Created new processes and development support for Medicare Advantage members as a Sr. SQL Database Developer using SQL 2014.
Responsibilities included the creation of complex SSIS packages to process data from various carriers, performance improvement of existing processes by analyzing execution plans, rewriting T-SQL code and queries, as well as the creation of new processes/systems to replace old and slow performing systems and processes.

Confidential, Temple Terrace, FL

Sr. MS SQL Server Database Developer

Responsibilities:

Provided development support for Confidential as a SQL Database Developer using SQL 2012.
Responsibilities included the query performance improvement by analyzing execution plans, creating indexes, rewriting T-SQL code and queries, as well as job performance optimization.

Confidential, Tampa, FL

MS SQL Server Database Developer

Responsibilities:

Modeled and developed table structures, stored procedures, views, and user-defined functions.
Created new SSIS packages to perform complicated and complex operations, improving efficiency by automating tasks and procedures.
Converted and redesigned the Commissions compensation system from MS Access to MS SQL Server, applying new techniques that improved the process from the better part of a week to less than a half hour.

Confidential, Temple Terrace, FL

Sr. MS SQL Server Developer

Responsibilities:

Modeled and developed table structures, stored procedures, views, and user-defined functions.
Created new SSIS packages to automate tasks and procedures.
Improved query performance by analyzing execution plans, creating indexes, and rewriting antiquated SQL code and queries.
Created stored procedures and views joining data within the OneSource application databases for use with ad hoc requests and daily reports for the application users.

MS SQL Server Developer

Confidential

Responsibilities:

Built internal intranet applications and tools on an ASP.Net (using VB.Net) platform for Verizon’s ordering system, Confidential, functioning as a SLQ BI developer with the following responsibilities:
Created stored procedures and views joining data within the Confidential application databases for viewing of daily statistics on a Metrics website with the use of cubes and Analysis Services.
Built DTS packages to facilitate data transfers between Verizon and multiple internal and external partners.

Senior Systems Engineer

Confidential

Responsibilities:

Developed, tested and implemented code for various enhancements to the customer order processing system using extensive knowledge of COBOL/IMS/DB2.
Implemented CBSS for Portugal Telecom (PT), a $16M account. Provided on-site support as the technical lead in Lisbon, Portugal.
As Technical Lead on the Rating portion for the PT CBSS application, completed work prior to requested time and under budget.

Systems Engineer

Confidential

Responsibilities:

Provided on-site support for User Acceptance Testing and technical support in 3 locations within Canad;Toronto, Manitoba and Edmonton.