WORK EXPERIENCE:

Confidential, Leawood, KS

ERP BI360 Financial Reporting Consultant

Responsibilities:

• Built financial reporting templates for processing of A/R & A/P aging statements, Significant Contracts to Matket Exposure, Delinquent Contracts to Market, Income Statements and Balance Sheets,
• Created queries in Composer tool to enable users to substantiate numbers in month - end financial statements.
• Built reports in Composer tool and exported the reports to Report Designer tool.
• Scheduled reports on BI360 Publisher tool for automated processing and distribution to recipients.

Confidential, Pleasanton, CA

ERP BI360 Financial Reporting Consultant

Responsibilities:

• Built financial reporting templates for processing of customized Income Statements, Balance Sheets, Expense reports, A/R & A/P aging schedules, Inventory Control reports and Sales Order/Purchase Order reports.
• Created queries in Composer tool to enable users to substantiate numbers in month-end financial statements.
• Built reports in Composer tool and exported the reports to Report Designer tool.
• Scheduled reports on BI360 Publisher tool for automated processing and distribution to recipients.
• Provided financial reporting support on a daily basis to Accounting and Finance departments.
• Provided BI360 training to existing users and new employees.

Confidential, Network Pleasanton, CA

ERP BI360 Financial Reporting Consultant

Responsibilities:

• Created financial reporting templates for processing of customized income statements, balance sheets, expense reports, A/R & A/P aging schedules and Sales/Purchase Order reports in BI360 One Stop Reporting software.
• Created new SEC-compliant financial reporting templates in BI360 software, and compiled data for the transition from tax basis to GAAP for processing financial statements for shareholders and external auditors.
• Provided financial reporting support on a daily basis to Accounting and Finance departments.

Confidential, Westminster, CO

ERP PeopleSoft Financial Reporting Consultant

Responsibilities:

• Created layouts in PeopleSoft nVision for the processing of a consolidated Balance Sheet and Income Statement during month-end close.
• Created queries for users to tie to the consolidated financial statements.
• Created layouts in PeopleSoft nVision for processing of customized Balance Sheets and Income Statements for all business units/subsidiaries. Created queries for users to tie to the customized financial statements.
• Created queries in Composer tool for users to substantiate numbers in consolidated and subsidiary reports.
• Created and maintained trees to reflect organizational and chart of accounts structures.

Confidential, Chicago, IL

ERP PeopleSoft Financial Reporting Consultant

Responsibilities:

• Created new financial reporting templates in PeopleSoft nVision for customized financial statements.
• Performed maintenance to existing financial reporting templates in PeopleSoft nVision that eliminated errors, and maintained processing options to ensure that all financial statements were processing on a timely basis.

Confidential, Network Pleasanton, CA

ERP BI360 Financial Reporting Consultant

Responsibilities:

• Gathered and documented user requirements for financial reporting piece of system conversion.
• Designed and formatted seventy-five financial reporting templates in BI360 One Stop Reporting software.
• Created queries in Composer tool to tie to numbers in month-end financial statements
• Provided financial reporting support on a daily basis to Accounting and Finance departments.

Confidential, Chicago, IL

ERP PeopleSoft Financial Systems Consultant

Responsibilities:

• Performed end of year 2010 account reconciliations for balance sheet accounts.
• Retrieved documentation and performed analysis to support and substantiate end of year balances.

Confidential, Chicago, IL

Payroll Accountant

Responsibilities:

• Audited employee timesheets from Midwest census offices to ensure accuracy and completeness.
• Entered timesheet data into PeopleSoft payroll system and conducted daily batch processing.

Confidential, Oakbrook Terrace, IL

IT Financial Systems Analyst

Responsibilities:

• Investigated and resolved all issues encountered with software applications in the Tax department.
• Created Business Continuity/Disaster Recovery Plan for Tax Department.
• Managed system conversion issues relating to recent software conversion from CORPTax to TTI.

Confidential, Chicago, IL

Senior PeopleSoft Financial Systems Analyst

Responsibilities:

• Designed financial reporting layouts and processed all month-end, quarter-end and year-end financial statements and budgeting financial statements via nVision reporting module of PeopleSoft.
• Constructed and processed queries via Query module of PeopleSoft in order to substantiate numbers displayed in all month-end financial statements and budgeting financial statements. Provided functional support to the Accounting and Finance departments regarding financial statements and the general ledger.
• Provided support to Accounting and Finance departments with financial analysis, budgeting and forecasting numbers, account reconciliation and variance analysis and investigations of anomalies in data.
• Created and maintained all PS chartfields, timespans, reports, report books, scopes, layouts and trees.
• Installed modifications to financial report templates improving the processing efficiency of month-end financial statements by 50%, thereby cutting nightly processing time from 8 hours to 4 hours.
• Created and maintained general ledger run controls for allocations, combination-edit rules, consolidations, eliminations, and translation/revaluation of foreign currencies.
• Managed all SDLC PeopleSoft projects for the nVision financial reporting module. Wrote business requirements, acceptance and regression test plans and test cases, and executed the test cases for all new software releases, customizations and process improvements to the nVision module.
• Created PeopleSoft training manual and provided training for users in Accounting and Finance departments.

Confidential, Hinsdale, IL

Quality Assurance Analyst

Responsibilities:

• Wrote design specifications and performed QA/acceptance testing for the enhancements to the general ledger reporting process for Confidential software package.
• Performed QA/acceptance testing for enhancements to “bid and offer transactions of unit trust accounts.