Oracle developer

Olexandr Bily

CONTACT INFORMATION

Phone: 908-***-****

E-mail: ****.*****@*****.***

SUMMARY

• Oracle Developer with over 11 years of experience developing in IT industry.

• About 5 years of experience developing extensions, upgrades and implementation of Oracle e-Business Suite (R11 and R12) to meet customers' needs. General Ledger, Accounts Receivable, Accounts Payable, Order Management, Fixed Assets, Purchasing, Cash Management, Treasury, Human Resource, Inventory, Work in Process, Oracle Enterprise Asset Management, Projects, XML, Oracle Workflow, Application Object Library etc.

• 2 years of Discoverer 4i Administrator and User Experience, including maintenance of Business Area and Work Book.

• Over 2 years of experience in writing Oracle ETL procedures and create/schedule jobs.

• About 2 year of experience in Excel VBA and SQL Server 2005-9.

• Strong experience in PL/SQL coding using packages, stored procedures and triggers, Transact-SQL, dynamic SQL, autonomous transactions, etc.

• Background in installing and administering Oracle e-Business Suite R11 and R12.

• Familiar with System Development Life Cycle.

• Hands-on experience in BEA WebLogic.

• Strong problem-solving and analytical skill.

• High motivation, experienced team player.

• Lifestyle: never miss a new challenge to solve the business needs.

SKILLS

Oracle Tools: Oracle Forms 6i/10g, Oracle Reports 6i/10g, Oracle Workflow Builder, SQL Developer, SQL Loader, Discoverer, Oracle Application Implementation Methodology;

Other tools: TOAD, PL/SQL Developer, Eclipse;

RDBMS: Oracle 9i up to 11g – professionally; ACCESS, MSSQL, SQL Server 2005-8 – practice experience;

Programming Languages: PL/SQL, VBA, UNIX Shell – professionally; C++, Java, Perl, PHP - practice experience;

Operation Systems: UNIX (Linux, FreeBSD, Sun Solaris), Windows XP, Windows Vista, Windows 2000;

ERP: Oracle e-Business Suite 11.5.9.* up to R12

WORK EXPERIENCE

08/2005 – 03/2010 Oracle developer, Kvazar-Micro, Zaporizhzhya, Ukraine

www.kvazar-micro.com (References available upon request)

Installed, administrated and implemented OeBS (Oracle e-Business Suite) R11 and R12. Participated in the development of API for creating EXCEL reports for Oracle E-Business Suite using the HTML, XML output and XML template without using Publisher.

Duties performed:

- Development: Oracle reports, forms; PL/SQL Programs, stored procedures, triggers, etc.; Unix shell scripts, EXCEL macros (VBA), SQL Server stored procedures, BEA WebLogic.

- Administration UNIX systems (Linux, FreeBSD) and Oracle e-Business Suite.

PROJECTS:

• 04/2009 – 01/2010 Implemented of «Oracle e-Business Suite R11» in JSC «COMSTAR» www.comstar.ru

COMSTAR – United TeleSystems (COMSTAR-UTS, LSE: CMST) is the leading supplier of integrated telecommunication solutions in Russia and the CIS.

My duties:

- Reports, PL/SQL programs development (TR, PO, INV, TR, GL, OM, AR)

- Forms customization (PO, OM, AR)

• 09/2008 – 03/2009 Implemented of «Oracle e-Business Suite R12» in Interpipe Company www.interpipe.biz

The Interpipe product portfolio is focused on creating value-added and technological advantages for companies mining and transporting oil and gas.

My duties:

- PL/SQL, Java program development (OPM, HR, EAM, PA)

- Head of Development team

• 06/2007 – 08/2008 Implemented of «Oracle e-Business Suite R11» in JSC «EuroChem» www.eurochem.ru

EuroChem is the only chemical company in Russia which incorporates mining and processing enterprises as well as logistics companies and distribution network in various regions of the world.

My duties:

Tuned Reports, Forms, PL/SQL programs and CUSTOM libraries (Modules: OPM, FA, EAM and AR).

Developed Form in Oracle Enterprise Asset Management in Oracle e-Business Suite:

o Created tables, triggers, PL/SQL stored procedures

o Used API for reserving and releasing material position in system

o Created interaction with the modules ‘Work in Process’, ‘Inventory’, ‘Order Management’ and ‘Oracle Process Manufacturing’

Developed several reports (PDF, RTF, Excel, eText) for Oracle BI (Business Intelligence). The following are few of the reports:

o Summary Balance Sheet

o Detailed Balance Sheet

o Manufacturing Department detail

• 09/2006 – 05/2007 Implemented of «Oracle e-Business Suite R11» in JSC «ROSNO» www.rosno.ru

ROSNO Group is one of the largest insurance groups in Russia. It comprises the universal federal-scale insurance company OJSC IC ROSNO and its subsidiaries: OJSC ROSNO-MS, OJSC RC ROSNO Centre, ICJSC Medexpress, Allianz ROSNO Asset Management, and SLC Allianz Ukraine.

My duties:

o Checking, installing and modifying several Forms, Reports, PL/SQL program and Discoverer reports (Modules: AR, AP, GL and CE). Coded some Shell scripts for SQL*Loader and UNIX system. Developed interface with a lot of analyst from Accounts Receivable to INFIN system.

o Assistance in installation and administration of «Oracle e-Business Suite R11». Created backup, “Everyday” and “Week” clone.

• 08/2005 – 08/2006 Implemented of «Oracle e-Business Suite R11» in JSC «Mobile TeleSystems» www.mts.ru

Mobile TeleSystems OJSC (MTS) is the largest cellular phone operator in Russia and the CIS.

My duties:

o Designed and developed reports, PL/SQL programs and CUSTOM libraries (Modules: INV, HR, FA and GL).

o Designed and developed new module FP (Functional Planning): creating new forms, tables, views, triggers.

o Coded and tuned large PL/SQL stored procedures more than 20 thousand lines of codes and enhanced the performance through the fine-tune of queries and creation of appropriate indexes, tablespaces and rollback segments.

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, Oracle Forms and Reports, OLTP, OLAP, Analytical Functions, Collections & Bulk Collections, Arrays & Varrays, Autonomous Transactions, Table Functions, Materialized Views, XML, Excel VBA, UNIX shell, Java, SQL Server.

04/2004 – 08/2005 Senior Software developer, JS Bank «AvtoZAZbank» , Zaporizhzhya, Ukraine

Participated in the development of complex banking system based on BD Oracle 9i.

Environment: Oracle 9i, SQL, PL/SQL, Oracle Forms and Reports, OLTP, OLAP, Analytical Functions, Collections & Bulk Collections, Arrays & Varrays, Autonomous Transactions, Table Functions, Perl, C++ MySQL, UNIX shell, DHTML.

05/2001 – 03/2004 System Administrator, «IT-Ukraine» Ltd. , Zaporizhzhya, Ukraine

Environment: UNIX shell, PHP, Perl, PosgreSQL, MySQL, MS SQL Server, DHTML

Equipment: automatic telephone system

10/2000 – 05/2001 Software engineer, «Inet» Ltd. , Zaporizhzhya, Ukraine

Developed and supported web sites for clients.

Environment: Perl, DHTML, JavaScript, PL/SQL, PosgreSQL, UNIX Shell

07/1998 – 03/2000 System Administrator, «Trans European communication» Ltd. , Zaporizhzhya, Ukraine

Environment: DHTML, Perl, MySQL, UNIX Shell

EDUCATION

1998 - Bachelor’s degree in Computer Science, State Technical University, Zaporizhzhya, Ukraine

Contact this candidate