Project Manager Oracle

Oleg Golden cell:267-***-****,home 215-***-****, voicemail775-***-****

Professional To obtain a position as IT Database System Professional

Objective Oleg is an experienced IT professional with specialization in

architecting, designing and developing database software systems.

Recently worked as a a senior database developer and technical project

lead at Merck & CO, Pennsylvania, US .

Key strengths are detailed understanding of technology, knowledge of the

full software project lifecycle and extensive ETL and database

development experience.

Professional ORACLE:10G Advanced SQL,PL/SQL, Certified Oracle University master DBA

Certifications: ,

Oracle Discoverer, Oracle AIS and other advanced courses diploma.

Microsoft: MSCE, MCP of MSWindows2005 Server.

Villanova University Lean Six Sigma, INFORMATICA 7.1.3

Databases/ Tools Informatica,ORACLE Server 8,8i, 9i, 10G, INFORMATICA,ORACLE Warehouse

Builder, Workflow, Portal, Discoverer, MS SQLserver2000,2005, MySQL,

Forms and Reports OEM, Cognos "ReportNet", Toad, Sql Navigator,Sql

Analyzer,Business Objects,DB2 UDB

Programming RDBMS:SQL (Proprietary, ANSII),PL-SQL(with new 9i,10g techniques &

Languages advanced packages),XML,PHP,

OS:PHP, Perl, Shell, C#, Basic Java, Install Shield, VB, VBScript,

VB.NET, JavaScript

Applications and Informatica,ORACLE Warehouse Builder, Workflow, Portal, Discoverer,

Software Suites Hyperion /Brio Intelligence, Business Objects, Cognos, Apache

Methodologies: Informatica Rapid ETL, Structured Systems Analysis and

Design, UML, Rational Unified Process (RUP), Oracle Custom Development

Method (CDM), Oracle Data Warehouse Method (DWM) Oracle Project

Management (PJM) and Oracle Program Management (PGM).

Miscellaneous:

Code/Documents Change/Solutions Management: Documentum, SharePoint,

Rational Clear Case. Clear Quest,Unix/Linux user,basic admin,Smit

(AIX), vi, emax, apache, grep, awk

Experience 1/2006 - Present Time, Atnaza., LB current client Merck & CO

Position: Senior ETL, Oracle Developer. System Architect .

Designing an enterprise ETL and database compliance integration system

Designing complex data governance and global ETL compliance test system

using PL/SQL and Perl for OS files tests.

Technical lead, project management and expertise as IT SME with a

nation-wide Field Sales Representatives Compliance system with complex

data model and application logic with the responsibilities for

development,maintenance and operation support on site and offshore.

Working closely with Merck SLC, Center of Excellence to provide for Data

Modeling, Data Standards, Data Governance; Data deliver methodology,

Best Practices and Services within Enterprise Architecture and Process

Excellence for the project

Working with standard tools like Quest Software Toad Developer TM

suite, including Toad TM, Benchmark Factory for Databases TM, Quest Code

Tester For OracleTM,Sql Navigator,Oracle Sql Analyzer TM, Oracle Query

Reporter TM, Peoplesoft TM .

Performing detailed analysis of the ETL processes including Oracle

stored procedures and packages, Informatica mappings,Kshell scripts, VB

, MSAccess and Cognos ReportNet.

Technical and Business Analysis in major knowledge transition processes

of maintenance and operation support the offshore including DATAMIRROR

with DB2 UDB.

Design, development and implementation of complex ETL Processes with

Informatica Design, development and implementation of complex ETL

Processes with OWB 11 G and Informatica 8.6., Application and tuning for

Source Qualifiers, Lookups, Workflows and other SQL and ETL Structures

as well as Oracle database Performance Tuning and ORACLE PLSQL 10G.

Performed database tuning using Explain Plan, hints, UTLBSTAT/UTLESTAT,

Toad, Oracle stats pack, ADDM, AWR and Enterprise Manager. Performed

de-normalization of Database models for optimal Datawarehouse

performance.

1/2005 - 1/2006 Clal Insurance and Investments Company Israel, Tel-Aviv

Position: Database and ETL Developer & Analyst, Application DBA:

Design, development and implementation of complex ETL Processes with

Informatica 7.1.3 for Insurance and Financial departments, calculating

risks management, fixed income profit, co-insurance and flexible tax.

Performing Application and DB (Oracle) Tuning for Source Qualifiers,

Lookups, Workflows and other SQL and Informatica Structures.

Development of numerous SQL and PLSQL application programs in the Oracle

10G environment including Regular Expressions and Analytical Functions.

Transfer of complex COBOL programs into Informatica and Brio SQR

Interfaces.

Preparation, implementation and support of the numerous UNIX (SUN,

LINUX) jobs and interfaces.

7/1998 - 3/2004 Israel Local Authorities Data Processing Center LTD,

Petach-Tikva

Position: Database and ETL Developer & Analyst:

Design, development and implementation of a complex PLSQL multi-packages

application as a part of Data Warehouse ETL for all parts of the

City-halls custom ERP system:

Education, Financial Services, Payroll, Utilities Management, Revenue

and Property Management,etc.

Design and implementation of a national-wide Data Warehouse Project for

Israel Local Authorities, based on ORACLE Server 8.i, 9.i Enterprise

Edition using partitioning, OLAP, advanced replication, XML loading and

retrieving, collections and objects, distributed package systems

modeling and other advanced options.

Designing and developing of an Automatic Processes and Information and

database management systems in ERP and CRM environments with tools of

Oracle ETL tools like Workflow, Warehouse Builder and also OEM,

Discoverer with IAS, Apache, PHP, Portal with help of the programming

environments like SQL, PLSQL, JDeveloper, Forms and VB6.0, Cognos

"ReportNet", Business Objects 5.1

Design and implementation of a complex distributed database network (in

about 20 cities) including networking, backup, recovery and data

distribution as well as issues of Database and Application security:

Virtual Privet Database, Label Security, Apache IP and Site Secure

Access, Single Sign On.

System programming at Client-Server environment for heterogeneous

platforms by means of several programming and scripting languages.

Application support of Financial system, complex tax and payroll

calculations.

Design, development and implementation of various network scripts

(NT/Unix) and maintenance of complex network system including NT,

Windows 2000 and UNIX .

Education and 01/2010 Merck & CO

Training FDA Guidance on Computer Systems

PC7044

MRL Computerized Systems Used in Clinical Investigations Awareness

GC4006

12/2009 Merck & CO

Merck Guidance on Computer Systems

PC7036

09/2009 Merck & CO TIS PeopleSoft 8.8 WBT

05/2009 LB Skillsoft Project Manager course

08/2008 Villanova University Lean Six Sigma Certification Program

03/2008 Merck & CO TIS PEOPLESOFT 8 WBT

12/2007 Merck & CO Process Management course

09/2007 Merck & CO Clear Quest course

02/2007 Merck & CO COGNOS TIS STANDARD RPT WBT

01/2007 Merck & CO COGNOS WEB REPORT MMD PRO

05/2005 SLA College Informatica 7.3

09/2004 John Bryce College Advanced System Analysis with UML approach

12/2003 John Bryce Oracle University PLSQL IV: Advanced Programming

course.

2002-2003 John Bryce Oracle University

Oracle DBA 9i Track: Foundation I, II, Database and SQL Tuning, advanced

courses.

2000-2001 John Bryce Oracle University

Oracle DBA 8i Track: DBA1-DBA3,Database and SQL Tuning, advanced

courses.

1998-1999 Hi-Tech Microsoft: MCSE NT4.0(+ TCP/IP4.0) + W2K Server(MCP)

1994-1997 Tel-Aviv University Tel-Aviv

B.A., General, Social and Cognitive Sciences

1990-1991 Haifa University Haifa

Academic Preparation Course(Mechina)

1986-1989 Gomel Technical Road Building College

Technical Certificate in Heavy Machinery

Keywords:

ORACLE, PLSQL, ETL: OWB (ORACLE WAREHOUSE BUILDER), DISCOVERER,

INFORMATICA, SQR, SQL

Other:

Excellent interpersonal skills

Reference available upon request

Contact this candidate