Joined the Data Orchestration Community of Service, which provides technologies that integrate data from multiple sources to enable effective maintenance and auditing of master data automated data quality rules, low-code solutions for managing master data with no existing automated source of record, and low-code solutions for automating hierarchical, approval workflows. Objectives of this new team also include providing intelligence regarding the best and most appropriate data source for a particular business process need, and providing strategic technology support for Master Data Management initiatives.Central to achieving all of this is building the organization’s capabilities on the Palantir Foundry platform.

• Designed user interface, developed queries, and mapped calculation data elements for an application used by the Natural Gas Accounting group to determine the actual cost of gas each month for regulatory compliance.• Designed data integrations for the Gas Transaction Information System (GTIS), an implementation of the Trellis Energy Transaction Management System used by Duke for contract management, demand forecasting, supply logistics, invoice reconciliation, and large volume commercial and industrial billing across jurisdictions in five states. • Learned and applied North American Energy Standards Board (NAESB) Wholesale Gas Quadrant standards for X12 EDI transactions for Nominations and Flowing Gas.• Designed tables and ETL processes.• Developed SQL Server stored procedures and Oracle views, and enhanced CAWA jobs and Informatica workflows.

• Developed SSAS tabular models, SSIS ETL packages, and SQL Server stored procedures, views, and Agent jobs for the Enterprise Resolution Execution Office (EREO).

Helped launch a company providing custom leadership development solutions worldwide. Served as primary contact with the firm’s attorneys and accountants, and primary liaison between core team and parent entities.

• To support the implementation of the Navis N4 terminal operating system at APMT’s Los Angeles facility, developed SSRS reports running against a Navis N4 SQL Server database to replace existing reports running against a Navis Express Oracle database.

• Assessed ETL processes of existing spend categorization application to identify dependencies and develop decommissioning plan. Designed new ETL processes for new spend classification solution.• Developed reporting capabilities for a new enterprise procurement services application.