Summary of Qualifications:
With ** years of accounting experience coupled with many years of IT experience in
key areas as, designing MS Access Databases and developing MS Excel Spreadsheets,
both utilizing the many SQL capabilities, as well as creating Oracle Discoverer Plus
Queries, I have gained a multitude of knowledge of the interworking of various
accounting software's. These skills have allowed me to restructure many job
functions allowing for more timely and accurate reporting, develop methodologies for
forecasting and more importantly expose failure to adhere to GAAP.
Experience:
10/2009 - 1/31/10(Contract) Data Analyst Bank of America -
Charlotte, NC
Analyze and Quarantine files that contain excessive amounts of Non-Public Information
Notify associates of file encryption policy and information security policy
Create VB code to automate email notifications to end-users who violate information
security policy
Create batch files to ping websites - Result allowed analysis of end-users surfing
activity
11/2008 - 08/2009 Sr. Financial Analyst
Worldspan/Travelport - Atlanta, GA
Researched Purchase Invoices to ensure depreciation and/or purchases are expensed
properly
Performed analysis of depreciation expense and purchases to explain significant P&L
impacts
Performed accruals for monthly depreciation based on analysis
Constructed and Analyzed Cash-Flow Statement
Maintain Fixed Assets and Accumulated Depreciation
Analyzed Fixed Asset process and implemented new Fixed Asset Depreciation Policy -
Result improved reporting of depreciation expense by 75%
Assist with the conversion of Fixed Assets from GEAC to Oracle
Automated Fixed Asset reconciliation using complex Excel formulas and Hyperion
Essbase to allow for more accurate Fixed Asset Reporting's
Maintain Fixed Assets and Accumulated Depreciation
Developed process of researching payables to ensure assets are depreciated and/or
expensed properly -Result exposed inaccurate depreciation of assets
Developed queries using Discoverer Plus to analyze the depreciation, purchases, and
expense of assets to explain significant P&L impacts - Result allowed for accurate
reporting and cut reporting time to VP and Controllership
Developed queries using Discoverer Plus to Perform accruals for monthly depreciation
Developed Oracle Discoverer Plus queries to validate Subledger and GL Balances
Developed Work-Flow Process for Fixed Assets using Visio
02/2008 -10/2008 Sr. Accounting Analyst Onity, Inc -
Duluth, GA
Maintained Extended Warranty Amortizations
Maintain Fixed Assets and Accumulated Depreciation
Prepare Gross Margin Report
Performed Intercompany transactions and Reconciliations
Prepare 45 Balance Sheet Reconciliations
Reconciled CIP account which exposed over 3 years of assets in progress
Analyzed Extended Warranty process and implemented Extended Warranty Amortization
Database - Result allowed for accurate reporting of sales and bonus' structure
Worked closely with Controller to perform various SOX and Financial Audits - Result
exposed inaccurate AP invoice postings to GL
Developed Access Database including SQL queries and VB Code to maintain Extended
Warranty Amortizations, result increased job efficiency by 50%
Developed Access SQL queries to calculate Foreign Revenue, result increased job
efficiency by 25%
Established methodology for calculating Inventory in-transit - result exposed 400K in
incorrect payable postings
03/2003 - 12/2007 Sr. Accountant Consultant Blue cross Blue
Shield of GA/WellPoint - Atlanta, GA
Lead project of transitioning work across 3 states(Georgia, Wisconsin, and Indiana)
Performed analysis of home and host revenue
Accrued monthly revenue based on monthly analysis
Analyzed Daily Balancing Functions using VB Code in Excel and implemented automated
worksheets to retrieve daily revenue - Result allowed for more accurate posting of
Revenue and increased job efficiency and performance by 75%
General Ledger Entries for accuracy
Prepared Quarterly and Annual Financial Reporting and Analysis
Established ODBC Connection between FoxPro and MS Access Database along with VB Code
to automate BCBS of Wisconsin daily balancing job function
Built 2 Built Access databases with VB Code to calculate Home and Host Revenue,
result increased job efficiency by 50%
Developed SQL queries in Access to analyze home and host revenue - Result allowed for
accurate accruals and provided validity of revenue forecasts
Developed methodology for forecasting of 15 balance sheet accounts
Created sub-ledgers for 4 Home Plans - allowed company to accurately reconcile to GL
03/2003 - 3/2005
Blue Cross of South Carolina - Columbia, SC
Researched payables to providers to ensure accurate payments are made
Reconciled Subledger to GL of provider credit balances
Developed Macro's using VB Code in Excel to automate daily credit balance postings,
result increased job efficiency by 35%
Coordinated and assisted with several special projects, result saved company $25,000
yearly
Developed Access Database with VB Code to house credit balances reports sent by
providers
Developed methodology and created sub-ledgers for provider credit balances, allowed
company to accurately reconcile to GL
Developed Access Database with VB Code and SQL queries to report Annual and Quarterly
credit balances to Association, result allowed more timely reporting
12/1999- 02/2003 Sr. General Ledger Associate United Parcel
Service - Columbia, SC
Balanced internal accounts (AR, AP, Cash on Hand)
Used MS Access and Excel to performed bank reconciliations on specific accounts
Used Ms Excel to Maintain and monitor journal entries for a minimum of 4 accounts
Interacted closely with CPA and Controller to review the general ledger and month-end
closeout
EDUCATION:
Limestone College 2002 - 2005
Bachelors of Science - Accounting
Bachelors of Science - Business Management
ADDITONAL QUALIFICATIONS:
Ability to Read PL/SQL, Understand ODBC Connections, People Soft 8, Sage Timberline,
MS Great Plains, Crystal Reports, ADP Payroll Processing Systems, Oracle, Oracle
Discoverer Plus, Hyperion Essbase, Navision, FAS, Certified Trainer MS Access, Expert
MS Excel, Visio