Markia I. Banks
*** **** ******, ** **** Rocks, PA 15136
Cell: 412-***-****, Alternate Cell: 410-***-****
E-mail: ***********@***.***, Alternate e-mail: ******.*****@*****.***
EMPLOYMENT HISTORY:
Electric Generation Supplier & Billing Analyst 5/2008-Present
Employer: Duquesne Light Company
411 Seventh Avenue, Pittsburgh, PA 15219
Salary: $56,009, 40 hours/week
Supervisor: Jane Cuff, 412-***-****, may be contacted
Oversee all Electric Generation Supplier (EGS) inquiries accurately and in a timely, consistent, fair and unbiased manner. Coordinates bills and collect all interval (hourly) data requests as per tariff requirements and corporate policy. Assist in the daily and monthly reconciliation and journal entry preparation, billing, and reporting of supplier imbalance billings. Prepare and reconcile the yearly Supplier Gross Receipt Tax report for management. Maintain supplier rates required for integrated rate ready billing. Participates in department improvement initiatives to identify, evaluate and implement new products and services. Participates in the Pennsylvania Public Utility Commission’s sub working groups to ensure DLCo is in compliance with current regulations. Coordinate supplier testing, contracts, and collateral requirements as defined in the electric generation tariff. Communicate with PA PUC investigators and DLCo’s internal PUC group in order to satisfy inquiries and complaints, and provide required information. Analyze system disturbances, makes decisions, complies with directives and initiates timely and appropriate real-time corrective actions in collaboration with the IT department. Resolve any billing calculation issues per the retail tariff. Reconcile all month end Purchase of Receivable (POR) transactions from the customer billing system to the corporate general ledger. Recon the POR administrative and provision for uncollectable expense. Review and report any unbilled customer accounts. Reconcile and prepare all month end revenue and kWh journal entries by revenue class, i.e. residential, commercial, and industrial. Reconcile and prepare marketing, EER surcharge, and Gross Receipt Tax (GRT) journal entries. Verify the totalized customer accounts correspond with the customer billing system, by verifying the usage, voltage, pending service orders, and time use.
Partnership Accountant 1/2005-4/2008
Employer: Atlas Energy Resources, LLC
1000 Commerce Drive, 4th Floor, Pittsburgh, PA 15275
Salary: $39,480, 40 hours/week
Supervisor: Karen Black, 412-***-****, may be contacted
Invoicing subsidiary companies for fees incurred for payroll, National Association of Securities Dealers fees (NASD) advertising expenses, and miscellaneous expenses for sales seminars and meeting expenses. Responsible for accounts payable including invoicing, voucher processing, and check generation. Reconciliation of balance sheet accounts and trial balance. Prepare monthly reports to management for analysis of the average well statistics. Ensure charges per well were charged properly and timely. Record revenue per well and ensure the funds flow to the investors less the expenses incurred. Monitored and mentored accounting clerks by training, reviewing, and approving voucher processing. Perform independent analysis and oversight functions of the monthly accounting reports for inclusion of appropriate data and format. When exceptions occur, formulate sound recommendations and provides professional technical assistance to decentralized accounting activities for systems improvements where necessary and for proper accounting treatment of financial transactions. Monthly general ledger reconciliation related to program items, sales seminars, occasional meals, and advertising. Assist the Vice President with payroll entries related to the wholesalers, ensure the taxes, dependent care, and 401K entries allocated properly. Responsibilities included journal entries and variance analysis. Assist co-works and management with projects as needed. Provide accounting support to senior management. Responsible for performing a variety of assignments related to budget, finance, accounting, and financial reporting to meet organizational goals and objectives. Prepare partnership budgets for senior management for approval.
Senior Accountant 2/2004-9/2004
Employer: SunGard Financial Networks
336 4th Avenue, Pittsburgh, PA 15222
Salary: $32,000, 40 hours/week
Worked closely with the accounting manager to offer improvements on accounting functions, and continuous analytical expertise for tracking purposes. Monthly preparation of financial statements for review with management. Reconcile, analyze and review general ledger accounts in preparation for month end close. Prepare documentation in support of external and internal audits. Perform ad hoc reporting and analysis and investigate issues providing explanations and interpretation. Assist with year-end audit preparation. Prepare 4 year budget plans. Record monthly accruals and adjusting entries.
Reconciliation & Control Accountant 9/2001-2/2004
Employer: Federated Investors, Inc
5800 Corporate Drive, Pittsburgh, PA 15237
Salary: $27,280, 35 hours/week
Supervisor: William Friday, 412-***-****, may be contacted
National Securities Clearing Corporation (NSCC) billing statement reconciliation on a daily basis averaging 50 million. Bank statement reconciliation ensuring accurate charges to broker dealers.
Integral team member for month-end closing. Responsibilities included journal entries, accounts receivable/payable, and variance analysis. Generate and reconcile daily settlement reports for various bank trust departments. Record payments received for the daily trading activity. Reconcile cash accounts and monitor daily cash flow maintaining the NSCC compliance performance requirements. Overseen and trained the settlement support clerk on various duties including wire submission and reconciliation of settlement reports. Analyze, interpret and implement financial management policies, directives, regulations, and guidance from a variety of sources. When exceptions occur, formulate sound recommendations and provides professional technical assistance to decentralized accounting activities for systems improvements where necessary and for proper accounting treatment of financial transactions.
EDUCATION:
Point Park University, August 2011-Present
Master of Business Administration Degree (Management Track)/Career GPA 3.66
Point Park University, April 2005
Bachelor of Science Degree, Business/Career GPA 3.00
Duff’s Business Institute, July 2002
Associates Degree, Accounting/Career GPA 3.45
CONTINUED EDUCATION SEMINARS:
Deloitte
Introduction to Accounting, Financial Reporting and Ratemaking for Regulated Utilities
Energy Seminars Inc.
Electricity 101
Institute for Management Studies (IMS)
Innovate Like Edison: How to Lead the Creative Process at Work
Fred Pryor Seminars
Making the Transition from Staff to Supervisor
Professional Communication
SkillPath Seminars
The Conference for Women
COMPUTER SKILLS:
Microsoft Excel, Word, Outlook, SharePoint, Internet, Oracle, Fundlinks, AS400, Peachtree, Master Piece
RELEVENT COURSES:
Corporate Finance, Quantitative Methods, Managerial Economics, Accounting for Managers, Business Finance, Financial Reporting and Control, Business Law I, Intermediate Accounting II, Intermediate Accounting I, Introductory Accounting I,
Introductory Accounting II