PROFESSIONAL EXPERIENCE:

Confidential

Sr. Financial Analyst

• Monthly Revenue & Gift Range Chart worksheets creation after retrieving dozen of Blackbaud - CRM SQL based queries; Weekly Revenue reports-short version. Data clean up based in Blackbaud CRM; Annual Surveys (NACCDO, AHP, AAMC) financial data research & population; Reviewed Monthly Financial Credit Reports (revenue) created by another employee; formulas troubleshooting and improvement; Access database testing; large data sets testing/comparisons; new Excel application testing; MTD/YTD Budget & Variance analysis. PowerPivot, PowerView, Tableau. Ad hoc reports. Written many business flow procedures.

Confidential

Sr.Accountant/Business Analyst

• ERP Migration project from PeopleSoft to Tyler-Munis. Clean up data for the new ERP requirements. Analyzed approximately 35,000 Fixed Assets for data consistency, relevancy and accuracy and research missing data. Validated and reconciled $1.3 Billion of fixed assets detail. Used PeopleSoft queries for data analysis as well as Excel formulas, Excel pivot tables for data reconciliation and data validation. Oracle database, SQL.
• Reconciled PeopleSoft & Munis Trial Balances at Fund, Account, Project and Program level (multilevel Reconciliation) by fiscal periods. Recorded adjustments.Visio chart creation. MS Project update. Data normalization and validation.
• Payroll OT variances analysis—over $20M Gross Payroll Overtime recalculation and analysis. Project Accounting-Munis entry; Government Contracts Munis entry, Contracts Reconciliation (PSFT/Munis); Account Master new Budget codes creations. Wrote Business Requirements for systems: SymPro, Keenan, Elite, CUBS, and Whitman.

Confidential

Financial Analyst/DBA

• Database Administrator (Access) for IT Department’ s Finance group.
• Meetings with project managers concerning financial planning for each project/department. Budget for IT Department, financial planning. Access database maintenance for budget purposes.

Confidential

Sr. Accountant

• Bank Reconciliations for 3 accounts for 8 months; numerous Journal Entries for inter-bank transfers, bank fees; Payroll Journal Entries, payroll taxes, vacation accrual, and other accrual entries in connection with payroll; Prepared Financial Statements.

Confidential

CEO/Founder

• Responsible for all accounting and tax matters of the corporation; monthly and quarterly reports of company’s financial performance. Budget and forecasting; revenue projection . Corporate Accounting, 1120 C Tax Preparations.

Environment: Advanced Excel & Access projects: database design, reports, SQL queries, Business Objects/Business Intelligence; case studies for the clients; PowerPoint presentation.

Confidential

Sr. Financial Analyst

• Responsible for Forecast/Budget for all locations/divisions. Revenue forecast based on test volume; budget volume utilizing client net wins/loses by regional managers’ estimate. Expenses forecast based on run rates and/or seasonality. Data extracting/mining from a large database and utilizing data for financial analysis. SQL queries from Oracle database.
• Developed Direct/Indirect/Total Cost model for each business Line: Lab, Xray, Ultrasound. Monthly P& L reports form MAS90 and expense reconciliation (>$7 million). P&L: EBITDA calculation for acquired Labs. Fixed Cost for new Labs Acquisition estimate. Bi-weekly Headcount, OT, FTE reports for upper management. QBR (Quarterly Business Review): Actual vs. Budget variances analysis. Write-up based on briefs with regional management.
• Net Revenue calculation based on production report and contractual rates for each location.

Confidential

Sr. Business Analyst

• As a Business Analyst was responsible for all facets of software migration project—from Moody’s Financial Analyst to Risk Analyst. This includes GUI interface comparison, Chart of accounts, testing formula comprising complicated financial statements-Balance Sheets and Income Statements as well as reconciling Financial Statements, re-calculating Financial Ratios, validating Scorecards for Risk Management module (personal & business). Data mining with Business Objects or SQL. The duties include formula verifications, running forecasts (projections), modeling, and formatting. Verification of the identical spreading of financial statements in the comparable software (MFA & RA); monitoring non-financial data migration as well as technical aspects of data migrating: speed, integrity, formatting, archiving database tables. Performed full-scope of new software testing.

Confidential

Business/Financial Analyst

• Fund Deficit Requests: reconciliation, justification & submission to Acctg Dept; Financial analysis for Annual Operating Deficit Request; Budget MOR (Monthly Operating Report), Revised Budget, Capital expenses; Balance Sheets & Income Statements Analysis; Annual Memo prep and co-revision; Operating Deficit Projections; Debt Amortization schedules: updating multiple loans and bond amortization; Reviewed Debt Notes/Promissory Notes, Notes to Auditor’s Reports, and Bond Redemption; Economic Occupancy Breakeven analysis; Debt Coverage Ratio calculation;
• Review: Partnership Agreements, Debt Notes, Purchase Agreements, Trustees’ statements
• Quarterly budget variances analysis, budget adjustments, quarterly DCR (Debt Coverage Ratio) variances analysis, MOR (Monthly Operating Report) analysis.
• Reviewed Audited Financial statements and Notes to Financial Statement

Confidential

Financial Analyst

• Financial Reporting to upper management: Daily Flash Reports, MTD/QTD Reports, various monthly reporting and variances analysis, Monthly/Quarterly meetings PP of financial results, Business Objects reports, Brokers commissions, ad hoc Excel projects.

Confidential

Sr. Financial Analyst

• Responsible for monthly flash and close and variance analysis. Prepared monthly management reports to provide executive management and parent company with profit/ loss, and amortization. Performed quarterly forecasts; presenting information to executive and parent company management. Reviewed of monthly/quarterly results and forecasting forward (rolling forecast). Creation of Senior level internal management reports measuring key performance indicators to address PC and News Corp needs. Creation of FEG Consolidation Reports: Exec Summary for Budgets, FEG Profit Roll-forwards, Quarterly Profit Analysis. Ran various monthly reports (SQL queries) from PeopleSoft as well as used Billing and A/R modules. Exported reports to Excel & Crystal. Set queries with various criteria. Department Level Review: FEG Corporate Review, FEG summary Review, General Cost containment. Inter-company accounts reconciliation ($6-7 mil) and subsequent journal entries as required.

Confidential

Research Analyst

• Designed and maintained Access database Exporting/Importing of large data between Excel & Access; large insurance data mining from custom database; upload to Access.
• Worked with Excel macros in analyzing MEC policies for IRS for insurance claims.
• Advanced filters in Excel, creating and updating financial spreadsheets, problem solving. Helped employees with Access & Excel troubleshooting and training. Custom-designed Access databases for file management. Prepared Reports for upper management
• Maintained IMS (Information Management System for premium and loan histories (mainframe).

Confidential

Property Management Accountant

• Performed high-rise building management accounting with 1.2M operating budget.
• Tracked work orders; charges-to-tenants, job costing ledgers maintenance & calculating
• Prepared daily sales reports and cash journal for upper management. A/R cycle: billing to tenants, invoicing and monthly statements, check deposits, collection calls & letters
• A/P cycle: invoices coding and payments; credit memos; month-end reconciliation
• Excel revenue projections spreadsheet and charts generation; trend analysis
• Profit & Loss statements; budget comparison & owner’s reports.