Jude RICHVALE judeR@gisdba.com (239)465-6191   (239) 494-8225
objective	GIS/Oracle Architect/DBA, Team or Project Leader, or Senior Developer
Synopsis	20+ years DataBase Modeling/Admin & Development.  10+ years technical leadership and management. 7 Years System Admin. 10 years GIS Database Design/Admin/Leadership.
Platforms	Unix, Windows, Oracle DB, FORMS & OWB, HACMP, Oracle 6-11g DBA, Forms & Reports 6-9i, Erwin, Oracle Spatial with LRS (Linear Referencing System), Unify DB,   MS  Project,. SQL,  PL/SQL,  C,  Pro*C, HTML, COBOL, ESRI 8-10 ArcSde, Arc Catalog, ArcObjects ArcGIS, VB, Geocoding, Teradata, Infosphere, Serena, Javascript, Java
Experience	1994–Present  Virtual DBA Inc. Oracle & GIS Architect/DBA/Unix Admin IBM/Evergy Electric 9/2021-3/2022 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 DBA Inc. 5/2021 – 8/2021 Created an ESRI based estimating system for Reclaimed water distribution in Bonita Springs. Infosys / Southern CA Edison/ Eversource Energy 9/2018- 3/2021 Performed assessment of work required to convert Old SCE mainframe COBOL based electric system to ESRI/Oracle based geospatial system. Maintained ArcGIS services and Arcsde server at Eversource energy in Berlin CT. Minnesota Department of Transportation. 1/17- 9/2018 GIS Architect / Project lead on Crash System. 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 and 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 subsystem). Created Geo processes to spatially EDIT (validate) and supplement incoming crash data from Department of Public Safety. Created Oracle spatial script to measure distances from crash site based on alternative methods. PGE – Pacific Gas & Electric Walnut Creek CA 10/15- 10/16 ESRI Arcsde Administrator. 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) issues. State of Michigan DOT 4/12-5/12/2015 Data Architect and Internal consultant on various ESRI & Arcsde & issues. Created NTFA Routing application using ESRI Model Builder & Python. Created Oracle Spatial Arcsde/ PL/SQL LRS Applications for Asset Management System. Assisted in building consensus for new DTMB Arcsde GIS approach. Architected Arcsde Oracle Spatial Data using Erwin then IBM Infosphere. HMA Corp (now part of CHS) 3/13-3/14 Data Architect and DB Analyst. Analyzed Athena Medical Practice Management System. Interfaced with Athena personnel to facilitate migration of data to new Data Warehouse. Designed & Created core warehouse on Teradata system. Loaded Athena data into TD Warehouse using TD utilities. Kennametal Corp 1/2000-2-2013 Performed Oracle maintenance and provided remote Oracle support. Installed Oracle 8-11g, Installed & Configured OWB 9-10. Created Oracle Forms for Metallurgy Application. Virtual DBA 5/1998-11/2/2013 (Internal project) Installed OWB (9i R2) on Win 2003 Server with repository on Sun Solaris server. Created and maintained Oracle forms for Project Time & Billing Created GISDBA Website using HTML Geodecisions (A division of Gannet Fleming) Camp Hill, PA 10/2011- 12/2012 Oracle Spatial/Arcsde DBA and Data Architect. Maintained & Tuned Oracle Spatial. Architected DB design for Georgia Department of Transportation. Performed Geocoding using Oracle Spatial. Dominion Energy(Richmond VA) 4/2011-10-2011 Data Architect. Designed Semantic relational data model for Urban Electric System, Created schema and Converted to Oracle/ Arcsde from MS Access based legacy system. (Mostly remote). Pacific Gas and Electric, San Ramon CA. 11/2010-3-2011 ESRI Arcsde Administrator. Maintained GASMAP 1.0. with Telvent Miner & Miner App and Oracle. US DMDC (Army) Seaside CA. 5/2010- 12/2010 GIS Consultant Arcsde Administrator. Architected Routing Application based on Oracle, Arcsde, ArcGIS Server, Arc Catalog, ArcMap, Network Analyst, Models, Python. Performed Geocoding via Python. Installed & Configured ArcGIS Server and Arcsde (All 9.3. version). US NAVFAC (Navy) Port Hueneme CA. 6/2008-5/2010 GIS Architect. 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. IBM/Michael Baker/FEMA in Alexandria VA. 3/2008-6/-2008 Tuned Oracle 10g/ESRI Arcsde 9.2 instance, wrote comprehensive tuning recommendation reports. USMC (Marine Corp.) Albany GA. 3/2007-3/2008 Oracle DBA group. Configured data pump exports. Solaris OS. Installed Oracle patches on Linux & HP-UX systems. Migrated 7 TB Oracle 8i DB to Oracle 10g. Developed table warning scripts, Installed and configured ASM, RAC, at USMC Base Albany GA. Linux & Solaris OS. Scott US AFB AMC/GIO. 2/2005-2/2007 Oracle DBA and ESRI Arcsde Admin. Used ESRI Arc Objects to automate consolidation of 12 ArcSDE AMC DBs into USAF OWB data warehouse. Provided technical support to 12 AMC GEOBASE coordinators. Architect & Team leader of AMC GeoBase 1.0 AMC Base Consolidation Application. Installed, configured and maintained Oracle & ArcSDE & ArcIMS. Wrote Oracle Spatial SQL Apps University of Ohio Medical Center. 6/2004-12/2004. Modeled Data Warehouse repository, Created ETL procedures. Migrated data from multiple DBs. Installed and configured Oracle Warehouse builder 10G. ESRI. Redlands CA. 8/2003-12/2003. DSG (Developer Support Group). Contractor. Supported ESRI Arcsde clients worldwide. Source Interlink. 12/2002-7/2003 AIX & Solaris System Administrator on Oracle/AIX platform Lockheed Martin NY. 11/2001-11-2002 Created Data Warehouse design and migrated historical data to DW using manual ETL methods. Developed Oracle forms (9i) for test viewing. Corpay Solutions. Randolh MA. 6/2001-10/2001. Led team in implementation of Freight Bill Processing system at Corpay Solutions for GE (client). Designed & Created tabbed forms. NYC DEP Kingston NY. 5/99- 5/2001 (DEP also acts as NYC water utility). Modeled GIS Upstate reservoir & pipeline data in ESRI Arcsde environment. Migrated ArcInfo shape file library to Oracle/SDE database. Installed 9i Application Server. Completed ESRI Oracle/Arcsde class in Vienna Virginia. NYCTA (NYC Transit Authority). 10/99-3/2000 Defined internal data dictionary and glossary, modeled tables for maintenance apps. Dataware, Cambridge, MA - 3/99-9/99 Cconverted Web project from Microsoft SQL Server to Oracle. Installed & Configured Oracle 8.1.6 City College of NY 2/97-3/99 (Concurrent with other projects). Led team developing IRIS College Management system (Oracle PL/SQL & Forms 6i). Fabrikant Diamonds (NYC) 12/98-2/99 Reverse engineered Fabrikant DB design using Oracle Designer (AI) Tools. Chase Manhattan.  5/98-12/98 Installed Oracle 7.3 RDBMS on  Sun  Solaris 2.5 , and Developer 2000 on  PCs. Modeled  “HR  EXPATRIAT SYSTEM” using Erwin Created froms using Pro*C. Database America (Montvale) then Acquired by Donnelly Marketing Stamford 11/97-5/98 Installed 64 bit Oracle 7.2  RDBMS on DEC 8200. Modeled Oracle Corp Marketing Data using Erwin. Created ETL scripts and Tuned Oracle  marketing data warehouse. Prodigy Corp. (White Plains, NY). 11/96-10-97 Installed Oracle 7.2  &  AIX  4.1  on IBM RS/6000  Modeled “WEB CLASSIFIED AD FEEDBACK SYSTEM” using Erwin. Trained staff in use of Oracle. Led implementation using MS Project. NYNEX 11/94-11/96 Architected “ENHANCED YELLOW PAGES  SUBSYSTEM” using  a hybrid approach. At NYNEX. Installed, Oracle 7.X on  AIX HACMP Rs/6000 Cluster with parallel server. .
		Advantage  Systems  Corp.   New Paltz, NY 1990–1994 IBM Boca Raton CIM Center. Supported and developed demo center workflow products using Oracle RDBMS.  Installed & maintained AIX 3.2, Oracle 6 & 7. on Rs/6000 Client/Server platform. Designed and  Developed workflows for “DEMOS & BRIEFINGS”  as well as “DESIGN CONCEPT REDUNDANCY REMOVAL”  using KI-SHELL & “C”.  Participated in developing   CDF/TIE/SAE a  Data Warehousing system for  heterogeneous DB/2  and Oracle platforms using C & OCI. IBM Kingston. Participated in developing a Geographic Information System (GIS) using an underlying Oracle RDBMS in an Object-Relational approach. Designed and implemented security and relationship components. Installed & configured AIX.
		Dataverse Corp.  Hackensack, NJ 1983–1990 Project leader/ Senior Developer Architected and led implementation teams in several application areas:  Import/Distribution Accounting, Health Club Management, Professional Time & Billing (CPA’s & Attorneys), and Sales Tracking.  Ported Informix application to Unify RDBMS.  Installed  Xenix, Unify and various other tools and applications on ALTOS Xenix hardware. Trained clients and staff in use of customized products and UNIFY database development
Education		1976–1979 SUNY At New Paltz, NY BA Human Communications