Resume

Sign in

Developer Oracle

Location:
Monsey, New York, United States
Salary:
$130K+/-
Posted:
August 29, 2018

Contact this candidate

Resume:

ב"ה

Abraham Bruck

845-***-****

ac6uzj@r.postjobfree.com

Database Developer – ETL – Systems Integration – Migration – Customization – Optimization

I have over 30 years of extensive and varied database and computer systems development experience, including Oracle, PostgreSQL, MS Access, mySQL, etc., in unix, Windows and Cloud environments. I have done data analysis, modeling, migration, conversion, integration, aggregation, mining, cleansing, optimization, performance tuning, warehousing, troubleshooting, etc. I have extensive expertise in the creation, fine tuning and maintenance of Tables, Views, Triggers, Functions, Indexes, Partitions, Materialized Views, Database Links, Packages and Procedures.

Business Analysis

Quality Assurance

Quality Management

Data Migration

Data Conversion

Data Integration

Data Optimization

Data Warehouse

Change Management

Systems Analysis

Systems Design

Data Analytical Skills

Innovation

Imagination

Business Requirements

Technical Requirements

Functional Requirements

Critical Thinking

Problem Solving

Presentation Skills

Communication Skills

Highlighted Career Achievements

●Migrated proprietary legacy financials system (FoxPro) to Oracle EBS Financials. Customized and added required functionality to maximize automation capabilities, fully utilizing every possible feature of the Oracle Financials Suite. (Financial Management Unit – City of New York)

●Created, tested and optimized systems for Stock Market firms including Corporate Reorg, Corporate Actions, Security Segregation and Exchanges, Washed Tax Lots Accounting, Cashiers Management, Collateral Management, Credit and Risk, etc. (DGT - Davidson Global Technologies)

●Designed, created, optimized and maintained a Data Warehouse for regional sales, marketing, analysis and reporting to various departments for a variety of corporate requirement (Costco)

●Developed completely automated AI expert system to test aircraft and other large machine oil samples and predict oil change, tune-up and/or maintenance requirements and the overall state of the equipment. (PMC – Predictive Maintenance Corp)

Employment Summary

Chargeback Gurus 2017– Present

Exxon-Mobile (Scotland) 2017

Matrix-IFS (Herzliya, Israel) 2015 – 2017

NYSIF (New York State Insurance Fund) 2014 – 2015

Federal Reserve Bank of New York 2012 – 2014

Emblem Health (GHI, HIP) 2012 – 2012

Bank of America 2011 – 2012

Davidsohn Global Technologies 2010 – 2011

Spartech Polycast Corporation 2009 – 2010

Dynamic Imaging (GE Healthcare) 2008 – 2009

City of New York, Financial Management Unit 2001 – 2008

American Welding Society (AWS) 1999 – 2001

Professional Experience

Duration: Nov 2017 – Present

Company: Chargeback Gurus (www.ChargebackGurus.com)

Remote position

Responsibility: AWS - PostgreSQL DBA, Developer and Designer

Environment: Needed to integrate three separate and completely different Database Schemas; 1 mySQL and 2 PostgreSQL into one PostgreSQL instance onto AWS. Created the AWS RDS for PostgreSQL. Created the EC2 environment on Linux. Created Buckets for storing images and set up CLI to insert and retrieve the images from the PostgreSQL Database.

Final Design resulted in 175 tables, plus indexes, functions, triggers.

Maintained Development, Test, QA and Production Instances.

Data needed to be migrated from each database into the new instance, thru export/import and database links, etc. There were duplicates and a lot of matching and merging, etc to accomplish this.

Duration: Aug 2017 – Oct 2017

Company: Exxon-Mobile of Scotland

Remote position

Responsibility: MS Access Developer and Troubleshooter

Environment: This was for the Machine Maintenance Department of Exxon-Mobile in Scotland.

Created enhancements to existing functionality and some added functionality.

Optimized functionality and create new reports.

Duration: July 2015 – July 2017

Company: Matrix-IFS

3 Sderot Abba Eben, Herzliya, Israel and Jersey City, NJ

Responsibility: Senior Oracle PL/SQL and Actimize Developer, Support and Troubleshooter

Environment: Develop, Customize and Maintain varied and various Anti-Money Laundering (AML), Market Manipulation, Fraud and other irregular Market activities Software for Deutsche Bank with Actimize AIS, RCM, uDeploy, JIRA, TortoiseSVN, etc.; Working with Big Data on Database Design, Development, ETL, Data Cleansing, De-Duping, Integration, Aggregation, Reconciliation, Exploration, etc. Develop ETL, WSDL, SOAP, Corvil, Control-M and Data Management processes. Modify, troubleshoot and optimize Oracle Database, PL/SQL, unix, awk, and perl scripts. Projects: MUMD, Ramping, Spoofing & Layering, Squeeze, Front Running, Wash Sales, etc.

Duration: February 2014 – June 2015

Company: NYSIF (New York State Insurance Fund)

199 Church Street, Manhattan

Responsibility: Oracle Lead Developer, Support and Troubleshooter

Environment: Consulting on various stages of migrating from Main Frame Legacy Premium and Billing System to Custom Oracle Application.

Create scripts to verify integrity of migration code and data, including Ad-Hoc Reports.

Resolve any discrepancies between Legacy and Customer Application functionality, performance and batch process results.

Maintain version control (TFS - Source Control Explorer, Microsoft Visual Studio).

Modify existing and create new Packages, Procedures, Function, etc. to enhance performance (Performance Tuning) and functionality

Optimize code thru creation of Indexes, Primary and Foreign Keys.

Create and maintain backup and restore tables and data, etc

Duration: Oct 2012 – February 2014

Company: Federal Reserve Bank of New York

World Financial Center, Manhattan

Responsibility: Oracle Lead Developer, Support and Troubleshooter

Environment: As all aspects of the work here at the Fed are very sensitive and highly confidential, I can only be very general about the work that I am involved with:

Most of the work centered around Oracle Database: analyze, design, development, documentation, migration (from Unisys Mainframe) and maintenance, data loading (ETL), PL/SQL, create, modify, enhance and debug Packages, Procedures, Triggers, Functions, Database Links.

Application (forms and reports) troubleshooting, support, maintenance, enhancements and development, deployment.

Also, support and debugging of IBM (Domino) Lotus Notes 9, WSDL and MS Access 2007 Applications.

In Development, QA and Production environments.

Duration: Jan 2012 – Sept 2012

Company: Emblem Health (GHI, HIP)

MidTown, Manhattan

Responsibility: Oracle Lead Developer

Environment: The project was to remediate database objects to conform to the ICD9 to ICD10 revisions (International Classification of Diseases Codes) which included expanding certain columns and adding a conversion date and revision column to necessary objects

1) create inventory of all end user schemas and objects for 17 Oracle Databases and Unisys Mainframe; including Tables, Views, Materialized Views, Indexes, Packages, Procedures, Triggers, Functions and SQL*Loader Control files.

2) Identify the objects needing remediation and document same

3) create Oracle Tables to store Total and ICD related inventory objects

4) create Procedures to update and keep current all ICD inventory objects

5) create Procedures and Views that automate and keep current Alter Tables scripts to add the new columns to the Tables that are being remediated

6) Automate Procedure to identify by Procedure, Package, Function and Trigger specific line numbers of code where remediation is required

7) In anticipation of the integration of these Database into one DataWarehouse, map source and target objects

Duration: Dec 2011 – Jan 2012

Company: Bank of America

World Trade Center, Manhattan

Responsibility: Oracle Lead Developer

Environment: Convert, optimize and test SQL Server and Unisys Banking Application to Oracle PL/SQL Procedures on Oracle Exadata Platform.

Duration: Dec 2010 – Dec 2011

Company: Davidsohn Global Technologies ( www.davidsohn.com )

Wall Street Plaza

Responsibility: Senior Oracle Developer

Environment: unix, Unisys, java, Windows XP; Oracle 11g, SQL, Sybase, PL/SQL, SQL*Loader, Toad, Forms, Reports, Aqua Data Studio, SQL Reports, Crystal Reports, including Ad-Hoc Reports.

DGT is a Boutique Software Development house with clients like Bank of America, Merrill Lynch, Royal Bank of Canada, Jefferies, Nomura, UBS, etc. Worked on Development, Testing and Debugging of products including Corporate Reorg, Corporate Actions, Security Segregation and Exchanges, Washed Tax Lots Accounting, Cashiers Management, Collateral Management, Credit and Risk, etc. Modify and Troubleshoot existing PL/SQL Procedures and Packages (Performance Tuning), Oracle Forms and SQL Reports and create new ones against multiple Databases. Create and enhance PL/SQL stored procedures, functions, trigger, indexes, views, materialized views, etc. Create, clone and maintain multiple Development, QA and Production Oracle and Sybase databases. Create load scripts from varying data sources. Cleanse and merge incoming data from various trading and securities feeds CCH, DTC, etc. Create 1099 system for clients of various day trading firms. Convert Sybase data, stored procedures, functions, triggers, etc to Oracle.

Duration: Jan 2009 – Dec 2010

Company: Spartech Polycast Corporation ( www.Spartech.com )

Stamford, CT

Responsibility: Senior Oracle Discoverer / Developer, Data Analyst

Environment: unix, Unisys, Windows XP; Oracle 10g, SQL, PL/SQL, SQL*Loader, Toad, Discoverer Viewer, Plus and Desktop

Modify and Troubleshoot (as Administrator and User) existing Discoverer and DataWarehouse Reports and create new ones against multiple Data Warehouses. Enhance functionality of existing reports and create new reports from Sales, Accounting, Manufacturing and Inventory data. Create PL/SQL procedures, triggers, tables, views and functions to facilitate these reports, based on the Oracle core Financials, Manufacturing, Inventory, WIP, BOM, OE, etc. and two datawarehouses coming off of them.

Duration: Jan 2008 – Jan 2009

Company: Dynamic Imaging ( www.Dynamic-Imaging.com )

A Division of GE Healthcare

Responsibility: Senior Oracle Developer, Data Analyst

Environment: Unisys, Windows NT, 2003, XP; Oracle 10g, SQL, PL/SQL, SQL*Loader, Toad, Oracle Developer, Designer, Seapine Surround and Test Track.

Expand functionality for a RIS (Radiology Information System) system. Develop a Generic Data Migration (ETL) system for the RIS system from many variable databases and formats. Included were a Patient Visit module, Exam Scheduling, Insurance Authorization and Verification, Physician Accessibility, Billing System, Claims System, Collections, Transcription, Report and Document Archiving and Retrieval and Financial Reporting. Also, Install and create scripts to Clone Oracle for Development, QA and Production. Create PL/SQL procedures, triggers, tables, views and functions to add functionality to existing and new modules.

Duration: Feb 2001 – Jan 2008

Company: City of New York, Human Resources Administration, Protective Services for Adults, Financial Management Unit

Responsibility: Senior Oracle Technical Lead / Developer / Data Analyst / Oracle Financials 11i (11.5.3 to 11.5.10.2) and 10g Installation, Set Up, Automation, Customization and Development, Forms and Reports, Peter Martin Associates FACTORS SetUp and Implementation, Unix Shell Scripting to enhance Oracle Functionality

Environment: Windows 98 / NT / 2000, Solaris 2.8, Unisys, Oracle RAC, Oracle8i, 9i, 11i and 10g, SQL, PL/SQL, SQL*Loader, HTML, Oracle Developer, Forms & Reports, Designer and Discoverer, awk, sed, Unix shell script.

Installation, Set Up and Implementation of Oracle Public Sector Financials. Maintain Logical and Physical Database Design. Install patches and updates to the Databases. Create automated procedures to Import / Migrate Legacy Data from FUND-EZ and FMIS Legacy Systems; Interview and Document Auditors, Accountants, Bookkeepers and Social Workers to determine work flow, legal compliance requirements and best practices; both time and monetary, based on Department, City, State and Federal mandates for the accounting processes. Create working documents, procedural and technical, and get sign-off at all levels. Monitor and supervise Oracle Financials Team, Functional and Technical, to ensure compliance with documents. Create link between Peter Martin Associates FACTORS Client Management System to automatically transfer new Clients from FACTORS to Oracle Financials. Create annual templates for AR, AP, and GL to automate monthly processes. Customization and automation of all procedures. A/R, A/P, PO, OE, GL, INV, CM, etc., by way of PL/SQL Packages, Procedures, Functions, Triggers, etc. Create Custom Menus, Forms, Monthly and Annual Reports, etc…

Duration: Nov 1999 – Feb 2001

Company: American Welding Society (AWS)

Responsibility: Senior Oracle DBA / Developer / Systems Analyst / Oracle Financials 11i Customization Development, Unix Shell Scripting to enhance Oracle Functionality, etc ...

Environment: Windows 98 / NT, Solaris, Oracle WebServer, Oracle 8.051, SQL,

PL/SQL, SQL*Loader, HTML, Oracle Developer, Reports and Designer.

Installation, Implementation, development of Bolt-On Screens and Customization of Oracle Financials; design member, course, test, certification, subscriber, etc. DataBase; create custom forms, reports, etc.; A/R, A/P, GL, Order Entry, Inventory, Training, etc.

Duration: Nov 98 – Oct 99

Company: Broward County (BIN Project)

Responsibility: Oracle DBA / Developer

Environment: Windows 95 / NT, Oracle WebServer & WebDB, Oracle 8.05 & 8i, SQL,

Oracle Security Server, PL/SQL, SQL*Loader, HTML, Oracle Developer and Designer

Various Oracle DBA activities including ETL, Data Migration, DataWarehousing modeling; Create Virtual Database on a frame relay system, for 8 county providers, each with its own server and instance of Oracle, to identify common activities, clients and services. Create algorithms and procedures to match up clients in all 8 provider databases in order to seamlessly view data on an individual no matter which or how many of the provider database they appeared on

Duration: Feb 98 – Aug 99

Company: Direct Services, Inc

Responsibility: Oracle DBA / Developer

Unix Admin Functions

Environment: Windows 95 / NT, Solaris 7, Oracle WebServer, Oracle 8.05, SQL, PL/SQL, SQL*Loader, HTML, Oracle Developer, Designer and Discoverer

Various Oracle DBA and Development activities including Data Cleansing (Hygiene) and DataWarehousing modeling, development and implementation for US West, Costco; for marketing and statistical analysis

Duration: Dec/97 – Feb/98

Company: Nu-Med USA, Inc. (www.nu-med.com)

Responsibility: Oracle DBA / Developer

Oracle eCommerce Server Developer with Oracle Financials

Environment: Windows 95 / NT, Solaris, Oracle WebServer, ORACLE 7.3 & 8.0, SQL, PL/SQL, HTML, Java, Developer 2000

Design and implement an Oracle DataBase Design for this new MLM Nutrition Company; Develop a Web presence with Oracle Web Server and eCommerce site with Oracle eCommerce Application Server. Develop programs and procedures to calculate sales and commissions, process credit cards, display upline and downline

Duration: Aug/97 – Dec/97

Company: ExpressWeb (www.freightrate.com)

Responsibility: Oracle DBA / Developer

Oracle Web Server Developer

Environment: Windows 95 / NT, Unix, Oracle WebServer, ORACLE 7.3 & 8.0, SQL, PL/SQL, HTML, Java, Developer 2000

Web Site Development for the Freight Industry with Oracle Web Server and ESRI GIS and Mapping Software. Oracle DBA responsibilities including Database modeling, architecture and site integration – After consultation with representatives of the Freight Industry designed and created a relational database structure and gave on-line functionality to a static Demo Web Site. Converted existing static html to dynamic PL/SQL code integrated with Oracle Web Server and Database. Developer 2000 Menu System for Maintenance of tables, Designer 2000 for schematic view and program flow and future enhancements.

Duration: Feb – July 97

Company: Aeon Decision Technologies (AutoNation, USA)

Responsibility: Oracle Developer / Systems Analyst, Unix Admin Functions

Environment: Unix, ORACLE, SQL, PL/SQL, SQR, Windows 95 / NT

Design and implementation of Database Design and Architecture for Predetermining future value of used cars, using data from various sources, including development of the programs and procedures

Duration: 5 months – Sept 96 – Feb 97

Company: Corporate Express

Responsibility: Oracle Developer / DBA / Systems Analyst / Unix Admin Functions

Environment: Unix, ORACLE, SQL, PL/SQL, SQR, Windows 95 / NT

Largest Office Supply Company; develop reports and unix scripting and menuing; audit and production reports and bar coding of product labels; consolidation of inventory and warehouse management system controls, etc.

Duration: 3 months – July – Sept 96

Company: A.B.C. Distributing

Responsibility: Consultant / Analyst / Programmer

Environment: Unix, ORACLE, SQL, PL/SQL, SQR, Developer 2000, Forms 4.5, Windows 95 / NT

Large Mail Order Catalog Distributor: developed statistical analysis forms and projections for sales by catalog, issue, year, geographic location, product, etc.

Duration: One year 4 months – Mar 95 – July 96

Company: PRC (Precision Response Corporation)

Responsibility: Oracle Programmer / Systems Analyst

Environment: Unix, ORACLE, SQL, PL/SQL, SQR, Developer 2000, Forms 4.5, Windows 95 / NT, AWK, SED, DDE, Davox, Dynacomm, etc.

Telemarketing and fulfillment development projects for AT&T

Duration: Three months - Dec 94 – Mar 95

Company: Alexander Proudfoot Company

Responsibility: Consultant/Analyst/Programmer for Oracle Financials

Environment: DataGeneral (Unix), ORACLE, rpt, ReportWriter, Visual Basic, Forms, etc.

I was responsible for upgrading and developing new forms, reports, menuing systems, etc. for this international management consulting firm. Including modifications to Oracle Financials reports and installation of Ver. 4.5 of Oracle Forms.

Duration: Three months – Sept – Dec 94

Company: Sentinel Insurance Management Systems

Responsibility: Oracle DBA / Systems Analyst / Programmer

Environment: Alpha (VMS), HP (Unix), ORACLE, rpt, SQR, ReportWriter, AWK, SED, etc.

I was responsible for conversion from VMS to Unix; DBA functions and installation, upgrading and customizing of a complete Insurance Management System for automobile insurance.

Duration: Three months – July – Sept 94

Company: EDC (Israel Export Development Corp.)

Responsibility: Consultant

Environment: Novell 3.12, Windows, MicroSoft Access, Visual Basic, ReachOut

I was responsible for developing a Prospect Database of Potential Investors from all over the world. The Main Database was in Miami and was accessed from London, Israel, Germany, New York and Washington, both interactively and downloading and uploading of data for local modification and addition.

Duration: Three months – Apr – July 94

Company: Six L's

Responsibility: Consultant

Environment: ORACLE Ver. 7.0, REPORTWRITER, FORMS 4.0, MENU

on an Alpha 4 VAX running VMS

I was responsible for the development of Integrated Warehouse/Inventory System for wholesale vegetable distribution company, with several warehouses across the U.S.;

●including product receiving, shipping, returns, lost and/or spoiled produce,

●box, pallet and warehouse movement/management/tracking,

●inventory reports by size, age, label, type, color, etc.,

●shipping reports, bills of lading, packing slips, etc., etc...

Duration: Three and a half years – 1990 – Dec 93

Company: Predictive Maintenance Corporation (PMC)

Responsibility: Oracle DBA / Systems Analyst

Environment: ORACLE, XENIX / UNIX, TCP/IP, UUCP, AWK, SED, FOXPRO (DOS), PROCOMM, WILSOFT BARCODES, EXSYS, RPT, FORMS, RPT2C, REPORTWRITER

I was responsible for the development of the completely automated expert system for PMC, a company whose mission is to test aircraft and other large machine oil samples and predict oil change and maintenance requirements and the overall state of the equipment. The system included:

●Identification of the oil samples by bar coded labels

●Data capture directly from the lab equipment (7 stations)

●Accumulation of the test results in an ORACLE database

●Analysis and trending of the results

●Conversion of the results into written reports by the expert system

●Customer modem access to the all reports (verbal, technical, graphic)

●Automatic invoicing

●Complete accounting system to trial balance

I was involved in all aspects of the development, from design and research, choice of equipment, languages, software and tools to the final testing and documentation, both technical and user. This was originally a 50 100 hour project, which landed up being 3 1/2 years; 6 months part time, 2 1/2 years full time and 6 months part time.

Duration: Two years

Company: Bascom Consultants

Responsibility: Consultant

Environment: Foxpro, Novell, Unix, DBase in DOS

I was responsible for the development of several computer systems for this software house, including:

●Fully integrated accounting package including Accounts Payable, Accounts Receivable, Trial Balance, Profit & Loss Statements, Invoicing, Commissions, etc...

●Sales Analysis System

●Purchasing System

●Non profit Administration System to keep track of canvassers, pledges, donors, donations and receipts

Duration: Two Years

Company: BAZZ, Inc.

Responsibility: Consultant

Environment: QPro4/DOS

I was responsible for the development of a fully integrated Production Planning and Control System for this lamp manufacturer. The system includes the following functions:

●Product Requirement Planning

●Bill of Materials

●Production scheduling and control

●Inventory Planning and control

●Purchasing and receiving

●Accounts Payable and Receivable

I was involved in all aspects of the development from design to final testing.

Duration: Three years

Company: Aviron Institute of Technology

Responsibility: Consultant

Environment: Foxpro / DOS, Novell

I was involved in all aspects of the development from design to final testing. I was responsible for the development of several computer systems for this technical school, among which are:

●Prospect mailing and feedback system

●Placement program to help place graduates

●Major modifications to an existing accounting package

Duration: 6 months

Company: National Financial Brokerage Centre (N.F.B.C.)

Responsibility: Consultant

Environment: Foxpro / DOS, Novell

I was responsible for the development of an order processing system for this company. I was involved in all aspects of the development from design to final testing.

Duration: 3 months

Company: Concordia University (Loyola)

Responsibility: Consultant

Environment: Basic / UNIX, DOS

I was responsible for the development of a system to monitor the environment inside an incubator. I was involved in all aspects of the development from design to final testing.

Duration: 9 months

Company: McGill University Library

Responsibility: Oracle DBA / Systems Analyst

Environment: ORACLE / UNIX, DOS

I was responsible for the development of a system to organize, control and retrieve data on the University's Audio Visual Libraries, Art and Architectural Slides. I was involved in all aspects of the development from design to final testing.

Duration: 6 months

Company: Dr. Earl Edelstein (Family Physician)

Responsibility: Consultant

Environment: QPro4 / DOS

I was responsible for the development of a system to categorize patients by predetermined internationally coded criteria. The system also provided a very flexible statistical, reporting and query function based on selective criteria. I was involved in all aspects of the development from design to final testing.

Duration: 6 months

Company: Leather and Shoe Finding Supply

Responsibility: Consultant

Environment: Foxpro / DOS

I was responsible for the development of an integrated system for this jobber/distributor. Functions included Invoicing, Quotations, Payables, Receivables, General Ledger, Monthly Federal and Provincial Tax Returns, Inventory Planning and Control. I was involved in all aspects of the development from design to final testing.

Technical Skills

Operating Systems: Unix, Linux, Solaris, Xenix, AIX, HP-UX, DOS, Unisys and IBM Mainframe, VMS, Windows

Software: ORACLE Ver. 8.1.7, 8i, 9i, 10g, 11i, 11g, 12c; Oracle; RICE (Reports, Interfaces, Conversions, Extensions), eBusiness Suite (EBS), Financials, Discoverer, OLAP, Developer, Designer, Forms, Reports, TOAD, SQL Developer, PL/SQL Developer, AquaData Studio, SQL*Loader, SQR, Peter Martin Associates (PMA) FACTORS, HTML, rpt, rpt2c, ctar, awk, sed, Access, FoxPro, Sybase, PostgreSQL, Rexx, lynx, Lotus Notes (Domino), JIRA, uDeploy, TortoiseSVN, Actimize, etc

Education, Training & Certifications

PROFESSIONAL ASSOCIATIONS & COURSES

Peter Martin Associates FACTORS/SA System Administrator Certified

Canadian School of Tax Accounting

Ontario Mortgage Broker's Association

National Association of Neuro Linguistic Programmers

BSFF and EFT Advanced Certified

TAT and EmoTrance Certified Trainer

Napoleon Hill Academy Course

Capital Research Financial Coordinator Course

Learning Strategies Photo Reading Course

John Bryce – Big Data, Hadoop, RStudio Course

Apitherapy Internet Course



Contact this candidate