Lead SQL Developer Resume

SUMMARY

Accomplished Database and Data Warehouse Developer with experience leading the design and development of technical architectures for Enterprise Data Warehouses, with an emphasis on processes to Extract, Transform, and Load (ETL) data. Excellent ability to translate business requirements into IT solutions, with a demonstrated talent for clearly communicating with all levels of business customers and technical professionals.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Lead SQL Developer

Responsibilities:

Designed and developed several data marts and reporting databases from scratch, along with the supporting extract, transform, and load (ETL) processes.
Solved several business problems by devising clever ways to integrate data from multiple systems, using T-SQL stored procedures and database triggers, eliminating the need for larger, more costly application development efforts.
Developed ETL processes and T-SQL stored procedures to collect billing statistics from various operational databases and applications, automating the generation of invoices, reducing errors, and eliminating the need for time-consuming manual processes.
Created a data warehouse to support a large call center, and a system for ranking agents using data collected from various outside sources to calculate performance metrics. Data sources for this system included SQL*Server, Informix, MySQL, and Access databases; spreadsheets; and text files. ETL procedures were developed using SSMS (T-SQL stored procedures), batch scripting, and SSIS.

Confidential

Development Team Lead

Responsibilities:

Let the team that designed and developed the processes for extracting, transforming, and loading the company’s customer data into the enterprise data warehouse.
Played a key role on a team established to develop overall ETL strategy and best practices. Environment included Informatica PowerCenter, Oracle, and SQL Server.
Led a team of onshore and offshore developers responsible for delivering innovation projects and support for applications in the areas of customer data integration and customer hierarchies.
Responsible for evaluating and prioritizing business requests, defining and planning projects, designing and developing effective and supportable solutions, and testing and quality assurance.

Confidential

Development Team Lead / Business Analyst

Responsibilities:

Led the design and development of the ETL processes for a Project Management data warehouse, using Oracle PL/SQL and Oracle Warehouse Builder.
Project Manager and Team Lead for development of a web based application used to track progress and productivity on construction projects. Application was built using ASP .NET and Oracle 9i.
Implemented and managed a successful post-implementation support program that delivered several key application enhancements on time and within budget. Primary responsibilities included evaluating business requests, developing cost and time estimates, allocating development resources, preparing technical specifications for developers, integration testing, and quality assurance.
Managed a call center group responsible for first and second level help desk support and user security.
Responsible for developing and enforcing production coding and deployment standards.