COMPUTER SKILLS / SOFTWARE:

• Excel (expert - macros, formulae, pivots, solver, fin. modeling)
• VBA, SQL
• SAP, Crystal Reports
• Oracle (local & ADI), Hyperion (HFM), Essbase, Smartview
• Great Plains (GP) - Microsoft Dynamics
• Fund-EZ (fund acctg.)
• PeopleSoft
• QuickBooks, Minitab, Expensewatch
• ADP Enterprise
• Business Objects - BOXI, BI Discoverer - Business Intelligence
• Sage Platinum, Yardi (Property/Asset Mgmt), FAS (Fixed assets)

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Assistant Finance Manager

Responsibilities:

• Community Guardian Program - agency becomes legal guardian for APS-referred client cases
• Oversee departmental portfolio of 800 clients & administer full individual portfolio of 150 clients
• PM for Migration & Restructuring (CoA-Chart of Accts, banking,, process documentation/workflow standards)
• Revenue Mgmt, Asset Marshalling, Property Mgmt, Social Security, Medicare, Medicaid surplus, benefit spenddown
• Trusts (pooled/individual, SNT Special Needs Trusts) - creation, administration, deposits/disbursements
• G/L maintenance, JE review, P&L generation, budget creation & expense tracking, trend analysis, vendor cleanup
• Audits - review, instate audit controls & processes, GAAP compliance, separation of duties, document, etc.
• Business analyst / IT Administrator for Finance Department (Fund-EZ, Docuware, custom-built software) - analyze end-user needs, administer user rights, UAT (pre-release software development testing), RFCs (change requests)

Business Analyst

Confidential

Responsibilities:

• Pro bono legal advocacy - Social Security & Employment law cases
• Receive client instructions, interview client for testimony, research, document & represent client at Tribunal (court)

Confidential, Boston, MA

Finance Director

Responsibilities:

• Period Close - M/E, Q/E, Y/E (oversee outsourced bookkeeping firm; review, approve & consolidate results)
• Supervisory Duties (oversee finance & accounting team- KPIs, SMART goals, employee & program reviews)
• Budgeting & Forecasting (proforma financial statements) - programs & trend analysis, projections
• Annual fiscal-year planning for Boards of Directors, meetings with BOD - create financial packets, answer queries
• Audit Preparation (single audit/OMB-a133, Title X, DPH, prep packets, service contracts)
• Federal & State Funding - applications, statutory requirements, research
• Continuous process improvement/reengineering, - reorganize ledger accounts /GL setup
• Reported directly to Executive Director

Confidential

Accounting Manager

Responsibilities:

• Staff accounting (revenue, contra-accounts: sales return reserves, expenses, allowances, billing, royalties, accruals/deferrals, sales tax returns, transfer pricing from European operations, etc.)
• Supervisory Duties (oversee accountants, analysts, co-ops; trial balance analysis; JE/period close review & approval)
• Variance analysis, Cost analysis, Trend analysis (BS, P&L accounts, budget:actual - 12-month, QTD, YTD, etc.)
• PM for SAP migration - user requirements, RFCs, UAT testing, process flow documentation, IT interface
• Budgeting & Forecasting (marketing, SOP, HFM-Hyperion)
• SQL Query-building & Data pulls (i.e. Oracle Business Intelligence (BI) Discoverer / Hyperion Smartview)
• Account Reconciliations (revenue/contra-revenue, A/R/allowance for doubtful accounts, etc.) depreciation schedules, loan/capital lease amortization schedules (creation of automated Excel calculators)
• External auditing & reporting - financial statements & systems
• SOX - Procedures, testing, documentation, SSAE 16 (SOC reports)
• International Currency Exchange transactions (EUR, CAD, CHF)

Confidential

Accounting Manager

Responsibilities:

• Supervisory Duties (Oversee accountants; Trial Balance analysis; JE/Close review & approval)
• Staff Accounting (revenue - premiums, fee income, etc., reclass, reserves)
• Account Reconciliations (by subsidiary entity, account, currency, legacy software sub-ledgers, set of books)
• Account mapping ($15B, multiple business entities & international subsidiaries, legacy systems)
• Reinsurance (ceding/assuming/retroceding), Rollforwards
• OLAP data cube pulls & data feeds
• IFRS, NAIC, GAAP & Canadian GAAP (CGAAP) concurrent sets of books, international subsidiaries
• Transfer Pricing (inter-divisional) & price testing
• Business Objects (BOXI) data reports

Confidential

Accounting Manager

Responsibilities:

• Supervisory Duties (oversee accounting assistants)
• Staff accounting (revenue recognition, deferred income, billing & credits)
• Revenue Analysis (License Fees, Maintenance, 3rd-party vendors)
• Contract analysis (revenue recognition, legal compliance, cash-flows, review, etc.), liaise with Account Mgr, Bus Dev
• Product analysis - revenue generation, implementation, first live-use, milestone software usage
• Excel – mega-file manipulation, advanced formulae, VBA programming
• Continuous process improvement – explosive growth company with antiquated SME processes

Confidential

Sr. Accountant

Responsibilities:

• Fund accounting (restricted funds, revenue/expense analysis, trend analysis, payroll, budgets)
• Account Reconciliations (bank accounts/credit cards, A/R, A/P, payroll, expense accounts, cost centers)
• Payroll (ADP JE, adjustments, account reconciliation), staff training, EAP, Personnel Action Form (PAF) processing
• Payroll deductions (health, wage garnishments, fringe benefits, 403(b), FSA, etc.)
• External reporting – SOX, Unemployment (ER/EE), worker’s compensation, federal census compilation
• Cost allocation (950cost centers) -.fees, income, expenses, etc.
• Vendor payments, A/P Vouchers, Invoicing, Rental Payments, A/R summary/detail aging, A/R status reports
• Audit preparation, Workpaper creation & execution
• Project Manager (Rep. Payee Clients) - backfill plan, process re-engineering, process documentation, audit prep.

Confidential

Sr. Accountant

Responsibilities:

• Staff accounting (JE posting, reclass, period close, ad hoc analysis)
• Account Reconciliations (operating cash accounts, straight-line, clearing accounts, CIP - construction in progress)
• Workpapers (Reconciliations, fixed assets & depreciation schedules, security deposits, real estate taxes, insurance – prepaid/accrued/expense, rent roll, service cost/service income, legal expense, budget & re-forecast, etc.)
• Property accounting for 80 properties, HUD property accounting
• RE (fee income-base rents, abatements, reimbursement income, service cost/income, operating expense escalations)
• Job costing (% completion, original contract & revised amendments), inventory costing (LIFO, LCM-IFRS)

Confidential

Sr. Financial Analyst

Responsibilities:

• Financial Statement Generation & Consolidation (all holding company entities separately & consolidated)
• VBA Macros & User form automation (Excel Developer)
• Financial Analysis - Revenue metrics (EBITDA/Operating π/ EBITDAR), ROI analysis, due diligence
• Revenue analysis – product analysis, A/R analysis, revenue-sharing models, sales journals, recognition/deferred income (subscriptions, events, commissions, training income, etc.)
• Budget-to-actual variance analysis, 10-yr P&L ProForma forecast, 24-mo. new sales region operating models
• KPI reporting (Key Performance Indicators)
• Annual fiscal-year planning for Boards of Directors
• Proforma event planning – cash-flow, pricing, conversion rates, expenses, marketing
• Data mining & customer analytics, predictive analytics/models
• Reported directly to & supported CEO, CFO & CMO
• Financial dashboard creation (VBA) – separate legal entities & consolidated financials
• Ad-hoc financial analysis

Confidential, New York, NY

Financial Analyst

Responsibilities:

• Analyst on middle-market loans: mezzanine capital financing
• Financial Modeling, Financial Statement Analysis, Decision Modeling, Reporting & Ad Hoc Analyses
• Analysis, financial forecasting, performance metrics, ensure departmental SOX-related compliance
• Capital Markets team support - analysis of publicly-traded debt, comparisons of multiples & structures
• Dashboard reporting & creation, Access SQL queries (join/filter/order/count)
• Structured Finance, Commercial Services & Factoring Divisions
• Transaction summaries, cash flows, trend cards, due diligence, credit documentation, covenants & initial deal reviews
• Client Accounting (reconciliations, trial balance, monthly closing, etc.)
• Timely & accurately gathering, compiling & dissemination of financial data to senior management
• PM for SAP migration - user requirements, RFCs, UAT testing, process-flow documentation
• Received highest employee appraisal ratings on annual 360º performance review

Confidential

Accounting Analyst

Responsibilities:

• Accounting Analysis, EU Operations
• Project Manager, International Expansion Project