Responsible for providing daily technical support to Stock Analysts, Traders and Audit teams. Manage and perform updates to all layers of Trilogy’s integration platform including front-end, middle-tier and backend systems development as required. Developed solutions using Visual Studio 2015, C#, ASP.Net, Microsoft SQL Server and Microsoft Azure.• Performed ongoing application maintenance and support to Trilogy’s brokerage, trading and accounting systems using Visual Studio 2015, C#, ASP.Net, .NET 4.5, MVC, Silverlight, SignalR, JavaScript, HTML, CSS and T-SQL• Secured access to both internal data and client data by developing and implementing Single Sign-On (SSO) using the SAML 2.0 specification and 2-Factor Authentication for multiple internal applications utilizing DUO Identity and Access Management services in accordance with SEC guidelines and regulations• Designed and developed a release management strategy for Trilogy’s application suite utilizing Microsoft Team Foundation Services• Conducted periodic assessment of and performance tuning on multiple Microsoft SQL Server databases, streamlining database structures and design as necessary to ensure optimal database and application performance using SQL Performance Monitor and Database Engine Tuning Advisor. Also responsible for monitoring daily and weekly backups, performing periodic validation and responding to requests for data restoration as required

Design, develop and implement Microsoft SQL Server 2014 based data warehouses for clients of McG Research & Marketing. Document system design and conduct training to end users. Perform restores and implement recovery procedures, handled performance tuning and conduct regular system backups. • Setup install and configure 4 Microsoft SQL Server 2014 databases per design specifications• Developed and implemented ETL platform which integrated 3 database systems (SQL Server, MySQL and HFSQL+) using T-SQL for all scripts, stored procedures and triggers on the host Microsoft SQL Server instance• Perform ongoing management and maintenance of all database systems including regular performance tuning using SQL Performance Monitor and Database Engine Tuning Advisor to ensure optimal application and database performance• Conducted training sessions for end-user on ongoing data warehouse management and maintenance. Handle requests for data extracts and performed data analyses as requested by client

As the Colorado Child Care Licensing System’s (CCCLS) support team lead, we were tasked with providing daily support for our users as well as participating in larger strategic initiatives to modernize Colorado’s Office of Information Technology’s application landscape• Designed and developed integration layer for the CCCLS application in Microsoft Visual Studio using C#, .NET 4.5.1, Object Relational Mapper (ORM) and T-SQL with a Microsoft SQL Server 2008 instance as the data repository and IIS for hosting a set of service based WCF .NET 4.5.1 applications• Developed the data models used in the integration layer per specifications provided by analysts working with the OIT modernization team

Headed the team responsible for Solutions Architecture and Systems Integration. Designed and developed customer integration solutions for Greytruck’s Emergency Services Information Management System, a Fire Intelligence and Analysis platform, providing reporting and analysis services to various Fire Department Agencies across the country. Provided implementation and post-implementation services and support to all client agencies.• Designed, developed and implemented ETL and bulk data transfer services in Visual Studio 2013 using C#, .NET 4, WebAPI, T-SQL and Microsoft SQL Server Management Objects, BCP services and Microsoft SQL Server 2012, 2014• Developed a client and server configuration/licensing utility sent to all client agencies using Visual Studio 2013, C#, .NET, WCF and JSON. Licensing utility implemented a proprietary algorithm used for key generation• Designed database architecture used to store client staging data and wrote all ETL scripts, stored procedures, triggers and SQL Server jobs using Microsoft SQL Server 2012, 2014 and T-SQL• Secured client data transfers using a 2-Stage authentication and a proprietary session-based protocol designed and implemented using Visual Studio 2013, C#, .NET 4 framework and WCF and data encryption when sending data from a client site to integration server

Responsible for the management and maintenance of all operational systems including the Call Center and CRM platforms, Salesforce, Accounting and Finance systems and multiple database systems. • Designed and implemented a data warehouse on Microsoft SQL Server 2012 using industry best practices. Implemented a star-schema design with a staging database and wrote all ETL scripts, stored procedures and triggers using T-SQL • Developed and implemented several ETL feeds from Salesforce using Visual Studio 2012, C#, .NET 3.5, WCF, SOAP 1.2, XML and Salesforce’s Apex API, Outbound Message mechanism and Sforce Object Query Language (SOQL) for change-data-capture (CDC) and Microsoft SQL Server (T-SQL) for all SQL scripts, stored procedures and triggers. The web-based services were hosted using Microsoft Internet Information Services (IIS)• Designed and implemented real-time data feed from Five9’s Cloud Contact Center (SaaS) platform using Visual Studio 2012, C#, ASP.Net, WebAPI, .NET 3.5, SOAP, XML, T-SQL and Microsoft Internet Information Services (IIS) and Message Queue services• Developed and implemented a batched data feed from the accounting/finance system using a utility written in Microsoft Visual Studio 2012 using C#, .NET 3.5 framework, Object Relational Mapper (ORM) and SQL. Data was extracted from a PostgresSQL database and formatted using XML and transmitted using SOAP and Microsoft Internet Information Services (IIS)• Developed an integration service layer for legacy accounting/finance system in Microsoft Visual Studio 2012 using C#, .NET 3.5, WCF, Object Relational Mapper (ORM) and T-SQL allowing direct application access to finance and accounting data• Planned, designed and developed an Install Operations Management system. Using an Agile/Iterative SDLC approach, I developed a system in Visual Studio 2013 using C#, Razor, WebAPI, .NET 4.5, WPF, WCF, HTML, CSS, Bootstrap 3, JQuery and T-SQL and MVC for the application’s design framework

Company specialized in providing CRM Applications, Implementation and Consulting

Responsible for managing our Global EDI Development team which provided B2B solutions for our global Air and Sea, Supply Chain Management and European Road Transport customers. Coordinated development efforts with internal regional application teams, business analysts and near-shore development teams.• Successfully implemented over 65+ EDI/EAI projects ranging from simple single document exchange customers to more complex supply chain logistics customers such as Abercrombie & Fitch, Haverty’s Furniture, Hunkemoeller and Case New Holland Industrial with dozens of inbound/outbound EDI documents (ANSI X12, EDIFACT) integrating with order management, warehouse management and transportation management systems• Using a wide array of applications and systems available to us including TIBCO Enterprise Messaging Service, Business Process Management and Application Integration modules, we designed solutions to meet our client’s needs in Microsoft Visual Studio 2008 using C#, VB.Net, .NET, HTML, CSS, Borland Delphi 6, 7 (Object Pascal), Microsoft SQL Server 2008 (T-SQL), Oracle RDBMS 9i, 10i (PL/SQL) for bespoke requirements. More generic requirements were developed within Sterling Commerce’s Gentran Server and Inovis’ TrustedLink EDI/EAI software whenever applicable

Held a senior role managing and coordinating the team development efforts for customers and partners with a focus on the US, Latin American and Canadian regions. Responsibilities included analysis, system design and database modeling and development. • Led the development team responsible for the design and implementation of the purchase order management and tracking and tracing systems using Borland Delphi 5, 6, 7 (Object Pascal) for the UI and Oracle RDBMS 8i, 9i (PL/SQL) for the database backend. The Customer Tracking and Tracing Portal was designed and written using Microsoft Visual InterDev 6.0 with an Oracle RDBMS 9i data repository• Project Manager for the team responsible for evaluating, designing and developing Business Objects’ proof-of-concept project. The project consisted of several canned reports and “universes” (Business Objects’ semantic layer) targeting multiple business domains and a data integrator implementation performing ETL against an IBM AS/400 DB2, Microsoft SQL Server (T-SQL), Sybase SQL Server and Oracle 9i (PL/SQL) database serving as the data mart/data warehouse for the project. The project was a resounding success and was promoted to be the global business intelligence and reporting solution for the company• Developed and implemented the integration layer between the Customer Tracking and Tracing Portal, Gentran Server and Inovis’ TrustedLink EDI systems using Borland Delphi (Object Pascal) and PL/SQL• Provided database administration, development and modeling services for all database vendor platforms. Designed and maintained new and existing database models and provided application SQL tuning and database performance tuning, weekly and monthly backups and capacity planning services as needed

Held a key development role for the newly created Client/Server group within United Healthcare. Our primary focus was to make business process improvements as identified by our analysts. Worked directly with clinical staff members during the analysis phases of various development projects. Provided daily support to multiple departments including Claims, Provider Relations, Provider Credentialing and our 32 Urgent Care centers.• Participated on the team responsible for the development of a windows based client/server application used by our Urgent Care centers using Borland Delphi 2, 3 (Object Pascal) for the UI and middle-tier and Sybase SQL Server/Pyramid Universe/PICK for the database backend