Business Analyst Intelligence
Resume:
DONALD STONEMAN
Business Analyst
Overland Park, KS
www.linkedin.com/in/kevin-stoneman
********@*****.***
Business intelligence professional with 20+ years of experience in financial and operational analysis at T-Mobile and SelectQuote. Spearheaded initiatives that recovered $2M+ in revenue and generated $800K in savings. Advanced from Reporting Analyst to Business Analyst in 16 years at T-Mobile, demonstrating consistent career growth and expertise in data-driven decision-making. PROFESSIONAL EXPERIENCE
SELECTQUOTE INSURANCE SERVICES, Overland Park, KS
Revenue Operations Analyst 2024 – 2024
• Drove improvements to data mapping and transformation logic, fixing data inconsistencies across systems, enhancing data quality scores from 40% to 60%, boosting trust.
• Performed root cause analysis on underpayment trends from 3+ insurance carriers affecting financial reporting, recovering $2M+ in revenue.
• Piloted a real-time data monitoring system, flagging errors with insurance carrier data feeds, resolving 30+ commission reporting inaccuracies within the first month, independent of team efforts.
• Developed Excel and Power BI dashboard reporting that helped the finance department, accounting department and Senior leadership in making business decisions.
• Accounting knowledge and experience helped resolve 5% of issues impacting the recognition process. T-MOBILE, Overland Park, KS 2020 – 2023
Business Analyst
• Engineered database solutions and data visualizations in Excel, Power BI and Tableau of staffing and call metric reporting, resulting in a 20% increase in data-driven decision-making capabilities.
• Championed a cost optimization initiative by identifying process inefficiencies, delivering $1M+ in savings.
• Steered cross-functional teams and external vendors toward optimal resource allocation, generating $800K in savings on a high- priority, six-month project, according to financial reports.
• Partnered with contact center analysts and reporting teams to streamline and develop key performance indicators (KPI) metric reporting processes resulting in 20% efficiency improvement.
• Merged three data sources into a single SQL database using stored procedures and SSRS packages, reducing the manual load time by 30%.
T-MOBILE, Overland Park, KS
Forecasting Analyst 2014 – 2020
• Developed and delivered weekly and monthly board-level reports on key performance indicators (KPIs) for 40 vendor call centers supporting 8,000 customer care specialists, directly impacting staffing decisions and revenue projections.
• Enhanced existing Excel and SAS forecasting models using historical call volume, handle time, and seasonality data; improved staffing accuracy by 10% across 40 contact centers supporting 8,000 specialists.
• Revamped bi-weekly demand forecasting and quarterly capacity planning models to pinpoint full-time equivalent staffing needs, aligning resources with call volume projections and enhancing operational efficiency by 15%.
• Simplified complex datasets, identify critical trends, and implement robust solutions to support business objectives. T-MOBILE, Overland Park, KS
Reporting Analyst 2004 – 2014
• Streamlined reporting processes by designing interactive Excel dashboards with pivot tables and data modeling techniques, consolidating redundant reports; accelerated data delivery to senior leaders by 60% and facilitated strategic decisions.
• Engineered a staffing and training model, incorporating agent attrition rates and available full-time equivalents to optimize resource allocation, boosting the resource planning team's metric attainment by 15%.
• Catalyzed process improvement initiatives by analyzing key performance indicators and implementing changes that boosted team productivity by 12%, while decreasing error rates by 8%.
• Tracked, monitored, and reported monthly actual to budget variance using scorecards to approve call center vendor invoices improving variance reporting by 10%.
• Created a new reporting framework using MS Excel features (graphs, pivot tables) for diverse business units; this initiative eliminated 35 person-hours of manual intervention each month and facilitated quicker data-driven decisions. EDUCATION
Bachelor of Science (BS) in Business Administration with Emphasis on Data Analytics, Colorado Technical University, Colorado (online), 2021 - 2023 Associate of Science (AS) in Accounting,
Johnson County Community College, Overland Park, KS, 2019 - 2021 TECHNICAL SKILLS
Data Mining, Macros, Microsoft Excel functions & macros, Power BI, Power Pivot, Power Query, SQL, Tableau, VBA, Python, Pivot Table, KPI Reporting, Revenue Recognition, Metric Reporting, Contact Center Staffing, Ad Hoc Analysis, AWS QuickSight, Agile, Project Management, CRM Systems: Salesforce
Contact this candidate