Resume

Sign in

Accounting Analyst

Location:
Columbia, South Carolina, 29223, United States
Posted:
May 27, 2010

Contact this candidate
Sponsored by:
TalentDesk
Post Jobs to
Multiple Job Boards &
Get more Candidates
Try it Free!
Start your 30-day
Free Trial

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



Contact this candidate