Resume

Zion M.,

We only do consulting.  No permanent job inquiries please.   Click here for Consulting rates.

BIOGRAPHY

Expert IT Skills

• Databases:           Oracle 8i and Oracle 9i Certified Professional (OCP) +Advanced Replication.  
  NCR Teradata, and MS SQL Server

• OLAP:                 Oracle Express and related tools, COGNOS and SAS

• Tools:                   Oracle development environment and Microsoft tools, TOAD,Rational Rose
                                and UML design

• Case tools:            ERWIN, Oracle Designer-2000

• Comm:                  TCP/IP,  SQLNET and ODBC

• Hardware:             HP UNIX, SUN SOLARIS, NCR UNIX, DEC Open VMS Cluster, Windows
  Servers

• Languages:            C++, Shell, C-Shell, COBOL, PL/1, Assembler and FORTRAN

Education

 

• Bachelor of Science in Computer Science, Brooklyn College, CUNY.

• Diploma in Computer Programming and systems analysis, New York University. 

 

Employment History

Ness Technologies Israel, Billing and CRM Project , Apr-00/Current

Senior Oracle DBA

 

Sr. Oracle DBA and Database Architecture expert in a project dedicated to the design and implementation of a Highway Toll Collection Billing system, on a 1½ a terabyte of database on an EMC disk array.  Oracle 9i and 8.1.7.  - SUN Solaris system.    

Using ERWIN for Logical and Physical database Modeling, and UML methodology and Use Case design approach using Rational Rose Unified Process.  Physical Database capacity planning and data-files mapping.  Database schemas creation based on the logical models.  Oracle Server software installation and configuration. Implementation of Oracle Advanced replication environment and mechanism.  Multiple Database environment over multiple platforms.  Design and implementation of backup and recovery strategy using tools, such as  Veritas Netbackup and RMAN. Database and system monitoring tools.  SIEBEL CRM package setup and interface to the billing system.  Other duties included: Technical assistance and guidance to the development group.  Performance testing and tuning, capacity planning, and database monitoring.  Strong knowledge of  PL/SQL code optimization, and assistiance to  developers with the writing and tuning of PL/SQL code.  Very good experience with different aspects of database tuning.  Responsible for supporting and managing database activity during the

development cycle.  Creating and maintaining the data model and physical integrity of

the databases.

 

Bank Hapoalim, Israel, Data Warehouse Project Jan-98/Apr-01

Senior TERADATA DBA and  Data modeler

 

Sr. TERADATA DBA. For Israel’s largest Commercial Bank. In charge of DBA and UNIX tasks.  Implemented a large-scale Enterprise Data Warehouse system using NCR Teradata database size of 1 Terabyte on EMC disk array.  Served as a technical expert in developing database designs for Data Warehouse.   Strong Data Modeling experience, .  Experience using modeling tools, logical and physical database design using ERWIN.  Maintaining and updating database models, generating or modifying the database schemas  Data Mapping and DWH loading.  Configuration of COGNOS and SAS metadata and query/data access utilities.

Database backup and recovery strategy, database performance and tuning and SQL code optimization.   Using marketing models to support the bank’s marketing campaigns.  Participated in the process of Installation and implementation of Campaign Management and Contact management Systems. 

 

 

Oracle Israel, Professional +Tech Support, Jan-96/Dec-1997        

Senior Oracle DBA/ Consultant

 

Senior  Oracle DBA and consultant, performing design and support for Data Warehousing and OLTP projects technical architecture and Database design tasks utilizing Oracle EXPRESS OLAP technology and Oracle 7.1.4, 8i RDBMS. 

Design of Star schema and multidimensional databases.  System monitoring, troubleshooting and PL/SQL code writing. 

Server installation, and schema generation and development.  SQL Loader scripts and database load tasks.   Benchmarks, Preparations and demonstrations of Oracle technology and related tools, Technical topics coverage at User-Group conventions.  Experience in EXPRESS OLAP and Data Warehousing database architecture and star schema design.

 

VISA Israel, Credit Card OLTP System, Dec-91/Dec-95       

Oracle DBA

 

For Israel VISA, Database designer and DBA developing a Client/Server OLTP Credit Card system responding to over 800 concurrent users and Batch jobs, in an Open VMS cluster.

Using Oracle 7.1.3 environment, from the design phase to production, resulting in a fault tolerant system with over 1 Terabyte of database. 

Duties included: Database logical Modeling and physical design, server installation and multiple schema creation and maintenance on multiple platforms.  Support for the application development team.  Database maintenance tasks, backup and recovery. 

Building and maintaining multiple databases, database and system monitoring and capacity planning, analysis troubleshooting and repair of database objects.  Responsible for supporting and managing database activity during the development cycle 

Support for system Data Conversion effort from the Legacy system.  Planning and carrying-out system load and performance and tuning and hotspot/bottleneck elimination.

 

Wall St. banks,  Citibank, Credit Suisse, Bankers-Trust- Feb-81/Jun-91

Developer/Team lead

 

Team Leader.  Responsible for planning and development of  money-market banking system, Credit risk analysis.  Application and Database design in a Futures and Options trading system.  Interaction with the users.

Wrote design specs.  Development Team management in the implementation of changes and additional features in the application and databases. Other duties included: Define requirements, analyze existing system, find a package, conversion and customization mainly in the Foreign exchange and precious metals modules.