Abraham is available for hire

Abraham Bruck

Verified Expert in Engineering

Data Analytics Developer

Location

Monsey, NY, United States

Toptal Member Since

June 18, 2020

Abraham's been working with databases since 1984, including Oracle, PostgreSQL, MS Access, MySQL, and more in Unix, Windows, and AWS (cloud) environments. His work experience runs the gamut from data analysis, modeling, migration, conversion, integration, aggregation, mining, optimization, performance tuning, warehousing to extensive, varied, and detailed reporting.

Portfolio

Key Autism Services

Amazon Web Services (AWS), MySQL, Remote Desktop, Task Scheduling, Optimization...

CMDX

MySQL, Amazon Web Services (AWS), PostgreSQL, Amazon EC2, Amazon S3 (AWS S3)...

CMDX

Amazon Web Services (AWS), HTML, BTC Wallet, Zapier, MySQL, Amazon RDS...

Experience

Database Modeling - 20 years Oracle - 20 years Database Design - 20 years PostgreSQL - 5 years Microsoft Access - 5 years MySQL - 5 years

Availability

Part-time

Preferred Environment

Amazon Web Services (AWS), Microsoft Access, MySQL, PostgreSQL, Oracle, Linux

The most amazing...

...project I've done was for a county in Florida—integrating into a database (warehouse) 8 different county agencies' data, each from a different database source.

Work Experience

Senior Database Developer and DBA

2021 - PRESENT

Key Autism Services

Created MySQL/PostgreSQL Database on AWS for this company, which provides resources to autistic children and adults in 15 states.
Automated daily download of API data from several sources and inserted it into MySQL/PostgreSQL tables.
Created reporting procedures, triggers, functions, views, etc.
Built XML files for reporting to required government agencies.
Automated daily emails to employees whose daily reports were late.

Technologies: Amazon Web Services (AWS), MySQL, Remote Desktop, Task Scheduling, Optimization, Troubleshooting, Database Design, APIs, PostgreSQL, Amazon RDS, PHP, Query Optimization, Query Composition, Performance Tuning, Data Warehouse Design, Data Warehousing, Analytics, REST APIs, MySQL/MariaDB, MySQL Workbench, MySQL Performance Tuning, Data Analysis, Databases, Database Architecture, Microsoft Power BI, Business Intelligence (BI)

Senior Database Developer

2019 - 2021

CMDX

Created a PostgreSQL data warehouse on AWS for a binary network marketing application.
Migrated data captured from website URLs, through Zapier, CSV files, etc., to PostgreSQL.
Built views, stored procedures, functions, triggers, etc., to use back-end code to capture from and populate the GUI interface.
Installed and implemented the BTCPay Server on the Ubuntu Server.
Verified Bitcoin payments on the blockchain and BTCPay.

Technologies: MySQL, Amazon Web Services (AWS), PostgreSQL, Amazon EC2, Amazon S3 (AWS S3), Amazon RDS, Query Optimization, Query Composition, Performance Tuning, Data Warehouse Design, Data Warehousing, Analytics, MySQL/MariaDB, MySQL Workbench, MySQL Performance Tuning, Data Analysis, Databases, Database Architecture

Developer | Designer

2019 - 2019

CMDX

Created a MySQL (Aurora) data warehouse on AWS for a binary network-marketing application.
Migrated data captured from website URLs through Zapier, CSV files, and so on to MySQL.
Created views, stored procedures, functions, triggers, and so on for using back-end code to capture from and populate a GUI interface.
Installed and implemented a BTCPay Server on an Ubuntu server.
Verified Bitcoin payments on the blockchain and on BTCPay.

Technologies: Amazon Web Services (AWS), HTML, BTC Wallet, Zapier, MySQL, Amazon RDS, Query Composition, Performance Tuning, MySQL/MariaDB, MySQL Workbench, MySQL Performance Tuning, Data Analysis, Databases, Database Architecture

Database Administrator (DBA) | Developer | Designer

2018 - 2019

Lingoda

Created a PostgreSQL data warehouse on AWS.
Migrated and optimized data from several sources into the DWH.
Created dashboards and reports in Tableau.

Technologies: Amazon Web Services (AWS), Database Conversion, Pipeline Programming, AWS Glue, Segment, Stitch Data, Zapier, Adyen Payments, Piwik, Stripe, Autopilot, PostgreSQL, MySQL, Tableau, Amazon RDS, Query Composition, Performance Tuning, Analytics, MySQL/MariaDB, MySQL Workbench, MySQL Performance Tuning, Data Analysis, Databases, Business Intelligence (BI)

Database Administrator (DBA) | Developer | Designer

2018 - 2019

GMA Grading

Modified, troubleshot, and added Visual Basic functionality to an existing MS Access database.
Made the decision to move the data onto an AWS platform in PostgreSQL and link it to the main Access application because the data in the main table was reaching the limit.
Created a system to load new data from CSV files into PostgreSQL.
Parsed six new columns and acronyms that needed to be spelled out in full.
Created several GIN indexes to allow quick response to fuzzy queries.
Created and/or fixed several forms to function as required.

Technologies: Amazon Web Services (AWS), Visual Basic, Microsoft Access, PostgreSQL, Relational Database Services (RDS), Query Composition, Performance Tuning, MySQL/MariaDB, MySQL Workbench, MySQL Performance Tuning, Data Analysis, Databases

Database Adminstrator (DBA) | Developer | Designer

2017 - 2018

Chargeback Gurus

Worked for Chargeback Gurus which processes the chargebacks for Visa, Mastercard, Amex, and so on.
Integrated three separate and completely different database schemas; one MySQL and two PostgreSQL into one PostgreSQL instance onto AWS.
Created the AWS RDS for PostgreSQL.
Constructed the AWS EC2 environment on Linux.
Built buckets for storing images and set up CLI to insert and retrieve the images from the PostgreSQL Database.
Created the final design which resulted in 175 tables, plus indexes, functions, and triggers.
Maintained the development, Test, QA, and production instances.
Migrated data from each database into the new instance, through export/import, and database links.
Handled the duplicates by matching and merging.

Technologies: Amazon Web Services (AWS), XML, Linux, PostgreSQL, MySQL, Command-line Interface (CLI), Amazon EC2, Query Composition, Data Warehouse Design, Data Warehousing, MySQL/MariaDB, MySQL Workbench, MySQL Performance Tuning, Data Analysis, Databases, Database Architecture, Business Intelligence (BI)

MS Access Developer and Troubleshooter

2017 - 2017

ExxonMobil of Scotland

Worked for the machine maintenance department of Exxon-Mobile in Scotland.
Built enhancements to existing functionality and some added Visual Basic functionality.
Optimized functionality and created new reports.

Technologies: Visual Basic, Microsoft Access, Query Composition, Performance Tuning, Data Analysis, Databases

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: Control-M, XSL, XML, ETL, SOAP, Actimize, PL/SQL, Unix, Oracle, Amazon RDS, Query Optimization, Query Composition, Performance Tuning, Analytics, REST APIs, Data Analysis, Databases, Oracle Database, Business Intelligence (BI)

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: PL/SQL, Unix, Oracle, Query Optimization, Query Composition, Performance Tuning, Data Analysis, Databases, Oracle Database, Database Architecture

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: Microsoft Access, Web Services Description Language (WSDL), Lotus Notes, ETL, PL/SQL, Unix, Oracle, Query Optimization, Query Composition, Performance Tuning, Data Analysis, Databases, Oracle Database, Database Architecture

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: SQL Loader, PL/SQL, ICD-10, ICD-9-CM, Unix, Oracle, Query Composition, Performance Tuning, Data Analysis, Databases, Oracle Database, Database Architecture

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: Exadata, Microsoft SQL Server, PL/SQL, Unix, Oracle, Data Analysis, Databases, Oracle Database, Database Architecture

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 Discoverer, PL/SQL, Unix, Oracle, Data Analysis, Databases, Oracle Database, Database Architecture

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: Surround SCM, Oracle Designer, Toad, SQL Loader, PL/SQL, SQL, Oracle, XP, Windows, Unisys, Query Composition, Performance Tuning, Data Analysis, Databases, Oracle Database, Database Architecture

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 Discoverer, Oracle Designer, Oracle Forms & Reports, HTML, SQL Loader, Oracle Financials, Oracle EBS, Visual FoxPro, PL/SQL, Unix, Oracle, Query Composition, Performance Tuning, Data Analysis, Databases, Oracle Database

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: Oracle SQL Developer, Oracle Designer, HTML, SQL Loader, PL/SQL, Oracle Security Server, SQL, Oracle, Oracle WebDB, Oracle Application Server, Windows NT, Windows 95, Query Composition, Performance Tuning, Databases, Oracle Database

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: Oracle Discoverer, Oracle Designer, Oracle SQL Developer, HTML, SQL Loader, PL/SQL, SQL, Oracle, Oracle Application Server, Solaris, Windows NT, Windows 95, Query Composition, Performance Tuning, Databases, Oracle Database

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 Developer 2000 (D2K), Java, HTML, Solaris, PL/SQL, Unix, Oracle, Databases, Oracle Database

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: Windows NT, Windows 95, SQR, PL/SQL, SQL, Oracle, Unix, Databases, Oracle Database

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: Oracle Developer 2000 (D2K), Java, HTML, PL/SQL, SQL, Oracle, Oracle Application Server, Unix, Windows NT, Windows 95, Query Composition, Performance Tuning, Databases, Oracle Database

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: Windows NT, Windows 95, Forms, Oracle Developer 2000 (D2K), SQR, PL/SQL, Oracle SQL, Unix, Query Composition, Performance Tuning, Databases, Oracle Database

Oracle Programmer | Systems Analyst

1995 - 1996

PRC (Precision Response Corporation)

Worked on telemarketing and fulfillment development projects for AT&T.

Technologies: DYNACOMM, Dynamic Data Exchange (DDE), Sed, AWK, Windows NT, Windows 95, Forms, Oracle Developer 2000 (D2K), SQR, PL/SQL, SQL, Oracle, Unix, Query Composition, Performance Tuning, Databases, Oracle Database

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: Forms, Visual Basic, RPT, Oracle, Unix, Query Composition, Performance Tuning, Databases, Oracle Database

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: VMS, Forms, Oracle, Query Composition, Databases

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: Visual Basic, Microsoft Access, Windows, Novell NetWare, Databases

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: Sed, AWK, SQR, RPT, Oracle, Unix, VMS, Databases, Oracle Database

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: Forms, RPT, Visual FoxPro, Sed, AWK, TCP/IP, Unix, Oracle, Databases, Oracle Database

Experience

Database Magician

http://www.cmdx.io

Created, optimized, and maintained all aspects of the database; modeling, and design.
Created MySQL (Aurora) DataWarehouse on AWS for a binary network marketing application.
Migrated data captured from website URLs, thru Zapier, CSV files to MySQL.
Created views, stored procedures, functions, triggers for use of back-end code to capture from and populate GUI interface.
Installed and implemented BTCPay Server on Ubuntu server.
Verified Bitcoin payments on the Blockchain and on BTCPay.

Skills

Languages

SQL, XML, XSL, Web Services Description Language (WSDL), HTML, Java, SQR, AWK, Sed, Visual Basic, Stored Procedure, Visual FoxPro, Lynx, REXX, PHP

Tools

Microsoft Access, Oracle SQL Data Modeler, MySQL Workbench, MySQL Performance Tuning, Lotus Notes, Oracle Designer, Surround SCM, Oracle Financials, Oracle Developer 2000 (D2K), DYNACOMM, Novell NetWare, Tableau, Piwik, Adyen Payments, Zapier, Stitch Data, BTC Wallet, Control-M, TortoiseSVN, Jira, Toad, AWS Glue, Microsoft Power BI

Paradigms

Database Design, Data Science, ETL, XP, Pipeline Programming, Business Intelligence (BI)

Platforms

Oracle Database, Oracle Data Integrator (ODI), Unix, Oracle, Linux, Windows, Solaris, Oracle Application Server, Amazon EC2, AWS Lambda, Amazon Web Services (AWS)

Storage

PostgreSQL, MySQL, Oracle SQL, Oracle PL/SQL, MySQL/MariaDB, Databases, Data Integration, Database Modeling, Database Testing, Oracle 12c, Amazon S3 (AWS S3), Database Architecture, PL/SQL, SQL Loader, Microsoft SQL Server, Exadata, Oracle WebDB, Oracle SQL Developer

Other

Data Queries, Data Loading, Data Extraction, Data Cleansing, Data Collection, Data Cleaning, Data Conversion, Data Analytics, Data Matching, Data Migration, Data Mining, Data Manipulation, Query Optimization, Unix Shell Scripting, Oracle Performance Tuning, Query Composition, Performance Tuning, Data Migration Testing, Data Quality Analysis, Oracle Discoverer, Actimize, Amazon RDS, Data Warehouse Design, Data Warehousing, Analytics, Data Analysis, SOAP, ICD-9-CM, ICD-10, Unisys, Oracle EBS, Oracle Forms & Reports, Windows 95, Windows NT, Forms, Dynamic Data Exchange (DDE), Oracle Security Server, RPT, VMS, TCP/IP, Command-line Interface (CLI), Relational Database Services (RDS), Autopilot, Segment, Database Conversion, Triggers, Functions, Optimization, Troubleshooting, Partitioning, Views, Ayden Web SDK, DBConvert, Big Data, Data Modeling, Oracle Apps Technical, Oracle R, Remote Desktop, Task Scheduling, APIs

Libraries/APIs

Stripe, REST APIs

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring