Senior Manager, Business Intelligence
Current• Developing, maintaining, and managing all analytic and operational business reports based on the MS SQL Server Reporting Services (SSRS), Microsoft Power BI, Solver, and MS SQL Server Management Studio. • Constructing and maintaining data warehouses to support dynamic dashboard reports.• Performing complex ad-hoc SQL queries when access to data is required to support internal and external client needs.• Optimizing and tuning existing queries for efficiency and decreased database impact. • Customizing and presenting reports using MS Excel (charting, graphing, and pivot-tables).• Developing comprehensive forecasting and data modeling using data from diverse data sources including multiple SQL databases, Salesforce, Mitel, and imported data feeds.• Designing, testing, and deploying new and enhanced client-facing reports using SQL stored procedures, functions, cursors and views.