Detail oriented, highly analytical, result driven Staff Accountant who consistently exhibits sound judgment when scrutinizing complex financial documents and works quickly and accurately under tight deadlines.
Exelon Energy, IncMarch 2013 to CurrentStaff Accountant Houston, TX
Experience in Excel, Words, and PowerPoint Create custom invoice reporting template for large summary customers Specializes in complex reconciliation and disputes Fast learner and highly dependable Special projects - UAT Knowledgeable with utility's rules and regulations Subject matter in regional and bill types billing Coding marketers supply invoices to ledgers Tracking and Truing-up monthly transportation and storage gas charges Maintaining Daily Revenue and system balance report from Lodestar Financial Module Engine Recording gross margin and imbalance settlement for Columbia, AGL, BGE gas, ComEd, and New England markets Monitoring, researching, and resolving the daily variances from the revenue reports Reconciling and certifying A/R accounts, transportation true up, and Customer Deposit accounts into Backline Validate the accuracy and sign off the gross margin input for gas and electric markets Recording unbilled revenue and costs accrual Preparing month-end close in four business days Testing new accounting products and General Ledger mapping in Lodestar Perform Billing and Accounting projects for system corrections, market interfaces, and reporting Billing the third parties invoices for excess gas sold and transportations Manually billed the interruptible revenues for AGL customers into People Soft A/R platform Performing correcting, reversing, other journal entries Establish gas and electric market roll forwards to capture the current and cumulative balance differences that affect receivable accounts posted in Sub ledger and General Ledger Working with various teams to resolve accounting issues Running trial balance report and perform a tie out Recording journal entries for billed revenues, costs, escrow, and imbalances Documenting POR, Non POR, and Direct LDC nuances and process Prepare quarterly Georgia PSC financial statement Prepare quarterly Georgia Fixed and Variable Customers Counts as well as associated costs Training new employees on transition markets and reconciliation process Analyzing the revenue and cost trend and provide details explanation to upper management for unusual increase or decrease.
Constellation EnergyFebruary 2008 to February 2013Senior Analyst Houston, TX
Monitor and oversees the unbilled report for the summary bill team to ensure the age unbilled bucket is resolved timely and accurately Prepare and document job aids for billing Handle complex and escalated billing issues Assign the daily unbilled to the team Provide the weekly and monthly summary metric report to supervisor Participate in special projects as tester Resolve complex billing exceptions Release the summary bills on the due date Advise on compliance needs and industry best practice to the team Improve the CNE Consolidated process by suggesting the system enhancement for the 810 mass upload tools and implement standardize 810 processing for efficiency and effectiveness Create queries to accommodate customer custom reporting Perform regression testing to validate system or product upgrade Manage billing SharePoint Work with IT to test new billing code or existing billing tools to enhance billing functionality Provide feedbacks on RFP for potential deals Analyze trend on billing errors across regions and log AWR for permanent resolution Test cancel/re-bill and summary billing codes Visit other branches to establish a good relationship with various functional groups and training Reconcile complex summary balances and clean up balance discrepancies between 810 charges and FME Manage major accounts and maintain good relationship with customers Supervise two summary billing team members and cross train new hires and existing employees Log activity to other functional group for billing error that require their involvement to resolve Handle one-offs billing for non-standard contracts and requirements.
ABM CorporationJuly 2006 to January 2008Billing Specialist Houston, TX
Approved work orders prior billing Processed fixed, square footage, cost plus, recurring, and consolidated invoices Entered, generated, and submitted invoices electronically through Citrix Reviewed and validated A/P invoices coding for rebill Account management for customers Run monthly A/R age report and trained new hires Reviewed and updated changes of the master contract into billing system Handled the customer disputes and inquiries Reconciled sales at the end of the month Assisted controller with month end closing Performed an internal billing audits to out of state branches Lead on the clean up on A/P aging and worked with vendors to schedule payments arrangement.
Jindal Saw Limited, IncMay 2004 to July 2006Accounts Receivable/Accounts Payable Specialist Baytown, TX
Matched, batched, coded billing data into Great Plains Generated the invoices, posted, and reconciled batches Allocated the freight costs for rail, trucks, and barges to the corresponding invoices Kept records on freight costs and revenues Provided weekly freights and sales reports to controllers Managed bank deposits and bank reconciliation Maintained, applied, and posted cash receipts Researched and resolved A/R and A/P issues with vendors and customers Entered and paid vendors invoices Copied, filed, faxed or mailed invoices and various documents Run A/R and A/P aged report Performed weekly collection called and vendors' payments Prepared and submitted yearly sales tax Maintained and managed vendors and customers' accounts Recorded journal entries Assisted controllers with month-end.
University of Phoenix2011Bachelor of Science: AccountingPhoenix, AZAccounting
Houston Community College2009Associate of Science: Business AdministrationHouston, TXBusiness Administration
Lee College2005Associate of Applied Science: Accounting and Office TechnologyBaytown, TXAccounting and Office Technology Working on CPA license
University of HoustonCurrentHouston, TXAccomplishments
Received the "Billing Conexus Award" in 2012 for being the subject matter expert in billing during the Conexus projects.
Promoted to Senior Analyst as the team lead to manage the summary bill team and provided cross training to new and existing employees.
*Received WOW awards for exceptional performances in providing red carpet customer services
Account management, Accounting, accrual, Analyst, A/P, trial balance, balance, bank reconciliation, Billing, billing system, cash receipts, CNE, Citrix, contracts, controller, CPA, customer services, dependable, Financial, functional, General Ledger, Great Plains, Hyperion, team lead, ledger, market, Access, Excel, PowerPoint, SharePoint, month end closing, People Soft, problem solving skills, Coding, Fast learner, Reconciling, Recording, reporting, researching, RFP, sales, sales reports, Siebel, supervisor, tax, transportation, trend, upgrade