SUMMARY:

• I have been a software lead and architect for the past 16 years, with a passion for data standards and system integration. I embrace numerous tools and standards (.Net, WCF, XML/XSLT, JSON, X12, etc) to enable scalable system workflows, APIs and process routing for both small and large - scale backend systems. I am known foremost for consistency and congruency across systems.

TECHNICAL SKILLS:

Languages/Scripting: C#/.Net, SQL/MDX, ASP.Net, Java-Script, XML/XSLT, JSON, Powershell, (Now learning R)

System Applications: Visual Studio/TFS, GIT, BizTalk Server/ESB, MSMQ, SQL Server, Teradata, Sharepoint

Design Tools/Methodologies: UML, SOA, OOP, GitHub, GhostDocSince 2004

Technology Platforms: ReST, Azure, Web Services, ServiceBroker, MSMQ

Data Analytics/Workflow Tools: SSIS, SSRS, SSAS, SSDT, ESB, Powershell, Alteryx, Tableau

Document and System Standards: JSON, XML/XSLT/XSD, EDI/X12, HL7, WCF, SOA

PROFESSIONAL EXPERIENCE:

Data Business Intelligence Lead

Confidential, Beaverton, OR

• Guided development of visuals and data workflow for supply chain measures and reporting.
• Used Alteryx and Tableau to gather, cleanse and create varied data reports and visual metrics to support aggregate global and regional supply chain KPIs.
• Created efficiencies with various sourced data - Teradata, Cognos, SQL SSAS, Snowflake -to capture appropriate aggregations.

BizTalk Architect/Lead

Confidential, Beaverton, OR

• Lead effort to refactor Biztalk application project structures and automate deployments using BizTalk Server 2013 R3, Visual Studio 2015, PowerShell and Octopus deploy.
• Used BizTalk 2013R2 and Visual Studio 2013 to implement system integrations and deliver a Service-based mediation architecture to service all domain systems.
• Used BizTalk 2013R2 and Visual Studio 2015 to create artifact-based project structures for easier builds and deploys.
• Refactored JSON endpoints to allow versioning of message payloads. Configured bindings to for more flexible deployments.
• Worked with System Admin group to setup auto-deployment scripting using PowerShell and Octopus.

BizTalk Architect/Lead

Confidential, Spokane, WA

• Wrote technical designs, workflow diagrams and specifications for large-scale integration project. Implemented project structures for development and testing framework.
• Used BizTalk 2013R2 and Visual Studio 2013 to implement system integrations and deliver a Service-based mediation architecture to service all domain systems.
• Used ESB 2.3 Toolkit to implement integration workflows, routing and various integration messaging patterns.
• Worked with various dependent system partners to assist with WSDL/WCF service interface development and reusable, extensible service contract design
• Used SQL Server 2014 SSDT/SSIS to aggregate and transform disparate data sources.

.Net Developer

Confidential, Beaverton, OR

• Implemented code and testing frameworks to enhance the Healthcare Integration/Exchange project (HIX).
• Used Visual Studio 2013, SQL Server 2012 and various 3rd party caching tools
• Enhanced unit testing frameworks to test schemas and message exchange code

Data Architect/Lead Analyst

Confidential, Ft Worth and Austin, Texas

• Lead/Engage in various projects to capture, analyze and integrate various healthcare trans- action data within and between entities for both compliance and reporting.
• Used various Microsoft and Non-Microsoft technologies to parse and capture various HL7, X12 and related healthcare standard data into and out of various data platforms.
• Co-authored several ETL and rules driven workflows for capturing and integrating workflow messaging between corporate and regulatory entities.
• Used SQL Server 2012R2 Data Tools for ETL/data warehouse structure to support healthcare data for regulatory transactions.

BizTalk Architect/Lead

Confidential, Indianapolis, IN

• Wrote technical designs and workflow for EDI Architecture project. Lead group of developers to implement various BizTalk artifacts for both Inbound 837 Claims and Outbound 837 Repricing claims.
• Used BizTalk 2010 and Visual Studio 2010 to implement claim processing workflow.
• Setup and configured TFS 2010 Build and Deploy environment for all TFS solutions
• Designed centralized Exception Handling routing using default ESB Exception Framework.
• Worked to resolve Production Environment issues with BizTalk application to reduce SQL Server bottlenecks and extensive throttling issues.

Senior BizTalk Consultant

Confidential, Bend, OR

• Lead and engaged in various BizTalk, .Net and SharePoint projects focused in the Healthcare industry. Co-implemented a workflow to process, archive, reporting and analytics for Healthcare Claims/Pmts (837I/P/D, 835, 834, 820), to provide high visibility for providers, EDI Managers, etc. to view key metrics and reports around provider and payer workflows.
• Used SQL 2012 SSIS, SSAS, SSRS, SharePoint 2010 to develop BI Reporting and analytics portal for healthcare data KPIs and targeted reports.
• Created ETL/data aggregation and scrubbing platform using SSIS/SSDT platform.
• Used BizTalk 2010/R2/2013 and ESB 2.1 to implement claim validation, processing and workflow tied to Trizetto Facets.
• Wrote extensive SQL backend logic for capturing and reporting BAM and other metrics for “real time” reporting and graphing.
• Implemented Windows 8/Metro application for custom/mobile user claim processing and tracking.
• Configured entire TFS 2012 Build/Deploy/Automated Test environment for all TFS solutions including the use of BizTalk Deployment Framework

Lead BizTalk Architect/Developer

Confidential, Ft Worth, TX

• Lead design and development initiative for workflow/process around delivery of 5010 837P Medicare Encounter Claims and 277CA receipts for a medium size healthcare company Major tasks included:
• Wrote logical and physical designs based on client’s workflow specifications.
• Created custom schemas and mapping to pull relational SQL Server warehouse data into a common transaction, to accommodate custom configured values in output.
• Created extensive XSLT mapping logic to handle complex source schemas to the hierarchical 837 HIPAA structure.
• Wrote orchestration logic for updating each workflow status and sending status and “file received” email updates.

Senior BizTalk Developer

Confidential, Baton Rouge, LA

• Senior Developer on EDI/HIPAA/BizTalk(2009) integration project for BCBS Louisiana to deliver all of the 5010 HIPAA transactions (835, 837X, 27X) to the Facets adjudication system. Major initiatives included:
• Wrote WCF-based component to manage ancillary liability updates/edits to be called by BizTalk orchestration.
• Wrote and reworked several orchestrations for workflow of messages from X12, thru validation and into Trizetto Facets/QNXT adjudication system.
• Mapped many complex logic scenarios for X12 data to Facets XC format using built-in functoids, XSLT and XSLT Template logic. Mentored several team members on X12 mapping logic and use of logic within 837X and 835 transactions.