William Rolison Email & Phone Number

Remote

MANAGER, BUSINESS INTELLIGENCE ENGINEERING• Administered Power BI Tenant and led the design of the Enterprise Reporting structure.• Managed a team of 5 onshore and offshore professionals (1 FTE & 4 contractors) through daily scrums.• Established and maintained Jira Board for effective work tracking and assignment.• Formulated best practices for developers, ensuring standardized processes.• Oversaw Power BI Capacity, workspaces, and security management.• Wrote and optimized SQL queries for enhanced performance.• Created and managed Snowflake views for streamlined data access.• Transitioned and decommissioned SSRS reports and report servers.• Developed and maintained AAS Tabular Models.• Provided expertise in Data Engineering and Data Modeling.• Stepped in to create Power BI solutions across business areas during resource constraints.• Mentored and fostered the skill development of team members.• Collaborated with the data team to optimize data design in Snowflake for BI platform utilization.• Implemented source control using GitHub.

Chattanooga, Tennessee, United States

• Administered Power BI Tenant and led the Commercial Power BI side for Accounting, Operations, Customer Experience, and Fleet.• Managed a team of 6 (4 FTEs & 2 contractors) with a focus on effective communication with VP’s, CFO, CIO, Directors, Managers, and workers.• Conducted meetings to gather requirements, make suggestions for reports, and ensure timely project delivery.• Established and maintained Jira Board, served as Scrum Master, and assigned story points for bi-weekly sprints.• Oversaw Power BI Capacity, workspaces, and security.• Wrote and optimized SQL queries, maintaining existing SSIS packages.• Transitioned and decommissioned SSRS reports and report servers.• Maintained SSAS Tabular Models.• Acted as an emergency off-hours support resource when needed.• Implemented and maintained source control using TFS.

• Led ETL/Data Warehouse architecture for five major business entities, ensuring optimal data flow and integration.• Conducted code reviews and provided guidance, demonstrating expertise in MS SQL Server 2005/2008/2012/2016 suite.• Executed ETL processes from diverse sources (Excel, CSV, SQL, Oracle, SharePoint, DB/2).• Managed SharePoint BI for Reports/PowerPivot solutions and developed Parameterized SSRS Reports.• Designed Dashboards, Scorecards, and reports using SSRS and PowerPivot.• Ensured Data Warehouse adherence to Ralph Kimball methods, managing database objects.• Participated in Microsoft SQL upgrades, offering 24/7 On Call Support for Data Warehouse loads.• Attended 2016 PASS SQL conference, gaining PowerBI insights.• Enforced coding standards using CMS and TFS for safe solution implementation.• Developed solutions with Cognos and SSIS/SSAS/SSRS in Visual Studio.• Created impactful PowerBI Dashboards for Senior Leadership.• Completed Azure Data Factory and Azure ML training.

Pittsburgh, Pennsylvania, United States

• Served as the primary BI Developer/Support for internal reports.• Contributed to the development of the Daily Sales Dashboard for 55,000 sales employees nationwide.• Created Multi-Dimensional Cubes for Business Objects.• Initiated award-winning sales incentive contests to boost employee morale.• Played a role in the launch of the original iPhone.• Compiled quarterly presentations for the VPGM to review region performance with the President AT&T.