Senior Data Engineer
Current• Developed strategies for data extraction from various source systems (Oracle, SQL, DB2, Hadoop), transformation and loading into the Customer Data Warehouse, and created subject specific Data Marts for other departments such as Load Research and Pricing. • Aggregated SRP Residential and Commercial Customer data for Profile Tableau Dashboard to segment customers for more effective, targeted marketing.• Provide performance tuning, and analysis on SQL Server databases to store, query and perform ETL processes on data using SQL Server best practices.• Built automated ETL Customer verification processes for Environmental programs participants using SSIS and eliminated time consuming manual process by 40%.