Director Of Software Development/senior Lead Sql Azure Dba/senior Bi Developer Resume
5.00/5 (Submit Your Rating)
SUMMARY:
Computer professional with many years of adaptability demonstrated through increasingly responsible experience in management, development, and SQL Server. In - depth knowledge of contemporary software and hardware applications.
SKILLS:
- Visual Studio / C# / C++ / VB/ .NET / Knockout JS / LINQ / VB6 / Java / SAS
- Entity Framework / React
- SQL Server / Oracle / Microsoft Access
- T-SQL / SSRS / SSIS / SSAS
- Microsoft Office / PowerBI Embedded / PowerBI Desktop/BizTalk / SharePoint / Crystal Reports
- Idera SQL Diagnostic Manager / Quest LiteSpeed
EXPERIENCE:
Director of Software Development/Senior Lead SQL Azure DBA/Senior BI Developer
Confidential, Nashville, TN
Responsibilities:
- Integrated Power BI Embedded reporting into existing web app
- Designed and implemented the ability for customers to create, copy, view, and modify Power BI reports from with the existing web app
- Created fixed reports using PowerBI desktop
- Imported fixed reports into PowerBI embedded
- Designed and created Asset Taxonomy application in Microsoft Access 2016
- Back end database connection to SQL Azure 2016
- Maintaining and updating company web app
- C#/MVC/jQuery
- SQL Azure 2016 Administrator and Senior DBA duties
- ASP.Net/MVC/jQuery programmer
- Oversaw work of 3 software developers
Senior Lead DBA/Senior Developer
Confidential, Nashville, TN
Responsibilities:
- Designed and created SSIS packages which copied data from SQL and PostGres servers to CRM2015 environments using both SDK and KingswaySoft CRM endpoints
- Modified CRM entities and fields as required to support operations with SQL and PostGres servers
- Installed and configured SQL Server 2012 Enterprise edition servers in Azure IAAS and PAAS
- Installed and configured SQL Server Reporting Servers 2012 in an Azure IAAS environment
- Designed and created software in C# and SSIS 2012 to create documents in Sharepoint 2013 systems
- Designed and created software in SSIS to create CSV and fixed format files on request
- Developed extensive ETL processes using C# and SSIS 2012
- Developed and created software in SSIS to process HIPAA 834 EDI files into a SQL 2012 database
- Developed software in SSIS 2012 to process HIPAA EDI data and update records in CRM from that data
- Designed and created SSRS reports in Visual Studio 2012 which were posted to SSRS 2012 servers
- Developed fax applications using C# and Visual Basic 2012 and 2013
- Developed web services using C# 2012
Consultant - DBA
Confidential, Nashville, TN
Responsibilities:
- Returned to Confidential in same capacity
Director of Technology
Confidential, Nashville, TN
Responsibilities:
- Responsible for all organization technology and resources
- Installed, configured, and administered clustered Windows 2012 servers hosting both web applications and SQL servers
- Modified/maintained website/portal in Visual Studio/C#/HTML/Knockout JS/LINQ
- Modified/maintained organization web services
- Modified/maintained central production and test databases in SQL Server 2008 R2 Standard
- Responsible for development of IPhone/Android app
- Modified/maintained book generation processing in SSRS 2008
- Designed/wrote new administrative reports in SSRS 2008
- Configured/installed replacement web servers using IIS 7.0
- Designed and wrote Blitz software which was used to verify prospect and school data
- Wrote Blitz software in Visual Studio/Visual Basic 2008
Senior Technology Specialist/DBA Consultant
Confidential, Nashville, TN
Responsibilities:
- Started position with Confidential then converted to permanent employee.
- Designed, installed and configured SQL 2008/2008 R2/2012 servers on both Windows 2012 stand alone and clustered servers and VMWare
- Recommended SQL server licensing options, saving the company approximately $2 million
- Created and maintained BI cubes in SSAS 2005/2008
- HR Pension cube
- Exchange Reporting cube
- Call Log Reporting cube
- Performance monitoring and tuning using both Microsoft and Quest tools
- Created T-SQL scripts
- Created ETL packages in SSIS 2005/2008 reading inputs from CSV, flat file, and database sources
- Met with users and programmers to recommend changes for performance improvements
- Recommended modifications to STAR project resulting in processing times decreasing from 45 minutes to 25 seconds
DBA
Confidential, Nashville, TN
Responsibilities:
- Installed and configured Windows Server 2008 R2 clustering
- Installed and configured clustered SQL Server 2008 on Windows Server 2008 R2 servers
- Installed and administered SharePoint 2007 systems
- Designed and implemented Data Warehouse/Multidimensional databases using SQL Server