VITALY ISAACS Queens NY, *****

917-***-****

adxx3y@r.postjobfree.com

Summary Of Recent Technical Experience:

Business Intelligence and Data Warehousing technologies.

ETL processing using Informatica 5.0/6.0/7/8.x/9.x/10.2/10.4 and PL/SQL.

Writing complex SQL and Performance Tuning.

Education:

BS Computer Science, Queens College CUNY, 1998

BS Civil Engineering/(Construction of Bridges and Tunnels), State College of Engineering (Former USSR), 1992

Post-Graduate:

Informatica PowerCenter 9.x Developer, 2013

Cognos 8.3 BI Transformer: Designing OLAP Models (version 8.3), 2008

Fundamentals of The Securities Industry, New York Institute of Finance, 2007

Introduction to Perl Programming: Hands-On, Learning Tree International, 2007

Oracle 10g Advanced SQL Tuning, Oracle University, 2005

Enterprise DBA: Performance and Tuning, Oracle University, 2001

Employment History:

EQC Inc

New York, NY

Oracle Database / Informatica ETL consultant 11/18 – present

Companies and Clients:

CVS:

Company Mission: Guided by our purpose, CVS Health® is building an entire world of health care around each and every person we serve, no matter where they are on their journey.

Was a part of DB Development Team to design, develop and test a brand new Online system DPAT - “Digital Promotion Authorization Tool”

DPAT is the tool to create, manage and publish CVS’ Promotions and Coupons

Analyzed business requirements and proposed Database solutions

Created Oracle SQL, PL SQL Packages/stored

Bitscopic:

Company Mission: Bitscopic is a small IT company processing and analyzing Healthcare data for US Veterans.

Created Oracle SQL Queries for Alert Generation used by Healthcare Professionals

Created Oracle SQL, PL SQL code for data validation to ensure the loading process is running normally

Tuned SQL queries

CopperPoint / Alaska National Insurance Company:

Company Mission: A western-based commercial insurance company and a leading provider of workers’ compensation and commercial insurance solutions.

Fined Tuned the Oracle Monthly Batch to reduce the running time frame from 3 Days to 12 hours

Sompo International Insurance Company:

Maintained Reference Data of SQL Server Data Warehouse.

Resolved Data Issues reported by the users

Nomura Bank:

Company Mission: Nomura’s mission is to enriching society by delivering clients superior services and solutions to meet all investment needs.

As a part of GFA NGRL Team Data Warehouse involved in modification of existing ETL Informatica 10.4.1 code and creating new code in order to absorb, process and extract data into Flat Files.

Created/modified Autosys schedule in order to properly schedule jobs

Partitioned Oracle 19 tables according to the archival strategy of the company.

Broadridge:

Company Mission: Broadridge services help financial institutions consolidate their books and records, gather and service assets under management, focus on their businesses and manage risk

As a part of TAX SERVICE Data Warehouse involved in modification of existing ETL Informatica 10.2 code to onboard a new client – Ameriprise/UBS/JPM/WFA

Created new/modified existing Greenplum DB functions according to the new requirements

JP Morgan Chase

New York, NY

Database / Data Warehouse Developer

10/07 – 10/18

Company Mission: JPMorgan Chase is a leading global financial services firm. It is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity.

As a part of Investment Banking Data Warehouse involved in developing and designing reusable processes using Unix Shell Scripts / Informatica / Oracle PL/SQL Packages

Created ETL Informatica mappings/sessions/workflows to move data from source destination to the Data Warehouse, and to massage data

Created and populated OLAP data marts in Vertica Database. (Vertica is a DW database owned by HP)

Advised on creation of database structures to guarantee the best possible performance. This included creation or Oracle Partitioned tables and usage of Bitmap indexes.

Fine-Tuned SQL Queries to improve the performance and save processing time and resources.

Advised on compressing data in order to save disk space in the ration 4:1

Designed “Zero Down Time” architecture to make sure the Data Warehouse is available 24x7

Credit Suisse Group

New York, NY

Sr. Data Warehouse Engineer

05/06 – 08/07

Company Mission: Credit Suisse is a world-leading financial services company, advising clients in all aspects of finance, around the world, around the clock.

Created new / modified existing SQL, SQL*Plus, PL/SQL, Informatica PowerCenter 7.1.4 code

Fine-Tuned SQL Queries to improve the performance and save processing time and resources.

PriceLine.com

Norwalk, CT

Sr. Data Warehouse Engineer

09/02 – 05/06

Company Mission: Name your own price Internet Travel Company Priceline.com offers the following services: airline tickets, hotel rooms, rental cars, vacation packages and cruises.

Involved in developing and supporting Priceline Data Warehouse System that was used to collect and analyze all aspects of the business

Conducted source-to-target mapping/sessions in PowerCenter 6.0/7.1.2 to retrieve, manipulate, and load data

Developed SQL, PL/SQL code, UNIX Shell scripts in support of Priceline’s Corporate Information Systems.

Jupiter Media Metrix Inc.

Long Island, NY

Sr. Data Warehouse Developer

10/00 – 09/02

Company Mission: Metrix was a global provider of innovative and comprehensive research and measurement products and services that analyze the impact of the Internet and new technologies on commerce and marketing

Involved in developing Audience Measurement Data Warehouse System that was designed to substitute current legacy system. The new Data Warehouse System was designed to have ORACLE, Microsoft SQL, and Red Brick Warehouse Databases on multiple UNIX boxes.

NaviSys Inc. Enterprise Solution Division

Edison, NJ

Programmer/Systems Analyst

12/98 – 10/00

Company Mission: NaviSys was one of the leading software providers for the insurance and annuities sector.

Involved in integration and upgrade of LifeCAD/MP with client specific systems.

Contact this candidate