Maggie Mckee Email & Phone Number

Philadelphia, PA, US

Philadelphia, PA, US

• Developed a dynamic model to modify the Retail commission plan nationally to align performance with business strategy that resulted in over $300K of annual expense savings
• Enhanced target setting tools, including forecast and compensation models, to improve estimation accuracy and provide decision making recommendations to Senior leadership
• Created Tableau dashboards utilizing SQL and Excel to give Senior leadership visibility into historical and in-month trended performance
• Delivered key insights of financial metrics, KPIs, and performance on multiple sales channels monthly to Senior leadership to facilitate strategic decision making and identify areas of improvement

Philadelphia, PA, US

• Built complex SQL queries to transform financial metrics into tools and assess risk for Revenue Assurance and cross-functional teams.
• Reduced Comcast’s GL Account reclass by $15K/month and identified six issues in Central division’s macros to improve automated processes and diminish manual maintenance.
• Managed two teams of Agents with sampling 50+ accounts for weekly and monthly reports to identify process improvements and provide leadership insight into unusual activity.
• Compiled monthly financial and operational data reports for Senior leadership to track key business operation metrics and measure revenue savings.

Philadelphia, PA, US

• Revenue Assurance
• Created Tableau dashboards utilizing SQL and Excel to provide database reporting and analysis for revenue savings across business operations while ensuring accuracy and timeliness of reports.
• Developed a performance metrics dashboard in Tableau from 200,000+ non-standardized order entries to provide strategic insight and guidance to leadership to increase employee productivity.
• Maintained three weekly reports providing proactive insight of issues in the Central division macros and credits by auditing 100+ accounts.
• Collaborated with Senior leadership and key Stakeholders to ensure processes align with the company goal through strategic planning and analysis of financial impacts.Capital Expenditures - Fiber
• Optimized 4 weekly project analysis reports by automating the update procedure with Excel lookups, index, and match to focus on in-depth analysis.

Philadelphia, PA, US

• Created an automated model for Health & Welfare cost and Payroll Tax as percentage of Base salary by state and call center site
• Compared and managed the Care Team's weekly attrition model against the monthly forecast to track pacing during a pandemic
• Improved forecast accuracy for Care Team's paid time off for 5000+ agents
• Analyzed when 300+ new hires were paid first to help improve the way the Care team forecasts new hires

Tampa, FL, US

• Reviewed and updated monthly P&L's for the Development team.
• Explained variances between actuals to forecast and budget.
• Created a monthly forecast from current to FY'21 for the Development team.
• Created a DOMO Dashboard for Development for 10 metrics for easier comprehension.
• Assisted the reorganization effort of the Development team to align to CTIO's vision.
• Collaborated with Development leaders, Talent, and Finance to ensure a smooth transition of reorganization.

Tampa, FL, US

• Revised over 1000 help guide pages for Prime Suite for better reader comprehension.
• Evaluated five different help guide softwares to see if they meet the company’s needs.
• Reviewed and revised a business plan to purchase a help guide software for the company.

Master Of Business Administration - Mba

Bachelor'S Degree, Management Information Systems, General