SUMMARY:

• Experienced Accountant/Financial/Business Analyst with in - depth analytical skills and attention to detail.
• Excellent knowledge of GAAP and SOX compliance and ability to manage and implement change.
• Experienced in systems migration and strong commitment to teamwork and cross-functional cooperation.
• Proven ability to communicate effectively, multitask, determine priorities, and be a self-starter.
• Strong business intelligence and data analytics background.
• Financial industry experience: Freddie Mac, Fannie Mae, Capital One, Sallie Mae.

TECHNICAL SKILLS

SKILLS: Microsoft Office Products (Excel, Word, Access, PowerPoint, Visio), Bloomberg, Atlas, QuickBooks, Oracle Financials, Business Objects, Deltek (Costpoint, Advantage, GCS Premier), PeopleSoft, Doors, ClearQuest, Lotus Notes, SAP-Web Intelligence, SharePoint, Remedy.

PROFESSIONAL EXPERIENCE

Confidential, CA

Business Analyst-Pharmacy Data Warehouse

Responsibilities:

• Manage the generation of accurate and timely month end financial reporting.
• Extract and compile data in Business Objects using a wide range of data sources for reporting purposes.
• Create and prepare ad-hoc reports for various cross-functional units.
• Analyses internal financial reports and evaluate performance and trends.
• Utilize expertise in Business intelligence and Data Analytics to create solutions to business process issues.
• Work in conjunction with the business users and development teams, responsible for the creation and execution of application test scripts, scenarios, and test plans that validate initial business requirements.
• Validate GL data specifically Accounts Receivable, Cost of Goods Sold, and Inventory accounts.
• Support deployed regions during month-end close processes, including oversight of utilization of Business Objects, GL Pharmacy accounting entries and reporting issues.

Confidential, VA

Financial Business Analyst (Contract)

Responsibilities:

• Assisted with system upgrade of PeopleSoft from v8.9 to v9.1
• Worked with business partners to assess business requirement changes.
• Identified, researched and analyzed usable existing data requirements.
• Interfaced with various operational units in performing timely resolution of outstanding items.
• Performed fit gap analysis and documented functional requirements.
• Prepared BRD document from inception to final sign-off by stakeholders.
• Serve as liaison between stakeholders/users and internal IT group to resolve issues.
• Developed business process flows so that all the work associated with a specific person or team is visually represented in a way that is easy to describe, comprehend and understand.

Confidential, VA

Financial Business Analyst (Contract)

Responsibilities:

• Served as liaison between accounting group and vendor host, to find solutions for issues impacting the company’s financial reports.
• Coordinated meetings with stakeholders, project managers, and IT specialists related to planning, development and upgrades of existing applications.
• Assisted the Capital Markets/Treasury group in resolving report issues and downloads.
• Worked closely with IT group providing input from different business units
• Working with business partners to assess key controls, review prior audit findings and ensure remediation, review and validate documentation and assist with updates as necessary.
• Assisted the General Ledger and Capital Markets group to maintain and ensure timely updates for month end close activity.
• Participated in SOX 404 efforts, including documentation of processes and facilitating testing controls as necessary.

Confidential, D.C

Financial Business Analyst (Contract)

Responsibilities:

• Performed testing documentation (i.e., process flows, requirements, document, procedures)
• Managed requirements traceability information and track requirements status throughout the project.
• Mitigated Fannie Mae's operational risk as it relates to cash remittances, security update, loan level reporting, MBS disclosures, lender reconciliations, and data integrity.
• Analyzed and resolved investor accounting problems of medium complexity within the scope of their assigned or shared lender portfolio.
• Participated in SOX 404 efforts, including documentation of processes and facilitating testing of controls, as necessary.
• Participated in special projects (Failed Business Rules - transactions entered into the system for compliance.)

Confidential, VA

Sr. Project Accountant

Responsibilities:

• Assisted in the verification of data migration from Deltek Advantage to Costpoint.
• Assisted in their system migration from Deltek Advantage to Costpoint (Setting up Projects, uploading Field Costs, General Accounting Worksheet, Setting up modifications on Projects i.e. adding prior year cost and revenue to a project.)
• Prepared reporting on compliance or audit projects or other program elements as required.
• Analyzed and document high quality functional, technical and security requirements.
• Researched, identified and evaluated loan system discrepancies.
• Performed testing documentation (i.e., process flows, requirements document, and procedures).
• Prioritized requirements to meet customer specifications and to enhance software development.

Confidential, VA

Business Analyst (Contract)

Responsibilities:

• Involved in the development of a new system application called Servicer Investor Reporting that deals with various types of mortgage products such as Cash loans, Pooled loans and Mortgage Backed Securities (MBS Loans).
• Solicited, analyzed, validated, specified, verified, and managed the needs of the project stakeholders.
• Identified, researched, analyzed and assessed the quality and usability of existing data repositories to meet emerging business requirements.
• Reconciled data sources to other related external sources by consulting with business partners and application development project leaders in determining accurate data sources
• Developed accounting entries to correspond to various sub-stream conditions. (Interest accruals and recognition, securities and various loan transactions).
• Intensive use of different database (PeopleSoft, Financial Dashboard, Access) proprietary to Fannie Mae.

Confidential, D.C

Financial / Compliance Analyst (Contract)

Responsibilities:

• Involved in the re - statement of financial reporting relating to the reconciliation and analysis of cash remittances and vendor billing contracts.
• Assisted with month end close process for Cash Control.
• Worked with business partners to assess key controls, review prior audit findings and ensure remediation, review and validate documentation and assist with updates as necessary.
• Identified, researched and analyzed outstanding items related to all cash transactions and vendor billing activities.
• Interfaced with various operational units in performing timely billing of various vendor contracts.
• Prioritized government compliance reporting and contracting activities. (SOX Compliance)
• In charge of the reconciliation and analysis of (MBS) Mortgage Backed Securities relating to Principal and Interest payments through the use of various database applications proprietary toFreddie Mac.
• Prepared Unpaid Principal Balance Roll-forward Report on 3 different portfolios. (Core, Tax Advantage and Taxable).
• Performed comparison of calculated Accrued Interest Receivable between Freddie Macs records against the remitting Banks record.
• Performed variance analysis and research on Accrued Interest Receivables
• Prepared summary worksheets for the reconciliation of Cash on record (Treasury-PeopleSoft vs. Bank Statements)

Confidential, MD

Senior Cash Accountant (Contract)

Responsibilities:

• Management of daily cash receipts and reconciliation of inter - company accounts.
• Posted journal entries to Deltek GCS Premier application and reconciled GL Accounts.
• Maintained cash receipts of roughly 100 accounts with a collective volume of $500M annually.
• Processed and updated day-to-day incoming wires and applied the same to the correct property account.
• Applied cash receipts to account receivables in multi-currency environment, which included withholding tax.
• Performed various ad-hoc projects assigned by the manager.
• Assisted in the preparation of quarterly reviews and annual audits
• Performed month-end closing, including reconciliation of general ledger accounts, developing and recording journal entries and the preparation of account analysis reports all these using SAP (Fico) application
• Reconciled Accounts Payable, Monthly Bank Statements and Travel Expense reports.