Patrick Hoerter Email & Phone Number

Uniontown, Pa, Us

Pittsburgh, Pennsylvania, United States

Atlanta, Georgia, United States

Architecture and construction of data solutions on Microsoft Azure and on-premises SQL Server, specializing in data warehousing (star schema / Kimball), ETL/ELT with Azure Data Factory and/or SSIS, Dashboards, reports, and semantic models in Power BI Desktop (DAX) and Power BI Report Builder (paginated). Delivery of data virtualization stacks in Denodo, data integrations in c#, and process orchestration via Azure Logic Apps.

Chicago, Illinois, United States

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.

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.

Carnegie, Pa

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.

Greater Pittsburgh Area

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.

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)

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.

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.

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.