Frank Quaile MBA
** ***** *****, *********, ** **374
910-***-**** ********@*****.***
http://www.linkedin.com/pub/frank-quaile-mba/16/b0/858/
PROFESSIONAL PROFILE
Motivated Finance Professional with expertise in Receivables Management, Revenue Application, and Billing System Administration. Strengths include superior analytical & thinking skills, problem-solving capability, and strong interpersonal and communication skills with attention to detail.
PROFESSIONAL EXPERIENCE
BLUE CROSS BLUE SHIELD NC, Durham, NC 06/2015 – 04/2017
Financial Analyst/Billing & Reconciliation Specialist (Contractor)
Analyzed emails, workflow and reports to determine remedial action for billing and enrollment
errors and other problem issues;
Performed corrective actions to individual billing accounts;
Acted as team specialist for Workflow Management;
Interacted with various departments to enable solutions;
Verified & authorized reinstatements and refunds;
Trained co-workers on proper procedures & compliance rules
SANDHILLS COMMUNITY COLLEGE, Southern Pines, NC 07/2014 – 05/2015
Continuing Education Instructor (Part-time)
Developed and delivered workshops on resume writing, interviewing skills & job searching
CAMPBELL SOUP SUPPLY COMPANY, LLC, Maxton, NC 12/2013 – 03/2014
Plant Analyst (Contractor)
Processed journal entries and other adjustments;
Conduct SOX reconciliation;
Utilized SAP & Excel to analyze plant information and create reports with Pivot Tables & Vlookups.
Validated product formulations for accuracy and errors.
Knowledge of Microsoft Access.
Accomplishments: Macro-enabled a weekly report producing an $11,000 annual savings.
AMERICAN RED CROSS, Raleigh, NC 6/2013 – 8/2013
Sr. Receivables Analyst (Contractor)
Participated in the year-end close project.
Analyzed revenue flow projections against receivables to determine root cause of variances.
Recommended changes/corrections to projections.
Organized corporate Red Cross campaign contributions.
Utilized JP Morgan and Oracle.
SPAY NEUTER VETERINARY CLINIC OF THE SANDHILLS, Vass, NC 9/2012 – 3/2013
Office Manager (Temporary)
Managed QuickBooks Accounting System and all accounting operations.
Performed inventory management.
Supervised all volunteers including recruitment, record-keeping and morale.
Coordinated customer service and front desk operations.
Documented procedures.
CREDIT SUISSE, Research Triangle Park, NC 7/2011- 10/2011
Syndicate Accounting Analyst/ Contractor
Processed Journal Entries for receivables set-up, account transfers, write-offs, and reserve set-up and adjustments.
Page 2
Managed accounting calendars to reflect receivables, reserves and payments.
Created invoices and supporting journals.
Communicated by phone and email with European contacts to manage receivables and associated accounting matters.
Set-up deals through various systems (PeopleSoft, Spider, GL – GLAD).
Performed other misc. accounting duties (invoice changes, payment tagging and processing, calendar maintenance, currency conversion rate updates and spreadsheet formula changes).
Recorded deal expenses into the IFRS spreadsheet by product line.
Accomplishments: Created payment matching tool using VLOOKUP in EXCEL.
EASTER SEALS UCP NC, Raleigh, NC 2007 – 2010
AR Reporting Manager/ Billing System Administrator
Managed all AR activities including medical billing system accruals, receipts and performed revenue recognition duties.
Analyzed monthly aging, trends, and write-off activity and reported results to management.
Audited/verified accuracy of all CPT codes.
Trained all staff on report generation and data analysis from the billing system.
Served as medical billing system administrator; Primary contact for all users on set-up, use, and issue resolution; coordinated billing software operation and performed project management duties with software vendor to maintain/improve billing and posting system.
Reconciled all revenue from the Billing System to the GL System (Great Plains) monthly, quarterly & annually.
Documented procedures and developed new processes that enhanced the AR function.
Accomplishments: Reduced prior year receivables by 99%. Created automated month end reports for JE generation with an annual cost savings of $9,000. Refined paper billing process resulting in a yearly cost savings of $4,500.
Key Accomplishments
Macro-enabled a weekly report producing an $15,000 annual savings;
Created payment matching tool using VLOOKUP. $18,200 in annual savings;
Reduced receivables from $3.5 M to $2,500 in 18 months;
Created automated month-end reports for JE generation. Annual savings $10,600;
Refined paper billing process with a cost savings of $4,500 annually;
Negotiated $400,000 reduction in local tax penalties;
Reduced receivables from $1M to $600,000 in 4 months;
Reduced receivables from $13.5 M to $2.1 M & reduced staff by 33%.
Previous Employment Available
EDUCATION
Master of Business Administration, June 1980
Bachelor of Science, Business Administration, June 1974
Philadelphia University, Philadelphia, PA
MILITARY
U.S. Army (Feb. 1966-Sep. 1971)
Supervised 42, Non-Commissioned Officer Academy Graduate.