Etl Developer Resume Profile
Jolla, CA
Objective
Utilize my software development skills for a challenging development opportunity
Qualifications
- 16 years of experience in Information Technology developing applications using Microsoft technologies such as asp.net, c and sql server as backend database.
- Proven experience in small, medium and large-scale projects. New projects, data migration, existing projects.
- Leadership skills demonstrated in successfully maintaining information systems, which met SLAs
- and company objectives. Assessed requirements, planned, developed, tested and trained end users
- in new applications.
- Excellent verbal, written and presentation skills.
Security History
Secret clearance
Background checks
Technical Environment
Language: C , Transact-SQL, PL/SQL.
GUI: Asp.Net Web forms, Windows Forms, Access Forms, Visual Basic.
Reporting Tools: SQLServer Reporting Services, Crystal reports
RDBMS: SQL Server 2000-2008, Oracle, Db2
Database Dev Tools: SQL Server Mgt. Studio, Oracle Enterprise Manager, TOAD
Web Technologies: ASP.NET 1.1 to 4.0, LINQ, MVC, AJAX, jQuery classic ASP, SEO
Web Server: Windows Server 2000-2008
Scripting: UNIX Shell Scripting, JavaScript, and VBScript for applications.
ETL: SSIS, Informatica, Custom C Code,
Oracle PL/SQL ETL Processing.
Operating Systems: Windows and DOS.
Tools: Test Director, Team Foundation Server, Visio, MSOffice, Access, Excel, StarTeam,
Visual Source Safe, PhotoShop, FlashMX, JAMS job scheduling system.
Payment gateway Netbilling
Experience:
ETL Developer
Confidential
Build and expand existing database and warehouse architecture to include data modeling, architecting an Operational Data Store including a landing database to staging database, transform logic applied between the landing and staging database. Apply slow changing dimension merge statement and logic to further push data to a data warehouse. Lay out vision of a robust operational data store with data dictionary, standardized ETL practices.
Develop and maintain existing applications written in:
C , TSQL, SSIS, SSRS, SSAS
Participate in Daily Scrum meetings stand-up
Use TFS for code versioning.
Monitor and troubleshoot issues with automated processes and update end users on fix eta. Processes include SSIS, SSRS, TSQL, C , VB.Net, various other applications.
Develop new processes for B of I analysis departments as requested by business users.
Design workflow documentation on new and existing processes.
Assess BI reporting tools for company use - such as Tableau
Third party software:
Jack Henry associates data warehouse
Soft-Vu
Velocify
NetSpend
GCC
Quickbridge
Exact Target
Salesforce SharePoint API
Cadence
PCLender
Tools:
SSIS, SSRS
Visual Studio 2013
Windows server 2014
SQL Server 2008, 2012 and 2014
Sql Sentry monitoring tool
Aiko 8 LLC Personal project 4/2014 - 7/2014.
Current development project involves an e-commerce website PrestoPanels with SQLServer2008 database.
Created C .Net back-end with MVC4 to construct API service to connect with AngularJs client . scope session with features to add, delete, edit and update records.
Added component Caroussel to the landing page.
Client/UX: HTML, AngularJs,
Middle tier-EntityFramework, C
SQLServerBack-End
Specs include: View details on product, sorting, List of products
Cart/store logic, add, remove from cart.
Technologies used:
AngularJS
MVC4
C
Entity framework
T-SQL - Sql server 2008 back-end
Confidential
Role: SQL Database ETL developer.
Software:
PL/SQL - T-SQL UNIX Shell scripting - C
Tools:
ETL Development Informatica
QA complete Bug Tracking
Active Batch scheduling system.
Gemini service request ticketing system
Confidential
Role: SQL Database ETL, .Net developer.
T-SQL SSIS - C , Power Shell
ETL Development
Pega systems interaction