Member of Customer Connect Program Data Architecture Team working to integrate customer data from various sources into a new SAP HANA EE database along with implementation of a new multi-jurisdictional customer billing system using SAP IS-U. • Designed, developed, and implemented SQL Server schema to create a common billing extract process for various Duke Energy product marketing vendors to receive customer and billing data. • Designed and implemented various views and procedures in HANA EE and SQL Server to provide data views of new SAP IS-U data to various consumers.Member of Common Outage Platform team from October 2018 to April 2019 responsible for the design, development, and implementation of an Oracle database used to consolidate outage data from all jurisdictions to improve outage communications. • Developed and implemented multiple Oracle stored procedures to optimize retrieval of data for common outage reporting and interfaces. • Analyzed and re-designed Oracle database security implementation to ensure easy and flexible maintenance while ensuring access by both applications and ad-hoc users followed the principle of least privilege.Member of Digital Transformation Data Services Center until September 2018 applying data architecture best practices to provision data from across the enterprise in the fulfillment of analytics use cases. • Designed, developed, and implemented SQL Server data mart and ETL programs using Informatica to consolidate demographic and giving information for the Duke Energy foundation. • Designed and implemented SQL Server data mart for a Cyber Security data mart to consolidate data from various threat monitoring systems.

Member of Operations Applications Data Architecture Team focusing on the data architecture of the regulated customer billing systems, customer operational data store (ODS), and customer data warehouse (DW). Responsibilities Include:• Logical database design based on business requirements.• ETL process architecture and SQL development.• SQL and process tuning to achieve maximum efficiency.Accomplishments include creating conceptual business models, logical database schemas, database implementation, and data integration into the ODS and DW for custom developed systems including: • Dynamic Customer Interactions (DCI) (SQL Server) • eBilling Synchronization between ODS, billing, and vendor systems. (SQL Server) • Time of Use Rate Calculator (TOURC) (Oracle) • Customer Contract Preference Center (CCPC) (Oracle) • Best Rates / New Rates (BRNR) (SQL Server) • Enterprise Customer System (ECS) integration into ODS and DW. (SQL Server and Oracle) • Meter Data Management System (MDMS) integration into ODS and DW (SQL Server and Oracle)

Managed the Call Center Application Support Team responsible for development and support of Duke Energy's call processing and internet self-service applications. Accomplishments include:• Led team of up to 12 developers in the development and support of call processing and internet self service applications.• Accountable for production systems availability, ongoing maintenance of supported applications, and delivery of new application functionality on schedule and on or under budget.• Developed complete IT services profile including FTE and cost requirements to support services performed along with complete process and procedure documentation for those key services.• Designed, implemented and maintained supported application availability and support incident metrics including Oracle SQL to retrieve detailed data and Excel spreadsheets using pivot tables to analyze and track availability and incident resolution.

Member of the CBIS DB2 Database Administration team responsible for development and support of the CBIS database. Accomplishments include:• Designed and implemented DB2 tables, wrote complex program SQL, and provided both development and production support for CBIS DB2 batch and online packages and utility jobs.• Designed, implemented, and supported a multidimensional data mart of customer electric usage data for use by the marketing department.• Wrote user manual for the Utility Automation product developed in house by my DB2 DBA team mates.• Developed REXX / ISPF Dialog application on the OS/390 platform to track DBA time spent on projects and specific process and SQL tuning efforts.

Member of the Data Delivery Data Administration team assigned to the development of the Customer Billing and Information System (CBIS). Accomplishments included:• Created logical database schema designs for several Customer Billing and Information System (CBIS) deliverable's and assisted DBA’s with database creation, SQL and process tuning.• Led database team in evaluation and selection of ER diagramming tool (ERwin) and development of process and standards for CBIS project logical database design. • Developed VBA application to generate reports from ERwin ER diagrams of the logical database schema and REXX/MVS DDL Editing application.• Developed REXX / ISPF Dialog application on the OS/390 platform to modify and expand DDL generated from ERwin and then re-generate the DDL for implementation in DB2 for OS/390.

Member of the Commercial Banking System (CBS) Core Application Development team. Accomplishments include:• Managed small team in the development of a customer combine subsystem using Unix C with embedded SQL for an Oracle database. Performed technical design, programming, and creation and management of the project plan.• Designed system architecture and multidimensional data model for a sales activity reporting subsystem and directed implementation of a prototype using Cognos Impromptu and PowerPlay.• Developed small time reporting system for team members using Microsoft Access.

Member of the Commercial Banking System (CBS) Document Definition Development team. Accomplishments include:• Conducted JAD sessions to define data requirements for automated loan documents. Led small team in logical database schema analysis to match requirements with the existing tables in an Oracle database.• Designed and implemented loan document definitions for a suite of loan closing documents using an Oracle database and Lotus AmiPro macros.• Created estimating model, task and resource estimates, and identified task dependencies for the next major release of automated loan documents for CBS.• Authored development process for creating automated loan documents using a customized Document Definition Language and Lotus AmiPro macros.

Member of the High Performance Transaction System (HPTS) Balancing application development team. Accomplishments include:• Performed structured high-level design, C programming, inspections, and unit test of several major components for the HPTS Balancing product in the OS/2 Presentation Manager (PM) environment.• Trained and supervised an overseas client in techniques for development of an HPTS client-side application, with emphasis on object-based design using C, OS/2, and Presentation Manager (PM).• Developed complex make file generator using REXX for OS/2.

Member of the Application Solutions Lab responsible for the development of software packaged applications for a variety of industries. Accomplishments include:• Evaluated relational database design and system architecture of six Business Partner Property Management Systems, and made recommendations to senior management for future Business Partner relationships.• Designed, implemented using Clipper, tested, and managed the scheduling and delivery of IBM's Electronic Service Management System/2 - Transmission System.• Wrote customized management report facility for DMS using RPG/400.• Designed user-interface and wrote server portion using RPG/400 of client-server vehicle search application.• Created interfaces linking IBM's AS/400-based Dealer Management System (DMS) to the PC-based Toyota and Chrysler Dealership Communication Systems using RPG/400, C, and Microsoft Assembler.