Accounting Manager

Sonya Skinner

Farmington Hills, MI *****

Home: 248-***-****, Email: *******@***.***

LinkedIn Acct: https://www.linkedin.com/in/sonya-skinner-0ba27415a/

Professional summary

An Accountant and Information Technology Database Analyst with over 10 years of Software Development Life Cycle experience. Working Experience with Software application implementation projects, testing and maintenance . Policy and Procedure creating, System Test Script writing, Test Plans, Business requirements gathering, system issue troubleshooting of defects .Accounting and Financial Statement Audit Support. IT system security administrator for Oracle and PeopleSoft systems. Supervisory experience for Fixed Assets Accounting, Management and ERP systems processes. Liaison between Business Owners, IT Staff, Department Heads and Vendors.

Education

Central Michigan University - Mount Pleasant, MI

Graduated in 1990---Bachelor of Science: Management and Accounting (GPA 3.24)

Wayne State University: Under Graduate /Post Graduate Accounting Courses(transferred to CMU)

Skills

Financial Statements Audit Support

Customer/End User Collaboration Skills

System Implementation Support-Agile Methodology

Assign System Security Roles and Responsibilities, Create Codes and Categories

Create Test Scripts and Perform Testing

Accounts Data Analysis/Issue Resolutions

Analyzing and Troubleshooting system issues

Microsoft Office Suite, Remedy, Visio/Share Point/HP Quality Ctr.

Test Oracle Financial, HRMS /Payroll Modules-Agile Methodology

Accounting /Accounts Reconciliation

ERP Security and Functionality Testing/ HP Application Life-cycle Management (HP ALM)/HP QC

GL Journal Entry/Report Analysis

Root Cause Analysis to Resolution

Oracle Systems Admin. Role/ Security Testing

Financial Accounting CAFR reporting

General Ledger and Fixed Assets Training

Work History

Dec 2017 to Present Home Care Provider for Parent (Post Surgery Injury and complications)

Trained by Beaumont Hospital and Henry Ford Hospital for TPN Infusions and Wound Care and other tasks

Jul 2017 to Dec 2017 Application Systems Analyst - Level 2

Accenture Financial Services /Clarus Group, Inc – Remote /Work at Home (5 months)

Part of Level 2 Support team performing tasks to manage a newly implemented Accounting System

Worked on process for the post implementation project, completed for the US Air Force's Defense Enterprise and Accounting Management Systems (DEAMS)

Utilized Clear Quest a toll that is used to track Support Tickets and Defect/Testing artifacts

Analyzed and worked on DEAMS Post Production Support(PPS) tickets created and tracked in Clear Quest to close and send updates to Management and End Users

Used Virtual Machine to access content stored for viewing of records and providing system archived data and Clear Case as a repository for contract deliverables, codes, scripts, designs etc.

Utilized the Oracle Procurement Purchase to Pay process, General Ledger Module and Discoverer reports to assist with resolving accounting issues reported within Remedy (Rational Clear Quest)

Utilized several Training instances or environments to Test or re-create issues reported for analysis

Learned basic PL/SQL scripts when trained by other Level2 staff. Created scripts for resolving system issues or updates

Ran SQL basic scripts to pull data and review it for resolving accounting and related system issues

Created Oracle Requisitions, General Ledger Journals Entries, and reports in Test Environments for Testing and troubleshooting Tickets. Utilized Test Scripts for testing efforts

Analyzed accounting data for General Ledger transactions created within the system, to discover the root cause of issues reported

Performed testing with Purchasing Module for Procurement processes, General Ledger transactions and ran accounting reports to discover root cause for issues, prior to updating Clear Quest

Updated Remedy System (Clear Quest) support tickets when resolutions were presented for review by Management

Wrote Justifications for Defects or Change Management as it related to system issues

Aug 2016 to Apr 2017 Accountant IV /Business Analyst

City of Detroit, Office of Departmental Financial Services – Detroit, MI (8 months)

Accountant IV position performing Business Analysis tasks within the Special Projects Unit of Finance

Assigned as temporary staff for facilitated meetings with Department Directors and staff to discuss or analyze reports, accounting transactions, transfer funds, setup P-Card accounts and discuss their business requirements

Cross trained to create and monitor Procurement Requisitions and analyze prior transactions which were not pushed through the system for payment properly

Edited and mapped transaction details which interfaced from a legacy system incorrectly for upload

Worked on a City-Wide Project to identify equipment which was assigned, disposed, or missing for reconciling and updating inventory records

Cross trained to work with 6 Departments for their Financial Services, Budget Review, and Financial reporting needs

Trained Department staff with running financial reports and updated procedures

Tested functionality for creating requisitions online and when errors occurred within Oracle Cloud

Attended Budget Reviews with Department Heads when Management assigned the task. Prepared reports for review and approval prior to attending Budget Hearings.

Created the Standard, Encumbrance, Cash Receipts and Budget Journal Entries to record accounting transactions for 6 City Departments. Attended Oracle Cloud Training Courses

Jul 2009 to Aug 2016 Program Supervisor Accountant /Business Analyst for Fixed Assets

Detroit Public Schools – Detroit, MI (7yrs)

Project Supervisor and Accountant performing Business Analyst tasks for District-wide Management of Fixed Assets and a system implementation project

Finance and Grants Department SME for reporting on District-wide purchased equipment capitalized and grant funded tracked assets.

Reconciled Asset transactions for purchased and missing assets annually, to properly manage assets assigned to various locations and to assist with locating stolen assets

Reviewed and reported for impairments and depreciation schedules annually for preparation of Audits. Discovered when system errors caused depreciation to be over or understated

Worked in the Strategic Management Systems Unit performing Business Analytical tasks and assignments for Support Tickets, and special projects related to PeopleSoft transactions

Created the District’s Finance Department, Asset Management Policy and Procedures which was approved by the Office of the CFO, Auditors, and the Emergency Manager of the District

Utilized Share Point for document storage check ins/outs.

Performed system category, accounting codes, Role and Responsibility assignments, data migration, data mapping and system functionality testing

Collaborated with IT and others to discover workarounds for business processes as it relates to system functionality and reporting requirements

Supervised the physical inventory process performed by Field Audit teams and updated system

Created all Fixed Assets sub-ledger transactions, GL Journal Entries, Trial Balances, Adjustments, Depreciation Schedules, Reports, Notes and Accounting Schedules for the District’s Comprehensive Annual Financial Report and assisted with Corrective actions analysis

Interfaced and mapped transaction details for fixed assets from a legacy asset management system

Gathered Requirements and facilitated JAD and Business Owner meetings for system implementation and helped to determine what was a fit or gap

Created, Reviewed, and met with stakeholders to complete the process for Deliverable approvals and when it was necessary to modify plans

Evaluated test plan, made risk-based testing recommendations, and provided test estimations

Created and provided Managers with a Requirements Questionnaire to thoroughly assess any unique business requirements

Analyzed project defects and made recommendations for future improvement to procedures. Worked with Oracle and IT Technicians for resolving system issues. Conducted meetings to communicate roadblocks to resolution process

Sept 2006 to Jan 2009 Software Quality Assurance Analyst III

Kelly Services, Inc. – Troy, MI (3 yrs.)

Performed testing for Oracle Financial Modules and cross trained to test HRMS /Payroll Module

Interfaced and mapped transaction details for fixed assets over from Oracle Accounts Payable

Provided Management with test estimate plans, defined overall project-level test strategies, test plans and modified as needed. Provided Test Summaries for approvals with screenshot support

Defined test plans for all items to be tested manually and with automation on occasion

Performed manual system security testing to validate that processes remained intact post upgrades and system changes. Reconciled and tied test cases back to user stories for full trace-ability

Provided Business Owners with Test Summary and met prior to testing for approvals and concerns

Analyzed project bugs and made recommendations for future improvement for procedures. Worked with Oracle, Developers and DBA’s for system bug fixes and other matters

Ensured bugs were communicated clearly to Management, Developers and business partners as well as tracking the bugs to completion. Used HP Application Life-cycle Management (HP ALM) for requirements, test logging and learned automated testing (2 months usage) building and recording

Collaborated with Subject Matter Experts and IT Staff to identify or refine test requirements and create workarounds and wrote weekly status reports to provide project manager with updates on test status

Attended meetings to communicate potential roadblocks to the testing process and to assist with removing those roadblocks or to modify the testing effort as needed.

Apr 2005 to Sept 2006 Business Analyst (Information Systems Division)

CareTech Solutions Inc (Mount Clemens Hospital) – Troy, MI (1.5 years)

Business Analyst leading support initiatives for Oracle Financial Module processes and reporting

Reviewed Accounts Payable processes, transactions, documents, and entries to resolve system issues

Assisted Finance Staff with issue resolutions and processes for Accounts Payables, General Ledger and Fixed Assets Modules (others with Team members by request)

System Admin for Financial Modules of Oracle, assigned responsibilities, ran diagnostic reports

Created Oracle FSG reports, ran SQL reports with TOAD for Audits, and created Noetix reports

Performed testing based on Test Plans to resolve Finance Department Oracle related issues

Performed manual system security testing to validate that processes remained intact post upgrades and system changes. Reconciled and tied test cases back to user stories for full trace-ability

Facilitated and tracked user acceptance testing for fixing system glitches, bug fixes and upgrades

Analyzed system issues then submitted potential resolution for review by Management and Oracle

Conducted meetings to communicate potential roadblocks to resolution processes and to assist with removing or modifying the project plan as needed and finding workarounds for processes as needed

Nov 2002 to Apr 2005 Sr. Accountant/Business Systems Support Specialist

City of Detroit -Detroit Resource Management Systems – Detroit, MI (3 yrs.)

Project Manager for leading an Oracle Asset Management Implementation and upgrades

Assisted Departments with system transaction issues post implementation

Interfaced and mapped transaction details for fixed assets over from Oracle Accounts Payable

Assisted Consultants with completing original training material and created job aids

Gathered Requirements and facilitated JAD and Business Owner meetings to discuss processes

Created, Reviewed, or modified deliverables, then met with stakeholders to receive approvals

Defined overall project-level test strategies. Defined test plans for all items to be tested manually

Met with Business Owners to complete a requirements questionnaire, reviews, and approvals during the system implementation project. Discussed system or process workarounds as needed

Performed manual system security testing and validated that processes remained intact post upgrades

Facilitated and tracked user acceptance testing for fixing system glitches, bug fixes and upgrades

Worked with Oracle staff for system bug fixes and tied accounting transactions to key reports

Presented issues and resolutions to all levels by using system demos, screen shots, and reports

Ensured that defects were communicated clearly to development team and business partners

Wrote weekly status reports to provide project manager and leadership with updates on test status

Attended Project Leads meetings to communicate roadblocks to resolution process and to assist with removing those roadblocks or to modify project plan as needed.

Reviewed and cleaned up data for uploads from the legacy system prior to importing to Oracle

Worked directly with team members from ‘DREAMS’ unit, IT staff, Compuware, and City Departments to upgrade and provide post implementation support for the ERP Oracle system

Contact this candidate