We provide IT Staff Augmentation Services!

Etl Developer Resume

Seattle, WashingtoN


Logical, motivated analyst seeks next great challenge. Combining proven experience in data analysis, business intelligence, SQL reporting and Powershell scripting, detail - oriented professional will leverage considerable business acumen with excellent communications skills to deliver great results on time and under budget. Skilled in analyzing problems, designing and implementing solutions.


Primary Language Skills: T-SQL

Secondary Language Skills: C#, Powershell, Python

Database Platforms: Microsoft SQL Server, IDBM DB2

Reporting Tools: SQL Server Reporting Services, Qlikview, Crystal Reports, PowerBI, Business Objects

ETL Tools: SQL Server Integration Services

Operating Systems: Windows 7, Windows 8, Windows 10, Ubuntu Linux, Server 2008 & 2012

Applications: Excel, Word, SalesForce

Other Technologies: SQL Server 2005, 2008 & 2012 Management Studio, Business Intelligence Development Studio, Visual Studio, Team Foundation Server, Active Directory


Confidential, Seattle, Washington

ETL Developer

  • Build SSIS packages to create and maintain data flows to and from external sources
  • Ensure that all ETL processes meet state healthcare regulations and compliance
  • Lead developer on project to upgrade all SSIS packages and corresponding code from SQL Server 2008 to SQL Server 2016
  • Perform on-call duties to respond to failed data processes

Confidential, Mountlake Terrace, Washington


  • Agile team development on a variety of varied projects (providers, claims, medicare)
  • Updated and improvde stored procedures to comply with new claims business rules
  • Wrote new extensions in C# for Facets claims application

Confidential, Seattle, Washington

ETL Developer

  • Planned and advised best methods for retrieving data from various data sources
  • Created procedures and SSIS packages to ingest data into the data warehouse
  • Wrote T-SQL scripts for data testing to ensure data quality
  • Updated ETL procedures and troubleshot existing processes

Confidential, Seattle, Washington

SSRS Report Developer

  • Designed and developed SSRS dashboards for analysis of ad support ticket data
  • Queried ad supported database for fulfillment of ad hoc requests
  • Consolidated and combined existing SSRS reports into a singular dashboard
  • Troubleshoot existing reports

Confidential, Seattle, Washington

SQL Report Developer

  • Developed stored procedures for use with metadata analysis on database objects for Confidential.
  • Created stored procedures and datasets for use in SSRS dashboards
  • Created subroutines using VBA to automate Excel dashboards

Confidential, Bellevue, Washington

Systems Analyst/ETL Developer

  • Oversaw operation of existing database processes for consumption of national retail sales commissions into SQL Server
  • Analyzed current system and database processes and make recommendations for improvement/efficiency
  • Wrote custom tasks using C# within SSIS to enhance processing of both Excel and flat-files into SQL Server
  • Validated commission data and troubleshoot errors in data processing and apply appropriate fixes in a very time-sensitive environment

Confidential, Bellevue, Washington

SQL Reporting Analyst

  • Planned design and development of reports in SQL Server Reporting Services for SEM data
  • Constructed dashboards in Qlikview with complex stored procedures and views using T-SQL
  • Installed and maintained Qlikview Server including troubleshooting technical issues and user access
  • Queried Confidential data from both DB2 and SQL Server platforms for ad hoc analysis and reporting
  • Constructed ETL processes to move data from both flat files and DB2 into SQL Server data warehouses for reporting and analysis

Confidential, Seattle, Washington

Online Data Analyst/SSRS Developer

  • Consulted with Disney Online and ABC.com business units to analyze key business metrics and reporting requirements
  • Performed analysis of business data for discovery and patterns before report construction to advise business units
  • Developed complex T-SQL queries and stored procedures for use in SSRS and Excel-driven reports
  • Designed and built SSIS packages for daily data updates and export to text files.
  • Created large and complex SSRS reports including tablix and chart objects utilizing multiple parameters and custom-built functions

Confidential, Seattle, Washington

Business Data Analyst/SSRS Developer

  • Initiated and conducted meetings with various business segments to gather data and reporting requirements
  • Designed and built charts and tables/matrix reports using SQL Business Intelligence Development Studio and Dundas Charts for Reporting Services
  • Constructed complex stored procedures using T-SQL for use as backend datasets in SSRS charts and reports
  • Constructed relational database using T-SQL DDL language to hold Microsoft Partner data

Confidential, Redmond, Washington

Data Analyst

  • Wrote batch scripts and cursors using T-SQL to update, insert and delete data from Microsoft SQL Server databases
  • Used Visual Studio 2005 tools to analyze and debug scripts written in ASP and VBScript
  • Performed deep data analysis by constructing ad hoc queries using T-SQL for export into Excel reports used by Xbox Account Management Team
  • Tracked and documented previously unknown processes and business rules for support team

Hire Now