Scott Carpenter Email & Phone Number

Portland, Or, Us

Portland, Or, Us

Beaverton, Or, Us

• Create conceptual and logical models based on discussions with the business, following domain driven design principles, including bounded context• Create physical models (SQL and no-SQL) based on logical models• Design schemas for REST APIs, event streaming, data lakes, data warehouses, and data lakehouses• Design data ingestion processes so that ETL rules are contained in database tables and not in code, thereby increasing the speed at which changes can be deployed• Evangelize good data design principles to engineers, product managers, analysts, architects, business and leadership

Beaverton, Or, Us

• Data conversion design and execution• Data integration design• Proactively search for and find data integrity issues• Extensive, detailed, comprehensive data analysis to determine root cause of and possible solutions for data integrity issues• Reverse engineer specifications, including Source-to-Target Maps (STMs), from code• Logical and physical data modeling• Design and execute systematic, comprehensive validation of every attribute on every record for data conversions and utilities built to correct data integrity issues

Beaverton, Or, Us

Analyze data and build requirements for data conversions and integrations. • Design systems, end-to-end integration patterns, and data services to ensure alignment with business needs and priorities, and technical strategy and standards• Create migration and integration strategies and functional specifications, including but not limited to source-to-target mappings (STMs)• Create data flow context diagrams and associated systems process models to provide clarity on integration patterns and identify potential improvements• Query, profile, and analyze data in order to understand use cases, related business processes, and data quality issues, and to identify ways to improve data via system design enhancements and data governance• Analyze data in legacy systems to determine current state physical data model, and then design future state model focused on simplifying and improving design with respect to performance, data quality, usability, and maintenance• Determine design of data in API layer based on structure of data in source systems, use cases, and performance considerations• Distill complex data issues into easily digestible summaries to assist leadership in understanding options for resolving issues• Validate data models against data, and recommend changes as necessary• Collaborate extensively with business users, engineers, data modelers, architects, information management (IM), and POs/PMs in agile environment, providing support and/or direction as needed, including driving evolution of data models, system design, and integration patterns• Systematically test data migrations and integrations using various tools, including SQL, Snowflake, Excel, Athena, Hive, and Python• Operating models include Waterfall, Scrum-fall, SAFe, and Agile

London, England, Gb

Analyze data and build requirements for conversions/implementations of outsourced and co-sourced data management systems for Fortune 500 companies. • Analyze data to understand the story it tells. Build functional and technical requirements for the processes that import, export, utilize, and report data.• Analyze flow of data from various conversion and integration sources relative to various output targets (files to other systems, calculators, reports, etc.) in order to determine best way to capture, store, maintain, and report data while ensuring data integrity.• Design and implement complex SQL for integrating data from multiple, disparate sources.• Meet with clients and internal stakeholders to determine business requirements.• Design and implement custom, SQL based test plans for systematically testing complex data conversion processes.• As member of internal Data Assurance Initiative, determine ways to automate and standardize processes for identifying data issues and ensuring data integrity.

• Work with internal and external stakeholders, from highly technical developers to decision-making executives, to understand data relative to business needs in order to build technical requirements for conversions, implementations, and system improvements• Program and manage programming of conversions, integrations, implementations, and system improvements using SQL, BizTalk, MS Access, and proprietary systems and programming languages• Design and implement data extracts and imports using SQL, BizTalk, and proprietary systems and programming languages• Convert client data between platforms using proprietary ETL tools• Design and implement changes to schemas in order to implement new system features• Audit programming to identify issues; implement improvements based on my findings• Design and implement complex reports others thought were not possible by creatively using SQL and proprietary languages to overcome the limits of pre-existing table structures• Re-engineer reports written in SQL and proprietary languages to be more efficient and accurate, to include built-in controls, and to reduce programming maintenance costs• Design and implement detailed, comprehensive test plans• Design and build custom database systems from scratch for ad hoc projects• Systematically analyze data using SQL, Access, Excel, and proprietary languages/systems in order to understand potential issues and determine requirements gaps, overlaps, and contradictions• Reverse engineer functional and technical requirements by analyzing codebase

Chicago, Illinois, Us

• Responsible for day-to-day management of relationship with $2.5+ MM client. Manage staff of four senior consultants and fifteen associate consultants. Manage simultaneous development of multiple employee benefit management systems. Define project scope, timeline, and deliverables. Define team roles and manage client expectations. Organize and lead internal and client meetings to facilitate implementation. Work with client management and internal staff to reduce cost and improve quality.• Member of client committees to design interface between web, interactive voice response (IVR), and data management systems.• Functional and technical lead on implementation of standard system features into legacy systems.• Interact extensively with all levels of client staff and management, HR staff, insurance carriers, pension trustees, actuaries, payroll vendors and administrators, and printers/publishers.• Mentor, counsel, and motivate internal consulting staff. Promote teamwork and code of ethics through words and actions. Identify and diffuse potential personnel issues. Perform formal annual performance appraisals.

Chicago, Illinois, Us

• Responsible for full life cycle development of employee benefit data management systems. Lead client meetings to determine true business needs and requirements. Design conversion process and system structure. Manage system development, and create, execute, and document system test plans. Document system functionality. Implement system, train users, and provide ongoing support.• Improve system performance and reduce costs in older systems by designing and implementing new relational data models and system structures.• Develop and conduct formal training programs for clients and internal staff. Train programmers, administrators/end-users, and other consultants.

Chicago, Illinois, Us

• Design, develop, test, document, implement and maintain data management systems for consulting firms in the employee benefits industry using RAD relational database software (Applaud). Create and customize databases, import and export data, create queries and reports, produce customized communications using report writing software.• Work directly with clients to determine needs and requirements.

Laurel, Maryland, Us

• Develop systems level mathematical models of various warfare engagement scenarios, with emphasis on missile systems.• Program computer simulations of these models in C and Matlab in order to analyze the impact of various parameters on combat system effectiveness.• Document findings in several department wide memoranda.• Present results to project sponsors.

M.A., Economics

Applied Mathematics, Computer Science

B.S., Systems Science Engineering