Stacey Johnson
McDonough
Summary
Senior Analyst at Cox Communications specializing in financial analysis and data visualization. Delivered $30M in savings through process enhancements and strong stakeholder collaboration. Expertise in Microsoft Excel and cross-functional teamwork, providing actionable insights that support strategic decisions and operational efficiency.
Overview
26
26
years of professional experience
1
1
Certification
Work History
Senior Analyst
Cox Communications
Atlanta
02.2022 - 11.2024
- Designed and developed metrics, reports, and analyses to inform key business decisions for Outside Plant Planning and Operations.
- Interpreted enterprise data for the primary areas within Operations (Production, Recruiting, FTE, Material Governance, etc.).
- Prioritized tasks and communicated effectively.
- Supported internal customers in the areas of data analysis, data visualization, and both routine weekly, monthly, and ad hoc reporting.
- Designed new reports, validated existing reports, and created presentations to adequately represent data and recommendations to leadership.
- Examined existing reports to understand current operational performance and identified opportunities for operational improvement.
- Developed and managed a process utilizing SharePoint and Microsoft Excel to track internal Aged IOs with over 700 Planners to either update Need by Dates or Cancel the Aged IOs which resulted in $30M in savings for Outside Plant Planning and Operations.
- Conducted a weekly Aged IO call with over 700 Planners via Microsoft Teams to identify and discuss concerns that needed to be addressed immediately.
- Worked closely with Supply Chain Management colleagues regarding the Aged IOs, vendor management, and material governance.
- Tracked and analyzed FTE/staffing for Organic Growth and Market Expansion initiatives within Outside Plant Planning and Operations on an ongoing basis.
- Tracked and analyzed fleet assignments to various roles throughout the regions within Outside Plant Planning and Operations.
- Created and maintained a weekly report for fleet assignments and shortages.
- Developed presentations and led weekly Material Governance Review meeting.
- Created a comprehensive Material Governance Playbook for companywide use.
- Developed and maintained a weekly RAID Log to track key issues with material governance and supply chain management’s top parts at risk.
- Led a cross-functional team and developed a companywide BCP (Business Continuation Process) for all stakeholders to follow if a catastrophic event occurs (i.e., hurricane).
- Assembled and analyzed data for business reports, making sure data and calculations were accurate.
- Worked cross-functionally to track KPIs, created reports, and developed dashboards related to business initiatives.
- Collected supplemental information by engaging in dialogue with leadership and staff and observing processes.
- Delivered ad hoc analyses and reports at leadership's request.
Business and Data Analyst
Clayton County School District
Jonesboro
08.2018 - 02.2022
- Managed and coordinated district and regional data analysis activities to accomplish business objectives through information management.
- Supported internal customers in data management, data analysis, data visualization, and routine monthly and ad hoc reporting.
- Gathered various measures of business data and transformed it into meaningful insight for internal stakeholders.
- Supported business users, primarily internal, in support of their data analysis needs.
- Maintained reports and provided insights and analysis both on a regular and ad-hoc basis to support value-add decision making.
- Coordinated preparation of reporting and analysis, including hands-on month-end responsibilities.
- Worked with large datasets and told a story using the data.
- Built and/or supported the development of KPI dashboards.
- Adapted well to change in a fast-paced, dynamic workplace and worked well in cross-functional teams/projects.
- Communicated complex information in a clear and concise manner.
- Utilized Advanced Excel skills including Pivot tables and complex functions daily.
Manager of Operational Finance and Data Analytics
GoHealth Urgent Care
Atlanta
02.2016 - 07.2018
- Provided vision and support in developing Operational Finance reporting and analytics platform to support GoHealth’s mission, strategic goals, and objectives.
- Consulted with GoHealth’s leadership to understand the operational finance and data analytics needs of the organization, and collected, organized, managed, and reported on key information.
- Understood GoHealth’s operations to effectively utilize business intelligence and operational finance measures to assist and support field-level operators and company executives.
- Maintained an understanding of the systems and data sources to create new insights and contribute to effective knowledge management within GoHealth.
- Developed and deployed BIME Analytics executive and operational dashboards to support GoHealth’s initiatives.
- Utilized Hyperion Essbase for budget analysis, forecasting, and reporting.
- Updated, maintained, and optimized (i.e., performance, esthetics, format) existing dashboards based on feedback from users and deployed self-service analytics platform.
- Increased GoHealth’s team data visualization skill level through sharing expertise and tips.
- Performed variance analysis of actual vs. budget.
- Conducted ad hoc analyses and communicated insights through compelling storytelling.
Senior Financial Analyst
First Data
Atlanta
08.2015 - 01.2016
- Assisted with a variety of tasks supporting internal audits, compensation, and financial reporting.
- Worked with teams of employees from multiple disciplines to drive toward common revenue/expense goals.
- Worked with, understood, and analyzed large amounts of data with a demonstrated ability to efficiently retrieve data from large relational databases.
- Conducted and documented complex financial analysis projects.
- Prepared financial and business-related analysis and research in such areas as auditing, compensation, financial and expense performance, costing, budgeting, rate of return, depreciation, and working capital.
- Prepared forecasts and analyzed trends in sales, finance, general business conditions, and other related areas.
- Developed and recommended business policies and conducted special financial and business-related studies.
- Developed accurate, timely, and comprehensive financial reports for facilitating management decisions.
- Presented recommendations to management.
- Provided training and guidance to lower-level Financial Analysts.
- Performed variance analysis vs. budget and conducted ad hoc reporting and analyses.
Senior Data Analyst
Atlanta Public Schools
Atlanta
09.2012 - 07.2015
- Gathered, analyzed, and transformed data from many different sources.
- Made a significant impact through the discovery, development, and implementation of analytics that answered important business questions related to the performance and operations of the school district.
- Collaborated with business partners to identify and deliver robust reporting and analytics capabilities to drive improved business performance.
- Managed the prioritization and development of applications and reports for business reporting and analysis purposes including ad hoc data analysis and special projects.
- Established relationships with business users and technical specialists, primarily internal, in support of their data analysis needs.
- Communicated with customers about technical issues in non-technical terms.
- Provided training and support of various data systems.
- Served as a district subject matter expert as it related to data analysis, visualization, application, and interpretation.
- Used Tableau to design and produce actionable data views to inform district strategic direction.
- Utilized advanced Excel skills to analyze large data sets and for modeling and forecasting (i.e., advanced formulas, financial and statistical functions, PowerPivot, VLOOKUP, What-If Analysis, Trend Lines, Data Validation, etc.).
- Built SQL queries against a relational database and used advanced Microsoft Access skills to query databases.
- Utilized Google Analytics to measure site traffic, look at our audience demographics and interests, track engagement with behavior reports, segment data, etc.
- Provided direct support and professional learning to Associate Superintendents, Executive Directors, and district leadership related to the application of data to inform improvement strategies and decisions.
- Planned, organized, coordinated, and managed work and resources within assigned areas of responsibility to meet division, department, and enterprise goals.
- Trained, coached, and counseled lower-level Data Strategists.
Data Analyst
Atlanta Public Schools
Atlanta
09.2010 - 08.2012
- Provided direct support and professional learning to district and school-based leadership related to the collection, management, analysis, interpretation, and application of data to inform improvement decisions and strategies.
- Analyzed, interpreted, and reported district and school-level data to inform strategy for school improvement.
- Pulled data from multiple warehouses for the regional and district-level data.
- Designed and developed relational databases for collecting data (i.e., performance, achievement, human capital).
- Conducted quantitative analysis of achievement data to project growth, identify trends and areas of concern.
- Utilized advanced Excel skills to analyze very large data sets for modeling and forecasting (i.e., advanced formulas, financial and statistical functions, PowerPivot, VLOOKUP, What-If Analysis, Trend Lines, Data Validation, etc.).
- Used Google Analytics to measure site traffic, look at our audience demographics and interests, track engagement with behavior reports, segment data, etc.
- Built SQL queries against a relational database and used advanced Microsoft Access skills to query databases.
- Created spreadsheets, charts, reports, actionable views, and presentations to inform district and school-level strategies (i.e., PivotCharts, Power View Reports, KPIs and Tableau dashboards, etc.).
Data and Mathematics Coach
Atlanta Public Schools and DeKalb County Schools
Atlanta
08.2002 - 08.2010
- Analyzed and reported various measures of data to evaluate overall school performance while identifying opportunities for improvement and growth.
- Analyzed, interpreted, and reported various measures of school-level data to inform improvement decisions.
- Designed and developed relational databases for collecting various measures of data.
- Conducted quantitative analysis of achievement data to project growth, identify trends and areas of concern.
- Utilized advanced Excel skills to analyze large data sets (i.e., advanced formulas, statistical functions, PivotTables, Excel dashboards, VLOOKUP, What-If analysis, trend lines, scenarios, data validation, etc.).
- Facilitated weekly data analysis meetings with the leadership team and staff.
- Created spreadsheets, charts, reports, actionable dashboards, and presentations to inform organizational decisions.
- Worked closely with school leadership to provide support and professional learning to school-based staff around data analysis, the data team process and the data systems utilized within the Atlanta Public School district.
- Performed ad hoc reporting and analysis.
Senior Financial Analyst
American Express
Miramar
02.1999 - 07.2002
- Supported business operations through analysis of key performance indicators and trends.
- Provided modeling and reporting to facilitate executive-level decision-making.
- Performed quantitative analysis, budgeting, and forecasting.
- Utilized Hyperion Essbase for budget analysis, currency conversion, forecasting, financial consolidations and reporting, customer, and product profitability analysis, etc.
- Conducted quantitative analysis of financial data to forecast revenue, identify future trends, and assess risk.
- Utilized advanced Excel skills for financial modeling, budgeting, and forecasting (i.e., Financial functions, PivotTables, VLOOKUP, What-If analysis, trend lines, scenarios, & data validation).
- Built detailed spreadsheets to identify trends, develop forecasts, and helped prepare the annual budget.
- Supported the creation of the annual and long-range strategic plans.
- Drove the implementation for Global Functional Reporting for the Latin America/Caribbean Region including developing a database in order to analyze and compare expense base, financials, volumes, and key reporting metrics.
- Modified and enhanced the Forecasting model to improve availability and accuracy of financial data.
- Coordinated the Month-End-Close process including the analysis of financial results against budget and forecast with detailed written explanations for variances.
- Developed comprehensive reports, presentations, and charts to present data and guide business strategies.
- Performed ad hoc reporting and analysis.
Education
Post Graduate Coursework - Leadership and Research
CAPELLA UNIVERSITY
Minneapolis, MN01.2012
M.Ed. - Educational Leadership w/a concentration in Mathematics
GEORGIA STATE UNIVERSITY
Atlanta, GA01.2007
BS - Mathematics (Actuarial Science) w/a concentration in Finance
FLORIDA A&M UNIVERSITY
Tallahassee, FL01.1999
Skills
- Financial Analysis
- Financial Modeling
- Forecasting
- Budgeting
- Budget Process
- Long-range strategic planning
- Data Analysis
- Data Visualization
- Business Intelligence
- Month End Close
- Variance Analysis
- Financial Metrics
- Financial Reporting
- Databases
- Project Management
- Presentation Development
- Training Facilitation
- Verbal & Written Communication
- Strategic Planning
- Organizational Leadership
- Cross-Functional Team Leadership
- Data analysis
- Data visualization
- Business intelligence
- Operational reporting
- KPI tracking
- Process improvement
- Microsoft Excel
- SQL querying
- Ad hoc reporting
- Effective communication
- Cross-functional collaboration
- Presentation development
- Stakeholder engagement
- Trend analysis
- Project management
- Performance monitoring
- Industry analysis
- Analytics software
- Stakeholder communication
- Financial forecasting
- Tech-Savvy
- Financial modeling
- Metric tracking
- Tableau software
- Budget planning
- Analytical thinking
- KPI analysis
- Data visualization tools
- Presentation building
- Microsoft office
- Data interpretation
- Verbal and written communication
- Complex Problem-solving
Certification
- BIME Analytics Dashboards, Zendesk, Atlanta, GA, 2016
- Tableau BI and Analytics, Tableau, Atlanta, GA, 2014
- Certified Data Analysis Trainer, The Leadership and Learning Center, 2013
- Leadership and Supervision Certification, GA Professional Standards Commission, 2016 - Present
- Business Certification, GA Professional Standards Commission, 2008 - Present
- Mathematics Certification, GA Professional Standards Commission, 2004 - Present
Personal Information
Citizenship: US Citizen
References
References available upon request.
Timeline
Senior Analyst
Cox Communications
02.2022 - 11.2024
Business and Data Analyst
Clayton County School District
08.2018 - 02.2022
Manager of Operational Finance and Data Analytics
GoHealth Urgent Care
02.2016 - 07.2018
Senior Financial Analyst
First Data
08.2015 - 01.2016
Senior Data Analyst
Atlanta Public Schools
09.2012 - 07.2015
Data Analyst
Atlanta Public Schools
09.2010 - 08.2012
Data and Mathematics Coach
Atlanta Public Schools and DeKalb County Schools
08.2002 - 08.2010
Senior Financial Analyst
American Express
02.1999 - 07.2002
Post Graduate Coursework - Leadership and Research
CAPELLA UNIVERSITY
M.Ed. - Educational Leadership w/a concentration in Mathematics
GEORGIA STATE UNIVERSITY
BS - Mathematics (Actuarial Science) w/a concentration in Finance
FLORIDA A&M UNIVERSITY
Similar Profiles
Molly HudlowMolly Hudlow
Senior Product Manager at Cox Communications, Cox MediaSenior Product Manager at Cox Communications, Cox Media
LaTricia FountainLaTricia Fountain
Auto Fleet Operation Specialist at Cox Communications, Cox AutomotiveAuto Fleet Operation Specialist at Cox Communications, Cox Automotive
Joel HenryJoel Henry
Independent Contractor at Cox Communications, DirecTV, Frontier CommunicationsIndependent Contractor at Cox Communications, DirecTV, Frontier Communications
Charles R. MorrisCharles R. Morris
Assistant Store Manager at Cox CommunicationsAssistant Store Manager at Cox Communications
Kelton DillardKelton Dillard
Class B CDL Septic Truck Driver at United RentalsClass B CDL Septic Truck Driver at United Rentals