 Analyzes and prepares detailed financial data and studies in a clear, concise format including month-end (internal) department financial reports and variance analysis. Evaluates and recommends resolution on issues related to assigned areas. Strong working knowledge of data modeling, trend, and gap analysis for various project assignments. Preparation of budget and forecast in various program areas related to VA contract. Compiles updates as needed by upper management. Recommends (and occasionally prepares) entries for the general ledger based on reliability, propriety, and compliance with GAAP.Accomplishments: Identified and facilitated accrual and payment corrections for several large contract accounts. Set up new budget worksheet format for departmental contracts to facilitate centralization of information for every contract and monthly tracking of expenses for budget and forecast. Validates and reports monthly non-financial information for significant estimates reporting and monthly CFO package.

 Analyzed monthly production and productivity of behavior healthcare professionals, physician's assistants, doctors and nurses through financial reporting models for monthly actuals versus budget. Prepared many diverse and detailed monthly financial reports and monthly board reports for CHOICES Network. Produced detailed encounter/productivity of case managers, doctors and nurses and identified by color productivity levels that were red (severely under), yellow (slightly under), and green (at) and white (greater than) productivity. Utilized encounter data to explain financial variances to budget for revenue and expenses. Investigated encounter discrepancies by extracting day/week/month data and determined detail not in the funding entity's claim system. Partnered with IT to correct rejects and encounter/claim resubmission. Maintained CHOICES staff position control within Datis Human Resource/Payroll system. Managed financial audit, retirement plan audit nonprofit reporting (Arizona Corporate Commission annual Report, Form 990, Form 5500) for federal, state, and local agencies. Created/updated annual budget and updated data cube detail in TM1 (Hyperion Essbase.Accomplishments: Played key role in the standardization of tools to be used for budgeting, forecasting, and real-time reporting of financial results through use of Cognos/TM1 (Hyperion Essbase) Identified and facilitated error corrections before financial close. Simplified accounting process for deferred revenue. Created a more efficient process for compliance and regulatory reporting.

 Facilitated program financial reporting for HIPAA 5010 Program. Analyzed month-end accounting activity and collaborated with various finance groups/Program Managers to correct discrepancies in accounts to manage financial models for monthly actuals. Prepared monthly reporting package for senior leaders which included preparing variance commentary for accounting categories (contract labor, internal labor, travel, hardware, software, and professional services). Set-up fixed assets by program after completion of reconciliation analysis for prior month's accounting activity.Accomplishments: Managed monthly forecast by collaborating with IT Program Office and Program Managers for updates based on program progress and resources. Modified monthly reporting to provide summary commentary by account group instead of account detail.

 Initiated research and resolved discrepancies in AR clearing accounts for divested divisions. Compiled monthly accounting analysis for bad debt reserve, AR aged trial balance vs. GL, Days Sales Outstanding Report, and Unapplied Payments and Credits reporting using Essbase. Ensured the completion of journal entry, monthly reporting and accounting support from field. Reconciliation and reporting of deferred revenue through analysis and collaboration with field controllers.Accomplishments Created new cost center rollups by region in Essbase (TM1). Identified and initiated resolution for 30% of out of balance AR accounts.

 Technically proficient in the utilization of Essbase for monthly metric reporting and site packages. Compiled actual versus budget commentary for responsible areas by workday +3. Reviewed journal entries and monthly status meetings to ensure financial targets are met. Collaborated with management for feedback to reporting and to support scope planning and changes.Accomplishments: Successfully handled largest SDN function (in addition to three other functions) with no training after team member's departure. Enabled customer groups in taking ownership of their accounts by monthly close reviews, budget creation and input into standardized formats to be loaded into TM1.

 Managed maintenance of capital budget including forecast and monthly reporting of expenditures. Compiled weekly revenue reporting and year-end detailed revenue reporting for sales trend analysis. Completed monthly corporate reporting of 12 month trend for revenue and balance sheet forecast. Participated in Sarbanes-Oxley training and utilized principles for quarterly audit of corporate card. Coordinated set-up, maintenance, retirement, reconciliation, and reporting of PC inventory for annual statement. Researched and resolved aging accounts receivable; accounts receivable back-up.Accomplishments: Created Capital Budget report which enabled managers to reduce aged Construction in Progress items to 60 days, resolved 50% of aged balance sheet items with several engineering groups within nine months. Created review procedures for employee credit card expenses in accordance with Sarbanes-Oxley.