Senior Consultant

• Oct 2020 - Present

Cloud Architect, Data Platforms

• Dec 2017 - Sep 2020

Architecture and construction of cloud-based data solutions on Microsoft Azure, specializing in data warehousing, analytics, and ETL/ELT with SSIS, Azure Data Factory and Spark SQL on Databricks. Architecture and construction of cloud-based data solutions on Microsoft Azure, specializing in data warehousing, analytics, and ETL/ELT with SSIS, Azure Data Factory and Spark SQL on Databricks.

Senior Solution Architect

• Jan 2012 - Dec 2017

Design and build cloud-based B2B workflow and integration platforms on Microsoft Windows Azure, using SQL Azure, Workflow Foundation 4, Entity Framework, and Windows Azure Service Bus. Design and build cloud-based B2B workflow and integration platforms on Microsoft Windows Azure, using SQL Azure, Workflow Foundation 4, Entity Framework, and Windows Azure Service Bus.

Salesforce Architect

• Jul 2012 - Jul 2017

Design and implement CRM solutions and B2B integrations on the Salesforce.com cloud platform. Responsibilities include workflow mapping and analysis, system architecture, implementation, and support. Technologies used include Apex (classes, triggers), Apex REST, Salesforce.com data API, Visualforce, and Force.com Sites. Design and implement CRM solutions and B2B integrations on the Salesforce.com cloud platform. Responsibilities include workflow mapping and analysis, system architecture, implementation, and support. Technologies used include Apex (classes, triggers), Apex REST, Salesforce.com data API, Visualforce, and Force.com Sites.

Solutions Architect, Consultant

• Jul 2013 - Jul 2014

Design ETL processes for ingestion of data from source systems into an Enterprise Atomic Data Warehouse (Oracle HDWF / Healthcare Data Warehouse Foundation) via OHADI (Oracle Healthcare Analytics Data Integration) on Informatica. Participate in team-based data analysis. Conduct business process modeling to support analysis, development, and testing phases. Key platforms and technologies include: Medipac (McKesson Healthquest), Epic, Cerner, HL7 messaging, Oracle, and Informatica. Design ETL processes for ingestion of data from source systems into an Enterprise Atomic Data Warehouse (Oracle HDWF / Healthcare Data Warehouse Foundation) via OHADI (Oracle Healthcare Analytics Data Integration) on Informatica. Participate in team-based data analysis. Conduct business process modeling to support analysis, development, and testing phases. Key platforms and technologies include: Medipac (McKesson Healthquest), Epic, Cerner, HL7 messaging, Oracle, and Informatica.

Senior Software Engineer

• 2011 - 2012

Architect and implement client/server database applications, web applications, and customizations to Microsoft Dynamics CRM. Author T-SQL stored procedures, tune them for performance, author reports in SSRS, build SSIS packages to load data from Oracle into Microsoft SQL Server, and assist with a migration to OBIEE (Oracle Business Intelligence Enterprise Edition) Architect and implement client/server database applications, web applications, and customizations to Microsoft Dynamics CRM. Author T-SQL stored procedures, tune them for performance, author reports in SSRS, build SSIS packages to load data from Oracle into Microsoft SQL Server, and assist with a migration to OBIEE (Oracle Business Intelligence Enterprise Edition)

Vice President of Information Technology

• Feb 2004 - May 2011

Conduct project planning and management, systems architecture, database administration and software construction. Oversee the activities of the external consultants. Select and implement enterprise-wide technology strategies. I took a very hands-on approach, working daily with my development team members and participating in all parts of project lifecycles. Design and implement data warehouse for e-commerce, customer service, telephone sales, and consumer credit portfolio analysis.

Senior Application Developer

• Jun 2001 - Feb 2004

Model data, define interfaces for components, coordinate business-to-business data exchange processes, administer databases, and author software. Serve as a mentor for less senior staff members.

DBA, Information Delivery

• Feb 2000 - Jun 2001

Administer data warehouse for credit card portfolio analysis of 70 million cardholders with over 3000 analyst users. Develop and support ETL processes. Develop and manage transactional system components for large-scale inter-bank currency trading. Develop and manage ETL processes for large-scale financial data warehouse. Design and construct metadata management tool with integrated source code control for database changes, DDL, and stored procedures. Assist with design of reporting platform for SEC and Bloomberg data. Show less