Oracle Manager

Boris Zelmanov

*** ***** ****** | Staten Island, NY 10306

Home: (718) 980 - 1027 | Mobile: 718-***-**** | E-mail: *********@*******.***

SUMMARY

A detail oriented and solution-minded IT and Financial Systems Manager with an background and strong problem-solving skills looking to contribute to the productivity and growth of an organization.

PROFESSIONAL EXPERIENCE

Coface North America | East Windsor, NJ 03/2008 to 02/2010

(A global Financial Services Company specializing in Credit Insurance, Business Information, Commercial Collections & Factoring)

Oracle Financials System Administrator

Administered the multi-currency, multi-organizational Oracle Financials 11i Modules: AP, AR, GL and CM, including 8 legal entities and 4 business lines; provided full technical support to Oracle Applications Users on the following Modules:

AP (Accounts Payable):

• Support of the Payables Department’s users during the month- and year-end procedures;

• Day-to-day support and troubleshooting of the Payables processes, transfers and setups;

• Creating and maintenance of the sets of reports (Vendors, Payments, Invoices);

AR (Accounts Receivable):

• Support and troubleshooting of the Receivables processes, transfers and setups (lookups, settings, banks, customers);

• Performing design and support of the sets of reports (Customers, Transactions);

GL (General Ledger):

• Administrating and supporting the GL processes, COA values, budgets and balances;

• Performing design, daily support and troubleshooting of FSG reports;

CE (Cash Management):

• Developed, tested and supported the Positive Pay File reconciliation process from bank-to-company on the monthly basis, including design of the interface / conversion mapping (CTL);

• Created and maintained the set of reports for checks reconciliation procedure;

• Provided the full implementation of AP, AR and CM modules during the split of the existing legal entities;

• Coordinated Oracle Financials modules (AP and AR) with the house-written Oracle- based Collection and Insurance system;

• Logging, monitoring and follow up Technical Assistance Requests (TARs) using Oracle Metalink (mostly working with an- offshore Oracle team in India), cooperating with the DBA (outsourcing company);

• Modified and configured existing standard Oracle reports on the server and client sides;

• Participated in the upgrade of the Oracle Financials application from 11.5.9 to 11.5.10.2 including the whole system’s testing and validation;

• Created documentation, administrative procedures, rules, research new products and tools;

Clarendon National Insurance Group | New York, NY 10/2006 to 03/2008

(A US based Property & Casualty Insurance Company)

Oracle Financials System Administrator

Provided 24x7 Oracle Financial System support (using Citrix and RDC ); System Administration: Users, Responsibilities, Organizations, LOV, DFFs Setups; OraFin Administration: Ran monthly GL upload, created solutions, created and maintained users, documents, reports and worksheets; resolved data aggregation problems.

• Developed and maintained the Oracle Financials (11.5.9) Modules (AP, AR, FA, HR, GL);

• Provided technical supported and assistance to Oracle Applications users in business processing of OraFin Modules:

AP: Support on daily basis as well as End Month and End Year troubleshooting, maintain employees and suppliers;

AP: Support and troubleshooting of the Invoices, Payments failure and Checks processing;

GL: Setup and maintain Chart of Accounts segments values, Segment Hierarchies;

GL: Create and maintain FSG reports as well as ADI support;

• Created and maintained Discoverer reports for AR / AP / GL / HR departments, created business areas, folders, customized SQL queries;

• Uploaded and developed data to Performance Management and Treasury Databases using SQL Loader and PL/SQL Developer;

• Participated in a full life cycle implementation project of Oracle BI Apps at the new Company location (after split) including Oracle Client, ADI and Discoverer;

• Involved in the process of solving Oracle Financial application problems in all modules, using Metalink site, dealing with Oracle support, and corrected problems using customized scripts;

• Created documentation and user manuals for the new releases of financial custom reports.

Boris Zelmanov Page Two

Wincor International, Inc. | Brooklyn, NY 06/2003 to 09/2006

(A privately-held Framing contractor and Manufacturer of Wood Doors and Windows)

System Manager

Provided technical support and maintenance of a computerized system for the Company. Managed internal and external security and IT audit activities. Maintained the integrity of financial systems and researched any problems with unbalanced entries, wrong accounting entries, “missing money” in the system, etc.

• Participated in the upgrade of Oracle Financials version 11.5.4 to 11.5.9. Re-designed financial reports, budget security and validation rules. Interacted with an implementation team in a process of upgrade of Oracle Financials Modules (AP, AR, GL, HR). Involved in the transfer of a database from the Legacy System (8i) to the New System (9i). Provided system training to personnel.

• Designed, developed and maintained financial reporting structure for financial services of a company using Oracle FSG, ADI, Discoverer and MS Excel.

• Implemented and optimized office procedures for data entry and production.

APYR, Inc. | Brooklyn, NY 9/2001 to 06/2003

System & Network Engineer

• Maintained security for Oracle Applications and Windows application environments (General Ledger, Accounts Payable, Accounts Receivable and HR) on Windows 2000/XP for this high-end commercial roofing business.

• Supported and updated a computerized system of the business:

Assist DBA on Oracle Application installations;

Provided user support when problems with applications arisen.

• Designed and supported the Corporate Web Site (APYRINC.com).

Created and developed SQL code of a website;

Built queries to output values in a order’s spreadsheet;

• Involved in the process of a negotiation, estimate and planning of construction job’s schedules.

Clarendon National Insurance Group | New York, NY 3/2000 to 9/2001

Programmer / Analyst

• Performed database modeling, using Visio 2000;

• Wrote stored procedures, functions, triggers, packages for the System Admin module and other modules across the system;

• Developed scripts to automate process of loading agent’s data using SQL*Loader;

• Developed and implemented scripts for Oracle Custom Reports;

• Developed Oracle code to support the new web-based upload system for general agents, including the ability to check errors while entering accounting data;

• Performed system testing of the designed modules and reconciliation between expected and production data to ensure accuracy and completeness of results;

• Created documentation and user manuals for the new releases of software, design related images and icons;

• Trained personnel in the use of the new system.

EDUCATION & PROFESSIONAL DEVELOPMENT

MS in Computer & Engineering Science, Mogilev State Technical University | Republic of Belarus

AS in Accounting, Mogilev State Accounting School | Republic of Belarus

Certificate in Oracle Apps / PLSQL Developer - New Age Training | New York, NY

TECHNOLOGY SKILLS

GUI Tools: Oracle BI/Financials 11i (including modules: AP, AR, GL, FA, CE, Treasury), Oracle Discoverer, Oracle Forms and Reports, Oracle ADI, PL/SQL Developer, MS Access, MS Excel, MS PowerPoint, MS Visio, MS FrontPage, Coldfusion Studio, Quick Books

RDBMS: Oracle 7/8/8i/9i/10g Coldfusion Server, Fox Pro

Languages: SQL, PL/SQL, HTML, JavaScript, Coldfusion

Design Tools: Adobe PhotoShop, Jasc PaintShop, Ulead PhotoImpact, AutoCAD

Operating Systems: Windows 3.11 / 95 / 98 / NT 4.0 / 2000 / XP/ 7, VM-Ware, Citrix.

Network: WinSCP, VPN Check-Point, D-Link & Linksys Wireless Routers and Switches.

Hardware: IBM PC and compatibles

Contact this candidate