Financial System Analyst Resume
Washington, DC
SUMMARY:
- Highly successful with presenting strategic planning recommendations to top management.
- Ensure that different accounting procedures and policies are in compliance with SOX, DCAA audit, CAS, FAR, FASB and GAP regulations.
- Experience gained through Financial System Implantation solving the outstanding issues with database legacy systems, overseeing the data cleansing /migration team quality work, determining the required fields for the new ERP Systems (SAP, Tyler Munis, Time Clock Plus) and making sure the new ERP modules for HR, Payroll, GL, Fixed Assets, Inventory, and Fleet Management are in compliance with the different internal controls (Federal, State, Local, and GAP regulations).
SKILLS:
Accounting Skills: Proficient in preparing Financial and Expenses reports that verify the accuracies of the Balance Sheet and Income Statement accounts to provide quality control of all activities related to reconciliation and external audit, Interpreted Federal contracts Cost Reimbursable, Time & Material, and Fixed Price in order to have proper revenue recognition. Proficient in preparing Incurred Cost Submission.
Financial ERP and Database skills: Lawson, PeopleSoft, SAP, SAP BA, Deltek Cost point and GCS Premiere, JAMIS, JD Edward, Crystal Reports, Tyler Munis, Momentum, Time Clock Plus Oracle SQL Queries, SQL Server database, Microsoft Office 2010, MS SharePoint, MS Visio, Visual Studio
Project Management: Agile, SDLC
EMPLOYMENT HISTORY:
Financial System Analyst
Confidential
ERP: Tyler Munis, SAP, Momentum
Responsibilities:- Collected and documented business requirements for the new ERP system and managed data flow across the organization - including Enterprise Systems, Human Resources, Payroll, and Accounting department
- Assisted in the rollout of a Human Resources Web Portal that allows employees to access their own personal information such as payroll, benefits, and leave time, which completely eliminated the need for manual lookups by HR and Payroll staff.
- Provided day-to-day technical support and problem solving services to the following three functional areas: human resources, payroll, and accounting departments.
- Assessed business operations and processes for HR, payroll, accounting departments to understand procedures, information flow.
- Create, design, and format technical specification documentation including architecture diagrams, process flows, and other information or processes needed to describe required system changes for development, QA, and other internal customers
- Participate in meetings with department managers, project managers, and developers to automate, upgrade, or expand applications that accomplish business operations.
- Write and maintain the user calculations that are used in the human resources, payroll and accounting systems.
- Proactively and collaboratively identify opportunities for business process improvement in the new ERP systems (Tyler Munis, Time Clock Plus).
- Set up and maintain the reporting business areas that are used in Oracle Discoverer.
- Wrote scripts using Oracle SQL queries Access, Excel to identify inconsistencies and errors
- Wrote functions that are loaded to the Oracle and SQL Server databases to be use with the various reporting and maintenance tools.
- Wrote and set up roles and procedures used by third party reporting tools to access the payroll/HR and finance system.
- Managed the selection and rollout of an electronic document management system, including integration with an enterprise database that drastically reduced inefficiencies in the processing of all paper-based forms and documents.
- Managed the selection and rollout of an electronic document management system, including integration with an enterprise database that drastically reduced inefficiencies in the processing of all paper-based forms and documents.
- . Assisted in created a Paperless Forms System that reduced the processing time of some forms from 2 weeks to 20 minutes. Forms included a performance review system, leave cash-in form, address information update form, and a new employee forms repository.
- Developed documentation and training for end users on how to SAP, and Tyler Munis features and related applications (MS Visio).
Confidential, Washington DC
Sr. System Analyst/Consultant
ERP: SAP
Responsibilities:- Ensured that SAP accounts are reconciled to the OPSM legacy systems, and any reconciling items are resolved in timely manner.
- Assisted in the in the implementation of property modules in the SAP/FBMS.
- Understand user objectives and advise users on the best way to accomplish a business objective with the systems.
- Reviewed, improved, and updated the design, setup for the fixed asset, fleet, supply and inventory databases.
- Assisted in the definition of data selection criteria and prioritize data cleaning/conversion efforts.
- Identify data quality issues that potentially exist with OPSM legacy systems.
- Assisted in ensuring adequate internal control measures over the property management department assets, data, systems and reports.
- Reviewed edit reports and operator error messages and provided applications support to end users for SAP/FBMS and related applications.
- Monitored databases and data. Identify and correct problems or corrupt data. Coordinate solutions with appropriate users
- Serve as a senior technical expert in financial and accounting system matters, especially as they relate to property functional areas (fixed asset, fleet management, supply and inventory).
- Provide day-to-day technical support and problem solving services to the following three functional areas: fixed asset, inventory, fleet, and accounting for the personal property office.
- Coordinated month-end closings, insuring that all required close entries are properly recorded for the personal property office.
- Researched, and follows through to ensure the general ledger and subsidiary systems accurately reflect the Personal Property Office
Confidential, McLean, VA
Lead Financial Consultant
Responsibilities:- Conducted proper closing procedures for interim and annual financial reporting and assist in reviews of journal entries and account reconciliations.
- Reviewed, investigated, and corrected errors and inconsistencies in financial entries, documents, and reports.
- Reconciled payroll-related liability and expense accounts for 3 different company
- Participates in year-end external and internal audits, preparing schedules and responding to auditor inquiries as required.
Confidential
Lead Financial ConsultantERP: SAP
Responsibilities:- Maintained and reconciled payroll-related liability and expense accounts for 4 different companies in SAP accounting system.
- Provided training, and coaching for the payroll department staffs in conducting audits and other audit-related issues
- Ensured compliance with legal, regulatory and professional standards in business transaction processing, recording, and reporting.
- Participated in year-end external and internal audits, preparing schedules and responding to auditor inquiries as required.
Confidential
Responsibilities:- Maintained all general ledger (G/L) functions (AR, AP, PR, Billing, Cash Receipt, and Job Costs in GCS Premiere for multiple business units.)
- Established, maintained, and improved policies and procedures, work processes, internal controls, systems functionality, and implementation of these applications.
- Assisted in the timely preparation of reliable financial reports and statements for internal and external information users.
- Monitored cash disbursements and receipts to allow for maximum utilization of company resources.
- Provided assistance in the preparation of the annual incurred cost submission and forward pricing rate proposals to the federal government.
Confidential , Fairfax, VA
Financial Accountant
ERP: JAMIS, JD Edward
Responsibilities:- Prepared monthly recurring and adjusting journal entries for depreciation, capitalization/retirement, and payroll liability, inter-company accounts.
- Maintained and reconciled payroll liability (120 accounts), inter-company revenue and expense, deferred rent, inventory, and fixed assets accounts.
- Maintained and reconciled JAMIS Job Costs: Cost Allocations, Job Numbers and Projects Setup.
- Prepared cash flow statement for capital assets accounts.
- Processed Equipment Acquisition and Facilities Modification Acquisition Requests (FAR).
- Processed Lease Analysis Forms (FASB 13).
- Assisted in the preparation of incurred cost submissions.
- Assisted in the JAMIS upgrade and tested the system for any internal weakness.
- Prepared monthly roll forward schedules and quarterly audit schedules.
- Analyzed and resolved the Fixed Assets software defects including depreciation calculations and reporting errors.
- Reviewed Business Process for the Fixed Assets Department to identify and resolve any outstanding issues regarding SOX and DCAA Compliances (CAS 404, 409, and SOX 404) and responded to Independent and DCAA Auditor requests for Audit schedules and reports to ensure SOX Compliance
- Worked with Designers and Software Engineers to resolve any defects and design issues discovered during product development for the Fixed Asset Department.
- Collaborated with the Sox Auditors to complete JAMIS functional testing, and user requirements
- Provided top management with monthly variances analysis reports: actual results versus accrual and budget numbers using SQL Queries
- Developed accounting process manual for the Fixed Assets Department.
Confidential, Manassas, VA
Sr. Accountant
ERP: Lawson, Crystal Reports
Responsibilities:- Performed and supervised periodic closing functions, which include monthly closing of Power Plant, and provides recurring and adjusting journal entries for depreciation, capitalization/retirement, inventory adjustment and variance analysis and overhead allocation.
- Reviewed and approved Accounts Payable invoices and checks for processing
- Oversaw the financial statements and reporting requirements for monthly and year end closing
- Maintained and reconciled Working Process Account.
- Maintained fixed asset sub-system to track physical location and depreciable value of items
- Worked directly with Procurement Office to facilitate physical fixed asset inventory.
- Managed annually external audit for plant accounting department by responding to the KPMG PBC list.
- Communicates audit and consulting projects via written reports and oral presentations to top management and the Board of Directors.
- Assisted in the Lawson upgrade and tested the system for any internal weakness.
- Reported tax remittance to local and state jurisdictions. Prepares Annual Form 990 and Income Tax Returns (Federal and State) and prepares other periodic regulatory reports.
Confidential, Herndon, VA
Accounting Consultant
ERP: People Soft
Responsibilities:- Prepared monthly recurring and adjusting journal entries for revenues and expenses for concessions and theaters business units.
- Prepared monthly Balance Sheets, Income Statements, and Cash Flow Statement for concessions and theaters business units.
- Prepared monthly, quarterly and annual revenues and expenses variance analysis of actual results versus accrual
- Maintained and reconciled balance sheet and income statement accounts for concessions and theaters business units.
- Maintained and reconciled service maintains schedules for IMAX Theaters.
- Participates in year-end external and internal audits, preparing schedules and responding to auditor inquiries as required.
Confidential, Herndon, VA
Consultant
ERP: Lawson, SAP
Responsibilities:- Supported the SAP financial system data migration and conversion project.
- Performed data analysis for data residing in legacy financial system (Lawson) to prepare for a major data migration and conversion effort.
- Analyzed and reviewed financial data and file formats, financial transactional files, and system data structures, including comparing data fields available in feeder systems to requirements of new system
Confidential, Auburn Hills, MI
Accounting and Operation Manager
ERP: Quick Book, Peachtree
Responsibilities:- Prepared quarterly financial statements and ensure financial documents are in compliance with GAAP standards and policies. Prepare monthly operation performance reports to top management.
- Established polices for internal control, quarterly review and annual audit.
- Overseen payroll function and manage accounts receivables, payables, general ledger transactions, and collections.
- Prepared payments by accruing expenses; assigning account numbers; requesting disbursements; reconciling accounts. Record and track fixed assets and tracked capital expenditures.
- Contracted and negotiate pricing with customers and vendors.
- Improved inventory control by initiating count sheets and auditing of counts.
- Recruited, trained and kept high quality employees.
- Scheduled trucks maintenance.
- Designed check lists to trace, maintain, and protect company’s physical assets.
- Negotiated future contracts with current and new customers.
- Called on delinquent customers for collections.
- Participates in year-end external and internal audits, preparing schedules and responding to auditor inquiries as required.