Senior Database Developer Resume Tempe, AZ - Hire IT People

SUMMARY

SQL Server Developer with two decades of database experience in the IT industry.
ETL Developer skilled at creating new ETL tools and implementing efficient SSIS packages.
BI Analyst bringing the ability to understand customer needs and develop a reporting solution that will ensure their success.

TECHNICAL SKILLS

Development Methods & Tools: Agile Methodologies | Test Driven Development (TDD) | Object - Oriented Design & Development

TECHNICAL EXPERTISE: SQL Server T-SQL, SSIS, MDS, SSAS, SSRS, Power BI, Oracle PL/SQL, Crystal Reports, JIRA, TFS, Git, C#, ASP.NET MVC

PROFESSIONAL EXPERIENCE

Senior Database Developer

Confidential | Tempe, AZ

Responsibilities:

As the Senior SQL developer on the team, I oversaw the complex reports to be converted during the report conversion project from Crystal Reports to SSRS.
T-SQL Development for SQL Server, including Stored Procedures from scratch
Performed data migration with SQL scripts (Migration Scripts)
T-SQL Development for SQL Server
PL/SQL Development for Oracle
Was Lead Power BI developer for the team and was a consultant for other departments.
Became the consultant for SQL Development for other IT teams.
Was the JIRA administrator for our team.
Mentored the rest of the team members on SQL Server development, SSRS, and Power BI.

Principal Database Developer

Confidential

Responsibilities:

Lead developer during the rewrite of our laboratory mice tracking software while supporting two junior database developers.
Lead developer writing a web RESTful API for an internal electronic purchase ordering system using Angular.
Team Lead and project manager overseeing the work on a new clinical research billing software.
Was part of the company’s business intelligence initiative creating new reports in Power BI.
Created multiple T-SQL Stored Procedures and SQL Scripts for data migration, in addition to SSIS/ETL depending on the project
Secondary support for SharePoint 2010 and 2013.
Migrated entire SSRS report library from SQL Server 2008 to 2016.
Provided SSRS and Power BI training to BRI staff.
Helped architect new data warehouse using Microsoft MDS.
Created and maintained SSIS packages that imported data from different vendors and labs

Programmer/Analyst

Confidential | Redmond, WA

Responsibilities:

Using T-SQL I helped develop the process to import instrumentation data and write the scripts used for analysis for the post release of Kinect Sports.
Using C#, VB.NET, and T-SQL I developed a WinForms application tool to assist research engineers in developing game play test reports.
Using VB.NET and T-SQL I developed a WinForms application to eliminate the paper intake form for play test participants.
Created SSIS packages to automate the ETL of instrumentation data from various studios.

Programmer/Analyst

Confidential | Seattle, WA

Responsibilities:

Web based referral service to aid families in finding assisted living facilities.
Performed maintenance and troubleshooting on local area network
Performed desk top support and PC hardware maintenance for employees
Was the primary developer for SSRS reports and set the direction the company took with reporting
Created T-SQL stored procedures for SSRS reports and web site processes
Performed routine maintenance on SQL Server database by creating new tables, stored procedures, functions, and scheduled jobs
Created and maintained ASP web pages for primary web site

Programmer/Analyst

Confidential | Seattle, WA

Responsibilities:

Programmed T-SQL stored procedures and analyzed data on a SQL Server database for a national medical screening program.
Utilized DTS to migrate data from an AS/400 to a SQL Server database through ODBC.
Contributed to the installation and maintenance of SQL Server and SQL Server Reporting Services.
Programmed T-SQL stored procedures and designed reports using SQL Server Reporting Services.
Created and maintained Access databases utilizing Visual Basic for Applications.
Created and maintained COBOL programs on an AS/400 legacy system.
Created HIPAA standard files for EDI format 834.