• Analyzed, designed and built data solution using Azure PaaS services to support data analysis and visualizations. • Architected and developed an ELT process for multiple file types and data sources for database ingestion from on-prem custom code to Azure using Azure Data factory, Automation Accounts, PowerShell and Azure Data Lake v2.• Implemented SQL Database projects for existing databases.• Created API layer for data retrieval using Node.js, Azure functions and Azure API Management.• Data orchestration using metadata driven processes using Azure Data Factory. • Created DevOps pipelines for deploying Azure Data Factory ARM templates and database objects to all environments.• Developed ADF pipelines in Synapse server utilizing SQL Pools.• Created and maintained documentation for all data team processes ensuring knowledge transfer and future reference. • Coach junior members of the team.• Developed and maintained complex SQL queries, stored procedures, and views to support business operations and reporting.

• Created metadata driven ELT pipelines with external services via ODBC, SFTP, REST APIs using PowerShell and SSIS.• Mentor other developers and analysts on best practices.• Work with multiple scrum teams to deliver quality data solutions.• Collaborate with executives to analysts to deliver reporting via SSRS and Tableau.• Spearheaded efforts to create data marts for multiple departments for analysis and reporting needs.

• Architect and implement data marts from CRM, OLTP and Financial datasets utilizing Azure Storage, Azure Data Factory, Polybase and Azure Data Warehouse • Work with executive leadership to develop meaningful and accurate reporting utilizing SSRS and Power BI• Support OLTP environments consisting of SQL Server 2005-2016, MySQL, MongoDB and Azure SQL• Create and implement a plan to consolidate cloud environments from Google Cloud and AWS to Azure• Mentor junior database developers and data analysts

• Architectural assessment of client environment and made stabilization recommendations• Conducted POCs on AWS and Azure to evaluate stability options for 1+TB MySQL database• Created plan on moving database from on premises environment to AWS Aurora• Created archiving solution to move 14+ years worth of data out of production database • Implemented internal reporting using Tableau, SSRS 2017• Reviewed and created DDL/DML statements for application developers• Assigned and reviewed work to DBAs• Worked with executive staff on reporting needs for the client’s sister companies.

• Conduct POC with various Azure products in preview and GA• Create a complete environment in the cloud consisting of Azure SQL DW, a VM with Server 2016, Azure SQL Database and SQL Server Enterprise 2016 with SSIS/SSAS/SSRS• Created a Data Pipeline from our OLTP databases and the different clients to transport the data to our central repository created in Azure SQL Database• Implemented encryption at rest and in transport• Work with company analysts and individual business units to determine data and reporting needs. Environment: SQL Server 2016, Azure SQL Database, Azure SQL Data Warehouse, Visual Studio 2015, SSDT, SSIS 2016, SSRS 2016(including mobile), Power BI, Tableau, Azure Storage, Streaming Analytics, Data Factory, Polybase, Azure Transparent Data Encryption, Azure Data Masking, SSAS Tabular, Azure Analysis Services

• Worked within Community Banking to develop reporting on high profile projects• Created, updated and optimized stored procedures, functions and T-SQL queries for reporting• Migrated custom .NET reporting to SSRS integrated with SharePoint 2013• Responsible for creating, testing and deploying SSRS Reports to all environments• Worked with business owners to develop and improve reporting• Conducted POCs on Performance Point, Power BI and Tableau Environment: SQL Server 2012-2016, SharePoint 2013, Performance Point, Power BI, SSRS 2014-2016, SSIS, BIML, Tableau, Excel Services, SSAS Tabular, Power BI

• Created, updated and optimized stored procedures and functions • Worked on migrating SSRS reports from T-SQL to MDX• Responsible for creating, testing and deploying all database deployments scripts• Worked with application developers to create and optimize database objects• Monitored databases for long running processes and optimize accordingly Environment: SQL Server 2012-2014, SSRS 2012, Redgate, SQL Sentry, SSAS Multidimensional

• Created, updated and optimized stored procedures and functions • Worked with QA to ensure code was released defect free to the production environment • Created and Maintained ETL jobs in SSIS from SQL Server and Oracle Databases• Created ad hoc reports for business units as required• Automated recurring reports from SQL Server and Oracle Databases• Upgraded SSRS and SSIS projects from SQL Server 2005 - SQL Server 2008 R2 • Worked with various departments and Project Managers to define and document reporting requirementsEnvironment: SQL Server 2000-2008 r2, SSRS 2005-2008 r2, SSIS 2005-2008r2, Oracle 10g

• Updated and Created Databases, Views, Stored Procedures, Functions • Designed and developed ETL solutions using SSIS • Utilized SQL Server profiler and Database Engine Tuning Advisor for query optimization• Created ad hoc reports for business units and automate recurring reports using SSRS• Scrubbed incoming datasets for use with internal systems• Scrubbed databases to correct duplicated and orphaned dataEnvironment: SQL Server 2005, SSIS 2005, SSRS 2005, Sybase, Visual Studio BIDS, TortoiseSVN

• Corrected/Updated/Deleted inaccurate or corrupt data records• Wrote SQL queries for maintenance of relational databases• Created and Maintained ETL and DB Maintenance jobs in SSIS • Created ad hoc reports and automate recurring reports• Administered MS SQL server with versions in 2000, 2005 and 2008• Updated and Created SQL Views and Stored Procedures Environment: SQL Server 2000-2005, SSRS 2005, SSIS 2005, Visual Studio BIDS, TortoiseSVN