David Mcghee Email & Phone Number

Pittsburgh, Pa, Us

Pittsburgh, Pennsylvania, Us

• Curated a complex backlog for a team of 7 FTEs that spanned multiple corporate entities and functional areas• Directed an Agile team in biweekly sprint sessions, creating epics, features, and user stories to accommodate customer demand

Pittsburgh, Pennsylvania, Us

• Developed a diverse reporting portfolio in Tableau, Alteryx, and Power BI that utilized dozens of cloud-based and on-premise data sources• Cultivated a highly engaged team of 6-8 FTEs with employee engagement survey results at 94 percent or higher for four consecutive years• Guided team members on SQL query writing and tuning to optimize performance and minimize resource utilization• Provided both strategic direction for the team (75%) as well as hands-on technical problem solving (25%)• Utilized advanced calculation features in Tableau, Power BI (DAX expressions), and Alteryx• Led multiple reporting rationalization and consolidation initiatives to improve data source and dashboarding efficiency and performance• Produced enterprise-wide reporting and analytics products in the cybersecurity, healthcare operations, and process improvement divisions• Organized continuous improvement initiatives that saved thousands of hours in manual cycle time for customers

Pittsburgh, Pennsylvania, Us

• Managed a diverse portfolio of business analytics projects, covering the following operational areas: claims, enrollment, billing, client management and implementation, customer service, and commissions• Consulted with clients regularly on strategic initiative projects, guiding them to the best reporting and analytics delivery solution• Delivered dashboards and reports to internal and external clients using Tableau, IBM Cognos Analytics, and SAS Enterprise Guide

Pittsburgh, Pa, Us

• Led the deployment of a new operational data warehouse in MS SQL Server• Designed complex metadata models for operational and financial reporting• Utilized business analytics tools to identify data quality issues, contributing to master data management initiatives• Gathered requirements and developed dashboards and reports using Cognos and TIBCO Spotfire

Homestead, Pa, Us

• Managed a team that supported Cognos BI and Planning environments and created complex reports in Cognos Report Studio • Directed the calendar and fiscal year budgeting system process for all company divisions• Consolidated monthly financial reporting into scalable Cognos reporting solutions, reducing processing time by two days

Pittsburgh, Pa, Us

• Managed monthly closing for a $5 billion entity, coordinating results with five business units • Forecasted and analyzed revenue, free cash flow, net margin, EBITDA and other operational metrics

Waltham, Ma, Us

• Organized, presented, and implemented profit improvement initiatives that contributed to $18 million in revenue growth• Performed annual and quarterly financial forecasts for a $35 million revenue portfolio• Designed customizable reporting tools in Cognos and SQL to improve forecasting reports and product category reports

Pittsburgh, Pennsylvania, Us

• Developed reporting solutions for the entire organization, focusing on operational efficiency and process improvement• Reconciled and balanced all revenue cycle data for twenty-eight pediatric offices earning $50 million annually

Bs, Business Management

Mba, Finance