Database& Data Warehouse Analysis& Design - Oracle RDBMS, Pro IV, COBOL
Designed Internet Classified ad Feedback system for Prodigy Corp. Led team implementing project. Trained staff in the use of Oracle & AIX.
Designed, administered, and maintained ORACLE database front and back ends for a Sun OS client/server stock market trading system.
Consulatant in design phase of Data Warehouse for a major defense contractor using Oracle. Used conceptual design approach.
Participated in the design and implementation of a Data Warehouse for a bank using Oracle. The Data Warehouse is now in operational status.
Designed and implemented all integrative programming interfaces to a stock market trading system running on an ORACLE/Unix platform.
Designed and implemented an Adult Ed. Management System using Oracle tools & Crystal Reports.
Architect Enhanced Yellow Pages for NYNEX Venture. Administrator for an ORACLE database supporting 40 developers. Used abstract object approach.
Designed and implemented four complete applications and several upgrades for a software publisher. The work included expanding a database, a scheduling algorithm, object-oriented programming, and internet file transfer.
Designed and implemented Oracle Front and Back ends of an in-house time & billing system in a Sun Solaris/NT Client Server networked environment.
Developed custom ProIV AP system for mid-sized retail chain.
Designed and implemented a Personnel System for Catholic Welfare Bureau (Trenton, NJ) using ProIV on McDonnell Douglas hardware.
Designed & implemented premier Sales System for Advanced Group Sales for hotels and A.R.M.S. Food and Beverage system for restaurants. Used ProIV on IBM-AT under DOS & XENIX.
Designed and Implemented a complete accounting system for Delaware Valley Wholesale Florists, Sewell, NJ.
Consultant on retainer to ProIV Computer Sciences, Inc. (CA). Involved in various aspects of bringing the ProIV IBM product to market. Included:
Performed competitive analysis to determine the most desirable features for implementation of ProIV.
Assisted in Beta site implementation as well as product evaluation at var. Cooper Energy locations.
Designed and implemented intranet web site for GE Capital’s videoconferencing department. Wrote Visual Basic macros to generate and maintain HTML files.
Participated in a group, which designed the Hardware and Software architecture of future bank information systems.
Modeled Human Resources Expatriate system for Chase Manhattan. Implemented on ORACLE back-end database.
Project leadership, design, implementation, and maintenance of client/server oriented ORACLE database applications for large university system on the scale of 'SCT BANNER'.
Project Manager for a work flow management and corporate database system
running on a Sun Solaris based server using Oracle CASE tools for all
aspects of the database design and implementation.
Education
University Administration
Enrollment Checking Considers course requirements, status requirements, financial requirements, etc.
Tuition and Refund Computation Considers tuition, fees, credits, add/drop, full-time status, residency, etc.
Payment Processing Considers deposits, net charges for tuition and fees, actual and estimated financial aid payments.
Financial Aid Processing Determines eligibility and maintains student accounts accounts for TAP, CUSTA, APTS, and Title IV Fund Awards.
Reports Registration and Performance, Graduation, 1098-T (Lifetime Learning).
Project Management Project Manager and designer for a multi-college federally funded
project to implement a web based & client server, networked application using ORACLE
8i running on Sun Servers. The interface includes both client server as
well as web enabled Java based versions. Scope on the scale of SCT BANNER.
Established two new campus EMail systems using Unix servers and desktop
clients running standard mail packages.
Created a college web site that includes live links to an ORACLE
database that allows students to view information via the Internet.
BOCES& School Administration
Adult Education management system State-of-the-art, multi-user, client-server, Oracle based.
Graphical user interface Easy data entry; easy data access: courses& books, classes& instructors, etc.
Manages day-to-day functions of the registrar Data entered in one area is available to others eliminating repetitious data entry.
Manages day-to-day functions of the bursar Includes credit, payment status, stop / hold, etc.
Provides class and faculty management Eliminates conflicts in scheduling and provides availability lists.
Reports Generates required state reports and a variety of other subjects.
School District Administration
Vehicle Preventive Maintenance Scheduling
Motor Fuel Inventory Tracking
Automotive Parts Inventory Tracking
General Inventory Tracking
School Tax Collection Accounting
Student Discipline Referral Tracking
Food Services Accounting
Personnel/Payroll Tracking
Database Management Systems
Designed Internet Classified ad Feedback system for Prodigy Corp. Led team implementing project. Trained staff in the use of Oracle & AIX
Assisted Dataware (Cambridge, MA) in conversion of Web project from Microsoft SQL Server to Oracle back end. Configured for use with Cold Fusion.
Assisted National Company in implementation of web (Java, JSP)& Oracle based Freight Bill Processing system for GE (client).
Designed, administered, and maintained ORACLE database front and back ends for a Sun OS client/server in-house stock market trading system.
Installed & tuned Oracle RDBMS on a variety of platforms including: AIX, Solaris, HP-UX, XENIX, Windows, DEC OSF (Alphaserver).
Participated in the design and implementation of a Data Warehouse for a bank using Oracle. The Data Warehouse is now in operational status.
Designed and implemented all integrative programming interfaces to a stock market trading system running on an ORACLE/Unix platform.
Architected Enhanced Yellow Pages for NYNEX Venture. Administrator for an ORACLE database supporting 40 developers.
Designed and implemented Oracle Front and Back ends of an in-house time & billing system in a Sun Solaris/NT Client Server networked environment.
Developed ORACLE PL/SQL packages for a university administration database.
Designed and implemented an Adult Ed. Management System using Oracle tools & Crystal Reports.
Converted multi-division Corp. to a unified accounting system in ProIV.
Developed custom ProIV AP system for mid-sized retail chain.
Customized and Optimized a ProIV accounting system on DEC Alphaserver VMS platform. Atlantic Coupon redemption center, Rockaway, NJ.
Designed and implemented a Personnel System for Catholic Welfare Bureau (Trenton, NJ) using ProIV on McDonnell Douglas hardware.
Designed& implemented premier Sales System for Advanced Group Sales for hotels and A.R.M.S. Food and Beverage system for restaurants. Used ProIV on IBM-AT under DOS& XENIX.
Helped evaluate ProIV IBM product for use at Manufacturers Hanover Trust and provided training and assistance in upgrading from NoCode to ProIV at European American bank.
Financial
Banking
Chase Manhattan Modeled Human Resources Expatriate system for Chase Manhattan. Implemented on ORACLE back-end database.
Software Engineering Managed software engineering at a large bank. In charge of software development and maintenance. Methodologies: Training and accentuation. Standards of EDP Division: definition and enforcement. Case Tools: selection, implementation in the division. Used Suitcase software engineering tool. Responsible for Quality assurance of software systems.
Hardware and Software Architecture Participated in a group which designed the Hardware and Software architecture of future bank information systems.
NoCode Implementation Assisted in the original implementation of NoCode at European American Bank. Included: application development, programmer training, and modification of an interface to a packet switching network between GA& IBM mainframe.
ProIV at Manufacturers Hanover Trust Helped evaluate ProIV IBM product for use at Manufacturers Hanover Trust and provided training and assistance in upgrading from NoCode to ProIV at European American bank.
Banking Application Project Management Project Manager of many banking applications: deposits, loans, salary & manpower, diamond bourse, checking accounts, pension funds, insurance programs, and others. Managed all project phases using project management tools: project initiation, preliminary design, systems analysis using CASE tools, programming and testing activities, implementation up to production phase, conversions when needed, and maintenance.
Trading
Stock Market and Sun Designed, administered, and maintained ORACLE database front and back ends for a Sun OS client/server in-house stock market trading system.
Stock Market Message Routing Wrote server message routing software for a Sun server stock market trading application supporting 250 Windows clients.
Stock Market and UNIX Designed and implemented all integrative programming interfaces to a stock market trading system running on an ORACLE/Unix platform.
General Accounting
Designed and implemented Oracle Front and Back ends of an in-house time & billing system in a Sun Solaris/NT Client/Server networked environment.
Assisted National Company in implementation of web (Java, JSP)& Oracle based Freight Bill Processing system for GE (client).
Converted multi-division Corporation to a unified accounting system in ProIV.
Developed custom ProIV AP system for mid-sized retail chain.
Customized and Optimized a ProIV accounting system on DEC Alphaserver VMS platform. Atlantic Coupon redemption center, Rockaway, NJ.
Designed&. implemented premier Sales System for Advanced Group Sales for hotels and A.R.M.S. Food and Beverage system for restaurants. Used ProIV on IBM-AT under DOS& XENIX.
Designed and Implemented a complete accounting system for Delaware Valley Wholesale Florists, Sewell, NJ.
Health Club Management& Club Administration
Developed a Unify based health club management system for 2 NJ clubs (5000& 2300 members). System includes front desk, membership, marketing, visits history, and accounts receivable with interface to checkfree.
Healthcare
Tested Visual Basic 3.0, Windows, SQL Server application for Total Healthcare Solutions, Glastonbury, CT.
Installed& Tuned Oracle DB for Internet Firepond application at Empire Blue Cross.
GIS - ESRI Arcsde and Oracle expert administration, tuning & development
Sr. Consultant at Evergy Electric 9/2021-12/2021. Assisted in consolidation of 2 merged electric utilities (west MS and East KS). Created and maintained ArcGIS server services. Diagnosed performance issues in Arcsde.
GIS Architect / Project lead on Crash System at Minnesota Department of Transportation. Designed and created Intersections and Safety Sections feature classes in consultation with client. Revised Architecture. Evaluated ESRI and Oracle products for GIS analytics / reporting. Recommended ESRI Insights. Client is now using Insights. Created canned reports using Insights and trained client in its use. Trained team members in GIS analysis using Geoprocessing models and python. Integrated data from other subsystems to be used in crashes (Postgress based Interchange subystem). Created Geo processes to spatially EDIT (validate) and supplement incoming crash data from Department of Public Safety.
ESRI Arcsde Administrator at PGE. Maintained user access and Oracle/ArcSde on Gas Transmission Application with Intrepid & ArcFM. Internal consultant for various GT (Gas Transmission) & Sub Systems including Synergee and Pgen Integration effort. As Part of O & M (Operations & Maintenance) team for GT helped debug incidents, created solutions per client work orders and remedied defects in GIS System. Created DB health maintenance scripts. Mentored team members in GIS & Database issues. Assisted with RCA (Root Cause) issuess.
Spatial Data Architect at State of Michigan Deapartment of transportation (DOT). Created NTFA Routing application using ESRI Model Builder & Python. Created Oracle Spatial Arcsde/ PL/SQL LRS Aapplications for Asset Management System. Assisted in design of and building consensus for new DTMB Arcsde GIS strategic approach. Architected Arcsde Oracle Spatial Data using Erwin then IBM Infosphere
Oracle Spatial/Arcsde DBA and Spatial Data Architect at Geodecisions. Maintained & Tuned Oracle Spatial. Architected DB design for Georgia Department of Transportation. Performed Geocoding using Oracle Spatial.
Spatial Data Architect at Dominion Energy. Designed Semantic relational data model for Urban Electric System, Created schema and Converted to Oracle/ Arcsde from MS Access based legacy system.
ESRI Arcsde Administrator at Pacific Gas and Electric (PGE). Maintained and tuned GASMAP 1.0. with Telvent Miner & Miner App and Oracle.
Arcsde Administrator Spatial Architect at US DMDC (Army) Seaside CA. Architected Routing Application based on Oracle, Arcsde, Arcgis Server, ArcCatalog, ArcMap, Network Analyst, Models, Python, Java & Web Services. Peformed Geocoding using Models/Python. Installed & Configured ArcGIS Server and ArcSde (All 9.3. version).
GIS Architect at US NAVFAC (Navy) Port Hueneme CA. Modeled GIS data & migrated to Oracle DB. Installed ESRI 9.3 software. Upgraded Arcsde & Arcgis from 9.2 to 9.3. Supported Worldwide Naval GIS.
Performance Tuned Oracle 10g ESRI Arcsde 9.2 instance for IBM & Michael Baker FEMA flood mapping application in Alexandria VA (cut 2/3 time). Also Wrote comprehensive tuning recommendation report
Installed Oracle spatial and migrated Arcsde data to Oracle spatial at
Virtual DBA. Wrote PL/SQL code for Geocoding application as well as spatial queries. Installed ArcGIS server 9.2
Installed Oracle, ArcSDE & ArcIMS at Scott AFB AMC/GIO. Developed Arc Objects programs to automate migration and consolidation of geographical databases. Provided technical direction and support to 12 AMC GEOBASE coordinators. Primary Author and team leader of AMC GeoBase 1.0 Architecture document.
Jude Wrote a variety of MKS / ESRI SDE / SQL scripts to delete users & objects cleanly. Scripts can also be used to clean up sde corruption at the user, feature class or feature dataset level. Assisted bases in Oracle migrations & implementing patches. Posted on http://arcscripts.esri.com
Installed ArcIMS with Java JDK ServletExec & IIS 6.0 on win2003. Installe
d ESRI ArcSde with Oracle and migrated ArcSde data from SQL Server. Earthdata I
nternational in Frederick Md.
At Redlands (ESRI HQ) Performed online & telephone AIR developer support
duties for ESRI customers.
Analyzed problem reports and routed or resolved for current ArcSDE issues.
Installed ESRI ArcSde with Oracle DB for NYC DEP.
Converted flat file GIS library data to ArcSde database.
Saved DEP $.75 million in Oracle license fees (over a 5 year period).
IBM Kingston. Participated in developing a Geographic Information System (GIS) using an underlying Oracle RDBMS in a hybrid Object-Relational approach.
Designed and implemented security and relationship components
Import / Distribution
Wrote Automated Distribution Tracking System for McNeil Labs. This is a bar-code entry system with automatic file upload and download to a host. Clarion.
Information Topology
Designed and implemented an interactive, on-line informational system
for use by professional physicists in academia and industry that
involves full text retrieval capabilities and is available over the
Internet.
Created and maintained a database that contains abstracts of over
twentyfive years of scientific materials published and added to
annually.
Installed three generations of full text photo-composition systems
running on three UNIX servers and used to generate over 100,000
PostScript pages per year.
Architect Enhanced Yellow Pages for NYNEX Venture. Administrator for an ORACLE database supporting 40 developers.
NetroCity Internet app. Design. Solaris 6-10 & Windows platforms.
Internet
Designed Internet Classified ad Feedback system for Prodigy Corp. Led team implementing project. Trained staff in the use of Oracle& AIX.
Assisted Dataware (Cambridge, MA) in conversion of Web project from Microsoft SQL Server to Oracle back end. Configured for use with Cold Fusion.
Assisted National Company in implementation of web (Java, JSP)& Oracle based Freight Bill Processing system for GE (client).
Assistant webmaster for www.redbooks.ibm.com, of IBM’s International Technical Support Organization. Wrote Lotus Notes applications, FTP macros, and REXX routines to automate generation and uploading of HTML.
Designed and implemented intranet web site for GE Capital’s videoconferencing department. Wrote Visual Basic macros to generate and maintain HTML files.
Designed Internet Classified ad Feedback system for Prodigy Corp. Led team implementing project. Trained staff in the use of Oracle& AIX.
Project Manager and designer for a multi-college federally funded
project to implement a client server, networked application using ORACLE
8i running on Sun Servers. The interface includes both client server as
well as web enabled Java based versions.
Established two new campus EMail systems using Unix servers and desktop
clients running standard mail packages.
Created a college web site that includes live links to an ORACLE
database that allows students to view information via the Internet.
Management
Managed up to 14 programmers Internally on various projects at Virtual DBA.
Managed 24 programmers on IBM Internal project.
Consultant on retainer to ProIV Computer Sciences, Inc. (CA). Involved in various aspects of bringing the ProIV IBM product to market. Included:
Performed competitive analysis to determine the most desirable features for implementation of ProIV.
Assisted in Beta site implementation as well as product evaluation at var. Cooper Energy locations.
Managed software engineering at a large bank. In charge of software development and maintenance. Methodologies: Training and accentuation. Standards of EDP Division: definition and enforcement. Case Tools: selection, implementation in the division. Used Suitcase software engineering tool. Responsible for Quality assurance of software systems.
Project Manager of many banking applications: deposits, loans, salary & manpower, diamond bourse, checking accounts, pension funds, insurance programs, and others. Managed all project phases using project management tools: project initiation, preliminary design, systems analysis using CASE tools, programming and testing activities, implementation up to production phase, conversions when needed, and maintenance.
Messaging
Wrote Automated Distribution Tracking System for McNeil Labs. This is a bar-code entry system with automatic file upload and download to a host. Clarion.
Wrote Modular Advertising Display Prepack system for Duracell Consumer products. Written in Clarion and automated up & downloads to/from host.
Wrote server message routing software for a Sun server stock market trading application supporting 250 Windows clients.
Assisted in the original implementation of NoCode at European American Bank. Included: application development, programmer training, and modification of an interface to a packet switching network between GA & IBM mainframe.
Wrote and maintained X Windows Bulletin Board system for a Sun client/server environment supporting 70 users.
Personnel& HR
Modeled Human Resources Expatriate system for Chase Manhattan. Implemented on ORACLE back-end database.
Designed and implemented a Personnel System for Catholic Welfare Bureau (Trenton, NJ) using ProIV on McDonnell Douglas hardware.
Pre& Post Sales Consulting
MetaCOBOL TSR at Applied Data Research. Offered Pre-Sales Consulting& Tech Support on MetaCOBOL product.
Consultant on retainer to ProIV Computer Sciences, Inc. (CA). Involved in various aspects of bringing the ProIV IBM product to market. Included:
Performed competitive analysis to determine the most desirable features for implementation of ProIV.
Assisted in Beta site implementation as well as product evaluation at var. Cooper Energy locations.
Sales Tracking
Developed an Oracle based sales tracking system to assist in complex sales process for professional services company. Includes lead listings, contact information, bulk emailing, prospect tracking, activity prioritization, notation & scheduling. Information can display or print by area_code, zip, state, county or city, and can be viewed remotely by field sales force.
Software Publishing
Designed and implemented four complete applications and several upgrades for a software publisher. The work included expanding a database, a scheduling algorithm, object-oriented programming, and internet file transfer.
Responsible for setting up and coordinating beta testing of all new products for a software publisher.
Fully responsible for writing and testing installation programs for CD-ROM based and disk based products published by a software publisher. The largest project contained over 1100 files of which over 800 were installed by setup.
Systems Installation
Veritas Cluster and Solaris 2.7 Installed Veritas Cluster on Solaris 9 system for National client. Configured for raid level 0.
Sun Solaris 8 (2.8) and Oracle 8.1.7, 9i & 10g Installed Oracle 8.1.7, 9i 10g and Solaris 8 & 9 internally & for various clients
Sun Solaris 8 and Oracle 8.1.6 Installed Oracle 8.1.6 and Solaris 8 for various clients
Sun Solaris 9 and Oracle 10g.3 Installed Oracle 9i at Chase Manhattan (Sun Solaris 9)
DEC Alphaserver UNIX and Oracle 7.3 Installed Oracle 7.3 at Database America (DEC Alphaserver UNIX)
DEC Alphaserver and Oracle 8.1.5 Installed Oracle 8.1.5 on a DEC Alphaserver VMS System
Sun Solaris 2.6 and Oracle 8.0.4 Installed Solaris 2.6 and Oracle 8.0.4 at Orange-Ulster BOCES on Sun Server
Sun Solaris 2.8 and Oracle 8.1.6 Installed Sun Solaris 2.8 and Oracle 8.1.6. internally on Sun E450 Server
AIX 4.1 and Oracle 8.1.5 Installed AIX 4.1 and Oracle 8.1.5. at Empire Blue Cross
AIX and Oracle Installed AIX & Oracle at IBM CIM Center, Boca Raton
AIX and Oracle 7.3 Installed Oracle 7.3 with Parallel Server option at NYNEX on twin AIX servers
Solaris 2.6 and Oracle 8.0 Installed Solaris 2.6 and Oracle 8.0 at City College University of NY
Telephony
Architect Enhanced Yellow Pages for NYNEX Venture. Administrator for an ORACLE database supporting 40 developers.
Time& Billing
Designed and implemented Oracle Front and Back ends of an in-house
time& billing system in a Sun Solaris/NT Client Server networked environment.
Legacy Systems
Converted COBOL systems from DOS/360 to OS/360 MVS for CPL/CCL (London).
Converted COBOL DB/2 applications to COBOL Oracle at Allen Systems.
COBOL Language consultant for Siemens AG.
MetaCOBOL TSR at Applied Data Research. Offered Pre-Sales Consulting& Tech Support on MetaCOBOL product.
Database& Data Warehouse Analysis& Design - Oracle RDBMS, Pro IV, COBOL.
Project Manager of many banking applications: deposits, loans, salary & manpower, diamond bourse, checking accounts, pension funds, insurance programs, and others. Managed all project phases using project management tools: project initiation, preliminary design, systems analysis using CASE tools, programming and testing activities, implementation up to production phase, conversions when needed, and maintenance.
