Maggie Mckee Email & Phone Number

Atlanta, Ga, Us

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.• Provided financial analysis for 15+ Fiber deployment/upgrade projects across Central division.• Participated in month-end and year-end processes by uploading the forecast to Essbase and reviewing forecast/budget variances.

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