QuickBooks, Great Plains Microsoft Dynamic , Project, Visio, SQL Server and Crystal Reports XI.
Essbase System 9 experience Excel and Smart View , SharePoint, SSAS, SSIS and SSRS.
SAP Query, Report Writing, Portal Reports, BexGetData , Financials, G/L and JE.
Over 10 Years IT/IS and Accounting Background:
Creating and Designing over 55 Databases VBA Access/Informix/SQL Server .
Built and Maintained 2 UNIX, 10 NT and 3 MS Exchange Servers in multiple locations.
JE, G/L, Payroll, Reconciliations, Financials, A/R, A/P, GAAP, Budget and P L.
TECHNICAL EXPERIENCE
Programming Language: VBA Excel/Access, VB6, FoxPro, SQL and T-SQL.
Servers: Windows 2003, NT4, Novell, UNIX and Exchange.
FINANCIAL STABILITY SUMMARY
Debt paid off monthly and with a TransUnion credit score of 827 Locked ID/Freeze-Protection , which is important when dealing with someone who is looking for a full-time position, while doing consulting assignments. Home and Cars Paid For. Married.
PROFESSIONAL EXPERIENCE
Confidential
Included month end analysis, communication of financial results and on-going support for BU.
Monthly preparation of overall financial results of BU for calls with management team.
Monthly analysis of operational results and financial position of BU.
Prepare ad hoc reports and assigned other duties.
Preparation of monthly BU review packages for headquarters and regions.
Preparation of forecasts and budgets for BU.
Manual and Automated entry into headquarters consolidation tool for forecasts and budgets.
Analyze and report monthly on key information between actual, budget or forecasted results.
Monitor and analyze variances and trends for BU.
Daily monitoring of key economic indicators for BU.
Understanding of accounting principles applied and their effect on the overall results of BU.
Manage, support, research and report with regards to special financial projects as assigned.
Able to work overtime as needed and provide operating solutions for 7 other BUs.
SAP, Active Directory, SQL, Hyperion, SQL Server 2005/2008, VBA Access/Excel and Pivot Tables based Financial, Revenue, Expense, Budgeting and Forecasting Modeling and Automation for BU.
Confidential
VBA Excel/Access Parallel Payroll Migration Database monitoring control with Pivot Tables.
Confidential
Crystal Reports, VBA Access/Excel and Pivot Tables Linked to ERP Lawson Software.
G/L Audit found an overpayment of 381K and trained Staff Accountant.
VBA Excel/Access Royalty Tracking Database with Pivot Tables.
Confidential
Consultant: Analyst
Automate various Accounting positions or train staff at 25M Medical Company, 45M Real Estate Company, Electric Coop, Restaurant Company and Dell PC Recycling Company Accounting software Custom, QuickBooks Pro, Peachtree Sage 50 and Great Plains .
To Fix Wholesale/Manufacturer Cash Flow Problem with Suppliers.
Review troubled loans and provided detail Interest/Principal fixes for Mortgages.
VBA Excel/Access Troubled Loan Tracking Database with Pivot Tables for Mortgages.
Confidential
Consultant:Analyst
VBA Excel/Access Department Level Budget Variance Database integrated with Great Plains Microsoft Dynamic . Also filled in as Senior Accountant role with G/L, A/P, A/R and FRX.
Privacy Policy
