Ashley Smith
Upper Arlington,OH
Summary
Dynamic professional with extensive experience leading User Acceptance Testing (UAT) for innovative billing systems, including the successful implementation of the ICOMS billing system at Time Warner Cable. Demonstrated success in managing complex projects, exemplified by spearheading the Adelphia acquisition project, which seamlessly integrated commercial cable accounts. Expertise in optimizing billing processes for industrial energy customers at AEP includes close collaboration with engineers to enhance equipment accuracy and conducting UAT for AMI meter migration. Committed to developing comprehensive training resources, including a robust database for payment services employees and essential job aids that streamline operations at Spectrum.
Overview
20
20
years of professional experience
1
1
Certification
Work History
AML Product Analyst II
Huntington Bank
01.2025 - Current
- Document business objectives, requirements and features in an agile framework
- Prepare status update materials for key stakeholders including Product Owners and executives
- Write user acceptance test cases
- Perform research and analysis of customer, account and transaction information within AML systems including Actimize, Archer, Azure Dev Ops and ServiceNow
Clearance Coordinator
Nisource
01.2025 - 01.2025
- Execute clearance requests based on work requests from Nisource and upstream suppliers
- Prioritize work requests including maintenance, repair, construction
- Independantly evaluate and prioritize outages and emergencies
- Maintain clearance management databases for tracking and forecasting
- Work closely with Gas Control and field personnel to avoid potential dangers
- Gather intel and prepare reports to fulfill regulatory agencies (PUCO, FERC) and manage data requests
Associate Data Analyst
Spectrum
01.2022 - 01.2025
- Perform ad hoc queries in SQL to identify and correct customer billing issues
- Create and maintain an Access database for the training of department employees
- Utilize Microsoft Excel and SQL to generate reports and create dashboards in Tableau
- Create department flowcharts using Visio
Risk Mgmt Analyst Comm Op
American Electric Power
01.2021 - 01.2022
- Perform daily maintenance of risk positions and maintain risk database
- Analyze daily and weekly income statements to reconcile any differences in booked margins
- Perform ad hoc queries in SQL to determine customer usage and impacts to pricing
- Research market changes and coordinate with other departments including Pricing and Contract Management
- Execute SOX and business controls for volume tracking
- Audit contract data to ensure integrity and forecasting accuracy
- Utilize Microsoft Excel and Power Bi to generate reports to assess risk positions
Meter Data Analyst
American Electric Power
01.2016 - 01.2021
- Perform a variety of technical duties associated with the retrieval, processing, and validation, editing, and estimation of meter translation and load research data via MV90
- Work closely with Special Billing Group handling customers representing $2.8 Billion in revenue
- Perform UAT testing for new AMI metering and meter programs
- Assist with load research sampling activities and PJM demand response
Revenue Assurance Analyst (Contract)
Verizon Wireless
01.2015 - 01.2016
- Develop reports using Teradata SQL and PL/SQL to identify billing errors
- Perform JITR research and validation of delayed data charges
- Research and validate workflow fallout for revenue assurance
Data Analytics and Reporting Analyst
Time Warner Cable
01.2014 - 01.2015
- Develop and automate daily, weekly and monthly reports using SQL Server to monitor Customer Care group performance
Business Class Sales Support Specialist
Time Warner Cable
01.2012 - 01.2014
- Act as sales facilitator for team of 12 agents, aid with talking points and order entry
- Maintain business relationships with members of other departments to facilitate business
ICOMS Support Specialist
Time Warner Cable
01.2009 - 01.2012
- Develop reports for auditing: SOX audits, PCI compliance, campaigns and rate increases
- Work closely with Engineering to handle construction orders
Commercial Sales Clerk
Time Warner Cable
01.2006 - 01.2009
- Primary UAT representative for system tests of financials
- Project lead for conversion of Adelphia system commercial cable accounts to ICOMS
Education
B.A. - Business Administration
Franklin University
Columbus, OHA.A. - Business Management
Columbus State Community College
Columbus, OHSkills
- SQL query writing, programming and large dataset manipulation
- Data visualization using PowerBi and Tableau
- Variety of software: MV90, Excel, Access, PowerPoint, Tableau and ServiceNow with exposure to Python
- Project management, documentation and reporting following the Agile methodology
- Creating training documentation and leading training classes
- Experienced in UAT testing and system migrations
- Process enhancement
- KPI analysis
- Workflow Analysis
- Contract analysis
- Data research and validation
Certification
- Data Science with SQL and Tableau (2023) Guild Education at eCornell
- User Story Bootcamp: Be an Expert In Managing User Stories (2025) Udemy
Timeline
AML Product Analyst II
Huntington Bank
01.2025 - Current
Clearance Coordinator
Nisource
01.2025 - 01.2025
Associate Data Analyst
Spectrum
01.2022 - 01.2025
Risk Mgmt Analyst Comm Op
American Electric Power
01.2021 - 01.2022
Meter Data Analyst
American Electric Power
01.2016 - 01.2021
Revenue Assurance Analyst (Contract)
Verizon Wireless
01.2015 - 01.2016
Data Analytics and Reporting Analyst
Time Warner Cable
01.2014 - 01.2015
Business Class Sales Support Specialist
Time Warner Cable
01.2012 - 01.2014
ICOMS Support Specialist
Time Warner Cable
01.2009 - 01.2012
Commercial Sales Clerk
Time Warner Cable
01.2006 - 01.2009
B.A. - Business Administration
Franklin University
A.A. - Business Management
Columbus State Community College
Similar Profiles
Rakesh UrugondaRakesh Urugonda
Sr. ServiceNow Developer (IS Technical Specialist) at Huntington BankSr. ServiceNow Developer (IS Technical Specialist) at Huntington Bank
Kimberly MadisonKimberly Madison
Credit Services Recovery Specialist at Huntington BankCredit Services Recovery Specialist at Huntington Bank
Aliah Moreno-EsterAliah Moreno-Ester
Customer Experience Banker at Huntington BankCustomer Experience Banker at Huntington Bank
Nicholas CheckNicholas Check
FRB at Huntington BankFRB at Huntington Bank
JULIE JOHNSTONJULIE JOHNSTON
Business Operations Manager at OhioHealth Riverside Methodist HospitalBusiness Operations Manager at OhioHealth Riverside Methodist Hospital