ABRAHAM BRUCK

SUMMARY

I am a Senior Oracle DBA / Systems Analyst / Programmer / Developer with over 21 years experience in Information Systems technology. A dedicated and proven professional with a solid 17 years of expertise specializing in Oracle Consulting, Oracle Tools, development and third party products. An experienced specialist with knowledge in the use of computer technology, systems analysis, design, development, integration, conversion, and client/server applications involving relational database environments. Specific experience includes the following types of systems: Oracle Financials Package (Installation, Implementation, Development and Customization), Peter Martin Associates FACTORS and HELPWORKS, Web Site Development with Oracle Web Server and Oracle eCommerce Server, DataWarehouse Design, Cleansing and Maintenance, Predictive Maintenance Expert System with Bar Coding, Integrated Financial Systems, Integrated Manufacturing Planning and Control Systems, Integrated Distribution Systems, Medical, Scientific and Technical Applications, Integrated Warehouse/Inventory System, and Complete Auto/Liability Insurance System.

TECHNICAL SKILLS

OPERATING SYSTEMS
Unix, Solaris, Xenix, AIX, DOS, VMS, Windows 3.XX/95/98/NT/2000/XP, Novell
PROTOCOLS
TCP/IP (LAN & WAN)
APPLICATIONS/DATABASES
Oracle 8.x/8i, 9i and 10g, eCommerce Application Server, Oracle Financial Applications 10.x/11.x/11i, 9iAS, SQL*Menu, SQL*Net, SQL*Loader, SQR, Oracle WebServer, WebDB, Oracle Developer – Designer – Discoverer – Forms – ReportWriter – Reports, Peter Martin Associates FACTORS and HELPWORKS, Fail Safe, DBase, MS Access, FoxPro, etc.
LANGUAGES
Visual Basic, HTML
TOOLS/UTILITIES
AWK, SED, UNIX Native Script, PCAnywhere, rpt, rpt2c, ctar, UUCP, NEWVIEWS, Crosstalk, Procomm, Reachout, Wilsoft Barcodes, Exsys, QPR04, DynaComm
HARDWARE/PLATFORMS
IBM Compatibles, Compaq, SUN, VAX, Polaris, HP

EXPERIENCE

City of New York
Human Resources Administration
Adult Protective Services
Financial Management Unit
New York, New York


Oracle DBA/Technical Project Lead/Oracle Financials
February 2001 – Present

- Responsible for the Installation, Set Up, Development and Customization and Implementation of Oracle 11i Public Sector Financials Package. Established multiple instances for the client including a production environment, a testing and staging environment and a training environment. The Oracle Financials Applications are browser-based and utilize Oracle’s 9iAS (Application Server).
- Imported Legacy Data from FUND-EZ and FMIS, the Financial Management Unit’s case management and accounting Legacy Systems.
- Created a link between the Peter Martin Associates FACTORS and HELPWORKS Client Management System to automatically transfer new clients from FACTORS (the new City Wide Adult Protective Services Case Management System) to Financial Management Unit’s Oracle Financials Application, including Suppliers, Clients, and A/R, A/P, GL, Cash Management, etc.
- Employed Windows 98 / NT, 2000 and XP, Solaris 2.8, Oracle WebServer, Oracle 8.1.6 to 9i and 10g, SQL, PL/SQL, SQL*Loader, HTML, Oracle Developer, Reports and Designer, Discoverer and OFA (Oracle Financial Analyzer).
- Created and maintained a Custom Unix Native Script Menu using SED and AWK to enhance the Oracle Financials Package to the Financial Management Unit’s must have specifications which were not included in the Oracle Financials standard functionality.

PSN.com
Oracle DBA/Systems Analayst November 2000 – February 2001

- Redesigned and fine tuned production database and completed set up for Development Instance and Replication for back-end of 9 sites.
- Employed Solaris 2.7, Windows 98/NT, Oracle WebServer, Oracle 8i, SQL, PL/SQL, SQL*Loader, HTML, Oracle Designer.

American Welding Society (AWS)
Oracle DBA/Systems Analyst
Oracle Financials Customization November 1999 – November 2000

- Executed Bolt-on and customization of Oracle Financials (design member, course test, certification, subscriber).
- Created custom forms and reports.
- Employed Windows 98 / NT, Oracle WebServer, Oracle 8.05, SQL, PL/SQL, SQL*Loader, HTML, Oracle Developer, and Reports and Designer.

Broward County (BIN Project)
Oracle DBA/Systems Analyst November 1998 – October 1999

- Performed various Oracle DBA activities including Data Warehouse Modeling.
- Customized a Virtual Database on a Frame Relay system for eight (8) county providers that allowed each provider access to its own server and instance of Oracle, to identify common activities, clients and services.
- Employed Windows 95 / NT, Oracle WebServer & WebDB, Oracle 8.05/8i, SQL, Oracle Security Server, PL/SQL, SQL*Loader, HTML, Oracle Developer and Designer.

Direct Services, Inc.
Oracle DBA/Systems Analyst February 1998 – August 1999

- Implemented various Oracle DBA activities including Data Cleansing (Hygiene) and Data Warehouse modeling, development and implementation for US West, Costco for marketing and statistical analysis.
- Employed Windows 95 / NT, Solaris 7, Oracle WebServer, Oracle 8.05, SQL, PL/SQL, SQL*Loader, HTML, Oracle Developer, Designer and Discoverer.

Nu-Med USA, Inc.
Oracle DBA/Systems Analyst
Oracle e-Commerce Server iStore Developer December 1997 – February 1998

- Designed and implemented an Oracle database design for a new MLM Nutrition Company.
- Developed a Web presence with Oracle Web Server and e-Commerce iStore site with Oracle e-Commerce Application Server.
- Employed Windows 95 / NT, Solaris, Oracle WebServer, Oracle 7.3 & 8.0, SQL, PL/SQL, HTML, Java, and Developer 2000.

ExpressWeb (www.freightrate.com)
Oracle DBA/Systems Analyst
Oracle Web Server Developer August 1997 – December 1997

- Responsible for web site development for the Freight Industry utilizing an Oracle Web Server.
- Performed Oracle DBA responsibilities including database modeling, architecture and site integration.
- Designed and created a relational database structure and gave online functionality to a static demo web site.
- Converted 2000 Menu System for maintenance of tables, Designer 2000 for schematic view and program flow and future enhancements.
- Employed Windows 95/NT, Unix, Oracle Web Server, Oracle 7.3/8.0, SQL, PL/SQL, HTML, Java, and Developer 2000.

Aeon Decision Technologies (AutoNation)
Oracle DBA/Systems Analyst February 1997 – July 1997

- Designed and implemented database design and architecture for predetermining future value of used cars, using data from various sources.
- Employed Unix, Oracle, SQL, PL/SQL, SQR, Windows 95/NT.

Corporate Express
Oracle DBA/Systems Analyst September 1996 – February 1997

- Created Reports and performed Unix scripting and menuing.
- Developed audit and production reports and barcoding of product labels.
- Engineered consolidation of inventory and warehouse management system controls.
- Employed Unix, Oracle, SQL, PL/SQL, SQR, Windows 95/NT.

A.B.C. Distributing
Consultant/Analyst/Programmer July 1996 – September 1996

- Acted as Consultant/Analyst/Programmer for a large mail order catalog distributor.
- Developed statistical analysis forms and projections for sales by catalog, issue, year, geographic location, product, etc.
- Employed Unix, Oracle, SQL, PL/SQL, SQR, Developer 2000, Forms 4.5, and Windows 95/NT.

PRC (Precision Response Corporation)
Oracle DBA/Systems Analyst/Programmer March 1995 – July 1996

- Acted as Oracle DBA/Systems Analyst/Programmer for telemarketing and fulfillment projects for AT&T.
- Employed Unix, Oracle, SQL, PL/SQL, SQR, Developer 2000, Forms 4.5, Windows 95/NT, AWK, SED, DDE, Davox, Dynacomm.

Alexander Proudfoot Company
Consultant/Analyst/Programmer December 1994 – March 1995

- Upgraded and developed new forms, reports, menuing systems, etc. for an international management consulting firm.
- Made modifications to Oracle Financials reports and installation of Version 4.5 of Oracle forms.
- Employed Data General (Unix), Oracle, Reports, Report Writer, Visual Basic, Forms.

Sentinel Insurance Management Systems
Oracle DBA/Systems Analyst/Programmer September 1994 – December 1994

- Responsible for conversion from VMS to Unix.
- Performed DBA functions and installs, upgrading and customization of a complete insurance management system for automobile insurance.
- Employed Alpha (VMs), HP (Unix), Oracle, rpt, SQR, ReportWriter, AWK, SED.

IEDC (Israel Export Development Corp)
Consultant July 1994 – September 1994

- Responsible for developing a prospect database of potential investors from all over the world.
- Maintained database, located in Miami, FL, that allowed access from multiple locations that included London, Israel, Germany, New York and Washington. Responsible for both interactively and downloading/uploading of data for local modification and addition.
- Employed Novell 3.12, Windows, Microsoft Access, Visual Basic, and Reachout.

Six L’s
Consultant April 1994 – July 1994

- Responsible for the development of an integrated warehouse/inventory system for wholesale vegetable distribution company with several warehouses across the USA.
- Performed 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.
- Employed Oracle Version 7.0, ReportWriter, Forms 4.0, Menu on an Alpha 4 VAX running VMS.

Predictive Maintenance Corporation (PMC)
Oracle DBA/Systems Analyst 1990 – December 1993

- 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.
- System included identification of the oil samples by bar coded labels, data capture directly from the lab equipment, 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 reports (verbal, technical, graphic), automatic invoicing, 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.
- Employed Oracle, XENIX, Unix, TCP/IP, UUCP, AWK, SED, FoxPro, DOS, ProComm, Whilst Barcodes, Exsys, Rpt, Forms, rpt2c, and ReportWriter.

Bascom Consultants
Consultant

- Responsible for the development of several computer systems for this software house including a fully integrated accounting package including Accounts Payable, Accounts Receivable, Trial Balance, Profit and Loss Statements, Invoicing, Commissions, etc., sales analysis system, purchasing system, and a non-profit administration system to keep track of canvassers, pledges, donors, donations and receipts.
- Employed FoxPro, Novell, Unix, Dbase in DOS.

BAZZ, Inc.
Consultant

- Responsible for the development of a fully integrated production planning and control system for this lamp manufacturer.
- System includes Product Requirement Planning, Bill of Materials, Production Scheduling and Control, Inventory Planning and Control, Purchasing and Receiving, and Accounts Payable and Receivable.
- Involved in all aspects of the development from design to final testing.
- Employed Qpro4/DOS.

Aviron Institute of Technology
Consultant

- Involved in all aspects of the development from design to final testing.
- Responsible for the development of several computer systems for this technical school including Prospect mailing and feedback system, Placement program to help place graduates, and Major modifications to an existing accounting package.
- Employed FoxPro, Dos, and Novell.

National Financial Brokerage Centre
Consultant

- Responsible for the development for an order processing system for this company.
- Involved in all aspects of the development from design to final testing.
- Employed FoxPro, DOS, and Novell.

Concordia University (Loyola)
Consultant

- Responsible for the development of a system to monitor the environment inside an incubator.
- Involved in all aspects of the development from design to final testing.
- Employed Basic, Unix, and DOS.

McGill University Library
Oracle DBA/Systems Analyst

- Responsible for the development of a system to organize, control and retrieve data on the University’s Audio-Visual Libraries, art and Architecture Slides.
- Involved in all aspects of the development from design to final testing.
- Employed Oracle, Unix, and DOS.

Dr. Earl Edelstein
Consultant

- Responsible for the development of a system to categorize patients by predetermined internationally coded criteria.
- System provided a very flexible statistical, reporting and query function based on selective criteria.
- Involved in all aspects of the development from design to final testing.
- Employed Qpro4 and DOS.

Leather and Shoe Finding Supply
Consultant

- 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.
- Involved in all aspects of the development from design to final testing.

EDUCATION

Canadian School of Tax Accounting
Ontario Mortgage Broker’s Association
National Association of Neuro-Linguistic Programmers
Napoleon Hill Academy Course
Capital Research and Financial Coordinator Course
Learning Strategies Photo-Reading Course