·       Sybase

·       SQL Server, Oracle 10g

·       Java Web Services

·       SOAP, XML, XSLT, XPath, XQuery

·       Eclipse, Struts

·       BEA Weblogic Servers 8.1, 9.2, 10

·       BEA Aqualogic Service Bus 2.5 and 2.6

·       MetaMatrix

·       Axis, Axis 2

                External companies involved that I had to interface with: Northrop Grumman and DISA (Defense Information Systems Agency).

                MIDB is the worldwide general military intelligence [GMI] database for the Distributed Production Program (DPP) providing GMI intelligence to the warfighter. A complex Web service is exposed to authorized users that provides information about Ports, Facilities, Equipment, Personnel, Units, Documents and more.                              

                MetaMatrix is a data service management tool that allows integration/aggregation of multiple data sources exposed to applications as if it were a single database. MetaMatrix can consume Web services, but the MIDB Web service's schema was too complex for MetaMatrix. Furthermore, the SOAP response was too complex for MetaMatrix to unmarshal.

                Solution started with requirements gathering and developing a Java Web service exposing a less complex interface for MetaMatrix to query the MIDB WS. The SOAP response was then formatted and returned in a SOAP object MetaMatrix could consume. This solution worked and provided the quick fix; however, managing security (X.509 certificates, username/password tokens) was not feasible. Credentials would have to be passed through MetaMatrix to the MIDB Web Service, which MetaMatrix was not able to do. Futhermore, stakeholders (Joint Defense Agencies) could not agree as to who should stand up and maintain the Web service. Commenced to perform a further domain analysis.

                The solution progressed to incorporate BEA's AquaLogic Service Bus (ALSB), which is a policy-driven Enterprise Service Bus (ESB). It manages routing and transformation of messages to promote seamless application integration.

                Using the ALSB, I transformed the MetaMatrix SOAP requests and MIDB SOAP responses using XPath, XSLT and XQuery. ALSB exposed a proxy Web service using the same signature I used in the original solution. The ultimate solution was unique with not documented. Created a business service connected to the MIDB Web Service. Used the WSDL from the Java Web service developed in solution #1 as a template to create a proxy. This WSDL merely provided a template for the operations, expected parameters and the schema the proxy could be expected to deliver, if hooked up to a functioning Web server that had the Web application running. I hand-tailored the WSDLs, coded XSLT files, and installed and configured the ALSB.

                Performed data analysis, worked with end users to gather requirements and created tools to provide developers a better way to understand the MIDB system and to query it more intelligently. Worked with MIDB developers to provide data to the suite of DoD Logistics and Engineering applications we had been developing for the previous three years.    

·       C# Web Application (adapted .NET 1.1 open source project)

·       C# Web Service (developed from scratch)

·       C# Windows Service with event log monitoring (from scratch)

·       Sharepoint Portal integration with linked lists

·       SQL Server 2000

·       MS Access to create linked lists for Sharepoint

                Teams of testers would login to Sharepoint and run test cases that originated from an Access DB. When users failed a test, a trigger would fire that logged a defect into another database. Developers and managers responsible for the defect were to be notified by a Windows service that fired every 5 minutes. The Windows service called a Web service that searched for new defects and updates occurring within the past 5 minutes. Email notifications were sent to subscribers detailing the new defects and updates. The emails had links directing the user back to the application allowing the user to upgrade the status (closed, not a defect, etc.), reassign the task, or re-categorize the defect.

Configured & integrated this system to track defects in multiple enterprise-level software development projects. Developed the C# Web service, Windows service. Created triggers and sprocs in the SQL Server databases to exchange information and to update on certain events. 

·       MS Project, MetaMatrix

·       BEA Weblogic Server

·       XML, XSLT, XPath, XQuery

·       JavaScript, AJAX, JSON

·       Oracle 9i, 10g

·       Java

Designed and developed a module to export a Java app’s construction plan to XML to be imported by MS Project. Designed and created a complex MS Project template to display the construction plan in a manner consistent to the original application. This module allowed a military planner to make changes in MS Project and then validate and calculate fields based on business logic.  Developed another module to import MS Project XML either as a new plan or merge it back into the original construction plan.

·       Service Oriented Architecture (SOA)

·       Java Web Services

·       .NET Web Services, C#

·       MetaMatrix

·       BEA Weblogic Server

·       Axis

·       BEA AquaLogic Service Bus

·       BEA AquaLogic Service Registry

·       XML, XSLT, XPath, XQuery

·       JavaScript, AJAX, JSON

·       X.509 certificates

·       Web security

·       BEA Weblogic Portal 8.1

·       Oracle 9i, 10g

                Provided consulting services for the Department of Navy's move to integrate its vast enterprise-level systems using Service Oriented Architecture. Developed prototypes demonstrating SOA principles using Navy logistics systems.  Developed prototypes using Web services, portals, enterprise services buses to demonstrate SOA concepts.

·    �Oracle 9i, 10g

·       BEA Weblogic Server 8.1, 9.2

·       BEA Weblogic Portal 8.1 and Workshop 8.1, 9.0

·       Eclipse, Myeclipse

·       Struts, Hibernate, Spring

·       Java Web Services

·       Web Security (X.509 certs, username/pwd tokens, roles)

·       Javascript

·       JSON, AJAX

·       XML, XSLT

·       MetaMatrix

·       WebFocus Reporting tools

·       Dojo, Prototype and X-library Javascript libraries

                Joint Execution and Planning System (JEPES). JEPES provides an integrated set of tools for the Joint Task Force Engineer Staff to plan, assess, and execute joint engineering requirements in accordance with Combatant Command's (COCOM) stated requirements. JEPES supports development of quantitative aspects of general engineering support planning and provides the general requirements for engineer support planning associated with Operational Plan (OPLAN) development. JEPES supports the execution phase of operations by providing GIS capability to perform real time engineering analysis to solve operational problems in a timely manner. The JEPES Architecture is 100% SOA-based and the application is hosted in the Global Combat Support System (GCSS) 6.1-SOA-based enterprise environment. This multi-year project started with no formal requirements.

                Helped gather requirements and performed data analysis. Designed Oracle 9i database with over 100 tables across 3 schemes segmented by user specific, application and reference tables. Co-authored Spiral 1 with a junior developer. Spiral 2 development team increased to more than 15 as we rewrote the application using Myeclipse, Struts, Hibernate and Spring technologies.

                Web application allowed military planners to create or import flat-files, XML, Excel comma-delimited, or JOPES (Oracle) troop movement plans (OPLANs).

                Engineers could plan whether adequate facilities existed at plan locations and if not, plan for the construction of military facilities. Program calculated time, materials, cost and transportation requirements for the projects. Worked with military engineers from all branches (Army, Navy, Air Force and Marines).

               Designed & developed the database for Spiral 1.  Wrote much of the code and managed the code base.  Guided other NWDS and client team members to provide consistent code that was well documented and maintainable.

 

·       Encryption

·       Web Security (X.509 certs, user/pwd tokens)

·       Active Directory Authentication

·       SQL Server, Oracle 9i, Cache

·       Federated Identity, Single-sign-on

·       XML

                Department of Defense Web services initiative. Researched and provided consulting for the latest Web security technologies.  Developed prototypes demonstrating concepts of encryption, message-level security and transport-level security.

                               

·       Oracle 9i, SQL Server, Cache

·       Web services

·       XML, XSLT, XQuery

·       Javascript, Photoshop, CSS

·       BEA Weblogic Server 7, 8.1 and 9.0

·       BEA Weblogic Workshop

·       XML Beans

·       EJB, JMS

·       Java, .NET, C#

              �

Created many smaller BEA Weblogic portals to demonstrate and communicate complex Service-Oriented-Architecture technologies to upper-level managers in the Department of Defense, such as:

1. Communities of Interest (COI)/Enterprise Working Group Support. In support of the Alaska I Project, NWDS supported JITC Alaska in designing and developing prototype SOA applications in support of both enterprise-wide services and COI services. Enterprise-wide services are those used by all of the DoD, whereas a group focused on a particular subset of DoD activities uses COI services. SOA implemented in this development and demonstration environment exposed the services and data needed to grant access to all users at any point in the process. The design allows access to historical, current and projected status to all members of the COI as desired.
2. Disaster Preparedness/First Responders. In response to USNORTHCOM mission requirements for Hurricane season 2006, NWDS helped JITC Alaska design, develop, and deploy an infrastructure availability and disaster-tracking tool in less than 21 days, as opposed to years of development required for other systems. Currently, this tool is supports responders for the 2007 Hurricane season. The USNORTHCOM application provides the fusion of data in GIS, enhancing the ability to analyze and discern an area’s infrastructure capability. Users have access to real time hurricane, tornado and forest fire information that can be queried for additional information directly from a map.
3. Alaska Radio Frequency Identification (RFID) Integration (ARI) Project.  NWDS helped the ARI Team guarantee delivery of innovative EAI software to the DoD that would achieve rapid adoption of Automatic Identification Technology (RFID-enabled) supply chain management. The project included a system prototype that aggregated item level data from passive RFID tags into active RFID tags during inter-modal distribution operations, demonstrating and evaluating the benefits of this integration. The prototype successfully demonstrated, across the various modes of transportation (land, sea, and air), shipments from one Defense Logistics Agency (DLA) distribution center to US Army and Air Force retail/base-level systems in Alaska. The ARI Team’s experience and proven performance in the areas of RFID systems, Net-Centric services/technologies, logistics data/data management, and education and training provided a unique and powerful set of capabilities that contributed to the success of this project.�I designed and developed the portal that housed this project.

 

                              

·       VB.NET, C#, Java

·       Web Services

·       Web security (X.509 certs, user/pwd tokens)

·       Active Directory integration

·       SQL Server, Oracle 9i, Informix, Sybase, Cache databases

·       Federated queries across disparate databases

·       XML, XSLT, CSS

·       SQL Server Reporting Services

                Designed and developed an online Store Front for warfighters. Provided Web interface allowing searching and ordering of millions of products, ranging from tiny transistors, trucks, fighter jets and classified materials. Maintained authentication and authorization via X.509 certificates and active directory. Used Web services extensively. Required extensive use of Data Transformation Services.  Designed & developed the database and wrote the application initially in VB.NET.  Later, I rewrote the application in C# as I implemented role-based security relying upon an LDAP server.

                Developed a prototype to track orders through approximately 50 logistics systems, starting from the initial ordering and during transit, warehouse stops until final destination. Assisted in the development of an RFID system to provide in-transit visibility to above system.

·       VB.NET, ASP.NET

·       SQL Server 2000

·       Web Services

·       CSS, JavaScript

·       XML, XLST

·       Crystal Reports

                Co-designed and developed a reservation system for an Alaskan Tour Bus operator. Did not allow online ordering in accordance with user's business requirements. Allowed end-users to view products, add products to shopping cart, submit order via email to be processed and view order history.

 

·       VB.NET, ASP.NET

·       SQL Server 2000

·       Web Services

·       CSS, JavaScript

·       XML, XLST

Architected and developed an online auction system for an Alaskan women’s group to raise funds to support Anchorage charities. Allowed sponsors to donate products and services. Allowed end users to view details, highest bids, place bids, notify users and sponsors of winning bids.

                As a full-time student, finished MIS degree that started in 1994.

                Summer internship at ConocoPhillips for Drilling & Wells group. 

 Technologies:

               Systems analysis and review of SharePoint beta version 2 for the Drilling and Wells group. Worked with Microsoft developers in their sand-box to determine defects and shortcomings in the product. Provided recommendations to management about the stability of the product and whether it should be implemented into the organization. Web development.  Designed and developed Web-based program that provided users a unified view of server file systems, although servers were in geographically and logically distant locations.  To end users, they could browse a file system and they were unaware that the files were not sitting on one server.     

                Old & forgotten technologies from another life...

·       COBOL, Basic, C, C

·       Paradox, FoxPro

·       Quattro Pro

·       DB2

·       Lotus 123

·       VB6

        Redesigned warehouse inventory system's database and user interface. Designed and developed maintenance shop’s tool accountability database. Designed database and user interface for a mid-size (> 2000 meals daily) food service company that tracked inventory and automated the ordering process.  Gathered requirements, performed systems analysis, worked on small team to develop and provide documentation. Taught basic programming and database design methodologies. Spreadsheet programming for business applications.

·       DOS 5, DOS 6

·       Windows 95

·       DB2, Lotus 123, Word Perfect, Quattro Pro, FoxPro

·       Basic, QBasic

·       C as hobby

                Designed & developed databases for library usage. Designed and developed databases to monitor student attendance and progress. Developed math tutorial software for adult users aimed at students studying for their GEDs. Designed database and user interface for a small (< 300 meals daily) food service company that tracked inventory and automated the ordering process. Taught DOS, Windows, word processing, database design and usage, spreadsheet design and usage.

               

·       DOS 3.3, DOS 5

·       Windows 3.1

·       C programming as hobby

·       Old and forgotten technologies.

                Provided help desk support, upgraded hardware on PCs and Apple computers. Managed educational computer lab on a token ring network. Learned that computers were WONDERFUL!