Consolidation of Home Equity/Wealth functionality into master Mortgage/Lending application facing Wells Fargo Associates. Project will add over a million customer accounts and a thousand users.

• Implement requirements using PowerBuilder GUI/Framework and Sybase ASE/UNIX back end; Stored Procedures and Triggers, in a collaborative team environment.

Air Force program to migrate a logistics application supporting thousands of users from a web browser to a desktop interface.

• Analyze assigned functions of the web application; Review requirements and needed changes. Develop flow charts and supporting diagrams for more complex processes.
• Migrate JavaScript and Java logic (JSP) from web server to desktop Client/Server and re-implement interfaces to the Oracle database using native PowerBuilder/PowerScript and government supplied framework API.
• Test functionality using web application as a reference.

Support the Consolidated Leads Management System (CLMS) and other credit card services call-center applications in a team environment. Analysis and SDLC documentation with emphasis on data-mapping current system to data sources provided to/from TSYS. Reverse engineer and migrate Tuxedo MW to SOAP (OSA) Web Services. Implement these changes in PowerBuilder codebase. Responsible for generating SOAP proxies for team from WSDL sources (Proxygen/wsdl.exe), and application builds/deployment (RTC, Jenkins). Developed tools to exercise Web Services independently, testing credentials and what-if scenarios (SoapUI).
(PowerBuilder v12.5, SOAP Web Services, SoapUI v5.x, RTC v4.5, Jenkins, Proxygen.)

Support a heavily data-driven Sales and Customer facing POS system and Back Office applications using a combination of PowerBuilder v9 & 12. Designed and implemented objects to encapsulate common UI features to simplify and reduce coding effort. Location specific Forms & Reports using datawindows, queries and stored procedures on ASE. Enterprise level reports using VS/SSRS Report Builder and stored procedures on Teradata.
(PowerBuilder v9/12, Visual Studio .NET 2008, SSRS, Sybase ASE 12.5/15, Teradata 13.10+.)

Support POS Client/Server application. Researching solutions; interface DLL to control Cash Drawer and prevent application aborting, resolve "SaveAs PDF" compatibility issues (Win 7x64), and sending customer notifications via mailSession (HTML, PDF, or Text), or SMS.
(PowerBuilder v12, Windows 7x64, MS SQL 2005/2008 R2.)

Support for ODOT applications and documentation including; CHAMPS, Fuels Tax System, Digital Video Log, Traffic Signal Information, and others.
(PowerBuilder v8+, Visual Basic v6, ColdFusion v9, MS SQL 2005.)

Working in the Oregon Access (OACCESS) development team to implement enhancements and perform defect resolution for the Medicaid Management Information System (MMIS) project.

Additional projects; Consolidate and stabilize UI for Benefit Service Planning Screen. Re-architect Person Search algorithm and UI to reduce duplicates occurring between systems.
(PowerBuilder v9, Eclipse, Sybase ASE 11.x and ASA 10, Documentation.)

Designed and implemented architecture changes to a PowerBuilder 5 based automated Reports Processing application. The project required being able to change leaf-node data elements on the fly, before printing. Migrated application to PowerBuilder v10 to make use of newer features. Added COM-layer API to a Custom C# DLL to interface with PowerBuilder.

Created a tool to read SRD source code and analyze right-margin clipping-rectangles. Added feature to walk the deep-nested report tree to make fixes and build DOT-notation statements to reach leaf-node objects.
(PowerBuilder v5/v10, C#/VS 2003/2005, SQL 2000/2005, Agile.)

Prime project is the processing of health system Trading Partner data into the in-house system. Responsible for designing, documenting, and implementation of process units made up of Tables and Stored Procedures to transform Trading Partner data streams into internal-usable forms and streams for redistribution to other Trading Partners.
(Sybase ASE 12.5, PowerDesigner, SQL Advantage, DbVisualizer.)

Database Engineering; captured and maintain schema. Develop Stored Procedures for Referential Integrity (including Triggers), Report queries, Data load post-processing, and XML formatted data extraction. Some ASP work.
(VB/VBScript/ASP, XML, MS SQL 2000/2005, T-SQL.)

Ongoing support for the WrightTools™ software suite: Designed enhancements for Web-delivery and Hosted applications.
(UML, XML, PowerBuilder, C++, Visual C++, WebApps, MS 2000/2005, T-SQL.)

Ongoing support for the WrightTools™ software suite: Innovated use of XML for inter-process communications. Wrote XML Schemas and sample documents. Supported design of the in-house DOM. Implemented wrappers for the PowerBuilder applications.

Added support for MS SQL Server 2000 and Transact SQL. Synchronization / Replication to remote laptop users.
(C++, PowerBuilder, XML, Schema, MS 2000, Sybase ASA, iMobileSuite.)

Contributed to the design of new product, eTransact™, a web-based version of SmartQuote™ functionality. Designed interactive web-pages as test of concept.
(C++, Delphi, HREF WebHub.)