Scroll To View More
Abraham Bruck

Abraham Bruck

Monsey, NY, United States
Member since February 14, 2017
Abraham is a database pro with over 30 years of experience in IT. With an extensive background in management, sales, and finance, he specializes in systems integration, conversion, migration, customization and performance tuning, analysis, design, and the development and implementation of computer systems, particularly in Oracle and Unix environments. His primary concern is to satisfy the needs of management and the end user through innovation.
Abraham is now available for hire
Portfolio
Experience
  • Oracle, 20 years
  • PL/SQL, 20 years
  • Unix, 20 years
  • Oracle Performance Tuning, 20 years
  • Unix Shell Scripting, 20 years
  • PL/SQL Developer, 20 years
  • Oracle Database, 20 years
  • Actimize, 2 years
Monsey, NY, United States
Availability
Full-time
Preferred Environment
Unix, Oracle, PL/SQL, Database Developer
The most amazing...
...project I've done was for a county in Florida—integrating into 1 database (warehouse) 8 different county agencies' data, each from a different database source.
Employment
  • Senior Oracle PL/SQL Developer | Data Analyst
    2015 - 2017
    Matrix-IFS (Deutsche Bank)
    • Developed, customized, and maintained 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, and more.
    • Worked with big data on database designs, development, ETL, data cleansing, de-duping, integration, aggregation, reconciliation, exploration, and more.
    • Developed ETL, WSDL, SOAP, Corvil, Control-M, and data management processes. Modified, troubleshot and optimized Oracle database, PL/SQL, Unix, AWK, Java, Python, and Perl scripts.
    • Worked on projects in AIS and RCM including the setup, customization, and optimization of fixed income, MUMD, MPRH, PTCC, duplicate orders, front-running, abusive squeeze, price deviation, spoofing, and more.
    Technologies: Oracle, Unix, PL/SQL, Actimize, SOAP, ETL, XML, XSL, Control-M
  • Oracle Lead Developer | Support | Troubleshooter
    2014 - 2015
    NYSIF (New York State Insurance Fund)
    • Consulted on various stages of a migration from a main frame legacy premium and billing system to a custom Oracle application.
    • Wrote scripts to verify the integrity of the migration code and data, including ad hoc reports.
    • Resolved any discrepancies between a legacy and customer application functionality, performance, and batch process results.
    • Maintained version control (TFS—source control explorer, Microsoft Visual Studio).
    • Created new and modified existing packages, procedures, functions and more to enhance performance (performance tuning) and functionality.
    • Optimized code through the creation of indexes and primary and foreign keys.
    • Created and maintained backup and restore tables, data, and more.
    Technologies: Oracle, Unix, PL/SQL
  • Oracle Lead Developer | Support | Troubleshooter
    2012 - 2014
    Federal Reserve Bank of New York
    • Maintained confidentiality—as all aspects of the work here are very sensitive and highly confidential, I can only be very general about the work that I am involved with:.
    • Worked mostly centered around the Oracle database—analyzing, designing, developing, documenting, migrating (from a Unisys Mainframe), maintaining, data loading (ETL), PL/SQL, and creating, modifying, enhancing and debugging packages, procedures, triggers, functions, and database links.
    • Developed, supported, maintained, enhanced, and deployed applications (forms and reports).
    • Supported and debugged IBM (Domino) Lotus Notes 9, WSDL, and MS Access 2007 applications.
    • Worked in development, QA, and production environments.
    Technologies: Oracle, Unix, PL/SQL, ETL, IBM (Domino) Lotus Notes, WSDL, MS Access
  • Oracle Lead Developer
    2012 - 2012
    Emblem Health (GHI, HIP)
    • Remediated 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.
    • Created an inventory of all the end user schemas and objects for the 17 Oracle databases and Unisys mainframe; including tables, views, materialized views, indexes, packages, procedures, triggers, functions, and SQL*Loader control files.
    • Identified the objects that needed remediation and documentation.
    • Created procedures to update and keep current all the ICD inventory objects and alter table scripts to add the new columns to the tables that are being remediated.
    • Automated a procedure to identify it by either procedure, package, function, and trigger specific line numbers of code where remediation is required.
    • Anticipated the integration of these databases into 1 data warehouse, map source, and target objects.
    Technologies: Oracle, Unix, ICD9, ICD10, PL/SQL, SQL*Loader
  • Oracle Lead Developer
    2011 - 2012
    Bank of America
    • Converted, optimized, and tested a SQL server and Unisys banking application to Oracle PL/SQL procedures on an Oracle Exadata platform.
    Technologies: Oracle, Unix, PL/SQL, SQL Server, Exadata
  • Senior Oracle Discoverer Developer | Data Analyst
    2009 - 2012
    Spartech Polycast Corporation
    • Modified and troubleshot (as an administrator and user) existing Discoverer and data warehouse reports and created new ones against multiple data warehouses.
    • Enhanced the functionality of existing reports and created new reports from sales, accounting, manufacturing, and inventory data.
    • Wrote PL/SQL procedures, triggers, tables, views, and functions to facilitate these reports (based on the Oracle core financials, manufacturing, inventory, WIP, BOM, OE, and 2 data warehouses coming off of them).
    Technologies: Oracle, Unix, PL/SQL, Discoverer
  • Senior Oracle Developer | Data Analyst
    2008 - 2009
    Dynamic Imaging (a Division of GE Healthcare)
    • Expanded a functionality for an RIS (radiology information system) system.
    • Developed a generic data migration (ETL) system for the RIS system from many variable databases and formats.
    • Created various modules for the above system: patient visit, exam scheduling, insurance authorization and verification, physician accessibility, billing system, claims system, collections, transcriptions, report and document archiving, retrieval, and financial reporting.
    • Installed and wrote scripts to clone Oracle for development, QA, and production.
    • Created PL/SQL procedures, triggers, tables, views, and functions to add functionality to existing and new modules.
    Technologies: Unisys, Windows NT, 2003, XP; Oracle, SQL, PL/SQL, SQL*Loader, Toad, Oracle Developer, Oracle Designer, Seapine Surround, Test Track
  • Senior Oracle Technical Lead | Developer | Data Analyst
    2001 - 2008
    City of New York, Human Resources Administration, Protective Services for Adults, Financial Management Unit
    • Installed, set up, and implemented Oracle Public Sector Financials; maintained a logical and physical database design.
    • Installed patches and updates to the databases.
    • Created automated procedures to import/migrate the legacy data from FUND-EZ and FMIS legacy systems.
    • Interviewed and documented auditors, accountants, bookkeepers, and social workers to determine the work flow, legal compliance requirements, and best practices; both time and monetary, based on department, city, state and federal mandates for the accounting processes.
    • Created working documents, procedural and technical, and get the sign-off at all levels.
    • Monitored and supervised the Oracle financials teams—functional and technical—to ensure compliance with documents.
    • Created a link between Peter Martin Associates FACTORS Client Management System to automatically transfer new clients from FACTORS to Oracle Financials.
    • Created annual templates for AR, AP, and GL to automate monthly processes; customized and automated all the procedures.
    • Developed A/R, A/P, PO, OE, GL, INV, CM, and more by way of PL/SQL packages, procedures, functions, triggers, and more.
    • Wrote custom menus, forms, monthly and annual reports, and more.
    Technologies: Oracle, Unix, PL/SQL, FoxPro, Oracle EBS, Oracle Financials, Peter Martin Associates FACTORS, SQL*Loader, HTML, Oracle Forms and Reports, Oracle Designer, Oracle Discoverer
  • Oracle Database Administrator | Developer
    1999 - 2001
    American Welding Society (AWS)
    • Worked on various Oracle database administration activities including ETL, data migration, and data warehousing modeling.
    • Created a 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.
    • Wrote 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.
    Technologies: Windows 95/NT, Oracle Web Server, Oracle WebDB, Oracle, SQL, Oracle Security Server, PL/SQL, SQL*Loader, HTML, Oracle (Developer and Designer)
  • Oracle Database Administrator | Developer
    1998 - 1999
    Direct Services, Inc.
    • Worked on various Oracle database administration and development activities including data cleansing (hygiene) and data warehousing modeling, development, and implementation for US West and Costco (for marketing and statistical analysis).
    Technologies: Windows 95/NT, Solaris 7, Oracle Web Server, Oracle, SQL, PL/SQL, SQL*Loader, HTML, Oracle (Developer, Designer, and Discoverer)
  • Oracle Database Administrator | Developer
    1997 - 1998
    Nu-Med USA, Inc.
    • Designed and implemented an Oracle database design for this new MLM nutrition company.
    • Built a web presence with an Oracle web server and eCommerce site with an Oracle eCommerce application server.
    • Developed programs and procedures to calculate sales and commissions, process credit cards, and display upline and downline.
    Technologies: Oracle, Unix, PL/SQL, Solaris, HTML, Java, Developer 2000
  • Oracle Developer | Systems Analyst, Unix Admin Functions
    1997 - 1997
    Aeon Decision Technologies (AutoNation, USA)
    • Predetermined the future value of used cars, using data from various sources, including the development of the programs and procedures.
    Technologies: Unix, Oracle, SQL, PL/SQL, SQR, Windows 95/NT
  • Oracle Database Administrator | Developer
    1997 - 1997
    ExpressWeb
    • Developed a website for the freight industry with an Oracle web server and ESRI GIS and mapping software.
    • Acted as an Oracle database administrator including database modeling, architecture, and site integration.
    • Consulted with representatives of the freight industry on designing and creating a relational database structure and gave on-line functionality to a static demo website.
    • Converted an existing static HTML code to dynamic PL/SQL code integrated with an Oracle web server and database.
    • Developed a 2000 menu system for the maintenance of tables.
    • Designed 2000 for a schematic view and program flow and future enhancements.
    Technologies: Windows 95/NT, Unix, Oracle Web Server, Oracle, SQL, PL/SQL, HTML, Java, Developer 2000
  • Consultant | Analyst | Programmer
    1996 - 1996
    A.B.C. Distributing
    • Developed statistical analysis forms and projections for sales by catalog, issue, year, geographic location, product, and more for a large mail order catalog distributor.
    Technologies: Unix, Oracle SQL, PL/SQL, SQR, Developer 2000, Forms 4.5, Windows 95/NT
  • Oracle Programmer | Systems Analyst
    1995 - 1996
    PRC (Precision Response Corporation)
    • Worked on telemarketing and fulfillment development projects for AT&T.
    Technologies: Unix, Oracle, SQL, PL/SQL, SQR, Developer 2000, Forms 4.5, Windows 95/NT, Awk, SED, DDE, Davox, Dynacomm
  • Consultant | Analyst | Programmer for Oracle Financials
    1994 - 1995
    Alexander Proudfoot Company
    • Upgraded and developed new forms, reports, menuing systems, and more for this international management consulting firm; including modifications to Oracle Financials reports and installation of version 4.5 of Oracle Forms.
    Technologies: DataGeneral (Unix), Oracle, RPT, ReportWriter, Visual Basic, Forms
  • Consultant
    1994 - 1994
    Six L's
    • Developed an integrated warehouse/inventory system for wholesale vegetable distribution company with several warehouses across the U.S.
    • Enabled the system to track and managed the boxes, pallets, and warehouse movement.
    • Developed a functionality where the system could inventory reports by size, age, label, type, color, and more.
    • Created shipping reports, bills of lading, packing slips, and more.
    • Enabled product receiving, shipping, returns, lost and/or spoiled produce.
    Technologies: Oracle, ReportWriter, FORMS 4.0, Alpha 4 VAX, VMS
  • Consultant
    1994 - 1994
    EDC (Israel Export Development Corp.)
    • Developed 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.
    Technologies: Novell 3.12, Windows, Microsoft Access, Visual Basic, ReachOut
  • Oracle Database Adminstrator | Systems Analyst | Programmer
    1994 - 1994
    Sentinel Insurance Management Systems, Trinidad
    • Handled the migration from VMS to Unix.
    • Managed and was responsible for the database administration functions and installation; upgrading and customizing a complete insurance management system for automobile insurance.
    Technologies: Alpha (VMS), HP (Unix), ORACLE, RPT, SQR, ReportWriter, Awk, Sed
  • Oracle Database Adminstrator | Systems Analyst
    1990 - 1993
    Predictive Maintenance Corporation (PMC)
    • Developed 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).
    • Developed a functionality so that the system could identify the oil samples by bar coded labels.
    • Implemented data capturing directly from the lab equipment (7 stations).
    • Enabled the system so that it could accumulate the test results in an ORACLE database.
    • Analyzed and trended the results.
    • Converted the results into written reports by the expert system.
    • Enabled the customer to have modem access to the all reports (verbal, technical, and graphics).
    • Implemented automatic invoicing.
    • Created a complete accounting system to trial balance.
    • 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.
    Technologies: Oracle, Xenix, Unix, TCP/IP, UUCP, Awk, SED, FoxPro (DOS), Procomm, Wilsoft Barcodes, Exsys, RPT, Forms, RPT2C, ReportWriter
Skills
  • Languages
    Sed, AWK, SQL, REXX, Lynx, Visual FoxPro
  • Tools
    Toad, Oracle Designer, Oracle SQL Data Modeler, Microsoft Access, JIRA, Control-M, TortoiseSVN
  • Paradigms
    Database Design
  • Platforms
    Oracle, Oracle Database, Oracle Data Integrator (ODI), Unix
  • Storage
    PL/SQL Developer, Oracle PL/SQL, PL/SQL, SQL Loader, Oracle SQL Developer, Oracle SQL, Oracle Database Tuning, Oracle 12c, PostgreSQL, Database Testing, Database Modeling, Data Integration
  • Other
    Unix Shell Scripting, Oracle Performance Tuning, Data Mining, Data Migration, Data Manipulation, Data Matching, Data Analytics, Data Conversion, Data Cleaning, Data Collection, Data Cleansing, Data Extraction, Data Loading, Data Queries, Actimize, Oracle Discoverer, Query Optimization, Data Quality Analysis, Data Migration Testing, Oracle Apps Technical, Data Modeling, Big Data
I really like this profile
Share it with others