We provide IT Staff Augmentation Services!

Etl Developer Resume

Seattle, WashingtoN

SUMMARY:

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.

TECHNICAL SKILLS:

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

PROFESSIONAL EXPERIENCE:

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

Developer

  • 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