Senior ETL Developer Resume Powder Springs, GA - Hire IT People

SUMMARY:

Experienced in Business Intelligence and ETL implementation based on Microsoft SQL Server, Microsoft Integration Services (SSIS), Microsoft Analysis Services (SSAS), and Microsoft Reporting Services (SSRS).
Data Warehouse Design and Implementation.
SQL Query Optimization and Performance Tuning.
Microsoft SQL Server DBA (up to SQL 2016).
Strong knowledge and background on Oracle Database Server. Core competencies
ETL Design and Implementation.
Relational Data Modeling.
Multidimensional Data Modeling (Snowflake and Star Schema).
Parallel Data Loading.
Database Security.
Data Partitioning.
Linux/Unix Operating System. Shell script, and other Unix - based tools.

PROFESSIONAL EXPERIENCE:

Senior ETL Developer

Confidential, Powder Springs, GA

Lead ETL developer assigned to Information Technology Department, State of North Dakota.
Designed and implemented State’s Educational Staff Data Warehouse in Star Schema.
Maintained and enhanced iMart K-12 Data Warehouse System for Department of Education, State of North Dakota.
Built parallel data loader. The ETL process, downloads 160 school district data, executes 4 times faster than in sequential mode.
Designed and implemented Training System on K-12 Data Warehouse and reporting system. All the student identities in the training system are totally anonymized but persisted.
Supported other state and county level agencies running iMart K-12 Data Warehouse System.
SQL Query Optimization on complex queries.
SQL Server Performance Tuning on SQL-2008, SQL-2012, and SQL-2016 Servers.

Senior DBA Consultant

Confidential, Atlanta, GA

Enhanced and supported the CVBAT (Customer Volume Behavior Analysis Tool). CVBAT is an in-house CRM application developed and supported by Department of Business Information & Analysis.
Implemented EWMA (Exponentially Weighted Moving Average) statistical function in Transact-SQL.
Built ETL processes in SSIS to extract data from Oracle Data Warehouse with Siebel Tool.
Designed and maintained the weekly, monthly, and yearly data extractions and rollups for CVBAT reporting system.
Developed Stored Procedures in static and dynamic SQL for business needs.
SQL Server Performance Tuning.
Utilized SQL-2000, SQL-2005, and SQL-2008 Servers.

Senior DBA

Confidential, Tampa, FL

Responsible for Data Services, including Database Administration, Informatics Data Mining, Reports Development, Data Analysis, and Database Integrations.
Integrated patients and clinical data from multiple clients. Created SQL scripts to do Data Mining for pre-sale data analysis.
Managed multiple SQL server running Dev/UAT/Prod environments.
Maintained and enhanced reports running on Microsoft Reporting Services (SSRS) and Crystal Reports.
Maintained and enhanced data cubes on Microsoft Analysis Services (SSAS).

DBA Consultant

Confidential, Jacksonville, FL

Enhanced ITAS (Information Technology Asset System) with intelligent pattern matching technology.

DBA Consultant

Confidential, Temple Terrace, FL

DBA

Confidential, Clearwater, FL

Maintained and supported multiple County Property Tax databases and Solomon Financial systems.
Designed and Implemented Tax Distribution Module to electronically disburse property tax revenues to different taxing authorities.