SUMMARY:

• Experience in development, enhancement, maintenance, Production support, Data Modeling, Data profiling, Reporting including Business requirement, system requirement gathering
• Systems Skills: Experience gained through Systems Implantation at AES, Alexandria City Public Schools, National Park Service, and Computer Associate (CA), ACOT, Flexible Investment and Confidential, MI which included 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 and making sure the new ERP modules compliance with the different internal controls (NIST Federal, State, Local, and GAP regulations).

TECHNICAL SKILLS:

Accounting Skills: SOX 404, Internal Control, External Audit, GAAP, FAR, CAS 404, FASB Revenue Recognition, Forecasting, Budgeting, Fixed Assets, Project Accounting, Inventory, Job Cost, AP, AR, Cost Accounting and Government Accounting, Monthly Closing, Accounts Reconciliation and Financial Statement

ERP and Database: Utilized database development tools like Visio, SQL Server, and Oracle with strong SQLLawson, People Soft, SAP, SAP BA, PeopleSoft Deltek Cost point and GCS Premiere, JAMIS, JD Edward, CrystalReports, Tyler Munis, Momentum, Time Clock Plus, Java

Project Management: Lead projects from initialization phase from capturing business requirements to final phases

PROFESSIONAL EXPERIENCE:

Confidential, Auburn Hill, MI

System Analyst

Responsibilities:

• Systems integration responsibilities including: business requirements gathering and functional design of the system solution (user requirement and rational database), and system testing, strategy and documenting result and solving associating test results.
• Performs daily audits and maintains manifest tables within (Various Databases) the system to ensure optimized routing and order fulfillment.
• Facilitate analysis of functional requirements and design of technology specifications, working with business/functional personnel, capturing requirements by interactive sessions with department manager and perform route efficiency and rerouting design.
• Serving as business advisor between business partners and IT vendors
• Design, development, administration, and publication of scorecards and metrics for assigned employee, including tracking and trending of issues, root cause identification and corrective action activity.
• Review processing schedules and work orders to ensure inventory levels, budget parameters, and workflow processes support shipment and delivery goals
• Oversees the purchases of parts and materials to ensure inventory levels support production demands

Confidential, Detroit, MI

Sr. PeopleSoft (Contractor)

Responsibilities:

• Analyzed and defined new process for data mapping, accounts mapping, and date migration in order have effective and efficient and secure system.
• Collected and identified objectives, risks, and key controls with current system.
• Co - ordinated with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Acted as a project manager for the PeopleSoft 9.1 implementation from an outdated Legacy system and set up and mapped accounts from legacy system to PeopleSoft applications (HRMS, FMS, SCM, FSCM, HCM and ELM).
• Provide day-to-day technical support and problem solving services to the following three functional areas: HR, fixed asset, inventory, fleet, and accounting for the Accounting department.
• Worked with end-users, business partners, senior management, & suppliers to define business requirements for defect resolution or solution development PeopleSoft applications (HRMS, FMS, SCM, FSCM, HCM and ELM).

Confidential, Bloomfield, MI

Bushiness Analyst (contractor)| PeopleSoft 9.1

Responsibilities:

• Worked with Project managers to divide the project into smaller modules and helping them in defining the time lines based on the development complexities.
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Created the Technical Specification documents and conducting the walk through meetings.
• Worked with System Analysts to identify the proper sources for required data elements and to determine the accuracy of the data Analysts.

Confidential, MO

Business Analyst (contractor)| PeopleSoft 9.2 Update

Responsibilities:

• Participating in the data modeling sessions to understand the data model and providing them inputs based on the existing data to make sure designed model is technically feasible.
• Provided wide-spread PeopleSoft system applications (HRMS,FMS, SCM, FSCM, HCM and ELM) support including resolving end user issues, upgrade testing, business process improvement, solution design, and report writing via query for various functions of the organization.
• Wrote Ad Hoc reports to top management using SQL Queries.

Confidential, Washington DC

Financial System Analyst

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.
• 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. (Tyler Munis, Time Clock Plus, and PeopleSoft).
• 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 (SAP) System.
• Developed documentation and for end users on how to SAP, related applications (MS Visio).

Confidential, Washington DC

Sr. System Analyst (Consultant)

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

Confidential

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
• Maintained and reconciled payroll-related liability and expense accounts for 4 different companies in SAP accounting system.
• Provided, 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.
• 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.
• 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.
• 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

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

Confidential, Manassas, VA

Plant Accounting Department/ Sr. Accountant

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.
• Maintained and reconciled Working Process Account.
• Maintained fixed asset sub-system to track physical location and depreciable value of items
• 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.
• ERP: PeopleSoft

Confidential, Herndon, VA

Accounting Consultant

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.
• ERP: People Soft/Lawson