Oracle Technical Consultant Resume

Desired Industry: Information Technology	SpiderID: 2883
Desired Job Location: Montvale, New Jersey	Date Posted: 6/16/2005
Type of Position: Contractor	Availability Date: July 5, 2005
Desired Wage: $100-125/hour
	U.S. Work Authorization: Yes
Job Level: Management (Manager, Director)	Willing to Travel: Yes, Less Than 25%
Highest Degree Attained:	Willing to Relocate: Undecided

Objective:
I have over 21 years of experience in information systems technology. Over 16 years of these has been specialized in Oracle Consulting (starting with ver. 4) and Development. I am experienced in all Oracle Tools and third party products. I have functioned as a Technical Consultant, DBA, Systems Analyst, Developer, Designer and Programmer. As well, I have an extensive background in management, sales and finance. I am a specialist in the use of computer technology, systems integration, conversion, and client/server applications. I have a great deal of experience in the analysis, design, development and implementation of computer systems, particularly in the relational database environment. And while many people are fixed on rigid technical issues and limited stereotype protocols, my primary concern is in satisfying the needs of the end user. This is achieved through complete flexibility and very creative, imaginative and original solutions.

Experience:
Company: City of New York Human Resources Admin. (Protective Services for Adults, Financial Management Unit)
Duration: Feb 2001 - Present
Responsibility: Oracle DBA / Developer / Technical Lead / Oracle Financials 11i (11.5.3 to 11.5.10) and 10g Installation, Set Up and Customization and Development of Forms and Reports, etc...
Peter Martin Associates FACTORS SetUp and Implementation
Unix Shell Scripting to enhance Oracle Functionality, etc ...
Environment: Windows 98 / NT / 2000, Solaris 2.8, Oracle WebServer, Oracle8i and 9i, SQL,
PL/SQL, SQL*Loader, HTML, Oracle Developer, Forms & Reports and Designer

Installation, Set Up and Implementation of Oracle Public Sector Financials; Import Legacy Data from FUND-EZ and FMIS Legacy Systems (FoxPro); create link between Peter Martin Associates FACTORS Client Management System to automatically transfer new Clients from FACTORS to Oracle Financials. A/R, A/P, PO, OE, GL, INV, CM, etc. Create Custom Menus, Forms and Reports, etc�

Company: American Welding Society (AWS)
Duration: Nov 1999 � Feb 2001
Responsibility: 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.

Company: Broward County (BIN Project)
Duration: Nov 98 � Oct 99
Responsibility: Oracle DBA / Developer/Systems Analyst
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 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

Company: Direct Services, Inc
Duration: Feb 98 � Aug 99
Responsibility: Oracle DBA / Developer/Systems Analyst
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

Company: Nu-Med USA, Inc. (www.nu-med.com)
Duration: Dec/97 � Feb/98
Responsibility: Oracle DBA / Systems Analyst / 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

Company: ExpressWeb (www.freightrate.com)
Duration: Aug/97 � Dec/97
Responsibility: Oracle DBA / Systems Analyst / 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.

Company: Aeon Decision Technologies (AutoNation, USA)
Duration: Feb � July 97
Responsibility: Oracle DBA / 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

Company: Corporate Express
Duration: 5 months � Sept 96 � Feb 97
Responsibility: Oracle DBA / Systems Analyst/Developer
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.

Company: A.B.C. Distributing
Duration: 3 months � July � Sept 96
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.

Company: PRC (Precision Response Corporation)
Duration: One year 4 months � Mar 95 � July 96
Responsibility: Oracle DBA / Systems Analyst / Programmer
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

Company: Alexander Proudfoot Company
Duration: Three months - Dec 94 � Mar 95
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.

Affiliations:
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
. Napoleon Hill Academy Course
. Capital Research Financial Coordinator Course
. Learning Strategies Photo-Reading Course

Skills:
Oracle Financials; Installation, Implementation, Customization, DBA
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
Complete Auto/Liability Insurance System

Technical Expertise: Environments:

Equipment: IBM Compatibles, Compaq, SUN, VAX, Polaris, HP, etc...
Operating Systems: Unix, Solaris, Xenix, AIX, DOS, VMS, Windows 3.XX / 95 / 98 / NT / 2000
Software: ORACLE Ver. 8.1.7, 8i, 9i; Oracle; WebServer, eCommerce Application Sever, WebDB, Developer, Designer, Discoverer, Forms, ReportWriter, Reports, Fail Safe, Financials 10.7 - 11.5.10 (11i) and 10g, SQL*Menu, SQL*Net, SQL*Loader, SQR, Peter Martin Associates (PMA) FACTORS, HTML, rpt, rpt2c, ctar, AWK, SED, TCP/IP (LAN & WAN), SQL*Net, MicroSoft ACCESS, FoxPro, UUCP, NEWVIEWS, CROSSTALK, PROCOMM, REACHOUT, ETC...

Additional Information:
Company: Sentinel Insurance Management Systems
Duration: Three months � Sept � Dec 94
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.

Company: IEDC (Israel Export Development Corp.)
Duration: Three months � July � Sept 94
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.

Company: Six L's
Duration: Three months � Apr � July 94
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...

Company: Predictive Maintenance Corporation (PMC)
Duration: Three and a half years � 1990 � Dec 93
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.

Company: Bascom Consultants
Duration: Two years
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

Company: BAZZ, Inc.
Duration: Two Years
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.

Company: Aviron Institute of Technology
Duration: Three years
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

Company: National Financial Brokerage Centre (N.F.B.C.)
Duration: 6 months
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.

Company: Concordia University (Loyola)
Duration: 3 months
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.

Company: McGill University Library
Duration: 9 months
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.

Company: Dr. Earl Edelstein (Family Physician)
Duration: 6 months
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.

Company: Leather and Shoe Finding Supply
Duration: 6 months
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.

Candidate Contact Information:

Name: Abraham Bruck
Street: -	Phone: 212-630-1800 (office) - 718-687-8805 (cell)
City: Monsey	Fax: -
State: New York
Zip: -
Web Site: