Data Analyst Columbus Oh
Resume:
Ashley Dawn Smith
**** ************ **. ********, ** 43235
***********@*****.***
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