Ashley Dawn Smith

**** ************ **. ********, ** 43235

adremm@r.postjobfree.com

614-***-****

Skills:

Proficient in SQL Server 2008 R2, Teradata SQL and Oracle PL/SQL, SQLyog

Proficient in a variety of software: MS Word, Excel, Access, PowerPoint and PowerBi

Experience in project management; led conversion of commercial accounts during

company acquisition

Experience with creating training documentation and leading training classes

Experienced in UAT testing and system migrations

Extensive experience in customer service, leadership and problem resolution

Employment History:

American Electric Power

Risk Mgmt Analyst Comm Op, 2021 - Current

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

Test enhancements to Risk database

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

Coordinate the filing of Renewable Portfolio

Utilize Microsoft Excel, Power Bi and MySQL to generate reports

Create report in PowerBi to capture intraday contracts to provide better accuracy of risk positions during volatile market days

American Electric Power, Columbus OH

Meter Data Analyst, 2016-2021

Perform a variety of technical duties associated with the retrieval, processing, and validation, editing, and estimation of meter translation and load research data, interact with appropriate field and office personnel to resolve metering and telecommunications problems, review, investigate and resolve interval data and billing data discrepancies

Work closely with Special Billing Group handling customers representing $2.8 Billion in revenue

Perform validation checks for accuracy of data

Perform UAT testing for new AMI metering and meter programs

Generate accurate reports and graphs

Assist with load research sampling activities and PJM demand response

Verizon Wireless, Hilliard OH

Revenue Assurance Analyst (Consultant), 2015-2016

Develop reports using Teradata SQL and PL/SQL to identify billing errors

Create defect tickets with solutions and assign to proper departments

Modify existing reports to maintain data integrity

Assist with M2M monthly access retained project for financial tracking

Perform JITR research and validation of delayed data charges

Research billing alarms based on statistical models

Research and validate work flow fallout for revenue assurance

Time Warner Cable, Columbus OH

Data Analytics and Reporting Analyst, 2014-2015

Develop and automate daily, weekly and monthly reports using SQL Server 2008 R2 to monitor Customer Care group performance

Modify existing reports to accommodate new processes and procedures

Create report views in Visual Studio using groupings, drop downs and expressions

Create and maintain subscriptions in SSRS

Experience in creating temp tables and views

Create reports in Viewpoint

Time Warner Cable, Columbus OH

Business Class Sales Support Specialist, 2012-2014

Act as sales facilitator for team of 12 agents, provide assistance with talking points and order entry

Create training materials for new sales agents

Accurately process and quality check sales requests in Salesforce and Closetabs

Process sales request fallout, work with customers and use best judgment to offer solutions in keeping with company guidelines

Work closely with Sales Managers to handle complex orders and expedite requests

Maintain business relationships with members of other departments to facilitate

business

Time Warner Cable, Columbus OH

ICOMS Support Billing Specialist, 2009-2012

Develop reports for auditing: SOX audits, PCI compliance, campaigns and rate increases

Create training documentation for the ICOMS department and train new hires

Work closely with Engineering to handle construction orders

Work with Finance to process MOP and Lockbox payment batch tracking

Primary UAT representative for system tests of financials

Assist the department by supporting the division 24/7 while on call

Responsible for statement validation; ensure accuracy of all customer statements prior to mail out

Time Warner Cable, Columbus OH

Commercial Sales Clerk, 2006-2009

Project lead for conversion of Adelphia system commercial cable accounts to ICOMS

Handle all customer related requests including services, billing, installation, construction

Responsible for entering bulk and right of entry contract information and maintaining the

accuracy of the database

Submit provisioning requests for HSD internet service in Closetabs and Salesforce

Education:

Franklin University, Columbus OH

B.A. Business Administration, 2011-2014

Columbus State Community College, Columbus OH

A.A. Business Management, 2008-2010

3.5GPA, Dean’s List

Contact this candidate