Dwayne D. Email & Phone Number

Remote

o Design, plan, and implement the integration of Guidewire ClaimCenter (GWCC) data into existing legacy data warehouse, semantic layer, and presentation layer objects. Lead a team of up to 15 data engineers, analysts and test engineerso Partner with business analysts and subject matter experts for analysis and change management Reconcile data model differences between legacy and GWCC models Product owner for Enterprise Data Warehouse Manage bug remediationo Coordinate with CSI program and workstream leads

o Maintain and enhance all aspects of the SAIF data warehouseo Research, promote, implement best practice EDW methodologyo Lead engineer for various projects Self Service Business Intelligence (SSBI)• Replace legacy Impromptu functionality with SAS star-schema technology Where is Premium Going• Design and implement ELT pipelines and metrics enabling Premium Attribution Analysis• Data modeling to illustrate different points of view (Marketing vs. Finance) on Premium Attribution Analysis GW Daily GL• Modelling, design, and coding related to changing the GL temporal grain from monthly to daily.

Beaverton, Or

o Develop end-to-end Orders conceptual models, using domain driven design, across vertical and horizontal business capabilities and entity lifecycles. Conduct subject matter expert interviews Present to non-technical stakeholders for adoption Operate in a highly-matrixed organization requiring cross-functional and cross-technology coordinationo Partnered with various technical business solution delivery teams to design, implement, and document solutions Integrated Product Creation PCX off-the-shelf implementation with enterprise information architecture Architected data acquisition into cloud-based analytic datamart for Financial Planning applications delivered via TM1 Modeled Assortment Planning requirements and interfaces between Product Line Planning and Go to Market (Sales)o Enterprise Information Management Modeled Vendor, Customer, Location Master Data Developed enterprise canonical API schemas for the same

o Created and maintained enterprise logical and physical data models for global data warehouse, reporting and analytics solutions Supply Chain Logistics, Point of Sale, Finance, Go to Market, Master Data Management, HR Geography-specific models, integrations and extractso Drove various Tableau, Cognos and custom report visualization solutions Data acquisition, report design, requirements definition (e.g., Global Category Dashboard)

Teradata, Oracle, SAP BW development. Datawarehousing ETL.o Technical Lead, Teradata and BW solutions Designed and implemented "never-can-be-done" Value Added Service delta-enabled data extraction from SAP R/3 into SAP BW Managed transition of internal production support capabilities to managed service structure Developed self-service code review applicationo Designed and configured ETL per business requirements, to optimize performance, to implement changes in technical landscape

o Oracle and SAP/BW datamart application analysis, design, development, quality assurance, and implementationo Production and release support

Portland, Oregon Area

o Managed various standardized testing applicationso Performed data analysis and migration of CRM database from legacy systems to new SQL Server database

Portland, Oregon Area

o Supervised administration and reporting of NWEA standardized tests to over 100 client school districtso Performed in depth analysis to explain data anomalies and respond to client inquirieso Provided classroom training and follow-up phone support to users of NWEA’s Scoring & Reporting System

Portland, Oregon Area

o Responsible for acquisition, installation, and support of desktop and laptop PCs and network printers for 300-person central location and four remote offices o Coordinated varied vendor, consultant, and contractor relationships