PROFESSIONAL EXPERIENCE:

Confidential

Lead Business Analyst

Responsibilities:

• OFSA 4.5 to OFSAA 6.1: multi - level reconciliation prior to “go- live”. Historical data reconciliation at 2 databases: Hyperion Essbase and OFSAA: writing/editing queries SQL for Oracle, pivot tables, Excel formulas. Production cycle: Flash reports for global branches; MDLs (Manual Data Load) to update OFSAA. Ran OBIEE reports; wrote business process procedures, improved existing business processes

Confidential

Sr. Financial Analyst

Responsibilities:

• 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; new Excel application testing; MTD/YTD Budget & Variance analysis. PowerPivot, PowerView, Tableau. Ad hoc reports.

Confidential

Sr.Accountant/Business Analyst

Responsibilities:

• 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 and for data analysis as well as Excel formulas, Excel pivot tables for data reconciliation and data slicing/dicing.
• Reconciled PeopleSoft & Munis Trial Balances at Fund, Account, and Project level (multilevel Reconciliation) by fiscal periods. Recorded adjustments.Visio chart creation. MS Project update. Data validation. Formula: vlookup, sumifs, countifs, Index/match, IF, etc

Confidential

Financial Analyst

Responsibilities:

• Financial Analyst and MS Access administrator 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 design and maintenance for budget purposes.

Confidential

Senior Accountant

Responsibilities:

• 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

Responsibilities:

• 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.

Confidential

Sr. Financial Analyst

Responsibilities:

• 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.
• 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.

Confidential

Sr. Business Analyst

Responsibilities:

• 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

Responsibilities:

• 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;

Confidential

Financial Analyst

Responsibilities:

• 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

Responsibilities:

• 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 Confidential Corp needs. Creation of FEG Consolidation Reports: Exec Summary for Budgets, FEG Profit Rollforwards, 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. Intercompany accounts reconciliation ($6-7 mil) and subsequent journal entries as required.

Confidential

Cost Accountant

Responsibilities:

• Multimillion billing review ($7-10M for assigned profit center), Job costs (Direct/Indirect/ICOM) calculation, sales orders/sales contracts review, monthly unbilled analysis for assigned profit center, month-end closing journal entries, adjustments, reconciliation and closing packages.

Confidential

Research Analyst

Responsibilities:

• 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 . Custom-designed Access databases for file management. Prepared Reports for upper management
• Maintained IMS (Information Management System for premium and loan histories (mainframe).
• 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.