Olympia, Washington, United States
Senior system integrator, specializing in BizTalk, with 22 years of application development and support experience. Strong troubleshooting and problem solving skills.
Current project is a complex two-way integration of legacy in-house applications with newly acquired TylerTech Odyssey Case Manager. Designed, developed and successfully deployed most comprehensive integration ever attempted with Odyssey. Leveraged Tyler Odyssey Configurable Integration Publisher, Tyler Odyssey APIs, XSLT, SQL Server Change Data Tracking, and BizTalk with C# .NET extensions. Was recognized by the agency as an extremely important accomplishment under extreme deadlines. Resolved server setup issues for BizTalk 2006 to 2010 cutover. Used network traces to diagnose HIS DB2Adapter problems. Mentored colleagues in design, coding, testing, and build techniques. Designed and built additional BizTalk-based data exchanges for internal and external systems. Developed IEPDs. Created static class diagrams to model message content. Mapped local fields to NIEM data models. Used Subversion for source code control. Converted all BizTalk deployments to BizTalk Deployment Framework. Leveraged certificate-based authentication with WCF. Modified DB2 and SQL Server stored procedures. Developed a custom solution for providing authorizations via BizTalk party profiles. Developed a response caching feature to prevent duplicate processing. Solutions also utilized WCF-WsHttp, DB2 adapter, Transaction Integrator, WebSphere MQ, and Enterprise SSO, and NUnit framework.
Developed BizTalk-based data exchanges for integration of in-house applications and for exchanging data with external customer systems. Developed IEPDs. Created static class diagrams to model message content. Mapped local fields to NIEM and GJXDM data models. Generated schema subsets. Created schema extensions to meet local needs. Created constraint subsets. Also designed and developed Oracle BPEL orchestrations to provide query web services in Oracle SOA Suite. Tuned DB2 SQL statements. Used Perforce for source code control. Solutions utilized WCF-WsHttp, DB2 adapter, Transaction Integrator, WebSphere MQ, and Enterprise SSO.
Worked as part of a team to develop a statewide juvenile case tracking system using HTML merge features of eDeveloper v9 (aka uniPaaS) on Windows Server 2003, accessing a DB2 database on IBM z/OS. Performed system analysis, coding, unit testing, and code reviews on screens, reports, background processes, and common subroutines. Managed build process (construction, deployment, verification, documentation). Configured and administered development, test, and production application server environments. Researched and resolved technical issues (e.g. application architecture, server software components). Developed performance test plans. Analyzed performance and stress test results. Maintained branched codelines in Perforce. Accomplishments: Provided in-house eDeveloper expertise to reduce dependency on contractors Designed report queuing system Developed web-based direct printing system for generated reports
In addition to Database Applications Programmer duties (below), served as team leader for dwindling IT department, assuming shared responsibility for IT Manager duties including: procedure and policy decisions, resource allocation, budgeting, planning, and prioritizing. Also assumed responsibility for Network Administrator duties including: Administration of an Ethernet LAN in a WAN environment. Novell NetWare 4 server maintenance. Maintain security and user accounts. Lotus Notes Domino server administration on Windows NT Server. Lotus Notes application customization. Setup & maintenance of application servers for email, file transfer, fax server, call accounting, and overnight processing. Tape backup & restore. Ethernet UTP, coaxial, and phone line cabling & termination. Minor website modifications. Second-level desktop support of 50 Windows 95/NT workstations, including troubleshooting/repair, hardware/software upgrades, and application support. Accomplishments: Maintained service levels with half staffing. Successfully completed extensive Y2k readiness project. Reduced spending without a reduction of service levels. Brought network environment up to company-wide standards, involving OS upgrade of all workstations and replacement of primary file server. Mentored co-workers in network/application/desktop support. Re-instituted documentation of standard departmental procedures. Mapped, documented, and labeled all data and telecomm cabling. Worked closely with construction contractors during complete office remodel to minimize service interruptions and to amend the datacomm wiring plan for maximum flexibility.
Integration of custom order processing application with Great Plains Accounting. Client-server application development and database design using MAGIC v5.61 (aka eDeveloper, aka uniPaaS). Pervasive Btrieve v6.15 database administration. System analysis, programming, testing, and maintenance. Application support of in-house systems and remote Magic-based customer quoting system.; Resolved complex multi-user record-conflict issues. Standardized all report output. Sped up order recalculation by a factor of 6. Created a custom Purchase Order system driven by sales order activity and integrated with the accounting system to allow for streamlined invoice and shipment receiving.