Financial Analyst
Greater Philadelphia Area
• Building of data models and analyses to support decision making processes for PGW.• Designed, streamlined, and implemented individual programs to improve credit and collections efficiency thus reducing PGW’s receivables (after reviewing and analyzing PGW’s current Collection Renewal Plan, policies and procedures, and collection systems).• Gathered and analyzed financial metrics, operational data, customer call data, performance data, and collection metrics.• Use of the Balanced Scorecard and Program Scorecard to track metrics (financial, operational, customer, employee). Conducted trend analysis and compared performance to other utilities using data from the Scorecards.• Use of financial measures such as: "Cost per Field Dollar Collected, Payroll Cost per Field Dollar Collected, Variance of Budgeted Dollar to Actual Dollar Spent" to monitor financial performance.• Gathered and analyzed data on PGW’s various Payment Arrangement Systems and Customer Responsibility Programs (CRP) and recommended various methods for improving collections from customers.• Use of the “Collections Efficiency Index” to compare cash receipts to bills for various time intervals. • Conducted “Pilot” by segmenting customers into two groups and tracking each group’s “Accounts Receivable data, deposits applied to account, the number of turn-offs issued” before and after the Pilot (the duration of the Pilot was 4 billing cycles). This assisted in identifying customers who should be focused on for collections and highlighting those strategies that are effective in motivating customers to pay their bills.. Designed data model to compute various bills. The data model proved effective and this process of computing monthly bills was implemented. Computing the various bills involved a complex procedure of deducting billing data from a specific month that related to another billing period and adding billing data to a specific month that occurred in another billing period.