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