Manage a team of reporting consultants who create and maintain reporting solutions for internal customers and partners. Partner with various business leaders on finding the most appropriate reporting solution based on their needs. Migrated SQL Server 2012 to SQL Server 2016. Created SSIS ETL processes to import data from various data sources. Created a powershell script that runs via SSIS to export flat files from a Smartsheet API. Set up and maintain 2016 Reporting Services environment. Created automated reports in SQL Server SSRS that are refreshed and sent via email to business users. Set up and maintain Power BI Report Server (on premises). Created automated dashboards in Power BI that are refreshed at various time intervals for business users

Created a datamart in SQL Server 2012 with ETL processes that run daily using Integration Services from various datasources such as Teradata and Oracle. Set up security model so only necessary users have access to data. Modify existing reports in MS Excel to point to new datamart as opposed to being run manually against data source. Partnered with various operation consultants to develop new reports and modify existing reports to include additional data points in MS Excel and Cognos. Developed new dashboards/visualizations using Tableau 10.1, Work with coordinators or operation consultants to test out modified processes that improve efficiency and data accuracy. Created an SSAS cube that stores over 5 years of transactional data for business users to analyze certain KPIs based on regional, director, or customer levels.

Create and/or modify ETL processes to load JDE and Salesforce data into an EDW using SSIS or stored procedures in SSMS. Work with business analysts to gather and understand business requirements for building or modifying processes. Develop, unit test, work with QA, and create deployment documents for DBAs as part of the SDLC. Work with team of developers and solution architect to analyze and come up with solutions for various operations enhancements, including query tuning, ETL performance improvement, creating or modifying indices, dependency model checks, data validation, error handling, and logging.

Identify Business Intelligence solutions for the Logistics group to provide more efficient and faster results of the business for various leadership teams. Currently working on migrating MS Access database to Microsoft SQL Server, which will completely automate ETL, report delivery, and notifications, as well as enhance data integrity, security, disaster recovery, and data availability

DBA for Business Intelligence team, specializing in Microsoft SQL Server. My team worked under the Midwest Finance umbrella but provided different reporting solutions for various regions across the country as well as various functions such as sales, marketing, finance, operations, and other BI teams. Managed and monitored a Data Warehouse-type of database structure, with hundreds of users and a team of developers.Managed security access on various levels and permissions.Developed processes that rebuilt indexes when fragmentation occurred.Created SQL Agent jobs that performed maintenance tasks, as well as ran SSSI/SSAS/SSRS tasks.Extensive SQL and query tuning experience working with Microsoft SQL Server, Oracle, and Teradata.Extensive knowledge and experience designing ETL solutions with Microsoft Visual Studio/SSIS/BIDSProficient knowledge designing Analysis Services/mutidimentional solutions with Microsoft SSAS

Reporting Analyst focusing on providing analysis to identify trends in KPIs and recommendations to different levels of leadership.Used Microsoft Office (MS Access, MS Excel, MS PowerPoint) to run reports, analyze data, and present analysis.