Jason Cunningham Email and Phone Number

Manage VoIP & Mobile Telephone Analytics - Coordination of existing report updates. Creation of new reporting.2022•VoIP Telephone Biller Accuracy Dashboard–Identification & reporting of biller accounts with service to biller gaps. Creation of Tableau Dashboard.•Service Provider Identifier (SPID) Mismatch Report–Report identified mismatch between billing accounts & SPID assignment. Identify accounts assigned to Charter not billed by Charter & accounts billed by Charter not assigned to Charter. >$5M monthly billing gap identified. > $10M liability identified. •Mobile Biller Reporting Enhancements-Recreate existing Reporting after migration from the Arterra Biller to Amdocs Biller. Included transition from daily csv files to Hadoop platform.-New Reports comparing Amdocs Biller & Verizon Network.•Active Mobile-HSD w/o Equipment–Identified potential legal risk of Mobile Customer paying for HSD Services while not having correct equipment to receive service.2023•Mobile Biller Reporting Enhancements-Python Program Redesign–Modified from single full inline script to modular script with individual report logic called from external SQL files. Allow for updates to report logic testing and implementation without modification to full script. New report introduction with individual lines of code.-Mobile and Core Cable Reporting–Development of Core Cable Biller (CSG) and Mobile Biller (Amdocs) converged reporting: Customers no longer eligible to receive Mobile Service discounts due to Core Services disconnect; Customers receiving Mobile Service promotions after loss of eligibility.•Mobile Validation Hub (MVH)–Migration of Amdocs MoneyMap (MMAP) to in-house reporting. Live on 1/8/2024. >$5 Mil annual cost savings.-Team worked with IT for deployment of DEV, UAT & PROD Oracle Servers. Developed Engine for processing normalized tables from Amdocs Billing System (CES). Developed individual reports matching MMAP Inspections. Worked with IT for User Interface Development.

Respond to Intake Requests sent to Analytics team. Work as intermediary between Project Management, Business Intelligence and Billing Assurance to obtain required data sourcing and build and produce reporting on a regular schedule.

Report Administration/Data Analysis• Oversee Transition from Excel Reporting to Access Reporting as record count increased from ~250,000 to >1,000,000. Normalize data structure to combine multiple data sources and reporting structures. Streamline and automate process flow to decrease report processing time and improve repeatability.• Respond to Ad Hoc Data Requests from Cable Modem Adherence team to provide requested information and analysis. Project Coordination• Transition Billing Code to updated format for 1.3 million accounts. Coordinate dataset and provide to IT for coordinated update. Code updated from generic date format to modified ISO 8601 date standard with informative characteristics.• Implement Weekly Recurring Notification process for multiple customer groups. Design database and reporting to create weekly reporting of at risk customer sets.

Report Administration• Maintain and process current reports. Identify opportunities for improvement and streamlining.• Create new reporting. Work with internal customers to determine data requirement needs.• Document reporting new and existing reporting.• Tools used are MS Access, MS Excel, MS Work and MS PowerPointData Analysis• Combine and refine information from multiple large dataset for analysis• Design repeatable reporting for improvements in efficiency and reduction in

Update Current Reports and Create Customized Report•Modify existing MS Excel Reports. Write custom Macros and formula to improve ease of use and automation.•Migrate MS Excel reporting to MS Access. New processes reduced manual input, decreased processing time for reporting and created trend reporting.•Create new reports in Microsoft Access and Excel. Work with end users to determine requirements and create Excel spreadsheet, Access database or combination as needed.•Migrate processes from static to live reporting •Spreadsheets and databases involved the creation of custom Macros, PivotTables and Charts, Data Validation and formulas including VLOOKUP, SUM, SUMIF, COUNT, COUNTIF, and INDEX(MATCH).•Create End User Documentation for use and creation of reportsData Analysis•Perform Detail and Root Cause Analysis of service issues and network utilization.•Analyze trends and identify outliers using data visualization graphs and charts.

Data Analyst • Analyze historical information to guide Package Delivery Center Teams planning of staffing and equipment levels.• Operations Research and Analysis to identify areas of opportunity for cost and time savings.• Detail Analysis of service trends to identify areas of operational improvement. • Develop and maintained reporting tools for multiple departments: Industrial Engineering; Package Center Operations; Hub Transportation Operations. • Corporate report developed based from district level reports.• SharePoint Site Owner for Central Plains District Industrial Engineering Department.Report Development• Created and developed reports and software utilizing Microsoft Access and Excel that were used by Management, Internal and External Customers. • Reports distributed via email or on custom SharePoint sites. Examples include: • Summary and detail reports for management teams on production levels and error management; End User tools to identify and correct errors on the day they occur; Detail reports for External Customer Assurance. • Modified existing reporting and tools to account for upgrades to Corporate Databases, system changes and changes in reporting elements.Multiple reports and tools incorporated into use across the country. Project Management• Coordinate deployment of multiple phases of new technology across multiple sites. • Responsibilities included scheduling and supervising the hardware and software installation of new software technology and training on the use of the new technology. • Deployments included new desktop equipment, servers, wireless network infrastructure and wireless scanning equipment. • Coordinate weekly, rostered conference calls for the purpose of reeducation on best practices and training on new features from software upgrades.

• Project Management of new technology implementation. • Responsible for hardware and software deployment of new desktop, server and network infrastructure across district. • Coordinated deployment at multiple sites. • Diagnosed and resolved technology issues for internal and external customers.• Trained end users on new and existing software.