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.