OBJECTIVE: A senior-level position of Project Lead, Software/Data Architect/Engineer, or Database Administrator involving the design, modeling, building, integrating, administering, and tuning of quality and secure web-based software, databases, and information technology solutions for changing enterprises.

CAREER:

Database Manager/Database Administrator

Confidential

• Conducted information assurance IA and coordinated geodatabase and source data recovery for Bureau of Indian Affairs Office of Trust Services tribal asset GIS data from corrupted media following a network crash. Re-designed and rebuilt trust service geodatabases using ESRI ArcGIS SDE 9.2 10.2, Oracle 10-11g R2 and MS SQL Server 2008-12 R2 RDBMS, PL/SQL Developer.
• Supported enterprise database operations and applications enhancements for BIA Office of Trust Services Enterprise License Agreement Program using Oracle 10-11g R2 and developed Arc Map IA Tools using Python 2.7,Javascript, Powershell,VBScript on Windows 2003-8 Server.
• Established Enterprise Data Engineering Governance Board for BIA Office of Trust Services. Moved production and development databases from internal networks to secure DOI and Azure cloud computing environments.

Enterprise Data Architect

Confidential

• Developed and maintained logical/physical data models LDM, PDM and artifacts SV-10 process flow, data design and implementation specification, DDL, and XSD schemas for message data in motion for a spatial feature data subject area within a multi-agency discoverable, SOA-based enterprise data architecture from design phase through initial operational capability IOC . This architecture interfaced with other agency business units such as infrastructure, tasking, and production and integrated COTS and agency legacy enterprise applications. Applied CMM Level 5 methodology and used CA ERWin 7.3, Oracle 10g RAC Real Application Clusters RDBMS, TOAD 9.6, Telelogic System Architecture 10.4, and DOORS 8.0.
• Organized and led technical meetings with enterprise data stewards, software developers, and stakeholders to develop spatial feature data requirements for definition, access, storage, classification, transfer, and retention of enterprise spatial feature data. Provided information assurance for the integration of legacy enterprise applications data into the geospatial feature database architecture, including assessment and accreditation. Developed security domain data modeling methodology to support a multi-domain security architecture. Resolved technical issues through Data Engineering Review Board CMM Level 5 processes.
• In support of business intelligence, ensured the accuracy and consistency of the unified data architecture to conform to the ICMAP and CIEM standards-based canonical data taxonomy for the XSD message format and Master Data Management, searchable metadata defined for the feature data subject area conforming to OGC and GML standards. Audited and validated delivered operational database environments.
• Provided the development database administrators with DDL from the physical data model and relational and materialized views in Oracle 10g RDBMS for the 1-2 TB spatial feature database and replication environment. Conducted benchmarks on OLTP databases to verify design. Tuned SQL queries in application environments using Oracle 10g SQL Developer and OEM. Developed database table partitioning scheme using discrete statistical data mining and query analysis.
• Coordinated data cleansing and ETL activities and ensured that the spatial feature data subject data models correctly reflected the data migration and synchronization ETL mappings to legacy data sources and data quality requirements. Validated and verified IV V legacy data sources.
• DoD Top Secret/SSBI/SCI Clearance with Polygraph

Software Engineer

Confidential

• Developed GUI and enterprise web services for a Service Oriented Architecture SOA and maintained local back office infrastructure software systems and databases for a DoD data processing facility using Java 1.5, J2EE, Web Services, XML/SOAP/WSDL/XSL/XSLT, Microsoft .NET 2002, ASP.NET and C , JavaScript, Oracle 10g and MS SQL Server 2000 RDBMS and Services, JDeveloper 10.1.3 , Eclipse 3.1, Oracle TopLink 10.1.3, Apache, Tomcat 2.8, Windows XP, CVS, SharePoint 2.1, VB Script, Redhat Linux, BEA Weblogic Platform 9.2, JSPs/Java Page Flow MVC, Struts, and Solaris 9.3.
• Developed and integrated visualization GUI software and designed and maintained an Oracle 9i/10g database for an open, web-based integration server for legacy satellite and scientific modeling tools for a demonstration at the GEOINT conference. Used Java 1.5, J2EE 1.4/JNI/Swing, Servlets, Oracle 9i RDBMS, Jakarta Tomcat Server, Sun NetBeans 4.1 IDE, XML messages, Sparx Enterprise Architect 5.0, Windows XP, CVS, C /C under agile software development methodologies.
• Developed and integrated visualization and workflow software services using object-oriented enterprise design patterns facade, decorator, plug-in, factory . Designed SOA system architecture SV 1-2 Sequence and Gane Sarsen Data Flow Diagrams , use cases, GUIs, and UML artifacts. Audited and gathered requirements from legacy satellite and scientific software tools, models, and algorithms for reuse for an enterprise framework-based DoD Satellite Ground Station using Java J2EE/JFC Swing/Open Source Ant, JUnit, Jakarta Struts MVC, Log4J, Hibernate , JSPs and Servlets, Javascript, Oracle 9i Database and JBuilderX/Control Center, BEA Weblogic Server 8.1, Workpoint, Popkin System Architect 8.8, DOORS, Windows XP, CVS, Clear Case 6.0, Cruise Control, C /C, SharePoint 2.2, and Solaris 9.3 using agile and iterative RUP Rational Unified Process software development methodologies.
• Evaluated current Java-based software engineering tools, architectures, workflow tools, and web server technologies Oracle, BEA, and others for DoD projects focusing on functionality and security.
• DoD Top Secret/SSBI/SCI Clearance with Polygraph

Information Technology Specialist / Production Database Administrator

Confidential

• Monitored worldwide MIDB Modernized Integrated Database replication environments using Sybase Replication Server 11.5-12.0 and Sybase ASE 11.8-12.5 RDBMS.
• Investigated database information assurance security, integrity, user access, and replication and software and security domain problems for intelligence community MIDB environment using SQL, Perl 5.5, Solaris 8.0 csh, and Sybase ASE 12.5 RDBMS.
• Managed day-to-day operations in absence of Branch Chief and technical contractors for the IDD Division to ensure efficient and timely operations.
• Performed database and software upgrades for intelligence community MIDB user sites using Perl 5.5, Solaris 8.0 csh, and Sybase ASE 12.5.
• DoD Top Secret/SSBI/SCI Clearance

Consultant

Confidential

• Defined requirements and designed, developed, integrated, and tuned an automated data QA/QC, cleansing and consolidation application internet and client/server for a data warehouse ETL for the South Florida Water Management District, using UML, Java J2EE JDBC, Bean Architecture, JSP , Oracle JDeveloper 9i UML, Oracle Forms 6i, Javascript, Java JSPs, UNIX shell scripts csh, ksh , Oracle 8i PL/SQL on Windows NT 4.0, Oracle 9iAS, and Solaris 8.7.
• Conducted JAD design sessions and built object model for application using UML and Oracle Designer 6i. Evaluated products used in application development, mentored team members, and managed development effort.

Principal Consultant

Confidential

• Managed development team and designed and developed internet message-based J2EE data source driver for a Data Warehouse effort for Integrated Logistics IL on USAF-wide network GCSS-AF using Java, JDBC, JDeveloper 3.2, Oracle 8i, OAS 4.0.8, , IBM MQ Series, CORBA, XML DOM, Business Object Documents and Rational Rose 2000 UML on Windows 2000. This driver provided communication, real-time data exchange using publish/subscribe, and integrated stove-piped legacy systems using the USAF Integrated Framework. Investigated using resource pooling, version management with Visual Source Safe, and EJBs for Adapter during component modeling.
• Modified and gathered new customer requirements for Bell South DSL CRM Call Center scripts using Java Bean based Oracle Scripting 3i Oracle Applications 11i .
• Completed and documented components for document management application demonstration for EPA/USAF using Java, Oracle Spatial 8i, interMedia, and Formida GIS.
• Developed HTML-based report generation software USAF Transportation resources using PL/SQL on Windows NT 4.0. Performed DBA tasks for these projects installed and configured Oracle 8i, WebDB, HTTP and Designer 6i, database tuning .
• Consulted on Data Striping issues for Birmingham News databases on Oracle 8.0.4 under OpenVMS.

Production Applications Database Administrator / Consultant

Confidential

• Provided 24x7 on-call operational DBA support for 3.7 Terabyte Oracle 7.3-8.0 OPS data warehouse for IBM Global Services, supporting SAP and Peoplesoft ERP applications on Tivoli-managed Solaris 7.0 platforms.
• Developed database and web server monitoring tools for on-call staff using UNIX shell scripts ksh .
• Provided database tuning and administration for operations and accounting MS SQL Server 6.5-7.0 RDBMS for KB-Kids e-commerce startup on Windows NT 4.0.

Development Database Administrator / Consultant

Confidential

• Designed, built, and administered Oracle 7.3/8.0.5 12 GB data mart using Info Modeler Entity Relationship Diagrams on HP-UX 11 for MCI Provisioning Services providing seamless integration of distributed, legacy provisioning business process.
• Provided Directory Services, business process re-engineering BPR , applications, rollout, testing, referential integrity, and data migration efforts for joint systems integration efforts of MCI Worldcom LSS on Windows NT 4.0 and administered using PVCS 5.3.
• Performed ETL for data mart using MS Access data sources. Installed Oracle product upgrades and migrations. Provided physical tuning and roll out capacity planning.
• Developed and tested SQL and Visual Basic 5.0 code for DSR Direct application, using RDO accessing Directory Assistance/Listing databases.

Database Consultant / Systems Administrator

Confidential

• Implemented DBA procedures and scripts PL/SQL, EBU, DOS for database backup and recovery, stress testing, database tuning, troubleshooting and consulting on Oracle 7.3 RDBMS on Windows NT 4.0 for Across Media Networks order management system rollout.
• Implemented backup procedures using BackupExec. Updated HTML web pages. Administered web services, ASP, HTTP, VBscript, and HTML pages using MS Frontpage 4.0 and MS IIS 4.0 for Windows NT 4.0, Redhat Linux 3.0, and OS/2 Warp for in-house systems and websites. Reverse-engineered on-line recruiting database system from PowerBuilder into CGI application using Rexx on OS/2. Installed and configured Sybase 11 EAS for Alpha NT and Replication for SQL Anywhere and investigated using Perl for future porting recruiting system from OS/2.
• Maintained and enhanced VBA and EDI based software and lead security product selection effort for Just-In-Time Inventory Management System VMI for Gates Rubber Company.

Software Engineer

Confidential

• Designed, developed, and tested GPS display linear referencing client/server software for the Marta Intelligent Transit System ITS using GDS, C, Visual Source Safe, and Sybase 10.1 RDBMS on HP-UX 10 for the 1996 Olympics. This GPS software provided real-time bus locations based on extrapolated schedule time-points and satellite data.
• Developed and tested spatial database query software for AM/FM/GIS applications for an Advanced Traffic Management System ATMS using GDS GEL 4GL Motif and Sybase 10 which integrated critical GDOT data with Atlanta ATMS GIS data with different spatial coordinate system.
• Administered ATMS and Marta/ITS Sybase 10.1 and Cinergy and Citizen Utility GIS Oracle 7.2 databases on HP-UX 10 and Windows NT 3.51. Certified GDS GIS products on Sybase 11 SQL Server. Ported Oracle 7.1 database into Sybase SQL Server 10 using bcp and SQL Loader. Conducted UNIX and Oracle product selection for project architectures. Provided database consulting, business process re-engineering BPR , and troubleshooting for AM/FM/GIS clients.
• Designed, developed, and tested Client/Server based QA/QC utilities for Bell South Outside Plant database/GIS workflow system using Oracle 7.2 PL/SQL and Visual Basic 4.0 with Winsock, ODBC and Crystal Reports.
• Developed and tested software component to automate porting Logical Data Models from S-Designer into Smallworld GIS Case environment using Smalltalk/Magik and emacs.

Database Systems Developer

Confidential

• Developed and tested Transact-SQL transactions, triggers, and stored procedures and maintained entity relationship data model and performed other DBA and troubleshooting tasks using MS SQL Server 4.2, S-Designer 4.0 and PVCS 4.0 for an integrated client/server sales support and accounting system on Windows NT 3.51 to support the Visual Basic 3.0 front-end of purchasing/leasing warehouse system for computer products.
• Developed, tested, documented, and integrated automated process for BBS data downloads and database population of daily computer product price lists based on business rules for purchasing system using Procomm 2.0 automation and DOS scripts.

Senior Systems Engineer

Confidential

• Developed, tested, and documented healthcare claims analysis and reporting client/server applications in full software lifecycle for Ochampus using UniFace 4.0, C, DB-Library, Applixware, and Sybase 4.8 RDBMS on Solaris 2.3.
• Enhanced PC to mainframe transfer, analysis, reporting, and word processing applications using Borland C and Clipper 5.0 in dBaseIII on DOS 5.0 - 6.2 and Windows 3.1. Provided troubleshooting and support to Ochampus agency staff.
• Evaluated developer tools such as SparcWorks, CenterLine, Jam and Focus for these projects.
• Gathered requirements via user JAD sessions, and designed database for procurement and inventory portion of the Ochampus automated administration system using Customer Q product in Sybase 4.8 RDBMS on Solaris 2.3.

Senior Quality Assurance Engineer

Confidential

• Developed scripts, and ran and documented product tests for SQL database product tests porting to all UNIX, VMS, and mainframe platforms for software product development using sccs and make for version management and builds.
• Coordinated with the product engineering and marketing departments to develop SQL specifications against ANSI/ISO standards.
• Prepared test plans for the performance testing and TPC benchmarking of Unidata database releases.
• Prepared documentation updates for product enhancements.
• Improved the production release process by automating all testing and QA processes with scripts, which tracked defects and performance and test results metrics.

Senior Software Engineer

Confidential

• Conducted and published TPC client/server database benchmark tests for Sybase 4.2-4.3 Client/Server RDBMS on DEC Ultrix 4.1 under simulated high capacity enterprise architectures for Systems Engineering and Marketing groups.
• Developed automated scripts to optimize OS, database tuning, and benchmark tests, which shortened project times.
• Provided consulting and pre-sales support for customer Sybase and Informix benchmarks.
• Developed database client/server software, test plans, test cases, and scripts in Fortran 77 using Rdb 4.0 RDBMS, DECmessageQ, CDD, Kermit, MMS, PCA, SCA, DCL, and CMS on VAX VMS for real time event-driven C3I workflow system for the Space Forecast Center at Falcon AFB.
• DoD Secret /EBI Clearance

Senior Engineer

Confidential

• Designed, developed, tested, and documented client/server software, designed database, and supervised other engineering team developers on the hardware test ATE systems project for USAF B2 aircraft avionics using Sybase 4.1 RDBMS, C, Transact-SQL, DB-Library, MMS, PCA, SCA, DCL, and CMS on VAX VMS. This database described and consolidated firmware/hardware testing from the system to the instruction level. Wrote system integration test plans and test cases for system acceptance testing.
• Wrote user tools and maintained and enhanced software to manage versions of delivered embedded systems using HP MPE iX, VAX Pascal, and Macro.
• DoD Secret/EBI Clearance

Software Engineer

Confidential

• Designed message processing software and database with referential integrity using Entity Relationship Diagrams, PDL, and interface diagrams for the C3I workflow system for the USAF TR-1 Ground Station TRIGS using Sybase 4.0 RDBMS on VAX VMS. This database described and consolidated complicated DoD message formats, which integrated distributed processes.
• Conducted software and hardware product selection for the TRIGS project architecture.
• Designed and developed the database and tracking analysis software for the U.S. Army radar procurement field tests at White Sands Missile Range using Fortran 77 on Data General Eclipse platforms and Data General SQL RDBMS.
• DoD Top Secret/EBI/SCI Clearance

Software Engineer

Confidential

• Developed and tested database access screens and report generation mainframe software in Model 204 DBMS user language on IBM 308x MVS platforms for DoD Agency Product Planning and Workflow system using MIL-STD 2167 methodology.
• Designed, prototyped, and implemented test plans, test cases, and the testing methodology for reporting functions of the system, which shortened software QA and release times.
• Acted as contractor representative to a client for system acceptance testing.
• Maintained and enhanced menu software for X-Windows driven Graphical Information System GIS application for an intelligence agency using C, sccs, and Alis Workflow on SunOS 4.0.
• DoD Top Secret/EBI/SCI Clearance

Engineering Statistician / Programmer

Confidential

• Performed analysis, published papers, and conducted briefings on special threat topics related to underwater acoustics of a statistical nature for the SPL Analysis Branch, uncovering overlooked engineering analyses.
• Developed and maintained data processing and analysis software for the branch in Fortran IV using DMS database on Xerox Sigma-7.
• Designed the Undersea Warfare USW portion of the Command Position Database using Oracle 4.0 RDBMS on Data General Eclipse, integrating stove-piped legacy data sources and reducing analysis preparation time.
• Managed software development contracts for the ASW Division, ensuring timely and accurate delivery of third-party contractor software deliverables per budget.
• DoD Top Secret/SBI/SCI Clearance