Professional History and Skills
May 2025 – Aug 2025
- Analyzed 500+ corporate-liable devices to identify underutilized plans, billing anomalies, and inactive lines, saving $14,400 annually.
- Built a Power BI framework connected to ServiceNow’s CMDB to track device age, warranty status, and refresh priority, replacing a fragmented Excel process.
- Automated 36-month hardware refresh cycle reporting within ServiceNow and Power BI, cutting manual reporting time by 40% and accelerating capital expenditure planning decisions for the IT Asset Management team.
Jun 2024 – Aug 2024
- Reduced cross-functional communication gaps on insurance claims denials by 30% through weekly alignment sessions with 5+ department managers.
- Conducted insurance workflow analysis across payers including Medicaid, Medicare, and commercial insurers to identify top denial codes (CO-4, CO-97, CO-16); implemented standardized intake and coding procedures that improved first-pass claim resolution rates and cross-team efficiency.
- Evaluated enterprise email security solutions (Barracuda, Mimecast, Proofpoint) using an Excel cost-benefit model and presented the findings to leadership, creating a vendor selection that reduced projected security spend and strengthened risk management.
- Identified process improvement opportunities in revenue cycle management regarding finance, scheduling, and reporting through an insurance workflow analysis to identify common claim denials, and then implemented standardized procedures increasing cross-team efficiency.
Jun 2019 – Oct 2021
- Managed telecom expense records for 2,000+ accounts, improving billing accuracy by 10% through Excel analysis and ERP reconciliation for clients in healthcare, government, and financial services.
- Resolved 10,000+ cost discrepancies by analyzing invoices and payments, then coordinating with carrier representatives at Lumen, AT&T, and Verizon to correct errors and recover overcharges.
- Eliminated 10+ hours of manual financial reporting work monthly by developing and implementing automated process improvements.
- Reduced customer response time by 20% by streamlining client communication processes through Zendesk in collaboration with senior management.
Capstone
Jan 2026 – May 2026
- Designed and delivered a proof-of-concept Power BI dashboard for a 240+ location organization, centralizing SharePoint engagement analytics to enable data-driven communications decisions for the organization.
- Constructed a daily API-based data pipeline from SharePoint into Power BI via Microsoft Fabric, capturing article-level metrics including lifetime views, likes, comments, author, keywords, and publication status across news articles.
- Delivered written and video training documentation and a future development roadmap to the Strategic Communications and IT teams; collaborated with IT to establish a shared Microsoft Fabric workspace at no net-new platform cost.