Consultant

• May 2019 - Present

Senior Analyst

• Apr 2016 - May 2019

Business Analyst

• Apr 2015 - Mar 2016

Billing Manager

• Jul 2013 - Mar 2015

•Monitor CDR reports for rating exceptions/errors by carrier, customer, type, etc. using P/L SQL (Search and Query Language) Developer to retrieve the data. Present data using Excel. Work with other team members to fix errors. •Analyze, prepare and rate call details from prospective and current customers using various programs, including SQL, Foxpro, Access and Excel in order to produce proposals and standard rate structures. •Provide post-billing reports to the Finance department and end of month (EOM) reports to the Sales department. •Perform vendor billing analysis using SQL, Excel, etc. to determine if the company is being billed correctly. File disputes as appropriate. •Review CDR reports provided by Billing Supervisor and respond accordingly, particularly if issues need to be escalated for resolution •Retrieve call detail records (CDR) from prospective and current customers via websites, email, CD ROM and file transfer protocol (FTP) •Provide and create new reports for other departments •Communicate with staff via email regarding billing schedule, bill run updates, billing issues, and potential fixes Show less

System Analyst

• Jan 2011 - Dec 2012

•Defined and constructed new products and related supporting documentation •Determined existing discounts to be offered, and new discounts for construction •Worked with Product Management to determine which existing Verizon Products would be retained and offered, and which new products need to be constructed. •Built products and supporting documentation related to the new products and discounts •Ensured that customer data converted accurately. •Conversion testing to ensure that converted customers billed correctly in the conversion environments •Analyzed data via data dumps under strict project deadlines •In charge of the IFVPO mapping document to ensure all customers converted with proper discounts •Revenue Recovery of over $100,000 Show less

Billing Specialist

• Mar 2007 - Jan 2011

•Completion of bill verification, audit and reconciliation for over 60 bill cycles per month covered both the wireless and wire line industries •Coordination and execution of detailed rating, usage and trending analysis •Resolution of complex customer service billing issues, included usage monitoring, troubleshooting, and SQL database updates. •Provided customer support via a 1-800 call in number and participated in on call •Participated in 2 upgrades for customers to latest version of CostGuard Show less

Supervisor, Project Team - End User Billing

• Aug 2006 - Mar 2007

•Management, coordination and resource scheduling for three Tables/Project Analysts•Coordinate and oversee billing implementation of all new project deliveries to ensure completion within the given timeline•Tracking and reporting of monthly performance measurements for Analysts to senior management•Ensure project and product compliance with current industry audit controls (i.e.: tariffs, Sarbanes-Oxley)•Mentor Analysts and lead team building activities to motivate them to achieve consistent individual and corporate performance targets Show less

Senior Analyst, Project Team - End User Billing

• Jun 2005 - Aug 2006

•Completion of all assigned projects within defined timeframe•Application of complex problem solving techniques to complete tasks and maximize billed revenue•Achievement of over 99% of defined monthly measurements and goals•Completion of audits for task deliverables by Tables Analysts•Mentored Analysts to provide premier customer support

Senior Analyst, Bill Verification & Message Processing - End User Billing

• Oct 2003 - Jun 2005

•Coordination of activities for up to six Analysts•Revenue Assurance activities for all billing cycle processes to remain within defined audit controls•Root cause resolution and process streamlining for unbilled revenue issues, corrective billing for usage discrepancies•Customer request research and reconciliation of accounts•Revenue data analysis in support of revenue forecasting and budget activities

Billing Analyst, Bill Verification - End User Billing

• Jan 2002 - Oct 2003

•Completion of bill verification, audit and reconciliation for over 120 bill cycles per month•Coordination and execution of detailed rating, usage and trending analysis•Resolution of complex customer service billing issues