Relevant Technologies Utilized: T-SQL, SQL Server 2017/2019/2022/Azure SQL, Data Warehousing, SSIS, PowerShell, Azure Suite (Azure Administration, Azure DevOps, Azure Data Studio, Azure Databricks, Azure Virtual Machines), Databricks, Python, JIRA, Asana, Agile Development, Sisense, Bitbucket Transformed data architecture from disparate production only servers to consolidated development, UAT, and production SQL server environments. Implemented Bitbucket for source control and Azure DevOps for automated deployments of the databases. Built out the data warehouse that powers client facing analytics applications and is utilized by entire development organization. Built end to end integrations with various insurance agency management systems (AMS360, Epic, EZLynx, etc.) into said data warehouse which enables clients to have a unified analytics experience and executives to have consolidated dashboards. Built automated refresh mechanisms using stored procedures, SQL Agent and SSIS for orchestration. Other responsibilities include SQL performance optimizations (commonly 80% or better gains), Azure tasks (building Virtual Machines with SQL Server, DataBricks integration using Python and Azure SQL to data warehouse), some database administration tasks (security, server troubleshooting) and more.

Relevant Technologies Utilized: Data Warehousing, SSIS, SQL Server 2014 and 2016, T-SQL, Birst, Entity Framework, Powershell, Octopus, JIRA, Agile Development, Git, C#Data Warehouse and ETL developer utilizing SQL Server 2014 and 2016 and Visual Studio 2015 (T-SQL, SSIS). Built out the data warehouse and ETL processes for Paylocity's HR Insights dashboard product and more.

Relevant Technologies Utilized: Data Warehousing, SSIS, SSRS, SQL Server 2005/2008/2012, TSQL, AX, Excel (Power BI), Zap Business IntelligenceResponsibilities include: Senior Database Developer for the SQL BI Team; Database design for the Margin Management application; Performance tuning of existing stored procedures and processes; Development and deployment of business intelligence reports and metrics for senior management; SQL code review; SQL script, stored procedure and report development; Management and development of ETL processes for various business systems.

Relevant Technologies Utilized: Data Warehousing, SSIS, SSRS, SSAS, SQL Server 2008, TSQL, PL/SQL, ExcelResponsibilities included: Data Warehouse Developer for Granite's Data Warehouse team; Creating and updating SSIS packages to import various telecommunications data sources throughout all levels of the data warehouse; Refreshing, editing and partitioning SSAS cubes; Creating and updating SSRS reports based on both cube and database sources; Analyzing and fixing errors with the data warehouse loading process; Making performance improvements to the loading process utilizing both SSIS and SQL methods; Working with Business Analysts and internal customers to define new projects for the data warehouse.

Relevant Technologies Utilized: Data Warehousing, SSIS, SSRS, SQL Server 2000/2005/2008, TSQL, DTS, ExcelResponsibilities included: Lead Data Analyst of the Data Warehouse Team for the Reporting and Data Management department; The design, implementation, and maintenance of the reporting data warehouse and its automated ETL processes across SQL Server 2000, 2005 and 2008 environments; Coordinating with engineering teams to implement new customers into the reporting environment; Giving guidance to other Data Warehouse team members; Redesigning legacy reporting environments to run on a star schema dimensional model; Designing Reporting Services reports and managing the Reporting Services web portal; Utilizing SSIS for tasks such as handling Slowly Changing Dimensional data, data imports and exports to and from various sources, and report creation and delivery.

Relevant Technologies Utilized: SQL Server 2000, TSQL, DTS, PL/SQL Responsibilities included: Implementing disparate client data files into the web based Employee Recognition tool P3 via SQL Server 2000 DTS; Analyzing client data requirements; Designing the ETL processes to clean/format/import client data files using DTS. Building of the DTS packages; Participating in the client implementation process; Participating in client interactive program changes; Researching/correcting data issues found in the Oracle front end-loading of both recurring and maintenance files and quality checking the results.

Relevant Technologies Utilized: SQL Server 2000, TSQL, DTS, Crystal Reports, Access, and ExcelResponsibilities included: Complex data analysis to deliver on the reporting needs for the companies top clients where accuracy is critical; Analyzing business requirements to deliver program specifications for the development team and management; Supervisory tasks including ensuring job completion, leading the reporting team, and managing interns; Advanced SQL Server responsibilities including automation and optimization of tasks using Query Analyzer, stored procedures, and SQL Server Agent.

Relevant Technologies Utilized: AccessProvided desktop and network support over a 25 user local network and a 75 user wide area network in a small to medium size company environment; Desktop support; Troubleshooting and training of personnel; Network support; Connectivity design, troubleshooting, DNS support, and router support ; Implemented PC hardware upgrades and builds; Designed, installed, and updated Point Of Sale commissions database which handled approximately $7,000,000 per year in commissions; Wrote and implemented business proposals approved by management; Performed detailed sales data analysis; Provided mechanical design, general problem solving, and purchasing skills; Interviewed and assisted in the management of fellow interns