Stephen Marchetti Email & Phone Number

Acton, Massachusetts, Us

Lead the technical team responsible for Corporate Systems. Area of ownership includes the SAP ecosystem (S/4, GTS, SAC planning/reporting, Integrated Business Planning, Business Technology Platform, etc.) across technical displaces (development, security, Administration/BASIS, Infrastructure, business intelligence, database administration).

Acton, Massachusetts, Us

Lead the AX technical work stream in support of key strategic programs such as the AX Upgrade Program as well as Production Support.

Aberdeen, Scotland, Gb

As a member of the Enterprise Architect team I am functionally focused on back office systems (HR, ERP, Time and Expense, etc.) and technically focused on Data, Integration and Solution Architecture. My responsibilities include definition of technical platforms to support the enterprise as well as driving processes within individual projects. PlatformIn an ongoing effort to modernize integration platforms an initiative has been undertaken to refresh the integration architecture. A key component is evaluation of integration platforms (SnapLogic, Boomi, etc.).Workday implementationAFW is presently undergoing implementation of Workday as a global HR solution to replace 30+ systems.• Model data for migration and integration purposes• Lead the design, development and execution of the data migration framework used to pull, version and validate from source systems• Define the overall approach to integration for the various integration scenarios between Workday and AFW systems (cloud, on premises, off premises)Business Process OptimizationAFW is undertaking a business process optimization program aimed at radically altering how Finance and Human Resources systems are managed and services delivered, with the goal of streamlining operations. A partner has been engaged to provide best in class systems and services to sit across existing AFW operations. o Provide partner resources with access to AMEC systems (36+) across several geographic regions (North/South America, Europa, Asia/Middle East) through a single Citrix virtual desktop environmento Work cooperatively with business owners of applications to ensure business processes can be efficiently operated on top of the Citrix environmento Work with vendor teams in Hyderbad and Manilla to deliver the technical implementation as well as act as the main technical point of contact for the business, vendor and internal application teams

Aberdeen, Scotland, Gb

I am working on the continued implementation and deployment of the organization’s global ERP system (Microsoft Dynamics AX). Ongoing work is to enhance system functionality and support the deployment of additional business groups into the system.In my role as Integration Architect I lead a geographically diverse team (US, Canada, UK, Jordan) in the implementation of integrations between AX and other systems (internal, external, hosted).• Work with business and functional owners to define integration requirements• Define the integration architecture to allow AX to exchange data with internal and external systems (Oracle SOA, AX AIF, .NET/WCF, ActiveBatch job scheduling)• Implement SOA and ETL based integration solutions between AX and internal and external AMEC systemsAs Performance Lead I lead an interdisciplinary team from the program, administration, database administration and infrastructure to assure the solution provides the required level of performance.• Work with the business to determine which processes are candidates for inclusion in automated testing• Development regimen to build automated load tests which includes working with the business and functional teams on system and trace recordings of test scenarios• Execution of load testing (automated and manual) to assure the solution remains performance as it evolves and additional business units are deployed• Ongoing monitoring of the production system• Remediation of issues identified through the load testing regimen or reported in productionIn addition the above roles are the following miscellaneous responsibilities.• Provide solution architecture (on premises kit, solution upgrades, cloud offerings)• Ownership of the overall development process and development environment• Lead the implementation of the build and release process for AX, .Net and database technologies• Coordination and management of vendor relationships (Microsoft, Advanced System Concepts, Lexmark and others)

Durham, North Carolina, Us

Within the Clinical Application Development group developed an integration which collected data from Electronic Data Capture systems for ongoing clinical drug trials, bringing them into the Clinical Management System and data warehouse. The systems were both internal and external and provided by several different vendors. The integration was implemented using TIBCO Business Works as the integration tool, JMS for messaging as well as a Java based front end.• Implemented integration using TIBCO JMS and Business Works• Redesigned the front end Java application which manages the integration (Java, Spring, Hibernate, Maven)

Aberdeen, Scotland, Gb

Lead a geographically diverse (east and west coast of US, Canada and the United Kingdom) development team responsible for the implementation of a global instance of a Microsoft Dynamics AX ERP system. Development team was built using a variety of resources.o Internal Amec Resourceso Contractorso Full time hiresThe position includes both management and architectural ownership of the Data Migration Framework, Integration Infrastructure, Data Warehouse, Dynamics AX and the Software Build and Release process. Additional responsibilities include Solution Architecture and Release Engineering.

Aberdeen, Scotland, Gb

Lead the implementation of a combination of custom developed and COTS systems. Responsible for the integration and orchestration infrastructure and architecture.

Irving, Texas, Us

Pharmaceutical ProjectThis project involved the redesign of an ETL process that built a marketing data warehouse (Oracle) for a major pharmaceutical company. The daily ETL process was running anywhere from 16 to 24 hours or more, leaving little time for analysts (the users) to work on the system. Ultimately the redesign resulted in a load process that consistently completed in less than two hours.• Evaluation and selection of open source ETL tools to use in the redevelopment of the system (Pentaho)• Complete analysis and redesign of the existing ETL process• Implementation of the redesigned process using the newly selected ETL tool (Pentaho)• Redevelopment of PL/SQL packages to more efficiently process data• Redesigned the jobs executed by the scheduling software (Tivoli)Grocery Chain ProjectA large Canadian grocery chain required a data warehouse to collect transactional data from all of its stores. An ETL process was created (Data Stage) to populate the multi-terabyte data warehouse (Netezza) from which marketing campaigns would be generated.• Built a combination ETL/ELT process, using Data Stage as the ETL tool and SQL within the database to take advantage of the unique architecture provided by Netezza• Created production job schedules to execute the process• Worked with analyst to create test data and develop test scenarios

Travelers (Hartford CT)ETL ConsultantI provided technical leadership as part of a team responsible for implementing a multi-terabyte auto insurance data warehouse. Data are loaded into a Teradata parallel relational database.• Technical lead for the “extract” team, responsible for building several dozen business processes based on the new data warehouse, using Ab Initio (ETL) and SQL (Teradata)• Member of team developing ETL processes (Ab Initio) for one of the data warehouse feeds• Successfully designed and implemented tools (ksh93) to manage Ab Initio development environment• Designed and built tools to support SCM (branching, release) strategy• Administer the Ab Initio Enterprise Metadata Environment (EME)• Maintain relationship with Ab Initio support and account management teams to work through a variety of software issuesMerkle Data Management (Landover, MD)ETL ConsultantLead the design and implementation of the Data Hygiene and Merge/Purge components of a multi-Terabyte data warehouse, built for a leader in the credit card industry. Designed and implemented the Process Request Repository database, responsible for auditing all production processes. This distributed implementation was built across a complex of Linux and HP/UX SMP servers. Data were loaded into an Oracle 10g RAC (parallel) database.• Integrated First Logic’s Data Right IQ and ACE products to perform name and address standardization and hygiene• Implemented merge/purge strategy using the First Logic Match/Consolidate product• Built production infrastructure (Java, Perl, Ksh, Xml) to manage and audit production processes• Lead the design of the Process Control Repository used to audit all production activity• Developed SyncSort-based routines to perform pre-load data sorts and transformations• Developed bulk-load/update routines (Oracle SQLLDR) to load and refresh data into Oracle 10gi RAC (3 node/12 processor/3.5 Tb disk) data store. Developed processes to refresh indexes.

Andover, Ma, Us

Lead the team that designed and developed of all point of sale back office functionality on a web based platform.1. Time and attendance functionality2. Menu design and pricing modules3. Various back off reporting4. KPIs and dashboards5. Various other back off modulesOther miscellaneous projects and responsibilities.1. Development of various device integrations (i.e. Automated Beverage System)2. Spin up of hardware staging and assembly process3. System wide logging infrastructure4. On site system installation (hardware, cabling, etc.)

Us

Technical staff engineer responsible for design, implementation and documentation of new product features in Epsilon’s Parallel Infrastructure (EPI) C++ class library. EPI provides the database management/access layer, and run-time environment for delivering large, distributed (MPP and/or SMP) marketing information databases. Typical systems run to the tens of processors and 100s of gigabytes of data.• Designed and implemented classes for new product features including record merging and matching tasks, system monitoring and reporting facility, consolidated configuration files, performance analysis and tuning, as well as integration with PostalSoft libraries• Learned Java language semantics and design principles (first Epsilonian to use Java extensively), sharing knowledge with core development group• Developed Java messaging layer to communicate with EPI Job Server• Developed Java front ends for EPI command line tools• Co-author and taught EPI training class, co-authored EPI User’s Guide, contributed to EPI reference manual• Consulted with internal client teams and customer development teams on EPI usage, metadata specification (schema), physical database layout, both EPI and Unix system configuration

Irving, Texas, Us

Technical staff engineer responsible for design, implementation and documentation of new product features in Epsilon’s Parallel Infrastructure (EPI) C++ class library. EPI provides the database management/access layer, and run-time environment for delivering large, distributed (MPP and/or SMP) marketing information databases. Typical systems run to the tens of processors and 100s of gigabytes of data.• Designed and implemented classes for new product features including record merging and matching tasks, system monitoring and reporting facility, consolidated configuration files, performance analysis and tuning, as well as integration with PostalSoft libraries• Learned Java language semantics and design principles (first Epsilonian to use Java extensively), sharing knowledge with core development group• Developed Java messaging layer to communicate with EPI Job Server• Developed Java front ends for EPI command line tools• Co-author and taught EPI training class, co-authored EPI User’s Guide, contributed to EPI reference manual• Consulted with internal client teams and customer development teams on EPI usage, metadata specification (schema), physical database layout, both EPI and Unix system configuration

Irving, Texas, Us

Senior QA software engineer charged primarily with developing verification and validation schemes for Epsilon’s core system libraries and tools. Developed and administered Epsilon’s internal development and configuration management tools. Also responsible for instituting and executing Epsilon’s software release process. Quality Assurance• Authored test plans and procedures; project leader of quality engineers testing the feeder preprocessing and update components of a large parallel marketing database • Designed and coded tests (C++) for “core” software pieces which run on an IBM SP (AIX): parallel class library, system access layer and Epsilon query language• Designed and coded test drivers using a variety of shell languages (Perl, sh, csh) Configuration Management• Administration of the ClearCase revision control system (and Attache) on AIX, SunOS, Solaris, MS Windows and MS Windows NT• Managed the support 65+ software engineers working in ClearCase• Designed ClearCase implementation for new large-scale projects, including port from RCS• Provided in-house classes and training on ClearCase, for both software and quality engineers Software Release• Managed all internal and client software releases and product builds• Defined Epsilon’s software release policies and procedures• Developed release software (in Perl) to package multi-component software packages from ClearCase, and reliably install them on customer systems• Built makefiles (GNU), including the development of a hierarchy of make files providing a standard interface to platform dependencies (compilers, linkers, tools, etc.) and third party software components

• Provided assistance to customers in the use of SQL Server, database design and database administration• Traveled to customer sites to repair corrupt databases• Developed GUI (Motif and C) based tool to assist engineers in reproducing problems encountered by customers, by creating schemas and data sets which simulate customer databases

Cambridge, Ma, Us

• Authored test plans for an “M” database engine, networking, C API and relational database • Created integrated bug tracking and test result database (M/SQL)• Developed test harness for regression suites and reporting results to the bug tracking database• Developed unit tests (written in M and C) for the database engine, networking subsystems (TCP, UDP, sockets), and database administration tools