Resume of Ruvin Gitelman

Address: *** **** ***, ****** ******, NY 10301

Phone: 1 (347) 203 – 3215

Email: acte9x@r.postjobfree.com

Databases: MS SQL Server 7 - 2014, Pervasive 10, Oracle 8i/9i, SYBASE-10/11, UDB2 5.0 / 7.0, MS ACCESS

Languages: TSQL, PL / SQL, EasyTrieve, Power shell

Tools: Info Pump, Platinum Erwin 4, SSIS, SSRS, SSDT, SSMS, SSAS, Info Maker Report, Crystal Report

OS Windows 4-2012, UNIX / Red Hat Linux 6.x

Mainframe: DB2, VSAM, COBOL II, SQL for DB2, CICS, SYNCSORT, File Aid, DB2 Utilities LOAD, REORG, RUNSTATS, IMAGECOPY, BMS.

Experience:

08/99 - present Major Reinsurance Company, NYC

Data Base Administrator

Participated in development, implementation and support of the Underwriters, Claims, Accounting, HR, Audit, Broker DataMart’s

and Data Warehouse systems.

Database administrator activities:

Create and schedule maintenance jobs - rebuild indexes, table, shrink databases / files.

Performance, Tuning, Query Optimization using Performance Monitor, SQL Profiler.

Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space issues.

Implemented the Clustering, Database mirroring, Replication, HA configuration and Disaster Recovery scripts and

documentation.

Performed logical and physical design of the MS SQL Server, Sybase, UDB2, Oracle and MS Access databases using Erwin

Responsible for the databases creation and support (creation of the table spaces, tables, view, indexes, stored

procedures and triggers), links between MS SQL Server / UDB2 / Sybase databases.

Created and implemented security for the new and existing databases users/system level privileges, user profiles, password management, object - level privileges and scripts to restore security on different hosts.

Create easytrieve scripts to extract data from the online BT files, create the SSIS projects and SQL scripts to

Populate databases with extracted data.

Manage, administer and support troubleshooting administrator reports (SSRS).

Implemented standalone physical server layouts and in cluster environment

Created and implemented scripts, procedures, triggers, management services / utilities for transferring data databases, table spaces, user’s schemas, tables between RDBMS.

Export / Import and Loader Utilities for Oracle databases and for transferring data to the MS SQL Server using scripts and Oracle Enterprise Manager.

Build backup tasks:

For Oracle databases - using Recovery Manager Tool RMAN / Export Utility full / incremental / cumulative options;

For the static Sybase - full backup; for the OLTP MS SQL Server - full / incremental / differential backup procedures;

For the static UDB2 - table space backup procedures

Implemented for Oracle logical database layouts for DATA, INDEXES, RBS, TEMPS and USERS table spaces

01/99 - 08/99 CONCREATEMEDIA NYC

Consultant / Database Administrator / WEB Designer

Database activities for the on-line and batch trading system:

Created Oracle and MS SQL server databases created tables, view, indexes, Created Stored procedures and triggers

Database performance and tuning

Set up publisher / distribution MS SQL server environment

Create and schedule Loader Oracle and DTS MS SQL Server scripts to transfer data between databases

Database performance and tuning

Documented new and existing databases, using Platinum Erwin tool

Created the following WEB pages using ASP scripts. :

Online Registration form; Symbol/Team Look up page; Trading Activities; Trading Form populated and unpopulated ; Transaction Conformation Report; Trading History; Competitor Summary Page.

02/98 - 12/98 American Express Bank NYC

Consultant / Programmer Analyst

For the conversion project from Mainframe to the client /server Payment Switch system:

Install Oracle server; created test and production databases, implemented security system

Created new and modified existing stored procedures; created triggers to enforce referential integrity

Create scripts to transfer data from the FTP server; create scripts to load database from the files using full and delta algorithm. The system was developed in C++ / SYBASE 10 / Oracle 7.3.

Participated in the Year 2000 Mainframe pilot project.

Created Batch and On-line test environment for CPS/NYAC system, Payment Switch system, Cash Management System and Loans system.

Create programs to bridge expanded and non-expanded files

06/97 - 02/98 CITIBANK, NYC

Consultant / Programmer Analyst

Participated in Planning, Analysis, Design and Implementation of the conversion of the CITIADR Mainframe Trading system on-line and batch from IDMS to DB2. Performed the following tasks: redesign on-line screens; program modifications; logical and physical design of DB2 Database; optimized DB2 SQL using EXPLAIN.

01/97 - 06/97 The Depository Trust Company, NYC

Consultant / Programmer Analyst

Participated in Design, Coding and Implementation of the Mainframe CUSTODY system (on-line and batch).

Performed the following tasks:

Logical and physical design of DB2 Database;

Optimized DB2 SQL, utilizing EXPLAIN;

Identified and resolved system malfunctions using Abend Aid, EXPEDITER, ACCESS DB2, PLATINUM DBA tool;

Population of databases using LOAD utility. The CUSTODY system developed in DB2, CICS, and COBOL II.

06/96 - 12/96 CITIBANK, NYC

Consultant / Programmer Analyst

Participated in New Jersey bank expansion project design and implementation for the OVERDRAFT system.

Project included the following modification on - line and batch for the OVERDRAFT system:

Design on-line screens to accept new NJ branches;

Modification of the VSAM files and various databases IDMS, ADABAS, and DB2

08/95 - 06/96 Pershing division of DLJ, NJ

Consultant / Programmer Analyst / Data Analyst

Participated in planning, analysis, design and implementation of the conversion “Security Master File” and “Account History” file from ADABAS to DB2. Conversion of the following systems: Trading, Broker View, and Account History from ADABAS to DB2. The systems were developed in DB2, CICS, and COBOL II. Conversion of the “Account History” systems from Mainframe to the VB4 / Sybase10.

Responsibilities included:

Logical and physical design of the Account History Database; screens design VB-4;

Create jobs to extract production data from DB2; created stored procedures to populate Sybase database with the extracted Mainframe data.

11/94-08/95 Chase Manhattan Bank, NYC

Senior Programmer/Analyst

Participated in Planning, Analysis, Design and Implementation of the conversion of VISA and MASTER Card on-line Customers information area from VSAM Database to DB2. Involved in downsizing of the application, installation of MICROFOCUS, COBOL, XDB on OS/2 and UNIX OS, as well as transferring data between Mainframe and XDB.

07/92-11/94 Warner-Lambert, Morris Plains, NJ

Senior Programmer/Analyst

Participated in Planning, Analysis, Design and Implementation of the ACIS Financial system. The ACIS system developed in DB2, CICS, and COBOL II environment and supported the following Databases: Customer Database, Item Database. Tracked and Tuned system performance using EXPLAIN, regular and periodic database updates, refreshes and applying storage maintenance. Additionally provide end-users with ad-hoc reports using FOCUS.

07/91 - 07/92 Aetna Insurance, CT

Senior Programmer/Analyst

Participated in the development of the Customer Financial Information system. Participated in Design, Coding, Testing and Implementation of Financial Overview Function that was coded in DB2/CICS/COBOL environment. That function handled Customer Account Information offering to the user ability to browse Customer s information.

09/78 - 09/90 Computer Data Center, Kishinev, USSR.

Senior Programmer/Analyst

Participated in the Life Cycle Projects performing analysis, design and implementation of the Manufacturing, Financial, and Forecasting applications.

Education: BE Engineer, USSR.

Contact this candidate