ETL Database Developer Resume

SUMMARY:

Experienced in the design, development, and support of SQL Server databases and database software applications used in transactional and data warehousing environments.
SQL Programming.
Database design and data modeling using Power Designer and Erwin.
ETL application development using SSIS.
SQL Server database and server administration
Application development using C# and VB.NET.
Experienced in all phases of SDLC methodology.
Excellent communication skills and ability to work well in a team oriented environment.

TECHNICAL SKILLS:

SQL Server 2000/2005/2008 (R 2)/2012/2014/2016 , T - SQL, SSIS/DTS, SSRS, Crystal Reports, Oracle 8.x/10g, PL/SQL, Power Designer Data Architect, ERWIN, Data Warehousing, VB 6/VB.NET/VB Script, C, C#.NET, ASP.NET (MVC), VSS, VSTS, TFS, HTML, XSL, XML, Java, JavaScript, MS Access, Excel, Visio, Sharepoint

CORE SKILLS:

SQL programming, maintenance, and performance tuning
ETL application development using SSIS and DTS (BIDS and SSDT)
Design and modeling of OLTP and OLAP databases using Power Designer, Erwin, and Visual Studio (Database Edition)
Application software development using Visual Studio/VS.NET, C#, VB, Access, Excel, Java, JavaScript, XSL, XML
SQL Server database administration and production support

PROFESSIONAL EXPERIENCE:

Confidential

ETL Database Developer

Responsibilities:

Development of ETL packages using SSIS 2008/2017 (BIDS/SSDT)
Migrated SSIS 2008 (BIDS) ETL packages to SSIS 2017 (SSDT)
Coding and performance tuning of SQL stored procedures and queries
Production support of SQL Agent jobs used to execute ETL packages and stored SQL

Confidential

ETL Developer

Responsibilities:

Development, maintenance, and production support of SSIS 2008/2012 ETL packages, and SQL Agent jobs for the Tax IT DevOps organization.
Coding of SQL stored procedures, functions, views and queries for the Schools & Libraries Information Center (SLIC) Erate application, Transaction Tax, and Property Tax systems.
Coding of SQL to scrub and repair data from third party vendors.
Development, maintenance, and support of the SLIC C# ASP.NET MVC application, and SLIC Mailer C# desktop applications. Report development using MS Access and Excel
Support of SLIC (Erate), Transaction Tax, and Property Tax applications, and Customer Care end users.
Conversion and migration of SSIS 2008 R2 ETL packages to SQL Server 2012
Migration of the tax organizations SLIC Erate ASP.NET application from Windows Server 2003 (IIS 6.0) to Windows Server 2012 (IIS 8.0)
Administration of the SLIC database and IIS web servers.

Confidential, Atlanta, GA

Senior (Application) Database Administrator/Software Engineer

Responsibilities:

Developed requirements and specifications documents used to detail the design of the DecisionPro consumer credit application processing application.
Developed logical and physical data models using Sybase Power Designer and Erwin to create SQL Server and Oracle databases used by the DecisionPro (OLTP) system.
Developed SQL scripts (in T-SQL and PL/SQL) to create, convert, maintain, and repair SQL Server and Oracle databases. SQL scripts included DDL, DML, stored procedure and cursor programming.
Created SQL scripts used to validate database schemas by extracting database metadata that would be compared to metadata of verified schema releases.
Developed SQL scripts used to repair databases at customer sites.
Created DTS packages used to migrate database objects and data between Oracle and SQL Server platforms, and to import data from legacy databases.
Administered SQL Server and Oracle databases and database servers for the R&D organization.
Provided technical support in the resolution of database performance and corruption issues at customer sites.
Designed and developed software components for the Client/Server and Intranet versions of the Decision Pro software system used by lending institutions to process consumer credit and loan applications. Design included writing requirements and design specification documents, and creating functional prototypes of the intranet application.
Developed enhancements to the Application Manager and Decision Pro consumer loan processing systems using Visual Basic 6, VB.NET, Java (EJB), HTML, XSL, XML, and JavaScript for the WebLogic platform.
Developed Visual Basic 6/.NET software applications used to archive SQL Server and Oracle application databases, validate database schemas, and to extract table data into SQL scripts used to populate other databases.
Development and maintenance of Crystal reports embedded within the application code.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship