SUMMARY:

• I am a system architect, integration architect, system developer and data engineer with 20 years of application experience with Microsoft as well as Unix, IBM, Oracle and SAP technologies designing and building high performance, high availability mission critical systems.
• Majority of my focus is devoted to architecting, building and/or modifying/enhancing the capabilities of existing systems.
• I leverage my Microsoft BizTalk and Microsoft SQL Server skills to perform integration tasks and to provide maximum availability, performance and security in all environments, particularly production and disaster recovery.
• Experienced professional with more than 20 years of application, web and database development; more than 16 years of integration development and 13 years of integration architectural design and development.
• Experience includes roles as architect, integration lead, development team lead, senior implementation consultant, senior system engineer and consultant, database developer, web developer and consultant/developer.
• Creative, talented and resourceful. Uses initiative when the situation dictates.
• Requires minimal supervision once requirements communicated.
• Integration focused, but talented development skills.
• Strong market experience in these key vertical markets: government, medical, energy, logistics, construction, telecommunications and commercial software development.
• Years of leadership experience and excellent communication skills; both written and oral. Proven asset to a development team encountering challenging obstacles. Experience with large and complex projects and a demonstrated ability to hit deadlines, stay within assigned budgets and assist project managers effectively manage scarce resources.

TECHNOLOGIES, METHODOLOGIES & LANGUAGES:

Web Services, Micro - Services, Agile, Rational Rose, Windows Communication Foundation (WCF), Windows Workflow (WF), Team Foundation Server (TFS), Visual Studio Team Server (VSTS), GIT, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services, Microsoft Business Intelligence (BI), Relational Database Management Server (RDBMS), SQL Server RDBMS all versions to 2017, Oracle 9i, BizTalk Business Activity Monitoring (BAM), BizTalk Enterprise Service Bus (ESB), BizTalk Business Rules Engine (BRE), Universal Database (UDB), IBM DB2, Informix RDBMS, Oracle RDBMS through 18c, Azure Cosmos DB, Azure Logic Apps, PowerShell, EDI (ANSI X12 & EDIFACT), HL7, HIPAA, SDLC, SCOM, SOAP, AngularJS, Azure Logic Apps, Azure Function, IaaS, PaaS, C#, VB .NET, VB, SOAP API, SSAS, SSRS, UML, SharePoint, ASP .NET, ASP .NET Core, Cold Fusion, Phyton, Angular JS, MVC, XSLT, JavaScript, JSON, RESTFul Services, CSS, Cold Fusion, HTML5, SAP Ariba, SAP ERP, Microsoft CRM, Mercator, SeeBeyond, WebSphere, WebMethods, MQ Series, Siebel UCM, GIT, PDC-9/10, MSMQ, Dell Boomi, Liquid Planner, Jira, Softrax, Astea, Dynamics 365, Slack, Postman, SoapUI, Express, Node.JS, Jenkins CI/CD, Visual Studio all versions to 2017, Windows all versions to 10 and Server 2018, Windows Server all versions to 2018, Yardi, SalesForce

EXPERIENCE:

Confidential, Las Vegas, NV

BizTalk Architect | Developer / Integration Architect

Responsibilities:

• Short-term contract to assist Confidential (DA) IT Group complete integration of justice system software using NIEM standards to move data from mainframe CICS computers to a WINTEL based system third party system entitled Justware.
• Primarily, the work focused on enhancing existing orchestrations; new XML schemas and interfaces to the criminal justice scheduling system.

Confidential, Atlanta, GA

Integration Developer / SQL Server Developer / .NET Developer

Responsibilities:

• Full-stack Microsoft development with a focus on integration of internal and third party systems to support the extraordinary growth of Confidential business.
• Create REST API web services for integration with third party services.
• Create SSIS packages to conduct ETL, SSRS for reporting and SSAS for data analytics and Business Intelligence. .NET development of custom classes and frameworks to support the operation of the business.
• Developed high value deliverables at Confidential .
• Developed, tested and deployed into production the ETL processes that moved data from various databases into Dynamics 365. Most of the data was extracted from Yardi or SalesForce systems and translated into standard and custom Dynamics 365 entities.
• Developed complex SQL Server stored procedures called from SQL Server Agent Jobs that scrubbed and enhanced data for use in Dynamics 365.
• This data then interfaced SSIS packages employing standard SSIS Control Flow and Data Flow tasks, Scripting tasks and the Kingsway Soft SSIS Adapter.
• Employed FlexXML to interact indirectly with the Dynamics 365 database.
• Developed, tested and deployed integration solutions to automate several processes that consumed business data from Excel spreadsheets to update backend SalesForce database tables. This information displayed status information on the user interface web pages.
• This solution replaced a series of manual processes to track broker purchase opinions and Wells Fargo and Credit Suisse title and deed submission dates and events.
• The solution ensured the data was accurate and timely and not dated and fraught with human error.
• Developed Azure Logic apps that retrieved monthly accrual and fair market value information on property assets from a SharePoint 365 Azure location and moved the data to virtual machine file system locations for integration with SSIS for loading into staging and reporting databases.
• The data was then included in monthly BI reports that were instrumental in providing business leadership with critical financial information.

Confidential, Cleveland, OH

Integration Architect / Dell Boomi Developer / .NET Developer

Responsibilities:

• Designing integration architecture for one of the fastest growing technology companies in the USA.
• Responsible for the design of the infrastructure for distributed systems architecture, sizing & benchmarking and applying integration patterns related to EAI, EIP, Web Services, SOA, etc...
• Designing and implementing security/provisioning for system integrations, integrating multiple local systems, various applications and services using Dell Boomi (iPaaS) both on and off premise. Responsible for designing and implementing the MDM for Confidential Technologies enterprise systems.
• Designing, developing and deploying of Integration solutions for On-Premise, Off-Premise (Cloud) and Hybrid scenarios for Confidential Technologies and the solutions that they provide to their clients.
• Designed and created REST API in Dell Boomi for Astea service orders using JSON as document format for integration.
• Designed Dell Boomi Soap API integrations for Softrax. Created SSIS packages with C# .NET in Visual Studio 2017 to migrate data from Microsoft Dynamics 365 to Data Warehouse layer.
• Project was Agile in nature with daily scrum sessions and weekly sprints.

Confidential, Greenville, SC

Integration Lead / BizTalk Developer / .NET Developer

Responsibilities:

• Confidential designs, builds and maintains the world's toughest projects. Confidential is one of the world’s largest publicly traded engineering, procurement, construction (EPC), maintenance, and project management companies.
• Confidential works with governments and Clients in diverse industries around the world to design, construct, and maintain complex and challenging capital projects.
• I served as the integration lead on an $10 million SAP Ariba implementation to upgrade procurement and supply management capabilities. BizTalk 2013 R2 and BizTalk 2016 were the integration layer tools for a multiphase implementation of Ariba. Gathered requirements, created technical specification, developed integration architecture, designed interfaces and implemented interfaces in production.
• Created an Azure cloud based web portal web application to onboard new suppliers and allow self-maintenance of existing suppliers.
• The portal was developed in ASP .NET core MVC and connected to a SQL Server 2018 database.
• Microsoft BizTalk Server core capabilities were employed: schemas, maps, orchestrations, custom pipelines, adapters (REST, HTTP, WCF-Custom, WCF-SQL, WCF-Oracle). Created custom pipeline components to convert cXML (DTD) messages to XSD messages and cXML DTD messages to XSD messages.
• Created ETL operations using SQL Server Integration Services (SSIS) on SQL Server databases.
• Interacted with an Oracle Advanced Queue that served as a near real-time database interface for a globally dispersed internally developed client/server application.
• Created the interface design for exchanging data with an SAP ERP with BizTalk Server 2013 R2. BAM implementation for transaction tracking, ESB implementation for real time transaction status and exception handling.
• Leveraged SQL Server Analysis Services (SSAS) to cube and flatten data sets and and SQL Services Integration Services (SSIS) to extract and transform data that was presented with SQL Server Reporting Services (SSRS) reports to generate management and status reports.
• Created desktop application using WinForms to execute integration between Materials Management and Oracle Advanced Queue; documents were manually loaded to several queues for testing in development and QA environments.

Confidential, Atlanta, GA

Integration Architect / .NET Developer

Responsibilities:

• Confidential manages, maintains, transports, and supplies more than 300 million platforms for our customers.
• Our higher quality pallets, containers, RPCs, bins, trays and store displays support the construction, handling and transport of more efficient and sustainable product loads.
• Confidential platforms and services play a critical role within every leg and across every trading partner in the supply chain.
• Worked with one of Confidential ’s clients, Confidential, to develop a prototype system to track the flow of Confidential pallets to Confidential, out to its customers and their return to Confidential.
• Solution focused on Niagara’s use of Manhattan Associates supply execution software and EDI X12 856 ASNs for inbound pallets and Niagara Bottlings outbound 856 and 850 Purchase Order (PO) transactions to track outbound pallets.
• A similar initiative was executed in Europe where Confidential (UK) provided similar consulting services for this global project; European Confidential uses significantly different sized and configured common handling equipment pool products. Globally, Confidential is the leading manufacturer of supply chain common handling equipment pool products, i.e. predominately pallets.
• Pilot program was validated at several Confidential facilities, Confidential broadened the scope and spectrum of the project to integrate a number of major retailers and manufacturers.
• These corporate entities will encapsulate a variety of enterprise resource planning, warehouse management, transportation management and financial system software solutions.
• The solution included SAP, Microsoft, Oracle, Siebel and SAS software products as the host systems and backend RDBMS.
• Development technology leveraged included: HTML 5, XSLT, EDI ANSI X12 and Python with APIs and Adapters that were REST and SOAP based. Much of the data exchanges relied on JSON to move collected data to the web presentation layer.

Confidential, Norcross, GA

BizTalk Architect / .NET Developer

Responsibilities:

• SOA environment with disparate internal and external systems
• Business Rules Engine used for controlling processing
• BizTalk ESB Itinerary processing for itinerary versus content controlled routing
• Migrated OFS customer transactions from webMethods to BizTalk Server 2010
• Project focused on four primary EDI X12 customer transactions:
• 850 Purchase Order
• 855 Purchase Order Acknowledgement
• 856 Advanced Shipping Notification
• 810 Invoice
• SAP ERP was the host system
• OFS SAP iDoc transactions converted to EDI ANSI X12 customer transactions
• Encryption Certificates: SHA2
• Transport and translation layer conversion from webMethods to BizTalk 2010
• Transport protocols: FTP, SFTP, AS2 and HTTPS

Confidential, Atlanta, GA

BizTalk Architect / .NET Developer

Responsibilities:

• EDI ANSI X12 message types processed:
• 160 Transportation Automatic Equipment Identification
• 810 Invoice
• 812 Credit Memo
• 850 Purchase Order
• 852 Product Activity
• 855 Purchase Order Acknowledgement
• 856 Advance Ship Notice
• 860 Purchase Order Change Request
• 997 Functional Acknowledgement
• Processed HIPAA HL7 message types:
• 270 EDI Health Care Eligibility/Benefit Inquiry
• 271 EDI Health Care Eligibility/Benefit Response
• 276 EDI Health Care Claim Status Request
• 277 EDI Health Care Claim Status Notification
• 278 EDI Health Care Service Review Information
• 820 EDI Payroll Deducted and other group Premium Payment for Insurance Products
• 834 EDI Benefit Enrollment and Maintenance Set
• 835 EDI Health Care Claim Payment/Advice Transaction Set
• 837 EDI Health Care Claim Transaction Set
• Translated EDI X12 to SAP iDoc
• Translated SAP iDoc to EDI X12
• EDI X12 to custom positional delimited flat file
• EDI X12 messages were received from and sent to:
• Pharmaceutical manufacturers
• Distribution centers operated by McKesson on east and west coasts
• SAP version 6 ERP running SAP EHP 7
• SAP iDoc messages transmitted and received via the BizTalk WCF-Custom LOB Adapter
• Automated processing of fourteen major pharmaceutical manufacturers (including):
• Pfizer
• GSK
• Merck
• Sanofi
• Custom BAM Framework implemented to provide transaction visibility and analytics
• Custom reporting web portal created using:
• ASP.NET reporting portal and application team and application support sites
• SSRS custom reports for reporting portal
• SSIS packages used to provide roll up data for custom reports
• SSAS provided data for dynamic financial and demographic reports
• SharePoint portal for presentation layer
• ESB Toolkit 3.2 employed for Itinerary Processing and Exception Handling
• ESB Exception Portal and ESB Fault Message code provided power users visibility to the system
• BizTalk CAT Instrumentation Framework employed for real-time tracing of transactions
• SCOM 2012 event monitoring fully exploited to monitor and maintain system health
• Experience/exposure to HL7 versions 2 and 3

Confidential

BizTalk Architect / .NET Developer

Responsibilities:

• Multiple BizTalk 2006 R2 applications ranged from moderate to extremely complex
• All Southern legacy mainframe work management systems were replaced by IBM Maximo
• Designed and constructed interfaces:
• External third-party manual interfaces replaced by Maximo/BizTalk Interfaces
• Legacy mainframe applications replaced by Maximo/BizTalk Interfaces
• Oracle Financial Interfaces via WCF-Custom Oracle Adaptor
• Complete SDLC project: Scoping to Production Implementation and Support
• Last of three BizTalk architects/developers remaining when GLSCAPE officially ended
• ANSI EDI X12 interfaces: 810, 820, 823, 850, 855, 860 and 865
• Complex orchestrations and custom Receive and Send pipelines
• Business Rule Engine implementation
• Custom assemblies called within BizTalk messaging components
• GLSCAPE moved Confidential to an SOA environment
• Microsoft ESB Guidance created:
• Robust ESB Exceptional Portal
• ESB Fault Messages tracking

Confidential, Atlanta, GA

Integration Architect / BizTalk Developer / .NET Developer

Responsibilities:

• Integration architect; designed, built and implemented an integration solution that provided business process management (BPM) and enterprise application integration (EAI) between a Logica
• Work Management Information System and a custom internal application entitled Compliance Tracking System. The architected solution was built using BizTalk 2006 R2.
• Two Oracle 10i databases served as data stores; messages were pushed and pulled from several IBM MQ Series queue managers and queues. Mercator 6.71 integration tool was replaced with BizTalk 2006 R2. Project selected as Microsoft BizTalk 2006 R2 technology adoption program (TAP).
• Focus was on the Microsoft BizTalk Line of Business (LOB) Adapter Pack TAP; specifically, the development of the WCF-Custom Oracle Adaptor.
• Opportunity provided exposure to the Microsoft development teams.
• This project leveraged the Oracle Windows Communication Foundation (WCF) LOB Adapter Pack that was pending the release to manufacturing (RTM) phase of its product development.

Confidential, Atlanta, GA

BizTalk Technical Architect / BizTalk Administrator / .NET Developer

Responsibilities:

• Implemented BizTalk 2004 messaging solution as a member of Confidential ’s Broadband Transformation — Siebel UCM project team. Functioned as a technical architect during the implementation of Siebel’s Universal Customer Master (UCM) product. BizTalk 2004 was used to process messages to the Enterprise Service Bus (ESB) from Siebel UCM to Siebel CRM applications and vice versa.
• Primary responsibilities included the design and implementation of BizTalk infrastructure related issues, performance tuning, BizTalk 2004 multiple server load balancing and the in corporation of a SQL Server cluster to handle multiple BizTalk Server MessageBox databases. Additional responsibilities included assisting primary development team resolve integration issues during development and supported the product and integration testing teams during the validation phase of the project.
• Concurrent to the Siebel UCM project, I also performed as the BizTalk technical architect on the IPTV project.
• The project’s goal was to provide television over internet protocol (IP) for on demand streaming high definition movies and programming.
• Primary responsibilities involved infrastructure design discussions and assisting developers and technical managers during deployment, including configuration of Microsoft BizTalk 2004 and Microsoft SQL Server 2000 database servers in support of the project.

Confidential, Alpharetta, GA

Senior .NET Developer

Responsibilities:

• Principle duties were to serve as the lead developer of an internal development team; implementing web based solutions for new clients and extending or enhancing web based solutions for existing clients.
• Principle focus of development efforts centered on the development of an automated batch upload process to consume client based data files of various input types.
• Subsequent validation and insertion of this data enabled clients to establish baseline data for new properties or to integrate these new properties into their portfolios.
• Prior to introduction of this enhancement, integrating new properties was labor intensive effort requiring multiple developers and business analysts; final results were often littered with errors due to a lack of adequate validation constraints on data input.
• Technologies used in solution development included ASP.NET with C#.NET code behind pages, SQL Server 2000 complex stored procedures, SQL Server 2000 DTS packages, SQL Server 2000 user defined functions (UDF) and C#.NET to enhance custom framework classes.
• Recommended and demonstrated how the use of BizTalk 2004, as a replacement to SQL Server Data Transformation Services (DTS), as the integration layer could improve speed, reliability, fliexibility and eliminate manual input during batch processing.
• While rejected for phase one of the effort, during phase two, BizTalk 2006 was chosen as the EAI tool which provided complete automation of interface processing; greatly simplifying and improving their billing operations.

Confidential, Atlanta, GA

Senior .NET Developer

Responsibilities:

• Participated in a large development effort to extend the capabilities of Groove, Microsoft’s new Virtual Office application, from a single workspace environment to an unlimited number of workspaces for the purpose of conducting multiple and simultaneous audits.
• Confidential & Confidential needed a means to create a hierarchal group audit structure to manage global, regional and local auditing teams from designated primary team locations; passing instructions and monitoring audit procedures to maintain quality control.
• The application was built with C# .NET on a custom .NET framework that wrapped a file based data store which communicated via XML and flat file messaging using BizTalk 2004 as the EAI tool.
• My responsibilities included custom Groove screen development, coding utilities, smoke testing weekly builds prior to submission to QA, defect tracking and defect resolution.
• The pilot project was deemed an unmitigated success and resulted in additional development projects for ThreeWill beginning in early 2006. This was a very large and complex project that required more than 100 developers, project managers and architects.

Confidential, Atlanta, GA

Senior BizTalk Developer / .NET Developer

Responsibilities:

• Coordinated and executed the migration of NUI Corporation's EDI based EAI system from Elizabethtown, NJ to the AGL Resources data center in Atlanta, GA. Project schedule had very tight timelines.
• Migration had to precede along planned migration of mainframe services from UBS to Axciom.
• Microsoft BizTalk Server 2002 was the principle integration tool; solution included heavy use of orchestration, more than one hundred messaging components and several custom COM DLLs and AICs called by orchestration schedules to read and write to SQL Server database and transform inbound EDI documents to XML and transform outbound XML to positional flat files. Additionally, custom applications performed import and export of files to and from external mainframe systems.
• Developed custom XSLTs and C# Windows Services, class libraries and classes to handle XML document transforms and XML document logging for a large data conversion project.
• Interaction with Logica third party application required programmatic transmittal and receipt of XML messages to/from IBM MQ Series queues. Microsoft Enterprise Library 1.0 was incorporated in project to handle complex multiple configuration files for separate components and robust exception handling.

Confidential, Winston Salem, NC

Senior BizTalk Developer

Responsibilities:

• Assisted in the January 2005 go live of the Confidential eCommerce web site dedicated to increasing volume and efficiency of vendor orders for Sara Lee subsidiary clothing products: Hanes, Playtex, Bali, etc...
• Principle technologies employed during the project included Microsoft server and development tools: Commerce Server 2002, Content Manger, SQL Server 2000, BizTalk 2004, VB and C# .NET applications.
• Custom MSIB v2.5 web site configuration was deployed.
• BizTalk 2004 orchestration, SQL Server 2000 DTS packages, web services and XSLTs handled backend legacy system integration. C# and VB .NET code employed to handle unique MSIB customer requirements and enhance customer experience. VB.NET Code Behind pages used for client and server-side validation and functionality, as well as custom VBScript and JavaScript.

Confidential, Atlanta, GA

Microsoft Consultant

Responsibilities:

• Analyzed, designed and implemented a functionality enhancement to Microsoft’s CRM v1.2 application for Confidential .
• Confidential is Microsoft’s second largest implementation of CRM worldwide and their business requirements exceed the current version’s capabilities.
• Principally, the customization focuses on improving the extensibility and capability of the application’s mail merge process and its interoperability with the Microsoft Word Object Library and Office Primary Interop Assemblies (PIAs) via VB.NET custom classes.
• Contract required extensive documentation.
• All SQL Server 2000 database modifications were affected via Microsoft’s proprietary FetchXML query language; all database queries were written to conform to the Microsoft CRM API and this custom XML based query structure.