Resume

Sign in

Accounting Data

Location:
Ridgewood, New Jersey, 07450, United States
Posted:
November 27, 2017

Contact this candidate

Resume:

JANE OSTROVSKY

** ******* **. 201-***-****

Paramus, NJ 07652 ac3h2r@r.postjobfree.com

SUMMARY

Highly self-motivated, detail and results oriented, responsible, and enthusiastic professional with diverse background in finance, accounting, and reporting systems. Years of experience in systems development and analysis. Able to work independently and collaboratively with individuals at all levels.

SKILLS

Strong computer skills, including MS Office (Excel, Access, Word, Outlook),Visual Basic, VBA, working knowledge of databases, Oracle, Microsoft SQL Server, Hyperion Enterprise, Analyst and Retrieve, HFM, NSP, TOAD, OBIEE,API Wizard.

PROFESSIONAL EXPERIENCE

RICOH AMERICAS CORPORATION

Sr. Financial Data Analyst – Reporting 2009 - Present

Develop, implement and maintain standard reporting utilizing application development and reporting tools including main frame and PC-based database software applications.

Performs trend analysis of income statement and balance sheet accounts to identify and correct any accounting or transaction errors during accounting close.

Follow system functionality and transaction processes to detect any accounting data anomalies, data corruption, or invalid data. Researches any data anomalies to source, quantifies any data problems, and summarizes findings to management in a timely manner.

Prepare supplemental schedules on key accounts impacting gross margin, expense to revenues, and distribution costs; and performs reviews of processes and procedures to identify and quantify profit opportunities and efficiency improvements.

Create ad hoc reporting and analysis and implement custom reporting requests. Provide accurate, courteous and professional service to all internal and external clients. Perform all daily reporting functions with minimal supervision. Provide assistance and technical support to end users to research data anomalies and communicate reporting procedures.

Participate in conversion project of NSP to R12. User acceptance testing, mapping, and data validation.

Extracted, manipulated, and scrubbed data to be used in producing metrics and analyses. Built and maintained complex queries. Delivered metrics and analytic results using custom reports and automated reporting tools.

Worked closely with customers to understand business requirements and translate them into IT Functional Design in order to automate processes.

Created and performed functional testing of all system defects, modifications as well as system enhancements.

Worked closely with Oracle development resources to ensure proper communication of Ricoh business requirements.

Participated in conversion project of Oracle 11i to R12. User acceptance testing, mapping, and data validation.

PS PARTNERS SOLUTIONS LTD 2008 – 2009

Financial Analyst, Assignment for Mass Mutual Insurance Company

Participated in development and enhancement of the 5-year planning model.

Automated, standardized, and simplified areas of corporate and management reporting and Finance/Accounting processes.

TRAVELPORT LIMITED (formerly Cendant Corporation) 2004 – 2008

Financial Analyst

Created ad hoc reports/retrieve files in support of financial reporting process.

Prepared selected footnotes and required supporting documents for the Company’s quarterly and annual reports.

Developed geographical rollup and templates to automate preparation and analysis of Domestic and Foreign BS, P&L, and Cash Flows footnotes.

Reviewed and analyzed monthly results for management, researched variances for balance sheet accounts to ensure financial data is properly recorded in the financial statements.

Performed variance analysis of monthly P&L, including detailed written explanations used in MD&A.

Identified data needs for accounting department and developed monthly account reconciliation matrix using advanced Excel and Access skills.

Prepared schedules and analysis related to financial close ensuring SOX compliance using Oracle, Hyperion and HFM data.

Assisted in producing the quarterly financial information package for Corporate and SEC reporting.

Collaborated with outside auditors during quarter- and year-end audits.

Developed various Government reports, compiling, improving, and automating required information.

Created new reports to simplify data analyses using Oracle Financial Query Discoverer functionality and Hyperion Analyst.

FRUTAROM INCORPORATED 2002 – 2004

Staff Accountant

In charge of month-end and quarter-end book closing activities, including adjusting entries (accruals and prepayments), management reports, and closing of all modules.

Monthly prepared and reviewed cash flow, sales & gross margin, and inventory reports, including variance analysis.

Maintained ownership of the reconciliation process of numerous accounts including Inventory, Fixed Assets, Payroll, A/P, A/R, Revenue, Cost of Sales, and A/R roll-forwards.

Responsible for daily review of bank and loan balances, transfer of funds between banks, and maintenance of related spreadsheets, including daily loan reconciliation.

Prepared and analyzed inter-companies reconciliations.

Recorded and analyzed payroll spreadsheets and month-end journal entries.

Assisted with preparation of monthly Financial Statements and related supporting schedules.

NCO FINANCIAL, INC. 2001 – 2002

Programmer Analyst

Directly involved in the development of the three-tiered Client/Server Universal Collection System application built on COM technology using VB 6 as front end, SQL 7 as back end and MitemView software to capture functionality from terminal-based systems and redeployed it to the VB environment.

Designed database intensive programs, stored procedures, triggers and table structures for financial/accounting applications, utilizing VB 6.0, MS SQL 2000, and Transact SQL.

Wrote business requirements, user manuals, production processes and other technical documentation for existing and future accounting and financial systems.

INSURANCE SERVICE OFFICES, INC. 1999 – 2001

Programmer Analyst

Responsible for the design, development, maintenance, support, and integrity for a number of applications, including a complete reference library of insurance information with monthly updates.

Created Reports using Crystal reports and MS Access Report System.

Led and wrote documentation for production code drops.

Worked with internal and external clients to resolve technical issues and to support and troubleshoot issues with production and testing.

VINYL BUILDING PRODUCTS, INC. 1994 – 1999

Staff Accountant

THE NEW YORK OBSERVER PUBLISHING CO. 1989 – 1994

Bookkeeper

EDUCATION

Bachelor of Business Administration Degree, Economics/Accounting Systems Kiev State University, Kiev, Ukraine



Contact this candidate